Valuemax Tech Academy

Foundational
Computer
Training

A VTA Outline — Revised & Expanded Edition
Valuemax Tech Academy
28
Days
3
Phases
7
New Modules
1
Capstone
Phase 1: Hardware & OS — Days 1–5 Phase 2: Microsoft Office — Days 6–20 Phase 3: Online World & AI — Days 21–28

★ New Modules Added: Mail Merge & Templates · Advanced Tables · Command Line · Typing Speed · PDF Tools · Outlook & Teams · Data Privacy · LinkedIn & Job Boards · Troubleshooting

Table of Contents

Phase 1 — Hardware, OS & System Management
Phase 2 — Microsoft Office
Phase 3 — The Online World & AI

Phase 1 — Hardware, OS & System Management

Days 1–5 · Building the foundational understanding of what a computer is, how it works, and how to manage it — including the command line and troubleshooting

Day 01

Computer Appreciation & Architecture

The 5W's and H of computers, career paths, system components, and memory vs. storage

The 5W's and H — Why You Are Here

Before touching a keyboard, every student must understand why they are learning. The answers to these six questions build the motivation and context for everything that follows in the course.

QuestionAnswer
WHAT is a computer used for?Processing data into useful information. Creating documents, spreadsheets, presentations, websites, and databases. A computer transforms raw input into meaningful output that helps people work, learn, communicate, and decide.
WHY do we use computers?Speed — a computer performs millions of calculations per second. Accuracy — it doesn't get tired or make arithmetic errors. Storage — billions of files in the same device. Automation — repetitive tasks done without human effort every time.
WHEN do we use computers?In virtually every modern activity: writing letters, managing money, designing buildings, treating patients, teaching students, running businesses, shopping, banking, and communicating across continents. The honest answer is: almost always.
WHO uses computers?Everyone from students doing homework to doctors viewing X-rays, engineers designing bridges, bankers processing transactions, farmers checking weather forecasts, and artists creating digital illustrations.
WHERE — Career PathsProgramming · Web Design · Data Analytics · Networking · Cybersecurity · Digital Marketing · Graphic Design · Accounting & Finance · Healthcare IT · Education Technology · Content Creation
HOW does a computer work?The IPO cycle: Input → Processing → Output → Storage. Data enters through input devices (keyboard, mouse), the CPU processes it according to software instructions, results appear through output devices (screen, printer), and data is saved in storage for later use.
System Architecture

The Motherboard is the main circuit board — every other component connects to it. Think of it as a city's road network. The CPU (Central Processing Unit) is the brain — it executes every instruction from every program. Speed is measured in GHz (gigahertz). More GHz means faster processing. The Power Supply Unit (PSU) converts mains electricity (240V AC in Nigeria) to the low-voltage DC that computer components need. Without the PSU, nothing runs.

Form FactorKey CharacteristicsBest For
DesktopMost powerful, upgradeable, requires external monitor/keyboardOffice work, gaming, graphics, video editing
LaptopPortable, battery-powered, components are smallerMobile workers, students, field staff
TabletTouch-screen focused, no physical keyboard by defaultMedia consumption, presentations, light work
SmartphoneFits in a pocket, always connected, limited screenCommunication, browsing, mobile apps
SmartwatchWorn on the wrist, notifications, fitness trackingHealth monitoring, quick notifications
Memory vs. Storage — A Critical Distinction

RAM (Memory) is volatile — it holds data only while the computer is on. When you shut down, everything in RAM disappears. RAM is the computer's "working desk" — it holds everything you are currently working on. More RAM means more programs can run simultaneously without slowdown.

Storage (HDD or SSD) is permanent — data stays here even when the power goes off. Your files, programs, and the operating system all live in storage. It is the computer's "filing cabinet." The difference between HDD and SSD is that HDD uses spinning magnetic platters (slower, fragile, cheap) while SSD uses flash memory chips (faster, durable, more expensive).

✅ Analogy: RAM is your desk. You work on things on the desk. Storage is your filing cabinet — you file things away when done. A bigger desk (more RAM) lets you work on more things simultaneously. More filing cabinets (more storage) means more files saved permanently.
Day 02

Peripherals & Physical Setup

Connecting and configuring input/output devices, identifying ports, and setting up wireless connections

Input vs. Output Devices

Input devices send data into the computer. Output devices deliver processed results out of the computer. Some devices do both (e.g. a touchscreen both receives touch input and displays output). Knowing which is which helps you troubleshoot connections and understand data flow.

DeviceTypeWhat It DoesCommon Connection
KeyboardInputSends keystrokes as text and commandsUSB or Bluetooth
MouseInputTranslates physical movement into cursor movement on screenUSB or Bluetooth
MonitorOutputDisplays visual output from the graphics cardHDMI, VGA, DisplayPort
PrinterOutputConverts digital documents to paperUSB or Wi-Fi
ScannerInputConverts physical documents to digital imagesUSB or Wi-Fi
WebcamInputCaptures live video for calls and recordingsUSB or built-in
SpeakersOutputConverts digital audio signals to sound waves3.5mm jack, USB, or Bluetooth
Port Identification
PortShapeUsed ForKey Fact
USB-ARectangular, flatFlash drives, mice, keyboards, chargingHas a right side — only inserts one way. Most common port on desktops.
USB-CSmall, oval, reversibleNew phones, laptops, fast charging, data transferNo "wrong way" — inserts either direction. Supports up to 100W power delivery.
HDMITrapezoidal, 19 pinsMonitors, TVs, projectorsCarries both video AND audio in one cable. Standard for all modern displays.
VGABlue, 15-pin D-shapeOlder monitors and projectorsAnalogue signal, video only, being phased out. Still common on older projectors.
Ethernet (RJ-45)Wide, 8-pinWired internet connectionMore reliable and faster than Wi-Fi. Essential for stable video calls and critical work.
Audio Jack (3.5mm)Small, round, 3 or 4 ringsHeadphones, external speakers, microphoneColour-coded on desktop PCs: green = audio output (speakers/headphones); pink/red = microphone input. Modern laptops use a single combo jack for both.
Wireless & Portable Storage Technologies

Not all connections use physical cables. Modern computers communicate wirelessly using radio signals. Understanding these helps you set up devices and troubleshoot connectivity issues.

TechnologyRangeUse CasesKey Points
Wi-FiUp to 50–100m indoorsConnecting to a router for internet access without cablesSpeed and stability depend on proximity to the router and number of devices sharing the signal. 2.4GHz band: longer range, slower. 5GHz band: shorter range, faster. Always use a secured (password-protected) Wi-Fi network; avoid open/public hotspots for sensitive work.
BluetoothUp to 10mShort-range wireless: headsets, mice, keyboards, file transfer between phone and PCPair once — the devices remember each other and reconnect automatically. Turn Bluetooth off when not in use to save battery and prevent unauthorised pairing.
USB Flash DrivePhysical — no wireless signalPortable storage for carrying files between computers and locationsThe most common portable storage device. Always eject safely before removing to avoid data corruption (see below).

Safely ejecting USB devices is not optional. A USB drive has a write buffer — data may still be in transit to the drive even after the copy progress bar finishes. Pulling it out without ejecting can corrupt the data being written. Always right-click the USB drive in File Explorer → "Eject," or click the USB icon in the system tray → "Safely Remove Hardware," before physically unplugging.

Day 03

The OS Environment & Navigation

Understanding operating systems, mastering the Windows desktop, and interpreting power states

What is an Operating System?

The Operating System (OS) is the most important software on a computer. It sits between the hardware and all applications — it manages CPU time, RAM allocation, storage access, and all devices, and provides the platform that every other program runs on. Without an OS, a computer is just expensive hardware doing nothing. Think of it as the manager of an office building — every worker (program) goes through the manager for resources; no worker touches the electricity or plumbing directly.

OSUsed OnStrength
Windows (Microsoft)Desktops, LaptopsWidest software compatibility, dominant in offices, schools, and businesses worldwide
macOS (Apple)Mac computers onlySmooth hardware-software integration, favoured by creatives and design professionals
LinuxServers, developer machinesFree, open-source, extremely powerful. Powers ~95% of the world's servers
Android (Google)Smartphones, TabletsMost widely used mobile OS globally, highly customisable
iOS (Apple)iPhone, iPadSmooth and secure, tightly integrated with Apple services
Power States — Understanding Shutdown, Sleep & Hibernate
StateWhat HappensWhen to UsePower Used
ShutdownAll programs close, RAM is cleared, system fully powers offEnd of day, before moving equipment, before hardware changesZero
Restart / Warm BootOS closes all programs, clears RAM, and reloads without cutting full powerAfter installing software, after updates, when system is behaving oddlyZero (brief)
SleepCurrent state saved to RAM, most components power off. Wakes in seconds.Short breaks. Quick to resume but loses data if power cutsVery low
HibernateCurrent state saved to hard drive, then fully powers off. Takes longer to resume.Long breaks, closing laptop when battery is low, travelingZero
Cold BootPower was completely off. Loads BIOS, then OS from storage into RAM from scratchStarting the day or after a full shutdownN/A (starting)
Day 04

Advanced File Management

Organising, moving, naming, compressing, and finding files with confidence

The File System Hierarchy

Windows organises all storage in a tree hierarchy. Everything starts from drives (C:, D:), which contain folders, which contain sub-folders, which contain files. The most common beginner mistake is saving a file and not knowing where it went — because they never understood where "Documents" lives in the tree. Standard path: This PC → Drive C: → Users → [Your Name] → Documents. Read this path in the address bar of File Explorer at all times.

File extensions identify the file type. .docx = Word document. .xlsx = Excel spreadsheet. .pdf = PDF document. .jpg/.png = image files. .mp4 = video. .exe = executable program. Windows may hide extensions by default — enable them: View → Show → File name extensions.

File Operations & Keyboard Shortcuts
Ctrl+CCopy selected file
Ctrl+XCut (move) selected file
Ctrl+VPaste copied/cut file
DeleteSend to Recycle Bin
Shift+DelPermanently delete (skips Bin)
F2Rename selected file
Ctrl+ZUndo last file operation
Ctrl+ASelect all files in folder
Win+EOpen File Explorer
Ctrl+FFind / search within a folder or document

Batch renaming: Select all files → press F2 → type the new base name → press Enter. Windows automatically appends (1), (2), (3) etc. to each file. Essential for organising photos, scan batches, and downloaded documents.

Zip/Compress: Select files → right-click → "Send to" → "Compressed (zipped) folder." The zip reduces file sizes (sometimes 50–80% for text files) and combines many files into one — ideal for emailing multiple documents. To extract: right-click the .zip → "Extract All."

Day 05

System Management, Tools, Command Line & Troubleshooting NEW

Control Panel, Task Manager, built-in utilities, terminal basics, and the structured approach to fixing problems

Control Panel & Settings

The Settings app (modern, simplified) and Control Panel (older, more detailed) are where you configure everything about Windows. Key settings: Display Resolution — always use "Recommended" for your monitor. Sound — configure default playback and microphone devices. Date & Time — enable "Set time automatically" and choose the correct time zone (West Africa Time, UTC+1 for Nigeria). An incorrect system clock breaks SSL certificates and software licences.

Bluetooth — Settings → Bluetooth & devices → toggle On to pair wireless headsets, mice, and keyboards. Once paired, devices reconnect automatically. Turn Bluetooth off when not in use to prevent unauthorised pairing and save battery. Wi-Fi — Settings → Network & Internet → Wi-Fi. Connect to networks, view saved connections, and use Forget to remove networks you no longer use. Enable Metered connection on limited data plans to stop Windows downloading large updates automatically.

User accounts: An Administrator can install software, change system settings, and access all files. A Standard User can use programs and save personal files but cannot install software or change system-wide settings. Always use a Standard account for daily work and the Administrator account only when installing or configuring. A strong password has 12+ characters, mixing uppercase, lowercase, numbers, and symbols — e.g. Vm@Lagos2024!

Software Lifecycle — Install, Update & Uninstall

Managing programs correctly prevents your computer slowing down over time. There are three stages to every program's life on your PC:

Installing: Run the installer file (.exe or .msi). Always download software from the official website only — not third-party download sites which may bundle malware. During installation, read each screen and decline any optional bundled software or toolbars that are pre-ticked.

Updating: Keep software and drivers current. Settings → Windows Update ensures the OS has the latest security patches. For installed apps: open the program → Help → Check for Updates. Driver updates — for printers, graphics cards, and webcams — come from the hardware manufacturer's website or via Device Manager (right-click Start → Device Manager → right-click the device → Update driver).

Uninstalling properly: Never delete a program by dragging it to the Recycle Bin or deleting its folder — this leaves behind registry entries, configuration files, and startup entries that accumulate and slow Windows down. Always uninstall via: Settings → Apps → Installed Apps → find the program → Uninstall. This runs the program's own remover and cleans up all associated files.

Task Manager — Your Diagnostic Dashboard

Ctrl + Shift + Esc opens Task Manager instantly. When a program freezes, find it in the Processes tab → right-click → End Task. This closes the frozen program without restarting the entire computer.

The Performance tab shows real-time graphs. CPU at 100% means a program is overworking the processor — find it in the Processes tab sorted by CPU. RAM at 100% causes severe slowdown — close unnecessary programs. Disk at 100% often indicates Windows is indexing or updating — usually resolves itself.

Built-in Windows Utilities
UtilityWhat It DoesBest Used For
NotepadPlain text editor, no formatting, saves as .txtQuick notes, editing config files, viewing raw data
WordPadBasic word processor with formatting, saves as .rtf or .docxQuick formatted documents without Word installed
Snipping ToolCaptures any region of the screen as an imageScreenshots, capturing error messages, documenting steps
Paint / Paint 3DBasic image editingCropping screenshots, annotating images, simple diagrams
Sticky NotesDigital Post-it notes on the DesktopQuick reminders, to-do lists visible while working
CalculatorStandard, scientific, programmer, and date calculation modesQuick maths, unit conversions, programmer's binary/hex
Voice RecorderRecords audio through the PC microphone. Files saved as .m4a audioRecording lectures, meetings, interview notes, and quick verbal memos

The Command Line / Terminal — What It Is and Why It Matters NEW

The Command Line (also called the Terminal or Command Prompt) is a text-based interface for communicating with your computer. Instead of clicking icons and menus, you type instructions as text commands and the computer responds with text output.

This feels intimidating at first but is one of the most important skills for anyone serious about computers. Every technology career — web development, data analytics, networking, cybersecurity, system administration — uses the command line daily. It is faster than clicking for many tasks, can be automated and scripted, and gives you access to powerful system functions that have no graphical equivalent.

On Windows, the primary tools are Command Prompt (cmd) and PowerShell. On Mac and Linux it is the Terminal. In this course, we focus on Windows Command Prompt as the entry point.

Opening the Command Prompt

There are three ways to open Command Prompt on Windows:

When it opens, you see a black window with a flashing cursor, showing something like: C:\Users\YourName> This is called the prompt. It tells you two things: the drive you are on (C:) and your current location in the folder tree (Users\YourName). Every command you type is run from this location.

Navigation Commands — Moving Around the File System

The most essential skill in the command line is navigation — moving between folders (called "directories" in terminal language). These three commands cover 80% of all navigation you will ever do.

Navigation — Moving around folders C:\Users\Tope> dir Lists all files and folders in the current directory Volume in drive C has no label. Directory of C:\Users\Tope 25/03/2026 09:14 <DIR> Desktop 25/03/2026 09:14 <DIR> Documents 25/03/2026 09:14 <DIR> Downloads 3 Dir(s) 45,678,123 bytes free C:\Users\Tope> cd Desktop cd = "change directory" — moves INTO the Desktop folder C:\Users\Tope\Desktop> Notice the prompt updated to show our new location C:\Users\Tope\Desktop> cd .. Two dots = go UP one level (back to Tope folder) C:\Users\Tope> C:\Users\Tope> cd C:\Windows Navigate to a completely different location using full path C:\Windows> C:\Windows> cls Clears the screen — removes all previous output
File & Folder Operations
Creating and managing files from the command line C:\Users\Tope\Desktop> mkdir MyProject mkdir = make directory (create a new folder) C:\Users\Tope\Desktop> mkdir MyProject\Reports Create a folder INSIDE another folder C:\Users\Tope\Desktop> copy report.docx MyProject Copy a file into the MyProject folder C:\Users\Tope\Desktop> move report.docx MyProject Move (not copy) a file — original is removed C:\Users\Tope\Desktop> rename report.docx final_report.docx Rename a file C:\Users\Tope\Desktop> del old_file.txt Delete a file permanently (does NOT go to Recycle Bin) C:\Users\Tope\Desktop> rmdir MyProject Remove an EMPTY folder C:\Users\Tope\Desktop> rmdir /s MyProject /s removes folder AND all its contents (careful!)
System Information Commands
Diagnosing your computer and network from the command line C:\Users\Tope> ipconfig Shows your IP address, subnet mask, and default gateway IPv4 Address. . . . . . . . . . . : 192.168.1.105 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : 192.168.1.1 C:\Users\Tope> ipconfig /all Shows full network details including MAC address C:\Users\Tope> ping google.com Tests internet connectivity by sending packets to Google Pinging google.com [142.250.185.78]: Reply from 142.250.185.78: bytes=32 time=25ms TTL=117 If you get "Request timed out" — your internet is not working C:\Users\Tope> systeminfo Full computer specs: OS version, RAM, CPU, last boot time C:\Users\Tope> tasklist Lists all currently running programs (like Task Manager) C:\Users\Tope> shutdown /s /t 60 Schedule shutdown in 60 seconds (/t 0 = immediately) C:\Users\Tope> shutdown /a Abort (cancel) a scheduled shutdown C:\Users\Tope> help Lists all available commands with descriptions C:\Users\Tope> dir /? Get help for a specific command — replace dir with any command
💡 Press the Up arrow key to cycle through previously typed commands — you don't have to retype them. Press Tab to auto-complete folder and file names as you type.
⚠️ Commands like del, rmdir /s, and shutdown have immediate consequences with no confirmation dialogs. Think before pressing Enter. You cannot undo a del from the command line — the file does not go to the Recycle Bin.

Basic Troubleshooting Methodology — Solving Problems Confidently NEW

Troubleshooting is a structured thought process, not a panicked clicking of everything on screen. Professional IT staff follow the same mental framework every time, which is why they can solve problems that seem mysterious to others. By learning this framework, any student can resolve 70–80% of common computer problems on their own.

The core principle is isolate → test → resolve. First understand exactly what the problem is. Then identify what changed. Then test solutions from simplest to most complex, one at a time.

