Department of Artificial Intelligence and Data Science
Academic Year 2025-2026
Model Lab Questions
Faculty Name :[Link]
Year/Sem/Sec :Ist Yr/ODD/B Sec
Subcode/Name: CS25C03-Essentials of Computing Date : 6/10/2025
Office Software (Documentation & Presentation)
1. Create a college report in a word processor with proper headings, subheadings, page
numbers, and a table of contents.
2. Design a resume using different font styles, borders, and bullet points.
3. Prepare a circular or notice for a college event using formatting tools (alignment,
indentation, and spacing).
4. Create a mail merge document for sending invitations to multiple recipients.
5. Insert and format tables, images, and charts in a Word document to represent data
neatly.
6. Design a brochure or flyer for a seminar using Word templates and SmartArt.
7. Create a PowerPoint presentation (minimum 5 slides) for any technical topic,
applying transitions and animations.
8. Develop a presentation showing the evolution and classification of computers, with
suitable visuals and slide design.
9. Demonstrate how to insert audio/video clips in a PowerPoint presentation.
10. Prepare a student mark list report and export it as a PDF document.
11. Create a PowerPoint presentation on “Applications of Artificial Intelligence” and
use Excel to analyze the growth rate of AI startups with a trendline chart.
12. Draft a meeting minutes document in Word for a company project review and link
Excel data showing project milestones and deadlines.
13. Design a poster for environmental awareness using Word/PowerPoint and use
Excel to display pollution index data across cities using a clustered column chart.
14. Prepare a college time table in Word and create an attendance monitoring sheet in
Excel using conditional formatting and percentage calculation.
Spreadsheet for Calculations & Data Visualization
11. Create a student marksheet using formulas to calculate total, average, and grade.
12. Use IF, AND, OR functions to display performance results (e.g., “Pass” or “Fail”).
13. Prepare a monthly sales report and visualize the data using a bar chart and pie
chart.
14. Demonstrate data sorting and filtering for an employee record sheet.
15. Use conditional formatting to highlight high and low values in a dataset.
16. Create a budget planner to track income and expenses using formulas and cell
references.
17. Use lookup functions (VLOOKUP / HLOOKUP) to search for data from a table.
18. Apply data validation to restrict input (e.g., allow only numeric entries).
19. Perform statistical analysis (mean, median, standard deviation) on a dataset using
spreadsheet functions.
20. Generate a chart or graph that compares product performance across multiple
months and analyze trends.
Scheme of Evaluation
Aim (Program 1&2) : 5+5
Procedure (Program 1&2) : 10+10
Output (Program 1&2) : 25+25
Result (Program 1&2) : 10
Viva : 10
Total : 100