Computer Applications

1.Word Processing

Episode 1Introduction to Word Processing

Episode 2Creating, Saving and Opening Documents

Episode 2 Part 1Creating and Saving Documents PracticeEpisode 2 Part 2Creating, Saving and Opening DocumentsEpisode 2 Part 3Creating and Saving Documents Solutions · Solutions for Episode 2 Part 1

Episode 3Text Formatting (Fonts, Paragraphs, Styles)Episode 4Page Setup, Headers, Footers and Page Numbers

Episode 5Tables, Images and Shapes in Word

Episode 5 Part 1Tables, Images and Shapes PracticeEpisode 5 Part 2Tables, Images and Shapes in WordEpisode 5 Part 3Tables, Images and Shapes Solutions · Solutions for Episode 5 Part 1

Episode 6Mail Merge, Reviewing and Printing

Episode 6 Part 1Mail Merge and Printing PracticeEpisode 6 Part 2Mail Merge, Reviewing and PrintingEpisode 6 Part 3Mail Merge and Printing Solutions · Solutions for Episode 6 Part 1

Episode 7Word Processing Round-Up

Episode 7 Part 1Round-Up PracticeEpisode 7 Part 2Round-UpEpisode 7 Part 3Round-Up · Solutions for Episode 7 Part 1

2.Presentations

Episode 1Principles of Effective PresentationsEpisode 2Audience Analysis and Presentation Planning

Episode 3Creating and Formatting Slides

Episode 3 Part 1Creating and Formatting Slides PracticeEpisode 3 Part 2Creating and Formatting SlidesEpisode 3 Part 3Creating and Formatting Slides Solutions · Solutions for Episode 3 Part 1

Episode 4Themes, Templates and Slide Masters

Episode 4 Part 1Themes, Templates and Slide Masters PracticeEpisode 4 Part 2Themes, Templates and Slide MastersEpisode 4 Part 3Themes, Templates and Slide Masters Solutions · Solutions for Episode 4 Part 1

Episode 5Text, Images, Charts, Tables and SmartArt

Episode 5 Part 1Text, Images, Charts, Tables and SmartArt PracticeEpisode 5 Part 2Text, Images, Charts, Tables and SmartArtEpisode 5 Part 3Text, Images, Charts, Tables and SmartArt Solutions · Solutions for Episode 5 Part 1

Episode 6Multimedia Integration (Audio/Video)

Episode 6 Part 1Multimedia Integration PracticeEpisode 6 Part 2Multimedia Integration (Audio/Video)Episode 6 Part 3Multimedia Integration Solutions · Solutions for Episode 6 Part 1

Episode 7Animations and Transitions

Episode 7 Part 1Animations and Transitions PracticeEpisode 7 Part 2Animations and TransitionsEpisode 7 Part 3Animations and Transitions Solutions · Solutions for Episode 7 Part 1

Episode 8Visual Design PrinciplesEpisode 9Presentation Delivery Techniques

Episode 10Sharing Presentations Digitally

Episode 10 Part 1Sharing Presentations Digitally PracticeEpisode 10 Part 2Sharing Presentations DigitallyEpisode 10 Part 3Sharing Presentations Digitally Solutions · Solutions for Episode 10 Part 1

Episode 11Presentations Round-Up

Episode 11 Part 1Round-Up PracticeEpisode 11 Part 2Round-UpEpisode 11 Part 3Round-Up · Solutions for Episode 11 Part 1

3.Spreadsheets

Episode 1Workbook and Worksheet ManagementEpisode 2Data Entry and FormattingEpisode 3Data Validation and Error Checking

Episode 4Basic and Advanced Formulas

Episode 4 Part 1Formulas PracticeEpisode 4 Part 2Basic and Advanced FormulasEpisode 4 Part 3Formulas Solutions · Solutions for Episode 4 Part 1

Episode 5Functions (Logical, Statistical, Financial, Lookup)

Episode 5 Part 1Functions PracticeEpisode 5 Part 2Functions (Logical, Statistical, Financial, Lookup)Episode 5 Part 3Functions Solutions · Solutions for Episode 5 Part 1

Episode 6Sorting and Filtering DataEpisode 7Conditional Formatting

Episode 8Charts and Graphical Presentation of Data

Episode 8 Part 1Charts PracticeEpisode 8 Part 2Charts and Graphical Presentation of DataEpisode 8 Part 3Charts Solutions · Solutions for Episode 8 Part 1

Episode 9Pivot Tables and Summaries

Episode 9 Part 1Pivot Tables PracticeEpisode 9 Part 2Pivot Tables and SummariesEpisode 9 Part 3Pivot Tables Solutions · Solutions for Episode 9 Part 1

Episode 10What-If Analysis and Decision Support

Episode 10 Part 1What-If Analysis PracticeEpisode 10 Part 2What-If Analysis and Decision SupportEpisode 10 Part 3What-If Analysis Solutions · Solutions for Episode 10 Part 1

Episode 11Spreadsheet Applications in Business Decision-Making

Episode 11 Part 1Business Applications PracticeEpisode 11 Part 2Spreadsheet Applications in Business Decision-MakingEpisode 11 Part 3Business Applications Solutions · Solutions for Episode 11 Part 1

Episode 12Spreadsheets Round-Up

Episode 12 Part 1Round-Up PracticeEpisode 12 Part 2Round-UpEpisode 12 Part 3Round-Up · Solutions for Episode 12 Part 1

4.Databases

Episode 1Design and Manage Simple Database SolutionsEpisode 2Introduction to Databases and Database ApplicationsEpisode 3Database Terminology (Tables, Records, Fields)

Episode 4Creating and Managing Tables

Episode 4 Part 1Creating and Managing Tables PracticeEpisode 4 Part 2Creating and Managing TablesEpisode 4 Part 3Creating and Managing Tables Solutions · Solutions for Episode 4 Part 1

Episode 5Data Types and Validation Rules

Episode 6Creating Forms for Data Entry

Episode 6 Part 1Creating Forms PracticeEpisode 6 Part 2Creating Forms for Data EntryEpisode 6 Part 3Creating Forms Solutions · Solutions for Episode 6 Part 1

Episode 7Creating Queries for Information Retrieval

Episode 7 Part 1Creating Queries PracticeEpisode 7 Part 2Creating Queries for Information RetrievalEpisode 7 Part 3Creating Queries Solutions · Solutions for Episode 7 Part 1

Episode 8Generating Reports

Episode 8 Part 1Generating Reports PracticeEpisode 8 Part 2Generating ReportsEpisode 8 Part 3Generating Reports Solutions · Solutions for Episode 8 Part 1

Episode 9Basic Relationships Between Tables

Episode 9 Part 1Table Relationships PracticeEpisode 9 Part 2Basic Relationships Between TablesEpisode 9 Part 3Table Relationships Solutions · Solutions for Episode 9 Part 1

Episode 10Data Integrity and Security Principles

Episode 11Developing a Simple Database Application

Episode 11 Part 1Developing a Database Application PracticeEpisode 11 Part 2Developing a Simple Database ApplicationEpisode 11 Part 3Developing a Database Application Solutions · Solutions for Episode 11 Part 1

Episode 12Databases Round-Up

Episode 12 Part 1Round-Up PracticeEpisode 12 Part 2Round-UpEpisode 12 Part 3Round-Up · Solutions for Episode 12 Part 1

5.Internet and Electronic Communication

Episode 1Utilize Internet and Electronic Communication Tools ProfessionallyEpisode 2Internet Concepts and ServicesEpisode 3Effective Web Searching and Information Evaluation

Episode 4Email Creation and Professional Email Practices

Episode 4 Part 1Professional Email PracticeEpisode 4 Part 2Email Creation and Professional Email PracticesEpisode 4 Part 3Professional Email Solutions · Solutions for Episode 4 Part 1

Episode 5Online Collaboration ToolsEpisode 6Cloud Storage and File SharingEpisode 7Digital Identity and CitizenshipEpisode 8Basic Cybersecurity PracticesEpisode 9Safe and Ethical Use of Online Resources

Episode 10Integrating Computer Applications for Workplace Tasks

Episode 10 Part 1Integrating Applications PracticeEpisode 10 Part 2Integrating Computer Applications for Workplace TasksEpisode 10 Part 3Integrating Applications Solutions · Solutions for Episode 10 Part 1

Episode 11Internet and Electronic Communication Round-Up

Episode 11 Part 1Round-Up PracticeEpisode 11 Part 2Round-UpEpisode 11 Part 3Round-Up · Solutions for Episode 11 Part 1

6.Past Papers

Episode 1Past Papers 2018-2025

Episode 1 Part 1Past Paper QuestionsEpisode 1 Part 2Past Paper Solutions · Solutions for Episode 1 Part 1

7.General Resource

Episode 1Study Resource