Information Technology

Information Technology

Qualification

Applied

This is a vocational IT qualification designed to develop the skills, knowledge and understanding that today’s universities and employers demand.

Visit Subject website

The OCR Level 3 Cambridge Advanced National in IT: Data Analytics (Extended Certificate) is designed for students aged 16-19 who are interested in developing data analytics skills.

This course is suitable for students who want to:

  • Gain practical, applied IT skills alongside other qualifications.
  • Develop knowledge of data analytics, machine learning, and digital marketing.
  • Learn how to plan, develop, and review IT solutions for real-world clients.
  • Build skills needed for university study and careers in data analytics, IT, and business.

It is an alternative academic qualification that provides both theoretical knowledge and practical experience, preparing students for further study or employment in the information technology sector.

Course Content

Alternative Academic Qualification Cambridge Advanced National

Year 1

F200: Fundamentals of Data Analytics (exam)

This unit covers data collection, storage, analysis, and security, including big data, data assurance, and compliance. Students learn visualisation techniques and explore job roles in data analytics.

Understanding data maintenance ensures accurate decision-making, preventing errors and negative impacts on data holders across industries.

F202: Spreadsheet Data Modelling (NEA)

This unit covers data modelling using spreadsheets for business applications like forecasting. Students will learn to gather client requirements, use spreadsheet tools and techniques, and develop data-driven solutions. Emphasis is placed on designing, testing, and refining models to ensure they effectively meet client needs.

Year 2

F201: Big Data and Machine Learning (exam)

This unit explores the rapid growth of big data and its impact on businesses, governments, and society.

It covers data analytics, artificial intelligence,
and machine learning, highlighting their role in
innovation. Students will also examine challenges in managing big data, legal and ethical issues, and its applications in environmental and social developments.

F203: Relational Database Design (NEA)

This unit teaches students to design, create, and test relational databases for business use. They will learn to structure data, ensure accuracy, and improve accessibility. Skills include querying, form creation, report generation, and user interface design. Students will also test, refine, and evaluate database solutions based on feedback.

F205: Data Visualisation (NEA)

This unit teaches data processing, visualisation,
and communication skills to extract meaningful insights. You will learn to prepare data for analysis, design dashboards, and present trends visually. By transforming data sets into clear formats, you will support informed decision-making and effectively
communicate information using a data dashboard.

How it is Taught

The course combines theory and practical
learning through classroom teaching, hands-on workshops, and project-based assignments.
Students develop skills in spreadsheets,
databases, AI, and data visualisation. Learning
includes independent research, group work, and exam preparation, ensuring a strong foundation for higher education or careers in data analytics and IT.

Assessment Information

The qualification includes a mix of examined units and non examined assessment (NEA)
assignments. The exams assess core knowledge of data analytics, while the NEA units require students to apply their skills in
real-world projects.

Year 1

  • F200: Fundamentals of Data Analytics 20% (Exam)
  • F202: Spreadsheet Data Modelling 20%
    (NEA)

Year 2

  • F201: Big Data and Machine Learning 20% (Exam)
  • F203: Relational Database Design 20% (NEA)
  • F205: Data Visualisation 20% (NEA)
Entry Requirements

To enroll in this course, you should have a Grade 4 in GCSE English and Maths, along with meeting the general college entry requirements for Advanced Level study (refer to the latest Prospectus for details).

Prior study of Information Technology at GCSE is not required, and students without IT qualifications are welcome. Key skills and aptitudes will be assessed through your GCSE profile.

Please note that entry requirements may be subject to change due to curriculum reform.

Careers & HE Information

This qualification prepares students for higher education in fields like data science, AI,
cybersecurity, and IT management or careers as data analysts, business intelligence specialists, and database administrators. It
also supports apprenticeships in data analysis and software development, providing essential problem-solving and data-handling skills for various industries.

Useful Subject Combinations

A Level Business, Computing, Geography, Maths, A Level Psychology.

Privacy Policy

We regard your privacy as important and any personal information you give to us will be used in accordance with the Data Protection Act and the General Data Protection Regulations.

We do not store personal information about individuals who visit this site except where they provide contact information via our contact us page and contact forms available on various pages throughout the website.

Any information you provide will only be used for the reasons specified and it will not be shared with any third party without your consent, unless required by law.

Your contact details are kept securely and are only accessed by authorised members of staff as part of the provision of school services. If you do not wish us to keep this contact information please tell us.

This website uses Google Analytics which provides statistical data about the usage of the site. This information is not used to identify individuals, but is collected to provide us with an understanding of the areas of interest on our site and how our site is being used.

If you are connected to the internet you will have an IP Address. This may take the form of a figure, such as 333.333.22.1. The address will be automatically collected and logged as part of the connection of your computer to our web server and may be used to determine the total number of visits to each part of the site. This data is not collected and used for other purposes.

This website contains links to other websites. The School is not responsible for the privacy practices of other sites or organisations and recommends you consult the privacy information on those sites.

This policy will be reviewed and updated versions will be posted on the website.

If you have any questions about the use of your personal information, the Information Commissioner is the independent regulator for both Data Protection and Freedom of Information.