LCA ICT Vocational Specialism

LCA ICT Vocational Specialism

Curriculum Mapping Student Devices
Pricing & Ordering Contact Us
This course develops advanced ICT vocational skills through four integrated specialisms aligned with Curriculum 2026. Students master professional word processing, create purposeful presentations, build and interpret spreadsheets for real-world data tasks, and cultivate critical digital literacy including online research, source evaluation, ethical practice, and safe digital citizenship. Practical key assignments and portfolio work emphasise precision, audience awareness, and reflective justification throughout.
Read more

Explore the Course

Click any lesson with to preview it

Basic Presentation Skills
Specialism Module 2 Kickoff: Why Presentation Matters and 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
Key Assignment 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
Specialism 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!, #VALUE!
Formula Auditing: Trace Dependents and Precedents
Cell Formatting: Colours, Hidden Rows and Columns, 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
Key Assignment Workshops
KA1 Workshop: Problem-solving Spreadsheet
KA2 Workshop: Graphical Data Representation and Interpretation
Basic Theory
Specialism 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 Actually Hang Out
Applications: Mobile, Calendar, Web Conferencing
Google Apps, 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 and the RAVA Test
Privacy, Data Protection, and the Student's 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
Key Assignment Workshops and Course Close
KA1 Workshop: Investigate and Present
KA2 Workshop: Reflection and Course Close

Basic Presentation Skills
Specialism Module 2 Kickoff: Why Presentation Matters and 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
Key Assignment 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
Specialism 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!, #VALUE!
Formula Auditing: Trace Dependents and Precedents
Cell Formatting: Colours, Hidden Rows and Columns, 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
Key Assignment Workshops
KA1 Workshop: Problem-solving Spreadsheet
KA2 Workshop: Graphical Data Representation and Interpretation

Basic Theory
Specialism 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 Actually Hang Out
Applications: Mobile, Calendar, Web Conferencing
Google Apps, 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 and the RAVA Test
Privacy, Data Protection, and the Student's 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
Key Assignment Workshops and Course Close
KA1 Workshop: Investigate and Present
KA2 Workshop: Reflection and Course Close

Curriculum Mapping

See exactly how this course maps to official curriculum specifications

LCA - ICT Vocational Specialism Module Descriptor
Curriculum Area
Outcomes
Module 1: Word processing
Unit 1: Basic theory
M1.U1.1 M1.U1.2 M1.U1.3
Unit 2: Entering and manipulating text
M1.U2.1 M1.U2.2 M1.U2.3
Unit 3: Additional techniques
M1.U3.1 M1.U3.2 M1.U3.3 M1.U3.4
Module 2: The Presentation of ideas
Unit 1: Basic presentation skills
M2.U1.1 M2.U1.2 M2.U1.3 M2.U1.4
Unit 2: Creating and editing
M2.U2.1 M2.U2.2 M2.U2.3 M2.U2.4
Unit 3: Additional techniques
M2.U3.1 M2.U3.2 M2.U3.3
Module 3: Spreadsheets
Unit 1: Basic spreadsheet theory
M3.U1.1 M3.U1.2 M3.U1.3 M3.U1.4
Unit 2: Creating and editing
M3.U2.1 M3.U2.2 M3.U2.3
Unit 3: Additional techniques
M3.U3.1 M3.U3.2 M3.U3.3 M3.U3.4
Module 4: The internet and digital literacy
Unit 1: Basic theory
M4.U1.1 M4.U1.2 M4.U1.3
Unit 2: Digital information literacy
M4.U2.1 M4.U2.2 M4.U2.3 M4.U2.4
Unit 3: Principles and practices
M4.U3.1 M4.U3.2 M4.U3.3

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.

What Students Will Learn

Learning Goals

  1. Master professional word processing techniques including advanced formatting, styles, templates, mail merge, and document design principles to produce publication-quality materials
  2. Develop effective presentation skills by analysing audience and purpose, applying universal design and accessibility principles, and creating, editing, and delivering engaging digital content across multiple formats
  3. Build practical spreadsheet competence in data organisation, formula construction, chart interpretation, error handling, and printing to solve real-world numerical problems
  4. Apply critical digital literacy skills including advanced search strategies, source evaluation using the RAVA test, accurate referencing, and understanding of online bias, creative rights, and digital footprints
  5. Demonstrate vocational capability through consistent use of professional workflows, reflective practice, portfolio development, and justification of digital choices in line with industry standards

Learning Outcomes

  1. Design and format complex, professional documents using templates, styles, advanced tables, mail merge, and linked tables of contents
  2. Create and deliver audience-appropriate presentations across multiple digital formats, applying universal design, accessibility features, and interactive elements
  3. Build, format and analyse multi-sheet spreadsheets using formulas, charts, filters, cell references and error auditing to solve real-world problems
  4. Conduct targeted online research, evaluate source reliability using the RAVA test, and reference information accurately
  5. Manage digital safety, protect personal data, maintain a positive digital footprint, and explain ethical and legal issues around online content and creative rights

What You'll Need

Student Devices

Students will need one of these devices. Students can share in groups of 2-3 if necessary.

Chromebook/Laptop/PC
Chromebook/Laptop/PC
iPad/Tablet
iPad/Tablet
Required Equipment

Equipment used in some of the lessons in this course. Items can be shared among students.

IWB/Projector/Large Screen
IWB/Projector/Large Screen

Ready to bring this course to your school?

Get in touch to discuss pricing and ordering for your school.

Pricing & Ordering Contact Us
Back to 5th Year courses
Ready to get started?
Pricing & Ordering Contact Us
🍪 Our website uses cookies to make your browsing experience better. By using our website you agree to our use of cookies. Learn more