OFFICE AUTOMATION TOOLS

Paper Code: 
CAI 102
Credits: 
3
Periods/week: 
45
Max. Marks: 
100.00
Objective: 

 The course will familiarize the students with

  1. Knowledge of office automation tools.
  2. Hands-on skills of working over Documents, spreadsheets and presentations

 Course Outcomes (COs):

Course Outcomes

(At Course Level)

Learning And Teaching Strategies

Assessment Strategies

The Students will:

CO6. Understand the fundamental concepts of office automation tools
CO7. Learn to design spreadsheets and employ basic functions, create charts to analyse data.
CO8. Design presentation using presentation tools and enhance presentation skills
CO9. Analyze and apply the features of Office automation tools to real life problems
CO10. Implement the presentation skills using presentation advanced tools.

Learning and Teaching Strategies-

Approach in teaching:

Interactive Lectures, Discussions, student centered approach, Through video, Tutorials 

 

Learning activities: Presentations, Quizzes and Assignments

Assessment Strategies-

 

Class test, Semester end examinations, Quiz, Solving problems in tutorials,

Assignments, Presentation, Individual and group projects and peer review.

 

9.00
Unit I: 

Introduction to CLI: Concept of Operating System, Important terms in DOS (program, file, directory, names, volume label, disk drive & its name (DOS prompt) 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 (ATTRIB, BACKUP, RESTORE, FORMAT, SYS, FIND, LABEL, SORT, XCOPY, TREE, DELTREE, PRINT, MEM, DOSKEY, MOVE, MORE, CHKDSK, APPEND, DISKCOPY, DISKCOMP, MODE, UNDELETE). 

9.00
Unit II: 

 GUI: Introduction features (Desktop & its components, the window, the application window (various bars), the document window, the dialog window, the icons). Windows explorer, Control panel,       setting wallpaper, screen saver and background. Creating a folder, Copying & moving file, Scandisk, Checking & Formatting disk space, Compressing/ Zipping files (WinZip), Virus & Antivirus.

 

9.00
Unit III: 

  Introduction to Word Processor: Features of Word processors, Getting started with MS-Word, Working with formatted text, Shortcut keys. Formatting documents: Selecting text, Copying & moving   data, Formatting characters, changing cases, Paragraph formatting, Indents, Drop Caps, Using format painter, Page formatting, Header & footer, Bullets & numbering, Tabs, Forming tables, styles and templates. Finding & replacing text, Go To (F5) command, Proofing text (Spell check, Auto correct), Reversing actions, Macros, Inserting pictures, Hyperlinks, Mail merging, Printing, Getting help.

 

9.00
Unit IV: 

Introduction to Spreadsheets, workbooks, creating, saving & editing a workbook, Renaming sheet, working with single and multiple workbook cell entries (numbers, labels, and formulas), spell check, find and replace; Adding and deleting rows and columns. Filling series fill with drag, data sort, Formatting worksheet, cell referencing (Relative, Absolute, Mixed)

Some useful Functions in excel: If Function, Financial Functions: PV, NPV, IRR, Rate & FV. Date & Time: DATE, DAY, MINUTE, HOUR, NOW, SECOND. Statistical: AVERAGE, COUNT, MAX, MIN.

Text: CHAR, CONCATENATE, EXACT, LEFT, LEN, LOWER, MID, REPLACE, RIGHT, SEARCH, TEXT, TRIM, UPPER. Math & Trig: CEILING, FACT, FLOOR, INT, ROUND, SQRT, SUM.

9.00
Unit V: 

 Introduction to charts: types of charts, creation of chart from adjacent data/ nonadjacent data, printing a chart, formatting charts, label scaling etc., printing worksheet, OLE (importing & exporting  data). Hyper linking, data filters (auto & advanced), Macros.

 Introduction to Presentation Software: Uses, Presentation tips, components of slide, templates and wizards, using template, choosing an auto layout, using outlines, adding subheadings, editing text,   formatting text, using master slide. Adding slides, changing color scheme, changing background and shading, adding header and footer, adding clip arts and auto shapes. Various presentation,    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: 
  1. Courter, “Mastering Office 2000”, BPB Publications.
  2. Bill Bruck, “MS-Office 2000”, TMH.
  3. Satish Jain,” MS OFFICE 2007-TRAINING GUIDE”, BPB Publications

 

REFERENCES: 

 SUGGESTED READINGS: 

  1. Robbins, “Mastering DOS”, BPB Publications
  2. Content Development Group, “Working with MS Office 2000”, TMH
  3. Mansfield & Olsen, “Mastering Word 2000”, BPB Publications
  4. Martin, Hansen, Klingher & Beth, “Mastering Excel 2000”, BPB Publications
  5. Murray, “Mastering Power Point 2000”, BPB Publications

 

E-RESOURCES:

  1. https://www.lifewire.com/dos-commands-4070427
  2. https://hmhub.in/introduction-to-windows-in-computer-gui-feature/
  3. https://ncert.nic.in/textbook/pdf/kect104.pdf
  4. https://edu.gcfglobal.org/en/excel2013/charts/1/

 

JOURNALS:

  1. https://www.researchgate.net/publication/334054812_Boolean_Algebra_and_Logic_Gates
  2. https://www.sciencedirect.com/topics/engineering/central-processing-unit
  3. Journal of the Brazilian Computer Society, SpringerOpen
  4. Journal of Internet Services and Applications, SpringerOpen
Academic Year: 
2022-23
  • Printer-friendly version