Computer And ICT Literacy Program - With 10 Course Bundle

This introduction presents module one as a foundation in computer literacy, highlights completing the one day workshop, and outlines history, classifications, components, applications, maintenance, and the path to mastery.

Learn how a computer uses electricity to process input data through a CPU, memory, control unit, and logic unit, storing and presenting results via output devices.

Explore the essential computer system parts, from CPU, monitor, keyboard, and mouse to motherboard, processor, and hard disk, and learn how ports, peripherals, and network connections extend functionality.

Explore essential computer terminologies such as input, data, processing, information, and output. Learn about software and hardware, memory like RAM, and terms such as bug, debugging, firewall, and hard copy.

Explore the classifications of computers by type, purpose, and size, including analog, digital, and hybrid systems, as well as special purpose and general purpose models.

Explore the history and development of computers from the abacus to modern, portable devices, highlighting key innovators like Babbage, Pascal, Ada Lovelace, and the evolution of input, processing, and output.

Trace the evolution of computers from room-sized vacuum-tube systems to compact semiconductors and integrated circuits, highlighting memory, speed, heat, and cost across generations.

Learn the three software types: system software, application software, and utility software, and how operating systems like Windows, Mac OS, and Linux enable tasks.

Explore computer memory by contrasting primary memory (ram, volatile and temporary) with rom (non-volatile) and secondary memory (hard drives, discs, flash), emphasizing saving data for future reference.

Explore the applications of computers in society, including business, education, research, and marketing, highlighting document creation, data management, online learning, and internet-enabled services.

Explore the advantages of computers, including fast processing, vast storage, versatility, and reliability, alongside their disadvantages such as dependency, cost, training needs, and unemployment implications.

Explore how computer viruses harm systems by slowing performance, locking or destroying files, and hiding as trojan horses. Learn prevention methods, including antivirus, scanning downloads, and avoiding contaminated devices.

Learn essential computer care practices to keep devices healthy, including dust protection, antivirus installation, USB/external device scanning, avoiding eating or drinking near systems, and ensuring proper cooling.

Learn to use Windows, operate keyboard and mouse, personalize the desktop, manage files, create user accounts, install programs, and improve typing skills with Beacon software across a five-day path.

Explore how operating system software mediates between hardware and software, manages memory and startup, and enables Windows and other OS to run applications.

Learn to use a standard keyboard layout, function keys, and common shortcuts. Explore typing basics, two-symbol keys with shift, and essential shortcuts like enter and Ctrl.

Learn to use a mouse and touchpad, connect wired or wireless mice via USB, Bluetooth, or infrared, and master left, right, and double clicks, scrolling, and touchpad tapping.

Explore the Windows environment and master desktop icons, the taskbar, notification area, and chamber navigation. Learn to open apps, search, customize settings, and move through the start screen in Windows 8.1.

Learn to personalize your desktop background and environment via control panel or right-click, choosing a single image or slideshow, and adjusting themes, color schemes, icons, and taskbar settings.

Explore system icons to access user profiles, file explorer, and core folders, and master commands, control panel settings, and basic navigation for efficient Windows use.

Create and manage Windows user accounts, including default, guest, and child accounts, with admin or standard access; use control panel or pc settings to sign in and set passwords.

Create folders anywhere on your computer, including the desktop and file explorer, to group related files; then rename them with right-click or F2, and nest subfolders.

Connect your phone to the computer with USB, access the device via my computer or this pc, locate dcim/camera videos, copy them, and paste using ctrl+v to a desktop folder.

Learn to copy, cut, paste, and drag-and-drop files in Windows using keyboard shortcuts like Ctrl+C, Ctrl+V, and Ctrl+X to move items to desktop, folders, external drives, or zip archives.

Learn to delete and restore files in Windows using the recycle bin for temporary deletions and shift-delete for permanent deletion, with file recovery software as needed.

Learn to create shortcuts for apps and files in Windows by using the start screen, more apps, or the file location, then send to desktop or pin to the taskbar.

Learn to identify your computer's configurations — model, operating system, RAM, storage, and processor details — using this PC's properties, the control panel, and settings in Windows.

Explore easy access features in Windows, including magnifier, narrator, voice recognition, and on-screen keyboard, and learn to configure them via control panel or easy access center.

Learn how to access PC settings beyond the control panel in Windows, using PC settings, Start screen, and easy access tools to customize display, devices, time, privacy, and accessibility features.

Learn to install application software on your system from disk or online, unzip downloads, run the setup file with administrator rights, and accept terms for a standard installation.

