RBSE Sec Voc IT and ITeS study materials
RBSE Sec Voc IT and ITeS study resources

RBSE Sec Voc IT and ITeS study plan

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

8 weeks · About 7 hours per week

Week 1

Fundamentals of Information Technology and Computer Systems

  • Label the internal and external components of a computer system (CPU, ALU, control unit, registers, cache, RAM, ROM, secondary storage, input/output devices) and state the function of each in one line

  • Distinguish hardware from software and classify software into system software, utility software and application software with two examples each

  • Convert numbers between binary, decimal and hexadecimal and perform binary addition manually for at least ten practice values

  • Describe the information processing cycle (input, processing, storage, output) and map each stage to the hardware that performs it

  • List common file types and storage units (bit, byte, KB, MB, GB, TB) and calculate storage size for a given set of files

Your checkpoint

A one-page labelled block diagram of a computer system plus a 20-row component-function table and a 10-conversion binary/hex worksheet solved by hand

Week 2

Fundamentals of Information Technology and Computer Systems & Office Productivity Software (Word Processing, Spreadsheets, Presentation)

  • Explain the role of the operating system and demonstrate file and folder operations (create, rename, move, copy, delete, search, compress) on a real machine

  • Apply word-processing skills to produce a formatted document using headings, styles, bullets, tables, page margins, headers and footers, and spell check

  • Build a spreadsheet with at least 30 rows of data using formulas, relative and absolute references, SUM, AVERAGE, IF, sorting and a simple chart

  • Create a presentation of 8-10 slides using a consistent theme, slide master, transitions and speaker notes

  • Identify the correct software tool for a given task and justify the choice in one sentence

Your checkpoint

A three-file portfolio (one formatted document, one spreadsheet with working formulas and a chart, one 8-slide presentation) saved in a single folder with a short note explaining which tool fits which task

Week 3

Office Productivity Software (Word Processing, Spreadsheets, Presentation) & Programming and Problem Solving Fundamentals

  • Solve spreadsheet problems using COUNT, COUNTA, MIN, MAX, ROUND, COUNTIF and nested IF, and interpret the results

  • Write algorithms as pseudocode and as flowcharts using the standard symbols for start/stop, input/output, process and decision

  • Trace a given algorithm step by step and record variable values in a trace table to predict the output

  • Identify and correct logic errors in three faulty algorithms or formulas

Your checkpoint

A worked problem set containing five flowcharts drawn with correct symbols, three completed trace tables and one corrected spreadsheet with a written explanation of each fix

Week 4

Internet, Web Technologies and Digital Communication & Digital Safety, Ethics, Cyber Security and Data Privacy

  • Explain how the internet works at a practical level: ISP, IP address, DNS resolution, HTTP/HTTPS, URL structure and the client-server model

  • Use a browser effectively with bookmarks, history, downloads and search operators, and evaluate a website's credibility using domain, author and date checks

  • Compose and manage professional email including subject lines, CC and BCC, attachments, reply versus reply-all, and folder organisation

  • Recognise phishing, smishing, fake login pages and unsafe downloads, and state the correct response for each

  • Apply password hygiene and two-factor authentication, and describe safe handling of personal data online

Your checkpoint

A one-page internet-and-safety reference sheet covering URL anatomy, DNS steps, five phishing red flags and a personal password/2FA checklist, plus screenshots-free written answers to five scenario questions

Week 5

Database Concepts and Data Management

  • Define database, table, record, field, primary key, foreign key and data type, and identify each in a sample dataset

  • Design a two-table relational schema for a small scenario and explain why the relationship prevents duplication

  • Write and interpret SELECT queries with WHERE, ORDER BY, GROUP BY and simple aggregate functions

  • Perform basic data operations (insert a record, update a value, delete a record) and explain why validation and backups matter

  • Compare flat files with relational databases and state two advantages of each in context

Your checkpoint

A database design document for a small scenario: entity list, field table with data types and keys, relationship description, and six working queries with their expected output described in words

Week 6

IT-enabled Services (ITeS) and Business Process Outsourcing & Communication Skills and Customer Service for ITeS

  • Define ITeS, BPO, KPO and LPO and give two real service examples of each, distinguishing voice from non-voice processes

  • Map a typical BPO workflow from customer contact to closure and name the role and responsibility at each step

  • Apply the components of effective communication (sender, message, channel, feedback, noise) to a customer interaction scenario

  • Demonstrate active listening, paraphrasing and empathetic phrasing by rewriting five blunt customer statements into service-appropriate responses

  • Explain service-level agreements, first-call resolution, average handling time and customer satisfaction as performance measures

Your checkpoint

A two-part artefact: a one-page ITeS/BPO process map with roles, and a scripted customer-interaction log of five scenarios with your rewritten responses and a note on which communication skill each demonstrates

Week 7

Programming and Problem Solving Fundamentals & Entrepreneurship, Employability and Workplace Skills

  • Write and dry-run simple programs using variables, input/output, sequence, selection and iteration, and predict output before running

  • Identify syntax, runtime and logic errors in short code fragments and state the fix for each

  • Draft a one-page business idea for an IT-enabled micro-service with customer segment, value proposition, cost and revenue lines

  • Build a personal CV and a short cover message that match stated job requirements, and prepare answers to three common interview questions

  • Set two SMART employability goals with a deadline and the evidence that will show completion

Your checkpoint

A career pack containing four debugged code exercises with predicted outputs, a one-page business idea canvas, a one-page CV and three written interview answers

Week 8

Fundamentals of Information Technology and Computer Systems & Office Productivity Software (Word Processing, Spreadsheets, Presentation) & Internet, Web Technologies and Digital Communication & Database Concepts and Data Management & Programming and Problem Solving Fundamentals & IT-enabled Services (ITeS) and Business Process Outsourcing & Communication Skills and Customer Service for ITeS & Digital Safety, Ethics, Cyber Security and Data Privacy & Entrepreneurship, Employability and Workplace Skills

  • Revise all nine domains using a weighted checklist that allocates the most time to Domains 1, 2, 5 and 6

  • Complete two timed mixed-domain practice sets and score them against an answer key

  • Re-study only the topics where practice scores fell below 60 percent and record the corrected facts

  • Recite key definitions (ITeS, BPO, primary key, algorithm, phishing, SLA) from memory without notes

Your checkpoint

A scored mock-test record showing both attempts, a list of weak topics with corrected notes, and a one-page final revision sheet of memorised definitions

Milestones

Week 2: Can explain the information processing cycle, convert between binary and decimal, and produce a formatted document, a formula-driven spreadsheet and a themed presentation without reference notes

Week 4: Can draw a correct flowchart, complete a trace table, explain DNS resolution in sequence, and list five phishing red flags with the correct response for each

Week 6: Can design a two-table schema with keys, write four SELECT queries, and explain BPO versus KPO with two service examples each

Week 7: Scores at least 60 percent on a self-made mixed-domain quiz covering Domains 1 to 8 and has a finished CV and business idea canvas

Week 8: Scores at least 70 percent on both timed mock tests and can define all listed key terms from memory