WBCHSE HS Vocational IT & ITeS study plan

Set up a practice folder structure and install or confirm access to a word processor, spreadsheet and presentation tool you will use for all eight weeks.

Build a 2-page formatted Word-style document with headings, bulleted lists, a table, page numbers, header/footer and at least three paragraph styles, then save it as both DOCX and PDF.

Label the main internal components (CPU, RAM, storage, motherboard, PSU, ports) on a hand-drawn or typed diagram and write one sentence on what each does.

Demonstrate and record the steps for creating, renaming, moving, copying and deleting files and folders, plus one backup to a second location.

Explain in writing the difference between RAM and ROM, and between HDD and SSD, in under 150 words.

Build a spreadsheet with at least 40 rows of sample data, using formulas for SUM, AVERAGE, COUNT, MIN, MAX, IF and one lookup function.

Apply sorting, filtering, cell formatting, number formats, borders and a simple chart to that spreadsheet.

Create a 6-slide presentation on 'Types of Computers' with a title slide, consistent theme, speaker notes on every slide and one image or shape.

Practise the OS skills listed in a checklist: creating a user account concept, changing display settings, using Task Manager or equivalent, and compressing a folder into a ZIP file.

Write a 10-line comparison of common operating systems (Windows, Linux, Android) covering interface, cost and typical use.

Produce a mail-merge letter from a spreadsheet of 10 contacts, including merged name and address fields, and print-preview the result.

Add a table of contents, captions and a hyperlink to an existing document, and export it as PDF.

Explain in writing how a URL resolves: browser, DNS, IP address, HTTP request, server response, rendered page.

List and describe at least six browser features or settings (bookmarks, history, downloads, cookies, private mode, extensions) and where to find them.

Send a properly structured email with a subject line, greeting, body, signature and one attachment, and save a copy of the text.

Create a small relational database with two tables, a primary key, a foreign key and at least 15 records, then run 5 queries including one filter and one sort.

Define and give an example of table, record, field, primary key, foreign key and data redundancy.

Compare flat-file and relational storage in a short written note with one advantage and one limitation of each.

Perform a timed data-entry drill: enter 60 records accurately in 15 minutes and record your error count.

Describe three web communication tools (email, instant messaging, video conferencing) and one appropriate business use for each.

Clean a messy dataset of 50 rows: remove duplicates, standardise date and name formats, and document each correction you made.

Write the steps for importing a CSV file into a spreadsheet or database and verify the imported record count.

Explain BPO and KPO in writing, with two examples of work typically outsourced in each and one reason a company outsources.

Map a simple order-handling process as a 6-step flowchart and mark where a data-entry error could cause a customer problem.

List five common service-level expectations in a BPO process (accuracy, turnaround time, response time, escalation, confidentiality) and state how each is measured.

Write and rehearse two customer email replies: one answering a routine query and one handling a complaint, each under 150 words and in a polite, factual tone.

Role-play a 3-minute phone call handling an upset customer, and note where you used listening, paraphrasing and an apology without admitting fault incorrectly.

List five active-listening techniques and give one sentence of sample dialogue for each.

Explain the difference between passive, aggressive and assertive communication with one workplace example of each.

Draft a short escalation note to a supervisor summarising a customer issue in five lines: issue, impact, action taken, current status, request.

List eight cyber-safety practices (strong passwords, two-factor authentication, updates, phishing awareness, safe browsing, backups, locking devices, verifying links) and state the risk each reduces.

Identify the tell-tale signs of a phishing email in a sample you write yourself, marking at least five red flags.

Explain data privacy in writing: what personal data is, why consent matters, and three duties of an organisation that holds customer data.

Describe three IT-enabled services (for example e-governance, online banking, e-learning) and one benefit and one risk of each.

Write a short acceptable-use note covering password sharing, personal use of office systems and reporting a security incident.

Assemble a project folder containing your best document, spreadsheet, presentation, database and cleaned dataset, each named clearly.

Write a 300-word project report covering what you built, which tools you used, one problem you hit and how you solved it.

Rehearse and record a 5-minute viva answers set: introduce the project, explain two technical choices, and answer three likely examiner questions.

Take one timed full-length practice paper under exam conditions and mark it, listing your three weakest areas.

Revise those three weakest areas for 90 minutes and write a one-page summary sheet of key definitions from all nine domains.