Intent Statement

IT is one of the most important subjects for today’s society; this can be evidenced through Work Skill requirements and the importance that has been placed on Computers. To meet these challenges the department has created a variety of courses with the appropriate content to ensure students develop the necessary skills for their future employment. 

 

Powerful knowledge in IT: 

• Requirement to think creatively and innovatively to solve problems. 

• Provides students with new ways of thinking about the world using ‘big ideas’ such as Automation, Computerisation and the future of technology. 

• Provides students with powerful ways of analysing, explaining and understanding the world through modelling complex situations. 

• Gives students power over their own knowledge. 

• Gives students both theoretical and practical knowledge in order to develop products or solutions in an efficient way. 

• Developing problem solving skills and the ability to think logically. 

Department Information

IT is one of the most important subjects for today’s society; this can be evidenced through work skill requirements and the importance that has been placed on Computers.  To meet these challenges the department has created a variety of courses with the appropriate content to ensure students develop the necessary skills for their future employment.

 

 

Key Stage 5 I.T

OCR Level 3 Alternative Academic Qualification Cambridge Advanced National in IT: Data Analytics 

Year12 - Both Examined units and Year13 - NEA Units

Entry Requirements - Grade 5 GCSE English and Maths

 

For this qualification, students must complete five units:

 

·         Two mandatory externally assessed units             

o    Fundamentals of data analytics

o    Big data and machine learning

 

·         One mandatory NEA unit

o    Spreadsheet data modelling

 

·         Two optional NEA units

o    Relational database design

o    Data and the Internet of Everything (IoE)

o    Data visualisation

o    Data and digital marketing

 

Content overview

F200: Fundamentals of data analytics (exam)

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.

Topics include:

o Topic Area 1 Understanding data

o Topic Area 2 Managing data

o Topic Area 3 How data can be accessed and managed across platforms

o Topic Area 4 Legal considerations

o Topic Area 5 Job roles, skills and attributes in data analytics

 

F201: Big data and machine learning (exam)

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. Topics include:

o Topic Area 1 The scope of managing big data

o Topic Area 2 The Infrastructure challenges of big data

o Topic Area 3 Big data, machine learning and artificial intelligence

o Topic Area 4 Legal and ethical issues in data management

o Topic Area 5 Environment and society

 

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. Topics include:

o Topic Area 1 Principles of spreadsheet modelling

o Topic Area 2 Planning the design of a spreadsheet model

o Topic Area 3 Creating the spreadsheet model

o Topic Area 4 Delivering the outcomes

o Topic Area 5 Evaluation

 

F205: Data visualisation

This unit is assessed by an assignment.

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

o Topic Area 1 The value and importance of data visualisation

o Topic Area 2 Planning for data dashboards

o Topic Area 3 Techniques for creating a data dashboard

o Topic Area 4 Communicating information and interpreting data

o Topic Area 5 Evaluating the effectiveness of visualisation solutions

 

F206: Data and digital marketing

This unit is assessed by an assignment.

In this unit you will learn the principles of digital marketing, and the knowledge and skills required to plan, design, create and review digital marketing material that meets the needs of a specific client. Topics include:

o Topic Area 1 Digital marketing fundamentals

o Topic Area 2 Data driven digital marketing

o Topic Area 3 Planning digital marketing content

o Topic Area 4 Creating content for digital marketing campaigns

o Topic Area 5 Communicating to stakeholders

o Topic Area 6 Reflection and evaluation of working processes

 

Students can follow different pathways which are: IT Infrastructure Technician, Data analyst, Emerging Digital Technology Practitioner and Application Developer. Depending on the pathway followed will depend what coursework units are completed in year 13.

 

 

Curriculum Learning Journey