UPMSP High School IT & ITeS study materials
UPMSP High School IT & ITeS study resources

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

Week 1

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

Week 2

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

Week 3

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

Week 4

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

Week 5

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

Week 6

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

Week 7

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

Week 8

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