Odisha CHSE +2 Vocational Information Technology study plan
Odisha CHSE +2 Vocational Information Technology · Give each week a clear focus.
8 weeks · About 6 hours per week
Computer Fundamentals and Hardware
Identify and explain the function of core internal components: CPU, motherboard, RAM, ROM, storage devices, SMPS, and expansion slots.
Classify input, output, and storage devices by their role and give one real example of each.
Describe the boot process from power-on to OS load, naming the roles of BIOS/UEFI, POST, and the bootloader.
Convert between binary, decimal, and hexadecimal and state typical storage unit values from bit to terabyte.
Your checkpoint
A one-page labelled block diagram of a computer system with a 150-word explanation of the boot sequence, checked against the textbook for accuracy.
Operating Systems and File Management & Word Processing and Documentation
Compare the purpose and interface of Windows, Linux, and mobile OS in a short table of 4–5 criteria.
Perform and document file operations: create, rename, move, copy, delete, and restore from Recycle Bin, plus use search and file-extension display.
Format a 2-page document using styles, headings, page margins, page numbers, and a simple table of contents.
Insert and format a table, an image with text wrapping, and a header/footer in a word processor.
Your checkpoint
A formatted 2-page report (saved as PDF and DOCX) with title page, table of contents, one table, one image, and page numbers.
Spreadsheets and Data Analysis
Enter and format a dataset with headers, data types, number formats, and freeze panes.
Write formulas using relative and absolute references and the functions SUM, AVERAGE, COUNT, COUNTA, IF, and VLOOKUP.
Create a column chart and a pie chart from the dataset and label axes, title, and legend.
Apply sorting, filtering, and conditional formatting to highlight values above a threshold.
Your checkpoint
A spreadsheet workbook with 20+ records, 5 formulas including one IF and one VLOOKUP, one chart, and one conditional-formatting rule, submitted with a screenshot of the formulas view.
Database Concepts and DBMS & Programming Fundamentals and Logic
Define DBMS, table, primary key, foreign key, and relationship, and draw an ER diagram for a small library or shop case.
Write and execute SQL statements for CREATE TABLE, INSERT, SELECT with WHERE, and simple UPDATE and DELETE.
Explain variables, data types, and the three basic control structures (sequence, selection, iteration) with one example each.
Trace a simple algorithm (sum of first n numbers, largest of three) and write its pseudocode and flowchart.
Your checkpoint
A single document containing an ER diagram, 6 working SQL statements with sample output, and pseudocode plus flowchart for two algorithms.
Programming Fundamentals and Logic & Presentation Software and Multimedia
Write and run a short program (in any available language) that takes input, uses a loop and a conditional, and prints output.
Debug three given faulty code snippets by identifying syntax and logic errors.
Build a 6-slide presentation with a consistent theme, title slide, bullet content, one chart or table, and speaker notes.
Apply slide transitions and animations sparingly and export the presentation to PDF.
Your checkpoint
A working 30–40 line program with comments and sample output, plus a 6-slide presentation exported to PDF.
Internet, Web Basics and Email
Explain the terms URL, HTTP/HTTPS, browser, web server, and search engine, and distinguish static from dynamic web pages.
Create a simple web page using HTML headings, paragraphs, lists, links, and one image.
Compose, send, and manage email: attach a file, use CC/BCC correctly, and create a signature and folder rule.
Identify common email threats (phishing, spam, attachments) and state two safe-practice rules for each.
Your checkpoint
A 3-page HTML file that opens in a browser with a working hyperlink and image, plus a screenshot of a sent email showing attachment, CC, and signature.
Computer Networks and Security Basics
Distinguish LAN, WAN, MAN, and PAN and list the hardware needed for each (router, switch, hub, modem, NIC).
Explain IP address, DNS, and the client-server model at a basic level with one everyday example.
Define confidentiality, integrity, and availability and give one threat and one control for each.
Describe password hygiene, antivirus updates, firewall basics, and safe browsing in a checklist of at least 8 items.
Your checkpoint
A one-page network-and-security summary with a labelled LAN diagram and a 10-item personal cybersecurity checklist.
Practical Work, Project and Employability Skills & Computer Fundamentals and Hardware & Spreadsheets and Data Analysis & Database Concepts and DBMS
Assemble a mini project that combines a spreadsheet dataset, a database table, and a short report or presentation.
Write a 1-page project report with aim, tools used, procedure, result, and limitations.
Draft a CV and a 150-word cover letter using word-processing formatting skills.
Complete two timed mixed-domain practice sets and review every wrong answer with the correct reason.
Your checkpoint
A submitted mini project folder (dataset, SQL file, report PDF, presentation) plus a formatted CV and a log of corrected mistakes from the practice sets.
Milestones
Week 2: Can label all major internal components from memory and produce a formatted 2-page document with table of contents without help.
Week 4: Can write 5 correct SQL statements and trace two algorithms on paper in under 30 minutes with no notes.
Week 6: Can create a working HTML page with a link and image, and explain the difference between HTTP and HTTPS and between CC and BCC.
Week 8: Mini project is complete and self-assessed against a checklist; two practice sets are done with a written error log and a score target of at least 70%.