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