PG DEPARTMENT OF COMPUTER SCIENCE
SUBJECT NOTES
PROGRAMME : [Link]., Computer Science
Class : II [Link]., CS
Semester : IV - Semester
Batch : 2023 - 2026
Course Name : OFFICE AUTOMATION
Course Code : 23UCSS03
Handling Staff Name : [Link]., M.C.A, [Link]., [Link].,
Student Name : ____________________________________
Register No : ____________________________________
External
Total
CIA
SEC1 OFFICE AUTOMATION Skill - - - 2 2 25 75 100
Enha. 2
Course
(SEC)
Learning Objectives
LO1 Understand the basics of computer systems and its components.
LO2 Understand and apply the basic concepts of a word processing package.
LO3 Understand and apply the basic concepts of electronic spreadsheet software.
LO4 Understand and apply the basic concepts of database management system.
LO5 Understand and create a presentation using PowerPoint tool.
UNIT Contents No. of
Hours
I Introductory concepts: Memory unit– CPU-Input Devices: Key board, Mouse
and
[Link]:Monitor,[Link]&itsfea 6
tures:DOS– UNIX–Windows. IntroductiontoProgrammingLanguages.
II Word Processing: Open, Save and close word document; Editing
text – tools, formatting, bullets;SpellChecker - Document formatting
– Paragraph alignment, indentation, headers and 6
footers,numbering;printing–Preview,options,merge.
III Spreadsheets:Excel–
opening,enteringtextanddata,formatting,navigating;Formulas–
entering,handlingand copying;Charts–creating,formatting and 6
printing,analysistables,preparationoffinancialstatements,introductiont
odataanalytics.
IV Database Concepts: The concept of data base management system;
Data field, records, and files,Sorting and indexing data; Searching
records. Designing queries, and reports; Linking of datafiles; 6
Understanding Programming environment in DBMS; Developing
menu drive applicationsinquerylanguage(MS–Access).
V Power point: Introduction to Power point - Features –
Understanding slide typecasting &viewingslides – creating slide
shows. Applying special object – including objects & pictures – 6
Slidetransition–Animationeffects,audioinclusion,timers.
Total 30
Course Outcomes Programme Outcomes
CO On completion of this course, students will
CO1 Possess the knowledge on the basics of computers
PO1,PO2,PO3,PO6,PO8
and its components
Multiple Choice Questions (MCQ)
1. Which component is responsible for storing data in a computer system?
A. CPU B. Memory Unit C. Printer D. Scanner Answer: B
2. What does CPU stand for?
A. Central Processing Unit B. Central Program Unit
C. Control Processing Unit D. Core Processing Unit Answer: A
3. Which input device is primarily used for typing?
A. Mouse B. Keyboard C. Scanner D. Monitor Answer: B
4. Which device is used to scan physical documents into a digital format?
A. Printer B. Scanner C. Monitor D. Keyboard Answer: B
5. Which output device is used for displaying visuals?
A. Monitor B. Keyboard C. Scanner D. Mouse Answer: A
6. Which of the following is an output device?
A. Mouse B. Printer C. Keyboard D. Scanner Answer: B
7. Which operating system is command-line-based?
A. DOS B. Windows C. UNIX D. macOS Answer: A
8. What is the main feature of Windows OS?
A. Command-line interface B. Graphical user interface
C. Real-time processing D. Network-based operations Answer: B
9. Which device provides a printed copy of digital documents?
A. Monitor B. Printer C. Keyboard D. Mouse Answer: B
10. What is an operating system?
A. A device used for storing data B. A program that manages hardware and software resources
C. A language for writing software programs D. An output device Answer: B
11. DOS stands for:
A. Disk Operating System B. Direct Operating System
C. Data Operating System D. Digital Operating System Answer: A
12. Which of the following is a programming language?
A. Monitor B. Python C. UNIX D. Scanner Answer: B
13. What is the main role of the CPU?
A. Data storage B. Execution of instructions
C. Document scanning D. Data visualization Answer: B
14. Which operating system supports multitasking and multi-user functionalities?
A. DOS B. UNIX C. Windows D. None of the above Answer: B
15. What is the purpose of the memory unit?
A. To execute instructions B. To store data and instructions
C. To interact with peripheral devices D. To print documents Answer: B
16. Which device is not an output device?
A. Monitor B. Mouse C. Printer D. Projector Answer: B
17. Which OS is primarily designed for desktop users?
A. UNIX B. Windows C. DOS D. Linux Answer: B
18. What is the role of programming languages?
A. Operating hardware B. Creating software applications
C. Connecting devices D. Managing memory Answer: B
19. What is the primary purpose of a mouse?
A. Typing text B. Scrolling and selecting items on the screen
C. Printing documents D. Storing data Answer: B
20. UNIX is primarily known for its:
A. Graphical interface B. Multi-user capabilities
C. Single-tasking capabilities D. Ease of use for beginners Answer: B
21. Which option is used to save a Word document?
A. Save As B. Save C. Close D. Exit Answer: B
22. Which shortcut key is used to open a new document?
A. Ctrl + S B. Ctrl + O C. Ctrl + N D. Ctrl + P Answer: C
23. What is the purpose of the Spell Checker?
A. Aligning paragraphs B. Correcting spelling errors
C. Formatting text D. Inserting a table Answer: B
24. Which tool is used to create bullet points?
A. Spell Checker B. Indentation C. Bullets Tool
D. Header/Footer Tool Answer: C
25. What does paragraph alignment mean?
A. Changing font color
B. Adjusting text position relative to page margins
C. Creating bullet points
D. Inserting page numbers Answer: B
26. Which alignment option spreads text evenly between the left and right margins?
A. Left B. Right C. Center D. Justify Answer: D
27. Which of the following is NOT an alignment option?
A. Left B. Right C. Diagonal D. Center Answer: C
28. What is the role of headers in a document?
A. Adding text at the top of the page B. Adding text at the bottom of the page
C. Changing paragraph alignment D. Adding bullet points Answer: A
29. Which feature adjusts the space between the margin and the start of text in a paragraph?
A. Indentation B. Alignment C. Headers D. Formatting Answer: A
30. What does "Print Preview" do?
A. Edits the document B. Views the document before printing
C. Saves the document D. Adds headers and footers Answer: B
31. Which menu contains the option to format text?
A. File B. Edit C. Home D. Insert Answer: C
32. Which tool is used to format a paragraph as numbered points?
A. Bullets Tool B. Numbering Tool C. Alignment Tool D. Indentation Tool Answer: B
33. Which shortcut key is used to save a Word document?
A. Ctrl + P B. Ctrl + W C. Ctrl + S D. Ctrl + C Answer: C
34. What is the purpose of indentation?
A. Adding a gap between paragraphs B. Adjusting text spacing within a line
C. Adjusting the start point of text relative to the margin
D. Changing font style Answer: C
35. How do you create headers and footers in MS Word?
A. Go to File Menu B. Use the Page Layout Tab
C. Use the Insert Tab D. Use the Home Tab Answer: C
36. What is Mail Merge used for?
A. Printing documents
B. Combining text and data to generate personalized documents
C. Formatting text D. Spell checking Answer: B
37. Which menu contains the "Print" option?
A. File B. Edit C. View D. Insert Answer: A
38. Which feature is used to apply pre-defined styles to text?
A. Font Style B. Format Painter C. Text Alignment D. Page Layout Answer: B
39. Which feature allows the addition of text at the bottom of every page?
A. Headers B. Footers C. Indentation D. Bullets Answer: B
40. Which tab contains options for printing a document?
A. Home B. Layout C. Review D. File Answer: D
41. What is the default file extension for Excel workbooks?
A. .docx B. .xlsx C. .pptx D. .txt Answer: B
42. Which tab in Excel allows you to insert charts?
A. Home B. Insert C. Data D. Review Answer: B
43. Which symbol is used to begin a formula in Excel?
A. & B. # C. = D. $ Answer: C
44. How can you quickly navigate to the last cell in a column with data?
A. Ctrl + Home B. Ctrl + End C. Ctrl + ↓ D. Ctrl + Right Arrow Answer: C
45. What is the function of the SUM formula?
A. Subtract values B. Add values C. Multiply values D. Divide values Answer: B
46. Which feature allows copying formulas to adjacent cells?
A. Autofill B. Paste Special C. Format Painter D. Data Validation Answer: A
47. Which chart type is best for showing trends over time?
A. Pie Chart B. Column Chart C. Line Chart D. Scatter Plot Answer: C
48. Which Excel formula is used to calculate the average of a range of values?
A. SUM B. AVERAGE C. MEDIAN D. MODE Answer: B
49. What is the shortcut key to open an Excel workbook?
A. Ctrl + N B. Ctrl + O C. Ctrl + S D. Ctrl + P Answer: B
50. Which tab is used to format cells in Excel?
A. Insert B. Home C. View D. Formulas Answer: B
51. What does the IF function do in Excel?
A. Performs conditional checks B. Adds values
C. Filters data D. Highlights duplicate values Answer: A
52. How do you adjust column width to fit the content?
A. Double-click the column header boundary B. Use the Format Painter tool
C. Use the Wrap Text option D. Manually drag the row border Answer: A
53. Which chart type is best for comparing parts of a whole?
A. Line Chart B. Bar Chart C. Pie Chart D. Scatter Chart Answer: C
54. What is the purpose of the VLOOKUP function?
A. To validate data B. To search for a value in a vertical range
C. To calculate vertical sums D. To find duplicates Answer: B
55. What does "cell reference" mean in Excel?
A. The location of a cell in a worksheet B. The formula used in a cell
C. The content of a cell D. The style of a cell Answer: A
56. Which Excel feature allows analyzing large datasets?
A. Pivot Table B. Filter C. Goal Seek D. Conditional Formatting Answer: A
57. How can you rename a worksheet in Excel?
A. Right-click the sheet tab and select Rename B. Double-click the cell
C. Use the Format option under the Home tab D. Use Ctrl + R Answer: A
58. What is the primary use of charts in Excel?
A. To filter data B. To visually represent data
C. To format cells D. To enter formulas Answer: B
59. Which formula is used to count the number of non-empty cells in a range?
A. COUNTA B. COUNT C. COUNTIF D. AVERAGE Answer: A
60. What does "freeze panes" do in Excel?
A. Locks specific rows or columns for scrolling B. Highlights duplicate values
C. Formats cells for printing D. Hides specific rows or columns Answer: A
61. What is the primary purpose of a Database Management System (DBMS)?
A. To create graphics B. To store and manage data
C. To write documents D. To edit images Answer: B
62. In a database, a single piece of information is called a:
A. File B. Record C. Field D. Table Answer: C
63. What is a collection of related fields called?
A. Database B. Record C. File D. Query Answer: B
64. Which SQL keyword is used to retrieve data from a database?
A. INSERT B. UPDATE C. SELECT D. DELETE Answer: C
65. What is indexing in a database used for?
A. To sort records B. To improve the speed of data retrieval
C. To delete records D. To secure data Answer: B
66. In MS Access, what is a table?
A. A design layout B. A collection of data organized in rows and columns
C. A type of chart D. A file storage tool Answer: B
67. Which tool in a DBMS allows you to search for specific records?
A. Form B. Query C. Report D. Table Answer: B
68. What is a "primary key"?
A. A field that uniquely identifies each record in a table B. A password to access the database
C. A file storage method D. A command for sorting data Answer: A
69. Which feature of a DBMS is used to link data from multiple tables?
A. Indexing B. Relationships C. Sorting D. Queries Answer: B
70. What is the purpose of designing a query in MS Access?
A. To organize data B. To fetch specific data based on criteria
C. To format the database D. To add new tables Answer: B
71. Which type of query is used to update or modify data in a table?
A. Select Query B. Update Query C. Append Query D. Delete Query Answer: B
72. In MS Access, a report is used for:
A. Editing data B. Displaying and printing data in a structured format
C. Adding data to a table D. Linking tables Answer: B
73. What does SQL stand for?
A. Standard Query Language B. Structured Query Language
C. Sequential Query Language D. System Query Language Answer: B
74. What does "sorting" data in a database mean?
A. Organizing data in ascending or descending order B. Deleting duplicate records
C. Formatting fields D. Searching for records Answer: A
75. What is a "foreign key"?
A. A key used to encrypt data B. A field in one table that links to the primary key in another table
C. A sorting tool D. A database schema Answer: B
76. What is the purpose of a menu-driven application?
A. To simplify user interaction with the database B. To update database software
C. To design reports automatically D. To sort data automatically Answer: A
77. In MS Access, how is a new relationship between tables created?
A. Using the Form tool B. Using the Relationships tool C. Using the Query tool
D. Using the Report tool Answer: B
78. Which command is used in SQL to add new data to a table?
A. INSERT B. DELETE C. SELECT D. UPDATE Answer: A
79. What is the primary purpose of reports in a DBMS?
A. To update records B. To display data in a printable format
C. To sort records D. To link tables Answer: B
80. What does MS Access primarily deal with?
A. Word processing B. Spreadsheets C. Databases D. Presentations Answer: C
81. What is PowerPoint primarily used for?
A. Database management B. Creating presentations
C. Writing documents D. Editing images Answer: B
82. What is the default file extension for PowerPoint presentations?
A. .ppt B. .pptx C. .docx D. .xlsx Answer: B
83. Which tab allows you to insert pictures, charts, and other objects in a slide?
A. Home B. Insert C. Design D. Slide Show Answer: B
84. What is a slide transition in PowerPoint?
A. A visual effect between two slides B. A type of slide layout
C. A background style D. A text formatting option Answer: A
85. Which view displays all slides in a presentation as thumbnails?
A. Normal View B. Slide Sorter View C. Slide Show View D. Notes View Answer: B
86. What is the purpose of animation effects in PowerPoint?
A. To sort slides B. To add visual effects to objects on a slide
C. To change the slide layout D. To edit text formatting Answer: B
87. What is a placeholder in PowerPoint?
A. A pre-designed slide B. A container for text, images, or other objects
C. A slide transition D. A background design Answer: B
88. Which feature is used to time slide transitions in a presentation?
A. Animation Pane B. Rehearse Timings C. Slide Sorter D. Design Tab Answer: B
89. How do you add audio to a PowerPoint slide?
A. Use the Design tab B. Use the Insert tab and select Audio
C. Use the Slide Show tab D. Use the Animation Pane Answer: B
90. What is the function of the Slide Master?
A. To create and manage consistent slide layouts B. To sort slides
C. To add animations D. To rehearse timings Answer: A
91. Which shortcut key is used to start a slide show from the beginning?
A. F5 B. Shift + F5 C. Ctrl + S D. Alt + F4 Answer: A
92. Which PowerPoint feature allows inserting moving objects or text into slides?
A. Transitions B. Animations C. Themes D. Placeholders Answer: B
93. What is the use of "Rehearse Timings" in PowerPoint?
A. To practice speaking during the presentation B. To set timing for slide transitions automatically
C. To edit slide content D. To change slide layouts Answer: B
94. Which view is primarily used for editing individual slides?
A. Slide Sorter View B. Normal View C. Reading View D. Slide Show View Answer: B
95. Which type of slide layout is commonly used for the title of a presentation?
A. Title Slide B. Content Slide C. Blank Slide D. Comparison Slide Answer: A
96. How can you apply the same animation to multiple objects in PowerPoint?
A. Copy and paste the animation settings B. Use the Animation Painter
C. Manually set the animation for each object D. Use Slide Master Answer: B
97. Which option allows you to create a slide show with specific slides?
A. Custom Slide Show B. Rehearse Timings C. Slide Sorter D. Slide Master Answer: A
98. What is the primary purpose of slide transitions?
A. To animate objects on the slide B. To add visual effects when moving from one slide to another
C. To adjust slide layouts D. To insert objects Answer: B
99. Which tab in PowerPoint is used to apply themes and backgrounds?
A. Insert B. Design C. Slide Show D. Transitions Answer: B
100. How do you print handouts for a PowerPoint presentation?
A. File → Print → Handouts B. Insert → Handouts
C. View → Handouts D. Slide Show → Handouts Answer: A
Five Mark Questions
1. Explain the basic components of a CPU and their functions.
2. Compare input devices: keyboard, mouse, and scanner.
3. Write a short note on the differences between DOS, UNIX, and Windows.
4. Discuss the key features of operating systems and their importance.
5. Describe the different types of output devices with examples.
6. Explain the steps to create, save, and close a Word document.
7. Discuss the tools and options available for text formatting, including bullet points and numbering.
8. Write a note on the importance of Spell Checker and how it improves document quality.
9. Describe the steps to add headers, footers, and page numbers to a document.
10. Explain the different types of paragraph alignment and their uses.
11. Explain the steps to open, navigate, and format a spreadsheet in Excel.
12. Write a note on creating and formatting a chart in Excel.
13. Discuss the importance of formulas in Excel and give examples of commonly used formulas (SUM,
AVERAGE, IF).
14. How do you prepare a simple financial statement (income statement or balance sheet) in Excel?
15. What are the benefits of using Excel for data analytics?
16. Explain the concept of a Database Management System (DBMS) and its main functions.
17. Describe the difference between fields, records, and files in a database.
18. What is the purpose of indexing in a database, and how does it improve performance?
19. Explain how queries are designed in MS Access to retrieve specific data.
20. Write a short note on the role and importance of reports in a database.
21. Explain the features of PowerPoint that make it a useful tool for presentations.
22. Describe the steps to add and format pictures or objects in a PowerPoint slide.
23. What are slide transitions, and how are they applied to slides?
24. Write a short note on the use of animation effects and audio inclusion in PowerPoint.
25. Explain the purpose of the Slide Master and its role in maintaining consistency in a presentation.
Ten Marks Questions
1. Describe the structure and working of the memory unit, CPU, and their interrelation.
2. Explain the functioning of different input devices (keyboard, mouse, and scanner) in detail.
3. Compare DOS, UNIX, and Windows operating systems in terms of features, advantages, and
limitations.
4. Elaborate on the role of operating systems in managing hardware and software resources.
5. Discuss the evolution of programming languages and their classifications with examples.
6. Describe in detail the process of formatting a document, including the use of bullets, numbering,
alignment, and indentation.
7. Explain the significance of headers and footers in document design and the process of creating them in
MS Word.
8. Write a detailed note on the steps and applications of Mail Merge in generating personalized
documents.
9. Discuss the printing options available in Word Processing software, including Print Preview and page
setup.
10. Elaborate on text editing tools, Spell Checker, and document formatting features with examples.
11. Describe in detail the process of creating and formatting charts in Excel, and explain their importance
in data representation.
12. Explain the use of formulas and functions in Excel, including examples like VLOOKUP, IF, and
SUM, and how they simplify data handling.
13. Write a detailed note on the creation of Pivot Tables and their role in data analysis.
14. Discuss the process of preparing financial statements in Excel, including formatting, calculations, and
use of formulas.
15. Explain how Excel is used for data analytics, including the use of features like charts, Pivot Tables,
and formulas to analyze and present data.
16. Discuss the steps involved in designing a relational database, including the use of primary keys,
foreign keys, and relationships.
17. Write a detailed note on sorting and searching data in a DBMS. Provide examples to illustrate.
18. Explain how to create a menu-driven application in MS Access. Discuss its significance in
simplifying database operations.
19. Describe the process of creating queries and reports in MS Access and explain their role in data
analysis and decision-making.
20. Discuss the features of a programming environment in a DBMS, with emphasis on creating and
managing linked data files.
21. Describe the process of creating a slide show in PowerPoint, including adding slides, objects,
animations, and transitions.
22. Explain the various slide views available in PowerPoint and their uses in creating and managing
presentations.
23. Discuss the process of including and formatting animations, slide transitions, and audio in a
PowerPoint presentation.
24. Write a detailed note on "Rehearse Timings" and its significance in professional presentations.
25. How do you design a professional presentation using themes, Slide Master, and special effects like
animations and transitions? Provide examples.