Chiswick School DeskUnofficial parent project
Ask a question or search

Year 12 BTEC IT Curriculum Map 24 25 1

Selected information from the source. Open the full source for all details.

Open original school source ↗ · Full saved source

Checked 2026-09-14

Full saved source text

Open original school source ↗

Curriculum Map - BTEC Level 3 National Extended Certificate in ICT Year 12 Dates Autumn Term 1 Autumn Term 2 Spring Term 1 Spring Term 2 Summer Term 1 Summer Term 2 Links to prior learning J277:2.2.3 Additional programming techniques J277: Component units in paper 1 and 2 J277: Component units in paper 1 and 2 Focus Unit 2 - Creating Information Systems Unit 1 - Information Systems Unit 1 - Information Systems Key Knowledge Learners study the design, creation, testing and evaluation of a relational database system to manage information. In this unit, students will cover the following: A1 Relational database management systems A2 Manipulating data structures and data in relational databases A3 Normalisation B1 Relational database design B2 Design documentation C1 Producing a database solution C2 Testing and refining the database solution D1 Database design evaluation D2 Evaluation of database testing D3 Evaluation of the database Learners study the role of computer systems and the implications of their use in personal and professional situations. In this unit, students will cover the following: A1 Digital devices, their functions and use A2 Peripheral devices and media A3 Computer software in an IT system A4 Emerging technologies A5 Choosing IT systems B1 Connectivity B2 Networks B3 Issues relating to transmission of data C1 Online systems C2 Online communities D1 Threats to data, information and systems D2 Protecting data Learners study the role of computer systems and the implications of their use in personal and professional situations. In this unit, students will cover the following: A1 Digital devices, their functions and use A2 Peripheral devices and media A3 Computer software in an IT system A4 Emerging technologies A5 Choosing IT systems B1 Connectivity B2 Networks B3 Issues relating to transmission of data C1 Online systems C2 Online communities D1 Threats to data, information and systems D2 Protecting data Revision activities Unit 1 - Information Systems Key Skills ● DBMS ● ERD Design ● Data Structures ● Normalisation ● Database Design ● Microsoft Access ● Testing Database ● Data Dictionary ● Relational Design ● Producing Databases ● Research ● Networks ● Security ● Creating Online security ● Being safe online ● Communication ● People skills ● IT Skills ● Connectivity ● Networking ● Research ● Networks ● Security ● Creating Online security ● Being safe online ● Communication ● People skills ● IT Skills ● Connectivity ● Networking On going assessment ● Practical exam practice for set task ● Extended writing ● quizzes ● Knowledge tests ( weekly ) ● PPE exam practice ● In class GEM tasks Regular exam questions: GEM Tasks ( 2 per half term) Extended report writing - Exam practice ( Unit 1 ) Regular exam questions: Extended report writing - Exam practice ( Unit 1 ) Learning aim A and B coursework completion Regular exam questions: ● Extended report writing - Exam practice ( Unit 2 ) ● Link to University Link to Degree level Topic areas such as The BTEC National External certificate in ICT provides a vocational context in which learners can develop the knowledge and skills required for particular degree courses, including: Computer Science degrees

Source details