Hero image

BTEC IT KS4 / KS5 Resources

Average Rating2.17
(based on 7 reviews)

This shop sells materials that have been used in an ALPS rated "1" college for the results achieved in Key Stage 5 in BTEC National Extended Certificate in Information technology. There are now new resources available for the new BTEC Tech Award in Digital Information Technology written to complement the new course that starts in September 2022. Email: onetmany3@gmail.com

29Uploads

13k+Views

2k+Downloads

This shop sells materials that have been used in an ALPS rated "1" college for the results achieved in Key Stage 5 in BTEC National Extended Certificate in Information technology. There are now new resources available for the new BTEC Tech Award in Digital Information Technology written to complement the new course that starts in September 2022. Email: onetmany3@gmail.com
BTEC National IT, Unit 2 (New 2020 exam): Just don't eat database
onetomanyonetomany

BTEC National IT, Unit 2 (New 2020 exam): Just don't eat database

(0)
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.
BTEC National IT, Unit 2 (New 2020 exam): Car Rental database
onetomanyonetomany

BTEC National IT, Unit 2 (New 2020 exam): Car Rental database

(0)
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.
BTEC National IT, Unit 2 (New 2020 exam): Music database
onetomanyonetomany

BTEC National IT, Unit 2 (New 2020 exam): Music database

(0)
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 National IT, Unit 2 (New 2020 exam): Supermarket database
onetomanyonetomany

BTEC National IT, Unit 2 (New 2020 exam): Supermarket database

(0)
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.
BTEC National IT, Unit 2 (New 2020 exam): Art database
onetomanyonetomany

BTEC National IT, Unit 2 (New 2020 exam): Art database

(0)
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.
BTEC National IT, Unit 2 (New 2020 exam): Zoo database
onetomanyonetomany

BTEC National IT, Unit 2 (New 2020 exam): Zoo database

(0)
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.
New Spec 2022, BTEC Tech Award Level 1/2 Digital I.T. - Component 1 - 10 Resource pack
onetomanyonetomany

New Spec 2022, BTEC Tech Award Level 1/2 Digital I.T. - Component 1 - 10 Resource pack

10 Resources
In this bundle you will find 10 resources that will help teachers deliver and students practise vital elements of content and skills relating to Component 1 in the new BTEC Tech Award in Digital IT course which starts in September 2022. Each resource contains 2 files: Assignment Appendices (required for students to complete assignment) Teach in conjunction with Component 1, resources A, B and C which are available for free in the shop.
Unit 2, Creating systems to manage information: Input Masks practise
onetomanyonetomany

Unit 2, Creating systems to manage information: Input Masks practise

(0)
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.
New Spec 2022, BTEC Tech Award Level 1/2 Digital I.T. - Component 2 - 5 Resource pack
onetomanyonetomany

New Spec 2022, BTEC Tech Award Level 1/2 Digital I.T. - Component 2 - 5 Resource pack

5 Resources
In this bundle you will find 5 resources that will help teachers deliver and students practise vital elements of content and skills relating to Component 2 in the new BTEC Tech Award in Digital IT course which starts in September 2022. Each resource contains 5 files: Assignment Dataset Analysis and Dashboard (student version which is blank) Analysis and Dashboard (teacher version with formulas and functions) Additional Data set Teach in conjunction with Component 2, resources A, B and C which are available for free in the shop.
New Spec 2022, BTEC Tech Award Level 1/2 Digital I.T. - Component 2 – Restaurant
onetomanyonetomany

New Spec 2022, BTEC Tech Award Level 1/2 Digital I.T. - Component 2 – Restaurant

(0)
This resource has been designed to give students the chance to practice controlled assessment type tasks before completing the Component 2 internally marked controlled assessment. Students will get the chance to work under time pressure and to practice their spreadsheet skills by completing tasks that reflect what they will be required to do in the assessment. This resource includes 5 files: Restaurant Assignment High Street Bistro Data file Restaurant Analysis and Dashboard (student version) Restaurant Analysis and Dashboard (complete version) Restaurant Dataset Use in conjunction with Component 2 Resources A, B and C
New Spec 2022, BTEC Tech Award Level 1/2 Digital I.T. - Component 2  – Schools
onetomanyonetomany

New Spec 2022, BTEC Tech Award Level 1/2 Digital I.T. - Component 2 – Schools

(0)
This resource has been designed to give students the chance to practice controlled assessment type tasks before completing the Component 2 internally marked controlled assessment. Students will get the chance to work under time pressure and to practice their spreadsheet skills by completing tasks that reflect what they will be required to do in the assessment. This resource includes 5 files: Schools Assignment Pastoral Data file School Analysis and Dashboard (student version) School Analysis and Dashboard (complete version) School Dataset Use in conjunction with Component 2 Resources A, B and C
New Spec 2022, BTEC Tech Award Level 1/2 Digital I.T. - Component 2 – Snowboarders
onetomanyonetomany

New Spec 2022, BTEC Tech Award Level 1/2 Digital I.T. - Component 2 – Snowboarders

(0)
This resource has been designed to give students the chance to practice controlled assessment type tasks before completing the Component 2 internally marked controlled assessment. Students will get the chance to work under time pressure and to practice their spreadsheet skills by completing tasks that reflect what they will be required to do in the assessment. This resource includes 5 files: Snowboarders Assignment Scandinavia League Data file Snowboard Analysis and Dashboard (student version) Snowboard Analysis and Dashboard (complete version) Snowboard Dataset Use in conjunction with Component 2 Resources A, B and C
New Spec 2022, BTEC Tech Award Level 1/2 Digital I.T. - Component 2 – Taxis
onetomanyonetomany

New Spec 2022, BTEC Tech Award Level 1/2 Digital I.T. - Component 2 – Taxis

(0)
This resource has been designed to give students the chance to practice controlled assessment type tasks before completing the Component 2 internally marked controlled assessment. Students will get the chance to work under time pressure and to practice their spreadsheet skills by completing tasks that reflect what they will be required to do in the assessment. This resource includes 5 files: Taxis Assignment City Taxi services Data file Taxi Driver Analysis and Dashboard (student version) Taxi Driver Analysis and Dashboard (complete version) Taxi Driver Dataset Use in conjunction with Component 2 Resources A, B and C
New Spec 2022, BTEC Tech Award Level 1/2 Digital I.T. - Component 2 – Hairdressers
onetomanyonetomany

New Spec 2022, BTEC Tech Award Level 1/2 Digital I.T. - Component 2 – Hairdressers

(0)
This resource has been designed to give students the chance to practice controlled assessment type tasks before completing the Component 2 internally marked controlled assessment. Students will get the chance to work under time pressure and to practice their spreadsheet skills by completing tasks that reflect what they will be required to do in the assessment. This resource includes 5 files: Hairdressers Assignment Employee review Data file Hairdresser Analysis and Dashboard (student version) Hairdresser Analysis and Dashboard (complete version) Hairdresser Dataset Use in conjunction with Component 2 Resources A, B and C
BTEC National IT, Unit 2 (New 2020 exam): Movies database
onetomanyonetomany

BTEC National IT, Unit 2 (New 2020 exam): Movies database

(1)
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 National IT, Unit 2, Exam Part B
onetomanyonetomany

BTEC National IT, Unit 2, Exam Part B

(0)
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.
BTEC National IT, Unit 2 Creating systems to manage information: Validation, Masks, Lookups practice
onetomanyonetomany

BTEC National IT, Unit 2 Creating systems to manage information: Validation, Masks, Lookups practice

(2)
**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.