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.