Computing and IT Advanced Technician

Assessment

Autumn 1 Unit 5 Data Modelling A: Investigate data modelling and how it can be used in the decision-making process B: Design a data model to meet client requirements C: Develop a data model to meet client requirements Unit 1 Information Technology Systems: Written examination set and marked by Pearson. • 90 marks. • Two hours. · 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 Autumn 2 Unit 1 Information Technology Systems: Written examination set and marked by Pearson. • 90 marks. • Two hours. · D1 Threats to data, information and systems · D2 Protecting data · E1 Online services · E2 Impact on organisations · E3 Using and manipulating data · F1 Moral and ethical issues · F2 Legal issues Unit 6: Website development · A Understand the principles of website development Spring 1 Unit 6: Website development · B Design a website to meet client requirements · C Develop a website to meet client requirements Unit 2 Creating Information systems A task set and marked by Pearson and completed under supervised conditions. • The supervised assessment period is ten hours, arranged over a number of sessions in a one-week assessment period timetabled by Pearson. • Completed using a computer and submitted electronically. • 66 marks. · A1 Relational database management systems · A2 Manipulating data structures and data in relational databases · A3 Normalisation · B1 Relational database design · B2 Design documentation Spring 2 Unit 2 Creating Information systems · 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 Mock test for Unit 2 Unit 17: 2d and 3D digital graphics · A:Investigate the purpose and characteristics of digital graphics that are an important part of visual communications Summer 1 Unit 17: 2d and 3D digital graphics · B: Design 2D and 3D digital graphics products to meet a client brief · C: Develop 2D and 3D digital graphics products to meet a client brief. Unit 3: Using social Media in Business · A : Explore the impact of social media on the ways in which businesses promote their Summer 2 Unit 3: Using social Media in Business · B:Develop a plan to use social media in a business to meet requirements · C: Implement the use of social media in a business. Unit 19: The Internet of Things · A: Examine systems and services that form part of the Internet of Things · B: Develop a design for an Internet of Things system or device to solve a problem · C: Carry out the prototyping of an integrated Internet of Things system or device to solve a problem.