AAQ IT Apply now

You will complete two units that will be examined:

Unit F200: Fundamentals of data analytics

In this unit you will learn about the fundamental knowledge required for a career working in data-related occupations. Topics include:

• Topic Area 1 Understanding data
• Topic Area 2 Managing data
• Topic Area 3 How data can be accessed and managed across platforms
• Topic Area 4 Legal considerations
• Topic Area 5 Job roles, skills and attributes in data analytics

Unit F201: Big data and machine learning

In this unit you will learn about the challenges of managing big data and the role of artificial intelligence and machine learning in data science. Topics include:

• Topic Area 1 The scope of managing big data
• Topic Area 2 The Infrastructure challenges of big data
• Topic Area 3 Big data, machine learning and artificial intelligence
• Topic Area 4 Legal and ethical issues in data management
• Topic Area 5 Environment and society

You will then complete 3 NEA/coursework units

Unit F202: Spreadsheet data modelling

In this unit you will learn the principles of data modelling with spreadsheets and the knowledge and skills required to plan, design, create, test and review a spreadsheet modelling solution that meets the needs of a specific client. Topics include:

• Topic Area 1 Principles of spreadsheet modelling
• Topic Area 2 Planning the design of a spreadsheet model
• Topic Area 3 Creating the spreadsheet model
• Topic Area 4 Delivering the outcomes
• Topic Area 5 Evaluation

Unit F203: Relational database design

This unit will provide you with the knowledge and skills to create and test a relational database. Relational databases are the most common type of databases used in business today. Relational databases are used by many different organisations to store and manipulate data. Using a relational database model will ensure that data is structured, accurate and accessible to all users

• Topic Area 1 Relational database concepts
• Topic Area 2 Plan relational database solutions
• Topic Area 3 Create relational databases
• Topic Area 4 Testing relational database solutions
• Topic Area 5 Evaluate database solutions

Unit F206: Data and digital marketing

Digital marketing has become important as organisations and individuals have started using digital devices and social media channels to communicate messages to a wider audience. Many people spend hours online and the ability to reach them has become more and more important. Digital marketing can take many forms, including video, pop up advertisements, and social media posts. The use of data allows digital marketing to target specific individuals and groups. This results in digital marketing providing a much more cost effective and efficient method of communication.

• Topic Area 1 Digital marketing fundamentals
• Topic Area 2 Data driven digital marketing
• Topic Area 3 Planning digital marketing content
• Topic Area 4 Creating content for digital marketing campaigns
• Topic Area 5 Communicating to stakeholders

The examination board isAQAOCR. The course will be examined in the following way:

The course is 40% examined and 60% coursework.

The Extended Certificate in IT (AAQ) qualifies for the same UCAS points as the traditional A-levels. Former students who have completed this qualification have been able to move on to work, Degrees/HNDs and Higher Apprenticeships in related subjects such as:

• ICT and Business
• Information Systems
• Systems Design and Analysis
• Cyber Security
• Digital Product Development

Well-qualified and experienced staff teach the five units of study. Students will learn the required knowledge through case studies, group work and presentations before completing assignments that are based on realistic workplace situations.

The college has an excellent network of up-to-date computers and the department has access to dedicated IT/Computing teaching rooms. There is also an extensive range of computing facilities available outside of lessons.

Facilities include popular office software, professional web development and graphics programs, colour printing, scanners, internet access, overhead digital projectors and interactive whiteboards. We also use video cameras, digital cameras and sound equipment.