Certificate: Information Technology: End User Computing

Overview

To equip learners with the fundamental skills and knowledge required to operate effectively in a modern digital workplace. Graduates will be proficient in using office software, managing data, communicating online, and providing basic IT support.

Target Audience:

School leavers, career changers, administrative staff, and any individual seeking to improve their digital literacy for professional purposes.

Outline

Module 1: Basics of IT and Computer Systems

• Introduction to Computing:
  • The role of IT in the modern workplace.
  • Different types of computers (desktops, laptops, tablets, smartphones).
• Computer Hardware:
  • Core components: CPU, RAM, Hard Drive (HDD/SSD), Motherboard.
  • Input devices: Keyboard, Mouse, Scanner, Microphone.
  • Output devices: Monitor, Printer, Speakers.
  • Peripheral devices: External drives, Webcams.
• Computer Software:
  • Difference between System Software (Operating Systems) and Application Software.
  • Introduction to common operating systems (e.g., Windows, macOS).
• Using an Operating System (e.g., Windows):
• • Navigating the desktop, start menu, and file system.
  • System settings and configuration (display, sound, user accounts).
  • Installing, updating, and uninstalling software applications.
  • Basic system maintenance (disk cleanup, defragmentation).

Module 2: Office Software Suites

•  Word Processing (e.g., Microsoft Word / Google Docs)
  • Creating, saving, and managing documents.
  • Text formatting (fonts, styles, alignment, lists).
  • Document structure (headers, footers, page numbers).
  • Inserting and formatting images, shapes, and tables.
  • Using tools like Spell Check, Thesaurus, and Find & Replace.
  • Mastering page layout (margins, orientation, columns).
  • Mail Merge for bulk letters and labels.
• Spreadsheets (e.g., Microsoft Excel / Google Sheets)
  • Workbook and worksheet fundamentals.
  • Entering and formatting data.
  • Essential formulas and functions (SUM, AVERAGE, MIN, MAX, IF).
  • Cell referencing (relative vs. absolute).
  • Creating and formatting charts and graphs.
  • Sorting and filtering data.
  • Introduction to data analysis with PivotTables.
• Presentations (e.g., Microsoft PowerPoint / Google Slides)
• • Creating a presentation from a template and from scratch.
  • Adding, duplicating, and arranging slides.
  • Working with text, images, video, and SmartArt.
  • Applying slide transitions and object animations.
  • Design principles for effective presentations.
  • Rehearsing and delivering presentations (Presenter View).

Module 3: Internet and Email Communication

• The Internet and World Wide Web:
  • How the internet works (basic concepts).
  • Using web browsers (Chrome, Edge, Firefox).
  • Effective searching techniques and evaluating online information for credibility.
• Professional Email Communication:
  • Email etiquette (subject lines, salutations, clear messaging, signatures).
  • Managing an inbox: creating, replying, forwarding, organizing with folders/labels.
  • Attaching files and managing attachments.
• Online Collaboration & Cloud Tools:
  • Introduction to cloud storage (OneDrive, Google Drive).
  • Real-time co-authoring on documents.
  • Using calendar tools for scheduling meetings and appointments.
• Digital Citizenship and Security:
• • Understanding digital footprints.
  • Recognizing phishing scams, spam, and malware threats.
  • The importance of strong, unique passwords.

Module 4: Data Management and File Security

• File Management:
  • Understanding file structures, paths, and extensions.
  • Creating a logical folder hierarchy for work and personal data.
  • Naming files and folders consistently.
  • Copying, moving, renaming, and deleting files.
• Data Storage:
  • Different storage media (local hard drive, network drives, USB drives, cloud storage).
  • Understanding cloud sync vs. cloud backup.
• Data Security Principles:
• • Why data security is important for individuals and organizations.
  • Creating and managing strong passwords and using password managers.
  • Introduction to encryption and two-factor authentication (2FA).
  • Data backup strategies and performing regular backups.
  • Safe disposal of data and hardware.

Module 5: Problem Solving and IT Support

• The Problem-Solving Mindset:
  • Developing logical and structured thinking.
• Common End-User Issues:
  • Identifying typical problems (e.g., printer not working, no internet connection, application crashing, forgotten passwords).
• Basic Troubleshooting Methodology:
  • Step-by-step approach: Identify the problem -> Establish a theory -> Test the theory -> Implement a solution -> Verify functionality -> Document the outcome.
• Using Help Resources:
  • Effectively using built-in Help menus, online knowledge bases, forums, and support sites.
  • Learning how to phrase search queries to find solutions online.
• Providing User Support:
  • How to communicate technical issues clearly to a support technician.
  • Documenting problems and solutions for future reference (log a ticket).
• Introduction to IT Ethics and Policies:
• • Understanding Acceptable Use Policies (AUP).
  • Principles of data privacy and confidentiality.