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

https://www.youtube.com/watch?v=umOSlKcyRrg

Session 2

MS-Word-Creating & Editing Document

https://www.youtube.com/watch?v=iSSug4LMXLk

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

https://www.youtube.com/watch?v=WCUyok_VmLM

Session 8

Page Formatting, Bookmarks

https://www.youtube.com/watch?v=3CZ6Ko610MI

Session 11

Session 12

Printing, Style linking and embedding object, Template

https://www.youtube.com/watch?v=CJezwpf4mCQ

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.

https://www.youtube.com/watch?v=HdtNL8D_SGE

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

https://www.youtube.com/watch?v=jOEEhPY41eM

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 21

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)

https://www.youtube.com/watch?v=kup-7HXoe2M

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

https://www.youtube.com/watch?v=hKdncHncKeg

Session 39(Practice 2hrs)

Practice-8 Prepare Bill in MS-Excel

https://www.youtube.com/watch?v=-6p1GnyyyRk

Session 40(Practice 2hrs)

Practice-9 Drawing Graphs. Taking own table.

https://www.youtube.com/watch?v=nb9V8r-FZZk

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.

https://www.youtube.com/watch?v=hKdncHncKeg

Session 42

MS-PowerPoint -Presentations

https://www.youtube.com/watch?v=0k92PUtdSFY

Session 43

Creating, Manipulating & Enhancing in powerpoint

https://www.youtube.com/watch?v=tcj2BhhCMN4

Session 44(Practice 2hrs)

Practice-11 Prepare Presentation by applying Formatting Tools.

https://www.youtube.com/watch?v=L3B4Q9R1sbw

https://www.youtube.com/watch?v=KBTvPpGmNc4

Session 46

Session 48

Session 49(Practice 2hrs)

Practice-12 Create a slide show presentation for a seminar.

Session 50

Session 51

Inserting Animated Pictures or Accessing through Object

https://www.youtube.com/watch?v=kw_udjD2xwo

Session 52

Inserting Recorded Sound Effect or In-Built Sound Effect

https://www.youtube.com/watch?v=h1tPMViAc94

Text Books: 

  1. Microsoft Office – Complete Reference – BPB Publication
  2. Learn Microsoft Office – Russell A. Stultz – BPB Publication

Reference Books:

  1. https://www.tutorialspoint.com/word/word_tutorial.pdf
  2. https://www.tutorialspoint.com/excel/index.htm
  3. https://www.tutorialspoint.com/powerpoint/powerpoint_tutorial.pdf

Case Studies

Case Studies

Our Main Teachers

Asha Rani Dalai

Assistant professor,Department of IT,SoAS,Bolangir
VIEW PROFILE

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.