Connect a flash drive to your system and use file explorer to view and copy files by dragging, dropping, or right-clicking copy and paste; then eject safely.

Learn to share your phone's internet with your laptop via a hotspot or USB tethering, including enabling wifi, setting a password, and connecting to the network.

Learn how to connect your phone's internet to your laptop using a USB cable, enable USB tethering in phone settings, and browse on your laptop while your phone charges.

Learn how to back up files to Microsoft OneDrive in Windows, access them from anywhere with internet, and save documents directly to the OneDrive folder for automatic cloud backup.

Master essential Windows shortcuts to navigate without a mouse, using escape for pop-ups, Ctrl+Z undo, Ctrl+Y redo, F1 help, F5 refresh, Alt+F4 close, and tab navigation.

Explore the fundamentals of internet technology, web concepts, and basic computer networks, then apply practical online skills in this introductory module with a four-day path to mastery.

Explore the internet as a global system of interconnected computers and devices. See how physical cables, including fiber optics, connect networks worldwide and enable access to servers and files.

Trace the internet's history from ARPANET to TCP/IP, highlighting how decentralizing communications and unique IP addresses enabled end-user access to a global network.

Explain how internet service providers enable end users to access the internet by managing infrastructure and data subscriptions. Compare dial-up, dsl, cable, satellite, and 3g/4g/5g connections.

Explore intranets as private networks within organizations for sharing information, collaboration tools, and computing services, and learn how LAN, WAN, and MAN connect departments.

discover how an extranet extends a private business network to authorized customers and partners, enabling secure access to private websites and resources through a public network.

Explore how the World Wide Web, a global system of interlinked documents with text, media, images, videos, and audios, relies on the internet to deliver online platforms.

Trace the web’s origins from Tim Berners-Lee’s 1989 HTTP invention to browser-based access on web servers. Explore how URLs, URIs, domain names, and HTML organize information.

Explore the web's blueprint by examining the internet, domain names, Uniform Resource Identifier, Uniform Resource Locator, and how browser, server, and Hypertext Transfer Protocol deliver platforms.

Discover how a web-based search engine indexes and ranks information using keywords, while explaining search engine optimization and how sites become discoverable.

Explore how the online world reshapes information access, communication, social networking, and ecommerce. Learn how the shift enables gig work, digital banking, and education for lifelong learning and self-employment.

Explore twenty years of internet growth, with 7.8 billion people and 5.1 billion online (65% penetration), Africa at 43%, and Nigeria around 70%, highlighting infrastructure barriers and marketing opportunities.

Cloud computing enables accessing programs, storing and processing data over the internet, letting you use computer features online without local installation.

Learn online safety basics, including antivirus and strong passwords, password managers. Verify brands and domains, download from reliable sources, and use payment gateways like Paystack and Flutterwave with https.

Explore practical web browser basics with Google Chrome and Edge. Learn to navigate using the address bar, search engines, tabs, bookmarks, and basic settings.

Learn how to browse online effectively using the address bar and search engines, locate platforms, access information, translate terms, check weather, and compare sources while researching.

Browse privately by using incognito mode and managing cookies. Understand cookies' role, privacy notices, and how clearing cookies affects your web experience.

Create a Gmail account and unlock access to Google business tools, YouTube, and 15 gb of google drive storage, guiding you through sign up, recovery options, and basic setup.

Learn to access a Gmail account, read and send emails, compose messages with attachments and links, and navigate inbox folders such as primary, social, promotions, and spam.

Get started with Microsoft Word processing by learning to create, edit, and format documents, explore the Word environment, locate commands, and follow a five-day plan to download and install Office.

Discover the basics of word processing, including creating, editing, saving, formatting, typesetting, and printing documents using Microsoft Word and Google Doc, alongside Notepad and Libre Office.

Explore the Microsoft Word 2013 interface, launching the app, navigating the document environment, and using the quick access toolbar, ribbon, and status bar to manage templates, views, and basic editing.

Set up your page size, margins, and orientation before typing to avoid disorganization. Apply column layouts, breaks, and optional line numbering to manage content flow.

Save your Word document with the initial save, then save continuously as you edit, and save in a different format like pdf using OneDrive or a local folder.

Format text and paragraphs in Microsoft Word 2013 by adjusting font style, size, color, alignment, line spacing, bullets, borders, and more.

Explore inserting and formatting images in Word, from online pictures and screenshots to images from your system, and control text wrapping, crop, size, color, effects, and arrange layering.

Use spelling and grammar tools to spot misspellings, fix capitalization, and replace words with appropriate synonyms. Learn to run spellcheck and use thesaurus features to refine document editing.

