ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Department of Computer Science (FCA) - Ganpat University
2
B.Sc. (CA&IT) Hons. - Semester I : Assignment
3
Subject : U11B3OAT : OFFICE AUTOMATION TOOLS
4
BTL1-Remember; BTL2- Understand; BTL3- Apply; BTL4-Analyze; BTL5- Evaluate; BTL6-Create;
5
Subject Teacher: Prof. C. D. Prajapati | Email ID: cdp01@ganpatuniversity.ac.in | (M) +91-9426399779
6
Unit Number Sr. No.Questions Name of COMatching Program Outcome (PO)Bloom’s Taxonomy (BTL)Practical ListMini Project / Case Studies
7
Unit 1 : Overview of DOS1What is DOS? Describe DIR command with all option.CO1PO1,PO2,PO4,PO5,PO6,PO7,PO9BTL2/4The list of practical exercises is available at the link provided below.

Students are advised to regularly complete and record the practicals in their journal upon successful completion of each task.
All practical work documented in the journal will be evaluated and verified at the end of the semester.
Students are therefore encouraged to maintain their journals in an up-to-date and organized manner throughout the semester.

Link: U11B3OAT Practicals

This is mandatory for all students.
Title: College Management System
Students are required to develop a College Management System as a case study or mini project by integrating Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Google Workspace tools.
Tasks to be Performed:
• Microsoft Word: Prepare a detailed project report.
• Microsoft Excel: Create student result analysis, charts, and summaries.
• Microsoft PowerPoint: Prepare and deliver a project presentation.
• Google Forms: Design forms for student admission, feedback, or surveys.
• Google Drive: Store, organize, and share project documents and data.
Guidelines:
• The case study must be completed by a group of 2 students only.
• The duration of the project is 3 to 4 weeks.
• After completion, each group must present their work in the classroom, demonstrating all components and tools used in the project.
• Students should ensure proper planning, documentation, and practical implementation of all tasks.
Note:
Participation in this case study is mandatory for all students and will be considered as part of the practical evaluation.
8
2Differentiate between files and directories with suitable examples.CO1PO1,PO2,PO4,PO5,PO6,PO7,PO9BTL3
9
3Demonstrate the any five internal and external commands with an example.CO1PO1,PO2,PO4,PO5,PO6,PO7,PO9BTL5
10
4Compare Internal and External DOS commands.CO1PO1,PO2,PO4,PO5,PO6,PO7,PO9BTL3
11
5Develop a simple batch file for automating repetitive tasks.CO1PO1,PO2,PO4,PO5,PO6,PO7,PO9BTL6
12
6Differentiate between CUI and GUI environments.CO1PO1,PO2,PO4,PO5,PO6,PO7,PO9BTL4
13
Unit 02 : Concept of Word7Describe the features and applications of MS Word.CO2PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL4
14
8Apply text and paragraph formatting techniques to a document.CO2PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL3
15
9Illustrate the use of Find and Replace and Spell Check tools.CO2PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL5
16
10Analyze the importance of Header, Footer, Footnote, Endnote, Drop cap, Watermark, Hyperlink.CO2PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL2
17
11Create a document using tables, charts and shapes.CO2PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL6
18
12Design a mail merge solution for sending personalized letters.CO2PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL6
19
Unit 03: Concept of Excel13What is Excel? Discuss features of MS Excel.CO3PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL2
20
14Explain spreadsheet, workbook and worksheet modes.CO3PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL5
21
15Construct charts for a given dataset and interpret results.CO3PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL3
22
16Define terms: Field, Record, Cell, Naming Range.CO3PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL2
23
17Use conditional formatting to highlight data patterns.CO3PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL3
24
18Analyze the importance of Auto Filter.CO3PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL4
25
Unit 04: Advanced Concept of Excel19Explain the purpose of Freeze Panes and worksheet splitting.CO4PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL2
26
20Apply Goal Seek to solve a numerical business problem.CO4PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL3
27
21Create and analyze a Pivot Table and Pivot Chart.CO4PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL4
28
22Demonstrate the use of Lookup and Reference functions.CO4PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL3
29
23Evaluate the use of statistical and mathematical in decision making.CO4PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL5
30
24Evaluate the use of financial and database functions in decision makingCO4PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL5
31
Unit 05: Concept of PowerPoint & Google Products25Describe the steps involved in creating a PowerPoint presentation.CO5PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL6
32
26Apply slide transitions and custom animations effectively.CO5PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL6
33
27What is MS PowerPoint? Discuss features of MS PowerPoint.CO5PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL2/3
34
28Analyze different presentation views and their applications.CO5PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL4
35
29Compare Google Docs, Sheets and Slides for collaborative work.CO5PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL3
36
30Evaluate the usefulness of Google Drive, Forms and Meet in education.CO5PO1,PO2,PO4,PO5,PO6,PO7,PO8,PO9,PO11,PO12BTL5
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100