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 ratings)
Category: LMS Training
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.
| 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 Word45min
-
Tabs, Custom Tab Stops, and Multi-Level Indentation45min
-
Advanced Tables: Splitting, Merging, Formulas, and Sorting45min
-
Multi-Column Page Layouts, Section Breaks, and Watermarks45min
-
Mail Merge Mastery: Envelopes, Letters, and Data Sources45min
-
Cell Referencing Modes: Relative, Absolute ($A$1), and Mixed45min
-
Mathematical and Statistical Functions: ROUND, COUNTIF, SUMIF45min
-
Complex Decision Making: Nested IF and Logical AND/OR Functions45min
-
Table Lookups: VLOOKUP and HLOOKUP Functions45min
-
Data Management and Advanced KCSE Paper 2 Charting45min
-
Table Design in Design View: Data Types and Field Properties45min
-
Data Integrity: Field Validation Rules and Validation Text45min
-
Relationships and Referential Integrity: One-to-Many Links45min
-
Query Design: Selection Criteria, Wildcards, and Calculated Fields45min
-
Form Design and Summary Reports for KCSE Paper 245min
-
Desktop Publishing (DTP) vs Word Processing Concepts45min
-
Layout Tools: Master Pages, Rulers, Margins, and Grid Guides45min
-
Text Frames, Overflowing Text, and Text Threading45min
-
Graphics Manipulation: Cropping, Wrapping, and Layering (Z-Order)45min
-
Designing Publication-Grade Certificates, Flyers, and Newsletters45min
-
The Internet Architecture: History, ARPANET, and ISPs45min
-
The World Wide Web (WWW) vs The Internet45min
-
Uniform Resource Locators (URLs) and Domain Names (.ke, .org, .edu)45min
-
Email Protocols: SMTP, POP3, and IMAP Operational Differences45min
-
Cyber Ethics, Copyright Infringement, and Digital Etiquette45min
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!