Coming soon
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:
