Learning Paths — Digital & Data Skills

Educational practice only. These modules teach methods and techniques. They do not guarantee employment, career advancement, or any specific professional outcome. Progress depends on individual practice and application.

Spreadsheet fluency for everyday work

This module builds confident use of core spreadsheet features. Learners practice writing reliable formulas, organising data in structured tables, applying sorting and filtering, and creating basic summary calculations. Emphasis is placed on habits that reduce errors and make work easy to revisit later. Exercises use realistic office-style data sets (sales records, inventory lists, attendance logs) rather than abstract examples.

Skills practiced: absolute and relative references, common functions (SUM, AVERAGE, COUNT, IF, VLOOKUP/XLOOKUP patterns), table structures, conditional formatting for clarity, basic error checking.

Practical data cleanup

Real data is rarely tidy. This module focuses on the systematic steps used to prepare information for analysis or reporting: identifying and handling missing values, standardising category labels, correcting date formats, removing or flagging duplicates, and validating calculations. Learners work through multi-step cleanup sequences and document their decisions so the process remains transparent.

Skills practiced: text cleaning functions, date parsing and reformatting, duplicate detection, consistent categorisation, basic validation rules, documenting cleanup steps for auditability.

Reading and interpreting data

Before creating charts or dashboards, it is useful to understand what numbers are saying. This module develops habits for examining tables, recognising patterns and anomalies, interpreting summary statistics, and asking clarifying questions about the source and meaning of data. Canadian workplace examples (regional sales, program participation, operational metrics) are used throughout.

Skills practiced: scanning large tables efficiently, understanding means versus medians in context, spotting outliers, reading percentage changes and rates, distinguishing absolute and relative differences.

Clear data visualization

Good charts make comparisons and trends visible without requiring the reader to decode unnecessary decoration. Learners practice selecting appropriate chart types (bar, line, simple scatter, pie only when composition is the point), labelling axes and series clearly, and avoiding common visual distortions. The goal is communication, not decoration.

Skills practiced: chart selection principles, axis scaling and labelling, colour use for clarity, avoiding 3-D and chartjunk, creating small multiples for comparison, exporting charts for documents and presentations.

Introductory dashboard thinking

A simple dashboard organises the most relevant figures so they can be reviewed regularly. This module covers the logic of choosing key metrics, arranging them for quick scanning, connecting summary views to underlying detail, and keeping the design maintainable. Learners build lightweight dashboard layouts in spreadsheet software rather than specialised tools.

Skills practiced: metric selection and prioritisation, layout patterns for overview-plus-detail, linking summary cells to source data, simple interactive filters, maintaining a dashboard as source data changes.

Digital workplace tools and collaboration

Many data tasks involve shared files, version control habits, and clear hand-offs between colleagues. This module addresses practical patterns for naming conventions, structured folders, commenting and documentation within files, and using common collaboration features without creating confusion. The focus remains on data and spreadsheet work rather than general productivity advice.

Skills practiced: file naming and version practices, protecting key ranges while allowing collaboration, documenting assumptions inside workbooks, preparing files for hand-off, basic shared-drive organisation for data projects.

Modules can be taken in sequence or selected according to current needs. Self-paced materials remain available for review. Optional live online sessions are scheduled periodically for discussion of exercises.

How the learning format works