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
Computer Appreciation & Architecture
The 5W's and H of computers, career paths, system components, and memory vs. storage
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.
| Question | Answer |
|---|---|
| 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 Paths | Programming · 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. |
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 Factor | Key Characteristics | Best For |
|---|---|---|
| Desktop | Most powerful, upgradeable, requires external monitor/keyboard | Office work, gaming, graphics, video editing |
| Laptop | Portable, battery-powered, components are smaller | Mobile workers, students, field staff |
| Tablet | Touch-screen focused, no physical keyboard by default | Media consumption, presentations, light work |
| Smartphone | Fits in a pocket, always connected, limited screen | Communication, browsing, mobile apps |
| Smartwatch | Worn on the wrist, notifications, fitness tracking | Health monitoring, quick notifications |
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).
Peripherals & Physical Setup
Connecting and configuring input/output devices, identifying ports, and setting up wireless connections
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.
| Device | Type | What It Does | Common Connection |
|---|---|---|---|
| Keyboard | Input | Sends keystrokes as text and commands | USB or Bluetooth |
| Mouse | Input | Translates physical movement into cursor movement on screen | USB or Bluetooth |
| Monitor | Output | Displays visual output from the graphics card | HDMI, VGA, DisplayPort |
| Printer | Output | Converts digital documents to paper | USB or Wi-Fi |
| Scanner | Input | Converts physical documents to digital images | USB or Wi-Fi |
| Webcam | Input | Captures live video for calls and recordings | USB or built-in |
| Speakers | Output | Converts digital audio signals to sound waves | 3.5mm jack, USB, or Bluetooth |
| Port | Shape | Used For | Key Fact |
|---|---|---|---|
| USB-A | Rectangular, flat | Flash drives, mice, keyboards, charging | Has a right side — only inserts one way. Most common port on desktops. |
| USB-C | Small, oval, reversible | New phones, laptops, fast charging, data transfer | No "wrong way" — inserts either direction. Supports up to 100W power delivery. |
| HDMI | Trapezoidal, 19 pins | Monitors, TVs, projectors | Carries both video AND audio in one cable. Standard for all modern displays. |
| VGA | Blue, 15-pin D-shape | Older monitors and projectors | Analogue signal, video only, being phased out. Still common on older projectors. |
| Ethernet (RJ-45) | Wide, 8-pin | Wired internet connection | More reliable and faster than Wi-Fi. Essential for stable video calls and critical work. |
| Audio Jack (3.5mm) | Small, round, 3 or 4 rings | Headphones, external speakers, microphone | Colour-coded on desktop PCs: green = audio output (speakers/headphones); pink/red = microphone input. Modern laptops use a single combo jack for both. |
Not all connections use physical cables. Modern computers communicate wirelessly using radio signals. Understanding these helps you set up devices and troubleshoot connectivity issues.
| Technology | Range | Use Cases | Key Points |
|---|---|---|---|
| Wi-Fi | Up to 50–100m indoors | Connecting to a router for internet access without cables | Speed 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. |
| Bluetooth | Up to 10m | Short-range wireless: headsets, mice, keyboards, file transfer between phone and PC | Pair 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 Drive | Physical — no wireless signal | Portable storage for carrying files between computers and locations | The 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.
The OS Environment & Navigation
Understanding operating systems, mastering the Windows desktop, and interpreting power states
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.
| OS | Used On | Strength |
|---|---|---|
| Windows (Microsoft) | Desktops, Laptops | Widest software compatibility, dominant in offices, schools, and businesses worldwide |
| macOS (Apple) | Mac computers only | Smooth hardware-software integration, favoured by creatives and design professionals |
| Linux | Servers, developer machines | Free, open-source, extremely powerful. Powers ~95% of the world's servers |
| Android (Google) | Smartphones, Tablets | Most widely used mobile OS globally, highly customisable |
| iOS (Apple) | iPhone, iPad | Smooth and secure, tightly integrated with Apple services |
| State | What Happens | When to Use | Power Used |
|---|---|---|---|
| Shutdown | All programs close, RAM is cleared, system fully powers off | End of day, before moving equipment, before hardware changes | Zero |
| Restart / Warm Boot | OS closes all programs, clears RAM, and reloads without cutting full power | After installing software, after updates, when system is behaving oddly | Zero (brief) |
| Sleep | Current state saved to RAM, most components power off. Wakes in seconds. | Short breaks. Quick to resume but loses data if power cuts | Very low |
| Hibernate | Current state saved to hard drive, then fully powers off. Takes longer to resume. | Long breaks, closing laptop when battery is low, traveling | Zero |
| Cold Boot | Power was completely off. Loads BIOS, then OS from storage into RAM from scratch | Starting the day or after a full shutdown | N/A (starting) |
Advanced File Management
Organising, moving, naming, compressing, and finding files with confidence
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.
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."
System Management, Tools, Command Line & Troubleshooting NEW
Control Panel, Task Manager, built-in utilities, terminal basics, and the structured approach to fixing problems
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!
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.
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.
| Utility | What It Does | Best Used For |
|---|---|---|
| Notepad | Plain text editor, no formatting, saves as .txt | Quick notes, editing config files, viewing raw data |
| WordPad | Basic word processor with formatting, saves as .rtf or .docx | Quick formatted documents without Word installed |
| Snipping Tool | Captures any region of the screen as an image | Screenshots, capturing error messages, documenting steps |
| Paint / Paint 3D | Basic image editing | Cropping screenshots, annotating images, simple diagrams |
| Sticky Notes | Digital Post-it notes on the Desktop | Quick reminders, to-do lists visible while working |
| Calculator | Standard, scientific, programmer, and date calculation modes | Quick maths, unit conversions, programmer's binary/hex |
| Voice Recorder | Records audio through the PC microphone. Files saved as .m4a audio | Recording lectures, meetings, interview notes, and quick verbal memos |
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.
There are three ways to open Command Prompt on Windows:
- Method 1 (Fastest): Press
Win + Rto open the Run dialog → typecmd→ press Enter - Method 2: Click the Start Menu → search "Command Prompt" → click it
- Method 3 (As Administrator): Start Menu → search "cmd" → right-click → "Run as administrator." Use this when commands require elevated privileges.
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.
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.
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.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.
| Step | Action | Why This Step |
|---|---|---|
| 1. Define the Problem | Write 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 It | Try 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 First | Restart 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 Obvious | Is 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 Online | Copy 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 Evidence | If 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. |
| Problem | Likely Cause | Solution Steps |
|---|---|---|
| Computer is very slow | Too many programs running, low RAM, full hard drive, malware | 1. 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 connecting | Router issue, Windows network adapter, wrong password, IP conflict | 1. 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 recognised | Driver issue, faulty cable/port, device not formatted for Windows | 1. 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 print | Printer not set as default, print queue stuck, driver issue | 1. 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 responding | Program crashed, infinite loop, memory issue | 1. 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, overheating | 1. 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 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.
✏️ Day 5 Exercise
- Open Command Prompt and navigate to your Desktop using
cd. Create a folder called "CMD_Practice" usingmkdir. Navigate into it. Create two more sub-folders. List them withdir. Navigate back to Desktop. - Run
ipconfigand write down your IPv4 address. Runping google.comand record the average response time. - Open Task Manager → Performance tab. Screenshot the CPU and RAM graphs. Identify the three processes using the most memory.
- 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
Keyboard Proficiency, Touch-Typing Speed & Home Ribbon NEW
Building keyboard fluency, setting a professional typing speed target, and mastering core formatting tools
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.
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.
| Finger | Home Key | Responsible Keys (approx.) |
|---|---|---|
| Left Little (Pinky) | A | A, Q, Z, Shift, Caps Lock, Tab |
| Left Ring | S | S, W, X |
| Left Middle | D | D, E, C |
| Left Index | F | F, G, R, T, V, B, 4, 5 |
| Both Thumbs | Space | Spacebar — alternating thumbs after each word |
| Right Index | J | J, H, Y, U, N, M, 6, 7 |
| Right Middle | K | K, I, , |
| Right Ring | L | L, O, . |
| Right Little (Pinky) | ; | ; , P, ' , /, Shift, Enter, Backspace |
| Tool | Website | Best For |
|---|---|---|
| Keybr.com | keybr.com | Structured learning — introduces new keys gradually as you master existing ones. Best for complete beginners learning touch-typing from scratch. Tracks your progress over time. |
| TypingClub | typingclub.com | Gamified lessons with step-by-step finger placement guidance. Excellent for students who prefer a course-style progression with levels. |
| 10FastFingers | 10fastfingers.com | Speed tests using the 200 most common English words. Shows WPM and accuracy. Good for measuring current speed and competing against personal bests. |
| Monkeytype | monkeytype.com | Clean, customisable speed tests. Professional preference among developers and advanced typists. |
| Key | Function |
|---|---|
| Caps Lock | Toggles ALL LETTERS to uppercase. Use Shift for individual capitals — do not use Caps Lock to capitalise one word. |
| Tab | Moves cursor right by one tab stop (usually 1.27cm in Word). Indents paragraphs. Also cycles through form fields. |
| Fn | Function modifier on laptops. Hold Fn + F-key to access secondary laptop functions (brightness, volume, etc.). |
| Ctrl | The most important modifier key. Ctrl + letter = dozens of shortcuts. Ctrl+S=Save, Ctrl+C=Copy, Ctrl+Z=Undo. |
| Alt | Activates menu shortcuts. Alt+F4 = close window. Alt+Tab = switch between open programs. |
| Shift | Capitalises single characters. Holds while pressing arrows to select text. Accesses top symbols on number keys (! @ # $ etc.). |
| Win Key | Opens Start Menu. Win+D=Desktop. Win+L=Lock screen. Win+E=File Explorer. Win+R=Run dialog. |
| F1–F12 | F1=Help. F2=Rename. F5=Refresh/Find in browser. F7=Spell check. F11=Full screen. F12=Save As in Office. |
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.
✏️ Day 6 Exercise
- Visit keybr.com and complete the first three lessons. Record your starting WPM and accuracy. Take a screenshot of your results.
- Take the 10FastFingers one-minute typing test. Record your WPM and accuracy. This is your Day 1 baseline.
- 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.
- Practice goal: achieve at least 5 WPM improvement over your baseline by Day 10. Track your score each day.
Insert Ribbon — Structuring Documents
Cover pages, page breaks, headers, footers, tables, hyperlinks, and bookmarks
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 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.
Illustrations, Shapes & Symbols
Pictures, WordArt, SmartArt organograms, text boxes, drop caps, and special characters
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.
Layout & References
Page setup, margins, orientation, table of contents, footnotes, watermarks, and page borders
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.
Review, Printing & PDF Tools with PDF24 NEW
Proofing, collaboration, file extensions, and mastering PDF management using the PDF24 toolbox
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 (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.
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.
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.
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.
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.
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.
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.
✏️ Days 6–13 Microsoft Word & PDF Capstone
- 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.
- Enable Track Changes. Make five edits. Accept three, reject two.
- Save the document as both .docx and .pdf. Open PDF24 and compress the PDF. Record the original and compressed file sizes.
- Use PDF24 to merge your compressed proposal PDF with a separate one-page CV PDF. The result should be one combined document.
- Typing check: take the 10FastFingers test. You should have improved from your Day 6 baseline by at least 5 WPM.
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
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.
| Component | What It Is | Example |
|---|---|---|
| Main Document | The 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 Source | The 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 Output | The final result — individual personalised documents for each row in the data source. | 200 individualised certificates, one per student |
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).
Document Templates & Style Management
Creating reusable branded templates, mastering the Styles panel, and building consistent corporate documents
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.
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.
Advanced Word Tables — Design, Sorting & Calculations
Table styles, sorting data, performing calculations inside tables, and converting between text and tables
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
Introduction to Data Entry
The Excel environment, navigating worksheets, and organising data correctly from the start
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.
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.
Formatting & Basic Arithmetic
Number formats, arithmetic operators, and essential statistical 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.
Logic & Data Cleanup
IF functions, sorting, filtering, removing duplicates, and data validation
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.
Visuals, Charts & Protection
Conditional formatting, charting data, protecting workbooks, and print setup
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
Slide Design & Structure
Presentation rules, themes, Slide Master for global consistency
- The 6×6 Rule: Maximum 6 bullet points per slide, maximum 6 words per bullet. Slides are visual aids — not documents to be read aloud.
- One idea per slide: Every slide communicates one clear message. The headline tells the story; the content supports it.
- Font size minimums: Titles: 36pt minimum. Body text: 24pt minimum. Nothing below 18pt. The back row must be able to read it.
- High contrast always: Dark text on light background or white text on dark background. Never yellow text, light grey on white, or any low-contrast combination.
- Consistent design: Same font family, same colour palette, same layout structure throughout. Inconsistency signals unprofessionalism.
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.
Dynamic Movement — Transitions & Animations
Slide effects, element animations, timing, and the Animation Pane
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.
Multimedia & Presentation Delivery
Embedding video and audio, recording narration, and mastering 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)
- 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.
- 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.
- PowerPoint: 10-slide business pitch with Slide Master logo, Fade transitions, animated bullet reveals, and speaker notes on all slides. Practice in Presenter View.
- 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
Web Navigation, Online Safety & Data Privacy NEW
Browser mastery, recognising threats, account security, and your legal data privacy responsibilities
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.
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 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.
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.
| Category | Examples | Sensitivity Level |
|---|---|---|
| Basic Identifiers | Full name, phone number, email address, home address | Personal — handle with care |
| Official IDs | NIN, BVN, passport number, driver's licence, voter card number | High — never share without clear purpose |
| Financial Data | Bank account numbers, card details, salary information, transaction history | Very High — strictly need-to-know basis |
| Health Data | Medical records, diagnoses, prescriptions, mental health information | Very High — strongest legal protection |
| Sensitive Categories | Ethnic origin, religious beliefs, political opinions, biometric data (fingerprints, face scans) | Special Category — requires explicit consent |
| Location Data | GPS location history, home/work address patterns, check-in data | High — can enable physical harm if misused |
- Lawfulness, Fairness, Transparency: Data must be collected legally, treated fairly, and individuals must know how their data is used.
- Purpose Limitation: Data collected for one purpose cannot be used for a different one without consent. Customer data collected for delivery cannot be sold to marketers.
- Data Minimisation: Only collect what is actually needed. Do not collect information "just in case."
- Accuracy: Personal data must be kept accurate and up to date.
- Storage Limitation: Data should not be kept longer than necessary. Delete old customer records when the business relationship ends.
- Integrity and Confidentiality (Security): Data must be protected against unauthorised access, loss, or destruction.
- Accountability: Organisations must demonstrate compliance, not just claim it.
- Data Subject Rights: Individuals have the right to access, correct, delete, or object to the processing of their personal data.
| You MUST | You 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 tasks | Browse customer records out of curiosity or for personal reasons |
| Report data breaches (lost laptop, accidental email to wrong person) immediately to your supervisor or IT | Save 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 disposal | Email files containing sensitive data without encryption or password protection |
| Follow your company's data retention policy for deleting old records | Discuss client personal information in public spaces where others can hear |
✏️ Day 18 Exercise
- Visit three websites and check whether each uses HTTPS. Report whether they do, and what personal data you think each collects.
- Look at a phishing email example (instructor provides a sample) — identify every warning sign present.
- Enable 2-Factor Authentication on your Gmail account. Document the steps you followed.
- 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.
Microsoft Outlook & Microsoft Teams NEW
The professional communication tools used in most Nigerian companies and organisations globally
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.
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.
| Feature | How It Works | Professional Use |
|---|---|---|
| Inbox / Folders | Default 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. |
| Rules | Home → 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 Flags | Click 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 View | Groups 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. |
| Calendar | Click 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 Invite | Calendar → 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 Office | File → 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. |
| Signature | File → 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 Message | Sent 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. |
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 Feature | What It Is | How to Use It |
|---|---|---|
| Teams & Channels | A 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. |
| @mentions | Type @ 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. |
| Reactions | Hover 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 / Replies | Click "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 Tab | Each 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 Meetings | Click 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 Indicators | Green 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 & Bookmarking | Pin 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. |
| Situation | Use Teams | Use 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 |
✏️ Day 19 Exercise
- 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.
- Create a calendar appointment for a mock "Project Review Meeting" next Thursday at 10am. Send a meeting invite to a classmate's email address.
- 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.
- 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.
Online Forms & Gmail Communication
Mastering form elements, JAMB and job applications, and professional Gmail usage
| Element | How to Use | Common Mistake |
|---|---|---|
| Text Box | Click inside, type the required information | Leaving required fields blank; typing in the wrong format (DD/MM vs MM/DD for dates) |
| Text Area | A larger, multi-line input box — click inside and type freely across multiple lines. Used for descriptions, comments, and paragraphs | Trying to write a full paragraph inside a small single-line text box; not noticing character limits displayed below the field |
| Dropdown | Click the ▼ to open the list, click your choice | Leaving 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 Upload | Click "Choose File" → navigate to file → select → confirm | Wrong 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 stores | Accidentally 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.
Google Workspace & Cloud Storage
Google Drive, real-time collaborative editing in Docs, Sheets, and Slides
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.
Surveys & Virtual Meetings
Google Forms for data collection and professional participation in Zoom and Google Meet
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.
Professional Online Presence — LinkedIn & Job Boards
Building a credible digital professional identity and knowing where and how to find jobs effectively
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.
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 Section | What to Write | Why It Matters |
|---|---|---|
| Profile Photo | A 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. |
| Headline | This 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. |
| Experience | Add 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. |
| Education | Add 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. |
| Skills | LinkedIn 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. |
| Certifications | Add 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. |
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.
Click "Jobs" in the top navigation bar. Use the search bar with job title keywords and location. Then use the filters to narrow results:
- Date Posted: Filter to "Past 24 hours" or "Past week" to focus on fresh listings that have fewer applications.
- Experience Level: For graduates: "Internship" and "Entry Level." Do NOT filter to "Mid-Senior" or "Director" — those require years of experience.
- Job Type: Full-time, Part-time, Contract, Temporary, Internship. Apply to what you genuinely want.
- Remote / On-site / Hybrid: Filter by your preference and transport situation. Many entry-level Nigerian roles are On-site.
- Easy Apply: Jobs marked with "Easy Apply" allow you to apply using your LinkedIn profile directly in 2 minutes. This is efficient but highly competitive. Applications sent with a tailored note stand out.
Jobberman
jobberman.com — Nigeria's largest job portal. Wide range of industries. Good for entry to mid-level roles.
MyJobMag
myjobmag.com — Strong for Lagos-based roles. Good for fresh graduates. Free profile creation.
NGCareers
ngcareers.com — Nigeria-specific listings. Government, NGO, and corporate sectors well-represented.
HotNigerianJobs
hotngerianjobs.com — Aggregates jobs from multiple sources. Good for discovering roles you might miss elsewhere.
Indeed
indeed.com — World's largest job board. Search by location "Lagos, Nigeria" for local roles, or "Remote" for international work-from-home opportunities.
Glassdoor
glassdoor.com — Jobs + company reviews and salary data. Research what a company is like before applying. Critical for informed applications.
Remote.co
remote.co — Fully remote roles only. Tech, customer support, writing, admin. International companies hiring in Nigeria.
We Work Remotely
weworkremotely.com — Large remote job board. Tech and digital roles with international companies paying in USD.
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
- 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.
- Turn on "Open to Work" for your desired job type and location. Set up a Job Alert for "Administrative Officer" in Lagos.
- 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.
- 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.
- Find 5 professionals in Lagos working in roles you aspire to. Send them a connection request with a personalised note.
AI Foundations, Prompt Engineering & Ethical Usage
How AI works, frameworks for effective prompting, and your responsibilities as an AI user
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).
C.O.R.E. — For Structured Content Requests
C.R.E.A.D. — For Role-Based and Audience-Specific Requests
| Risk | What It Means | How to Protect Yourself & Others |
|---|---|---|
| Hallucinations | AI 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 Cutoffs | LLMs 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. |
| Bias | AI 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. |
| Deepfakes | AI-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 Property | AI-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 Risk | If 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
- 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.
- 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.
- 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.
Final Capstone & Assessment
Integrating all 28 days of skills into one real-world project — plus the theory and practical examination
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.
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.comonehpromise@gmail.commisojeunsamuel11@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.
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.
- What is computer hardware? (Short Answer)
- Which part of the computer is known as the "brain" of the computer? (Multiple Choice)
- A. Monitor
- B. Mouse
- C. CPU
- D. Keyboard
- Which of these is NOT a hardware device? (Multiple Choice)
- A. Printer
- B. Hard drive
- C. Calculator
- D. Keyboard
- Give two examples of input devices. (Short Answer)
- A speaker is an output device. (True / False)
- What is the function of a monitor? (Short Answer)
- Match the hardware component with its function: (Matching / Grid)
- A. CPU → ____
- B. Mouse → ____
- C. Printer → ____
- D. Monitor → ____
- Which of these devices is used to point and click? (Multiple Choice)
- A. Keyboard
- B. Printer
- C. Mouse
- D. Speaker
- What part of the computer stores all the data? (Multiple Choice)
- A. CD
- B. CPU
- C. Hard drive
- D. Monitor
- What is software in a computer? (Short Answer)
- Which of the following is an example of software? (Multiple Choice)
- A. Monitor
- B. Mouse
- C. Microsoft Word
- D. Flash drive
- Name two examples of application software. (Short Answer)
- Software is a physical part of the computer. (True / False)
- What is the purpose of software? (Short Answer)
- Identify the odd one out: (Multiple Choice)
- A. Excel
- B. Word
- C. Windows
- D. Keyboard
- Which of these is used for creating slides or presentations? (Multiple Choice)
- A. WordPad
- B. PowerPoint
- C. Paint
- D. Chrome
- What is the main function of an operating system? (Short Answer)
- Which of the following is NOT an operating system? (Multiple Choice)
- A. Windows
- B. Linux
- C. Google Docs
- D. macOS
- Briefly explain how to remove unwanted software from your personal computer. (Short Answer)
- You cannot use a computer without an operating system. (True / False)
- What operating system is most commonly found on school computers? (Multiple Choice)
- A. Linux
- B. Windows
- C. Android
- D. MS-DOS
- What role does the OS play when you want to open a file? (Short Answer)
- Which of these operating systems is open-source? (Multiple Choice)
- A. Linux
- B. macOS
- C. Windows
- D. iOS
- Match each OS with its company: (Matching / Grid)
- A. Windows → ____
- B. macOS → ____
- C. Linux → ____
- 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)
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 Section | Slides | Content Required |
|---|---|---|
| Introduction | 2 | Brief self-introduction and training recap; overview of what the presentation will cover |
| Hardware in the Workplace | 5 | Common hardware devices (laptops, printers, projectors); real-life example: how a receptionist uses hardware daily |
| Software Applications | 5 | Application software in use (MS Word, Excel, browsers); real-life example: how a secretary uses Word to write letters |
| Operating Systems | 3 | What an OS is and why it matters at work; example: choosing between Windows and macOS |
| Microsoft Office Suite | 7 | Uses of Word, Excel, and PowerPoint; include screenshots of mock tasks (sample spreadsheet, letter, slide deck) |
| Online Collaboration Tools | 3 | Google Workspace, Zoom, Microsoft Teams; how teams share documents and communicate online |
| Generative AI & Prompt Engineering | 3 | Efficient 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 & Takeaways | 2 | Difficulties 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.
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."
- 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)
- 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
COUNTto exclude non-numeric entries automatically
- Use an
IFfunction: display "Pass" if a student's average score ≥ 50, or "Fail" otherwise - Apply Conditional Formatting: "Fail" → red highlight | "Pass" → green highlight
- 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)
- 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
IF formulas based on the table below:
| Average Score | Grade | Remark |
| ≥ 70 | A | Excellent |
| 50 – 69 | B | Fair |
| < 50 | C | Needs Improvement |
- 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
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.
🔗 View original document on Google Drive
Pay close attention to: line spacing, font family, font size, margins, and page layout settings.
- 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
- 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
- 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"
Deadline: Friday, 11 July 2025
| Component | Format | Topics Covered | Weight |
|---|---|---|---|
| Theory Exam | Multiple 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 ethics | 40% |
| Practical Exam | Live computer tasks under timed conditions, observed by instructor | 1. 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% |
✏️ Capstone Submission Checklist
- 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.
- 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.
- 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.
- 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.
- 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.