UPMSP High School IT & ITeS study plan
UPMSP High School IT & ITeS · Give each week a clear focus.
8 weeks · About 6 hours per week
Fundamentals of Information Technology and Computer Systems & Office Productivity Software (Word Processing, Spreadsheets, Presentation)
Label the main internal components (CPU, RAM, ROM, motherboard, storage, SMPS) and state the function of each in writing
Distinguish hardware from software and classify five examples of each, including system versus application software
Demonstrate correct use of file and folder operations: create, rename, move, copy, delete and restore from Recycle Bin
Identify the main parts of a word processor window and apply basic formatting (font, size, bold, italic, alignment) to a typed passage
Your checkpoint
A one-page handwritten or typed diagram of computer components with functions labelled, plus a saved practice document showing at least five formatting changes
Office Productivity Software (Word Processing, Spreadsheets, Presentation)
Build a formatted document using headings, bulleted and numbered lists, page margins and page orientation
Insert and format a table with merged cells, and apply borders and shading
Create a spreadsheet with at least 20 rows of data and apply SUM, AVERAGE, MIN, MAX and COUNT formulas
Construct a chart from spreadsheet data and label its title, axes and legend
Design a five-slide presentation with a consistent theme, one title slide and one closing slide
Your checkpoint
A single practice folder containing one formatted document, one spreadsheet with working formulas and a chart, and one five-slide presentation
Office Productivity Software (Word Processing, Spreadsheets, Presentation) & Fundamentals of Information Technology and Computer Systems
Apply relative and absolute cell references correctly in at least three copied formulas and explain the difference
Use sorting and filtering on a data table, then apply conditional formatting to highlight values above a threshold
Insert a slide transition and apply animation to text without overusing effects
Compare input, output, and storage devices by giving two examples of each and one use case per example
Explain the difference between primary memory and secondary storage with two examples each
Your checkpoint
A spreadsheet workbook with a sorted, filtered and conditionally formatted table plus a short written comparison of input, output and storage devices
Internet, Web Browsing and Digital Communication & Digital Safety, Cyber Hygiene and Ethics
Explain how a URL, IP address, domain name and DNS resolution relate to each other
Perform a search using at least two operators or filters and record which results were relevant and why
Compose and send a formal email with a clear subject line, salutation, body, attachment and signature
Identify three phishing red flags in sample message text and state the correct response for each
Set a strong password policy for yourself and enable two-step verification on one account
Your checkpoint
A screenshot-free written log of one search exercise, one sent formal email draft saved as a document, and a checklist of five cyber-hygiene actions you completed
IT-enabled Services (ITeS) and Business Process Outsourcing Basics & Data Entry, Documentation and Record Keeping
Define ITeS, BPO, KPO and LPO and give one realistic Indian example of work done in each
Distinguish voice and non-voice processes and list the skills each demands
Type a supplied passage at a steady pace while keeping errors low, and record your own speed and accuracy
Apply data validation and consistent formatting rules to a record-keeping sheet with at least 30 entries
Explain why accuracy, confidentiality and turnaround time matter in a client-facing process
Your checkpoint
A 30-row record-keeping spreadsheet with validation applied, plus a typed passage with your measured words-per-minute and error count noted
Basic Networking, Hardware and Troubleshooting & Digital Safety, Cyber Hygiene and Ethics
Distinguish LAN, MAN and WAN and identify which one fits a school lab, a city cable network and the internet
Explain the roles of IP address, router, switch, modem and Wi-Fi access point in a small network
Follow a basic troubleshooting sequence for a computer that will not start or has no display, and document each step
Distinguish a virus, worm, Trojan and ransomware by behaviour and state one preventive measure for each
Explain what data backup means and set up a simple two-location backup routine for your project files
Your checkpoint
A troubleshooting flowchart for one common fault plus a written four-row malware comparison table with preventive measures
Entrepreneurship, Employability Skills and Workplace Communication & IT-enabled Services (ITeS) and Business Process Outsourcing Basics
Draft a short business idea for a small ITeS or data-entry service and list its customer, cost and price
Write a two-minute self-introduction covering skills, experience and career aim
Prepare answers to three common interview questions and rehearse them aloud
Identify the parts of a formal business letter and draft one enquiry letter to a prospective client
List five employability skills and give one concrete example of how you have shown each
Your checkpoint
A one-page business idea sheet with cost and price estimates plus a written two-minute self-introduction and one drafted enquiry letter
Practical / Project Work and Viva (school-assessed vocational component) & Office Productivity Software (Word Processing, Spreadsheets, Presentation) & Internet, Web Browsing and Digital Communication
Assemble a project folder containing your best document, spreadsheet and presentation, named and organised consistently
Rehearse a five-minute viva explanation of what your project does, which tools you used and one problem you solved
Complete a timed mixed-topic revision set and review every wrong answer against the source material
State the safety and ethical rules you followed while working on the project, including data privacy and plagiarism
Your checkpoint
A complete, consistently named project folder with a one-page project summary and a rehearsed five-minute viva script
Milestones
Week 2: You can produce a formatted document, a formula-driven spreadsheet and a short presentation without looking up basic steps
Week 4: You can explain DNS and URL structure in your own words and correctly identify phishing signs in unfamiliar sample text
Week 6: You can name the devices in a small network, follow a troubleshooting sequence, and state preventive measures for four malware types
Week 8: Your project folder is complete and consistently named, and you can deliver the five-minute viva without notes