Assam ASSEB Higher Secondary Skill Subject IT/ITeS study plan

Set up a practice folder structure and type a 300-word document applying at least 10 formatting features (styles, headings, tables, page breaks) in a word processor

Build a spreadsheet with 30 rows of sample data and use at least 6 functions (SUM, AVERAGE, IF, COUNT, VLOOKUP, ROUND) correctly

Create a 6-slide presentation with a consistent theme, one chart, and speaker notes

Explain the difference between hardware, software, data and information in writing, with one local example each

Produce a formatted report of at least 500 words with a title page, table of contents, numbered headings, and a footer with page numbers

Clean and analyse a 50-row dataset using sorting, filtering, conditional formatting, and a pivot-style summary table

Type three timed passages of 5 minutes each at 30+ words per minute with 95%+ accuracy and log the results

Apply standard data-entry conventions: date format, capitalisation, numeric alignment, and duplicate checking on a 40-record practice sheet

Identify and describe the function of CPU, RAM, ROM, motherboard, HDD/SSD, PSU, and at least four ports from memory, without notes

Perform and document basic OS tasks in both Windows and Linux-style interfaces: file permissions, folder creation, disk usage check, and installing/removing software

Configure a browser profile: bookmarks, downloads folder, pop-up settings, and one privacy setting, then explain what each change does

Explain how a URL resolves to a web page, covering DNS, HTTP/HTTPS, and IP addresses, in under 200 words

Write and send a professional email with a subject line, greeting, structured body, attachment, and signature to a practice address

Design a normalized 3-table database schema for a small library or shop scenario, with primary and foreign keys marked

Write and run at least 8 SQL statements covering SELECT, WHERE, ORDER BY, GROUP BY, and a two-table JOIN

Draw a flowchart for a number-checking or grading program using sequence, selection, and loop constructs

Write pseudocode and then working code for two small programs: sum of first N numbers, and largest of three inputs

Trace a given loop by hand and predict its output before running it

Write a scripted response for five common customer scenarios: billing query, service delay, wrong item, refund request, and an angry caller

Handle two mock calls or chats with a peer or recorded self-review, applying greeting, active listening, empathy, and closing steps

Classify ten given data-privacy situations as safe or risky and justify each in one sentence

Set up and demonstrate three practical safeguards: strong password practice, two-factor authentication, and identifying a phishing message

Draft a one-page incident note describing a suspected phishing attempt using the facts-only, no-blame format

Create a simple three-page static website using headings, lists, links, and one image with correct relative paths

Compare at least four digital communication channels (email, chat, video call, ticketing) on speed, record-keeping, and suitability

Draft a two-minute self-introduction for an interview covering skills, one achievement, and why the role fits

Prepare a one-page CV in a word processor with consistent formatting, reverse-chronological order, and no spelling errors

Identify three IT-enabled local business or freelance opportunities and note the service, customer, and price model for each

Explain digital literacy terms (cloud, file format, backup, digital signature, netiquette) in your own words with one example each

Audit your own online accounts: list accounts, note which have 2FA, and change any reused passwords

Identify five common cyber threats (phishing, malware, ransomware, social engineering, weak passwords) and one countermeasure for each

Practise two workplace messages: a leave request and a status update, each under 120 words and appropriately formal

Complete two full-length timed mock tests under exam conditions and score them by domain

Re-attempt every question missed in the mocks and write the correct reasoning in your own words

Recite from memory the key lists: hardware components, SQL clause order, OSI-free network basics, and customer-handling steps

Redo one weak practical task (spreadsheet, query, or program) end to end without looking at notes