This folder contains the following resources: A practice exam, based on the new January 2020 exam layout for the BTEC National IT Unit 2 Creating systems to manage information externally assessed unit, and corresponding mark scheme. It has been developed to give students experience of tackling the new, shorter, 5 hour practical exam. Movies Part A solution database which can be amended or used as teaching aid. Movies Part B solution database, complete with relevant Macros, which can be amended and given to students or used as teaching aid. Activity 2, 3, 4, 6 and 7 templates required for students to complete the tasks in the practice exam.

BTEC Tech Award in digital information technology Component 2 Component 2 involves the creation of a Dashboard using Excel, covering quite a few complex functions and formulae. The resources in this pack have been designed to give all students the opportunity to aim for the Distinction grade and can therefore be differentiated according to the needs of an individual group. The presentations are designed to give the students a guide as to what to put in their work and will be supported by teacher’s individual lessons or one on one interventions as and when required. They will be vital in helping students become as independent as possible which considering the nature of the qualification is key to success, as students will invariably find themselves at different stages of the assignments very quickly. The folder contains the following files: “Learning Aim A”, “Learning Aim B” and “Learning Aim C” presentations. These detailed presentations are to be used alongside Pearson assignments and teacher led lessons. They will help students develop a more independent style of working and should alleviate some of the workload felt by the class teacher. “Holiday Data Macro” enabled spreadsheet and “Holiday Data” spreadsheet. The macro enabled spreadsheet has an example of all functions and formulae used in section B of component 2, and would is an excellent teaching aid and reference point for students. Students will be able to use these examples and in turn create Dashboards worthy of a Distinction grade.

This is a resource created to assist in the delivery of Component 3 in the BTEC Tech Award Digital information technology, Level 1/ 2 qualification. The folder contains 35 presentations that can be used by teachers to deliver the required theory for the exam. Contents: A1 Modern technologies* Communication technologies Features and uses of cloud storage Features and uses of cloud computing How the selection of platforms and services impacts on the use of cloud technologies How cloud and ‘traditional’ systems are used together Implications for organisations when choosing cloud technologies A2 Impact of modern technologies* Changes to modern teams facilitated by modern technologies• How modern technologies can be used to manage modern teams How organisations use modern technologies to communicate with stakeholders How modern technologies aid inclusivity and accessibility Positive and negative impacts of modern technologies on organisations in terms of Positive and negative impacts of modern technologies on individuals B1 Threats to data* Why systems are attacked External threats (threats outside the organisation) to digital systems and data security Internal threats (threats within the organisation) to digital systems and data security Impact of security breach B2 Prevention and management of threats to data* User access restriction Data level protection Finding weaknesses and improving system security B3 Policy* Defining responsibilities Defining security parameters Disaster recovery policy Actions to take after an attack C1 Responsible use* Shared data (location-based data, transactional data, cookies, data exchange between services) Environmental C2 Legal and ethical* Importance of providing equal access to services and information: Net neutrality and how it impacts on organisations The purpose and use of acceptable use policies Blurring of social and business boundaries Data protection principles Data and the use of the internet Dealing with intellectual property The criminal use of computer systems D1 Forms of notation* Understand how organisations use different forms of notation to explain systems, data and information The resources include a wide range of exercises for students to complete but can obviously be altered to suit the needs of different ability groups or particular local examples.

This folder contains the following resources: A practice exam, based on the new January 2020 exam layout for the BTEC National IT Unit 2 Creating systems to manage information externally assessed unit, and corresponding mark scheme. It has been developed to give students experience of tackling the new, shorter, 5 hour practical exam. Supermarket Part A solution database which can be amended or used as teaching aid. Supermarket Part B solution database, complete with relevant Macros, which can be amended and given to students or used as teaching aid. Activity 2, 3, 4, 6 and 7 templates required for students to complete the tasks in the practice exam.

Query Practice This resource has been created to give students a basic understanding of how to complete simple queries in Access that will form the basis of their exploration and development of the subject. Crucial for Task 3 in the Unit 2 exam, students can start with this resources and then begin to develop their own more complex queries. The folder contains two files - a database containing examples of Text field, Numerical field, Currency field and Date field queries, as well as a presentation that students can be given as a task. Please note that table validation has not been done in this database, as it is not the main focus of the task.

**Task 2: Validation ** Students will need to understand how to include appropriate validation when designing and creating a database. This presentation gives simple examples that students will be able to build on based on a Gym example. No data has been entered, as this is something that students may do themselves once they have amended or adapted the validation rules. The accompanying database includes examples of the following validation: • Range Check • Presence Check • Format Check • Type Check • Length Check There are examples of basic input masks in the database which students will also be able to build on. A list of the most common types of masks are in the presentation and students are encouraged to experiment with the different types to understand when they should be used. There is an expectation that students will know how to set up “Value” and “Table” Lookups using Access. In the example are one of each. Bear in mind for this example, the concept of normalisation has been ignored.