Learn to insert and format shapes, SmartArt, and charts in Word, edit text inside shapes, customize colors, and create charts from Excel data.

Learn to insert, format, and manage tables in a document, including adjusting columns and rows, merging cells, applying styles, and using quick table templates.

Learn to format a Word document by applying page color, borders, and watermark using the design menu, with options like textures, patterns, and pictures.

Master text box positioning to align and format text, and enhance documents with word art and drop cap styling.

Learn to use the find and replace command in Microsoft Word to locate occurrences, replace words with alternatives, and employ advanced find, replace, and go to options for large documents.

Learn to use Microsoft Word comments to annotate documents, offer feedback, and guide edits, then manage, navigate, and delete comments from the review and insert menus.

Learn to work with templates in Microsoft Word: find, download, and edit free and premium templates for CVs, flyers, or resumes; edit headers and save with your own file name.

Learn to insert and customize a table of contents in Microsoft Word by using heading formatting, header levels, and the reference tab, with automatic updates for chapters and topics.

Learn how to encrypt a Word document with a password to restrict access. The guide covers confirming and removing password, and using final or copying and printing restrictions for security.

Learn to print a Microsoft Word document using the file menu and print dialog. Set printer, pages, copies, and custom ranges, while applying default margins and page size.

Learn how to remove an image background in Microsoft Word using the remove background tool, adjust areas to keep, and save the edited image for use in other applications.

Master Microsoft Word by learning where to find commands—from the quick access toolbar to fonts, paragraph, hyperlinks, bookmarks, equations, symbols, date and time, and design and layout options.

Explore essential Microsoft Word shortcuts for Windows, including text highlighting, copying, pasting, formatting, alignment, undo/redo, and navigation, with Mac equivalents and practical tips.

Develop word processing skills by learning Google Docs alongside Microsoft Word, including creating, editing, typesetting, formatting, and printing documents in a cloud-based, no-installation environment.

Access Google Drive via Chrome or other browsers, sign in, upload files or folders, and share them with email or links using view, comment, or edit permissions.

Learn how to access Google Docs through Google Apps or search, explore the Google Docs environment, and use autosave, templates, and sharing permissions (view, comment, edit, ownership).

Set up the page size in Google Docs by adjusting margins, orientation, and color. Choose A4 or other sizes, and save these settings as default in page setup.

Learn how to format text in Google Docs, including font style and size, color, bold/italic/underline, headings, alignment, indentation, spacing, bullets, numbering, highlighting, and creating hyperlinks.

Learn how to insert images in Google Docs from computer, web, drive, photos, URL, or camera, using image options and quick access toolbar for basic formatting and wrap text.

Master creating and formatting tables in Google Docs, including color, outline, and text formatting, and build and edit charts via Google Sheets with the chart editor and customization options.

Learn to email a Google Docs document as an attachment, download in pdf, epub, or plain text, and use drawings, header and footer, and page numbers.

Explore Google Docs templates to quickly build resumes, CVs, letters, and proposals, customize placeholders, edit fonts and sections, and publish ready documents with add-on requirements.

Learn how to insert a table of contents in a Google Docs document, format headings for automatic updates, and include page numbers and clickable links.

Learn how to translate a Google Docs document into multiple languages with the translate document feature, duplicating the file to preserve the original, and choose languages like Spanish or Igbo.

Master Google Docs voice typing to convert speech to text, using tools, voice typing, and the control shift X shortcut; speak, edit, and format a full document quickly.

Learn to create a shareable Google Docs file and share it online with specific people or via a link, choosing view, comment, or edit permissions for collaborative work.

Print a Google Docs document by using the file menu or ctrl+p, then adjust page setup, margins, paper size, color, and printer options before printing a hard copy.

Master Google Docs basics by sharing, commenting, and reviewing documents; manage editing permissions, track changes with comments, and explore formatting tools like word count, footnotes, and special characters.

Learn how presentation software presents information in slides with text editing and media. Apply it in business, education, and graphic design with tools like Google Slides and PowerPoint.

Explore Microsoft PowerPoint, a key presentation tool in the Office suite, for adding and manipulating text and media on slides and delivering slides via a slideshow.

Explore the PowerPoint 2013 environment, including themes, blank templates, saving and recovering presentations, and design-driven features like slides, transitions, and slide show.

Compare Microsoft PowerPoint 2007 and 2013 interfaces, highlighting the office button, design and transition menus, and the shift from animation to custom animation while noting similar features including slide show.

