Fundamentals of Computers and Office Automation

Paper Code: 
AAF 117
Credits: 
3
Contact Hours: 
45.00
Max. Marks: 
100.00
Objective: 

The objective of this course is to acquaint the students with the Fundamentals of Computers and Office Automation

10.00
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.
10.00
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.
10.00
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.
8.00
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
 
7.00
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.
References: 

Dr. Leena Bhatia & Dr. Bindu Jain, Elementary Computer Application :. Elementary Computer Application : Shubhi Lall.

Mastering DOS – Robbins

Mastering Windows 98 – Robert & CowartMastering Word 2000 – Mansfield & Olsen

Mastering Excel 2000 – Martin, Hansen, Klingher & Beth Mastering Power Point 2000 – Murray

Academic Year: