Certificate in Computer Packages

Computer Packages offer foundational training in essential digital skills, equipping learners with practical knowledge to operate effectively in Small and Medium Enterprises (SMEs). These courses cover areas such as word processing, spreadsheets, databases, and basic internet use—tools crucial for daily business operations. Additionally, they serve as a strong stepping stone for students preparing to pursue higher-level IT courses by building confidence and competence in fundamental computer applications.

open to all interested.

NAYOLITES COMPUTER AND MEDIA COLLEGE

DEPARTMENT OF ICT & DIGITAL LITERACY

CERTIFICATE IN COMPUTER PACKAGES (CMP)

 MASTER CURRICULUM

Total Duration: 3 Months (12 Weeks / 235 Total Guided Learning Hours)

Certification Pathway: Institutional Practical Certificate (ICDL Aligned & TVET CDACC Compliant)

Study Modes: Full-Time (Daily Labs), Part-Time (Evening), & Weekend Intensive

Entry Requirements: Open Enrollment (KCPE, KCSE, or adult literacy learners)

CMP 101: Apply Microsoft Office Tools

• Duration: 40 Hours
• Assessment Mode: Practical Assignment
• Unit Overview: Synthesis and application of core Microsoft Office tools across integrated workplace tasks.
• Detailed Topics:
  • Integration of Office suite applications for administrative workflows.
  • Cross-application data sharing, including exporting database entries to spreadsheets.
  • Embedding dynamic Excel charts into Word reports and PowerPoint presentations.
  • Standard office document styling, templates, and universal document exchange formats.
• Key Practical Deliverable: Multi-program integration assignment combining Word, Excel, and PowerPoint.

CMP 102: Computer Fundamentals & Operating Systems

• Duration: 20 Hours
• Assessment Mode: Theory & Lab Test
• Unit Overview: Core computer hardware components, system architecture, and operating system navigation.
• Detailed Topics:
  • Hardware Architecture: System unit, CPU, RAM, storage drives, and input/output peripherals (printers, scanners, projectors).
  • Operating System Operations: Desktop navigation (Windows 10/11), File Explorer, system settings, control panel, display configuration.
  • File & Storage Management: Folder structures, file naming rules, file extension types (.docx, .xlsx, .pdf, .jpg).
• Key Practical Deliverable: Operating system navigation test and structured directory setup exercise.

CMP 103: Word Processing – Microsoft Word

• Duration: 25 Hours
• Assessment Mode: Practical Project
• Unit Overview: Professional document creation, advanced layout, formatting, and administrative document automation.
• Detailed Topics:
  • Document Creation & Formatting: Character styling, line spacing, paragraph alignment, margins, page breaks, borders, shading.
  • Page Layout & Structuring: Headers, footers, page numbering, cover pages, multi-column layouts, section breaks.
  • Tables & Visual Objects: Inserting and formatting tables, images, shapes, SmartArt graphics, captioning.
  • Advanced Office Tools: Generating automated Table of Contents, spell check, track changes, and Mail Merge for official circulars and bulk mailings.
• Key Practical Deliverable: Formatted business proposal and a mail-merged client circular document.

CMP 104: Spreadsheets – Microsoft Excel

• Duration: 30 Hours
• Assessment Mode: Practical Test
• Unit Overview: Spreadsheet fundamentals, mathematical calculations, data analysis, and visual chart reporting.
• Detailed Topics:
  • Worksheet Fundamentals: Workbook structure, row/column operations, cell addressing (relative vs. absolute referencing), formatting cell data types.
  • Mathematical & Logical Formulas: Standard formulas (SUM, AVERAGE, MIN, MAX, COUNT, COUNTA), logical functions (IF, AND, OR).
  • Data Analysis Tools: Sorting datasets, multi-criteria filtering, data validation dropdown lists, lookup functions (VLOOKUP, XLOOKUP).
  • Data Visualization: Creating and customizing Column, Bar, Line, and Pie charts, chart elements, sparklines, printing setup (print titles, scaling).
• Key Practical Deliverable: Automated financial ledger with interactive lookup tables and customized charts.

CMP 105: Presentations – Microsoft PowerPoint

• Duration: 20 Hours
• Assessment Mode: Live Presentation
• Unit Overview: Visual slide deck creation, presenter techniques, and interactive presentation design.
• Detailed Topics:
  • Visual Slide Deck Design: Customizing Slide Master layouts, typography pairing, slide color themes.
  • Multimedia Integration: Embedding audio tracks, video clips, custom slide transitions, animation triggers.
  • Presentation Skills: Utilizing presenter view, slide navigation shortcuts, rehearsing timing, audience engagement techniques.
• Key Practical Deliverable: Live interactive presentation deck defense.

CMP 106: Database Fundamentals – Microsoft Access

• Duration: 20 Hours
• Assessment Mode: Practical Test
• Unit Overview: Relational database design, table relationships, user input forms, queries, and business reporting.
• Detailed Topics:
  • Relational Database Concepts: Tables, primary keys, foreign keys, field data types.
  • Form & Query Design: Designing user input forms, executing SELECT queries, filtering records.
  • Reporting: Generating clean business summary reports and formatted data outputs.
