RBSE SS Voc IT and ITeS study plan

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

Distinguish input, output, and storage devices and classify 20 given examples correctly

Compare primary and secondary memory, and convert between bit, byte, KB, MB, GB, and TB

Identify common file extensions and match each to its file type (document, spreadsheet, image, audio, video, executable)

Demonstrate correct startup, shutdown, and safe USB removal procedure on a real or simulated machine

Apply character and paragraph formatting (font, size, bold, alignment, line spacing, indents) to produce a formatted two-page document

Insert and format a table with merged cells, and add page numbers, headers, and footers

Use spelling/grammar check, find-and-replace, and track changes to edit a draft

Build a spreadsheet with at least 30 rows using SUM, AVERAGE, MIN, MAX, and COUNT

Write IF and COUNTIF formulas and create a chart from selected data

Sort and filter a dataset on two or more criteria and apply conditional formatting rules

Create a presentation of 8-10 slides applying a consistent theme, slide master, and readable font hierarchy

Add transitions and at least three animation types, and insert an image and a chart into slides

Use relative vs absolute cell references correctly in three worked examples

Print-preview and set page orientation, margins, and print area for both a document and a spreadsheet

Explain how a URL is structured (protocol, domain, path) and identify each part in 10 sample addresses

Distinguish browser, search engine, website, and web page, and run three advanced search queries using operators

Configure and describe email fields (To, Cc, Bcc, Subject, Attachment) and compose a professional email with attachment

List at least five netiquette rules and apply them to rewrite three poorly written messages

Identify common online risks (phishing, malware, weak passwords) and state one preventive measure for each

Define database, table, record, field, and primary key, and identify each in a sample dataset

Create a table with appropriate data types and enter at least 25 records

Write SELECT queries using WHERE, ORDER BY, and comparison operators

Use aggregate functions (COUNT, SUM, AVG) with GROUP BY on the sample table

Explain the purpose of a relational link between two tables and sketch a two-table design

Describe the IPO (input-process-output) model and identify each stage for three everyday programs

Write and explain algorithms and flowcharts for three simple problems using standard symbols

Declare variables of different data types and write assignment and arithmetic statements

Write programs using sequence, selection (if-else), and iteration (loop) constructs

Trace a given short program by hand and predict its output correctly

Define BPO and ITeS and list at least five service types with one real example each

Outline the stages of a customer-support call and list five qualities of effective voice support

Demonstrate data-entry accuracy and speed on a timed 10-minute passage and calculate accuracy percentage

Explain transcription workflow and list three quality checks applied to a transcript

Identify the skills and roles in an ITeS team (agent, team leader, quality analyst) and describe each responsibility

List ergonomic workstation practices and identify five posture and screen-distance errors in a described setup

State electrical and fire safety precautions for a computer lab and the correct response to each hazard

Explain confidentiality, data privacy, punctuality, and professional conduct obligations in an ITeS workplace

Complete two full-length timed mock tests and log every wrong answer by domain

Re-study the two weakest domains using the error log and re-test those areas