Learn how to design and deliver effective presentations that communicate ideas, visions and plans using readable fonts, simple design, and audience focused delivery.

Set up slide size and apply a design in PowerPoint, choosing standard or widescreen, customizing orientation, and formatting colors, gradients, and backgrounds for the whole presentation.

Build presentation slides from scratch by designing layouts and inserting text and images. Learn formatting, image sourcing with copyright considerations, and transitions and animations.

discover how to save PowerPoint presentations in multiple formats, including PowerPoint presentation, OneDrive, images, a slideshow, PDF, and video, with continuous save.

Learn to apply and customize slide transitions in PowerPoint, preview timing, set durations and sound, and control slide shows with per-slide or global transitions.

Learn to add and customize PowerPoint animations, including entrance, emphasis, and motion paths, to create engaging slides. Discover timing options, mouse-click control, and automatic slide shows.

learn how to add audio to slides by inserting sound for individual slides, using wav file format limitations, and configuring playback such as start automatically, looping, or playing across slides.

Learn to create narrated slide shows with voiceover using a microphone, record from the beginning, and export your presentation as a video for online delivery.

Discover how to insert and customize videos in PowerPoint, including trimming, playback options, looping, borders, backgrounds, and online or local video sources.

Discover 11 tips for effective presentation delivery across live, screencast, or pre-recorded formats; focus on context, topic, audience, core message, eye contact, clear speech, gestures, and practice.

Master slide lets you apply universal formats across all slides, including logos, fonts, and backgrounds, via master view and layouts. It also supports notes, printouts, and slide handouts.

Explore how to use PowerPoint templates to quickly create slides and designs, download and enable editing, and customize text, images, and logos for slides, flyers, and business materials.

create a photo album in PowerPoint by importing images, choosing a layout, adding captions, and applying design options before exporting.

Learn how to remove image backgrounds in PowerPoint using the remove background tool, keep changes, and save the result as a new image.

Learn to record your screen with PowerPoint’s built-in screen recording tool, which creates watermark-free videos you can save as media, edit in a video editor, and publish online.

Master Microsoft PowerPoint in this final module, highlighting format painter, headers and footers, tables, comments, slide show, and custom slide shows, plus design and view options.

Master Google Slides to create, format, and deliver engaging slide decks with animations and transitions, exploring cloud-based tools and a three-day path to mastery.

Learn to build and design a Google Slides presentation from a blank slide, using layouts, text boxes, image insertion, and basic formatting to create a polished slide.

Learn to set a slide background by applying an image from online search, camera, URL, or Google Drive. Adjust text readability with colors or background effects.

Learn to add transitions and animations in Google Slides, apply them to slides or text, and control timing and order for smooth presentations.

Explore how to use google slide templates to quickly create polished presentations. Learn to replace images, customize layouts, duplicate slides, and import templates from go go slide templates.

Discover how to hyperlink between slides and to external websites in a Google Slides presentation by selecting text or objects, inserting a link, and choosing the destination.

Learn to deliver presentations with Google Slides using presenter view, slide notes, and audience questions for a timed, interactive session online or offline.

Explore Google Slides features, including inserting audio and video with timing, and adding shapes, tables, diagrams, and charts, plus sharing with edit or view permissions.

Master microsoft excel from beginner to intermediate, covering workbook creation, saving, data entry, formatting, formulas, functions, charts, and pivot tables.

Explore spreadsheet software, a rows and columns application that organizes, analyzes, and manipulates data with formulas and functions used in business, accounting, and education, focusing on Excel and Google Sheets.

Explore Excel, a spreadsheet tool in Microsoft Office, and compare Microsoft 365 with standalone installations. Review versions from 2013 to 2019 and practice in the Excel environment with a workbook.

Learn to navigate the Microsoft Excel environment, distinguishing workbooks from worksheets, identify cells, columns, and rows, and use the formula bar and quick access toolbar.

Learn to input and organize data in Excel worksheets with rows and columns by populating cells, using drag-and-fill, copying and pasting, and applying currency formatting to budgets.

Learn how to modify rows, columns, and cells in Excel, using drag to resize, auto fit, insert and delete rows or columns, and merge cells for header sections.

Format text in Excel by applying font style, size, color, bold, italic, underline, borders, and merged cells, plus basic table formatting and hiding rows or columns, and find and replace.

Learn how to create a new workbook and open existing ones in Excel, including navigating blank workbooks, recent documents, and the open command.

Learn how to save Excel workbooks using initial save, continuous save, and save in different formats (including PDF), with options to save to OneDrive or computer.

