Information Technology
Qualification
Applied
Course Overview
This is a vocational IT qualification designed to develop the skills, knowledge and understanding that today’s universities and employers demand.
Visit Subject websiteApplied
This is a vocational IT qualification designed to develop the skills, knowledge and understanding that today’s universities and employers demand.
Visit Subject websiteThe 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:
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.
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.
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.
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
Year 2
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.
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.
A Level Business, Computing, Geography, Maths, A Level Psychology.