B.Sc. (Vocational), Semester I · 20 theory lectures (+20 lab sessions)
Reproduced from the instructor's official session-wise Lecture Plan for the 2026–27 academic session.
Note: the remaining 20 lectures of this 40-lecture course are conducted as Lab Practice sessions in the Advanced MS Office Lab.
| Lect. | Topic | Ref. | Method |
|---|---|---|---|
| 1 | L1: Introduction to MS-Word: screen layout & Ribbon; Text basics – typing, alignment; Editing text (Cut/Copy/Paste, Select All, Find & Replace) | T1, T3 | C&T, S/P, DEMO |
| 2 | L2: File operations (New, Open, Close, Save, Save As); Formatting text & paragraphs – font, line/paragraph spacing, tabs & indents | T1, T3 | C&T, S/P, DEMO |
| 3 | L3: Styles & Content – built-in/custom styles, list styles; Table of Contents & references; Footnotes and Endnotes | T1, T3 | C&T, S/P, DEMO |
| 4 | L4: Bullets & Multilevel Numbered Lists; Working with Objects – Shapes, Pictures, WordArt, SmartArt, Columns, Text Boxes, Symbols | T1, T3 | C&T, S/P, DEMO |
| 5 | L5: Working with Tables (creating, formatting, merge/split); Borders & Shading; Header & Footer with Section Breaks | T1, T3 | C&T, S/P, DEMO |
| 6 | L6: Mail Merge – recipients, merge fields, rules, finish & merge; Proofing the document; Page Setup and Printing | T1, T3 | C&T, S/P, DEMO |
| 7 | L7: Introduction to the MS-Excel environment – Workbook & Worksheet, Rows/Columns/Cells, navigating & entering data | T2, T3 | DEMO, LAB |
| 8 | L8: Formatting cells & data – number formats, wrap/merge, conditional formatting; Worksheet management, freezing panes | T2, T3 | DEMO, LAB |
| 9 | L9: Creating simple formulas; Relative, Absolute & Mixed cell referencing | T2, T3 | DEMO, LAB |
| 10 | L10: In-built functions I – SUMIF, COUNTIF, COUNTA, logical function IF, Lookup functions VLOOKUP/HLOOKUP | T2, T3 | DEMO, LAB |
| 11 | L11: In-built functions II – Financial, Statistical, Mathematical, Text, Database and Date & Time functions | T2, T3 | DEMO, LAB |
| 12 | L12: Sorting & Filtering data – number/text/custom filters; Creating Sub-totals | T2, T3 | DEMO, LAB |
| 13 | L13: Pivot Tables; Creating and formatting Charts (Column, Line, Pie) and Excel Tables | T2, T3 | DEMO, LAB |
| 14 | L14: Advanced list management – INDEX & MATCH; Forms and Form Controls; Drawing & Picture objects in Excel | T2, T3 | DEMO, LAB |
| 15 | L15: Proofing & Printing a spreadsheet – Print Area, Print Titles, Page Setup, background error checking | T2, T3 | DEMO, LAB |
| 16 | L16: Setting up the PowerPoint environment; Creating slides & applying Themes; Formatting text | T1, T3 | S/P, DEMO, LAB |
| 17 | L17: Bullets & Numbering in PPT; Working with Objects – Shapes, Pictures, WordArt, SmartArt, Slide Header/Footer | T1, T3 | S/P, DEMO, LAB |
| 18 | L18: Hyperlinks & Action Buttons; Working with Movies and Sound (audio/video playback options) | T1, T3 | S/P, DEMO, LAB |
| 19 | L19: Tables & SmartArt in PowerPoint; Animation and Slide Transition | T1, T3 | S/P, DEMO, LAB |
| 20 | L20: Slide Show options (Rehearse Timings, Custom Slide Show); Proofing & Printing; Save as Video/JPEG/Show file | T1, T3 | S/P, DEMO, LAB |
Teaching Methods: C&T: Chalk & Talk; S/P: Slides/PPT & Videos; SEM: Seminar; DEMO: Demonstration; CHART; ET/GL: Expert Talk/Guest Lecture; QUIZ; GD: Group Discussion; RTCS: Real Time Case Studies; JAR: Journal Article Review; PD: Poster Design; LAB: Laboratory demonstration.
Faculty Course Portal · 2026–27