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
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.
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.
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.
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.
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.
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.
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.
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.