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