Fundamentals of Computers and Office Automation

Paper Code: 
AAF 116
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.

Course

Learning outcome (at course level)

Learning and teaching strategies

Assessment Strategies

Paper Code

Paper Title

AAF 116

Computers and Office Automation

Upon successful completion of this course, the student will be able to:

CO 25: Evaluate the fundamental concepts of computers, econdary storage devices, and communication technology

CO 26: Develop an understanding of the concept of Operating Systems and execute internal and external commands of MS-DOS

CO 27: Analyze the fundamental concepts of office automation tools.

CO 28: Create a well-formatted document and learn the fundamentals of the word processors tool.

CO 29: Design spreadsheets and employ basic functions, create charts, perform statistical analysis.

CO 30: Make a presentation on presentation software and design effective presentations.

 

Approach in teaching:

Learning how to execute basic commands in MS-DOS Command Prompt., format documents using MS –Word, create tables and charts to analyze data using MS Excel, effective presentations using MS-PowerPoint.

Learning activities for the students:

Watching you tube videos, Working with MS-DOS Command Prompt, MS- Word, MS – Excel, MS-PowerPoint

Quizzes, Giving scenario for application of MS-DOS commands,  Practical Assignments for MS-Word, MS Excel and MS-PowerPoint.

 

 

10.00
Unit I: 
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
Unit II: 
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 & pathnames, 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
Unit III: 
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
Unit IV: 
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
Unit V: 
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
  • 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: