LCA ICT Vocational Specialism

LCA ICT Vocational Specialism

Curriculum Mapping
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 Theory
Specialism Kickoff: Project, Portfolio, and What's Different Quiz
Project Folders That Stay Findable: Drafts, Finished, Evidence Quiz
Document Templates: When, Why, How Quiz
Creating a Document from a Template Quiz
Save and Export: .Docx, .Pdf, and .Rtf Quiz
Character and Word Formatting: Best Practice Rules Quiz
Paragraph and Line Spacing: Best Practice Quiz
Styles and the Styles Gallery Quiz
Using Styles Consistently Across a Document Quiz
Unit 1 Recap and Document Formatting Workshop Quiz
Entering and Manipulating Text
Columns and Newspaper Layout Quiz
Page Orientation Changes Within a Document Quiz
Advanced Text Formatting: Professional Headline Colour Quiz
Inserting Special Characters and Symbols Quiz
Find and Replace: Advanced Quiz
Track Changes and Comments Quiz
Accepting and Rejecting Edits Quiz
Proofing Tools: Spell, Grammar, Readability Quiz
Manual Proofing Techniques Quiz
Unit 2 Recap and Multi-format Document Workshop Quiz
Additional Techniques
Advanced Tables: Merged Cells, Styles, Header Rows Quiz
Inserting and Formatting Images, Graphics, Drawn Objects Quiz
Headers, Footers and Page Breaks: Cover Versus Body Quiz
Pagination and Linked Table of Contents Quiz
Mail Merge Part 1: Data Source and Template Quiz
Mail Merge Part 2: Running the Merge Quiz
Design Principles: Layout, Hierarchy, Whitespace Quiz
Audience-driven Layout Evaluation Quiz
Key Assignment Workshops
KA1 Workshop: Coursework Document and Skills Explanation Quiz
KA2 Workshop: Table-based Information Document Quiz
Basic Presentation Skills
Specialism Module 2 Kickoff: Why Presentation Matters and VET Brief Quiz
Design Principles: a Tour of Well-designed Presentations Quiz
Design Principles: a Tour of Poorly-designed Presentations Quiz
Identifying Purpose of a Presentation Quiz
Identifying Audience Quiz
Requirements Analysis: Matching Format to Purpose and Audience Quiz
Accessibility Features in Presentations Quiz
Universal Design Principles Quiz
Applying Universal Design to Your VET Work Quiz
Unit 1 Recap and Design Critique Workshop Quiz
Creating and Editing
Choosing the Right Digital Format: Final Decision Quiz
Building a Slide Presentation: Structure First Quiz
Structure-first for Non-slide Formats Quiz
Content: Filling in the Structure Quiz
Editing, Formatting, Proofing: First Pass Quiz
Publishing in a Suitable Medium Quiz
Presenting to Peers: Pair Rehearsal Round 1 Quiz
Acting on Feedback Quiz
Benefits and Challenges of Digital Formats: Class Discussion Quiz
Unit 2 Recap and Format 2 Check-in Quiz
Additional Techniques
Templates and Template Manipulation Quiz
Motion: Slide Animations, Video Cuts, Capcut Effects Quiz
Interactive Components, Hooks, and Engagement Devices Quiz
Sound and Audio Integration Quiz
Engaging an Audience: Techniques That Work Quiz
Cross-format Comparison: When to Use Which Quiz
Key Assignment Workshops and VET Handover
KA1 Workshop Part 1: Polish Format 1 Quiz
KA1 Workshop Part 2: Polish Format 2 Quiz
KA2 Workshop: Reflection and Justification Quiz
VET Handover: Final Rehearsal and Interview Prep Quiz
Basic Spreadsheet Theory
Specialism Module 3 Kickoff: Revisit Your Project Data Quiz
What Real People Actually Use Spreadsheets for Quiz
Default Templates: What's Available Quiz
Building from a Template Quiz
File Formats and Conversion Quiz
Data Input Best Practice Quiz
Data Manipulation: Select, Sort, Copy, Move, Delete Quiz
Multiple Worksheets: Copying, Moving, Deleting, Renaming Quiz
Logical Formulas with Standard Functions: Recap and Extend Quiz
Unit 1 Recap and Multi-sheet Workbook Workshop Quiz
Creating and Editing
VAT, Percentages, Currency Formatting Quiz
Tax Calculations with Formulas Quiz
Time and Date Data Quiz
Charts from Data: Going Deeper, with Real Data Quiz
Graphs and Data Tables Quiz
Advanced Chart Interpretation Quiz
Error Values: #NAME!, #DIV/0!, #REF!, #VALUE! Quiz
Formula Auditing: Trace Dependents and Precedents Quiz
Cell Formatting: Colours, Hidden Rows and Columns, Toolbar Control Quiz
Unit 2 Recap and Enterprise Spreadsheet Workshop Quiz
Additional Techniques
Filters: Understanding and Applying Quiz
Standard Functions: SUM, AVERAGE, MIN, MAX, COUNT, ROUND Quiz
Cell References: Relative, Absolute, Mixed Quiz
Arithmetic Operators and Formula Construction Quiz
Page Setup for Printing: Margins, Orientation Quiz
Gridlines and Print Area Selection Quiz
Printing Selected Charts Quiz
Character, Field, Record, File, Data Type, Key Field Quiz
Key Assignment Workshops
KA1 Workshop: Problem-solving Spreadsheet Quiz
KA2 Workshop: Graphical Data Representation and Interpretation Quiz
Basic Theory
Specialism Module 4 Kickoff: the Bigger Picture Quiz
Commonly-used Terms: Web Browsers, UI, Cloud Storage Quiz
Data Protection, Viruses, Malware, Spam: Deep Dive Quiz
Advanced Email: Attachments and Hyperlinks Quiz
Email Management: Searching, Sorting, Filing Quiz
Online Communities: Where Creators and Interest Groups Actually Hang Out Quiz
Applications: Mobile, Calendar, Web Conferencing Quiz
School VLE: Find Work and File Evidence Quiz
Digital Safety Risks: Cyberbullying, Identity Theft, and the Digital Age of Consent (16) Quiz
Unit 1 Recap and Safety Workshop Quiz
Digital Information Literacy
Search: Traditional Search, AI Search, and Knowing Which to Use Quiz
Targeted Search for Your Investigation Topic Quiz
Refining Search Results Quiz
Referencing Information Accurately Quiz
Authorship and Authenticity Quiz
Checking Whether Sources Are Independent Quiz
Reliability, Accuracy, Validity, Authority (RAVA) Quiz
Privacy, Data Protection, and the Student's Digital Footprint Quiz
Digital Footprint: Positive and Negative Quiz
Unit 2 Recap and Research Workshop Quiz
Principles and Practices
Online Presentation Formats: Social Media Pages Quiz
Online Presentation Formats: Websites Quiz
Short-form Formats: Vertical Video and Audio Explainers Quiz
Bias in Digital Media: News, Social, and Algorithmic Quiz
Creative Rights and Ownership Quiz
Avoiding Plagiarism in Your Investigation Quiz
Open Source and Creative Commons Quiz
Ethical and Legal Debates Quiz
Key Assignment Workshops and Course Close
KA1 Workshop: Investigate and Present Quiz
KA2 Workshop: Reflection and Course Close Quiz

Basic Theory
Specialism Kickoff: Project, Portfolio, and What's Different Quiz
Project Folders That Stay Findable: Drafts, Finished, Evidence Quiz
Document Templates: When, Why, How Quiz
Creating a Document from a Template Quiz
Save and Export: .Docx, .Pdf, and .Rtf Quiz
Character and Word Formatting: Best Practice Rules Quiz
Paragraph and Line Spacing: Best Practice Quiz
Styles and the Styles Gallery Quiz
Using Styles Consistently Across a Document Quiz
Unit 1 Recap and Document Formatting Workshop Quiz
Entering and Manipulating Text
Columns and Newspaper Layout Quiz
Page Orientation Changes Within a Document Quiz
Advanced Text Formatting: Professional Headline Colour Quiz
Inserting Special Characters and Symbols Quiz
Find and Replace: Advanced Quiz
Track Changes and Comments Quiz
Accepting and Rejecting Edits Quiz
Proofing Tools: Spell, Grammar, Readability Quiz
Manual Proofing Techniques Quiz
Unit 2 Recap and Multi-format Document Workshop Quiz
Additional Techniques
Advanced Tables: Merged Cells, Styles, Header Rows Quiz
Inserting and Formatting Images, Graphics, Drawn Objects Quiz
Headers, Footers and Page Breaks: Cover Versus Body Quiz
Pagination and Linked Table of Contents Quiz
Mail Merge Part 1: Data Source and Template Quiz
Mail Merge Part 2: Running the Merge Quiz
Design Principles: Layout, Hierarchy, Whitespace Quiz
Audience-driven Layout Evaluation Quiz
Key Assignment Workshops
KA1 Workshop: Coursework Document and Skills Explanation Quiz
KA2 Workshop: Table-based Information Document Quiz

Basic Presentation Skills
Specialism Module 2 Kickoff: Why Presentation Matters and VET Brief Quiz
Design Principles: a Tour of Well-designed Presentations Quiz
Design Principles: a Tour of Poorly-designed Presentations Quiz
Identifying Purpose of a Presentation Quiz
Identifying Audience Quiz
Requirements Analysis: Matching Format to Purpose and Audience Quiz
Accessibility Features in Presentations Quiz
Universal Design Principles Quiz
Applying Universal Design to Your VET Work Quiz
Unit 1 Recap and Design Critique Workshop Quiz
Creating and Editing
Choosing the Right Digital Format: Final Decision Quiz
Building a Slide Presentation: Structure First Quiz
Structure-first for Non-slide Formats Quiz
Content: Filling in the Structure Quiz
Editing, Formatting, Proofing: First Pass Quiz
Publishing in a Suitable Medium Quiz
Presenting to Peers: Pair Rehearsal Round 1 Quiz
Acting on Feedback Quiz
Benefits and Challenges of Digital Formats: Class Discussion Quiz
Unit 2 Recap and Format 2 Check-in Quiz
Additional Techniques
Templates and Template Manipulation Quiz
Motion: Slide Animations, Video Cuts, Capcut Effects Quiz
Interactive Components, Hooks, and Engagement Devices Quiz
Sound and Audio Integration Quiz
Engaging an Audience: Techniques That Work Quiz
Cross-format Comparison: When to Use Which Quiz
Key Assignment Workshops and VET Handover
KA1 Workshop Part 1: Polish Format 1 Quiz
KA1 Workshop Part 2: Polish Format 2 Quiz
KA2 Workshop: Reflection and Justification Quiz
VET Handover: Final Rehearsal and Interview Prep Quiz

Basic Spreadsheet Theory
Specialism Module 3 Kickoff: Revisit Your Project Data Quiz
What Real People Actually Use Spreadsheets for Quiz
Default Templates: What's Available Quiz
Building from a Template Quiz
File Formats and Conversion Quiz
Data Input Best Practice Quiz
Data Manipulation: Select, Sort, Copy, Move, Delete Quiz
Multiple Worksheets: Copying, Moving, Deleting, Renaming Quiz
Logical Formulas with Standard Functions: Recap and Extend Quiz
Unit 1 Recap and Multi-sheet Workbook Workshop Quiz
Creating and Editing
VAT, Percentages, Currency Formatting Quiz
Tax Calculations with Formulas Quiz
Time and Date Data Quiz
Charts from Data: Going Deeper, with Real Data Quiz
Graphs and Data Tables Quiz
Advanced Chart Interpretation Quiz
Error Values: #NAME!, #DIV/0!, #REF!, #VALUE! Quiz
Formula Auditing: Trace Dependents and Precedents Quiz
Cell Formatting: Colours, Hidden Rows and Columns, Toolbar Control Quiz
Unit 2 Recap and Enterprise Spreadsheet Workshop Quiz
Additional Techniques
Filters: Understanding and Applying Quiz
Standard Functions: SUM, AVERAGE, MIN, MAX, COUNT, ROUND Quiz
Cell References: Relative, Absolute, Mixed Quiz
Arithmetic Operators and Formula Construction Quiz
Page Setup for Printing: Margins, Orientation Quiz
Gridlines and Print Area Selection Quiz
Printing Selected Charts Quiz
Character, Field, Record, File, Data Type, Key Field Quiz
Key Assignment Workshops
KA1 Workshop: Problem-solving Spreadsheet Quiz
KA2 Workshop: Graphical Data Representation and Interpretation Quiz

Basic Theory
Specialism Module 4 Kickoff: the Bigger Picture Quiz
Commonly-used Terms: Web Browsers, UI, Cloud Storage Quiz
Data Protection, Viruses, Malware, Spam: Deep Dive Quiz
Advanced Email: Attachments and Hyperlinks Quiz
Email Management: Searching, Sorting, Filing Quiz
Online Communities: Where Creators and Interest Groups Actually Hang Out Quiz
Applications: Mobile, Calendar, Web Conferencing Quiz
School VLE: Find Work and File Evidence Quiz
Digital Safety Risks: Cyberbullying, Identity Theft, and the Digital Age of Consent (16) Quiz
Unit 1 Recap and Safety Workshop Quiz
Digital Information Literacy
Search: Traditional Search, AI Search, and Knowing Which to Use Quiz
Targeted Search for Your Investigation Topic Quiz
Refining Search Results Quiz
Referencing Information Accurately Quiz
Authorship and Authenticity Quiz
Checking Whether Sources Are Independent Quiz
Reliability, Accuracy, Validity, Authority (RAVA) Quiz
Privacy, Data Protection, and the Student's Digital Footprint Quiz
Digital Footprint: Positive and Negative Quiz
Unit 2 Recap and Research Workshop Quiz
Principles and Practices
Online Presentation Formats: Social Media Pages Quiz
Online Presentation Formats: Websites Quiz
Short-form Formats: Vertical Video and Audio Explainers Quiz
Bias in Digital Media: News, Social, and Algorithmic Quiz
Creative Rights and Ownership Quiz
Avoiding Plagiarism in Your Investigation Quiz
Open Source and Creative Commons Quiz
Ethical and Legal Debates Quiz
Key Assignment Workshops and Course Close
KA1 Workshop: Investigate and Present Quiz
KA2 Workshop: Reflection and Course Close Quiz

Teacher Resources

Everything you need to plan and teach the course, ready to download and print.

Teacher resource book

These are for teachers. Sign in to download them.

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

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