Workshop: End User Computing

Course Objective:

To empower learners with the practical skills and knowledge to confidently use computer hardware, application software, and online collaboration tools to solve problems, communicate effectively, and perform basic IT troubleshooting.

Target Audience:

Individuals with little to no formal IT training, career changers, administrative staff, and anyone seeking to improve their digital literacy for personal or professional development.

Outline

Module 1: Introduction to Computing and IT Skills

• Computer Hardware & Software: Identifying core components (CPU, RAM, storage); understanding the difference between system and application software.
• Operating System Navigation: Proficiency in using Windows or macOS (file management, system settings, user accounts).
• File Management: Creating a logical folder structure; naming, moving, copying, and organizing files and folders.
• System Setup & Maintenance: Connecting peripherals (printers, drives); basic software installation and updates.
• IT Security Fundamentals: Creating strong passwords, recognizing phishing attempts, and understanding malware.

Module 2: Application Software Proficiency

• Word Processing (e.g., Microsoft Word/Google Docs): Creating, formatting, and reviewing documents; using templates; mail merge.
• Spreadsheets (e.g., Microsoft Excel/Google Sheets): Data entry, formatting, basic formulas and functions (SUM, AVERAGE, IF), creating charts and graphs.
• Presentation Software (e.g., PowerPoint/Google Slides): Designing effective slideshows; using themes, animations, and transitions; presenting skills.
• Database Fundamentals (e.g., Microsoft Access): Basic concepts of tables, forms, queries, and reports.

Module 3: Online Collaboration Tools

• Effective Web Use: Advanced search techniques; critically evaluating online information.
• Email Management: Professional email etiquette; managing calendars, contacts, and tasks within an email client.
• Cloud Storage & Collaboration: Using OneDrive, Google Drive, or Dropbox for file storage and sharing; real-time co-authoring on documents.
• Digital Communication Platforms: Effective use of instant messaging and video conferencing tools (e.g., Teams, Zoom) for meetings and teamwork.

Module 4: Problem Solving Using Technology

• Information Literacy: Using online resources to research and gather information for decision-making.
• Data-Driven Decisions: Using spreadsheet functions to organize and analyze data to identify trends and support conclusions.
• Automation Basics: Introduction to macros and simple automation tools to streamline repetitive tasks.
• Project Management Tools: Using basic features of applications like Trello or Planner to organize tasks and manage small projects.

Module 5: IT Support and Troubleshooting

• Troubleshooting Methodology: Applying a structured approach to identify and solve hardware and software problems.
• Common Issue Resolution: Solving problems with printers, network connectivity, frozen applications, and peripheral devices.
• Using Help Resources: Effectively using built-in OS help, online knowledge bases, and forums to find solutions.
• Professional Support Practices: How to accurately describe a problem to an IT support specialist and document the solution.