Office Automation Software Lab detailed syllabus for Computer Application & Business Management (CB) for 2021 revision curriculum has been taken from the SITTTRs official website and presented for the Computer Application & Business Management students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.
For Computer Application & Business Management 1st Sem scheme and its subjects, do visit Computer Application & Business Management (CB) 1st Sem 2021 revision scheme. The detailed syllabus of office automation software lab is as follows.
Course Objectives:
- To enable the students in crafting professional word documents; excel spread sheets, power point presentations using the Microsoft office tools.
- To be able to handle day-to-day activities at their workplace using the skills gained from this.
Course Outcomes:
On completion of the course, students will be able to:
- Use Word Processing software applications for creating documents and reports.
- Use M S Excel for creating basic spreadsheets required at business world.
- Apply the knowledge of Advanced Excel by using formulae and other data manipulation techniques to work on existing spreadsheets.
- Build presentations for general and business purpose and gain knowledge about creation of databases using MS Access
Module 1:
- Create word documents as per various requirements.
- Apply the concept of Mail Merge for preparing multiple letters envelops etc.
- Develop documents with pictures tables hyperlinks and exporting in pdf format
Module 2:
- Prepare Excel spreadsheets for various requirements in real and business world
- Create tables using excel adjusting rows and columns size and using data referencing between tables
- Apply the auto sum, averages, other basic formulae and perform logical calculations using conditional statements like IF
Module 3:
- Prepare bar, pie and other charts and perform Look-up functions
- Perform functions like split cells, merge cells, freeze planes, conditional formatting and inserting graphics.
- Perform sorting, filtering, Pivot tables, Data protections in excel
- Prepare a basic dashboard in Excel
Module 4:
- Prepare Power point presentations with charts pictures for giving business presentations.
- Creating tables using MS Access and inserting data into these tables
- Retrieving data from database using basic queries
Reference Books:
- Bittu Kumar, Mastering MS Office, V&S Publishers, Edition 2017
- Michael Price, Office 2019 in Easy Steps, BPB Publications, Edition2019
- Peter Weverka, Timothy L. Warner, Office 365 All-in-One For Dummies, Wiley, 2019
- Computer Course Windows 10 with MS Office 2016, BPB Publications, 2018
Online Resources
- http s: // supp ort. off ce.com
- http://dlib.info/home/leo
- https://www.excel-easy.com/
- https://youtu.be/-ujVQzTtxSg
- https://www.tutorialspoint.com/excel/index.htm
For detailed syllabus of all other subjects of Computer Application & Business Management (CB), 2021 revision curriculum do visit Computer Application & Business Management 1st Sem subject syllabuses for 2021 revision.
To see the syllabus of all other branches of diploma 2021 revision curriculum do visit SITTTR diploma all branches syllabus..
To see the results of Computer Application & Business Management (CB) of diploma 2021 revision curriculum do visit SITTTR diploma Computer Application & Business Management (CB) results..
For all Computer Application & Business Management academic calendars, visit Computer Application & Business Management all semesters academic calendar direct link.