Year 12
Year 13
ICT (Year 12) Course Title: BTEC L3 National Extended Certificate in IT Grading: Distinction* - Pass Course Overview: (What will students learn?) Unit 1 – Information Technology Systems Information technology (IT) systems have a significant role in the world around us and play a part in almost everything we do. Having a sound understanding of how to effectively select and use appropriate IT systems will benefit you personally and professionally. You will explore the relationships between the hardware and software that form an IT system, and the way that systems work individually and together, as well as the relationship between the user and the system. You will examine issues related to the use of IT systems and the impact that they have on organisations and individuals. In this unit you will draw on your learning from across your programme to complete assessment tasks. This unit will give you a fundamental and synoptic understanding of all areas of IT, supporting your progression to an IT-related higher education course. Unit 2 – Creating systems to Manage Information In order to produce information to support many business processes as well as our social lives, relational databases are widely used to manage and process data. From the smallest in-house systems to stock control systems for large online retailers, databases are repositories of information that are a significant part of organisational operating requirements. You will examine the structure of data and its origins, and how an efficient data design follows through to an effective and useful database. You will examine a given scenario and develop an effective design solution to produce a database system. You will then test your solution to ensure that it works correctly. Finally, you will evaluate each stage of the development process and the effectiveness of your database solution. In this unit you will draw on your learning from across your programme to complete assessment tasks. The skills you gain in this unit support progression to IT-related higher education courses and to employment in a role that requires computing-related expertise. Unit 3 – Using Social Media in Business Social media websites are a popular way for people to communicate and share information with friends and family. People spend a lot of time on social media websites and they give businesses opportunities to interact with people, for example to promote their business, to encourage people to visit their e-commerce site and buy, to provide customer service. You may be familiar with social media for personal use and in this unit you will discover how it can be used in a business context. You will explore different social media websites, the ways in which they can be used and the potential pitfalls when using them for business purposes. You will develop a plan to use social media strategies for business purposes to achieve specific aims and objectives. You will then implement the plan, developing and posting content and interacting with others. Finally, you will collect data on the business use of social media and review the effectiveness of your efforts. Understanding how to use social media for business purposes is useful for employment in information technology and in a variety of business sectors. Also, social media skills are closely linked with web and mobile applications development. This unit gives you a starting point for progression to roles such as social media specialist, content developer and web developer. Unit 5 – Data Modelling In all aspects of life, individuals are constantly faced with situations where they must weigh up the available information in order to produce alternatives and make decisions. In the working environment, effective decision making can ensure the successful development of organisations. Poor decision making can have significant negative consequences and can even lead to the demise of an organisation. In this unit, you will investigate the fundamentals of the decision-making process. You will find out how using data modelling provides the computational ability to compare consequences, and determine a preferred course of action. You will develop the skills and techniques necessary to create complex spreadsheets in order to produce accurate information that informs decision making. You will examine a scenario and then design, develop and test a spreadsheet; you will review your spreadsheet and make refinements based on user feedback, providing an evaluation of the effectiveness of the alternatives produced. The skills developed in this unit are useful for progression to computing or business-related higher education courses and for use in decision making in the workplace. External Assessment: Unit 1: Information Technology Systems 2 hour Written Examination, marked external - 90 marks Points for Pass: 12 Merit: 20 Distinction: 32 Unit 2: Creating Systems to manage Information 10 hour assessment task, marked external - 66 marks Points for Pass: 9 Merit: 15 Distinction: 24 Unit 3: Using Social Media in Business Internal Coursework Points for Pass: 9 Merit: 15 Distinction: 24 Unit 5: Data Modelling Internal Coursework Points for Pass: 6 Merit: 10 Distinction: 16 Edexcel BTEC Level 3 National Extended Certificate in IT Points needed to achieve each grade: Pass 36 Merit 52 Distinction 74 Distinction* 90 Internal Assessment: Pupils will be assessed using both written and practical assessments (where appropriate) on a half-termly basis. Pupils will be expected to revise current as well as past topics of study to enable them to develop a long-term memory to ensure that they are fully prepared to sit their Level 3 examinations.
ICT (Year 13) Course Title: BTEC Level 3 Subsidiary Diploma in IT Grading: Distinction* - Pass Course Overview: (What will students learn?) Unit 1: Communication and Employability Skills (Year 12) The aim of this unit is to ensure that learners understand both the personal attributes valued by employers and the principles of communicating effectively whist developing effective communication skills and addressing their own personal development needs. Learning outcomes On completion of this unit a learner should: Understand the personal attributes valued by employers Understand the principles of effective communication Be able to use IT to communicate effectively Be able to address personal development needs. Unit 2: Computer Systems (Year 12) The aim of this unit is to enable learners to understand the components of computer systems and develop the skills needed to recommend appropriate systems for business purposes and set up and maintain computer systems. Learning outcomes On completion of this unit a learner should: Understand the components of computer systems Be able to recommend computer systems for a business purpose Be able to set up and maintain computer systems. Unit 30: Digital Graphics (Year 12) This unit aims to enable learners to understand different types of digital graphics images and file formats and to be able to create, edit, modify and manipulate digital images of various types and complexity. Learning outcomes On completion of this unit a learner should: Know the hardware and software required to work with graphic images Understand types of graphic images and graphical file formats Be able to use editing tools to edit and manipulate images Be able to create and modify graphic images to meet user requirements. Unit 18: Databases (Year 13) The aim of this unit is to enable learners to understand the features of relational databases and to develop the skills necessary to design, create, populate and test a relational database incorporating advanced features. Learning outcomes On completion of this unit a learner should: Understand the features of relational databases Be able to design, create and populate a relational database Be able to test a relational database. Unit 22: Developing Computer Games (Year 13) The aim of this unit is to ensure learners know about different types of computer game, understand the impact gaming has on society and are able to design, develop, test and document computer games. Learning outcomes On completion of this unit a learner should: Understand the impact of the gaming revolution on society Know the different types of computer game Be able to design and develop computer games Be able to test and document computer games. Unit 28: Website Development (Year 13) The aim of this unit is to enable a learner to understand web architecture and the factors that affect its performance and to be able to design and create interactive websites. Learning outcomes On completion of this unit a learner should: Understand web architecture and components Understand the factors that influence website performance Be able to design websites Be able to create websites. External Assessment: All units are marked and graded internally and then externally verified by Pearson. All unis carry equal weighting.
Links & Resources
Lightcliffe Academy, Stoney Lane, Lightcliffe, Halifax, HX3 8TL Tel: 01422 201028 Fax: 01422 204615 contactus@lightcliffeacademy.co.uk Abbey Multi Academy Trust, c/o Chapter House, Abbey Grange Church of England Academy, Butcher Hill, Leeds, LS16 5EA Tel: 0113 257877 enquiries@abbeytrust.org
Company No.: 07705552