|
|
510907: INFORMATION TECHNOLOGY LABORATORY
Teaching Scheme: Examination Scheme:
Practical: 4 Hrs/ Week Term Work: 50 Marks
Practical: 50 Marks
Assignment No 1:
WINDOWS 98/2000/XP/Linux: Installation, Desktop setting - new folder, rename, recycle bin
operations, briefcase function, control panel utility, Network setting, Display properties : Screen
saver, background settings, Using Command line utilities of Linux/DOS/Windows etc.
Assignment No 2:
Ms - Word: Create a document such as your resume or notes of any topic of your text book using
facilities below
Creating file: save, save as, save as HTML, save as Text, template, RTF format, Page setup
utility: Margin settings, paper size setting, paper source, layout, Editing: cut, paste, paste special,
undo, redo, find, replace, goto etc, View file: Page layout, Normal outline, master document,
ruler, header, footer, footnote, full screen, Insert: break, page number, symbol, date and time, auto
text, caption file, object, hyperlink, picture etc. Format: font, paragraph, bullets and numbering,
borders and shading, change case, columns, Tools: Spelling, merge documents, protect document,
mail merge, macro. Table: Draw label, insert table, cell handling, table auto format, sort formula,
Give password to document
Assignment No. 3
Ms-PowerPoint: Create any presentation using following facilities
Creating new slide, formatting slide, slide layout, slide show and sorter, Inserting new slide, slide
no., date, time, chart, formatting slide, tool operation, Animation, Timing, Inserting Video clips
Assignment No. 4
MS Access: Create a database for Inventory or reservation system or student information system
(with multiple tables and relation) and generate different reports
Parts of an Access Window, Tool Bars and Their Icons, Starting Microsoft Access, Creating a
New Database, Creating a Database through Table Wizard, Creating a New Table, Rename
Columns, Saving the Database, Relationships, Creating Table through Design View,
Relationship, Query, Forms, Reports, Import/export tables etc.
Assignment No. 5
Excel Basics: Create small accounting applications such as Maintaining invoices/budgets or
totaling of various transactions or Maintaining daily and monthly sales reports or any other
application using following facilities of excel
Menus, Opening of Spread Sheet, creation of cells and addressing of cells, Cell inputting,
Manipulation of cells, Enter texts numbers and dates, Creation of tables, Cell Height and Widths,
Copying of cells, Providing Formulas, Using basic functions/formalism a cell such as Sum,
average, Percentage and Other basic functions and draw graphs, import/export
Assignment No. 6
Internet:
A. Creation of New Email Account: Create your own Email account on
http://www.hotmail.com / http://yahoo.com or rediff.com and set the account preferences while
18
registration. Create your signature in hotmail account with following details: 1) Name, 2) Postal
Address, 3) Phone, 4) PRN etc.
B. Email with File Attachment: Send an email to your hotmail account with sample image file
attachment from your hotmail account. Receive this email and confirm signature appended with it
C. Outlook Express Exercise: Add your email (hotmail) account in ‘outlook express’ and
explore the settings. Create your signature in ‘outlook express’ with following details: 1) Name,
2) Postal Address, 3) Phone, 4) PRN etc.
D. MSN Messenger/ Yahoo messenger Exercise: Add your account in MSN or yahoo
Messenger and add the contacts list to your account on messenger.
E. Search the important information on search engine such as
www.google.com/www.altavista.com etc.
F: Create a group on Yahoo groups for your class ( set properties)
G: MS Front Page: Introduction, Toolbars, Commands and Their Icons, Starting MS Front Page,
Creating a Web Page without a Wizard, Creating a Web Page with a Wizard
Student should submit term work in the form of a journal consisting of minimum 12 assignments
based on the above list. Practical examination will be based on the term work. And questions will
be asked during the examination to judge the understanding of the practical performed at the time
of examination. Candidate is expected to know the theory involved in the experiment.
For more details, visit http://www.unipune.ernet.in/stud_info/Syllabi/Syllabus_2008.html
|