PC UTILITIES LAB
| L 0 | T 0 | P 4 | | Curri. Ref. No.: CSE514 |
| Total Contact hrs : 60 Theory: 0 Tutorial: 0 Practical: 60 Pre requisite: NIL Credit: 2 | Total marks: 50 | Theory: 0 End Term Exam: 0 P.A.: 0 Practical: 50 End Term Exam: 0 P.A : 50 | ||
Practical
Total Periods: 60
Periods : 4 P/W
1. Introduction to MS Office
· Basic features of MS Office,
· Overview of different Office Tools.
2. Introduction to MS Word
· Creating and editing documents,
· Formatting documents,
· Working with tables,
· Spell checking,
· Mail merging,
· Import graphics into Word document
3. Introduction to MS Excel
· Creating a new workbook,
· Entering labels, values and formulae,
· Formatting layout,
· Working with functions,
· Creating chart from data,
· Working with macros.
4. Introduction to MS Power Point
· Creating a presentation,
· Adding / editing text,
· Working with Objects,
· Formatting the Presentation,
· Placing the Chart in slide,
· Importing Object from other tools,
· Slideshow and Printing
5. Introduction to MS Access
· Creation of Database,
· Creation of tables – Field declaration, data types declaration, constraints declaration.
· Working with records,
· Querying the database,
· Joining tables,
· Designing the Forms,
· Creating Reports.
6. Introduction to www
· Internet browsing and surfing,
· Use of Search Engine
· Email operations
RECOMMENDED LITERATURE:
1. Microsoft Office Manual
2. Online Manual on Microsoft Office and Internet.
LIST OF EQUIPMENT:
Hardware :
Standalone PC
(for detail, please refer Annex – I)
Software :
Microsoft Office 2013 / 2016
Additional Service:
Internet Connectivity
