KEMBAR78
Syllabus | PDF | Microsoft Excel | Spreadsheet
Scribd
Upload
22 views2 pages

Syllabus

The document outlines a syllabus for an Office Automation course covering topics such as computer automation, hardware and software, Windows operating system, and Microsoft Office applications including Word, Excel, and PowerPoint. It also includes sections on storage devices, input/output devices, internet concepts, and software development. References for further reading are provided from various authors and publications.

Uploaded by

anithakannaiah8
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
22 views2 pages

Syllabus

The document outlines a syllabus for an Office Automation course covering topics such as computer automation, hardware and software, Windows operating system, and Microsoft Office applications including Word, Excel, and PowerPoint. It also includes sections on storage devices, input/output devices, internet concepts, and software development. References for further reading are provided from various authors and publications.

Uploaded by

anithakannaiah8
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Office Automation Tools

Unit
Syllabus
s

Computer Automation: Introduction to Office Automation,


1
Requirements and tools to automate the work.

Hardware and Software: Introduction, Computer Memory,


2 Secondary Memory, Computer Peripherals, Output Devices, Software
requirements

Windows Operating system: Introduction, Features, Comparison


between Professional and Home edition, Microsoft Office installation,
3
Activating Microsoft Office, Security features of Microsoft Office,
Accessing User Accounts, Getting Help

MS Word: Creating and formatting of a document, Introduction of


cut, copy and paste operations, Explore various page layout and
printing options, Creation and editing Table in MS word, Header,
4
footer, Referencing, Writing equations, Exploration of translate
feature, Introduction of word art, Graphics and print options, Mail
merge.

Microsoft Excel: Creation of spreadsheet and usage of excel,


Formatting and Editing in worksheet, Visibility : Row, Column, Sheet,
Security, Searching in Excel sheets, Basic Mathematical and
Statistical Functions using formula, Referencing worksheets,
5 Workbook, Sorting, Filtering, Validation, Consolidation, Subtotal,
What if Analysis tools: Scenario Manager, Goal Seek, Pivot Tables,
Macros, printing and additional features of worksheet, Maintaining
multiple worksheet, Protection of worksheet and workbook and
inserting graphics creating chart.

MS PowerPoint: Creation of presentation, Power point views,


Creating slides and other operations, Using design, Animation, and
6
transition in slides, Internet Tools, Using Email and Outlook facilities,
Google Drive, Google Forms, Google Spreadsheet, Google groups.

Storage Devices: Introduction, Hard Drive, CD-ROM Drive, DVD


7
Drive, Blue-Ray Disc Drive, Flash Memory Drive

Input & Output Devices: Introduction, Input Devices, Output


8
Devices

9 Computer Software: Introduction, System Software and


Application Software, Open Source Technology.

Internet: History of Internet, Concepts of Internet, How Internet


10 Works, Requirements of Internet, Uses of Internet, Internet Explorer,
Internet Applications.

Software Development, Design and Testing: Software


11 Development, Software analysis and design, Software testing,
programming methods, software applications

References:

1. Reema Thareja, Fundamental of Computer, Oxford Publications,


2014.

2. Kahate Atul, Information Technology, Tata McGraw Hill Publication,


2008

3. Joan Lambert, Curtis Frye, Microsoft Office Step by Step (Office 2021
and Microsoft 365), Microsoft Press, 2022

You might also like