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.

Essential Readings: 

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

References: 

• Mastering DOS – Robbins

• Mastering Windows 98 – Robert & Cowart
• Mastering Word 2000 – Mansfield & Olsen

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

Academic Year: