Skip to content

← Back to Advanced MS Office Lab · Launch the Lab

Chapter 8: Advanced Workshop — 60 Hands-On Practice Tasks

अध्याय 8: उन्नत कार्यशाला — 60 व्यावहारिक अभ्यास कार्य

This chapter is a complete, self-contained task guide for the Advanced MS Office Workshop — 60 hands-on production tasks spread across 12 sections (5 tasks each), covering every unit of the VOI001 syllabus: MS Word, MS Excel, MS PowerPoint, Internet & Email, and MS Access. Each task is designed to take a focused student roughly 10–15 minutes of real typing, formatting, decorating or designing work — not a multiple-choice quiz question, but an actual small deliverable you build yourself in the real application.

For every task you'll find: a short goal describing exactly what to produce, a picture of what the finished output should look like, and a numbered list of procedure hints to get you there. Nothing here replaces your own judgement — the hints tell you which commands to reach for, not the exact clicks, so there is room to explore the ribbon and find your own way to the same result.

Use the companion Advanced MS Office Workshop Booklet to record your work, paste screenshots of each completed task, and answer the quiz and viva questions for each section.

Note on translation

Chapters 0–7 of this guide are presented bilingually (English and Hindi). Given the very large volume of original task content in this chapter (60 tasks across 12 sections), it is provided in English only at this time; a Hindi translation may be added in a future revision.

WS1 Document Setup & Formatting Fundamentals

Unit 2 — MS Word, §§1.2–1.5

Five short document-formatting tasks covering typing, font/paragraph formatting, page setup and saving — the essential Word skills every later task builds on.

Try it in the Workshop Booklet

Record your work for this section — App/Tabs/Features used, your method, screenshots and results — in the Advanced MS Office Workshop Booklet.

Task 1.1 — Format a College Notice

Goal (~10–15 min): Type and format a one-page college notice announcing a workshop, with a centred bold title, a justified body paragraph, and a right-aligned date/signature block.

Expected output for Task 1.1

▶ Expected output — Task 1.1 (MS Word)

Procedure / hints:

  1. Open a new blank Word document and set the page margins to Normal (2.54 cm all sides).
  2. Type the title 'NOTICE — Workshop on Digital Literacy' and centre-align it; set font to 16 pt, Bold.
  3. Below the title, type a 3–4 sentence announcement paragraph and justify it (Ctrl+J).
  4. On a new line, right-align 'Date: _' and 'Signature: _' (Ctrl+R).
  5. Save the file as Notice_YourRollNo.docx in your workshop folder.

App, tabs & features used: Word — Home tab (Font group, Paragraph group, Alignment buttons); File > Save As

Task 1.2 — Apply Font & Paragraph Styling

Goal (~10–15 min): Take a plain, unformatted paragraph about 'Renewable Energy' and apply a Heading 1 style title, custom font colour, 1.5 line spacing, and a highlighted key term.

Expected output for Task 1.2

▶ Expected output — Task 1.2 (MS Word)

Procedure / hints:

  1. Type a heading 'Renewable Energy Sources' and apply the built-in Heading 1 style from the Styles gallery.
  2. Type or paste a 4–5 sentence paragraph below the heading.
  3. Select the paragraph and set line spacing to 1.5 (Home > Paragraph > Line Spacing).
  4. Change the heading's font colour to a theme colour of your choice.
  5. Use the Text Highlight Color tool to highlight one key technical term in the paragraph.

App, tabs & features used: Word — Home tab (Styles gallery, Font Color, Line Spacing, Text Highlight Color)

Task 1.3 — Create a Multi-Level Numbered List

Goal (~10–15 min): Build a two-level numbered agenda for a college fest, with 4 main items and 2–3 sub-items under two of them.

Expected output for Task 1.3

▶ Expected output — Task 1.3 (MS Word)

Procedure / hints:

  1. Type the title 'Annual Fest 2026 — Agenda'.
  2. Start a numbered list (Home > Numbering) and type 4 main agenda items.
  3. Place the cursor at the end of item 2, press Enter, then press Tab to demote to a sub-level; type 2 sub-items.
  4. Repeat the demotion for item 3 with 2 sub-items of its own.
  5. Adjust the multilevel list style if needed via Home > Multilevel List gallery.

App, tabs & features used: Word — Home tab (Numbering, Multilevel List, Increase/Decrease Indent)

Task 1.4 — Insert and Position an Image with Caption

Goal (~10–15 min): Insert a picture into a short report paragraph, wrap text around it, resize it proportionally, and add a numbered figure caption below it.

Expected output for Task 1.4

▶ Expected output — Task 1.4 (MS Word)

Procedure / hints:

  1. Type a 3-sentence paragraph about your college campus.
  2. Insert > Pictures and choose any image from your files.
  3. Click the picture, use Layout Options to apply 'Square' or 'Tight' text wrapping.
  4. Drag a corner handle to resize the image proportionally to about 2 inches wide.
  5. Right-click the picture > Insert Caption, and set it to read 'Fig. 1 — '.

App, tabs & features used: Word — Insert tab (Pictures); Picture Format tab (Layout Options, Size); References (Insert Caption)

Task 1.5 — Set Page Margins, Orientation & Page Numbers

Goal (~10–15 min): Format a short report's cover section: custom margins, a title block, and automatic page numbering in the footer starting from page 1.

Expected output for Task 1.5

▶ Expected output — Task 1.5 (MS Word)

Procedure / hints:

  1. Layout tab > Margins > Custom Margins; set 1 inch on all sides.
  2. Type a report title block: title, your name, roll number, date — centred.
  3. Insert > Page Number > Bottom of Page > choose a centred style.
  4. Add 2–3 more blank pages (Ctrl+Enter for page breaks) to see the numbering increment.
  5. Confirm via Print Preview that margins and page numbers appear correctly.

App, tabs & features used: Word — Layout tab (Margins); Insert tab (Page Number); File > Print (Preview)

WS2 Tables, Lists & Page Layout

Unit 2 — MS Word, §§1.9–1.11

Five tasks on building and formatting tables, headers/footers, a table of contents, and footnotes — the layout tools needed for structured reports.

Try it in the Workshop Booklet

Record your work for this section — App/Tabs/Features used, your method, screenshots and results — in the Advanced MS Office Workshop Booklet.

Task 2.1 — Create and Format a Class Timetable

Goal (~10–15 min): Build a 6-day x 6-period timetable table with merged header cells, shaded header row, and centred text in every cell.

Expected output for Task 2.1

▶ Expected output — Task 2.1 (MS Word)

Procedure / hints:

  1. Insert > Table; create a table with 7 columns and 7 rows.
  2. In row 1, type period numbers 1–6 across columns 2–7, and merge column 1 rows 1–2 for a 'Day/Period' label.
  3. Type day names (Mon–Sat) down column 1 and sample subjects into the grid.
  4. Select the header row and apply a background shade (Table Design > Shading).
  5. Select the whole table and centre-align all text both horizontally and vertically (Layout > Alignment).

App, tabs & features used: Word — Insert tab (Table); Table Design tab (Shading, Borders); Table Layout tab (Merge Cells, Alignment)

Task 2.2 — Design a Fee Structure Table

Goal (~10–15 min): Create a fee-structure table with a Total row, alternating row shading, and appropriate right-aligned currency figures.

Expected output for Task 2.2

▶ Expected output — Task 2.2 (MS Word)

Procedure / hints:

  1. Insert a table with 2 columns and 6 rows: 'Item' and 'Amount (₹)'.
  2. Fill in 4 fee items (Tuition, Library, Lab, Sports) with amounts.
  3. In the last row, type 'Total' and manually sum the amounts.
  4. Right-align all figures in the Amount column.
  5. Apply a built-in Table Style with alternating (banded) row shading from Table Design.

App, tabs & features used: Word — Insert tab (Table); Table Design tab (Table Styles, Banded Rows); Layout Alignment

Task 2.3 — Insert an Automatic Table of Contents

Goal (~10–15 min): Apply heading styles to a 4-section outline and generate an automatic, clickable Table of Contents from those headings.

Expected output for Task 2.3

▶ Expected output — Task 2.3 (MS Word)

Procedure / hints:

  1. Type 4 section headings (e.g. Introduction, Methodology, Results, Conclusion), each on its own line.
  2. Apply Heading 1 style to each, and add a short dummy paragraph under each heading.
  3. Place the cursor on a new page before the headings; go to References > Table of Contents.
  4. Choose an Automatic Table style from the gallery.
  5. Add one more heading further down, then right-click the TOC and 'Update Field' to confirm it refreshes.

App, tabs & features used: Word — Home tab (Styles: Heading 1); References tab (Table of Contents, Update Table)

Task 2.4 — Add a Running Header/Footer with Page Numbers

Goal (~10–15 min): Add a header showing the document title on every page and a footer with 'Page X of Y' style numbering.

Expected output for Task 2.4

▶ Expected output — Task 2.4 (MS Word)

Procedure / hints:

  1. Insert > Header > Edit Header; type your report title, left-aligned.
  2. Add a thin bottom border to the header text for a professional look.
  3. Insert > Footer > Edit Footer; type 'Page ' then Insert > Page Number > Current Position.
  4. Type ' of ' then Insert > Number of Pages to complete 'Page X of Y'.
  5. Close Header & Footer and scroll through multiple pages to confirm it repeats.

App, tabs & features used: Word — Insert tab (Header, Footer, Page Number); Header & Footer Tools > Design tab

Task 2.5 — Insert Footnotes for an Academic Paragraph

Goal (~10–15 min): Write a short academic-style paragraph citing two sources using Word's automatic footnote numbering.

Expected output for Task 2.5

▶ Expected output — Task 2.5 (MS Word)

Procedure / hints:

  1. Type a 3–4 sentence paragraph making two factual claims.
  2. Place the cursor right after the first claim; go to References > Insert Footnote.
  3. Type a source citation in the footnote area at the bottom of the page.
  4. Repeat for the second claim with a different source.
  5. Confirm the footnote markers (¹, ²) appear correctly in the body text and renumber automatically if you add a third.

App, tabs & features used: Word — References tab (Insert Footnote)

WS3 Mail Merge & Reference Tools

Unit 2 — MS Word, §1.12; Unit 5 — integration with Excel data

Five tasks walking through the complete mail-merge workflow end-to-end, plus hyperlinks/bookmarks and collaborative review tools.

Try it in the Workshop Booklet

Record your work for this section — App/Tabs/Features used, your method, screenshots and results — in the Advanced MS Office Workshop Booklet.

Task 3.1 — Prepare a Mail-Merge Data Source

Goal (~10–15 min): Build a small Excel table of 5 recipients (Name, Course, Fee Due) to be used as a mail-merge data source.

Expected output for Task 3.1

▶ Expected output — Task 3.1 (MS Excel)

Procedure / hints:

  1. Open Excel and create column headers: Name, Course, FeeDue, DueDate.
  2. Enter 5 rows of sample student data under the headers.
  3. Format the header row in bold with a background fill.
  4. Format the FeeDue column as Currency.
  5. Save the file as MergeData.xlsx in your workshop folder.

App, tabs & features used: Excel — Home tab (Font, Fill Color, Number Format); File > Save As

Task 3.2 — Create a Mail-Merge Letter Template

Goal (~10–15 min): Write a fee-reminder letter template in Word with merge placeholders for Name, Course and FeeDue.

Expected output for Task 3.2

▶ Expected output — Task 3.2 (MS Word)

Procedure / hints:

  1. Open a new Word document and type a formal letter body with salutation and closing.
  2. Go to Mailings > Start Mail Merge > Letters.
  3. Mailings > Select Recipients > Use an Existing List, and browse to MergeData.xlsx.
  4. Place the cursor after 'Dear' and Mailings > Insert Merge Field > Name.
  5. Insert the Course and FeeDue merge fields at the appropriate points in the letter body.

App, tabs & features used: Word — Mailings tab (Start Mail Merge, Select Recipients, Insert Merge Field)

Task 3.3 — Complete the Merge & Preview Letters

Goal (~10–15 min): Finish the mail merge, preview each personalised letter, and produce a single merged document containing all 5 letters.

Expected output for Task 3.3

▶ Expected output — Task 3.3 (MS Word)

Procedure / hints:

  1. With the template and data source connected, click Mailings > Preview Results.
  2. Use the arrow buttons to page through and check each recipient's letter looks correct.
  3. Mailings > Finish & Merge > Edit Individual Documents > All.
  4. A new document opens with all 5 personalised letters, each on its own page — scroll through to verify.
  5. Save the merged output as MergedLetters.docx.

App, tabs & features used: Word — Mailings tab (Preview Results, Finish & Merge)

Task 3.4 — Insert Hyperlinks and Bookmarks

Goal (~10–15 min): Add a clickable web hyperlink and an internal bookmark link (jump-to-section) inside a document.

Expected output for Task 3.4

▶ Expected output — Task 3.4 (MS Word)

Procedure / hints:

  1. Type a sentence mentioning your university's website; select the university name.
  2. Insert > Link > Insert Link, and type the URL; confirm the text turns blue and underlined.
  3. Scroll to a heading further down; select it and Insert > Bookmark, name it 'ContactSection'.
  4. Scroll back up, select some text, and Insert > Link > Place in This Document > choose the bookmark.
  5. Ctrl+Click both links to confirm the web link opens a browser and the bookmark link jumps down the page.

App, tabs & features used: Word — Insert tab (Link, Bookmark)

Task 3.5 — Track Changes & Add Reviewer Comments

Goal (~10–15 min): Turn on Track Changes, make a few edits to a paragraph, and add a reviewer comment — then accept/reject changes.

Expected output for Task 3.5

▶ Expected output — Task 3.5 (MS Word)

Procedure / hints:

  1. Open a paragraph of text; go to Review > Track Changes > turn it on.
  2. Delete a sentence and add a new one — note the strikethrough and coloured insertion marks.
  3. Select a phrase and Review > New Comment; type a suggestion.
  4. Go to Review > Accept > Accept All Changes for half the document, leaving the rest marked.
  5. Review > Next to step through remaining changes/comments one at a time.

App, tabs & features used: Word — Review tab (Track Changes, New Comment, Accept/Reject, Next)

WS4 Advanced Formatting & Desktop Publishing

Unit 2 — MS Word, §§1.8, 1.15

Five tasks that push Word beyond plain text formatting into desktop-publishing territory: columns, WordArt, SmartArt, watermarks and PDF export.

Try it in the Workshop Booklet

Record your work for this section — App/Tabs/Features used, your method, screenshots and results — in the Advanced MS Office Workshop Booklet.

Task 4.1 — Design a Two-Column Newsletter Layout

Goal (~10–15 min): Lay out a short campus-newsletter article in two newspaper-style columns with a column break.

Expected output for Task 4.1

▶ Expected output — Task 4.1 (MS Word)

Procedure / hints:

  1. Type a newsletter headline and a 6–8 sentence article body.
  2. Select the article body and go to Layout > Columns > Two.
  3. Position the cursor mid-article where you want the column to break, and Layout > Breaks > Column.
  4. Justify the body text for a cleaner newspaper look.
  5. Adjust column spacing via Layout > Columns > More Columns if the gap looks too tight or wide.

App, tabs & features used: Word — Layout tab (Columns, Breaks); Home tab (Justify)

Task 4.2 — Add a WordArt Headline and Drop Cap

Goal (~10–15 min): Create a decorative WordArt-style headline plus a large drop-cap first letter for an article's opening paragraph.

Expected output for Task 4.2

▶ Expected output — Task 4.2 (MS Word)

Procedure / hints:

  1. Insert > WordArt, choose a style, and type a headline such as 'CAMPUS TIMES'.
  2. Resize and position the WordArt at the top of the page.
  3. Below it, type an opening paragraph.
  4. Click inside the paragraph and go to Insert > Drop Cap > Dropped.
  5. Adjust the drop cap's font or number of lines it spans if needed (Drop Cap Options).

App, tabs & features used: Word — Insert tab (WordArt, Drop Cap)

Task 4.3 — Insert a SmartArt Process Diagram

Goal (~10–15 min): Illustrate the college's admission process as a 4-step SmartArt process diagram with short labels.

Expected output for Task 4.3

▶ Expected output — Task 4.3 (MS Word)

Procedure / hints:

  1. Insert > SmartArt > Process category, choose a basic left-to-right process layout.
  2. Type 4 short step labels (Enquiry, Apply, Interview, Admission) into the text pane.
  3. Select the SmartArt and change its colour scheme (SmartArt Design > Change Colors).
  4. Resize the SmartArt to fit neatly within the page margins.
  5. Add a one-line caption below explaining the diagram.

App, tabs & features used: Word — Insert tab (SmartArt); SmartArt Design tab (Change Colors, Layouts)

Task 4.4 — Apply a Watermark and Page Border

Goal (~10–15 min): Mark a draft report with a diagonal 'DRAFT' watermark and add a decorative page border.

Expected output for Task 4.4

▶ Expected output — Task 4.4 (MS Word)

Procedure / hints:

  1. Open or create a 1-page document with some body text.
  2. Design tab > Watermark > Custom Watermark > Text Watermark > type 'DRAFT'.
  3. Choose a light grey colour and diagonal layout, then apply.
  4. Design tab > Page Borders; choose a border style, width and colour.
  5. Apply the border to the Whole Document and confirm it doesn't overlap the text.

App, tabs & features used: Word — Design tab (Watermark, Page Borders)

Task 4.5 — Export the Finished Document to PDF

Goal (~10–15 min): Take any finished document and export/save it as a PDF, then verify the formatting is preserved.

Expected output for Task 4.5

▶ Expected output — Task 4.5 (MS Word)

Procedure / hints:

  1. Open your finished Notice or Report document from an earlier task.
  2. Go to File > Export > Create PDF/XPS Document (or File > Save As and choose PDF as the type).
  3. Choose a filename and location, keeping 'Standard' quality for print.
  4. Open the exported PDF in a PDF viewer and check fonts, images and layout all match the original.
  5. Note the PDF's file size compared to the original .docx file.

App, tabs & features used: Word — File tab (Export > Create PDF/XPS, or Save As > PDF)

WS5 Worksheet Basics, Formulas & Formatting

Unit 3 — MS Excel, §§2.2–2.4

Five tasks covering the Excel fundamentals: building a sheet, basic formulas, number formatting, absolute references, and sorting/filtering.

Try it in the Workshop Booklet

Record your work for this section — App/Tabs/Features used, your method, screenshots and results — in the Advanced MS Office Workshop Booklet.

Task 5.1 — Build a Student Marks Sheet with SUM/AVERAGE

Goal (~10–15 min): Create a 6-student marks sheet across 3 subjects, and compute each student's Total and Average using formulas.

Expected output for Task 5.1

▶ Expected output — Task 5.1 (MS Excel)

Procedure / hints:

  1. Type headers: Name, Subject1, Subject2, Subject3, Total, Average across row 1.
  2. Enter 6 rows of sample names and marks (out of 100 each).
  3. In the Total column, type =SUM(B2:D2) and fill down for all rows.
  4. In the Average column, type =AVERAGE(B2:D2) and fill down.
  5. Format the Average column to show 1 decimal place.

