Appearance
Computer Training & Digital Productivity
Go From Complete Beginner to Confident Workplace Professional in 8 Weeks: Master Windows, Touch Typing, MS Word, Excel, PowerPoint, Google Workspace, and Cyber Hygiene
8Weeks
4Stages
40Lessons
6Projects
0Prerequisites
Welcome to the Tech Minds Academy 8-Week (2-Month) Computer Training & Digital Productivity Programme. In every modern office, university, civil service ministry, hospital, school, NGO, and growing business across Nigeria and the world, confident computer fluency is non-negotiable. Designed specifically for complete beginners, secondary/university students, NYSC corps members, civil servants, administrators, and business owners, this hands-on programme at our Bwari, Abuja campus (G5 Plaza, Sabon-Gari Road) and Live Online guides you patiently from turning on a PC to producing polished reports, automated Excel budgets, executive slide decks, and secure cloud workflows.
TIP
Patient, Zero-Intimidation Learning: You do not need prior laptop experience to join. Every lesson is 100% practical—you learn with your hands on the keyboard alongside supportive instructors, graduating ready for immediate office employment or advanced tech tracks like Digital Marketing & SEO, Prompt Engineering & AI Tools, or HTML Mastery.
Programme Overview
| Attribute | Details |
|---|---|
| Programme Title | Computer Training, Office Suite Mastery & Workplace Digital Productivity |
| Duration | 8 Weeks / 2 Months (4 Practical Stages · 40 Instructor-Guided Lessons) |
| Delivery Modes | In-Person Practical Lab (Bwari, Abuja) & Live Online |
| Prerequisites | 0 Prerequisites — Designed from the ground up for absolute beginners and refreshers |
| Who Should Attend | Office & admin seekers, students/graduates, civil servants, teachers, entrepreneurs, and career switchers |
| Core Software Covered | Windows 11, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Google Docs/Sheets/Slides/Drive, Gmail, Canva |
| Portfolio Output | 6 Real-World Workplace Deliverables compiled into your Week 8 Digital Portfolio Capstone |
Curriculum Rationale
1. Confidence From Power-Button to Executive Workplace Output
Many people feel anxious around computers because nobody ever taught them how files, folders, extensions, and shortcuts actually work—forcing them to rely on cybercafés or colleagues for simple edits. Stage 1 permanently removes that anxiety by building clean file organisation, touch-typing speed, and keyboard shortcut muscle memory first.
2. Dual Fluency: Microsoft Office + Google Workspace
Government ministries, banks, and corporate offices rely daily on Microsoft Word, Excel, and PowerPoint, while modern remote companies, NGOs, and startups collaborate live inside Google Docs, Sheets, Slides, and Google Drive. Mastering both ecosystems side-by-side ensures you can walk into any workplace locally or internationally without hesitation.
3. Practical Cyber Hygiene & Everyday AI Productivity
Modern office workers are the #1 target of WhatsApp/email phishing scams, fake bank alerts, and USB malware—and those who know how to use AI assistants safely finish tasks twice as fast. Stage 4 equips you with practical two-factor authentication (2FA), scam detection, and responsible AI drafting workflows.
Stage 1: Computer Hardware, Windows OS & Typing Fluency (Weeks 1–2)
Goal: Operate Windows 11 smoothly, build clean touch-typing posture and speed, organise folders/PDFs like a professional, and master time-saving keyboard shortcuts.
Week 1: Computer Anatomy, Windows 11 Navigation & Touch Typing
| Lesson | Topic | Practical Skills Mastered |
|---|---|---|
| 1.1 | Understanding Computer Hardware & Ports | CPU, RAM vs SSD storage, battery care, USB-A/USB-C, HDMI projectors, Wi-Fi vs mobile hotspot tethering |
| 1.2 | Mastering Mouse, Trackpad & Windows 11 Desktop | Left-click, right-click context menus, double-click, two-finger scrolling, Start Menu, Taskbar, Settings, safe shutdown |
| 1.3 | Ergonomic Posture & Home-Row Touch Typing (ASDF / JKL;) | Correct wrist posture, finger placement without staring at keys, symbols (@, #, ₦, %, _), daily WPM drills |
| 1.4 | Managing Windows, Multitasking & Split-Screen | Snap Layouts (Win + Arrow), switching apps (Alt + Tab), Task Manager (Ctrl + Shift + Esc) for frozen apps |
| 1.5 | Installing Safe Software & Printer/Scanner Basics | Identifying trusted installers vs adware popups, Windows Update, printing to physical printers & Save as PDF |
Week 2: File Systems, Flash Drives, Cloud Backup & Shortcut Fluency
| Lesson | Topic | Practical Skills Mastered |
|---|---|---|
| 2.1 | File Explorer Mastery & Professional Naming Conventions | Drives (C:\), folders, paths, sorting by date/size, naming cleanly (2026-03_Invoice_Tech_Minds_Academy.pdf vs doc1_final_final.docx) |
| 2.2 | Understanding File Extensions | Knowing .docx, .xlsx, .pptx, .pdf, .jpg/.png, .mp4, and .zip at a glance (enabling File name extensions in Explorer) |
| 2.3 | Compressing .zip Archives, Flash Drives & Safe Ejection | Zipping and extracting multi-file attachments, transferring to USB drives safely, scanning external media |
| 2.4 | Everyday PDF Workflows & Screen Capture | Reading, merging, signing, and exporting PDFs cleanly; capturing crisp screenshots with Win + Shift + S |
| 2.5 | Web Browsers, Search Operators & Downloading Safely | Browser tabs, bookmarks, clearing cache, incognito mode, downloading official forms without clicking fake "Download" ads |
Project 1 (End of Week 2) — Structured Corporate Digital Filing Cabinet & Typing Milestone: Create a logically organised, multi-department folder hierarchy (Administration, Finance, HR, Client_Proposals), convert and .zip sample PDFs with clean ISO date naming, and pass your Week 2 touch-typing accuracy benchmark!
Cheat Sheet: Essential Workplace Keyboard Shortcuts (Windows)
| Shortcut | Action | Why Professionals Use It Daily |
|---|---|---|
Ctrl + C / Ctrl + X | Copy / Cut selected item | Duplicates or moves text, cells, and files cleanly |
Ctrl + V / Ctrl + Shift + V | Paste / Paste Plain Text | Pastes without bringing messy fonts/backgrounds from websites! |
Ctrl + Z / Ctrl + Y | Undo / Redo | Instantly reverses accidental deletions—never panic again |
Ctrl + S | Save current document | Protects your work every few minutes |
Ctrl + F | Find word on page/document | Jumps straight to any name or figure inside a 50-page PDF/sheet |
Ctrl + A | Select All | Highlights everything in the current document or folder |
Ctrl + P | Print / Export to PDF | Opens print preview and PDF setup immediately |
Alt + Tab | Switch Open Windows | Moves seamlessly between Excel, Word, and Chrome |
Win + E / Win + D | Open File Explorer / Show Desktop | Instant file access without hunting for icons |
Win + Shift + S | Snipping Tool Screenshot | Captures any exact rectangular region of your screen |
Win + L | Lock Computer Immediately | Essential security habit whenever stepping away from your desk |
Stage 2: Word Processing & Professional Documents — MS Word & Google Docs (Weeks 3–4)
Goal: Produce crisp, executive-grade letters, CVs, memos, academic projects, and multi-page business proposals—without broken spacing or manual formatting headaches.
Week 3: Document Setup, Typography, Styles & Tables in MS Word
| Lesson | Topic | Practical Skills Mastered |
|---|---|---|
| 3.1 | Page Setup, Margins, Orientation & Ruler Control | A4 vs Letter sizing (crucial for Nigerian printers!), custom margins, Portrait vs Landscape sections |
| 3.2 | Clean Typography, Paragraph Spacing & Indentation | Why you must never align text by pressing Spacebar 20 times! Line spacing (1.15 / 1.5), paragraph spacing, tabs |
| 3.3 | Using Built-In Heading 1, Heading 2 & Normal Styles | Styling entire documents consistently in one click and preparing automatic navigation outlines |
| 3.4 | Lists, Columns, Borders & Callout Boxes | Multi-level numbered clauses, clean bullet points, official letterhead borders |
| 3.5 | Designing Clean Word Tables & Embedding Images | Fee schedules, attendance sheets, repeating header rows across pages, text-wrapping logos (In Front of Text / Tight) |
Project 2 (End of Week 3) — ATS-Clean Professional CV & Tailored Cover Letter: Build a modern, recruiter-ready 1–2 page Curriculum Vitae and matching formal cover letter in Microsoft Word & Google Docs, exported as a crisp, hyperlinked .pdf.
Week 4: Long Reports, Auto Table of Contents, Mail Merge & Google Docs
| Lesson | Topic | Practical Skills Mastered |
|---|---|---|
| 4.1 | Page Breaks, Section Breaks, Headers & Footers | Ctrl + Enter page breaks, different first-page cover headers, Page X of Y numbering |
| 4.2 | Automatic Table of Contents (ToC), Footnotes & Citations | Generating and updating a clickable Table of Contents in 2 seconds whenever page numbers shift |
| 4.3 | Track Changes, Comments & Proofing Tools | Reviewing contracts/theses with Track Changes, accepting/rejecting edits, UK/Nigerian English spellcheck |
| 4.4 | Mail Merge for Bulk Letters & Certificates | Generating 50 personalised offer letters or certificates automatically from an Excel list |
| 4.5 | Real-Time Collaboration in Google Docs | Suggesting mode, @ action items, Version History recovery, offline mode, .docx ↔ Google Docs compatibility |
Project 3 (End of Week 4) — Multi-Page Formatted Business Proposal / Official Report: Author a complete 6-page business or NGO project proposal featuring a custom cover page, automatic Table of Contents, structured budget table, headers/footers, and print-ready PDF output.
Stage 3: Spreadsheets & Business Data — MS Excel & Google Sheets (Weeks 5–6)
Goal: Turn raw numbers into accurate budgets, payroll sheets, inventory trackers, automated lookups, and clear visual charts in Microsoft Excel and Google Sheets.
Week 5: Spreadsheet Structure, Formatting & Essential Formulas
| Lesson | Topic | Practical Skills Mastered |
|---|---|---|
| 5.1 | Workbook Anatomy: Cells, Ranges, Rows, Columns & Sheets | Cell coordinates (B4), ranges (B2:B25), AutoFill series, freezing header panes (Freeze Top Row) |
| 5.2 | Data Types & Currency/Date Formatting | Formatting Naira (₦#,##0.00), percentages, ISO dates, text-wrapping, avoiding merged-cell traps in data tables |
| 5.3 | Arithmetic Operators & Core Aggregation Functions | Writing `=SUM()`, `=AVERAGE()`, `=COUNT()`, `=COUNTA()`, `=MIN()`, and `=MAX()` |
| 5.4 | Relative vs Absolute Cell References (A2 vs $A$2) | Locking tax rates, commission percentages, or exchange-rate cells with F4 ($) when dragging formulas down |
| 5.5 | Sorting, Multi-Column Filtering & Excel Tables (Ctrl + T) | Converting raw lists into structured Tables with instant filter dropdowns, zebra striping, and Total Rows |
Week 6: Conditional Logic, Lookups, Charts & Print-Ready Budgets
| Lesson | Topic | Practical Skills Mastered |
|---|---|---|
| 6.1 | Logical Decisions with IF & Conditional Totals (SUMIF, COUNTIF) | Automating "Pass"/"Fail" or "Reorder Stock"/"OK" flags and summing expenses by category automatically |
| 6.2 | Data Validation Dropdowns & Conditional Formatting | Restricting status cells to clean dropdown lists (Paid, Pending, Overdue) with automatic green/amber/red highlights |
| 6.3 | Connecting Sheets with XLOOKUP & VLOOKUP + IFERROR | Pulling product prices or staff details automatically by ID code without manual copy-paste errors |
| 6.4 | Business Charts & Introductory PivotTables | Building clean Column, Line, and Donut charts + 60-second PivotTable sales summaries by month/branch |
| 6.5 | Google Sheets Live Sharing & Printing Wide Workbooks | Sharing view/comment links safely, fixing cut-off Excel printouts (Fit All Columns on One Page) |
Project 4 (End of Week 6) — Automated Monthly SME Inventory, Sales & Expense Tracker Workbook: Build a 3-sheet Excel / Google Sheets business workbook (Transactions, Inventory_Lookup, Executive_Dashboard) featuring data-validation dropdowns, SUMIF category breakdowns, XLOOKUP pricing, conditional low-stock alerts, and 2 visual charts.
Reference Table: Essential Workplace Excel & Google Sheets Formulas
| Business Question | Exact Formula Pattern | What It Calculates |
|---|---|---|
Total monthly sales in C2 through C31 | `=SUM(C2:C31)` | Adds every numeric value in the range |
| Average student/staff score | `=AVERAGE(D2:D40)` | Computes arithmetic mean of populated cells |
| Count how many invoices exist | `=COUNTA(A2:A100)` | Counts all non-empty invoice rows |
| Lowest & highest supplier quote | `=MIN(E2:E12)` / `=MAX(E2:E12)` | Returns smallest or largest figure instantly |
Apply locked 7.5% VAT cell in $H$1 | `=C2 * (1 + $H$1)` | $H$1 stays fixed when copied down 500 rows |
| Flag low stock under 10 units | `=IF(D2 < 10, "REORDER NOW", "In Stock")` | Displays automatic status warning |
Sum only "Transport" expenses | `=SUMIF(B2:B100, "Transport", E2:E100)` | Totals column E where category B matches "Transport" |
Look up unit price for item code in A2 | `=IFERROR(XLOOKUP(A2, Items!$A$2:$A$80, Items!$C$2:$C$80), "Not Found")` | Pulls exact price from Items sheet cleanly |
Stage 4: Presentations, Cloud Collaboration, AI Productivity & Cyber Hygiene (Weeks 7–8)
Goal: Deliver clean visual presentations, collaborate across Google Drive and professional email, leverage AI assistants responsibly, protect accounts against cyber scams, and graduate with a Workplace Digital Portfolio.
Week 7: Executive Presentations, Canva & Cloud Collaboration
| Lesson | Topic | Practical Skills Mastered |
|---|---|---|
| 7.1 | Designing Clean Slides (PowerPoint & Google Slides) | The 1-Idea-Per-Slide rule, visual hierarchy, Slide Master consistency, avoiding overcrowded walls of text |
| 7.2 | Visual Storytelling, Charts, Icons & Canva Integration | Designing crisp title graphics, flyers, and diagrams in Canva and embedding charts cleanly into decks |
| 7.3 | Presenter View, Speaker Notes & Confident Delivery | Using Presenter View on projectors/Zoom/Google Meet, subtle transitions, exporting PDF handouts |
| 7.4 | Cloud Storage & Google Drive / OneDrive Permissions | Organising shared team folders; understanding Restricted vs Anyone with the link: Viewer / Commenter / Editor |
| 7.5 | Professional Email & Calendar Etiquette (Gmail / Outlook) | Clear subject lines, To vs Cc vs Bcc privacy, professional signatures, scheduling Google Calendar + Meet invites |
Project 5 (End of Week 7) — 10-Slide Executive Pitch / Project Presentation Deck: Design and present a visually clean 10-slide PowerPoint or Google Slides deck (incorporating charts from your Week 6 Excel workbook), shared via properly permissioned Google Drive links.
Week 8: Workplace AI Productivity, Cyber Hygiene & Portfolio Capstone
| Lesson | Topic | Practical Skills Mastered |
|---|---|---|
| 8.1 | Everyday AI Productivity Assistants (ChatGPT, Claude, Gemini) | Drafting polite emails, summarising meeting notes, explaining tricky Excel formulas—while fact-checking and never pasting confidential client/bank data |
| 8.2 | Password Security & Two-Factor Authentication (2FA) | Creating strong passphrases, password managers, enabling authenticator-app 2FA on Gmail, WhatsApp (Two-Step PIN), and work accounts |
| 8.3 | Spotting Phishing Emails, Fake Bank/BVN Alerts & Job Scams | Checking real sender domains, lookalike URLs, urgent payment/OTP social engineering traps, safe Wi-Fi habits |
| 8.4 | Backing Up Critical Work (3-2-1 Rule) | Protecting documents against laptop theft, hardware failure, or ransomware using automatic cloud sync + external backup |
| 8.5 | Workplace Digital Portfolio Capstone Review & Graduation | Final verification, live presentation, and certificate award |
Project 6 (Week 8 Capstone) — Complete Workplace Digital Portfolio Pack: Assemble, polish, and present a cohesive, employer-ready cloud folder containing:
- Organised multi-department folder structure & naming standard,
- ATS-ready Professional CV & Cover Letter (
.docx+.pdf), - Formatted 6-page Business/Project Proposal with automatic Table of Contents,
- Automated 3-sheet Excel / Google Sheets SME Budget & Inventory Workbook, and
- 10-Slide Executive Presentation Deck—all secured behind a
2FA-protected account and presented live!
Assessment & Grading Breakdown
| Assessment Component | Weight | Evaluation Criteria |
|---|---|---|
| Weekly Practical Lab Exercises & 5 Stage Projects | 40% | Touch-typing progress, file organisation hygiene, Word style discipline, working Excel formulas, and clean slide layouts |
| Mid-Programme Practical Office Task Assessment | 30% | Timed, open-software workplace simulation: formatting a messy report, building an Excel expense summary, and sending a formal attachment |
| Week 8 Workplace Digital Portfolio Capstone | 30% | Polish, accuracy, cloud-sharing permissions, cyber-hygiene checklist completion, and 10-minute presentation |
Learning Outcomes
Graduates of the Tech Minds Computer Training & Digital Productivity programme can:
- Operate Windows 11 & Files Effortlessly: Navigate Windows settings, manage files/folders/ZIPs/PDFs cleanly, type with speed and posture, and use essential keyboard shortcuts by instinct.
- Author Executive Documents (
MS Word&Google Docs): Format CVs, official letters, tables, mail merges, and multi-page reports with automatic Tables of Contents and print-ready PDF exports. - Analyse Business Numbers (
MS Excel&Google Sheets): Build clean budgets, payrolls, and inventory sheets usingSUM,AVERAGE,IF,SUMIF,XLOOKUP, conditional formatting, and charts. - Present & Collaborate in the Cloud: Create clear PowerPoint/Google Slides/Canva decks, manage Google Drive sharing permissions safely, and write professional workplace emails.
- Work Safely & Productively Online: Use AI tools responsibly to accelerate daily writing, secure accounts with
2FA, and spot phishing, WhatsApp hijacking, and financial scams immediately.
Tools, Platforms & Resources
| Category | Software & Tools | Purpose in Curriculum |
|---|---|---|
| Operating System & Typing | Microsoft Windows 11, Keybr / TypingClub | OS navigation, file management, touch-typing speed & accuracy |
| Word Processing | Microsoft Word & Google Docs | Letters, CVs, proposals, automatic Tables of Contents, collaborative editing |
| Spreadsheets & Data | Microsoft Excel & Google Sheets | Business budgets, inventory tracking, formulas, lookups, charts |
| Presentations & Design | Microsoft PowerPoint, Google Slides, Canva | Executive slide decks, visual reports, clean workplace graphics |
| Cloud, Comms & Safety | Google Drive, Gmail, Google Calendar/Meet, Authenticator 2FA | Cloud backup, permission control, workplace email, account security |
Where Can You Go After Graduating?
Once you complete your 8-week foundation, every career track at Tech Minds Academy is open to you:
- Automate Office & Business Workflows with AI: Step directly into Prompt Engineering & AI Tools (14 Weeks).
- Grow Businesses Online: Launch a career in Digital Marketing, SEO & Growth (12 Weeks).
- Start Coding Websites or Data Analytics: Enrol in HTML Mastery (12 Weeks) or Python, Data Science & Machine Learning (14 Weeks).
- Explore All Courses & Pathways or download syllabi on the 2026 Curricula PDFs page!