OCR Level 3 AAQ Cambridge Advanced National in IT

This AAQ in IT: Data Analytics will develop knowledge, understanding and skills that will help prepare you for progression to undergraduate study and is relevant to the information technology sector.

You might be interested in this qualification if you want to build applied or practical skills, to take alongside and enhance your A Levels or other Level 3 qualifications. You might be interested in this qualification if you want to apply what you learn to practical, real-life contexts, such as:

  • Planning, developing and reviewing spreadsheet data models that meet the needs of a client.
  • Planning, developing and reviewing relational databases that meet the needs of a client.
  • Planning, developing and reviewing digital marketing campaigns or Internet of Everything (IoE) solutions that meet the needs of a client.

PREFERRED ENTRY REQUIREMENTS

There is no requirement for students to achieve any specific qualifications before taking this course. An interest in how organisations use IT and computer systems is essential, as well as a commitment to explore and learn how to use new software!

UNITS STUDIED

For this qualification, students must complete five units:

Two exams (40%)

F200: Fundamentals of data analytics

F201: Big data and machine learning

Three NEA units (60%)

F202: Spreadsheet data modelling

F203: Relational database design

F204: Data and the Internet of Everything (IoE)

EXAM BOARD

OCR

COURSE ASSESSMENT DETAILS

Each exam is available in January and June and is paper-based.

F200: Fundamentals of data analytics

This unit is assessed by an exam.

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

F201: Big data and machine learning

This unit is assessed by an exam.

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.

All NEA assignments are set by OCR and are live for the two year window of the course.

F202: Spreadsheet data modelling

This unit is assessed by an assignment.

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.

F203: Relational database design

This unit is assessed by an assignment.

In this unit you will learn the principles of relational database design and the knowledge and skills required to plan, design, create, test and review a relational database design solution that meets the needs of a specific client.

F204: Data and the Internet of Everything (IoE)

This unit is assessed by an assignment.

In this unit you will learn the principles of the Internet of Everything (IoE), and the knowledge and skills required to plan, design and present an IoE solution that meets the needs of a specific client.

PROGRSSION AND CAREER OPPORTUNITIES  

This qualification will complement other learning that you’re completing at Key Stage 5. If you are a full-time student, it will be part of your studies along with A Levels and/or other Level 3 qualifications.

The subjects that complement this course

  • Business Studies
  • Media Studies
  • IT: Application Development
  • A Level Computer Science
  • A Level Maths or Economics
  • A Level Geography
  • A Level Psychology

The types of courses or apprenticeships you may progress to

Both the knowledge, understanding and skills, and broader transferable skills developed through these units, will help you progress to further study in related areas such as:

  • Business Technology
  • Business Analytics
  • Information Technology
  • Digital Marketing

This qualification is recognised in the UCAS tariff tables. More broadly, any technology qualification is very well regarded by employers in any organisation and sector.