IT AS-Levels

I worked with the Hodder Education textbook [1]. The AS-Level IT curriculum builds on the IGCSE curriculum with the exception of a few areas such as PowerPoint which is only covered in the IGCSE.

1. Data Processing and information

There are a number of practical approaches to this theory, such as looking at implementations of validation and verification in Excel and Access to match the Checking the accuracy of data module.

2. Hardware and software

3. Monitoring and control

4. Algorithms and flowcharts

My approach to this section of work, which is covered theoretically in the textbook, is to use Turtle Academy and Scratch to take the final step to implement the planning as a working program.

5. eSecurity

6. The digital divide

7. Expert systems

8. Spreadsheets

There is no shortage of Excel help here at stylus!

Traffic cone warning icon.

Data for all practical assessments is provided in CSV file format. You must be adept at working with CSV files in Excel and remember to save your CSV as XLSX, or lose all your work!

9. Modelling

10. Database and file concepts

Traffic cone warning icon.

Data for all practical assessments is provided in CSV file format. You must be adept at importing CSV files in Access! See the post Importing data into Access.

Whilst the practical aspect of the databasing is done using Access, it is more than worth it to play around with another database if possible. You could easily set up MySQL Installer on Windows and play with MySQL Workbench which will give you a deeper understanding of tables, queries, relationships and ERD‘s.

11. Sound and video editing

Audacity logo.

Sound editing using Audacity.

Video editing using ClipChamp.


References:

  1. Brown, G., Sargent, G. (2021) Cambridge International AS Level Information Technology. London: Hodder Education.