{"id":6692,"date":"2024-04-04T10:29:58","date_gmt":"2024-04-04T10:29:58","guid":{"rendered":"https:\/\/www.inspirenignite.com\/kl\/1259-office-automation-software-lab-syllabus-for-computer-application-business-management-1st-sem-2021-revision-sitttr\/"},"modified":"2024-04-04T10:29:58","modified_gmt":"2024-04-04T10:29:58","slug":"1259-office-automation-software-lab-syllabus-for-computer-application-business-management-1st-sem-2021-revision-sitttr","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/kl\/1259-office-automation-software-lab-syllabus-for-computer-application-business-management-1st-sem-2021-revision-sitttr\/","title":{"rendered":"1259: Office Automation Software Lab Syllabus for Computer Application &amp; Business Management 1st Sem 2021 Revision SITTTR"},"content":{"rendered":"<p align=\"justify\">Office Automation Software Lab detailed syllabus for Computer Application &amp; Business Management (CB) for 2021 revision curriculum has been taken from the <a class=\"rank-math-link\" href=\"http:\/\/www.sitttrkerala.ac.in\/\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">SITTTRs<\/a> official website and presented for the Computer Application &amp; 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. <\/p>\n<p align=\"justify\">For Computer Application &amp; Business Management 1st Sem scheme and its subjects, do visit <a class=\"rank-math-link\" href=\"..\/sitttr-diploma-computer-application-business-management-cb-syllabus-for-1st-sem-2021-revision\">Computer Application &amp; Business Management (CB) 1st Sem 2021 revision scheme<\/a>. The detailed syllabus of office automation software lab is as follows. <\/p>\n<p><h4>Course Objectives:<\/h4>\n<ul>\n<li>To enable the students in crafting professional word documents; excel spread sheets, power point presentations using the Microsoft office tools.<\/li>\n<li>To be able to handle day-to-day activities at their workplace using the skills gained from this.<\/li>\n<\/ul>\n<p><h4>Course Outcomes:<\/h4>\n<p>On completion of the course, students will be able to:<\/p>\n<ol>\n<li>Use Word Processing software applications for creating documents and reports.<\/li>\n<li>Use M S Excel for creating basic spreadsheets required at business world.<\/li>\n<li>Apply the knowledge of Advanced Excel by using formulae and other data manipulation techniques to work on existing spreadsheets.<\/li>\n<li>Build presentations for general and business purpose and gain knowledge about creation of databases using MS Access<\/li>\n<\/ol>\n<p><h4>Module 1:<\/h4>\n<ol>\n<li>Create word documents as per various requirements.<\/li>\n<li>Apply the concept of Mail Merge for preparing multiple letters envelops etc.<\/li>\n<li>Develop documents with pictures tables hyperlinks and exporting in pdf format<\/li>\n<\/ol>\n<p><h4>Module 2:<\/h4>\n<ol>\n<li>Prepare Excel spreadsheets for various requirements in real and business world<\/li>\n<li>Create tables using excel adjusting rows and columns size and using data referencing between tables<\/li>\n<li>Apply the auto sum, averages, other basic formulae and perform logical calculations using conditional statements like IF<\/li>\n<\/ol>\n<p><h4>Module 3:<\/h4>\n<ol>\n<li>Prepare bar, pie and other charts and perform Look-up functions<\/li>\n<li>Perform functions like split cells, merge cells, freeze planes, conditional formatting and inserting graphics.<\/li>\n<li>Perform sorting, filtering, Pivot tables, Data protections in excel<\/li>\n<li>Prepare a basic dashboard in Excel<\/li>\n<\/ol>\n<p><h4>Module 4:<\/h4>\n<ol>\n<li>Prepare Power point presentations with charts pictures for giving business presentations.<\/li>\n<li>Creating tables using MS Access and inserting data into these tables<\/li>\n<li>Retrieving data from database using basic queries<\/li>\n<\/ol>\n<p><h4>Reference Books:<\/h4>\n<ol>\n<li>Bittu Kumar, Mastering MS Office, V&amp;S Publishers, Edition 2017<\/li>\n<li>Michael Price, Office 2019 in Easy Steps, BPB Publications, Edition2019<\/li>\n<li>Peter Weverka, Timothy L. Warner, Office 365 All-in-One For Dummies, Wiley, 2019<\/li>\n<li>Computer Course Windows 10 with MS Office 2016, BPB Publications, 2018<\/li>\n<\/ol>\n<p><h4>Online Resources<\/h4>\n<ol>\n<li>http s: \/\/ supp ort. off ce.com<\/li>\n<li>http:\/\/dlib.info\/home\/leo<\/li>\n<li>https:\/\/www.excel-easy.com\/<\/li>\n<li>https:\/\/youtu.be\/-ujVQzTtxSg<\/li>\n<li>https:\/\/www.tutorialspoint.com\/excel\/index.htm<\/li>\n<\/li>\n<\/ol>\n<p align=\"justify\">For detailed syllabus of all other subjects of Computer Application &amp; Business Management (CB), 2021 revision curriculum do visit <a class=\"rank-math-link\" href=\"..\/category\/sitttr\/cb\">Computer Application &amp; Business Management 1st Sem subject syllabuses for 2021 revision<\/a>. <\/p>\n<p align=\"justify\">To see the syllabus of all other branches of diploma 2021 revision curriculum do visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/kl\/sitttr-syllabus\/\"> SITTTR diploma all branches syllabus.<\/a>. <\/p>\n<p align=\"justify\">To see the results of Computer Application &amp; Business Management (CB) of diploma 2021 revision curriculum do visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/kl\/sitttr-results\/\"> SITTTR diploma Computer Application &amp; Business Management (CB) results.<\/a>. <\/p>\n<p align=\"justify\">For all Computer Application &amp; Business Management academic calendars, visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/kl\/sitttr-academic-calendar\/\"> Computer Application &amp; Business Management all semesters academic calendar<\/a> direct link. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Office Automation Software Lab detailed syllabus for Computer Application &amp; Business Management (CB) for 2021 revision curriculum has been taken from the SITTTRs official website and presented for the Computer [&hellip;]<\/p>\n","protected":false},"author":2462,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[32,76],"tags":[],"class_list":["post-6692","post","type-post","status-publish","format-standard","hentry","category-1st-sem","category-cb"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts\/6692","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/users\/2462"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/comments?post=6692"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts\/6692\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/media?parent=6692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/categories?post=6692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/tags?post=6692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}