RBSE Prav Voc IT and ITeS study plan
RBSE Prav Voc IT and ITeS · Give each week a clear focus.
8 weeks · About 6 hours per week
Information Technology Fundamentals and Computer Systems & Operating Systems and File Management
Identify and explain the function of core computer hardware components (CPU, RAM, storage, motherboard, peripherals) and classify input, output, and processing devices.
Compare operating system types and describe their role in resource, memory, and device management.
Demonstrate file and folder operations in at least two operating systems: create, rename, move, copy, delete, compress, and set permissions.
Explain the difference between system software and application software and give an example of each.
Describe common file formats and their appropriate uses (e.g., .docx, .xlsx, .pptx, .pdf, .csv, .jpg, .mp4).
Your checkpoint
A one-page labeled diagram of a computer system with a written explanation (150–200 words) of how the OS manages hardware and files, plus a screenshot log of 10 completed file operations.
Word Processing and Document Preparation & Spreadsheets and Data Analysis
Create a formatted document using styles, headings, page numbers, tables, and a table of contents.
Apply spreadsheet formulas and functions (SUM, AVERAGE, IF, COUNT, VLOOKUP) to a sample dataset.
Build a chart from spreadsheet data and interpret the result in writing.
Use data-sorting and filtering tools to answer specific questions about a dataset.
Explain relative vs. absolute cell references and demonstrate both.
Your checkpoint
A two-part portfolio: a 2-page formatted report (with TOC and table) and a spreadsheet workbook with 5 formulas, 1 chart, and a 100-word written interpretation of the chart.
Spreadsheets and Data Analysis & Presentation Software and Digital Communication
Clean and analyze a small dataset using sorting, filtering, pivot-style summaries, and conditional formatting.
Create a 6–8 slide presentation with a consistent theme, slide master, speaker notes, and at least one chart or table.
Apply presentation best practices: one idea per slide, readable fonts, contrast, and minimal text.
Deliver a 3-minute recorded or live presentation using speaker notes and answer two audience-style questions.
Explain how to export and share documents and presentations in PDF and editable formats.
Your checkpoint
A polished 8-slide presentation deck built from the spreadsheet analysis, with speaker notes and a 3-minute recorded narration or a written script.
Internet, Web Services and Email & Database Concepts and Data Management
Explain how the internet works: IP addressing, DNS, HTTP/HTTPS, browsers, and common web services.
Configure and use email professionally: compose, reply, forward, attach files, use CC/BCC, and organize with folders and labels.
Describe database concepts: tables, records, fields, primary keys, foreign keys, and relationships.
Write basic SQL queries (SELECT, WHERE, ORDER BY, JOIN) against a sample database.
Explain the difference between a database and a spreadsheet and when to use each.
Your checkpoint
A short report (200–250 words) explaining how a URL request reaches a web server, plus a set of 5 working SQL queries and their output on a sample database.
IT Enabled Services and Business Process Operations & Digital Communication and Soft Skills for ITeS
Define IT Enabled Services (ITeS) and distinguish BPO, KPO, and LPO with real examples.
Describe common business process operations: data entry, voice and non-voice support, transaction processing, and quality metrics.
Apply professional email and chat etiquette in simulated customer interactions.
Demonstrate active listening and clear verbal communication in a role-play scenario.
Explain the importance of service level agreements (SLAs), KPIs, and customer satisfaction in ITeS.
Your checkpoint
A role-play package: two professional emails (one complaint response, one escalation), a 200-word reflection on active listening, and a one-page SLA/KPI summary table.
Cyber Safety, Ethics and Data Privacy & Emerging Technologies and Entrepreneurship in IT
Identify common cyber threats: phishing, malware, ransomware, social engineering, and weak passwords.
Apply safe browsing and password practices, including multi-factor authentication and password managers.
Explain data privacy principles (consent, minimization, purpose limitation) and relevant legal concepts at a high level.
Describe emerging technologies (AI, cloud computing, IoT, blockchain) and give one ITeS use case for each.
Outline the steps to start a small IT-enabled service business, including a basic value proposition and cost estimate.
Your checkpoint
A two-part deliverable: a one-page cybersecurity checklist for a small office and a one-page business idea canvas for an ITeS startup with a 100-word risk note.
Information Technology Fundamentals and Computer Systems & Word Processing and Document Preparation & Spreadsheets and Data Analysis & Internet, Web Services and Email
Review and consolidate weak areas from Weeks 1–6 using a personal error log.
Complete a timed 30-question mixed practice set covering Domains 1, 3, 4, and 6.
Re-explain in writing the five concepts you missed most often, with corrected examples.
Build a one-page formula and shortcut sheet for word processing, spreadsheets, and email.
Verify file management and internet/email tasks can be completed without notes.
Your checkpoint
A completed 30-question practice set with a scored answer key, a personal error log, and a one-page quick-reference sheet.
IT Enabled Services and Business Process Operations & Digital Communication and Soft Skills for ITeS & Cyber Safety, Ethics and Data Privacy & Emerging Technologies and Entrepreneurship in IT
Complete a full-length timed mock exam covering all 11 domains and score it.
Review every incorrect answer and write the correct reasoning in your own words.
Rehearse two ITeS soft-skill scenarios (an angry customer and a data privacy concern) aloud.
Summarize the top 10 exam facts you must remember from ITeS operations, cyber safety, and emerging technologies.
Finalize a one-page exam-day checklist covering time allocation and question strategy.
Your checkpoint
A scored full-length mock exam with a corrected answer review and a final one-page exam-day strategy sheet.
Milestones
Week 2: Can create a formatted document with a table of contents and a spreadsheet with 5 working formulas and a chart without referring to notes.
Week 4: Can explain DNS, HTTP, and email workflow in plain language and write 5 correct SQL queries against a sample database.
Week 6: Can list 5 cyber threats with one prevention measure each and describe one ITeS use case for 4 emerging technologies.
Week 8: Scores at least 70% on the full-length mock exam and has a written correction for every missed question.