Beatsy Solutions Beatsy Solutions
8-4-4 Secondary (KNEC Aligned) Form 2 Curriculum Verified

Form 2 Computer Studies

Covers the four major KNEC KCSE Paper 2 practical applications aligned to official 8-4-4 secondary syllabi: Word Processing (Microsoft Word), Spreadsheets (Microsoft Excel), Database Management System...

0.0
(0 ratings)
Category: LMS Training
Created by James Mwangi Last updated 10/2026 English / Swahili

What you'll learn

["Produce advanced formatted documents, tables, multi-column articles, and mail merges in Microsoft Word","Construct complex financial models, lookup tables, nested logical IF formulas, and charts in Microsoft Excel","Design relational database tables, input forms, multi-table queries, and summary reports in Microsoft Access","Create publication-grade brochures, certificates, flyers, and newsletters in Desktop Publishing software","Utilize email protocols, attachments, web browsers, and search engines safely and ethically."]

Learning Tracks & Pricing Options

Designed for self-paced independent study, with optional 1-on-1 instructor support when needed.

2 Flexible Pathways
Curriculum & Support Feature Option A: Self-Study Ksh 2,200.00 Option B: Assisted Learning Ksh 4,840.00
All 5 Structured Modules
Downloadable PDF Manuals & Starter Code
Hands-on Practical Exercises & Capstone Labs
Verified Certificate of Completion
Dedicated 1-on-1 Instructor Mentorship Add on demand Included
Live Debugging & Screen-Share Support Add on demand Included
Milestone Portfolio Code Reviews Add on demand Included
Enroll Self-Study • Ksh 2,200.00 Enroll Assisted • Ksh 4,840.00
Self-Study Flexibility: If you choose Self-Study, you can request instructor assistance for any specific module whenever you need help without altering your self-study access.

Course Content

5 sections • 570 lessons • 20h total length
Expand all sections

  • Advanced Text and Paragraph Formatting in Microsoft Word
    45min
  • Tabs, Custom Tab Stops, and Multi-Level Indentation
    45min
  • Advanced Tables: Splitting, Merging, Formulas, and Sorting
    45min
  • Multi-Column Page Layouts, Section Breaks, and Watermarks
    45min
  • Mail Merge Mastery: Envelopes, Letters, and Data Sources
    45min

  • Cell Referencing Modes: Relative, Absolute ($A$1), and Mixed
    45min
  • Mathematical and Statistical Functions: ROUND, COUNTIF, SUMIF
    45min
  • Complex Decision Making: Nested IF and Logical AND/OR Functions
    45min
  • Table Lookups: VLOOKUP and HLOOKUP Functions
    45min
  • Data Management and Advanced KCSE Paper 2 Charting
    45min

  • Table Design in Design View: Data Types and Field Properties
    45min
  • Data Integrity: Field Validation Rules and Validation Text
    45min
  • Relationships and Referential Integrity: One-to-Many Links
    45min
  • Query Design: Selection Criteria, Wildcards, and Calculated Fields
    45min
  • Form Design and Summary Reports for KCSE Paper 2
    45min

  • Desktop Publishing (DTP) vs Word Processing Concepts
    45min
  • Layout Tools: Master Pages, Rulers, Margins, and Grid Guides
    45min
  • Text Frames, Overflowing Text, and Text Threading
    45min
  • Graphics Manipulation: Cropping, Wrapping, and Layering (Z-Order)
    45min
  • Designing Publication-Grade Certificates, Flyers, and Newsletters
    45min

  • The Internet Architecture: History, ARPANET, and ISPs
    45min
  • The World Wide Web (WWW) vs The Internet
    45min
  • Uniform Resource Locators (URLs) and Domain Names (.ke, .org, .edu)
    45min
  • Email Protocols: SMTP, POP3, and IMAP Operational Differences
    45min
  • Cyber Ethics, Copyright Infringement, and Digital Etiquette
    45min

Description

Covers the four major KNEC KCSE Paper 2 practical applications aligned to official 8-4-4 secondary syllabi: Word Processing (Microsoft Word), Spreadsheets (Microsoft Excel), Database Management Systems (Microsoft Access), Desktop Publishing (Publisher/InDesign), and Internet/Email communications.
Recommended Learning Pathway
Prerequisites / Prior Knowledge:

Form 1 Computer Studies or basic familiarity with computer hardware and operating systems.

Recommended Before Taking This Course:
Recommended Next Step After Completion:

Student Reviews & Feedback

Verified ratings from students enrolled in this course.

No reviews yet for this course. Be the first enrolled student to share feedback!

Chat with us on WhatsApp