App, tabs & features used: Excel — Home tab (Number Format); Formulas — SUM(), AVERAGE(); fill handle

Task 5.2 — Apply Cell Formatting & Number Formats

Goal (~10–15 min): Format a small budget sheet with currency symbols, percentage figures, and clear borders/shading.

Expected output for Task 5.2

▶ Expected output — Task 5.2 (MS Excel)

Procedure / hints:

  1. Build a 4-row budget list: Item, Amount, % of Total.
  2. Select the Amount column and apply the Currency number format (₹ symbol, 0 decimals).
  3. In the % of Total column, compute each item's share and apply Percentage format.
  4. Select the whole table and apply All Borders (Home > Borders).
  5. Shade the header row with a fill colour and bold white text.

App, tabs & features used: Excel — Home tab (Number Format dropdown, Borders, Fill Color, Font)

Task 5.3 — Use Relative vs Absolute Cell References

Goal (~10–15 min): Compute each item's tax amount using a single fixed tax-rate cell, demonstrating the $ absolute-reference lock.

Expected output for Task 5.3

▶ Expected output — Task 5.3 (MS Excel)

Procedure / hints:

  1. Set up a Price column for 5 items, and a single cell (e.g. G1) containing a tax rate like 18%.
  2. In the Tax column, type =B2*$G$1 for the first row, locking the rate cell with $ signs.
  3. Fill the formula down for all 5 items and confirm every row correctly references G1.
  4. Try removing the $ signs and re-filling down to see the (incorrect) result for comparison.
  5. Restore the absolute reference and add a Total row summing the Tax column.

App, tabs & features used: Excel — Formulas (relative vs $absolute$ references); F4 key to toggle reference type

Task 5.4 — Sort and Filter a Data List

Goal (~10–15 min): Sort a list of 8 products by price, then apply a filter to show only items above a chosen price threshold.

Expected output for Task 5.4

▶ Expected output — Task 5.4 (MS Excel)

Procedure / hints:

  1. Build a list of 8 products with Name, Category and Price columns.
  2. Select the data range and Data > Sort > sort by Price, Largest to Smallest.
  3. Select the header row and Data > Filter to add dropdown filter arrows.
  4. Click the Price column's filter arrow > Number Filters > Greater Than, and enter a threshold.
  5. Confirm only matching rows remain visible, then clear the filter to restore the full list.

App, tabs & features used: Excel — Data tab (Sort, Filter, Number Filters)

Task 5.5 — Freeze Panes & Set Up Printing

Goal (~10–15 min): Freeze the header row of a 30-row sheet so it stays visible while scrolling, and configure Print Setup to fit on one page.

Expected output for Task 5.5

▶ Expected output — Task 5.5 (MS Excel)

Procedure / hints:

  1. Open or extend a sheet to about 30 data rows with a header row at the top.
  2. Click cell A2, then View > Freeze Panes > Freeze Top Row.
  3. Scroll down and confirm the header row stays fixed at the top.
  4. Go to Page Layout > Print Titles and set row 1 to repeat at the top of every printed page.
  5. Page Layout > Size and Scale to Fit > set Width to 1 page, and preview via File > Print.

App, tabs & features used: Excel — View tab (Freeze Panes); Page Layout tab (Print Titles, Scale to Fit)

WS6 Functions, Data Tools & Conditional Formatting

Unit 3 — MS Excel, §§2.5–2.7

Five tasks on logical/lookup functions, conditional formatting, data validation, and data-cleaning tools.

Try it in the Workshop Booklet

Record your work for this section — App/Tabs/Features used, your method, screenshots and results — in the Advanced MS Office Workshop Booklet.

Task 6.1 — Grade Students with IF/Nested IF

Goal (~10–15 min): Assign letter grades (A/B/C/F) to 8 students' average marks using a nested IF formula.

Expected output for Task 6.1

▶ Expected output — Task 6.1 (MS Excel)

Procedure / hints:

  1. Set up Name and Average columns for 8 students.
  2. In the Grade column, type a nested IF: =IF(B2>=90,"A",IF(B2>=75,"B",IF(B2>=50,"C","F"))).
  3. Fill the formula down for all 8 students.
  4. Test the boundary cases by editing one average to exactly 90 and one to exactly 49.
  5. Apply bold red font to any cell showing an 'F' grade.

App, tabs & features used: Excel — Formulas — IF() (nested); Home tab (Conditional font formatting)

Task 6.2 — Look Up Values with VLOOKUP/XLOOKUP

Goal (~10–15 min): Use VLOOKUP (or XLOOKUP) to pull a product's price from a lookup table based on a typed product code.

Expected output for Task 6.2

▶ Expected output — Task 6.2 (MS Excel)

Procedure / hints:

  1. Build a small lookup table: ProductCode, ProductName, Price (5 rows), placed to the side.
  2. In a separate cell, type a product code to search for.
  3. In the next cell, use =VLOOKUP(searchCell, lookupTableRange, 3, FALSE) to fetch the price.
  4. Test with a code that exists, and one that doesn't (checking the #N/A result).
  5. If your Excel version supports it, redo the same lookup using =XLOOKUP() and compare.

App, tabs & features used: Excel — Formulas — VLOOKUP() or XLOOKUP()

Task 6.3 — Apply Conditional Formatting (Data Bars/Icon Sets)

Goal (~10–15 min): Visually highlight a sales figures column using Data Bars, and flag pass/fail marks with an Icon Set.

Expected output for Task 6.3

▶ Expected output — Task 6.3 (MS Excel)

Procedure / hints:

  1. Build a Sales column with 8 numeric values.
  2. Select it and go to Home > Conditional Formatting > Data Bars, choose a colour.
  3. In a separate Marks column, apply Conditional Formatting > Icon Sets (e.g. traffic-light icons).
  4. Adjust the icon set's threshold rules via Manage Rules so the red icon means below 40.
  5. Change one value and confirm its bar/icon updates automatically.

App, tabs & features used: Excel — Home tab (Conditional Formatting: Data Bars, Icon Sets, Manage Rules)

Task 6.4 — Restrict Entries with Data Validation

Goal (~10–15 min): Create a dropdown-list data-validation rule so a 'Status' column only accepts Pending/Approved/Rejected.

Expected output for Task 6.4

▶ Expected output — Task 6.4 (MS Excel)

