Course Objectives: Provides Introdution about operating system with examples of DOS and UNIX .
Provides knowlwdge of apllication software Page maker .
Provides knowledge aboyt Ms Excel in details .its components and Working .
Provides relevant information about Ms-Excess and Multimedia concepts.
Provides relevant information to student about networking technology .
Module- 1 (DOS/UNIX)
(a) Disk Operating System: Introduction to operating system, How DOS works, Internal
Commands: PROMPT, CLS, DATE, TIME, DIR, REN DEL, MD, CD, RD, COPY,
TYPE, VOL, VER, PATH. External Commands: XCOPY, DELTREE, FORMAT,
CHKDSK,DISKCOPY, DISKCOMP, SCANDISK, TREE, APPEND, ATTRIB, LABEL,
(b) Unix Operating System: Introduction, History, features, simple Unix commands.
Module- 2 (Page Maker)
(a) Introduction to page maker: introduction, creating publications, setting up a new
publication, opening editing and existing publication. Typing text moving a text block,
(b) Type menu : applying a font, formatting and word processing, formatting characters,
changing borders and applying fills, graphics and text blocks, wrapping text around
graphics and drop down menus
Module- 3 (Excel)
(a) Electronic Spread sheet: Definition, History, Terminology, Features, Application and
Basics of MS-Excel: Starting MS-Excel, Components, Workbook, Worksheet, online
help. Creating a Workbook, Data Entry in a work book. Copying and moving data saving
a work book. Saving and retrieving a work book.
(b) Editing: Editing a cell, selecting range, deleting cell, column, row, worksheet. Renaming,
moving, copying and moving a worksheet. Protecting a workbook.
Formatting: Adjusting a column width, row height, hiding /unhiding rows and columns,
aligning a worksheet data. Number, currency, date formats.
Module- 4 (Excel)
(a) Functions: Types of function in MS-Excel, Syntax, Mathematical function, logical
function, date/time function. Function Wizard Formula: Entering a formula, referencing
technique, naming range, moving & copying formula.
(b) Charts: Creating Charts, Components of a chart, types of a chart, using chart wizard,
Moving and resizing charts, saving & retrieving charts.
Printing: Defining page layouts, setting header and footers, hiding gridlines, print
preview, printing a worksheet.
Module- 5 (Access)
Database: Definition, component, understanding RDBMS, basic object of a
Creating Table: Methods for creating table, setting datatypes, naming fields,
saving, closing retrieving table. Adding validation in a table.
(b) i. Modifying a Table: Rearranging fields, adding deleting, changing column width,