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 Outcome (COs):

Course

Learning outcome (at course level)

Learning and teaching strategies

Assessment Strategies

Paper Code

Paper Title

AAF 116

Computers and Office Automation

CO 25: Learn the fundamental concepts of computers , secondary storage devices and communication technology

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

CO 27: Understand the fundamental concepts of office automation tools

CO 28: Learn the fundamentals of word processors tool and be able to create well formatted documents.

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

CO 30: Make presentation on presentation software and design an 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 & 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
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.
References: 
  • 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: 
2020-2021
  • Printer-friendly version
  • PDF version