The Troubleshooting Framework — 6 Steps
StepActionWhy This Step
1. Define the ProblemWrite down exactly what is happening. What did you try to do? What happened instead? What error message appeared (screenshot it)?Vague problems cannot be solved. "The computer is not working" is useless. "Internet Explorer closes immediately when I click a PDF link" is a solvable problem.
2. Reproduce ItTry to make the problem happen again deliberately. Does it happen every time, or only sometimes? Does it happen in a different program?A problem you can reproduce consistently is much easier to diagnose than a random one. If it only happens in one program, the problem is that program, not the computer.
3. Restart FirstRestart the affected program first. If that fails, restart the computer. Do not skip this step.Restarting clears RAM, resets software states, and resolves about 40% of all common problems instantly. It is not "giving up" — it is the most efficient first step.
4. Check the ObviousIs it plugged in? Is the cable seated properly? Is Wi-Fi enabled? Is the Caps Lock on? Is the volume muted? Is the file in the expected location?The most common cause of problems is the simplest explanation. Before investigating complex solutions, eliminate the obvious ones.
5. Search OnlineCopy the exact error message → paste it into Google with the program name. Add your Windows version if relevant. Read 2–3 results.Almost every common error has been solved by someone else and documented online. Learning to search effectively for technical solutions is itself a professional skill.
6. Escalate with EvidenceIf you cannot solve it, report to IT support with: what you were doing, the exact error message (screenshot), what you already tried, and when it started.Good escalation saves the support person time and shows you are competent. "My computer broke" wastes everyone's time. "Outlook shows error 0x800CCC0F since this morning after an update, restarting did not help, here is a screenshot" gets it fixed fast.
Common Problems & Solutions
ProblemLikely CauseSolution Steps
Computer is very slowToo many programs running, low RAM, full hard drive, malware1. Open Task Manager — identify high CPU/RAM processes. 2. Close unused programs. 3. Check disk space (right-click C: → Properties). 4. Run Windows Defender scan. 5. Restart.
Wi-Fi is not connectingRouter issue, Windows network adapter, wrong password, IP conflict1. Check if others can connect (if not, it's the router — restart it). 2. Forget the network and reconnect. 3. Run ipconfig /release then ipconfig /renew in cmd. 4. Update network adapter driver.
USB device not recognisedDriver issue, faulty cable/port, device not formatted for Windows1. Try a different USB port. 2. Try a different cable. 3. Try the device on another computer. 4. Open Device Manager → look for yellow warning icon → Update driver.
Printer offline / won't printPrinter not set as default, print queue stuck, driver issue1. Check the printer is on and connected. 2. Open Printers in Settings → right-click → "Set as default." 3. Open the print queue and cancel all stuck jobs. 4. Restart the Print Spooler service (services.msc → Print Spooler → Restart).
Program not respondingProgram crashed, infinite loop, memory issue1. Wait 30 seconds (it may self-resolve). 2. Ctrl+Shift+Esc → find program → End Task. 3. If it keeps crashing, uninstall and reinstall the program.
Blue Screen of Death (BSOD)Driver crash, hardware fault, RAM issue, overheating1. Note the error code displayed. 2. Restart — if it only happened once, likely a one-off. 3. Search the error code online. 4. If recurring, run Windows Memory Diagnostic (search in Start). 5. Update or roll back recent drivers.
Device Manager — Hardware Diagnostics

Device Manager shows every hardware component in the computer and its status. A yellow warning triangle (⚠️) next to a device means it has a driver problem — the software that lets Windows communicate with that hardware is missing, outdated, or corrupted. To open: right-click Start → Device Manager, or search "Device Manager" in the Start Menu. To fix a driver problem: right-click the flagged device → Update driver → Search automatically. If that fails: note the device name → visit the manufacturer's website → download the correct driver manually.

✅ The most important troubleshooting tool is a calm, methodical mind. Computer problems are never random — they always have a cause. Your job is to find the cause by testing, not by panicking and clicking everything at once.

✏️ Day 5 Exercise

  1. Open Command Prompt and navigate to your Desktop using cd. Create a folder called "CMD_Practice" using mkdir. Navigate into it. Create two more sub-folders. List them with dir. Navigate back to Desktop.
  2. Run ipconfig and write down your IPv4 address. Run ping google.com and record the average response time.
  3. Open Task Manager → Performance tab. Screenshot the CPU and RAM graphs. Identify the three processes using the most memory.
  4. Scenario exercise: Your printer is showing "offline." Walk through all six troubleshooting steps out loud, documenting what you would check at each step.

Phase 2 — Microsoft Office

Days 6–20 · Mastering the world's most widely-used productivity suite — including touch-typing speed, professional document tools, and PDF management

📝

Microsoft Word — Days 6–13

Professional document creation, formatting, layout, mail merge, templates, advanced tables, collaboration, and PDF tools

Day 06

Keyboard Proficiency, Touch-Typing Speed & Home Ribbon NEW

Building keyboard fluency, setting a professional typing speed target, and mastering core formatting tools

Why Typing Speed Matters — The Career Case NEW

Most people dramatically underestimate how much of their working day involves typing. A data entry clerk, customer service agent, teacher, accountant, or executive will spend 2–6 hours per day typing. At 15 words per minute (WPM) — which is typical for a two-finger typist — typing a 1,000-word report takes over an hour. At 40 WPM (the professional minimum), the same report takes 25 minutes. At 70 WPM, it takes under 15 minutes. Over a year, the faster typist saves hundreds of hours.

More importantly, slow typing breaks your thinking. When you are hunting for each letter, your cognitive focus is on the keyboard, not on the content you are writing. Fast touch-typists keep their eyes on the screen — their thinking flows directly onto the page. This is why professional writers, programmers, and executives who handle large volumes of communication almost universally type with all ten fingers without looking.

Touch-typing means typing without looking at the keyboard, using all ten fingers, each assigned to specific keys. It feels difficult at first because you are unlearning old habits, but the learning curve is short. Most people reach 30 WPM within 2–3 weeks of consistent 20-minute daily practice.

Professional Typing Speed Standards
Under 20 WPMBeginnerSignificantly below standard
20–34 WPMLearningBelow professional threshold
35–49 WPMOffice ReadyMinimum for employment
50–70 WPMProfessionalExpected in most office roles
70+ WPMExpertSecretaries, journalists, developers
🎯 Course Target: Every student should achieve at least 35 WPM with 95%+ accuracy before completing this course. This is the minimum threshold for professional office employment in 2026.
Touch-Typing Technique — The Home Row Method

The home row is the middle row of the keyboard: A S D F G H J K L ;. This is where your fingers rest when not typing. Your left hand covers A-S-D-F, your right hand covers J-K-L-;, and each thumb rests on the spacebar. The two raised bumps on the F and J keys are the tactile home markers — you can find home position without looking.

Each finger is responsible for specific keys. Your left index finger covers F, G, R, T, 4, 5, V, B. Your right index finger covers J, H, Y, U, 6, 7, N, M. Each finger stretches up and down from its home position to reach assigned keys, then returns. This is the mechanical foundation — once it becomes automatic through practice, your fingers find the right keys by muscle memory, not by sight.

FingerHome KeyResponsible Keys (approx.)
Left Little (Pinky)AA, Q, Z, Shift, Caps Lock, Tab
Left RingSS, W, X
Left MiddleDD, E, C
Left IndexFF, G, R, T, V, B, 4, 5
Both ThumbsSpaceSpacebar — alternating thumbs after each word
Right IndexJJ, H, Y, U, N, M, 6, 7
Right MiddleKK, I, ,
Right RingLL, O, .
Right Little (Pinky);; , P, ' , /, Shift, Enter, Backspace
Free Practice Tools — Daily Habit
ToolWebsiteBest For
Keybr.comkeybr.comStructured learning — introduces new keys gradually as you master existing ones. Best for complete beginners learning touch-typing from scratch. Tracks your progress over time.
TypingClubtypingclub.comGamified lessons with step-by-step finger placement guidance. Excellent for students who prefer a course-style progression with levels.
10FastFingers10fastfingers.comSpeed tests using the 200 most common English words. Shows WPM and accuracy. Good for measuring current speed and competing against personal bests.
Monkeytypemonkeytype.comClean, customisable speed tests. Professional preference among developers and advanced typists.
💡 Practice Protocol: 20 minutes of focused practice every day beats 2 hours once a week. Practise at the start of each computer session before opening Word or any other application. Slow down when making errors — accuracy first, speed follows.
Keyboard Layout — Every Key Explained
KeyFunction
Caps LockToggles ALL LETTERS to uppercase. Use Shift for individual capitals — do not use Caps Lock to capitalise one word.
TabMoves cursor right by one tab stop (usually 1.27cm in Word). Indents paragraphs. Also cycles through form fields.
FnFunction modifier on laptops. Hold Fn + F-key to access secondary laptop functions (brightness, volume, etc.).
CtrlThe most important modifier key. Ctrl + letter = dozens of shortcuts. Ctrl+S=Save, Ctrl+C=Copy, Ctrl+Z=Undo.
AltActivates menu shortcuts. Alt+F4 = close window. Alt+Tab = switch between open programs.
ShiftCapitalises single characters. Holds while pressing arrows to select text. Accesses top symbols on number keys (! @ # $ etc.).
Win KeyOpens Start Menu. Win+D=Desktop. Win+L=Lock screen. Win+E=File Explorer. Win+R=Run dialog.
F1–F12F1=Help. F2=Rename. F5=Refresh/Find in browser. F7=Spell check. F11=Full screen. F12=Save As in Office.
Core Formatting — Home Ribbon

The Home Ribbon contains tools used in every Word session. Font group: change face, size, colour, bold, italic, underline, highlight. Paragraph group: alignment, line spacing, bullets, numbering, indentation. Format Painter — the paintbrush icon — copies ALL formatting from selected text and applies it wherever you click next. Double-click Format Painter to keep it active for multiple targets; press Escape to release.

Find and Replace (Ctrl+H) is indispensable. If a client's name changed in a 50-page document, Find "Old Name" → Replace with "New Name" → Replace All fixes every occurrence instantly.

Ctrl+BBold
Ctrl+IItalic
Ctrl+UUnderline
Ctrl+ECentre align
Ctrl+LLeft align
Ctrl+JJustify text
Ctrl+HFind & Replace
Ctrl+ZUndo
Ctrl+YRedo
Ctrl+SSave

✏️ Day 6 Exercise

  1. Visit keybr.com and complete the first three lessons. Record your starting WPM and accuracy. Take a screenshot of your results.
  2. Take the 10FastFingers one-minute typing test. Record your WPM and accuracy. This is your Day 1 baseline.
  3. Type a full-page business letter in Word using only keyboard shortcuts for formatting — no toolbar clicks. Use Ctrl+B for the heading, Ctrl+J for body text, Ctrl+E for the date line.
  4. Practice goal: achieve at least 5 WPM improvement over your baseline by Day 10. Track your score each day.
Day 07

Insert Ribbon — Structuring Documents

Cover pages, page breaks, headers, footers, tables, hyperlinks, and bookmarks

Pages — Professional Document Structure

A Cover Page is a pre-designed first page with placeholders for title, subtitle, author, and date. Apply one from Insert → Cover Page. Using Word's built-in gallery instantly gives any report a polished, professional first impression.

A Page Break (Ctrl+Enter) forces the next content to start on a new page. This is fundamentally different from pressing Enter repeatedly to push content down. If you press Enter 30 times and later add content above it, your spacing shifts. A Page Break is an absolute anchor — content always starts at the top of the next page regardless of what is above it.

Headers and Footers display information automatically on every page — company name, document title, date, or page numbers — without typing it on each page. Double-click the top or bottom margin to enter header/footer editing mode. Press Escape to exit. Page Numbers: Insert → Page Number → choose position and format.

Tables, Navigation Elements

Tables organise information into rows and columns. Insert → Table → drag to define size. Key operations: Merge cells (select cells → Table Layout → Merge Cells) — used for headers spanning multiple columns. Shading — fills cells with colour for alternating rows or header highlighting. Borders — set line style, colour, and width for a professional or invisible grid appearance.

A Hyperlink links selected text to a URL. Select text → Insert → Hyperlink → paste URL. In exported PDFs, these links remain clickable. A Bookmark marks a specific location in the document — useful for navigation in long documents and for cross-references. A Cross-reference creates an auto-updating pointer — "See Table 3 on page 12" updates automatically when Table 3 moves.

Day 08

Illustrations, Shapes & Symbols

Pictures, WordArt, SmartArt organograms, text boxes, drop caps, and special characters

Working with Visuals

When you insert an image, Word places it "inline with text" by default. For most layouts, change the Text Wrapping to "Square" or "Tight" so text flows around it. Do this via: select image → Picture Format tab → Text Wrapping → choose option.

SmartArt converts a bullet list into a professional graphic — org charts, process flows, cycle diagrams, pyramid charts. Insert → SmartArt → choose category and layout. Type text in the left pane. Word arranges it automatically. Organograms (hierarchical org charts) use the Hierarchy category in SmartArt.

Text Boxes are floating containers positioned anywhere on the page, independent of the text flow. Use for pull quotes, sidebars, and callouts. Drop Caps enlarge the first letter of a paragraph — the newspaper/magazine effect. Symbols inserts characters not on the keyboard: ©, ™, £, é, ñ, mathematical signs. Insert → Symbol → More Symbols.

Day 09

Layout & References

Page setup, margins, orientation, table of contents, footnotes, watermarks, and page borders

Page Setup & Backgrounds

Margins: Standard for Nigerian official documents is 2.54cm (1 inch) on all sides. Layout tab → Margins → Custom Margins. Orientation: Portrait (tall, default) for letters and reports. Landscape (wide) for tables, timelines, and wide charts. Columns divide the page into newspaper-style columns. Layout → Columns → Two or Three.

A Table of Contents is generated automatically from your document's Heading styles. This is why using proper Heading 1, Heading 2 styles — rather than just making text large and bold — matters so much. References → Table of Contents → select a style. To update after changes: click the TOC → Update Table. A Watermark is faint background text — "CONFIDENTIAL" or "DRAFT." Design → Watermark. Page Borders add a decorative frame — used for certificates, invitations, and formal letters. Design → Page Borders.

Day 10

Review, Printing & PDF Tools with PDF24 NEW

Proofing, collaboration, file extensions, and mastering PDF management using the PDF24 toolbox

Review & Collaboration

F7 opens Spell Check — it scans for spelling (red underline) and grammar (blue underline) errors. It does NOT catch correctly spelled words used incorrectly ("their/there"). Always proofread manually after spell check. Thesaurus (Shift+F7 or Review → Thesaurus) suggests synonyms to avoid word repetition in formal writing.

Track Changes — the most important collaboration feature in Word. Review → Track Changes → enable. Every edit made by any reviewer is recorded with their name and timestamp. The document owner can Accept or Reject each change individually or all at once. This is the standard workflow for professional document review in law firms, NGOs, government agencies, and corporations.

Comments add sticky-note annotations linked to specific text without modifying the document. Select text → New Comment → type note. The author replies and resolves comments when acted upon. Understanding file extensions: .docx preserves all Word features and is for editable versions. .pdf locks layout permanently and looks identical on every device — use for final sharing and submission.


PDF Tools — What is PDF24 and Why Use It? NEW

PDF (Portable Document Format) is the universal standard for sharing final documents. A PDF looks identical on every device and printer regardless of which software created it, and it cannot be accidentally edited by the recipient. In Nigeria, virtually every official document exchange — JAMB forms, NYSC registrations, job applications, government submissions, contracts, invoices — uses PDF.

PDF24 is a completely free, full-featured PDF toolbox available at pdf24.org. You can use it directly in your web browser with no account or subscription required — simply visit the website and use any tool. It also offers a free desktop application for offline use. PDF24 contains over 25 tools covering everything you will ever need to do with PDF files, all in one place.

This matters in the workplace because you will regularly receive PDFs that need to be combined, compressed for emailing, converted, or signed — and paid tools like Adobe Acrobat are expensive. PDF24 gives you professional PDF capabilities at zero cost.

The PDF24 Toolbox — Complete Guide
🔗

Merge PDF

Combine multiple PDF files into one. Drag to reorder pages before merging.

✂️

Split PDF

Extract specific pages from a large PDF, or split into individual pages.

🗜️

Compress PDF

Reduce file size for emailing. A 10MB PDF can become 1MB without visible quality loss.

🔄

Convert to PDF

Convert Word, Excel, PowerPoint, JPG, PNG, or any other format to PDF.

📄

PDF to Word

Convert a PDF back to an editable Word document for modification.

✍️

Sign PDF

Add a digital signature or drawn signature to PDF contracts and forms.

📝

Fill PDF Forms

Type into PDF form fields — great for government and HR forms.

🔒

Protect PDF

Add a password so only authorised people can open the PDF.

🔓

Unlock PDF

Remove password protection from a PDF you own.

🔢

Add Page Numbers

Insert auto-numbered page numbers to any PDF.

↩️

Rotate Pages

Fix sideways or upside-down pages in a PDF.

🖼️

PDF to Image

Export each PDF page as a high-quality JPG or PNG image.

Step-by-Step Walkthroughs — Most Common Tasks
📋 Task 1 — Merge PDFs (Combining a CV, Cover Letter, and Certificate into one file)
1. Go to pdf24.org → click "Merge PDF"
2. Click "Choose files" or drag your PDF files into the upload area
3. The files appear as thumbnails — drag to reorder them (CV first, then Cover Letter, then Certificate)
4. Click "Merge PDF" — processing takes 5–15 seconds
5. Click "Download" to save the merged PDF to your computer
Result: One single PDF file containing all three documents — exactly what most job applications require.
🗜️ Task 2 — Compress a PDF for emailing (Under 2MB limit)
1. Go to pdf24.org → click "Compress PDF"
2. Upload your large PDF file
3. Choose compression level: "Medium" balances quality and size for most documents. Choose "Low" for image-heavy PDFs you need to keep sharp. Choose "High" if size is the only priority.
4. Click "Compress PDF"
5. Compare the original vs. compressed file size shown on screen, then download
Tip: A scanned document with images can often be reduced from 8MB to under 1MB with "Medium" compression, making it suitable for email attachments.
📝 Task 3 — Fill and Sign a PDF Form (NYSC / Job Application Forms)
1. Go to pdf24.org → click "Sign PDF" (this also allows filling forms)
2. Upload the PDF form
3. The form opens in PDF24's editor — click on any field and type your information
4. To add a signature: click the Signature tool → draw your signature with your mouse, or type your name → place it on the signature line
5. Click "Save" → Download the completed form
Important: If the form has interactive fields, PDF24 fills them directly. If it is a scanned image (flat PDF), use the Text tool to overlay your text on top.
✂️ Task 4 — Extract Specific Pages from a PDF
1. Go to pdf24.org → click "Split PDF"
2. Upload the large PDF
3. To extract specific pages: click "Extract pages" → enter page numbers (e.g. "3,7,12-15" for pages 3, 7, and 12 through 15)
4. Click "Split PDF" → download the extracted pages as a new PDF
Use case: A 200-page company policy document — extract only the 4 pages relevant to a specific question rather than sending the full file.
PDF24 Desktop App — Working Offline

For situations where you need to work without internet access (power cuts, data saving), PDF24 also offers a free desktop application for Windows. Download from pdf24.org → "Desktop App." Once installed, all the same tools are available offline with no file size limits and no uploads to the internet — important for confidential documents. The desktop version also includes a PDF printer that appears in your Windows printer list — you can "print to PDF" from any program, converting anything printable into a PDF instantly.

⚠️ Privacy note: When using the web version of PDF24, your files are uploaded to their servers temporarily for processing and deleted after a short period. For highly confidential documents (ID cards, bank statements, legal contracts), either use the offline desktop app or a paid, enterprise-grade PDF tool.

✏️ Days 6–13 Microsoft Word & PDF Capstone

  1. Create a 3-page formal business proposal in Word with: designed cover page, table of contents (using Heading 1 and 2 styles), body text with a table containing merged header cells, one inserted image with text wrapping, page numbers in the footer, and a "DRAFT" watermark.
  2. Enable Track Changes. Make five edits. Accept three, reject two.
  3. Save the document as both .docx and .pdf. Open PDF24 and compress the PDF. Record the original and compressed file sizes.
  4. Use PDF24 to merge your compressed proposal PDF with a separate one-page CV PDF. The result should be one combined document.
  5. Typing check: take the 10FastFingers test. You should have improved from your Day 6 baseline by at least 5 WPM.
Day 11

Mail Merge — Personalised Letters & Certificates at Scale

Creating one master document that auto-generates hundreds of personalised letters, labels, or certificates from a spreadsheet data source

Why Mail Merge Matters

Mail Merge solves a real workplace problem: you have one letter to send to 200 people, but each copy must include the recipient's name, address, and personalised details. Without Mail Merge, you type each letter individually — 200 separate documents. With Mail Merge, you create one master document and one Excel spreadsheet, and Word generates all 200 personalised letters automatically in seconds.

Practical use cases: invitation letters for events, salary letters, employee certificates, customer invoices, bulk email personalisation, NYSC posting letters, school report cards.

The Three Components of Mail Merge
ComponentWhat It IsExample
Main DocumentThe letter, certificate, or label template. Contains fixed text and merge field placeholders.The certificate reading "This is to certify that «Full_Name» has successfully completed..."
Data SourceThe Excel spreadsheet (or Word table / CSV file) containing the variable information — one row per recipient.A spreadsheet with columns: Full_Name, Address, Course_Title, Date_Completed
Merged OutputThe final result — individual personalised documents for each row in the data source.200 individualised certificates, one per student
Step-by-Step Mail Merge

Step 1 — Prepare your Excel spreadsheet: Create a spreadsheet with a header row (column titles). No merged cells, no blank rows, no special characters in column headers. Column headers become your merge field names — use simple names like Full_Name, Email, City.

Step 2 — Open your letter in Word: Write the full standard letter, leaving gaps where personalised details go.

Step 3 — Start Mail Merge: Mailings tab → Start Mail Merge → Letters (or Labels, or Envelopes).

Step 4 — Connect to your data source: Mailings → Select Recipients → Use an Existing List → browse to your Excel file → select the sheet.

Step 5 — Insert merge fields: Place your cursor where a name should appear → Mailings → Insert Merge Field → select Full_Name. A placeholder «Full_Name» appears. Repeat for all variable fields.

Step 6 — Preview: Mailings → Preview Results → click the arrows to check each recipient's letter looks correct.

Step 7 — Complete the merge: Mailings → Finish & Merge → choose: Print Documents (send directly to printer) or Edit Individual Documents (creates one long Word file with all letters separated by page breaks — useful for review).

Day 12

Document Templates & Style Management

Creating reusable branded templates, mastering the Styles panel, and building consistent corporate documents

What Is a Template?

A template (.dotx file) is a pre-designed document blueprint. When you create a new document from a template, Word creates a copy — the original template remains unchanged. Every organisation should have branded templates so that all letters, reports, and proposals look consistent.

Every new Word document is already based on a template — the blank Normal.dotx template. The default font is Calibri 11pt, the margins are 2.54cm — these all come from Normal.dotx. You can and should customise this for your organisation's brand.

Creating your own template: Design your document exactly as you want it — add your logo to the header, set the fonts and colours, create and apply all necessary styles. Then: File → Save As → change file type to Word Template (.dotx) → save to your templates folder. From then on: File → New → Personal → select your template to open a fresh branded copy.

The Styles Panel — Formatting with Intelligence

A Style is a saved bundle of formatting — font, size, colour, line spacing, paragraph spacing — given a name. When you apply the style "Heading 1" to text, it applies all those formatting settings simultaneously and consistently.

Why Styles matter beyond appearance: Styles create document structure that Word understands. Documents formatted with proper Heading 1/2/3 styles automatically generate a Table of Contents, enable the Navigation Pane to work, and make accessibility features function correctly. Documents where headings are just "large bold text" — without actual styles — cannot generate a TOC automatically and have no navigable structure.

Modifying a style: Right-click the style name in the Styles panel (Home tab, Styles group) → Modify → change any formatting → check "Automatically update" to cascade changes to all text using that style throughout the document. This is how you change all headings in a 40-page report with one action.

Creating a new style: Format text exactly as you want → right-click the formatted text → Styles → Save Selection as New Quick Style → give it a name. Now this style appears in your panel and can be applied document-wide.

Style Sets (Design tab → Document Formatting) apply a complete family of coordinated styles — heading fonts, body fonts, spacing — with one click. Use these as a starting point, then customise individual styles to match your brand.

Day 13

Advanced Word Tables — Design, Sorting & Calculations

Table styles, sorting data, performing calculations inside tables, and converting between text and tables

Beyond the Basics — Advanced Table Operations

Table Styles: Click anywhere in a table → Table Design tab → choose a style from the gallery. The style applies professional colours, borders, and header/footer row formatting instantly. Check "Banded Rows" for alternating-colour rows (improves readability). "Header Row" and "Total Row" options format the first and last rows distinctively.

Converting Text to a Table: If you have data separated by tabs, commas, or other delimiters, Word can convert it to a proper table automatically. Select the text → Insert → Table → Convert Text to Table → choose the separator → OK. Conversely, select a table → Table Layout → Convert to Text to extract data back to plain text.

Sorting a table: Click in any column → Table Layout → Sort. Choose the column to sort by, select Ascending or Descending, and whether the table has a header row. You can sort by up to three levels simultaneously (sort by Department, then by Surname, then by Date).

Calculations in Word tables: Word tables can perform basic calculations without Excel. Click in a cell → Table Layout → Formula. The formula =SUM(ABOVE) totals all numbers above the current cell. =SUM(LEFT) totals numbers to the left. =AVERAGE(ABOVE), =COUNT(ABOVE), and =MAX(ABOVE) also work. Note: unlike Excel, these do not auto-update when data changes — right-click the result → Update Field to refresh.

Nested tables: A table within a table cell — useful for complex form layouts and structured data that needs inner formatting. Click inside a cell → Insert → Table. Use sparingly as they increase document complexity significantly.

📊

Microsoft Excel — Days 14–17

Data entry, formulas, logical functions, data tools, and professional visualisation

Day 14

Introduction to Data Entry

The Excel environment, navigating worksheets, and organising data correctly from the start

The Excel Environment

Excel is built around a grid of cells, each identified by a column letter and row number: A1, B5, C12. This cell reference is the foundation of all formulas. A Worksheet is one grid (one tab at the bottom). A Workbook is the entire Excel file, which can contain many worksheets — like having multiple pages in one notebook. The Name Box (top-left, shows current cell address) lets you navigate by typing a cell reference and pressing Enter. The Formula Bar shows the actual content of the active cell — if the cell displays "₦1,500" but was entered as a formula, the Formula Bar reveals the formula.

Layout Tools

Merge & Centre: Combines multiple cells into one and centres text inside — used for headings spanning multiple columns. Select cells → Home → Merge & Centre. Freeze Panes: Locks rows/columns so they stay visible while scrolling. Click the cell below and to the right of what you want frozen → View → Freeze Panes. Essential for tables with hundreds of rows — headers always stay visible. Text Wrapping: Makes text wrap inside the cell (row height increases to show all text) instead of overflowing into adjacent cells. Home → Wrap Text.

Day 15

Formatting & Basic Arithmetic

Number formats, arithmetic operators, and essential statistical functions

Cell Formatting & Functions

The same number means different things in different formats. Format cells via right-click → Format Cells → Number tab, or use the quick buttons on the Home ribbon. Every formula starts with = — without it, Excel treats the entry as plain text. Always use cell references in formulas (=A1+B1) rather than hard values (=500+300) — if source data changes, formulas recalculate automatically.

Arithmetic operators =A2+B2 Addition =A2-B2 Subtraction =A2*B2 Multiplication =A2/B2 Division Core statistical functions =SUM(B2:B10) Total of all values from B2 to B10 =AVERAGE(B2:B10) Mean average of the range =COUNT(B2:B10) Counts cells containing NUMBERS only =COUNTA(B2:B10) Counts ALL non-empty cells (numbers AND text) =MIN(B2:B10) Smallest value in the range =MAX(B2:B10) Largest value in the range
Day 16

Logic & Data Cleanup

IF functions, sorting, filtering, removing duplicates, and data validation

Logical Functions
IF — basic decision (Pass/Fail) =IF(B2>=50, "PASS", "FAIL") Nested IF — grade system (A/B/C/F) =IF(B2>=70, "A", IF(B2>=60, "B", IF(B2>=50, "C", "F"))) COUNTIF — count cells meeting a condition =COUNTIF(C2:C50, "PASS") How many cells in C2:C50 contain "PASS" SUMIF — add values only where a condition is met =SUMIF(C2:C50, "Lagos", D2:D50) Sum column D only where column C says "Lagos"

Sorting rearranges all rows based on one column's values. Data → Sort. You can sort by multiple levels. Filtering temporarily hides rows that don't match criteria — Data → Filter → click dropdown arrows on headers. Remove Duplicates (Data → Remove Duplicates) scans selected columns and deletes rows where the combination already appeared — essential before any data analysis. Data Validation: restricts what values can be entered, creating dropdown lists for consistent data entry. Data → Data Validation → Allow: List → Source: type options separated by commas.

Day 17

Visuals, Charts & Protection

Conditional formatting, charting data, protecting workbooks, and print setup

Conditional Formatting, Charts & Protection

Conditional Formatting automatically changes cell appearance based on values — making patterns visible instantly. Highlight Cells Rules: colour cells above/below a threshold. Data Bars: horizontal bars inside cells proportional to values. Colour Scales: gradient heatmap (green=high, red=low). Home → Conditional Formatting.

Charts: Select data first → Insert → recommended chart types. Pie charts for proportions of a whole. Bar/Column for category comparisons. Line for trends over time. Always add a chart title and label your axes. Sheet Protection (Review → Protect Sheet) locks cells from editing. Unlock specific input cells first: Format Cells → Protection → uncheck Locked. Print Area: select cells → Page Layout → Print Area → Set Print Area, so only the relevant data prints.

🎞️

Microsoft PowerPoint — Days 18–20

Designing, animating, and delivering professional presentations

Day 18

Slide Design & Structure

Presentation rules, themes, Slide Master for global consistency

Rules of Effective Presentations

Themes apply complete pre-designed packages — fonts, colours, backgrounds, and layouts simultaneously. Slide Master (View → Slide Master) is the behind-the-scenes template controlling every slide. Changes to the Slide Master automatically appear on all slides — add your company logo once here and it appears on all 30 slides without editing each one individually.

Slide Size — Design tab → Slide Size → choose your format before adding content:

  • Standard (4:3) — suited for older projectors, square screens, printed handouts, and classroom presentations on older equipment. Images fill the frame without black bars on traditional projectors.
  • Widescreen (16:9) — suited for modern monitors, laptops, TVs, and online presentations. Most screens produced after 2010 are widescreen. This is the default for new presentations.

Important: Always set your slide size before adding content. Changing it after will reformat all text boxes, images, and shapes — you will need to manually fix the layout on every slide.

Day 19

Dynamic Movement — Transitions & Animations

Slide effects, element animations, timing, and the Animation Pane

Transitions & Animations

Transitions are visual effects when moving between slides. Applied from the Transitions tab. Use one consistent subtle effect (Fade or Push) throughout. Mixing 10 different dramatic transitions is unprofessional. Advance Slide Timing: uncheck "On Mouse Click" and set seconds for automatic advancing — used for kiosk displays and pre-timed presentations.

Animations apply to individual elements within a slide. Three categories: Entrance effects — how elements appear (Fly In, Fade, Zoom). Emphasis effects — what happens to visible elements (Pulse, Spin). Exit effects — how elements leave (Fly Out, Fade). The Animation Pane (Animations → Animation Pane) shows the sequence, timing, and triggers of all animations on the current slide — reorder and adjust from here.

Day 20

Multimedia & Presentation Delivery

Embedding video and audio, recording narration, and mastering Presenter View

Media & Presenter View

Insert → Video embeds video files directly into slides. Trim the video to show only the relevant portion. The Recording Ribbon records your voice narration and webcam as you present — Export → Create a Video converts the presentation to an MP4 for submission or training materials.

Presenter View is the most important feature most beginners don't know exists. When presenting with two screens (laptop + projector), your laptop shows Presenter View — your speaker notes, the next slide preview, elapsed time timer. The audience sees only the current slide. This means your complete script can be in the Notes panel without the audience ever knowing. Enable via: Slide Show tab → check "Use Presenter View."

✏️ Phase 2 Capstone (Office Suite)

  1. Word: Create a 4-page formal report with TOC (from Heading styles), table with shaded header row, one SmartArt organogram, DRAFT watermark, and Track Changes from a peer review.
  2. Excel: Build a student results sheet: 10 students, 5 subjects, Total, Average, Grade (Nested IF), Pass/Fail (IF). Add Conditional Formatting and a bar chart of average scores. Protect formula cells.
  3. PowerPoint: 10-slide business pitch with Slide Master logo, Fade transitions, animated bullet reveals, and speaker notes on all slides. Practice in Presenter View.
  4. PDF24: Export the Word report as PDF. Compress it under 2MB. Merge it with the Excel chart (exported as PDF) into one combined document. Password-protect it.

Phase 3 — The Online World & AI

Days 21–28 · Internet safety, data privacy, professional communication tools, cloud collaboration, LinkedIn, job boards, and artificial intelligence

Day 21

Web Navigation, Online Safety & Data Privacy NEW

Browser mastery, recognising threats, account security, and your legal data privacy responsibilities

Browser Mastery

A browser is the program that connects to the internet and renders websites (Google Chrome, Mozilla Firefox, Microsoft Edge, Safari). A search engine is a website you visit using a browser (Google, Bing, DuckDuckGo). The browser is the vehicle; the search engine is a destination. You can use Google's search engine in any browser — they are not the same thing.

Tabs vs. Windows: A tab is a new page within the same browser window. A window is a completely separate browser instance. Use Ctrl+T for a new tab. Use Ctrl+N for a new window. Use Ctrl+W to close the current tab. Use Ctrl+Shift+T to reopen the last closed tab — extremely useful when you accidentally close something. To open a link in a new tab without leaving your current page: right-click the link → Open link in new tab, or hold Ctrl while clicking the link.

Bookmarks (Ctrl+D) save a webpage address for one-click future access. Organise bookmarks into folders. The Bookmarks Bar (Ctrl+Shift+B) shows your most-used sites as quick-access buttons below the address bar.

History is a log of every webpage you have visited. Access it with Ctrl+H or Menu → History. You can search, revisit, or delete individual entries. To delete all history: Ctrl+Shift+Delete → select time range → choose what to clear → Clear data. On a shared or public computer, always clear your history, cookies, and saved passwords before leaving — otherwise the next user can see every site you visited and potentially access your accounts.

Incognito / Private mode (Ctrl+Shift+N in Chrome and Edge): opens a session that does not save history, cookies, or form data after you close the window. What it does protect: history from being saved on that device. What it does NOT protect: your internet provider can still see your activity; websites can still track you; your employer or school network can still monitor traffic. Use incognito for private browsing on shared devices, or when you need to open a second account on the same site without logging out of the first.

Online Safety — Recognising Threats

The HTTPS padlock in the address bar means the connection is encrypted — third parties cannot intercept passwords or card numbers you submit. HTTP (without the S) sends data in plain text. Never enter personal information on an HTTP site. Phishing is the most common cyber attack — emails or websites impersonating trusted sources (your bank, JAMB, Google) to steal credentials. Warning signs: sender email doesn't match the organisation (support@g00gle.com is not Google), urgent threatening language ("Account suspended in 24 hours!"), links that go to a different URL than the text shows, poor spelling and grammar. Strong passwords: 12+ characters, mixed case, numbers, symbols, unique per account. Enable 2FA/MFA on email, banking, and social media — even if someone steals your password, they cannot access your account without your phone.

Data Privacy — Your Legal Responsibilities NEW

Data privacy is no longer just a technical topic — it is a legal and professional obligation. Nigeria enacted the Nigeria Data Protection Act (NDPA) 2023, replacing and strengthening the earlier NDPR. Any employee handling information about customers, clients, patients, or staff at a company that processes personal data has legal obligations under this law. Non-compliance can result in fines and criminal penalties for the organisation.

Understanding data privacy makes you a more trustworthy and employable professional. Employers in banking, healthcare, telecoms, e-commerce, NGOs, and government actively look for staff who understand why data protection matters.

What is Personal Data?

Personal data is any information that identifies or can be used to identify a living person. This is broader than most people realise — it includes not just the obvious (ID numbers, addresses, phone numbers) but also combinations of information that together identify someone.

CategoryExamplesSensitivity Level
Basic IdentifiersFull name, phone number, email address, home addressPersonal — handle with care
Official IDsNIN, BVN, passport number, driver's licence, voter card numberHigh — never share without clear purpose
Financial DataBank account numbers, card details, salary information, transaction historyVery High — strictly need-to-know basis
Health DataMedical records, diagnoses, prescriptions, mental health informationVery High — strongest legal protection
Sensitive CategoriesEthnic origin, religious beliefs, political opinions, biometric data (fingerprints, face scans)Special Category — requires explicit consent
Location DataGPS location history, home/work address patterns, check-in dataHigh — can enable physical harm if misused
The 8 Principles of Data Protection (NDPA 2023)
Your Responsibilities as an Employee
You MUSTYou MUST NOT
Lock your computer when stepping away from your desk (Win+L)Share login credentials with anyone, including colleagues
Only access data you need for your specific job tasksBrowse customer records out of curiosity or for personal reasons
Report data breaches (lost laptop, accidental email to wrong person) immediately to your supervisor or ITSave company data to personal USB drives, personal email, or personal cloud accounts
Use company-approved tools for work communications (not personal WhatsApp for client data)Screenshot or photograph screens containing personal data and share on social media
Shred physical documents containing personal data before disposalEmail files containing sensitive data without encryption or password protection
Follow your company's data retention policy for deleting old recordsDiscuss client personal information in public spaces where others can hear
🚨 Real consequence: An employee who accidentally emails a client's salary details to the wrong person has committed a data breach. The company may be fined, and the employee may face disciplinary action. "I didn't mean to" is not a legal defence. This is why this topic is taught before you enter the workforce.
💡 A simple rule to live by: "Would I be comfortable if this person knew I had their data, or saw how I was using it?" If the answer is no, stop and ask your supervisor.

✏️ Day 18 Exercise

  1. Visit three websites and check whether each uses HTTPS. Report whether they do, and what personal data you think each collects.
  2. Look at a phishing email example (instructor provides a sample) — identify every warning sign present.
  3. Enable 2-Factor Authentication on your Gmail account. Document the steps you followed.
  4. Scenario: You work in a bank's customer service department. A colleague asks you to email her the full customer database so she can work from home this weekend. Using the NDPA principles, write a short note explaining what is wrong with this request and what the correct procedure should be.
Day 22

Microsoft Outlook & Microsoft Teams NEW

The professional communication tools used in most Nigerian companies and organisations globally

Why Outlook & Teams — Not Just Gmail and Zoom

Most consumers use Gmail and Google tools in their personal lives. But the overwhelming majority of formal employers in Nigeria and globally — banks, oil companies, telecoms, NGOs, government agencies, multinationals, and large SMEs — run on Microsoft 365. This means Microsoft Outlook for email and calendar, and Microsoft Teams for internal communication and meetings.

A graduate who only knows Gmail will need to relearn their core communication tools on their first week of employment. Microsoft 365 is consistently the first tool new employees are given access to. Knowing Outlook and Teams before you start work signals a level of readiness that sets you apart.

The good news: the concepts are the same as Gmail and Zoom — email, calendar, video calls, file sharing. The interface is different. This lesson focuses on what is different about the Microsoft tools and the features that make them more powerful in a professional corporate context.

Microsoft Outlook — Professional Email & Calendar

Outlook is more than email — it combines email, calendar, contacts, tasks, and notes in one application. This integration is what makes it the dominant professional tool. You can receive an email about a meeting and add it to your calendar without switching applications. You can flag an email as a task with a due date. You can see someone's calendar availability before sending a meeting invite.

FeatureHow It WorksProfessional Use
Inbox / FoldersDefault folders: Inbox, Sent Items, Drafts, Deleted Items. Create custom folders by right-clicking "Inbox" → New Folder. Drag emails to move them, or right-click → Move.Organise by project, client, or department. "Finance Project" folder keeps all related emails together for easy reference.
RulesHome → Rules → Manage Rules and Alerts → New Rule. Set conditions: "When emails arrive FROM [person]" → action: "Move to [folder] and mark as read."Automatically sort incoming emails so newsletters, alerts, and team communications go to their own folders without cluttering your Inbox.
Follow-Up FlagsClick the flag icon on any email to mark it as needing action. Colour-coded. Flagged emails appear in your To-Do sidebar.Never forget to respond to an important email. The flag is a built-in task reminder linked to the original email.
Conversation ViewGroups all replies in a thread together as one item. Click the arrow to expand and see the full exchange.Instead of 15 separate emails for one discussion, you see one collapsed thread — much cleaner for following a project conversation.
CalendarClick the Calendar icon at the bottom of the navigation pane. View: Day, Week, Work Week, Month. Create appointment: click a time slot → type the subject.Schedule your meetings, set reminders, and see your week at a glance. Colour-code different calendar categories (Meetings, Deadlines, Personal).
Send Meeting InviteCalendar → New Meeting → add attendees' email addresses in the To field → set date/time → Add Zoom/Teams link if needed → Send. Recipients get an invitation they can Accept, Decline, or mark as Tentative.The standard way to schedule a meeting in any corporate environment. When accepted, the meeting automatically appears on all attendees' calendars.
Out of OfficeFile → Automatic Replies → "Send automatic replies" → type your message → set date range → OK.When you are on leave, on a trip, or unavailable, anyone who emails you gets an automatic reply explaining when you will return and who to contact urgently.
SignatureFile → Options → Mail → Signatures → New → type your signature with name, title, company, phone → assign to new messages and replies.Your professional signature appears automatically on every email — no typing it each time. Typically: Full Name, Job Title, Company, Phone, Website.
Recall a MessageSent Items → open the sent email → File → Resend or Recall → "Delete unread copies." Only works if the recipient has not yet opened the email, and only within the same Exchange organisation.Useful when you sent an email with wrong information or attached the wrong file — though it only works in limited circumstances.
Ctrl+NNew email
Ctrl+RReply to email
Ctrl+Shift+RReply All
Ctrl+FForward email
Ctrl+EnterSend the email
F9Send and receive (check mail)
Microsoft Teams — The Digital Office

Microsoft Teams is a hub for teamwork that combines chat, video meetings, file storage, and app integration in one platform. In most corporate organisations in 2026, Teams has replaced email for internal day-to-day communication — you email clients and external partners, but you use Teams to talk to your colleagues.

The key mental model: Email = postal service (formal, asynchronous, external). Teams = office floor conversation (informal, instant, internal). Learning when to use which prevents you from cluttering everyone's email inbox with internal quick questions and missing urgent messages because they were buried in email.

Teams FeatureWhat It IsHow to Use It
Teams & ChannelsA Team is a group (e.g., "Marketing Department"). A Channel is a sub-topic within the team (e.g., "Campaign Q3," "Design Reviews," "General"). All members of the Team can see all Channels.Post in the relevant channel. Never send "Hi, can you help me?" in a channel — include your full question. Others searching later will find it.
Chat (Direct Messages)Private one-on-one or group conversations not visible to the whole team. Like a private text message.For personal, sensitive, or casual conversations. Start a chat: click the Chat icon → click pencil icon → search for the person's name.
@mentionsType @ before someone's name to notify them specifically. They get a notification that they were mentioned. @channel notifies everyone in that channel. @team notifies every member of the team.Use @name to assign something to a specific person in a channel post. Avoid @team or @channel for minor posts — it interrupts everyone.
ReactionsHover over any message → emoji icon → add a reaction (thumbs up, heart, laugh, etc.)Acknowledge a message without sending a separate "OK" or "Thanks" reply that adds to notification noise. Thumbs up = "Acknowledged, I'll do it."
Threads / RepliesClick "Reply" under a specific message to respond to that message specifically, keeping the conversation organised.Always reply in a thread rather than posting a new message, so conversations stay grouped and easy to follow.
Files TabEach channel has a Files tab where documents shared in that channel are stored (in SharePoint). Team members can collaborate on Word, Excel, and PowerPoint files directly in Teams without downloading them.Instead of emailing document versions back and forth, share the file in the Files tab. Everyone edits the same document simultaneously.
Video MeetingsClick the video camera icon in a chat or channel to start an instant meeting. Or schedule via the Calendar tab. All standard features: mute, camera on/off, screen share, recording, background blur, hand raise, chat.Schedule internal meetings via Teams Calendar. External meetings (with people not in your organisation) can join via a Teams link without needing a Teams account.
Status IndicatorsGreen circle = Available. Yellow = Away or inactive. Red = Do Not Disturb. Purple = In a meeting. Grey = Offline.Set your own status via your profile picture. Set "Do Not Disturb" during deep work to avoid notification interruptions. Others see this before messaging you.
Pinning & BookmarkingPin important channels to the top of your sidebar. Bookmark important messages to find them later.Pin your most active channels. Bookmark any message containing instructions, links, or information you need to reference frequently.
Teams vs. Email — When to Use Which
SituationUse TeamsUse Email
Quick internal question✅ Chat message — instant, no clutter❌ Too formal, creates email noise
Project update for team✅ Post in the project channel❌ Creates "reply-all" chaos
Sending final document to client❌ Client may not have Teams✅ Email is universal
Formal request needing paper trail❌ Chats are less formal✅ Email is the legal record
Internal meeting scheduling✅ Teams calendar invite with Teams link⚠️ Outlook invite also fine
Sensitive HR or disciplinary matter❌ Chats may not have the right privacy✅ Email with clear subject line creates formal record
Collaboration on a document with colleagues✅ Share in Files tab, co-edit in real time❌ Creates multiple conflicting versions
✅ The golden rule: use Teams for conversations, use email for formal correspondence and external communication. When in doubt in a new job, observe how your colleagues communicate and match their style.

✏️ Day 19 Exercise

  1. Set up a Microsoft Outlook email account (or use a school/practice Microsoft 365 account). Configure your professional email signature with your name, "Trainee — Valuemax Tech Academy," and your phone number.
  2. Create a calendar appointment for a mock "Project Review Meeting" next Thursday at 10am. Send a meeting invite to a classmate's email address.
  3. Set an Out of Office automatic reply that will activate next Saturday through Sunday with a professional message stating you are unavailable and will respond Monday.
  4. In Microsoft Teams: create a new Team, add two classmates, create three Channels (General, Resources, Q&A), post a message in Resources with a file attachment, and @mention a classmate in Q&A.
Day 23

Online Forms & Gmail Communication

Mastering form elements, JAMB and job applications, and professional Gmail usage

Online Form Elements
ElementHow to UseCommon Mistake
Text BoxClick inside, type the required informationLeaving required fields blank; typing in the wrong format (DD/MM vs MM/DD for dates)
Text AreaA larger, multi-line input box — click inside and type freely across multiple lines. Used for descriptions, comments, and paragraphsTrying to write a full paragraph inside a small single-line text box; not noticing character limits displayed below the field
DropdownClick the ▼ to open the list, click your choiceLeaving it at the default "Select..." without choosing
Radio Button (○)Click the circle next to your choice. Only ONE can be selected.Thinking multiple can be selected; re-reading all options before clicking
Checkbox (□)Click to tick/untick. MULTIPLE can be selected simultaneously.Not reading checkboxes carefully; ticking without reading each one
File UploadClick "Choose File" → navigate to file → select → confirmWrong file type, exceeding size limit, forgetting to click "Upload"
Star Rating (★)Click the number of stars that matches your experience (e.g. 1–5 stars). Common on Uber, Google Reviews, and app storesAccidentally clicking 1 star when intending 5; not being able to change your rating on some platforms once submitted

Gmail mastery: TO: main recipient expected to act. CC (Carbon Copy): people who need to know but not act — all recipients see who is CC'd. BCC (Blind Carbon Copy): recipients hidden from all others — use when emailing a large group to protect everyone's privacy. Attachments: keep under 10MB total; compress multiple files into one zip; always mention the attachment in the email body. Professional Signature: Settings (gear icon) → See all settings → General → Signature → create and assign.

Day 24

Google Workspace & Cloud Storage

Google Drive, real-time collaborative editing in Docs, Sheets, and Slides

Google Drive & Collaborative Editing

Google Drive stores your files on Google's servers — accessible from any internet-connected device. 15GB free per Google account. Files are automatically backed up. Sharing: Instead of emailing copies (which create conflicting versions), share a link to the single file. Share settings: "Viewer" (read only), "Commenter" (can add comments), "Editor" (full access). Share via: right-click file → Share → type email address or generate a link.

Suggesting Mode in Google Docs (equivalent to Track Changes in Word): click the pencil icon dropdown (top-right) → switch from "Editing" to "Suggesting." Every change you make becomes a suggestion the owner must accept or reject. This is the correct mode when reviewing a document someone else owns.

Google Docs, Sheets, and Slides are web-based equivalents of Word, Excel, and PowerPoint. Multiple people edit simultaneously — you see each other's cursor in real time. Auto-saves every change. No manual save required. Every change has a Version History (File → Version History → See version history) — you can restore any previous version.

Day 25

Surveys & Virtual Meetings

Google Forms for data collection and professional participation in Zoom and Google Meet

Google Forms & Virtual Meeting Skills

Google Forms creates surveys, quizzes, and data collection forms with any shareable link. Forms → Responses tab → Link to Sheets: every new response becomes a new row in a connected spreadsheet automatically. Download as CSV: Responses → three dots → Download .csv for analysis in Excel.

Zoom & Google Meet professional etiquette: Mute yourself when not speaking — your background noise disrupts everyone. Use Background Blur for professional appearance regardless of your physical environment. Raise Hand (Reactions → Raise Hand) to signal you want to speak without interrupting. Chat panel for sharing links and asking questions without audio interruption. Breakout Rooms: host creates small groups for discussion within a larger meeting. Always test your audio and video before a meeting — not during it.

Day 26 NEW

Professional Online Presence — LinkedIn & Job Boards

Building a credible digital professional identity and knowing where and how to find jobs effectively

Why Your Online Professional Presence Matters

In 2026, employers do not wait to receive CVs — they actively search for candidates. A hiring manager who receives your CV will almost certainly search your name on LinkedIn before or after reading it. If they find nothing, that itself makes an impression. If they find a well-crafted profile that matches and reinforces your CV, you have already differentiated yourself from candidates who only sent a PDF.

More importantly, LinkedIn is the world's largest professional network with over 1 billion members. Jobs posted on LinkedIn often receive applications from thousands of candidates. But jobs filled through referrals and networking — which LinkedIn facilitates — are often never publicly posted at all. Studies consistently show that 70–80% of jobs are filled through networking before or without a public listing. Building a LinkedIn presence is not just about job hunting — it is about becoming findable by opportunities.

This is not optional for someone serious about a professional career. It costs nothing. It takes 2 hours to set up properly. And it works continuously in the background while you sleep.

Creating a LinkedIn Profile — Step by Step

Go to linkedin.com → Click "Join now" → Create your account

Use your real full name — exactly as it appears on official documents. Use a professional email address (not nicknames). Choose a strong password. LinkedIn is a professional platform — everything you do here is visible to potential employers.

Profile SectionWhat to WriteWhy It Matters
Profile PhotoA clear, front-facing headshot with a neutral or plain background. Formal attire or smart-casual. Good lighting — daylight near a window works perfectly. Smile professionally. No group photos, selfies, or blurry images.Profiles with professional photos receive 21× more views and 9× more connection requests than those without. First impressions are visual and immediate.
HeadlineThis is the line under your name — it appears in every search result, every comment you make, everywhere your name appears. Default is your job title, but craft it specifically. Example: "IT Graduate | Microsoft Office Specialist | Available for Office & Admin Roles — Lagos" Rather than just: "Student"The headline is the most-read part of your profile after your name and photo. It determines whether someone clicks to read more.
About (Summary)3–5 sentences in first person telling your story. Include: what you do (your skills and training), what you are looking for (type of role), what makes you valuable (key strengths), and your location. Keep it professional and specific. Example: "I am a recent graduate of Valuemax Tech Academy with proficiency in Microsoft Office Suite, Google Workspace, and AI tools. I am seeking an entry-level administrative or data entry role where I can contribute accuracy, organisation, and digital communication skills. Based in Lagos, Nigeria."The About section is where recruiters decide if they want to read further. A blank About section signals a lack of seriousness.
ExperienceAdd every job, internship, NYSC placement, volunteer role, or freelance project you have held. Include: title, organisation name, start/end date (or "Present"), location, and 2–3 bullet points describing what you did (using action verbs: "Managed," "Created," "Processed," "Coordinated"). If you have no formal experience yet, add your training programme as a "position" — "IT Trainee — Valuemax Tech Academy."The experience section shows your track record. Even entry-level positions demonstrate responsibility, consistency, and real-world exposure.
EducationAdd your school(s) — institution name, degree/qualification, field of study, year. Add this training programme as a "Professional Certificate" in the Licences & Certifications section.Education confirms your formal qualifications and makes you findable when recruiters filter by institution or field of study.
SkillsLinkedIn allows you to add up to 50 skills. Add relevant ones: Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Outlook, Microsoft Teams, Google Workspace, Data Entry, Communication, Organisation. Start with the most relevant and be accurate — connections can "endorse" your skills, which adds credibility.Recruiters filter candidate searches by skills. If "Microsoft Excel" is not in your skills section, you will not appear when they search for Excel-proficient candidates.
CertificationsAdd any certificates you have received: this course, WAEC, NECO, other short courses. Certifications → Add → fill in the details. Upload a PDF of the certificate if available.Verifiable certifications significantly boost credibility, especially for entry-level candidates who may have limited work experience.
LinkedIn Settings for Job Seekers

Open to Work: Click your profile photo → "Open to" → "Finding a new job" → add your preferred job titles, location, and employment type (full-time, part-time, remote, on-site) → you can share this with all LinkedIn members (a green "Open to Work" banner appears on your photo) or only with recruiters. Choose "Recruiters only" if you are currently employed and job searching discreetly.

Job Alerts: After searching for a job type on LinkedIn, click the "Set alert" toggle. LinkedIn will email you new matching jobs daily or weekly — you do not need to check manually. Set alerts for 3–5 different job title variations to maximise coverage.

Searching for Jobs on LinkedIn

Click "Jobs" in the top navigation bar. Use the search bar with job title keywords and location. Then use the filters to narrow results:

💡 When applying via LinkedIn, always customise the opening message / cover note. Something as simple as "I am a recent computer training graduate based in Lagos seeking my first role in office administration. I believe my proficiency in Microsoft Office Suite and my completion of the Valuemax Tech Academy training programme make me a strong candidate for this position." takes 3 minutes and significantly increases your response rate.
Nigerian & Global Job Boards
🇳🇬 Nigeria

Jobberman

jobberman.com — Nigeria's largest job portal. Wide range of industries. Good for entry to mid-level roles.

🇳🇬 Nigeria

MyJobMag

myjobmag.com — Strong for Lagos-based roles. Good for fresh graduates. Free profile creation.

🇳🇬 Nigeria

NGCareers

ngcareers.com — Nigeria-specific listings. Government, NGO, and corporate sectors well-represented.

🇳🇬 Nigeria

HotNigerianJobs

hotngerianjobs.com — Aggregates jobs from multiple sources. Good for discovering roles you might miss elsewhere.

🌍 Global

Indeed

indeed.com — World's largest job board. Search by location "Lagos, Nigeria" for local roles, or "Remote" for international work-from-home opportunities.

🌍 Global

Glassdoor

glassdoor.com — Jobs + company reviews and salary data. Research what a company is like before applying. Critical for informed applications.

💻 Remote

Remote.co

remote.co — Fully remote roles only. Tech, customer support, writing, admin. International companies hiring in Nigeria.

💻 Remote

We Work Remotely

weworkremotely.com — Large remote job board. Tech and digital roles with international companies paying in USD.

Networking on LinkedIn — The Hidden Job Market

Sending connection requests to people you have never met is normal and expected on LinkedIn — it is not rude. The platform is specifically designed for this. When sending a connection request, always add a personalised note (the "Add a note" option when connecting). Example: "Hi [Name], I recently completed computer training and am building my professional network in the tech space. I noticed you work at [Company] in [Role] and would love to connect and learn about your experience. Thank you."

Who to connect with: classmates, instructors, alumni from your school, people who work at companies you want to join, professionals in your field who post useful content. After connecting, engage with their posts — thoughtful comments are more valuable than just liking. This keeps you visible in their network without being intrusive.

LinkedIn Premium: The free plan is sufficient for job searching. LinkedIn Premium (paid) offers InMail messages to people you are not connected to and advanced applicant insights. It is not necessary until you are actively searching and want every advantage.

✏️ Day 23 Exercise

  1. Create a complete LinkedIn profile with a professional photo, a crafted headline, and a 4-sentence About section. Add this training programme to your Experience and Education sections. Add at least 10 relevant skills.
  2. Turn on "Open to Work" for your desired job type and location. Set up a Job Alert for "Administrative Officer" in Lagos.
  3. Search for 3 entry-level jobs on LinkedIn that you could realistically apply to. For each one, write: the job title, the company, why you are a match, and what one skill you still need to develop for it.
  4. Register on Jobberman.com. Upload or build a profile. Search for the same "Administrative Officer" role and compare the results to LinkedIn. Note the differences in the roles and companies shown.
  5. Find 5 professionals in Lagos working in roles you aspire to. Send them a connection request with a personalised note.
Day 27

AI Foundations, Prompt Engineering & Ethical Usage

How AI works, frameworks for effective prompting, and your responsibilities as an AI user

History & How AI Works

Alan Turing's Imitation Game (1950) proposed the question "Can machines think?" — defining AI research for decades. AI Winters were periods of reduced funding (1970s and late 1980s) when early AI overpromised and underdelivered. The Modern AI Boom (2010s–present) was triggered by three convergences: massive internet-scale datasets, powerful GPU computing originally built for gaming, and deep learning breakthroughs.

How LLMs work: Large Language Models (ChatGPT, Claude, Gemini) are trained on vast text to predict the next word in a sequence. Through doing this with billions of parameters and trillions of words, they develop general capabilities — writing, reasoning, coding, translation, summarisation. They do not "think" — they complete patterns statistically. Understanding this explains both their power (they are very good pattern completers) and their weaknesses (they can confidently complete incorrect patterns).

Prompt Engineering — The C.O.R.E. and C.R.E.A.D. Frameworks

C.O.R.E. — For Structured Content Requests

C
Context
Who are you? What is the situation? What background does the AI need? "I am a teacher preparing a lesson for 14-year-olds on climate change."
O
Output
Exactly what do you want produced? Be specific about format — a table, a list, a 300-word essay, a PowerPoint outline, a Python script.
R
Rules
Constraints, limitations, requirements. "Use simple language. Avoid jargon. Must include a hands-on activity."
E
Examples
Show the AI what good looks like. Few-shot prompting provides 1–3 examples before your actual request, and the AI follows the pattern.

C.R.E.A.D. — For Role-Based and Audience-Specific Requests

C
Context
Background situation, organisation, subject matter.
R
Role
"Act as an experienced HR manager." Role assignment significantly improves tone and quality of responses.
E
Expectation
Specific task and desired output. What should the response achieve?
A
Audience
Who reads this? Board of directors? A 10-year-old? The AI adjusts vocabulary and depth accordingly.
D
Delivery
Format and length. "In bullet points," "As a formal report," "In 200 words or less."
AI Safety, Ethics & Limitations
RiskWhat It MeansHow to Protect Yourself & Others
HallucinationsAI confidently states false information as fact — inventing citations, statistics, names, and events that don't exist.Always verify critical facts independently. Never submit AI-generated claims in academic, legal, or professional work without checking original sources.
Data CutoffsLLMs are trained on data up to a specific date and don't know events after that point.Check the model's knowledge cutoff. Use web-search-enabled AI (like Perplexity, or Claude/ChatGPT with browsing) for current information.
BiasAI inherits biases in its training data — racial, gender, cultural, and geographic biases can appear in outputs, often subtly.Critically evaluate AI outputs, especially on sensitive topics. Don't treat AI as objective or neutral on matters of identity, history, or politics.
DeepfakesAI-generated fake video or audio of real people saying things they never said.Verify media from primary trusted sources. Be sceptical of videos of public figures in unexpected situations. Look for unnatural facial movement and audio sync issues.
Intellectual PropertyAI-generated content may incorporate copyrighted material from training data. Ownership of AI output is legally unclear in many countries including Nigeria.Disclose AI use where required by academic or professional policies. Do not present AI-generated creative work as your own original creation in contexts where originality matters.
Privacy RiskIf you input personal data (names, IDs, medical info, financial details) into a public AI tool, it may be used to train future models.Never input real personal data of clients, customers, or patients into public AI tools. Use anonymised or fictional data when testing AI for work purposes.

✏️ Day 24 Exercise

  1. Use the C.O.R.E. framework to write a prompt asking an AI to help you prepare for a job interview at a bank. Identify each element of your prompt explicitly.
  2. Ask ChatGPT or Claude to state a "fact" about your city. Search online to verify whether it is accurate. Document whether the AI was correct, partially correct, or hallucinated.
  3. Privacy scenario: Your manager asks you to paste a list of 500 customers' names and phone numbers into ChatGPT to generate personalised SMS messages. Using what you know about data privacy (Day 18) and AI risks, write a memo explaining why this is problematic and what a safer approach would be.
Day 28

Final Capstone & Assessment

Integrating all 28 days of skills into one real-world project — plus the theory and practical examination

About This Capstone Assessment

The capstone assessment is your final demonstration that you can independently apply the skills from this course to real-world tasks. It consists of four questions — each targeting a specific set of tools and concepts covered during the 28-day programme. You must complete all four questions and submit according to the general instructions below.

General Submission Instructions

a. Submission method: Online — all work submitted as Google Drive shared links or emailed files as specified per question.

b. Co-editor / collaborator access: Before submitting any file, add all three addresses below as co-editors or collaborators on every shared document:

  • valuemaxcommunications@gmail.com
  • onehpromise@gmail.com
  • misojeunsamuel11@gmail.com

c. Public link visibility: Set all shared links to "Anyone with the link" so they are accessible without a sign-in request.

d. Full name: Write your full name exactly as you want it on your certificate at the top of each answer you submit.

e. Mandatory completion: All four questions are required — none are optional.

Question 1 — Hardware, OS & Google Form

Instruction: Using Google Forms, create a single form containing all 25 questions below, organised into three sections exactly as shown. When complete, set the form sharing to "Anyone with the link can fill in the form" and submit the link.

Section 1 — Hardware (Questions 1–9)
  1. What is computer hardware? (Short Answer)
  2. Which part of the computer is known as the "brain" of the computer? (Multiple Choice)
    • A. Monitor
    • B. Mouse
    • C. CPU
    • D. Keyboard
  3. Which of these is NOT a hardware device? (Multiple Choice)
    • A. Printer
    • B. Hard drive
    • C. Calculator
    • D. Keyboard
  4. Give two examples of input devices. (Short Answer)
  5. A speaker is an output device. (True / False)
  6. What is the function of a monitor? (Short Answer)
  7. Match the hardware component with its function: (Matching / Grid)
    • A. CPU → ____
    • B. Mouse → ____
    • C. Printer → ____
    • D. Monitor → ____
  8. Which of these devices is used to point and click? (Multiple Choice)
    • A. Keyboard
    • B. Printer
    • C. Mouse
    • D. Speaker
  9. What part of the computer stores all the data? (Multiple Choice)
    • A. CD
    • B. CPU
    • C. Hard drive
    • D. Monitor
Section 2 — Software (Questions 10–16)
  1. What is software in a computer? (Short Answer)
  2. Which of the following is an example of software? (Multiple Choice)
    • A. Monitor
    • B. Mouse
    • C. Microsoft Word
    • D. Flash drive
  3. Name two examples of application software. (Short Answer)
  4. Software is a physical part of the computer. (True / False)
  5. What is the purpose of software? (Short Answer)
  6. Identify the odd one out: (Multiple Choice)
    • A. Excel
    • B. Word
    • C. Windows
    • D. Keyboard
  7. Which of these is used for creating slides or presentations? (Multiple Choice)
    • A. WordPad
    • B. PowerPoint
    • C. Paint
    • D. Chrome
Section 3 — Operating System Environment (Questions 17–25)
  1. What is the main function of an operating system? (Short Answer)
  2. Which of the following is NOT an operating system? (Multiple Choice)
    • A. Windows
    • B. Linux
    • C. Google Docs
    • D. macOS
  3. Briefly explain how to remove unwanted software from your personal computer. (Short Answer)
  4. You cannot use a computer without an operating system. (True / False)
  5. What operating system is most commonly found on school computers? (Multiple Choice)
    • A. Linux
    • B. Windows
    • C. Android
    • D. MS-DOS
  6. What role does the OS play when you want to open a file? (Short Answer)
  7. Which of these operating systems is open-source? (Multiple Choice)
    • A. Linux
    • B. macOS
    • C. Windows
    • D. iOS
  8. Match each OS with its company: (Matching / Grid)
    • A. Windows → ____
    • B. macOS → ____
    • C. Linux → ____
  9. Your kid brother just started learning how to use a computer and you intend to share your computer with him. To prevent him from tampering with your files and personal settings, explain how to password your user account and how to create a non-admin user for him. (Short Answer)
Question 2 — PowerPoint / Online Presentation

Task title: Tech in Real Life: Applying Digital Skills in the Modern Workplace

Create a minimum 30-slide presentation on Google Slides demonstrating how hardware, software, operating systems, Microsoft Office tools, online collaboration tools, and generative AI are used in real-life work environments. Keep each slide concise — use bullet points, visuals, or short text. Every slide must have a title and subheading.

Slide SectionSlidesContent Required
Introduction2Brief self-introduction and training recap; overview of what the presentation will cover
Hardware in the Workplace5Common hardware devices (laptops, printers, projectors); real-life example: how a receptionist uses hardware daily
Software Applications5Application software in use (MS Word, Excel, browsers); real-life example: how a secretary uses Word to write letters
Operating Systems3What an OS is and why it matters at work; example: choosing between Windows and macOS
Microsoft Office Suite7Uses of Word, Excel, and PowerPoint; include screenshots of mock tasks (sample spreadsheet, letter, slide deck)
Online Collaboration Tools3Google Workspace, Zoom, Microsoft Teams; how teams share documents and communicate online
Generative AI & Prompt Engineering3Efficient use of generative AI in work or academic settings; pick a topic and write the best possible prompt using the C.O.R.E. or C.R.E.A.D. framework taught in class
Challenges & Takeaways2Difficulties faced during the course; the biggest learning achievements

Presentation guidelines: Add relevant pictures or screenshots where possible. Apply animations or transitions for visual appeal. Keep font sizes readable and slides well-organised. Save the file with your full name in the filename.

Submission: Prepare on Google Slides. Share the link (set to "Anyone with the link can view") with:
valuemaxcomplex@gmail.com  ·  onehpromise@gmail.com  ·  misojeunsamuel11@gmail.com

Deadline: Pick a date for your live online presentation no later than 3 weeks from the date you complete your training.

Question 3 — Excel Practical

Complete all seven tasks below using Microsoft Excel or Google Sheets. Save the file using your full name. Submit via Gmail (attachment) or share the Google Sheets link set to "Anyone with the link can view."

Task 1 — Data Entry & Formatting
  • Create a new workbook and rename the first worksheet First Term
  • Enter the data exactly as shown in the reference image provided by your instructor
  • Apply matching formatting: merged & aligned cells, correct font family/size, bold/normal text, yellow cell highlighting, and cell borders
  • Adjust column widths so all content is fully visible
  • Freeze the Name column and the header row (the row containing subject titles)
Task 2 — Calculations
Using correct formulas, calculate the following:
  • a. Total score for each student
  • b. Average score for each student
  • c. Average score for each subject (across all students)
  • d. Number of subjects each student sat — use COUNT to exclude non-numeric entries automatically
Task 3 — Pass / Fail Evaluation
  • Use an IF function: display "Pass" if a student's average score ≥ 50, or "Fail" otherwise
  • Apply Conditional Formatting: "Fail" → red highlight  |  "Pass" → green highlight
Task 4 — Term Management
  • Duplicate the First Term sheet twice — rename as Second Term and Third Term
  • Change the student scores on the new sheets (they must differ from First Term)
Task 5 — Final Result Sheet
  • Duplicate the Third Term sheet and rename it SS2 Result Sheet
  • Delete all existing student scores from this sheet
  • Using cross-sheet cell references (e.g., =FirstTerm!C2+SecondTerm!C2+ThirdTerm!C2), compute each subject's cumulative total across all three terms
  • Sort students from highest to lowest total score
Task 6 — Grade & Remark
In Column K add the heading Grade; in Column L add the heading Remark. Use nested IF formulas based on the table below:
Average ScoreGradeRemark
≥ 70AExcellent
50 – 69BFair
< 50CNeeds Improvement
Task 7 — Visualisation
  • Insert a bar chart showing the average score for each subject
  • Place subject names on the horizontal (X) axis
  • Add a clear, descriptive title to the chart
Question 4 — MS Word Practical

Accurately recreate a provided document in Microsoft Word, then add navigation elements, convert to PDF, upload to Google Drive, and submit the link for grading.

Step 1 — Document Reproduction
Recreate the document exactly as shown in the original copy:

🔗 View original document on Google Drive

Pay close attention to: line spacing, font family, font size, margins, and page layout settings.
Step 2 — Page Numbering
  • Add page numbers to the footer of each page
  • Exclude the cover page from numbering — enable "Different First Page" in the Header & Footer Tools tab
  • Ensure numbering starts correctly from the second page onward
Step 3 — Page Titles & Heading Styles
Assign a clear, descriptive title to each page based on its content. Apply the Heading 1 style (not just bold/enlarged text) to each title — Word uses heading styles to auto-generate the Table of Contents. Without proper styles, References → Table of Contents will not work.
Step 4 — Table of Contents
  • Insert a Table of Contents immediately after the cover page
  • References tab → Table of Contents → select an Automatic style
  • Each entry must hyperlink to its corresponding page in the document
Step 5 — Convert to PDF & Upload
  • Save the final document as a PDF (File → Save As → PDF)
  • Upload the PDF to Google Drive
  • Set sharing permission to "Anyone with the link can view"
Step 6 — Submission & Deadline
Copy the Google Drive PDF link and send it for review and grading.
Deadline: Friday, 11 July 2025
Final Examination Structure
ComponentFormatTopics CoveredWeight
Theory ExamMultiple choice (30 questions) + Short answer (5 questions)Computer architecture, OS concepts, file management, Office features, data privacy (NDPA 2023), internet safety, command line, troubleshooting methodology, AI concepts, prompt engineering ethics40%
Practical ExamLive computer tasks under timed conditions, observed by instructor1. Word: Format a provided document to specification (heading styles, TOC, page numbers, table). 2. Excel: Write three formulas (SUM, COUNTIF, IF) in a provided dataset. 3. PowerPoint: Apply a theme, add a logo via Slide Master, and animate one slide. 4. Command line: Navigate to a specific folder and create two sub-folders using cmd commands. 5. PDF24: Merge and compress two provided PDFs. 6. LinkedIn: Show your completed profile to the instructor. 7. Type 50 words from a passage — measured for WPM and accuracy.60%
Certificate of Completion: Requires passing both theory (minimum 60%) and practical (minimum 60%) components. A student who excels academically but cannot perform the practical tasks — or who performs tasks well but cannot explain why — has not achieved the programme's objectives.

✏️ Capstone Submission Checklist

  1. Q1 — Google Form: All 25 questions created and divided into 3 labelled sections. Form sharing set to "Anyone with the link can fill in." All three collaborator emails added as co-editors.
  2. Q2 — Google Slides Presentation: Minimum 30 slides covering all 8 sections. Each slide has a title and subheading. Filename contains your full name. Presentation date scheduled within 3 weeks. Link shared with all three submission emails.
  3. Q3 — Excel Workbook: All 7 tasks completed — First/Second/Third Term sheets with different scores; SS2 Result Sheet using cross-sheet formulas; Grade and Remark columns with nested IF; bar chart with chart title. File submitted or shared link sent.
  4. Q4 — Word / PDF: Document reproduced accurately. Heading 1 styles applied to all page titles. TOC generated after cover page. Page numbers start from page 2. PDF uploaded to Google Drive with correct sharing permission. Link submitted by deadline.
  5. All submissions: Full name written at the top of every task. All three collaborator emails (valuemaxcommunications@gmail.com, onehpromise@gmail.com, misojeunsamuel11@gmail.com) added before submitting. All links set to public access.