RBSE VU IT and ITeS study materials
RBSE VU IT and ITeS study resources

RBSE VU IT and ITeS study plan

RBSE VU IT and ITeS · Give each week a clear focus.

8 weeks · About 6 hours per week

Week 1

Information Technology Fundamentals and Computer Systems

  • Label the internal components of a desktop computer (CPU, RAM, storage, motherboard, PSU) and state the function of each in one sentence.

  • Convert between binary, decimal, and hexadecimal for values up to 255 and show the working for five conversions.

  • Distinguish system software from application software and classify ten given programs correctly.

  • Identify five input and five output devices and match each to a realistic office task.

  • Explain the difference between volatile and non-volatile memory using two concrete examples.

Your checkpoint

A one-page labelled hardware-and-software reference sheet (hand-drawn or digital) with a 10-item classification table, self-checked with zero errors.

Week 2

ITeS Industry Overview, BPM/BPO Processes, and Service Delivery

  • Define ITeS, BPM, and BPO and write a two-sentence distinction between BPM and BPO without using the other term's wording.

  • Map the stages of a typical service-delivery lifecycle (transition, steady state, improvement) onto a real customer-support process.

  • List five common BPO service lines (e.g., voice, chat, back office, F&A, HR) and give one metric used to measure each.

  • Explain what an SLA is and draft three sample SLA clauses with a target, a measurement window, and a consequence.

  • Describe the difference between inbound and outbound processes and give one quality risk for each.

Your checkpoint

A one-page SLA excerpt plus a labelled process-flow diagram of one support process, with at least three measurable metrics named.

Week 3

Office Productivity Software (Word Processing, Spreadsheets, Presentations)

  • Format a three-page document using styles, headings, page numbers, and a table of contents that updates automatically.

  • Build a spreadsheet with at least 20 rows that uses SUM, AVERAGE, IF, and COUNTIF correctly.

  • Create a chart from spreadsheet data and label its axes, title, and legend appropriately.

  • Design a five-slide presentation with a consistent theme, one idea per slide, and speaker notes on each slide.

  • Apply print and export settings (page orientation, print area, PDF export) to a document, sheet, and deck.

Your checkpoint

A three-file portfolio set (formatted document, formula-driven spreadsheet with chart, five-slide deck exported to PDF) saved in one folder.

Week 4

Database Concepts and Data Management

  • Explain table, record, field, and primary key and design a three-table schema for a small customer-orders scenario.

  • Write SQL SELECT statements using WHERE, ORDER BY, GROUP BY, and one aggregate function.

  • Normalise a flat list of data to third normal form and state the anomaly each step removes.

  • Describe the difference between a relational database and a spreadsheet for storing transactional data, with two reasons.

  • Identify three data-quality problems (duplicates, missing values, inconsistent formats) in a sample dataset and propose a fix for each.

Your checkpoint

An ER diagram plus a query sheet containing at least six working SQL statements and a short before/after normalisation write-up.

Week 5

Internet, Web Browsing, and Email Communication

  • Explain how a URL resolves (DNS, request, response) in plain language and identify the parts of five sample URLs.

  • Compare at least four web browsers and three search operators, and use two operators to narrow a search successfully.

  • Compose five professional emails (request, follow-up, apology, escalation, closure) each with a clear subject line and a specific ask.

  • Demonstrate correct use of To, Cc, Bcc, reply-all judgement, and attachment etiquette in a written checklist.

  • Recognise three phishing indicators in sample email text and state the correct response for each.

Your checkpoint

An email etiquette checklist plus a folder of five drafted emails and a screenshot-free written record of two search-operator results.

Week 6

Communication Skills, Customer Service, and Workplace Etiquette & Digital Safety, Security, and Ethical Practices

  • Draft responses to four difficult customer scenarios (angry caller, unclear request, delay, refusal) using a acknowledge-clarify-resolve structure.

  • List five active-listening techniques and apply them in a written transcript of a simulated support call.

  • Explain confidentiality, data minimisation, and consent, and apply them to three workplace situations.

  • Identify four types of malware and three password and authentication practices that reduce risk.

  • Describe the consequences of plagiarism, software piracy, and misuse of customer data, with one prevention step for each.

Your checkpoint

A scenario-response script pack of four dialogues plus a one-page digital-safety and ethics checklist with at least ten do/don't items.

Week 7

Entrepreneurship, Employability Skills, and Career Pathways in IT/ITeS

  • Map three IT/ITeS career paths (support, data, development) to entry-level roles, typical tasks, and one skill gap each.

  • Write a one-page resume and a matching cover letter for one target entry-level role.

  • Describe three employability behaviours (punctuality, ownership, feedback) with a workplace example of each.

  • Outline a simple business idea in IT services using customer, value, cost, and revenue in one page.

  • Prepare answers to five common interview questions and rehearse them aloud once.

Your checkpoint

A career pack: one-page resume, tailored cover letter, one-page business-idea outline, and written answers to five interview questions.

Week 8

Practical Work, Project, and Portfolio Assessment & Information Technology Fundamentals and Computer Systems & ITeS Industry Overview, BPM/BPO Processes, and Service Delivery

  • Assemble a portfolio containing at least five artefacts from weeks 1-7 with a short caption explaining the skill each demonstrates.

  • Complete one timed mixed-topic practice set covering all nine domains and log the score per domain.

  • Re-teach the two weakest domains from the practice set by writing a half-page summary of each from memory.

  • Present the portfolio in a five-minute spoken walkthrough covering scope, tools used, and lessons learned.

  • Review all deliverables against the plan and close any gaps found.

Your checkpoint

A final portfolio (five or more artefacts plus captions) with a domain-score log and a written reflection of at least 150 words.

Milestones

Week 2: Can define ITeS, BPM, and BPO from memory, draw one service-delivery process flow, and state three SLA metrics without notes.

Week 4: Can write a working SQL SELECT with a WHERE clause and an aggregate from a blank screen in under five minutes, and explain 3NF in two sentences.

Week 6: Can deliver the four scenario responses aloud without reading the script, and score at least 8/10 on a self-made digital-safety and ethics quiz.

Week 8: Portfolio has five or more captioned artefacts, the mixed practice set is logged by domain, and both weakest domains are re-summarised in writing.