Fundamentals of Computers and Office Automation

Anatomy  of  Computer:  Introduction  to  Computers  (definition,

characteristics & uses), System unit (memory, ALU & control unit),

Input  /  Output  devices,  Storage  devices  (Memory-  primary  &

secondary).

Computer  Software:  Introduction  to  Software,  its  type  (system,

application& utility).

Communication Technology: Data communication, Data Transmission

medium (modem),

Communication Channels- transmission medium(twisted pair, coaxial &

fiber optic cables), Computer and networks, Need for networking,

components of network,), HTTP, Web Browser, Introduction to internet,

Uses of internet, E-mail, Sending Email, Attaching files with E-mail.

Introduction to DOS: Concept of Operating System, Introduction to

DOS, Important terms in DOS (program, file, directory, names, volume

label, disk drive & its name(MS-DOS prompt)

DOS File System & Various Commands: Dos file system, path & path

names, internal commands (dir, cd, md, rd, copy, del, ren, date, time,

ver, vol, cls, type, prompt, path) and external commands

Introduction to MS-Windows: Introduction, features (Desktop & its

components, the window, the application window (various bars), the

document window, the dialog window, the icons)

Exploring the Windows: Windows explorer, Control panel, Setting

wallpaper, screen saver, background.

Managing Files & Folders: Creating a folder, Scandisk, Checking &

Formatting disk space, Compressing / Zipping files (WinZip), Virus &

Antivirus.

Introduction to MS-Word: Introduction to word processing, Features of

Word processors, Getting started with MS-Word, Working with word

documents,

Quitting word, Shortcut keys.

Formatting documents: Formatting documents, Selecting text,

Formatting characters, Changing cases, Paragraph formatting, Indents,

Using

format painter, Page formatting, Header & footer, Bullets & numbering,

Tabs, Forming tables.

Editing Text: Finding & replacing text, Go To (5) command, Proofing

text (Spell check, Auto correct), Reversing actions, Macros, Inserting

pictures, Hyperlinks, Mail merging, Printing, Getting Help.

Excel Basics: Introduction, spreadsheet, workbooks, saving a file,

opening  an  existing  worksheet,  Rows  and  columns,  cell  entries

(numbers, labels, formulas), spell check, find and replace, Adding and

deleting rows and columns.

Various Tools & functions: Filling series, fill with drag, data sort,

Formatting worksheet, Functions and its parts.

Some useful Functions in excel (SUM, AVERAGE, COUNT, MAX,

MIN,  IF),  What-if  analysis,  cell  referencing  (Relative,  Absolute,

Mixed), Renaming sheet, Printing worksheet.

Charts in Excel: Introduction to charts, types of charts, creation of chart

from adjacent data / nonadjacent data, printing a worksheet and chart

Power Point Basics: Introduction, Use of power point, starting power

point, Presentation tips, components of slide, power point templates and

wizards, using template, choosing an auto layout, using outlines, adding

subheadings, editing text, formatting text, using master slide.

Tools in Power Point: Creating presentation using blank presentation,

adding slides, changing colour  scheme, changing background and

shading, adding header and footer, adding clip arts and autoshapes,

components used for reference

Advanced Power Point tools: Various Power point views, Working in

slide sorter view (deleting, duplicating, rearranging slides), adding

transition and animations to slide show, inserting music or sound on a

slide, Inserting action buttons or hyperlinks for a presentation, set and

rehearse slide timings, viewing slide show, Printing slides.