Procedure / hints:

  1. Type the three allowed values (Pending, Approved, Rejected) in a small side list.
  2. Select the Status column's data range; go to Data > Data Validation.
  3. Set Allow: List, and set the Source to your three-value range.
  4. Click a Status cell and confirm a dropdown arrow appears with only those 3 choices.
  5. Try typing an invalid value directly to confirm Excel rejects it with a warning.

App, tabs & features used: Excel — Data tab (Data Validation > List)

Task 6.5 — Remove Duplicates & Split Text to Columns

Goal (~10–15 min): Clean a messy student list: remove duplicate entries, then split a combined 'Name,RollNo' column into two separate columns.

Expected output for Task 6.5

▶ Expected output — Task 6.5 (MS Excel)

Procedure / hints:

  1. Build a 10-row list with 2–3 intentionally duplicated rows.
  2. Select the data and Data > Remove Duplicates; confirm the count of duplicates removed.
  3. In a new sheet/area, create a column of combined text like 'Amit Sharma,2026045'.
  4. Select that column and go to Data > Text to Columns > Delimited > comma.
  5. Confirm the name and roll number now sit in two separate, correctly labelled columns.

App, tabs & features used: Excel — Data tab (Remove Duplicates, Text to Columns)

WS7 Charts, PivotTables & Dashboards

Unit 3 — MS Excel, §§2.8–2.9

Five tasks building up from a simple chart to a full PivotTable/PivotChart mini-dashboard.

Try it in the Workshop Booklet

Record your work for this section — App/Tabs/Features used, your method, screenshots and results — in the Advanced MS Office Workshop Booklet.

Task 7.1 — Create a Column Chart from Sales Data

Goal (~10–15 min): Build a clustered column chart comparing monthly sales across 3 product categories.

Expected output for Task 7.1

▶ Expected output — Task 7.1 (MS Excel)

Procedure / hints:

  1. Build a small table: Month (rows) x 3 Category columns, 6 months of data.
  2. Select the full range including headers.
  3. Insert > Charts > Clustered Column.
  4. Add a chart title and axis titles via Chart Design > Add Chart Element.
  5. Move the chart below the data table and resize it to a readable size.

App, tabs & features used: Excel — Insert tab (Charts: Clustered Column); Chart Design tab (Add Chart Element)

Task 7.2 — Create a Trend Line Chart

Goal (~10–15 min): Plot 12 months of website visits as a line chart and add a linear trendline with displayed equation.

Expected output for Task 7.2

▶ Expected output — Task 7.2 (MS Excel)

Procedure / hints:

  1. Build a Month (1–12) x Visits table with generally increasing numbers.
  2. Select the data and Insert > Charts > Line with Markers.
  3. Right-click the data series > Add Trendline > Linear.
  4. In Trendline options, tick 'Display Equation on chart' and 'Display R-squared value'.
  5. Change the trendline's colour/style so it's clearly distinguishable from the raw data line.

App, tabs & features used: Excel — Insert tab (Line Chart); Format Trendline pane (Linear, Display Equation)

Task 7.3 — Build a PivotTable Summary

Goal (~10–15 min): Summarise a 20-row sales dataset into a PivotTable showing total sales by Region and Product.

Expected output for Task 7.3

▶ Expected output — Task 7.3 (MS Excel)

Procedure / hints:

  1. Prepare a raw data list with columns Region, Product, Sales (20 rows).
  2. Select the data and Insert > PivotTable > New Worksheet.
  3. Drag Region to Rows, Product to Columns, and Sales to Values (set to Sum).
  4. Rename the PivotTable's Values field label to 'Total Sales'.
  5. Apply a PivotTable Style from PivotTable Design for readability.

App, tabs & features used: Excel — Insert tab (PivotTable); PivotTable Fields pane; PivotTable Design tab

Task 7.4 — Build a PivotChart from the PivotTable

Goal (~10–15 min): Turn the Region x Product PivotTable into a linked PivotChart that updates when filters change.

Expected output for Task 7.4

▶ Expected output — Task 7.4 (MS Excel)

Procedure / hints:

  1. Click inside your existing PivotTable from the previous task.
  2. Go to PivotTable Analyze > PivotChart, and choose a Clustered Column chart.
  3. Use the field buttons on the chart to filter out one Region and observe the chart update live.
  4. Restore the filter, then move the PivotChart beside the PivotTable.
  5. Add a chart title summarising what it shows.

App, tabs & features used: Excel — PivotTable Analyze tab (PivotChart); Chart field buttons (interactive filters)

Task 7.5 — Assemble a One-Page Mini Dashboard

Goal (~10–15 min): Combine a KPI summary, one chart and one small table onto a single, uncluttered dashboard sheet.

Expected output for Task 7.5

▶ Expected output — Task 7.5 (MS Excel)

Procedure / hints:

  1. Create a new worksheet named 'Dashboard'.
  2. Add 2–3 large KPI number cells at the top (e.g. Total Sales, Total Orders) with bold big fonts.
  3. Paste/link your PivotChart from the previous task into the dashboard sheet.
  4. Add a small summary table alongside it.
  5. Turn off gridlines (View > Gridlines) for a cleaner, presentation-ready look.

App, tabs & features used: Excel — View tab (Gridlines); Copy/Paste Link; Home tab (large KPI fonts)

WS8 Slide Design & Content

Unit 4 — MS PowerPoint, §§3.1–3.3

Five tasks building a short presentation from a themed title slide through content, image and comparison slides.

Try it in the Workshop Booklet

Record your work for this section — App/Tabs/Features used, your method, screenshots and results — in the Advanced MS Office Workshop Booklet.

Task 8.1 — Design a Themed Title Slide

Goal (~10–15 min): Create a title slide for a 'Digital Literacy Workshop' presentation using a built-in Design theme.

Expected output for Task 8.1

▶ Expected output — Task 8.1 (MS PowerPoint)

Procedure / hints:

  1. Open a new presentation and go to Design tab; choose an appealing theme.
  2. On the title slide layout, type the main title and a subtitle line.
  3. Try 2–3 theme Variants to see different colour palettes, and pick one.
  4. Insert a small logo or icon image into a corner of the slide.
  5. Check the slide reads clearly at a glance from a few metres away (font sizes not too small).

App, tabs & features used: PowerPoint — Design tab (Themes, Variants); Insert tab (Pictures)

Task 8.2 — Create a Bulleted Content Slide with SmartArt

Goal (~10–15 min): Build a content slide listing 4 workshop objectives as bullets, then convert them to a SmartArt list graphic.

Expected output for Task 8.2

▶ Expected output — Task 8.2 (MS PowerPoint)

