7 PowerPoints with activities for teachers to go through focusing on the Theory for the following; Purpose Normalisation SQL Relational Data Structures Relationships Keys Which covers the material from A1 Relational database management systems A2 Manipulating data structures and data in relational databases A3 Normalisation Also included are worksheets for students as well as a scaffolded report writing frame for students to demonstrate their knowledge before progressing to the next learning aim. Updated 02/10/2024 I have uploaded a practice database that has tasks for students for table creation, relationships, query design, using validation and more. I have also uploaded a complete step by step guide on performing those tasks with screenshots for every step of the way.

Level 3 BTEC IT - Unit 12 - IT Technical Support (Learning Aim B&C) These resources cover all the material for all activities including; I have created two differing examples of work, one for your more standard PC friendly monitoring performance of an IT System and then a revamped version that is focused on Raspberry Pi hardware/software. B.P3/M2/D2 Complete at least six routine IT support activities safely, using some appropriate processes and behaviours. B.P4/M2/D2 Monitor the performance of the IT system safely against the client’s requirements, using some appropriate processes and behaviours. The following template documents are included for students to us - I have written a new assignment brief that I’d recommend editing very slightly just to localise and to meet your students needs. Business Continuity Plan, Capacity Plan, Acceptable Use Plan, Disaster Recovery Plan, Floor Plan there is also a IT Support and Management Plan - Review for students to peer assess each others work for quality assurance. C.P5 Produce an IT support and management plan that adequately meets most of the client’s requirements. C.P6 Review the IT support and management plan with others to identify and inform improvements. C.M3 Justify, using feedback from others, the decisions made for an IT support and management plan, explaining how it will meet the client’s requirements and be fit for purpose. C.D3 Evaluate, using feedback from others, the refined IT support and management plan, justifying how it fully meets the client’s requirements and is fit for purpose.

BTEC IT LEVEL 3 - Unit 5 - Data Modelling: Learning Aim B&C Included in the resource which is designed to go alongside the ‘Cheese’ scenario that was provided on externally verified assignment brief. This file includes guides on how to achieve all criteria, teacher PowerPoints for delivery, a completed solution for the problem created in Microsoft Excel (Google Sheets compatible), templates for students that require more scaffolding and completed versions to see expectations,. As well as all of the above - I have completed and included a case study example that covers all of the pass criteria for a different scenario so students can have a go at completing designs and reviews and get first hand much needed practice before starting the assignment. I have also made a resource bundle that includes all criteria for learnings ABC. Please check my seller page to get this saving. Bundles work out cheaper overall.

Included are PowerPoints that cover each learning aim, worksheets for students to answer questions on about all of the core criteria from assignment A for the following criteria; P1, P2, M1 & D1. Also included in these resources are teacher answer sheets for all of the questions attached and example scenarios with solutions included within the PPT presentations. I have also made a resource bundle that includes all criteria for learnings ABC. Please check my seller page to get this saving. Bundles work out cheaper overall.

I have completely worked through the Unit 11 January 2019 past paper for the unit 11 IT LEVEL 3 BTEC. Included in this file is examples of how to answer questions 1-5 in the Jan 2019 past paper. Annotated and highlighted and ready to deliver/work through with your classes. I have now added a marking table template for you to use to provide feedback to your students UPDATED ON 04/12/23. Added activity 5 13/12/23 Update 29/04/24 - January 2024 exam paper with example answers graded at a Distinction.

Included in this resource student question sheets and teacher copies with all the answers on as well as teacher PowerPoints, covering all criteria up to M1, D1 as well as P1 and P2 for the assignment A covering the following criteria. 8/A.D1 Evaluate the impact of current and emerging technologies on the design and development of computer games to meet the requirements of the users and the computer games industry. 8/A.M1 Discuss how current and emerging technologies impact on how games are designed and developed to meet the requirements of the users and the larger computer games industry. 8/A.P1 Explain social and technological trends of computer games. 8/A.P2 Explain how current and emerging technologies impact computer games’ design and development.

BTEC IT Level 3 - Using Social Media in Business Learning Aim: A (Full Teacher Guide) This is a full set of PowerPoints that cover all criteria (P1, P2, M1 and D1) from the learning aim A assignment brief. Each lesson comes with an accompanying question sheet to hand to students and there is also a teacher copy with suggested answers for the teacher.

BTEC Level 3 IT/Computing - Unit 7 Mobile Applications Development Complete with newly written unique assignment brief that has been authorised by Pearson and with PPT with tasks and solution for application. All Thunkable code screenshots with annotations with explanation to how it works. Screenshots from Thunkable are from an older version of Thunkable so your experience may differ slightly when using the Thunkable software.

Here is a 45 page powerpoint presentation I have made which works as a complete teacher guide to unit 19 Internet of Things for the BTEC IT EXTENDED DIPLOMA LEVEL 3 The soloution is a Python application that runs on a Raspberry Pi, the program is linked to a motion sensor and a camera. When motion is detected the camera will take a photograph and email it to an attached Gmail account. The photo is also saved locally on the micro SD card. This works as an internet of things connected device. All code is included with explanations, all learning aims are included with guides for teachers. 08/02/24 - I have added a peer review form for P4. 29/02/24 - I have added a security and mitigation PPT 29/02/24 - I have added risk assessment/mitigation templates (These are the official BTEC ones that used in Unit 11 - Cyber Security exam.) However, I noticed it was good opportunity for cross curricular learning. 08/03/2024 - In 2024 Gmail removed unsupported applications from connecting to Gmail accounts, this made my code crash. I have created a workaround and included the guide here today. Everything works again! 20/03/2024 - I have added a Evaluation Template which is great for weaker learners and help them aim towards P6/D2/D3 20/03/2024 - I have added a testing table template with examples of how to complete it. 16/04/2024 I have added a Distinction completed assignment. 22/04/2024 I have added feedback and where the learner has achieved each criteria on the assessment as a seperate PDF.

I have fully completed and gone over the Digital Information Technology COMPONENT 1: Collecting, Exploring User Interface Design Principles and Project Planning Techniques Pearson Set Assignment January 2025. This is a great guide to help you complete the new released January 2025 paper. Great tool to assist the marking process so you can check and cross reference against the provided answers. Included is a fully completed Task 1A - completed Word Doc 1B - complete on Excel with key milestones and task dependencies 2 - Wireframe designs 3 - functional prototype 4 - completed Word Doc review Added a tracker for the entire DIT course that covers COMP1, COMP2 and COMP3 and can be used for your entire class. 03/12/24 - Added a guide on how to porgram/link the buttons to have a functional navigation buttons. 04/12/24 - Added a marking grid template and fully marked student work for COMP1 Jan 2025 with screenshots/comments for practical tasks 1B, 2 and 3 04/12/24 - Added a fully marked work for Task 1A and 4.

I have gone over all the criteria for theBTEC TECH AWARD LEVEL 1/2 January 2024 - Component 2: Collecting, Presenting and Interpreting Data Pearson Set Assignment. I have covered how to complete EVERY task 1-3 BUT I have used a completely different data set as to not break the rules of the exam board. You can use these resources to PRACTICE the controlled assessment. I also have a cheaper bundle of resources for Comp1, Comp2 & Comp3. https://www.tes.com/teaching-resource/btec-tech-award-l1-2-component-1-2-and-3-12943995 This includes all the resources I have created for the Pearson BTEC Level1/Level 2 course.

I have fully completed and gone over the Digital Information Technology COMPONENT 2: Collecting, Presenting and Interpreting Data Pearson Set Assignment January 2025. This is a great guide to help you complete the new released January 2025 paper. Great tool to assist the marking process so you can check and cross reference against the provided answers. Included is a fully completed Excel Spreadsheet with all completed tasks for 2A 2B and 2C as well as a complete ‘how to guide’ on PowerPoint. Fully completed examplar answers for 3 errors patterns and trends, as well as a guide on responding well to task 1, task 1 is generic and can be used on any PSA, not just the JAN2025. Added a tracker for the entire DIT course that covers COMP1, COMP2 and COMP3 and can be used for your entire class. 11/11/2024 - Marking grids (updated) for answers 2A, 2B and 2C A completed marking grid to show you the best practice. 02/12/24 - Added a marking grid and fully marked student work for COMP2 Jan 2025 with screenshots/comments. 11/12/24 - Added a comment bank and made some minor changes to the marking grid template/marked work.

I.T. BTEC LEVEL 3 - Unit 1: Information Technology Systems (Workbook: Learning Aim A,B,C & D) This resources covers the 4 learning aims that I sell individually for £15 each in one package for £50 which is a £40 saving. Each workbook is between 35-70 pages so there are endless amounts of activities for students to get stuck into Workbook A: 70 Pages Workbook B: 60 Pages Workbook C: 40 Pages Workbook D: 35 Pages Workbook E: 35 Pages Workbook F: 33 Pages Please note, each workbook can be purchased individually for £15 each on my shop page right here on Tes if you don’t have the budget to purchase all 6. Thanks.