Grade 11

PAT 

• 2020

• 2021

• 2022 English   2022 Afrikaans

• 2023 Gr 11 IT PAT - also on Gr 11 IT page

PRACTICAL RESOURCES: DBE-Textbook

• Term 1:  Chapter 1 - Revision and Mathematical Functions

• • Data Files

  • Mr Long's YouTube channel

    • Error Checking student guide

    • Error Checking video

• Term 1:  Chapter 2 - Nested Loops

• • Data Files

• Term 2:  Chapter 3 - Arrays

• • Data Files

  • Mr Long's YouTube channel

    • Arrays student guide

    • Arrays summary

    • Arrays video

    • Mock Test 2020 Question 1

    • Mock Test 2020 Question 2

    • Mock Test 2020 Question 3

    • Mock Test 2020 Question 4

    • Mock Test 2020 Question 5

    • Arrays Part 1 - Introduction into arrays

    • Arrays Part 2 - Aggregate algorithms

    • Arrays Part 3 - More examples

    • Arrays Part 4 - Specific indices

    • Arrays Part 5 - Parallel arrays

    • Arrays Part 6 - Load array from a text file

    • Binary Search in arrays

    • Linear Search in arrays

    • Arrays - Removing duplicates

• Term 2:  Chapter 4 - String and data manipulation

• • Data Files

  • Mr Long's YouTube channel

    • String and data manipulation video

• Term 3:  Chapter 5 - Text Files

• • Data Files

  • Mr Long's YouTube channel

    • Text files video

    • Formatting into columns

    • Writing to a text file

    • Reading from a text file example

    • Reading from a text file

• Term 3:  Chapter 6 - User-defined methods

• • Data Files

  • Mr Long's YouTube channel

    • User-defined methods video

    • Functions and Procedures video

    • Subprograms Summary

    • Subprograms Student Guide

• Term 4:  Chapter 7 - User interfaces

• • Data Files

• Term 4:  Chapter 8 - Databases

• • Data Files

  • Mr Long's YouTube channel

    • Databases in Delphi - Connecting and Data Modules

    • Databases in Delphi - Sorting

    • Databases in Delphi - Extracting data from a database table

    • Databases in Delphi - Searching for multiple records in a database table

    • Databases in Delphi - Determining the Maximum and Minimum of a field

    • Editing Databases in Delphi - Inserting a new record

    • Databases in Delphi - Searching for one record in a table

    • Editing Databases in Delphi - Editing a current record

    • Editing Databases in Delphi - Deleting a record

    • Databases in Delphi - Connecting to a database using code

    • Database Objects video

    • Databases in Delphi by Mr Long 

    • Database in Delphi - Filter

    • Database in Delphi - Locate

    • Database in Delphi - Sorting

    • Database in Delphi - Connecting and Data modules

ADDITIONAL RESOURCES

Additional videos by Mr Long:  "Series on Microsoft Access Databases that particularly covers the content in Grade 11 and 12 CAT (Computer Applications Technology) and IT (Information Technology)."

• What is a database?

• Creating a database and tables

• Validation Rules

• Input Masks

• Lookup Wizard

• Basic Forms

• Improve your form

• Basic Reports

• Calculations in Reports

• Grouping in reports

• Reports based on queries

• Reports calculations with groupings

• Queries Part 1:  Basic queries

• Queries Part 2:  Between and IN queries

• Queries Part 3:  LIKE and NULL in queries 

• Queries Part 4:  Separate queries

• Queries Part 5:  Grouping in queries

• Queries Part 6:  Calculated Fields

• Queries Part 7:  More Examples of Calculated fields

• Date and Time Functions by Mr Long

  • Link to YouTube channel Part 1 to 3

  • Student Guide by Mr Long

  • Summary document by Mr Long 

• Dandel10n Delphi Books

  • Website

  • YouTube Channel

• Mr Long's YouTube channel

  • Dynamic Components

• P. Naidoo Youtube Channel

• Video Lessons - Joubert Duvenhage

Mr Long's YouTube channel

• • Selection Programming Part 6 - Radio group component

  • Selection programming Part 5 - Case Statements

  • Selection programming Part 4 - Checkbox component

  • Selection programming Part 3 - Nested IF Statements

  • Selection programming Part 2 - Multiple Conditions

  • Selection programming Part 1 - If Statements

Date and Time by Mr Long

• Part 1 

• Part 2 - Functions

• Part 3 - TDateTimePicker