Vocational Group: Office, Spreadsheet, Web and E-Commerce Skills
What this domain tests
The Vocational Group syllabus tests employable computer application skills: office automation, spreadsheet accounting, desktop publishing, web page design, e-commerce and digital payments, and cyber safety. Questions are task-based and reward exact procedures rather than general definitions.
Core rules to keep straight
- Word processing: use heading styles for structure; mail merge combines a main document with a data source, so verify fields before merging.
- Spreadsheet functions: =SUM(B2:B10), =AVERAGE(B2:B10), =IF(condition, true_value, false_value). Use absolute references for fixed rates such as tax or discount.
- DTP: distinguish margins, bleed, resolution and colour mode; vector graphics scale without pixelation, raster images do not.
- HTML: use html, head and body structure; heading tags h1–h6; links with href; images with alt text; close elements correctly.
- E-commerce: an invoice carries seller details, GSTIN, item description, quantity, rate and tax; payment gateways must never ask for card PIN or OTP in chat.
Worked example
A worksheet stores quantity in B2, rate in C2 and a discount rate in E1 (10%). The formula =B2C2(1-$E$1) gives 42500.90 = 900 when B2=4 and C2=250. The $E$1 lock is essential: copying the formula down keeps the discount cell fixed, while a relative E1 would shift to E2 and break the calculation.
Traps that cost marks
- Entering numbers with spaces or commas so the spreadsheet stores them as text and SUM ignores them.
- Using a relative reference for a fixed tax or discount rate.
- Running mail merge without refreshing or checking the data source.
- Leaving HTML tags unclosed or attributes unquoted.
- Sharing OTP, PIN or CVV in digital payment tasks.