Karnataka KSEAB SSLC NSQF Information Technology study plan
Karnataka KSEAB SSLC NSQF Information Technology · Give each week a clear focus.
8 weeks · About 7 hours per week
Information Technology Fundamentals and Computer Systems
List and explain the function of each major internal component (CPU, ALU, control unit, RAM, ROM, cache, motherboard, storage drives, SMPS, ports) in your own words
Convert between binary, decimal and hexadecimal by hand for at least ten numbers, and state the number of bits in a byte, kilobyte, megabyte and gigabyte
Classify ten given devices as input, output, processing or storage with a one-line justification each
Draw a labelled block diagram of a computer system and trace the fetch-decode-execute cycle through it
Distinguish system software from application software and NSQF-level IT job roles using five examples of each
Your checkpoint
A hand-drawn labelled block diagram of a computer system plus a one-page component glossary with at least 25 terms defined in your own words
Operating Systems and File Management
Perform and record 20 file operations (create, rename, copy, move, delete, restore from Recycle Bin) using both GUI and keyboard shortcuts
Build a nested folder tree three levels deep that separates personal, study and project files, and explain the naming rule you applied
Compare at least five operating systems (Windows, Linux, Android, macOS, DOS) on interface, licensing and typical use
Demonstrate file compression, extraction and a full-disk scan, and note the steps in a checklist
Explain absolute versus relative paths and write the full path of three of your own files
Your checkpoint
A screenshot-free written lab log of 20 file operations with the command or menu path used for each, plus your folder-tree naming scheme
Word Processing and Documentation
Format a five-page document using headings, paragraph spacing, alignment, indents, bullets and numbered lists
Insert and format a table with merged cells, and add a captioned image with wrapped text
Apply styles, generate an automatic table of contents, and insert page numbers with a different first page
Run spell check, use find-and-replace with formatting, and record tracked changes on a draft
Set margins, orientation, page size and print preview for a two-column layout
Your checkpoint
A formatted five-page report on an IT topic of your choice containing a styled heading hierarchy, an auto-generated table of contents, one merged-cell table and one captioned image
Spreadsheets and Data Analysis
Enter and format a 25-row dataset with correct data types, then sort and filter it on two criteria
Write formulas using SUM, AVERAGE, MIN, MAX, COUNT, COUNTA and ROUND, and explain what each returns
Build IF, nested IF and COUNTIF formulas to grade or categorise records automatically
Create a column chart and a pie chart from the same data with titles, axis labels and a legend
Apply relative and absolute references correctly and demonstrate a VLOOKUP or lookup equivalent on your dataset
Your checkpoint
A single spreadsheet workbook with a formatted data sheet, a formula sheet using at least eight functions including one lookup, and two correctly labelled charts
Presentation Software and Digital Communication & Cyber Safety, Ethics, and Digital Citizenship
Build a ten-slide presentation with a consistent theme, slide master, and at least three layout types
Add speaker notes, a hyperlink, an embedded chart and one transition, and rehearse the deck aloud once
Identify five common cyber threats (phishing, ransomware, identity theft, cyberbullying, fake news) and write one prevention rule for each
State the key legal and ethical points on password hygiene, software piracy, plagiarism and personal-data sharing
Draft a short digital-citizenship code of conduct for a school or workplace lab
Your checkpoint
A ten-slide presentation on cyber safety for first-time internet users, exported as PDF, accompanied by a one-page digital-citizenship code of conduct
Internet, Web Browsing, and Email
Explain how a URL is structured by breaking five real URLs into protocol, domain, path and query parts
Compare at least four browsers and three search engines, and demonstrate three advanced search operators
Compose and send a formal email with a subject line, salutation, body, attachment and signature, then reply and forward it
Create and organise contacts, labels or folders, and demonstrate CC versus BCC with an explanation of when each is appropriate
List five signs of a fraudulent website or email and describe how to verify a sender before clicking
Your checkpoint
A printed or saved set of three formal emails (enquiry, application, complaint) with attachments and signatures, plus a one-page URL anatomy and safe-browsing checklist
Database Concepts and Management & Programming Fundamentals and Logic
Define table, record, field, primary key, foreign key and data type, and design a three-table schema on paper for a school library or shop
Write and run SQL statements for CREATE TABLE, INSERT, SELECT with WHERE, ORDER BY and a simple aggregate
Explain the difference between a spreadsheet list and a relational database table using your own schema as the example
Write algorithms in pseudocode and draw flowcharts for three problems: largest of three numbers, sum of first N numbers, and a simple menu-driven calculator
Trace a given flowchart by hand, state its output for two inputs, and identify the loop condition and any off-by-one error
Your checkpoint
A database design sheet with an ER-style sketch and five working SQL statements, plus a flowchart-and-pseudocode portfolio for three programs with hand-traced outputs
Programming Fundamentals and Logic & Employability Skills and Vocational Practices & Information Technology Fundamentals and Computer Systems & Spreadsheets and Data Analysis
Write, dry-run and correct programs that use variables, data types, operators, conditional statements and loops in the language taught in your course
Revise all ten domains using a self-made one-page summary sheet per domain, flagging weak areas
Complete two timed full-length practice papers and score them honestly against the marking scheme
Re-attempt every question you got wrong and write the reason for each error in a correction log
Prepare a short CV or profile listing your IT skills, and rehearse answers on teamwork, punctuality and workplace safety
Your checkpoint
A correction log of every missed practice question with the correct reasoning, plus a one-page skills CV and a completed self-assessment grid scoring your confidence in each of the ten domains
Milestones
Week 2: You can create, move and restore files without the mouse and can explain the difference between system and application software in under two minutes
Week 4: You can build a formatted spreadsheet with eight functions, a lookup and two labelled charts from a blank workbook in 45 minutes
Week 6: You score at least 70 percent on a self-made 30-question quiz covering domains 1 to 6, and can send a correctly formatted email with attachment and signature unaided
Week 8: You score at least 60 percent on both timed practice papers, and your correction log shows no repeated error type across the two attempts