Master managing Excel worksheets within a workbook by adding, deleting, renaming, duplicating, and moving sheets. Group, hide, color the tabs, and navigate multiple sheets to organize monthly budgets and data.

Learn how to format numbers and dates in Excel, including currency and accounting formats, decimals, date and time formats, and percentages, with practical steps for applying formats to selected cells.

Learn how to apply simple formulas in Microsoft Excel, using the equal sign, cell references, and basic arithmetic operations like addition, subtraction, multiplication, and division.

Discover how to apply complex formulas in Excel using DAX rules—parentheses, exponent, multiplication/division, addition/subtraction—and bracket expressions to ensure correct results, illustrated with inventory cost calculations.

Learn how to use relative and absolute cell references in Excel, make key data absolute with dollar signs, and build a formula for selling price including tax and profit margin.

Learn how to use the autosum function in Excel to quickly sum data across a range, and explore basic functions like sum, average, max, min, and count.

Learn how the if function, a key Excel logical function, compares data and returns true or false values. See its use in stock restock decisions and student grading.

Discover how to insert images from computer, online sources, or screenshots into Excel worksheets. Format and arrange illustrations, shapes, and smart art with borders, colors, and layout options, background removal.

Learn to format data as a table in Excel to organize information for printouts, using header options, designs, and shading to create a clear, print-ready layout.

Set up Excel page layouts and prepare worksheets for printing by organizing data, applying table formats, and configuring print area, margins, orientation, header and footer, and print preview.

Apply conditional formatting in Excel to visualize data and spot trends. Use color scales, icons, and data bars to highlight scores and compare values clearly.

Learn to sort data by highest to lowest and filter data to print or present only selected records in Excel, using table formatting and filter buttons.

Learn to visualize data in Microsoft Excel by selecting appropriate chart types, such as column, line, and pie, after organizing data and using insert, design, and format options.

Learn to create and customize pivot tables and pivot charts in Excel to analyze, filter, and visualize data across months using drag-and-drop field placement.

Learn to use the subtotal function in excel to sum quantity and revenue by branch, choose functions (sum, average, max, min, count), apply filters, and understand grand totals.

Lock formulas in Excel by first unlocking all cells, then selecting formula cells with go to special, and applying worksheet protection (with an optional password) to restrict formula edits.

Discover how to password protect your Excel workbook and worksheet for confidential access. Lock all cells, protect formulas, and encrypt with password to manage protection.

Learn to work with templates in Microsoft Excel, read formulas, and structure data using payroll and other templates opened via the file menu and templates from Microsoft Office.

Learn to create and run your first Excel macro, record formatting steps for daily sales reports, use the Developer tab, assign a shortcut, and save as a macro-enabled workbook.

Master essential spreadsheet skills using Google Sheets, including data entry, formatting, formulas, charts, pivot tables, and data visualization, with a four-day path to mastery and practical action steps.

Get a practical overview of Google Sheets, navigating menus and toolbars, using the formula bar, sorting and filtering data, auto-saving in the cloud, and sharing with access controls.

Format cells in Google Sheets by applying font style, size, color, borders, and alignment; rotate text, wrap text, and apply currency, number, percentage, and date/time formatting to data.

Learn practical google sheets techniques to manage columns, rows, and cells, including auto-fit with double-click, inserting and deleting columns or rows, dragging data, and freezing or merging cells.

Learn to manage multiple worksheets in Google Sheets by adding, renaming, duplicating, coloring tabs, hiding, copying to another workbook, and protecting sheets.

Learn how to apply simple formulas in Google Sheets with the rule to start with equals, use cell references, and perform basic operations like addition, subtraction, multiplication, and division.

Master complex formulas in Google Sheets by applying the order of operations, using parentheses, exponentials, and left-to-right rules to compute selling price from cost and profit margin.

Explore functions in Google Sheets, including sum, average, count, maximum, minimum, and auto sum, and learn how to apply ranges and arguments to real data.

Master sorting and filtering data in Google Sheets using data ranges, ascending/descending order, and filter views for shared files.

Master conditional formatting in Google Sheets to enhance worksheets with manual and automatic colors, alternating colors, and customizable color schemes across selected data ranges.

Learn to insert and customize charts in Google Sheets, select data ranges, choose chart types, and move charts to new sheets for clear data visualization.

Learn to create and use a pivot table in Google Sheets to analyze student scores by subject, using rows, columns, values, and filters for flexible data analysis.

Explore essential Google Sheets features, including creating new worksheets, opening and importing workbooks, downloading in Microsoft Excel or PDF formats, sharing with others, and using formulas, images, and comments.