Karnataka KSEAB SSLC NSQF Information Technology study materials
Karnataka KSEAB SSLC NSQF Information Technology study resources

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

Week 1

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

Week 2

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

Week 3

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

Week 4

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

Week 5

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

Week 6

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

Week 7

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

Week 8

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