This resource has been developed based on student feedback from the Paper 2 2018 and the Paper 2 Examiner Report extract: “Candidates who did well on this paper generally… Understood the use of SQL and wildcards.” This resource provides: Syntax, example for a fruitShop table and practice with a bakery table. Solution provided - in lesson, I will get students to self-check against a printed copy of the solution. Thanks for taking an interest in this resource.

Let’s Do It Activities Designed as lesson starters for component 2, this free resource is from the Data Representation set. The set, on sale for £4, shows the different methods for converting data in the 9-1 specification, illustrated through worked examples and a suggested approach, with three practice questions that students can work on independently. In my lessons, I will have a folder with the solutions in so that students can self-mark once they have completed the activity. Thanks for interest in this resource.

Let’s Do It Activities Designed as lesson starters for component 2, this free resource is from the Algorithm set. The set, on sale for £4, shows the sort/search methods in the 9-1 specification, illustrated through worked examples and a suggested approach to three practice questions that students can work on independently. In my lessons, I will have a folder with the solutions in so that students can self-mark once they have completed the activity. Thanks for interest in this resource.

Let’s Do It Activities Designed as lesson starters for component 2 - revision of the different methods for searching and sorting: Binary search, linear search, bubble sort, merge sort, merge sort lists and insertion sort. Each method is illustrated through worked examples and tips on how to search/sort with three practice questions that students can work on independently. In my lessons, I will have a folder with the solutions in so that students can self-mark once they have completed the activity. To follow shortly: Let’s Do It Activities for Programming Techniques.

I have trialled BTEC Digital Information Technology during 2017/2018, and have produced a number of resources linked directly to the new specification. This free resource is one of a set linked to the theory required on sectors for Component 3 Cyber Security, and the skills required in Component 1, if you choose to use PowerPoint for the User Interface. The complete set for will be available to purchase in November for £5. Thanks for taking an interest in this resource.

I have trialled BTEC Digital Information Technology during 2017/2018, and have produced a number of resources linked directly to the new specification. This free resource is one of a set linked to the theory required on sectors for Component 2 LAA, and the skills required in Excel for LAB. The image with this resource shows the different placemats I have created for this unit which can be purchased for £6. Thanks for taking an interest in this resource.

I have trialled the teaching of BTEC TA Digital Information Technology during 2017/2018 and have produced the attached ‘placemats’ to ensure that students understand the key skills required for LAB/C and the knowledge required for the research task in Component A. Either print double-sided, laminate or simply display/view on screen. On side A is the LAA theory looking at sectors of industry. On side B is the LAB/C skills in Excel. I have used them laminated, 1 between 2 and supported the Excel element with short tasks that teach students the skills as listed in the specification. I hope these can be of help to you and your students. Thanks for taking an interest in this resource.

Let’s Do It Activities Designed as lesson starters for component 2 - revision of the different data conversion methods: Binary to denary and vice versa, binary to hexadecimal and vice versa, denary to hexadecimal and vice versa, binary addition, binary shift to the left, binary shift to the right, and finally as mentioned in the spec, (how to calculate) the check digit. Each conversion is illustrated through worked examples and tips on how to convert with three practice questions that students can work on independently. In my lessons, I will have a folder with the solutions in so that students can self-mark once they have completed the activity. To follow shortly: Let’s Do It Activities for Sorting & Searching Algorithms and Logic Gates.

Scheme of Work for Component 2 LA1 Role of Data and Information. Example lesson resource.

Using a model of 15 minutes theory and discussion, followed by practical creation of a user interface in Microsoft Access, this unit helped my Year 9 class to understand the concept of user interfaces as an introduction to the BTEC TA in DIT. Includes - discussion tasks linked to specification, home learning tasks and practical tasks in Access.

Memory Joggers to help students think about the long QWC questions. Use the card size memory jogger for a carousel paired activity, and then use the questions as a follow on written activity. I hope this resource can assist in final revision for the Unit 2 Business Finance exam. Good luck.

Inspired by a Sunny May Day bank holiday on 7 May 2018! Recapping theory of Business Finance looking at the ice cream sales of an ice cream van man and woman. Names of students can be altered to suit your class, but animated so that questions come up one by one and follow on from each other. Simple answers in the notes section.

A simple resource to help students remember how to convert from Hexadecimal into Decimal number (denary), and from Decimal number (denary) into Hexadecimal. As there are no calculators in the exam this year, it would help if students could refer to the 16 times table quickly when converting.

In final preparation for the GCSE Computer Science 9-1 exam, I have created some characters and simple tips to help students remember how to approach the different types of questions. If you can you this, and it can help students, please download. Good luck to all GCSE Computer Science students on 14 & 17 May 2018.

End of Unit test Differentiated questions on Dangers to computer networks, identifying vulnerabilities and preventing attacks. Teacher solution provided.

Preparation for the GCSE Computer Science 9-1 Paper 2. Reminders on how to do sorting, searching and data conversion. Student questions (differentiated - some with ‘methods’, some with additional pseudocode challenge) - Teacher solutions to main questions. DTT Revision - Key Areas: Data structures, errors, robustness and data types ( Therapy - as identified in mock exam).

Revision session - Focus: Calculation questions Storage capacity Converting between binary, denary and hexadecimal Binary shifts Binary addition Check digit calculations Questions & Solution provided.

Interleaving lesson - testing theory already taught and focusing on areas for further study: Independent questions: Data Representation/Truth tables Independent questions: Programming Techniques/Data Types DTT Revision: Flowchart symbols, languages, IDE and binary shifts Teacher-led question: Databases Teacher-led questions: SQL pseudocode

Each revision lesson gets the students working independently for the first part of the lesson, followed by a review of the answers. A specific area of Component 1 is then revised, and the lesson concludes with a QWC question. If you have longer lessons, you could add in past exam questions from the A451 syllabus which are related. Independent questions: Topologies, Network Protocols Teacher-led revision (and questions as part of discussion): Network Topologies, Protocols & Layers QWC question: Choice of network topology for a school.