Professional IT Skills Course

Lesson 1 • Digital File and Data Organization

Establishes best practices for naming, storing, and retrieving digital assets. Reduces errors and time lost searching for information.

Lesson 2 • Navigating Operating Systems

Teaches file management, settings, and system tools across major desktop platforms. Enables efficient day-to-day computer operation.

Lesson 3 • Understanding Hardware and Software Basics

Covers the physical and logical components of computing systems. Establishes vocabulary needed for every subsequent chapter.

Lesson 1 • Calendar and Scheduling Tools

Covers digital calendar management, meeting invitations, and time-zone coordination. Reduces scheduling errors in distributed teams.

Lesson 2 • Collaborative Document Editing

Introduces real-time co-authoring, commenting, and version tracking in shared documents. Supports team-based deliverables introduced in later chapters.

Lesson 3 • Email Etiquette and Management

Covers composing, formatting, and organizing professional email. Connects digital communication norms to workplace credibility.

Lesson 4 • Instant Messaging and Team Chat Platforms

Teaches effective use of real-time messaging tools for team coordination. Builds habits that reduce email overload and speed up decisions.

Lesson 1 • Cloud Services and Remote Access

Explains cloud computing models and how to access remote systems securely. Prepares students for cloud-based workflows covered in later chapters.

Lesson 2 • Connecting Devices to Networks

Teaches the steps to configure and verify network connections on common devices. Builds self-sufficiency for common connectivity problems.

Lesson 3 • Internet Research and Evaluation

Develops skills for finding, filtering, and assessing online information quality. Supports evidence-based decision-making in professional tasks.

Lesson 1 • Device and Data Protection

Addresses encryption, screen locks, software updates, and secure disposal. Ensures data remains protected across the full device lifecycle.

Lesson 2 • Safe Browsing and Email Practices

Teaches recognition of malicious links, attachments, and spoofed senders. Connects directly to email skills from Chapter 2.

Lesson 3 • Understanding the Threat Landscape

Maps common attack types including phishing, malware, and social engineering. Contextualizes why security awareness is a professional responsibility.

Lesson 4 • Password and Authentication Security

Covers strong credential creation, multi-factor authentication, and password managers. Directly reduces the most common account compromise vectors.

Lesson 1 • Spreadsheet Auditing and Error Handling

Covers formula auditing tools, error functions, and documentation practices. Ensures spreadsheets are reliable and maintainable by others.

Lesson 2 • Structuring Data for Analysis

Teaches table design, data types, and validation rules that prevent errors upstream. Lays the groundwork for formulas and pivot tables.

Lesson 3 • Formulas and Functions

Covers logical, lookup, text, and statistical functions used in professional reporting. Builds on basic spreadsheet entry from Chapter 1.

Lesson 4 • PivotTables and Data Summarization

Introduces dynamic summarization of large datasets using pivot tables and grouping. Enables rapid insight generation without manual calculations.

Lesson 1 • Relational Database Fundamentals

Explains tables, keys, relationships, and normalization at a conceptual level. Provides the mental model required before writing any queries.

Lesson 2 • Aggregating and Grouping Data

Covers GROUP BY, HAVING, and aggregate functions for summary reporting. Mirrors pivot table logic from Chapter 5 in a SQL context.

Lesson 3 • Writing Basic SQL Queries

Teaches SELECT, WHERE, ORDER BY, and LIMIT clauses for data retrieval. Builds directly on data structuring concepts from Chapter 5.

Lesson 4 • Data Modification and Integrity

Introduces INSERT, UPDATE, DELETE, and transaction control statements. Teaches safe data modification practices to prevent irreversible errors.

Lesson 1 • Introduction to Workflow Automation

Introduces no-code and low-code automation tools for repetitive digital tasks. Builds on spreadsheet and communication skills to create time-saving workflows.

Lesson 2 • Agile and Waterfall Methodologies

Compares iterative and sequential project approaches with real IT examples. Enables students to select the right methodology for a given project.

Lesson 3 • Task and Project Tracking Tools

Teaches use of digital project boards, Gantt charts, and status dashboards. Connects communication tools from Chapter 2 to structured project oversight.

Lesson 4 • Scripting Basics for Task Automation

Covers simple scripts for file operations, data processing, and scheduled tasks. Extends automation capability beyond no-code tool limitations.

Lesson 1 • Digital Transformation Frameworks

Introduces maturity models and transformation roadmaps for digitizing business processes. Connects automation and data skills to enterprise-level change initiatives.

Lesson 2 • IT Governance and Risk Management

Covers governance frameworks, risk registers, and compliance monitoring for IT operations. Extends security knowledge from Chapter 4 to a strategic management level.

Lesson 3 • Evaluating Technology Solutions

Teaches cost-benefit analysis, vendor assessment, and total cost of ownership for IT tools. Builds on all prior technical knowledge to enable informed procurement decisions.

Lesson 4 • Data-Driven Decision-Making

Applies database and spreadsheet skills to build KPI dashboards and business cases. Translates analytical outputs into strategic recommendations.