Punjab PSEB Matric Computer Science study plan
Punjab PSEB Matric Computer Science · Give each week a clear focus.
8 weeks · About 6 hours per week
Computer Fundamentals and Hardware
Classify 30 devices and components into input, output, processing, storage, and memory units, writing a one-line justification for each placement.
Draw and label a block diagram of a computer system from memory, then correct it against your notes and redraw once.
Build an eight-row comparison table covering RAM vs ROM, primary vs secondary memory, and volatile vs non-volatile storage.
Explain bit, byte, KB, MB, GB, and TB in order of size, and state what each of CPU, motherboard, RAM, and hard disk is doing when a program is launched.
Distinguish hardware from software, and system software from application software, with two examples of each in your own words.
Your checkpoint
A hand-drawn system block diagram plus a 30-row device classification table, self-marked and scoring at least 27/30.
Operating System and File Management
Perform and log 15 file-management operations on your own machine: create, rename, copy, move, delete, restore from Recycle Bin, and search by file extension.
Compare FAT32, NTFS, and exFAT in a table showing typical use and key limits, and state which suits a USB drive used for large files.
Describe the boot process and the role of the kernel, device drivers, and the user interface in five sentences without notes.
Demonstrate five built-in utilities (disk cleanup, drive optimisation, task manager, file compression, display/sound settings) and record what each changes.
Distinguish GUI from CUI, single-user from multi-user, and open-source from proprietary operating systems, naming one example of each.
Your checkpoint
A written folder-structure plan showing a five-folder tree holding 20 files sorted by type, plus a 10-shortcut list you can reproduce from memory.
Word Processing
Format a two-page document using heading styles, font size and family, line and paragraph spacing, alignment, bullets, and numbering.
Insert a six-row table with merged header cells and repeat the header row when it breaks across pages.
Add page numbers, header, footer, page border, and auto-generate a table of contents from the heading styles.
Use find and replace, spell check, word count, and track changes on a paragraph you deliberately corrupt first.
Set page size, margins, and orientation, then export the file to PDF and confirm pagination is unchanged.
Your checkpoint
A two-page formatted report (title block, table, header/footer, page numbers, contents list) exported as PDF and passed against a 10-point self-checklist.
Spreadsheets
Enter and format a 20-row dataset with currency, percentage, and date formats, and freeze the header row so it stays visible.
Write formulas using the four arithmetic operators, then apply SUM, AVERAGE, MAX, MIN, COUNT, and COUNTA to the dataset.
Build one IF formula and one nested IF to assign grades, and add COUNTIF and SUMIF summary cells.
Create a column chart and a pie chart with axis titles, legend, and a two-sentence written interpretation of each.
Explain relative, absolute, and mixed cell referencing with one worked example each, then sort, filter, and apply conditional formatting to the dataset.
Your checkpoint
A working 20-student marks-sheet workbook with totals, average, IF-based grades, COUNTIF pass count, and a column chart, verified against five hand-calculated values.
Spreadsheets & Presentation Software and Multimedia
Convert 10 written spreadsheet problems into correct formulas, including percentage change, absolute references, and averaging only a filtered set of rows.
Outline a six-slide deck (title, agenda, two content slides, chart slide, conclusion) with one headline message per slide before opening the software.
Apply a consistent theme, slide master, layout, font pair, and colour contrast across a six-slide deck, then add transitions and one entrance animation.
Insert the chart exported from your week-4 workbook and add speaker notes for every slide.
Rehearse the deck aloud and set slide timings so it runs unattended for the assigned duration.
Your checkpoint
A six-slide deck built on your spreadsheet chart, delivered aloud in four minutes and timed automatically without overrunning.
Presentation Software and Multimedia & Internet, Email and Cyber Safety
Insert, crop, and align two images on a slide, add alt text to both, and compress media so the file stays under 5 MB.
Compare raster and vector graphics and match JPG, PNG, GIF, SVG, MP3, and MP4 to a suitable use case each.
Draw a labelled diagram showing computer, router, ISP, DNS, IP address, URL, and browser, and explain in writing what happens when a URL is typed.
Configure an email account with a proper signature, then send one message using To, Cc, and Bcc with a subject line and one attachment.
Demonstrate reply, reply-all, forward, and a mail rule or label that files incoming messages into a folder.
Your checkpoint
A multimedia slide deck (image, short audio or video clip, chart) plus a saved copy of a sent email thread showing To, Cc, Bcc, and an attachment.
Internet, Email and Cyber Safety
Identify eight cyber threats (phishing, smishing, malware, ransomware, spyware, cyberbullying, identity theft, fake QR codes) and write the correct first response to each.
Build a password policy of at least 12 characters with mixed types, and enable two-factor authentication on one account you own.
List the safety rules for OTPs, HTTPS, public Wi-Fi, shared devices, and backups, and explain the harm each rule prevents.
State the exact steps to take within 24 hours of an online financial fraud, including blocking the card or account, calling helpline 1930, and filing at cybercrime.gov.in.
Distinguish e-commerce, e-banking, e-governance, blog, wiki, and social media, giving one authentic Indian example of each.
Your checkpoint
A one-page personal cyber-safety checklist with 15 rules, plus a written 150-word answer on the first 24 hours after an OTP fraud.
Computer Fundamentals and Hardware & Operating System and File Management & Word Processing & Spreadsheets & Presentation Software and Multimedia & Internet, Email and Cyber Safety
Sit two timed 60-question mock tests spanning all six domains and record the score for each domain separately.
Re-teach your five weakest subtopics on blank paper with no notes, then check each against the source material and correct it in red.
Redo every question you got wrong in weeks 1 to 7 and rewrite the corrected reasoning in one line each.
Self-quiz a 40-item sheet of definitions, shortcuts, and function names until you reach 38/40 twice in a row.
Your checkpoint
A domain-wise score log from two mocks showing at least 60 percent in every domain and at least 75 percent overall.
Milestones
Week 2: Score at least 70 percent on a 25-question self-test covering fundamentals and OS/file management, and reproduce the system diagram and boot sequence from memory.
Week 4: All four 17 percent domains are covered: produce the formatted PDF report and the working spreadsheet, and score at least 65 percent on a mixed 30-question test drawn only from domains 1 to 4.
Week 6: Deliver the multimedia deck and the email evidence, and explain image, audio, and video formats plus the URL-to-page sequence without notes.
Week 8: Two full mocks completed with at least 60 percent in each of the six domains and 75 percent overall, with every wrong answer corrected in writing.