Click any lesson with to preview it
| Basic Theory | ||
| Specialism Kickoff: Project, Portfolio, and What's Different | ||
| Professional Filing Framework: Deep Folder Structures | ||
| Document Templates: When, Why, How | ||
| Creating a Document from a Template | ||
| Advanced Save Options: Docx, Pdf, Odt, Rtf | ||
| Character and Word Formatting: Best Practice Rules | ||
| Paragraph and Line Spacing: Best Practice | ||
| Styles and the Styles Pane | ||
| Using Styles Consistently Across a Document | ||
| Unit 1 Recap and Document Formatting Workshop | ||
| Entering and Manipulating Text | ||
| Columns and Newspaper Layout | ||
| Page Orientation Changes Within a Document | ||
| Advanced Text Formatting: Shape, Colour, Effects | ||
| Inserting Special Characters and Symbols | ||
| Find and Replace: Advanced | ||
| Track Changes and Comments | ||
| Accepting and Rejecting Edits | ||
| Proofing Tools: Spell, Grammar, Readability | ||
| Manual Proofing Techniques | ||
| Unit 2 Recap and Multi-format Document Workshop | ||
| Additional Techniques | ||
| Advanced Tables: Merged Cells, Styles, Header Rows | ||
| Inserting and Formatting Images, Graphics, Drawn Objects | ||
| Headers, Footers, Section Breaks, Page Breaks | ||
| Pagination and Linked Table of Contents | ||
| Mail Merge Part 1: Data Source and Template | ||
| Mail Merge Part 2: Running the Merge | ||
| Design Principles: Layout, Hierarchy, Whitespace | ||
| Audience-driven Layout Evaluation | ||
| Module 1 KA Workshops | ||
| KA1 Workshop: Course Document and Skill Explanation | ||
| KA2 Workshop: Table-based Information Document | ||
| Basic Presentation Skills | ||
| Module 2 Kickoff: Why Presentation Matters and the VET Brief | ||
| Design Principles: a Tour of Well-designed Presentations | ||
| Design Principles: a Tour of Poorly-designed Presentations | ||
| Identifying Purpose of a Presentation | ||
| Identifying Audience | ||
| Requirements Analysis: Matching Format to Purpose and Audience | ||
| Accessibility Features in Presentations | ||
| Universal Design Principles | ||
| Applying Universal Design to Your VET Work | ||
| Unit 1 Recap and Design Critique Workshop | ||
| Creating and Editing | ||
| Choosing the Right Digital Format: Final Decision | ||
| Building a Slide Presentation: Structure First | ||
| Structure-first for Non-slide Formats | ||
| Content: Filling in the Structure | ||
| Editing, Formatting, Proofing: First Pass | ||
| Publishing in a Suitable Medium | ||
| Presenting to Peers: Pair Rehearsal Round 1 | ||
| Acting on Feedback | ||
| Benefits and Challenges of Digital Formats: Class Discussion | ||
| Unit 2 Recap and Format 2 Check-in | ||
| Additional Techniques | ||
| Templates and Template Manipulation | ||
| Motion: Slide Animations, Video Cuts, Capcut Effects | ||
| Interactive Components, Hooks, and Engagement Devices | ||
| Sound and Audio Integration | ||
| Engaging an Audience: Techniques That Work | ||
| Cross-format Comparison: When to Use Which | ||
| Module 2 KA Workshops and VET Handover | ||
| KA1 Workshop Part 1: Polish Format 1 | ||
| KA1 Workshop Part 2: Polish Format 2 | ||
| KA2 Workshop: Reflection and Justification | ||
| VET Handover: Final Rehearsal and Interview Prep | ||
| Basic Spreadsheet Theory | ||
| Module 3 Kickoff: Revisit Your Project Data | ||
| What Real People Actually Use Spreadsheets for | ||
| Default Templates: What's Available | ||
| Building from a Template | ||
| File Formats and Conversion | ||
| Data Input Best Practice | ||
| Data Manipulation: Select, Sort, Copy, Move, Delete | ||
| Multiple Worksheets: Copying, Moving, Deleting, Renaming | ||
| Logical Formulas with Standard Functions: Recap and Extend | ||
| Unit 1 Recap and Multi-sheet Workbook Workshop | ||
| Creating and Editing | ||
| VAT, Percentages, Currency Formatting | ||
| Tax Calculations with Formulas | ||
| Time and Date Data | ||
| Charts from Data: Going Deeper, with Real Data | ||
| Graphs and Data Tables | ||
| Advanced Chart Interpretation | ||
| Error Values: NAME, DIV/0, REF | ||
| Formula Auditing: Trace Dependents and Precedents | ||
| Cell Formatting: Colours, Hidden Rows, Toolbar Control | ||
| Unit 2 Recap and Enterprise Spreadsheet Workshop | ||
| Additional Techniques | ||
| Filters: Understanding and Applying | ||
| Standard Functions: SUM, AVERAGE, MIN, MAX, COUNT, ROUND | ||
| Cell References: Relative, Absolute, Mixed | ||
| Arithmetic Operators and Formula Construction | ||
| Page Setup for Printing: Margins, Orientation | ||
| Gridlines and Print Area Selection | ||
| Printing Selected Charts | ||
| Character, Field, Record, File, Data Type, Key Field | ||
| Module 3 KA Workshops | ||
| KA1 Workshop: Problem-solving Spreadsheet | ||
| KA2 Workshop: Graphical Data Representation and Interpretation | ||
| Basic Theory | ||
| Module 4 Kickoff: the Bigger Picture | ||
| Commonly-used Terms: Web Browsers, UI, Cloud Storage | ||
| Data Protection, Viruses, Malware, Spam: Deep Dive | ||
| Advanced Email: Attachments and Hyperlinks | ||
| Email Management: Searching, Sorting, Filing | ||
| Online Communities: Where Creators and Interest Groups Hang Out | ||
| Applications: Mobile, Calendar, Web Conferencing | ||
| Google Apps and Virtual Learning Environments | ||
| Digital Safety Risks: Cyberbullying, Identity Theft, Age of Consent | ||
| Unit 1 Recap and Safety Workshop | ||
| Digital Information Literacy | ||
| Search: Traditional Search, AI Search, and Knowing Which to Use | ||
| Targeted Search for Your Investigation Topic | ||
| Refining Search Results | ||
| Referencing Information Accurately | ||
| Authorship and Authenticity | ||
| Comparing Sources for Reliability | ||
| Validity, Accuracy, Authority (RAVA) | ||
| Privacy, Data Protection, and Your Digital Footprint | ||
| Digital Footprint: Positive and Negative | ||
| Unit 2 Recap and Research Workshop | ||
| Principles and Practices | ||
| Online Presentation Formats: Social Media Pages | ||
| Online Presentation Formats: Websites | ||
| Short-form Formats: Podcasts, Short Videos, Reels | ||
| Bias in Digital Media: News, Social, and Algorithmic | ||
| Creative Rights and Ownership | ||
| Plagiarism on the Internet | ||
| Open Source and Creative Commons | ||
| Ethical and Legal Debates | ||
| Module 4 KA Workshops and Course Close | ||
| KA1 Workshop: Investigate and Present | ||
| KA2 Workshop: Reflection and Course Close | ||
| Basic Theory | ||
| Specialism Kickoff: Project, Portfolio, and What's Different | ||
| Professional Filing Framework: Deep Folder Structures | ||
| Document Templates: When, Why, How | ||
| Creating a Document from a Template | ||
| Advanced Save Options: Docx, Pdf, Odt, Rtf | ||
| Character and Word Formatting: Best Practice Rules | ||
| Paragraph and Line Spacing: Best Practice | ||
| Styles and the Styles Pane | ||
| Using Styles Consistently Across a Document | ||
| Unit 1 Recap and Document Formatting Workshop | ||
| Entering and Manipulating Text | ||
| Columns and Newspaper Layout | ||
| Page Orientation Changes Within a Document | ||
| Advanced Text Formatting: Shape, Colour, Effects | ||
| Inserting Special Characters and Symbols | ||
| Find and Replace: Advanced | ||
| Track Changes and Comments | ||
| Accepting and Rejecting Edits | ||
| Proofing Tools: Spell, Grammar, Readability | ||
| Manual Proofing Techniques | ||
| Unit 2 Recap and Multi-format Document Workshop | ||
| Additional Techniques | ||
| Advanced Tables: Merged Cells, Styles, Header Rows | ||
| Inserting and Formatting Images, Graphics, Drawn Objects | ||
| Headers, Footers, Section Breaks, Page Breaks | ||
| Pagination and Linked Table of Contents | ||
| Mail Merge Part 1: Data Source and Template | ||
| Mail Merge Part 2: Running the Merge | ||
| Design Principles: Layout, Hierarchy, Whitespace | ||
| Audience-driven Layout Evaluation | ||
| Module 1 KA Workshops | ||
| KA1 Workshop: Course Document and Skill Explanation | ||
| KA2 Workshop: Table-based Information Document | ||
| Basic Presentation Skills | ||
| Module 2 Kickoff: Why Presentation Matters and the VET Brief | ||
| Design Principles: a Tour of Well-designed Presentations | ||
| Design Principles: a Tour of Poorly-designed Presentations | ||
| Identifying Purpose of a Presentation | ||
| Identifying Audience | ||
| Requirements Analysis: Matching Format to Purpose and Audience | ||
| Accessibility Features in Presentations | ||
| Universal Design Principles | ||
| Applying Universal Design to Your VET Work | ||
| Unit 1 Recap and Design Critique Workshop | ||
| Creating and Editing | ||
| Choosing the Right Digital Format: Final Decision | ||
| Building a Slide Presentation: Structure First | ||
| Structure-first for Non-slide Formats | ||
| Content: Filling in the Structure | ||
| Editing, Formatting, Proofing: First Pass | ||
| Publishing in a Suitable Medium | ||
| Presenting to Peers: Pair Rehearsal Round 1 | ||
| Acting on Feedback | ||
| Benefits and Challenges of Digital Formats: Class Discussion | ||
| Unit 2 Recap and Format 2 Check-in | ||
| Additional Techniques | ||
| Templates and Template Manipulation | ||
| Motion: Slide Animations, Video Cuts, Capcut Effects | ||
| Interactive Components, Hooks, and Engagement Devices | ||
| Sound and Audio Integration | ||
| Engaging an Audience: Techniques That Work | ||
| Cross-format Comparison: When to Use Which | ||
| Module 2 KA Workshops and VET Handover | ||
| KA1 Workshop Part 1: Polish Format 1 | ||
| KA1 Workshop Part 2: Polish Format 2 | ||
| KA2 Workshop: Reflection and Justification | ||
| VET Handover: Final Rehearsal and Interview Prep | ||
| Basic Spreadsheet Theory | ||
| Module 3 Kickoff: Revisit Your Project Data | ||
| What Real People Actually Use Spreadsheets for | ||
| Default Templates: What's Available | ||
| Building from a Template | ||
| File Formats and Conversion | ||
| Data Input Best Practice | ||
| Data Manipulation: Select, Sort, Copy, Move, Delete | ||
| Multiple Worksheets: Copying, Moving, Deleting, Renaming | ||
| Logical Formulas with Standard Functions: Recap and Extend | ||
| Unit 1 Recap and Multi-sheet Workbook Workshop | ||
| Creating and Editing | ||
| VAT, Percentages, Currency Formatting | ||
| Tax Calculations with Formulas | ||
| Time and Date Data | ||
| Charts from Data: Going Deeper, with Real Data | ||
| Graphs and Data Tables | ||
| Advanced Chart Interpretation | ||
| Error Values: NAME, DIV/0, REF | ||
| Formula Auditing: Trace Dependents and Precedents | ||
| Cell Formatting: Colours, Hidden Rows, Toolbar Control | ||
| Unit 2 Recap and Enterprise Spreadsheet Workshop | ||
| Additional Techniques | ||
| Filters: Understanding and Applying | ||
| Standard Functions: SUM, AVERAGE, MIN, MAX, COUNT, ROUND | ||
| Cell References: Relative, Absolute, Mixed | ||
| Arithmetic Operators and Formula Construction | ||
| Page Setup for Printing: Margins, Orientation | ||
| Gridlines and Print Area Selection | ||
| Printing Selected Charts | ||
| Character, Field, Record, File, Data Type, Key Field | ||
| Module 3 KA Workshops | ||
| KA1 Workshop: Problem-solving Spreadsheet | ||
| KA2 Workshop: Graphical Data Representation and Interpretation | ||
| Basic Theory | ||
| Module 4 Kickoff: the Bigger Picture | ||
| Commonly-used Terms: Web Browsers, UI, Cloud Storage | ||
| Data Protection, Viruses, Malware, Spam: Deep Dive | ||
| Advanced Email: Attachments and Hyperlinks | ||
| Email Management: Searching, Sorting, Filing | ||
| Online Communities: Where Creators and Interest Groups Hang Out | ||
| Applications: Mobile, Calendar, Web Conferencing | ||
| Google Apps and Virtual Learning Environments | ||
| Digital Safety Risks: Cyberbullying, Identity Theft, Age of Consent | ||
| Unit 1 Recap and Safety Workshop | ||
| Digital Information Literacy | ||
| Search: Traditional Search, AI Search, and Knowing Which to Use | ||
| Targeted Search for Your Investigation Topic | ||
| Refining Search Results | ||
| Referencing Information Accurately | ||
| Authorship and Authenticity | ||
| Comparing Sources for Reliability | ||
| Validity, Accuracy, Authority (RAVA) | ||
| Privacy, Data Protection, and Your Digital Footprint | ||
| Digital Footprint: Positive and Negative | ||
| Unit 2 Recap and Research Workshop | ||
| Principles and Practices | ||
| Online Presentation Formats: Social Media Pages | ||
| Online Presentation Formats: Websites | ||
| Short-form Formats: Podcasts, Short Videos, Reels | ||
| Bias in Digital Media: News, Social, and Algorithmic | ||
| Creative Rights and Ownership | ||
| Plagiarism on the Internet | ||
| Open Source and Creative Commons | ||
| Ethical and Legal Debates | ||
| Module 4 KA Workshops and Course Close | ||
| KA1 Workshop: Investigate and Present | ||
| KA2 Workshop: Reflection and Course Close | ||
See exactly how this course maps to official curriculum specifications
The curriculum does not include official reference codes for individual learning outcomes, so we have assigned a code scheme to make it easier to identify and track coverage.
Students will need one of these devices. Students can share in groups of 2-3 if necessary.
Get in touch to discuss pricing and ordering for your school.
.png)
