The Cambridge Advanced National in IT: Data Analytics Extended Certificate is ideal for students who have an interest in IT and data and want to develop a solid foundation for future study, employment, or career progression in fields that involve data analysis and information technology.
What does the course involve?
The Cambridge Advanced National in IT: Data Analytics Extended Certificate is ideal for students who have an interest in IT and data and want to develop a solid foundation for future study, employment, or career progression in fields that involve data analysis and information technology.
The course will equip you with the confidence to use knowledge and skills relevant for progression to undergraduate study in IT or data-related fields. It covers the fundamentals of data analytics, Big Data, data modelling with spreadsheets and databases, the Internet of Everything and digital marketing.
Specifically, this qualification would be suitable for students planning a career in data-related fields, and is well suited to those who want to explore careers in fields like AI, Big Data, or Data Visualisation, where a foundation in IT and data analytics is crucial.
Course Outline
Components of the Course
Level 3 Certificate:
Fundamentals
Understanding Data
Managing Data
Cross-platform access
Legal considerations
Job roles and skills
Examination – 1 hour 15 minutes
Data Modelling
Spreadsheet modelling principles
Designing a spreadsheet model
Creating a spreadsheet model
Delivering the outcomes
Evaluation
Coursework task set by OCR
Level 3 Extended Certificate:
Internet of Everything
Concepts and issues
Data collection
Data transmission
User interface
Securing devices
Documentation
Relational Databases
Concepts
Planning
Creation
Testing
Evaluation
Two coursework tasks set by OCR
Big Data and AI
Managing Big Data
Infrastructure Issues
Machine Learning & AI
Environment & Society
Examination – 1 hour 30 minutes
Exam Board
Entry Requirements
A minimum of five GCSEs at grade 4 or above, including Maths and English. Preferably this should include IT or Computing but this is not essential.
Employability
This IT qualification can lead to careers such as Data Analyst, Business Analyst, Data Scientist and IT Specialist. It serves as preparation for undergraduate degrees in Data Science, Computer Science, IT Management or Business Analytics. The qualification also provides a useful foundation for subjects like economics, finance or other fields that require strong analytical and IT skills.
About Us
As the largest provider of 16-19 study programmes in the West Midlands, we are committed to ensuring that every young person has the opportunity to reach their full potential. We support our learners in developing their academic, personal and social skills so they are fully equipped for future progression to higher education, apprenticeships or employment.
The Sandwell family of colleges is comprised of three campuses – Cadbury Sixth Form College, providing A Level and vocational provision in Kings Norton; Central Campus, which focuses on the vocational offer for Sandwell; and Central St Michael’s, the A Level centre for Sandwell. Each campus offers a positive and inclusive learning environment to ensure that every student can excel and develop within their chosen field.
Renowned as a centre of excellence for young people, Cadbury Sixth Form College places high quality teaching, pastoral care, and strong student support at its heart. More than 50 A Levels, T Levels, BTEC Diplomas and Subsidiary Diplomas are delivered by the College’s specialist faculty, allowing students to build a strong skill set for the future.
The College is dedicated to creating a first-class learning environment and has recently completed the second phase of a multi-year, multi-million pound Science City development, providing a cutting-edge Science, Technology, Engineering & Maths (STEM) centre.
Located in West Bromwich, Sandwell College boasts best in class facilities and exceptional teaching standards. Alongside delivering outstanding pass rates, the College is proud to offer unrivalled mental health services and welfare support, ensuring that every student has access to the advice and guidance they need.
The College’s inspiring team of tutors go above and beyond to help their students achieve not only their qualifications, but also to guide them on their journey into work, further education, and university.
Highly regarded for its university-style campus and facilities, Central Saint Michael’s Sixth Form offers more than 30 different advanced courses to students. Learners can choose from core AS and A Level subjects alongside a range of specialist diplomas, creating a unique and flexible approach to learning, which is designed to suit the individual needs of sixth formers.
Students from the College go on to make their educational mark at Birmingham’s own universities, as well as leading institutions throughout the UK and across a range of subjects.
Tomorrow’s People is a specialist employer-focused delivery arm of Sandwell College, providing access to recruitment services for employers, vacancy matching and business-focused education and training right across the Midlands and beyond.
We work with businesses to support their strategic and operational plans, in particular workforce planning, to ensure a skilled and growing workforce. Courses and training from Apprenticeships, Professional Qualifications and bespoke delivery aim to keep your current workforce engaged and equipped in an ever-changing market.
Our Mission:
To provide and continuously develop and deliver an education of the highest quality, training and learning programmes that help improve the life chances and the economic prosperity of our learners, communities and businesses.
Our Vision:
To provide an exceptional, innovative, technologically advanced and inspirational teaching and learning experience leading to individuals’ success; and to be an anchor institution at the heart of our communities by working together with schools, employers and partner organisations to enrich lives, raise aspirations, encourage enterprise and improve social and economic well-being.
Power BI for Beginner is an introductory level course, where you will first get used to the term DAX (Data Analysis Expression), which is a collection of functions, constants, and operations used by Microsoft and used in some specific BI visualization tools.
DAX (Data Analysis Expressions) is the language of such analytical tools as PowerBI, Power Pivot and SQL server. Having a thorough understanding of DAX will allow you to develop visualisations and present data in any way you want.
Master the basics of DAX fast on this 1-day introduction to DAX course.
Power BI is one of the best drag and drop Business Intelligence (BI) tools, invented by Microsoft. This application/tool is prepared mainly for non-technical users so that they can aggregate, analyze, share, and visualize data with the help of all the business resources.
This is a hands-on course. We give you plenty of time to play with what you are being taught and ask questions. Our expert instructors break the course into easily digestible sections so that we can make sure that no-one is left behind.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy