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