Year 13 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
Curriculum Map - BTEC Level 3 National Extended Certificate in ICT Year 13 Dates Autumn Term 1 & Autumn Term 2 Spring Term 1 & Spring Term 2 Summer Term 1 & Summer Term 2 Links to prior learning Focus Unit 3 - Using Social Media In Business Unit 5 - Data Modelling Unit 1 - Information Systems & Unit 2 - Creating Information Systems Key Knowledge Learners explore how businesses use social media to promote their products and services. Learners also implement social media activities in a business to meet requirements. A1 Social media websites A2 Business uses of social media A3 Risks and issues B1 Social media planning processes B2 Business requirements B3 Content planning and publishing B4 Developing an online community B5 Developing a social media policy B6 Reviewing and refining plans C1 Creating accounts and profiles C2 Content creation and publication C3 Implementation of online community building C4 Data gathering and analysis C5 Skills, knowledge and behaviours Learners study the role of computer systems and the implications of their use in personal and professional situations A1 Stages in the decision making process A2 Spreadsheet features used to support data modelling A3 Using data modelling to consider alternatives A4 Evaluating models A5 Documenting and justifying decisions B1 Functional specification B2 Spreadsheet model design B3 Reviewing and refining data model designs C1 Developing a data model solution C2 Testing the data model solution C3 Reviewing and refining the data model solution C4 Skills, knowledge and behaviours Learners study the role of computer systems and the implications of their use in personal and professional situations. Unit 1 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 design, creation, testing and evaluation of a relational database system to manage information. Unit 2 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 Key Skills ● Research ● Business Plans ● Use of Social Media ● Timeline ● Planning ● Posting Schedule ● Written Work ● Graph Analysis ● Presentations ● Research ● Business Plans ● Use of Social Media ● Timeline ● Planning ● Posting Schedule ● Written Work ● Graph Analysis ● Presentations ● Research ● Networks ● Security ● Creating Online security ● Being safe online ● Communication ● People skills ● IT Skills ● Connectivity ● Networking ● DBMS ● ERD Design ● Data Structures ● Normalisation ● Database Design ● Microsoft Access ● Testing Database ● Data Dictionary ● Relational Design ● Producing Databases Ongoing assessment Internal Assessment - Coursework Learning aim: A (A.P1, A.P2, A.M1, A.D1) Learning aim: B (B.P3, B.P4, B.M2) Learning aim: C (C.P5, C.P6, C.M3, BC.D2, BC.D3) Internal Assessment - Coursework Learning aim: A (A.P1, A.P2, A.M1, A.D1) Learning aim: B (B.P3, B.P4, B.M2) Learning aim: C (C.P5, C.P6,C.P7, C.M3, BC.D2, BC.D3) 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 ) ● Practical exam practice for set task ● Extended writing ● quizzes ● Knowledge tests ( weekly ) ● PPE exam practice ● In class GEM tasks 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