Procedure / hints:

  1. Add a new slide with a Title and Content layout.
  2. Type a title ('Workshop Objectives') and 4 short bullet points.
  3. Select the bulleted text box and go to Home > Convert to SmartArt.
  4. Choose a simple vertical list SmartArt style.
  5. Adjust SmartArt colours to match the slide theme.

App, tabs & features used: PowerPoint — Home tab (Bullets, Convert to SmartArt); SmartArt Design tab

Task 8.3 — Insert and Format Images/Icons

Goal (~10–15 min): Add two images/icons to a slide, apply a picture style, and align them neatly using PowerPoint's alignment guides.

Expected output for Task 8.3

▶ Expected output — Task 8.3 (MS PowerPoint)

Procedure / hints:

  1. Add a new slide with a blank or two-content layout.
  2. Insert > Pictures, add two relevant images (or Insert > Icons for simple vector icons).
  3. Select an image and apply a Picture Style (rounded corners or a frame) from Picture Format.
  4. Drag both images and use the smart alignment guides (pink lines) to align their tops.
  5. Use Home > Align > Distribute Horizontally to space them evenly.

App, tabs & features used: PowerPoint — Insert tab (Pictures, Icons); Picture Format tab (Picture Styles); Home tab (Align)

Task 8.4 — Build a Comparison Slide with a Table

Goal (~10–15 min): Design a two-column 'Before vs After' comparison slide using an inserted PowerPoint table.

Expected output for Task 8.4

▶ Expected output — Task 8.4 (MS PowerPoint)

Procedure / hints:

  1. Add a new slide with a title 'Manual vs Digital Record-Keeping'.
  2. Insert > Table, create a 2-column, 4-row table.
  3. Type contrasting points in each row (Manual side vs Digital side).
  4. Apply a Table Style with a colour scheme matching your theme.
  5. Resize the table to fill the available slide space without overlapping the title.

App, tabs & features used: PowerPoint — Insert tab (Table); Table Design tab (Table Styles)

Task 8.5 — Design an Agenda / Section-Divider Slide

Goal (~10–15 min): Create a visually distinct section-divider slide that lists the presentation's 3 upcoming sections.

Expected output for Task 8.5

▶ Expected output — Task 8.5 (MS PowerPoint)

Procedure / hints:

  1. Add a new slide and change its layout to 'Section Header' if your theme has one.
  2. Type a large section title such as 'Part 2: Spreadsheets & Data'.
  3. Below it, list the 3 upcoming sub-topics in a smaller font.
  4. Apply a contrasting background colour/fill to visually separate this slide from content slides.
  5. Duplicate this slide (Ctrl+D) to quickly create dividers for the other two parts, editing the text each time.

App, tabs & features used: PowerPoint — Layout gallery (Section Header); Design tab (background fill); Ctrl+D duplicate

WS9 Animation, Transitions & Multimedia

Unit 4 — MS PowerPoint, §§3.4–3.6

Five tasks adding motion and interactivity: transitions, entrance animations, navigation buttons, embedded media, and rehearsed timing.

Try it in the Workshop Booklet

Record your work for this section — App/Tabs/Features used, your method, screenshots and results — in the Advanced MS Office Workshop Booklet.

Task 9.1 — Apply Slide Transitions

Goal (~10–15 min): Apply a consistent transition effect across all slides of a short deck, with a controlled duration.

Expected output for Task 9.1

▶ Expected output — Task 9.1 (MS PowerPoint)

Procedure / hints:

  1. Open a presentation with at least 4 slides.
  2. Select the first slide and go to Transitions tab; choose an effect (e.g. Fade or Push).
  3. Set the transition Duration to about 0.75 seconds.
  4. Click 'Apply to All' so every slide shares the same transition.
  5. Play the slideshow (Slide Show > From Beginning) and click through to confirm the effect looks smooth.

App, tabs & features used: PowerPoint — Transitions tab (effect gallery, Duration, Apply to All)

Task 9.2 — Animate Bullet Points with Entrance Effects

Goal (~10–15 min): Animate a bulleted list so each point appears one-by-one as you click, rather than all at once.

Expected output for Task 9.2

▶ Expected output — Task 9.2 (MS PowerPoint)

Procedure / hints:

  1. Select a slide with a 4-point bulleted list.
  2. Click the text box, go to Animations tab, and choose an Entrance effect (e.g. Fly In or Fade).
  3. Open the Animation Pane (Animations > Animation Pane) to see each bullet listed as a separate step.
  4. Set each bullet's Start option to 'On Click' so they appear one at a time.
  5. Preview the animation and reorder items in the Animation Pane if any appear out of sequence.

App, tabs & features used: PowerPoint — Animations tab (Entrance effects, Animation Pane, Start: On Click)

Task 9.3 — Add Hyperlinks & Action Buttons

Goal (~10–15 min): Add clickable navigation: a hyperlink jumping to a specific slide, and an Action Button returning to the agenda.

Expected output for Task 9.3

▶ Expected output — Task 9.3 (MS PowerPoint)

Procedure / hints:

  1. On your agenda slide, select one topic's text and Insert > Link > Place in This Document, choosing the relevant slide.
  2. Navigate to that target slide; Insert > Shapes > Action Buttons > Home (or Back).
  3. Draw the button in a bottom corner; in the Action Settings dialog, set Hyperlink to 'Slide...' and pick the agenda slide.
  4. Repeat the action button on 2–3 other content slides for consistent navigation.
  5. Run the slideshow and test that both the text hyperlink and action buttons jump correctly.

App, tabs & features used: PowerPoint — Insert tab (Link, Shapes > Action Buttons); Action Settings dialog

Task 9.4 — Insert Audio/Video or Animated Icons

Goal (~10–15 min): Embed a short audio clip or video (or an animated icon) into a slide and configure its playback options.

Expected output for Task 9.4

▶ Expected output — Task 9.4 (MS PowerPoint)

Procedure / hints:

  1. Select a slide and go to Insert > Media > Audio (or Video), and choose a file from your computer.
  2. With the media object selected, go to Playback tab and set Start to 'Automatically' or 'On Click' as appropriate.
  3. Resize/reposition the media player controls so they don't block other slide content.
  4. If using video, trim it (Playback > Trim Video) to a shorter, relevant clip.
  5. Preview the slide in Slide Show mode to confirm playback works as configured.

App, tabs & features used: PowerPoint — Insert tab (Media: Audio/Video); Playback tab (Start options, Trim Video)

Task 9.5 — Rehearse Timings & Set Up the Slide Show

