Punjab PSEB Matric Computer Science study materials
Punjab PSEB Matric Computer Science study resources

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

Week 1

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.

Week 2

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.

Week 3

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.

Week 4

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.

Week 5

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.

Week 6

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.

Week 7

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.

Week 8

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.