This folder contains the following resources: A practice exam, based on the new January 2020 exam layout for the BTEC National IT Unit 2 Creating systems to manage information externally assessed unit, and corresponding mark scheme. It has been developed to give students experience of tackling the new, shorter, 5 hour practical exam. Music Part A solution database which can be amended or used as teaching aid. Music Part B solution database, complete with relevant Macros, which can be amended and given to students or used as teaching aid. Activity 2, 3, 4, 6 and 7 templates required for students to complete the tasks in the practice exam.

BTEC Level 1/2 Tech Award in digital information technology Component 1 This resource has been created to deliver the theory required for Component 1. It provides a stimulus for teaching and also something for the students to refer to when completing their work. You may notice that handheld devices and entertainment systems have been emboldened (slide 14) as these are the two I used with my students. The resource offers all students the opportunity to achieve a Distinction grade, and is thus differentiated by outcome. Some of the trickier section will have to be differentiated further for certain students. The resource has been designed with the creation of an app in mind. This is something that can be changed to suit local needs or the specific needs of a school. Some slides will have a reference (in the notes) to the part of the Unit specification it is designed to cover. In the notes section, any text in italics has been taken from the specification, and in particular the section on what needs to be done to get a Distinction grade in each particular Learning Aim. Expansion on the points in the presentation is up to individuals and also very much dependent on the expected outcomes for learners. For example a section on types of user interface can be made as simple or as complex by the teacher, as they need to. This resource has been created for use with the available authorised assignment briefs on the Pearson website. The folder contains the following files: • Component 1 Learning Aim A, Component 1 Learning Aim B and Component 1 Learning Aim C powerpoint resources to accompany the assignments (authorised or bespoke) • Sample GANTT planner using Excel • Sample PERT chart (Neoteric stadium) • Sample Home page wireframe design

This folder contains the following resources: A practice exam, based on the new January 2020 exam layout for the BTEC National IT Unit 2 Creating systems to manage information externally assessed unit, and corresponding mark scheme. It has been developed to give students experience of tackling the new, shorter, 5 hour practical exam. Zoo Part A solution database which can be amended or used as teaching aid. Zoo Part B solution database, complete with relevant Macros, which can be amended and given to students or used as teaching aid. Activity 2, 3, 4, 6 and 7 templates required for students to complete the tasks in the practice exam.

Creating systems to manage information Input masks Students will be required to set up masks to help validate input, and this will be vital for the testing task in the exam. Once they have mastered the basic text and number masks they will be able to apply them to suitable field types when creating a table within a database. The practice database contains two tables : Example warehouse table simulating simple warehouse stock system. The masked fields are Stock_ID - autonumber Product_name - Capitalisation / Lower case Mask Country_of_origin - Letter Mask Range_of_product - Must enter Letter / Must enter Number Mask Warehouse_telephone - Can enter Number Mask Product_price - Decimal Number Mask Example student details recording table. The masked fields are: ID - autonumber Firstname_initial - Capitalised Letter Mas Year - Number mask Form - Letter / Number Mask Attendance - Decimalised number mask FSM - Yes / No Postcode - Text / Number Mask UPN - Text / Number Mask Students can use this database as reference or change the masks to help them understand how masks restrict data input.

This folder contains the following resources: A practice exam, based on the new January 2020 exam layout for the BTEC National IT Unit 2 Creating systems to manage information externally assessed unit, and corresponding mark scheme. It has been developed to give students experience of tackling the new, shorter, 5 hour practical exam. Art Part A solution database which can be amended or used as teaching aid. Art Part B solution database, complete with relevant Macros, which can be amended and given to students or used as teaching aid. Activity 2, 3, 4, 6 and 7 templates required for students to complete the tasks in the practice exam.

This folder contains the following resources: A practice exam, based on the new January 2020 exam layout for the BTEC National IT Unit 2 Creating systems to manage information externally assessed unit, and corresponding mark scheme. It has been developed to give students experience of tackling the new, shorter, 5 hour practical exam. Car rental Part A solution database which can be amended or used as teaching aid. Car rental Part B solution database, complete with relevant Macros, which can be amended and given to students or used as teaching aid. Activity 2, 3, 4, 6 and 7 templates required for students to complete the tasks in the practice exam.

This folder contains the following resources: A practice exam, based on the new January 2020 exam layout for the BTEC National IT Unit 2 Creating systems to manage information externally assessed unit, and corresponding mark scheme. It has been developed to give students experience of tackling the new, shorter, 5 hour practical exam. Just don’t eat Part A solution database which can be amended or used as teaching aid. Just don’t eat Part B solution database, complete with relevant Macros, which can be amended and given to students or used as teaching aid. Activity 2, 3, 4, 6 and 7 templates required for students to complete the tasks in the practice exam.

This resource is an addition to the existing practice papers available in this shop. Following the January 2020 Unit 2 exam in which there was a non data entry form in Section B, these add ons were created. Students can now try the original practice papers, and then these bonus questions which will help them develop the skills required to create a non data entry form using Access.