Goal (~10–15 min): Use Rehearse Timings to record how long each slide needs, then configure the slide show to auto-advance using those timings.

Expected output for Task 9.5

▶ Expected output — Task 9.5 (MS PowerPoint)

Procedure / hints:

  1. Go to Slide Show tab > Rehearse Timings; the presentation starts with a timer overlay.
  2. Talk through / read each slide at a natural pace, clicking to advance normally.
  3. At the end, confirm 'Yes' when asked whether to save the new slide timings.
  4. Go to Slide Show > Set Up Slide Show, and confirm 'Using timings, if present' is selected under Advance Slides.
  5. Play the show once more without clicking, confirming it now auto-advances on its own.

App, tabs & features used: PowerPoint — Slide Show tab (Rehearse Timings, Set Up Slide Show)

WS10 Internet Research & Professional Email

Unit 5 — Internet, Email & MS Access, §§4.2–4.10

Five tasks covering effective, safe web research and professional email practice.

Try it in the Workshop Booklet

Record your work for this section — App/Tabs/Features used, your method, screenshots and results — in the Advanced MS Office Workshop Booklet.

Task 10.1 — Perform an Advanced Web Search

Goal (~10–15 min): Use search operators to find 3 PDF resources about 'digital literacy' published specifically on .edu or .ac.in sites.

Expected output for Task 10.1

▶ Expected output — Task 10.1 (Internet & Email)

Procedure / hints:

  1. Open a search engine and type a plain search for 'digital literacy' first, noting how broad the results are.
  2. Refine the search using: digital literacy filetype:pdf site:edu
  3. Try a second variant using site:ac.in instead, to find Indian academic sources.
  4. Open 2–3 of the results and skim their first page to judge relevance.
  5. Record the exact search strings you used and how many results each returned.

App, tabs & features used: Browser — address/search bar; search operators (filetype:, site:)

Task 10.2 — Evaluate Website Credibility

Goal (~10–15 min): Compare two websites on the same topic and judge which is more credible using a short checklist (author, date, domain, references).

Expected output for Task 10.2

▶ Expected output — Task 10.2 (Internet & Email)

Procedure / hints:

  1. Find two different websites covering the same factual topic (e.g. a health or science claim).
  2. Check each site for a named author or organisation, and note if one is missing.
  3. Check the publish/update date on each page — is the information current?
  4. Look at the domain type (.gov/.edu/.org vs an unfamiliar .info/.xyz) and note any red flags.
  5. Write a 3–4 line judgement on which source is more trustworthy and why.

App, tabs & features used: Browser — page inspection (author byline, date, domain, footer/about page)

Task 10.3 — Compose a Professional Email with Attachment

Goal (~10–15 min): Write a formal email to a (mock) placement officer requesting an internship, with your resume attached and a proper subject line.

Expected output for Task 10.3

▶ Expected output — Task 10.3 (Internet & Email)

Procedure / hints:

  1. Open your email client and click Compose.
  2. Write a clear, specific subject line (e.g. 'Internship Application — Amit Sharma, B.Sc. Voc.').
  3. Write a 3-paragraph formal body: introduction, why you're interested, and a polite closing/call-to-action.
  4. Attach a resume file using the paperclip/Attach icon.
  5. Proofread for tone and typos before sending (or saving as draft for this exercise).

App, tabs & features used: Netmail — Compose window (Subject, Body, Attach)

Task 10.4 — Organise an Inbox with Folders & Rules

Goal (~10–15 min): Set up two folders (College, Personal) and one automatic rule that files incoming mail from a specific sender.

Expected output for Task 10.4

▶ Expected output — Task 10.4 (Internet & Email)

Procedure / hints:

  1. In your email client, create two new folders named 'College' and 'Personal'.
  2. Manually drag 2–3 existing emails into the appropriate folder to test.
  3. Open Settings/Rules and create a new rule: 'If From contains registrar@..., move to College'.
  4. Save the rule and send yourself (or simulate) a test email matching the condition.
  5. Confirm the test email lands directly in the College folder without manual sorting.

App, tabs & features used: Netmail — Folder pane (New Folder); Settings > Rules/Filters

Task 10.5 — Identify and Report a Suspicious Email

Goal (~10–15 min): Examine a simulated phishing email, list the specific red flags you notice, and use the Report/Junk button.

Expected output for Task 10.5

▶ Expected output — Task 10.5 (Internet & Email)

