IT Skills Course

Lesson 1 • Hardware Components and Their Roles

Identifies and explains CPU, RAM, storage, and peripherals. Establishes the physical foundation needed to understand software behaviour and system performance.

Lesson 2 • Basic Troubleshooting Techniques

Introduces systematic problem-solving for common hardware and OS issues. Equips students to resolve everyday technical problems independently.

Lesson 3 • Navigating the Desktop Environment

Teaches efficient use of desktop interfaces, taskbars, and settings panels. Builds the hands-on fluency required for all subsequent software tasks.

Lesson 4 • File Management and Organisation

Develops skills for creating, naming, moving, and organising files and folders. Directly supports productivity in every later chapter involving documents and data.

Lesson 1 • Data Privacy and Responsible Online Behaviour

Addresses personal data protection, digital footprints, and acceptable use policies. Prepares students to act responsibly with organisational and personal data.

Lesson 2 • How Networks and the Internet Work

Explains IP addresses, routers, DNS, and data transmission concepts. Provides the conceptual grounding needed to troubleshoot connectivity and use cloud tools.

Lesson 3 • Effective Web Browser Use

Covers browser navigation, bookmarks, extensions, and privacy settings. Enables fast, organised, and secure web-based work throughout the course.

Lesson 4 • Password Management and Authentication

Teaches strong password creation, multi-factor authentication, and password managers. Directly reduces account compromise risk in professional environments.

Lesson 1 • Writing Effective Professional Emails

Teaches subject lines, tone, structure, and reply etiquette for workplace email. Ensures clear, concise communication that reflects professional standards.

Lesson 2 • Calendars and Scheduling Tools

Covers creating events, sharing calendars, and scheduling meetings digitally. Connects email skills to time management for a complete communication workflow.

Lesson 3 • Email Client Setup and Configuration

Covers account setup, signatures, and notification settings in email clients. Establishes a professional, organised email environment for all subsequent tasks.

Lesson 4 • Instant Messaging and Team Chat Platforms

Explores channels, direct messages, status indicators, and file sharing in chat tools. Prepares students for real-time collaboration in modern workplaces.

Lesson 1 • Reviewing, Tracking, and Collaboration

Covers track changes, comments, and version history for collaborative editing. Prepares students for document review workflows common in professional teams.

Lesson 2 • Document Creation and Basic Formatting

Covers fonts, paragraph spacing, alignment, and page setup fundamentals. Establishes the formatting baseline for all professional document work.

Lesson 3 • Tables, Lists, and Visual Elements

Introduces tables, bulleted lists, numbered lists, and inline images. Enhances document clarity and supports structured data presentation.

Lesson 4 • Styles, Headings, and Document Structure

Teaches heading styles, table of contents generation, and outline views. Enables consistent, navigable documents required in professional settings.

Lesson 1 • Spreadsheet Interface and Data Entry

Introduces cells, rows, columns, sheets, and efficient data entry techniques. Provides the structural foundation for all formula and analysis work ahead.

Lesson 2 • Core Formulas and Functions

Teaches SUM, AVERAGE, COUNT, IF, and lookup functions with practical examples. Enables automated calculation and data retrieval essential for analysis tasks.

Lesson 3 • Sorting, Filtering, and Data Validation

Introduces sort orders, filter dropdowns, and input validation rules. Ensures data integrity and enables efficient navigation of large datasets.

Lesson 4 • Data Formatting and Conditional Formatting

Covers number formats, date formats, and rule-based cell highlighting. Improves data readability and helps users spot trends and anomalies quickly.

Lesson 1 • Animations, Transitions, and Interactivity

Introduces entrance animations, slide transitions, and hyperlink navigation. Adds purposeful motion that guides audience attention without distraction.

Lesson 2 • Delivering and Sharing Presentations

Covers presenter view, slide show settings, export formats, and sharing options. Prepares students for live delivery and asynchronous distribution of decks.

Lesson 3 • Content Design and Visual Hierarchy

Teaches text placement, font contrast, colour theory, and whitespace use. Ensures slides communicate clearly without overwhelming the audience.

Lesson 4 • Inserting Media and Data Visuals

Covers inserting images, icons, charts, and embedded videos into slides. Enriches presentations with visual evidence that supports spoken content.

Lesson 1 • Remote Work Productivity and Etiquette

Addresses async communication norms, focus techniques, and digital workspace setup. Prepares students to maintain professionalism and output in remote roles.

Lesson 2 • Video Conferencing and Virtual Meetings

Teaches meeting setup, screen sharing, breakout rooms, and recording features. Equips students to run and participate in professional virtual meetings.

Lesson 3 • Cloud Storage Platforms and File Sync

Explains cloud storage concepts, sync clients, and folder sharing permissions. Builds the foundation for all cloud-based collaboration tasks in this chapter.

Lesson 4 • Project and Task Management Tools

Introduces task boards, assignments, due dates, and progress tracking in digital tools. Connects collaboration skills to organised project execution.

Lesson 1 • IT Documentation and Knowledge Management

Covers writing procedures, maintaining wikis, and version-controlling documentation. Ensures institutional knowledge is captured, accessible, and kept current.

Lesson 2 • Building Professional Reports and Dashboards

Teaches report layout, KPI selection, chart integration, and automated refresh. Produces decision-ready outputs that synthesise data from multiple sources.

Lesson 3 • Data Quality and Integrity Practices

Covers data cleaning, deduplication, validation rules, and audit trails. Ensures the accuracy and reliability of data used in professional reporting.

Lesson 4 • Workflow Automation and Macros

Introduces recorded macros, basic scripting logic, and automation triggers. Reduces repetitive manual tasks and increases throughput in IT workflows.