Office Automation
Teacher
Asha Rani Dalai
Category
Core Courses
Course Attendees
Still no participant
Course Reviews
Still no reviews
Course Name : Office Automation
Code(Credit) : CUTM1895 (3-2-1)
Course Objectives
- Introduces the basic features of Microsoft Office, Windows basics, and file management.
- Develops familiarity with Word, Excel, Access, PowerPoint, email, and Internet basics.
Learning Outcomes
-
COs Course Outcomes Mapping COs with POs (High-3, Medium-2, Low-1) CO1 Able to gain knowledge on installation of Windows and Linux both in Physical and VM PO1 (3) CO3 Able to identify and resolve the hardware and software problem PO2(3), PO5(1) CO4 Acquire hands-on skill in hardware administration PO3 (2)
Course Syllabus
MODULE -I
Introduction to Office Automation, Creating & Editing Document, Formatting Document, Auto text, Auto correct, Spelling and Grammar Tool, Document Dictionary.
Assignment 1- Describe components of Office Automation
Assignment 2-Describe features of Office Automation.
Practice-1 Write a paragraph about your institution and Change the font size and type, Spell check, Aligning and justification of Text
MODULE -II
Page Formatting, Bookmarks, Mail Merge, Macros, Tables, File Management, Printing, Styles, linking and embedding object, Template.
Assignment 3-Describe how to create a table and insert data in that table in document
Assignment 4-How to select entire document, a paragraph, multiple line using mouse and write the shortcut key to cut, copy and paste
Assignment 5-What do you mean by mail merge? Write the step.
Assignment 6-What is change case &how can it be use?
Practice-2 Prepare a Bio-data.
Practice-3 Write a paragraph about yourself and do the following. Find and Replace - Use Numbering Bullets, Footer and Headers.
Practice-4 Create a mark sheet in word
Practice-5
Create a table in word as shown below
Roll No Name Marks in Physics Marks in Chemistry Total Marks
1 Ritu 80 70
2 Rohit 70 80
3 Amit 60 50
4 Rakesh 40 60
5 Niti 30 70
6 Garima 80 80
Do the following
(a) In the total marks column, entries should be calculated using formulas and it is the sum of marks in physics and marks in chemistry.
(b) Insert a new row at the end of the table and also find grand total using formula.
(c) Sort the table based on total marks
(d) The date and heading should be center aligned
(e) Heading should be in bold and underlined
MODULE - III
Introduction to MS-Excel, Creating & Editing Worksheet, Formatting and Essential Operations
Assignment 7 - Describe the features of MS-Excel
Practice-6 Data sorting-Ascending and Descending (both numbers and alphabets)
MODULE -IV
Formulas and Functions, Charts, Pivot table & Pivot Chart, Linking and Consolidation, Sorting, Filtering, Table, Validation, Goal Seek, Scenario.
Assignment 8 -what are the different type of function used in excel?
Assignment 9 - define pivot table .what is the need of pivot table.
Assignment 10 - A company records the details of total sales (in Rs. ) sector wise and month wise in the following format
Jan Feb March April
Sector 30 12000 17000 14000 15000
Sector 22 14000 18000 15000 16000
Sector 23 15000 19000 16000 17000
Sector 15 16000 12000 17000 18000
(a) Enter the data in a worksheet and save it as sector.xls
(b) Using appropriate formula, calculate total sale for each sector
(c) Create a 3-D column chart to show sector wise data for all four months
(d) Create a 3-D pie chart to show sales in Jan in all sectors
Practice-7 Prepare Marksheet in MS-Excel
Practice-8 Prepare Bill in MS-Excel
Practice-9 Drawing Graphs. Taking own table.
Practice-10
Enter the following data and save it in grade .xls
Name Marks1 Marks2 Marks3 Total Percentage Grade
Amit 80 70 80
Renu 70 60 90
Rajeev 60 50 80
Manish 50 30 90
Sanjeev 40 40 80
Anita 70 70 90
Do the following
(a) Compute the total marks and percentage of each student by entering appropriate formula.
(b) Compute the grades based on following criteria
If percentage >= 90 then grade = A
If percentage >= 80 and <90 then grade = B
If percentage >= 70 and <80 then grade = C
If percentage >= 60 and <70 then grade = D
If percentage < 60 then grade = E.
MODULE - V
Presentations, Creating, Manipulating & Enhancing Slides
Practice-11 Prepare Presentation by applying Formatting Tools.
MODULE -VI
Organizational Charts, Excel Charts, Word Art, Layering art Objects
Practice-12 Create a slide show presentation for a seminar.
MODULE -VII
Animations and Sounds, Inserting Animated Pictures or Accessing through Object, Inserting Recorded Sound Effect or In-Built Sound
Session Plan
Session 1
Introduction to Office Automation
Session 4
Spelling and Grammar Tool, Document Dictionary
https://www.youtube.com/watch?v=nv28u-J7TEE&list=PL7WYUFDtCahDb7QYhnwujJKBhiF8G2f6M&index=29
Session 5 (Assignment 1hrs)
Assignment 1- Describe components of Office Automation
Session 6(Assignment 1hrs)
Assignment 2-Describe features of Office Automation.
Session 7(Practice 2hrs)
Practice-1 Write a paragraph about your institution and Change the font size and type, Spell check, Aligning and justification of Text
Session 12
Printing, Style linking and embedding object, Template
Session 13(Assignment 1hrs)
Assignment 3-Describe how to create a table and insert data in that table in document
Session 14(Assignment 1hrs)
Assignment 4-How to select entire document, a paragraph, multiple line using mouse and write the shortcut key to cut, copy and paste
Session 15(Assignment 1hrs)
Assignment 5-What do you mean by mail merge? Write the step.
Session 16(Assignment 1hrs)
Assignment 6-What is change case &how can it be use?
Session 17(Practice 2hrs)
Practice-2 Prepare a Bio-data.
Session 18(Practice 2hrs)
Practice-3 Write a paragraph about yourself and do the following. Find and Replace - Use Numbering Bullets, Footer and Headers.
Session 19(Practice 2hrs)
Practice-4 Create a mark sheet in word
Session 20(Practice 2hrs)
Practice-5
Create a table in word as shown below
Roll No Name Marks in Physics Marks in Chemistry Total Marks
1 Ritu 80 70
2 Rohit 70 80
3 Amit 60 50
4 Rakesh 40 60
5 Niti 30 70
6 Garima 80 80
Do the following
(a) In the total marks column, entries should be calculated using formulas and it is the sum of marks in physics and marks in chemistry.
(b) Insert a new row at the end of the table and also find grand total using formula.
(c) Sort the table based on total marks
(d) The date and heading should be center aligned
(e) Heading should be in bold and underlined
Session 22
Creating & Editing Worksheet
https://www.youtube.com/watch?v=u2yFuy1A_9w&list=PLWPirh4EWFpEpO6NjjWLbKSCb-wx3hMql&index=19
Session 23
Session 24
Essential Operations in excel
https://www.youtube.com/watch?v=TKY_AuLMQIc&list=PLWPirh4EWFpEpO6NjjWLbKSCb-wx3hMql&index=6
Session 25(Assignment 1hrs)
Assignment 7 - Describe the features of MS-Excel
Session 26(Practice 2hrs)
Practice-6 Data sorting-Ascending and Descending (both numbers and alphabets)
Session 27
Session 28
Session 30
Session 31
Session 32
Linking and Consolidation
https://www.youtube.com/watch?v=4PWVFBiFVVU&list=PLWPirh4EWFpEpO6NjjWLbKSCb-wx3hMql&index=70
Session 33
Sorting, Filtering, Table in excel
https://www.youtube.com/watch?v=U1KRV9zJtUc&list=PLWPirh4EWFpEpO6NjjWLbKSCb-wx3hMql&index=60
Session 34
Session 35(Assignment 1hrs)
Assignment 8 -what are the different type of function used in excel?
Session 36(Assignment 2hrs)
Assignment 9 - define pivot table .what is the need of pivot table.
Session 37(Assignment 2hrs)
Assignment 10 - A company records the details of total sales (in Rs. ) sector wise and month wise in the following format
Jan Feb March April
Sector 30 12000 17000 14000 15000
Sector 22 14000 18000 15000 16000
Sector 23 15000 19000 16000 17000
Sector 15 16000 12000 17000 18000
(a) Enter the data in a worksheet and save it as sector.xls
(b) Using appropriate formula, calculate total sale for each sector
(c) Create a 3-D column chart to show sector wise data for all four months
(d) Create a 3-D pie chart to show sales in Jan in all sectors
Session 38(Practice 2hrs)
Practice-7 Prepare Marksheet in MS-Excel
Session 39(Practice 2hrs)
Practice-8 Prepare Bill in MS-Excel
Session 40(Practice 2hrs)
Practice-9 Drawing Graphs. Taking own table.
Session 41(Practice 2hrs)
Practice-10
Enter the following data and save it in grade .xls
Name Marks1 Marks2 Marks3 Total Percentage Grade
Amit 80 70 80
Renu 70 60 90
Rajeev 60 50 80
Manish 50 30 90
Sanjeev 40 40 80
Anita 70 70 90
Do the following
(a) Compute the total marks and percentage of each student by entering appropriate formula.
(b) Compute the grades based on following criteria
If percentage >= 90 then grade = A
If percentage >= 80 and <90 then grade = B
If percentage >= 70 and <80 then grade = C
If percentage >= 60 and <70 then grade = D
If percentage < 60 then grade = E.
Session 43
Creating, Manipulating & Enhancing in powerpoint
Session 44(Practice 2hrs)
Practice-11 Prepare Presentation by applying Formatting Tools.
Session 45
Session 49(Practice 2hrs)
Practice-12 Create a slide show presentation for a seminar.
Session 51
Inserting Animated Pictures or Accessing through Object
Session 52
Inserting Recorded Sound Effect or In-Built Sound Effect
Text Books:
- Microsoft Office – Complete Reference – BPB Publication
- Learn Microsoft Office – Russell A. Stultz – BPB Publication
Reference Books:
Case Studies
Case Studies
Our Main Teachers
Miss Asha Rani Dalai has received her M.Sc (Computer Science ) from Sambalpur University Institute of Information and Technology,Joyti Bihar,sambalpur,Odisha,India.Presently she is working as an Assistant Professor ,Department of Information and Technology ,School of Applied Science Centurion University of Technology and Management Bolangir campus ,Odisha,India.