Procedure / hints:

  1. Open the suspicious-looking email in your inbox (or the workshop's sample).
  2. List at least 3 specific red flags: sender domain, urgency language, generic greeting, suspicious link, etc.
  3. Hover (without clicking) over any link to inspect the actual destination URL shown at the bottom of the window.
  4. Use the client's Report Phishing / Junk button rather than replying or clicking anything.
  5. Write a 2-line note on what you would tell a less experienced user about this email.

App, tabs & features used: Netmail — inspecting sender/domain and link preview; Report/Junk button

WS11 Database & Table Design

Unit 5 — Internet, Email & MS Access, §§5.3–5.7

Five tasks building a small student-records database from scratch: tables, data types, keys, relationships and validation.

Try it in the Workshop Booklet

Record your work for this section — App/Tabs/Features used, your method, screenshots and results — in the Advanced MS Office Workshop Booklet.

Task 11.1 — Design a Students Table with Correct Data Types

Goal (~10–15 min): Create a new database and a 'Students' table with 5 well-chosen fields and appropriate data types.

Expected output for Task 11.1

▶ Expected output — Task 11.1 (MS Access)

Procedure / hints:

  1. Create a new blank database and name it StudentRecords.accdb.
  2. In Design View, create a table named 'Students' with fields: RollNo, Name, Course, DOB, Email.
  3. Set RollNo to Short Text, DOB to Date/Time, and the rest to Short Text.
  4. Set RollNo as the Primary Key (right-click the row selector > Primary Key).
  5. Switch to Datasheet View and confirm the column headers and types look correct.

App, tabs & features used: Access — Table Design View (Field Name, Data Type); Design tab (Primary Key)

Task 11.2 — Enter Records via Datasheet View

Goal (~10–15 min): Populate the Students table with 8 realistic records directly in Datasheet View.

Expected output for Task 11.2

▶ Expected output — Task 11.2 (MS Access)

Procedure / hints:

  1. Switch the Students table to Datasheet View.
  2. Type 8 rows of realistic student data, one field at a time, using Tab to move across.
  3. Try leaving one required-feeling field blank to see Access's default behaviour.
  4. Use Ctrl+; to quickly insert today's date into a DOB-style test field.
  5. Resize columns (double-click the column border) so all data is visible without truncation.

App, tabs & features used: Access — Datasheet View; column resize; Ctrl+; (insert date)

Task 11.3 — Create a Second Related Table

Goal (~10–15 min): Add a 'Fees' table (RollNo, Amount, DueDate, Paid) that will later be linked to the Students table.

Expected output for Task 11.3

▶ Expected output — Task 11.3 (MS Access)

Procedure / hints:

  1. Create > Table Design; name the new table 'Fees'.
  2. Add fields: FeeID (AutoNumber, Primary Key), RollNo (Short Text), Amount (Currency), DueDate (Date/Time), Paid (Yes/No).
  3. Switch to Datasheet View and enter 6–8 rows, reusing RollNo values that exist in Students.
  4. Format the Amount column to show the Rupee symbol.
  5. Save and close the table.

App, tabs & features used: Access — Table Design View (AutoNumber, Currency, Yes/No data types)

Task 11.4 — Establish a Table Relationship

Goal (~10–15 min): Link the Students and Fees tables on RollNo, enforcing referential integrity.

Expected output for Task 11.4

▶ Expected output — Task 11.4 (MS Access)

Procedure / hints:

  1. Close all open tables, then go to Database Tools > Relationships.
  2. Add both Students and Fees tables to the Relationships window.
  3. Drag Students.RollNo onto Fees.RollNo to open the Edit Relationships dialog.
  4. Tick 'Enforce Referential Integrity' and click Create.
  5. Confirm a join line with '1' and '∞' markers now connects the two tables.

App, tabs & features used: Access — Database Tools tab (Relationships); Edit Relationships dialog (Enforce Referential Integrity)

Task 11.5 — Apply Field Validation Rules

Goal (~10–15 min): Add a Validation Rule to the Fees table's Amount field so negative or zero fee amounts are rejected.

Expected output for Task 11.5

▶ Expected output — Task 11.5 (MS Access)

Procedure / hints:

  1. Open the Fees table in Design View and click the Amount field.
  2. In the Field Properties pane, find the Validation Rule box.
  3. Type the rule: >0
  4. In Validation Text, type a friendly message: 'Fee amount must be greater than zero'.
  5. Switch to Datasheet View and try entering 0 or a negative number to confirm the rule blocks it.

App, tabs & features used: Access — Table Design View (Field Properties: Validation Rule, Validation Text)

WS12 Queries, Forms & Reports

Unit 5 — Internet, Email & MS Access, §§5.8–5.11

Five tasks turning the raw Students/Fees database into a genuinely useful application: queries, a data-entry form, a grouped report and export.

Try it in the Workshop Booklet

Record your work for this section — App/Tabs/Features used, your method, screenshots and results — in the Advanced MS Office Workshop Booklet.

Task 12.1 — Build a Select Query with Criteria

Goal (~10–15 min): Create a query listing only students whose fees remain unpaid (Paid = No).

Expected output for Task 12.1

▶ Expected output — Task 12.1 (MS Access)

Procedure / hints:

  1. Create > Query Design; add both Students and Fees tables.
  2. Drag Name, Course from Students and Amount, Paid from Fees into the grid.
  3. In the Criteria row under Paid, type: No
  4. Run the query and confirm only unpaid students appear.
  5. Save the query as 'UnpaidFees'.

App, tabs & features used: Access — Create tab (Query Design); Query Design grid (Criteria row); Run

Task 12.2 — Build a Multi-Table Join Query

Goal (~10–15 min): Create a query combining Students and Fees data to show each student's name alongside their total amount due, sorted highest first.

Expected output for Task 12.2

▶ Expected output — Task 12.2 (MS Access)

Procedure / hints:

  1. Create > Query Design; add Students and Fees (the join line should already exist from the relationship).
  2. Add Name and Course from Students, and Amount from Fees.
  3. Set the Sort row under Amount to Descending.
  4. Run the query and check the results are correctly matched and sorted.
  5. Save the query as 'FeesByStudent'.

App, tabs & features used: Access — Query Design grid (multi-table join, Sort row)

Task 12.3 — Create a Data-Entry Form

Goal (~10–15 min): Generate and lightly customise a Form for entering new Students records, instead of typing directly into the table.

Expected output for Task 12.3

▶ Expected output — Task 12.3 (MS Access)

Procedure / hints:

  1. Select the Students table, then Create > Form to auto-generate a basic form.
  2. Switch to Layout View and reposition/resize a couple of fields for a cleaner look.
  3. Add a title text box at the top reading 'New Student Registration'.
  4. Switch to Form View and use the Navigation buttons at the bottom to add one new test record.
  5. Confirm the new record also appears when you reopen the Students table.

App, tabs & features used: Access — Create tab (Form); Layout View; Form View (Navigation buttons)

Task 12.4 — Create a Grouped Fee Report

Goal (~10–15 min): Build a Report grouping the FeesByStudent query results by Course, with a subtotal for each course.

Expected output for Task 12.4

▶ Expected output — Task 12.4 (MS Access)

Procedure / hints:

  1. Select the FeesByStudent query, then Create > Report.
  2. Switch to Design View (or use the Report Wizard) and add Grouping by Course.
  3. In the Course group footer, add a Text Box with an expression summing Amount for that group.
  4. Add a Report Header with a title 'Fee Collection Summary by Course'.
  5. Switch to Print Preview and confirm subtotals and a grand total appear correctly.

App, tabs & features used: Access — Create tab (Report, Report Wizard); Report Design (Group Footer, Sum expression)

Task 12.5 — Sort, Filter & Export the Results

Goal (~10–15 min): Apply an on-the-fly sort/filter to the Students datasheet, then export the filtered results to Excel.

Expected output for Task 12.5

▶ Expected output — Task 12.5 (MS Access)

Procedure / hints:

  1. Open the Students table in Datasheet View.
  2. Click the Course column's filter arrow, and filter to show only one course.
  3. Sort the filtered list alphabetically by Name (A to Z).
  4. Go to External Data > Export > Excel, and export the filtered, sorted view.
  5. Open the exported file in Excel to confirm the data and order match what you saw in Access.

App, tabs & features used: Access — Datasheet filter/sort controls; External Data tab (Export to Excel)

Author & Maintainer: Dr. S. K. Jain, Associate Professor in Physics, Department of Applied Sciences and Humanities, Invertis University, Bareilly, India 📧 sanjeev.j@invertis.org

© 2026 Author. All rights reserved.