• Key Practical Deliverable: Functional relational database featuring custom input forms, queries, and reports.

CMP 107: Internet, Email & Online Services

• Duration: 15 Hours
• Assessment Mode: Continuous Assessment
• Unit Overview: Web research methods, digital communication etiquette, and cloud-based collaboration tools.
• Detailed Topics:
  • Web Navigation & Research: Advanced search engine techniques, search operators, evaluating online information sources.
  • Email & Workspace Collaboration: Professional email composition etiquette, CC/BCC protocols, calendar scheduling, Google Workspace (Docs, Sheets, Forms).
• Key Practical Deliverable: Cloud workspace setup, collaborative document editing, and formal email workflow execution.

CMP 108: Desktop Publishing & Graphic Documents

• Duration: 20 Hours
• Assessment Mode: Portfolio Project
• Unit Overview: Graphic layout principles, visual document creation, and print-ready publishing.
• Detailed Topics:
  • Graphic Design Principles: Contrast, repetition, alignment, proximity, color theory, typography pairing.
  • Document Production: Designing business cards, promotional flyers, brochures, certificates, event posters, and digital banners using MS Publisher and Canva.
  • Print Preparation: Page setup, bleed margins, high-resolution PDF export for professional print shop output.
• Key Practical Deliverable: Design portfolio containing print-ready business cards, event posters, and flyers.

CMP 109: Computer Maintenance & File Management

• Duration: 15 Hours
• Assessment Mode: Practical Lab Exercise
• Unit Overview: System maintenance routines, storage organization, backup management, and hardware troubleshooting.
• Detailed Topics:
  • File & Storage Management: USB drives, cloud synchronization (Google Drive / OneDrive), archiving.
  • System Maintenance & Troubleshooting: System updates, disk cleanup, defragmentation, safe hardware removal, peripheral troubleshooting.
• Key Practical Deliverable: Hands-on lab exercise executing system cleanup, backup procedures, and peripheral configuration.

CMP 110: Digital Literacy & Online Safety

• Duration: 15 Hours
• Assessment Mode: Written Test
• Unit Overview: Cybersecurity concepts, safe internet navigation, privacy settings, and online risk mitigation.
• Detailed Topics:
  • Online Security & Cyber Hygiene: Phishing detection, strong password management, two-factor authentication (2FA), malware protection, social engineering awareness.
  • Digital Citizenship: Data privacy regulations, copyright awareness, responsible digital communications.
• Key Practical Deliverable: Written examination on digital safety policies and threat identification.

CMP 111: Practical Computer Applications Capstone

• Duration: 20 Hours
• Assessment Mode: Final Capstone Portfolio
• Unit Overview: Comprehensive synthesis module where students produce a complete operational document kit for a business startup.
• Detailed Topics & Deliverables:
  • Multi-program project execution bringing together Word, Excel, PowerPoint, Access, and Desktop Publishing.
  • Deliverable 1: Formal Business Proposal & Services Contract (MS Word — formatted with TOC & Mail Merge).
  • Deliverable 2: Automated 12-Month Financial Budget & Expense Ledger (MS Excel — formatted with formulas & charts).
  • Deliverable 3: Client Pitch Presentation Deck (MS PowerPoint — custom animations & master layout).
  • Deliverable 4: Promotional Poster & Business Card (Desktop Publishing — high-resolution print PDF).
• Key Practical Deliverable: Complete Startup Business Document Package and oral presentation defense.

Career Opportunities After Computer Packages Training

✅ 1. Office Administrator / Secretary

• Managing documents, scheduling, and office communications using tools like MS Word, Excel, and Outlook.

✅ 2. Data Entry Clerk

• Entering, updating, and maintaining business data using Excel or Access.

✅ 3. Receptionist / Front Desk Assistant

• Handling customer inquiries, scheduling, and basic computer tasks.

✅ 4. Accounts Assistant

• Supporting finance departments using Excel for budgeting, invoicing, and record-keeping.

✅ 5. Customer Service Representative

• Using email and online tools to communicate with clients and resolve issues.

✅ 6. Sales & Marketing Assistant

• Creating presentations, reports, and marketing content using PowerPoint and basic graphic tools.

✅ 7. Typist / Transcriptionist

• Fast and accurate typing for business or medical/legal transcription tasks.

✅ 8. Administrative Assistant in NGOs or SMEs

• Supporting operational functions using computer skills in small organizations or community projects.

✅ 9. Cyber Café or IT Support Assistant

• Providing basic computer help, printing, scanning, and internet services.

Pathways to Advanced Careers (with Further IT Study):

Completing computer packages also opens doors to pursue specialized IT careers, such as:

• Web Developer

• Software Engineer

• Graphic Designer

• IT Support Technician

• Database Administrator

• Digital Marketer

• Network Administrator

• Data Analyst

Final Note:

Computer Packages training is more than just learning software—it's a gateway to numerous job roles and a launchpad for higher-level IT careers, especially in today's digital-driven economy.