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.

Developed specifically for the GCSE Computer Science 9-1 Component 2 Exam. Based directly on the OCR Syllabus, it covers each element in bitesize chucks. A simple resource that can be used for independent revision, peer-to-peer Q&A and mix n’ match tasks. Golden Nugget Technique: Read a golden nugget. Read it again. Look away - what can you remember? Read it again - what did you forget? Read it again. Look away - have you remembered it yet? Repeat this process and learn the theory in little bitesize chunks Feedback from Parents Evening: “My child brought these home for revision. Even though I don’t understand the theory, I have the answers in front of me. I ask for a definition and compare his answers to those on the Golden Nugget. I can even give prompts because all the answers are there.”

End of unit assessment for Python Introduction - The Basics. Differentiated for low, middle and high ability students. Supported by end of unit self-assessment checklist.

Knowledge Organisers for the Component 3 Topics. Flashcards created using the mindmaps on the Knowledge Organisers. Using flashcards to prompt students to discuss topics linked to specific business scenarios: Network Airbus The Royal Navy

Developed specifically for the GCSE Computer Science 9-1 Component 1 Exam. Based directly on the OCR Syllabus, it covers each element in bitesize chucks. A simple resource that can be used for independent revision, peer-to-peer Q&A and mix n’ match tasks. Golden Nugget Technique: Read a golden nugget. Read it again. Look away - what can you remember? Read it again - what did you forget? Read it again. Look away - have you remembered it yet? Repeat this process and learn the theory in little bitesize chunks Feedback from Parents Evening: “My child brought these home for revision. Even though I don’t understand the theory, I have the answers in front of me. I ask for a definition and compare his answers to those on the Golden Nugget. I can even give prompts because all the answers are there.”

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.

With students, prior to assessment, we run a walk-through-talk-through lesson, where using a visualiser, we talk through the questions and then the teacher handwrites the answer explaining how they structure it. This has resulted in greater confidence displayed by students in the following assessment. As we have multiple teachers, a solution is provided with possible answers so that there is consistency in guidance given to students. Following the assessment, in the DIRT lesson, we go through a modelled answer to again show students how the teacher would have approached the actual assessment and things they should have picked up on when reading/answering the questions. This assessment is based on students having completed: Modern technologies, Impact of Modern Technologies, Cyber Security and ELCE Wider Impact. Another paper is currently also available for the year below, where they have so far studied: Modern Technologies, Impact of Modern Technologies.

Student workbook (and teacher solution to exam style questions) 1.4 Wired & Wireless Networks Memory jogger - 'trigger words' Student task Key links to further revision OCR exam-style questions 1.5 Topologies & Protocols to follow soon.

A short check-test on Wired and Wireless networks. Teacher solution provided. An additional test of knowledge following mock exam weaknesses.

Help students to revise the concepts in the run up to the exam: Hand out a memory jogger: 1 minute (think), 1 minute (pair) then class discussion (share) A great way to revise a topic before getting them to attempt a previous exam question.

Learn to convert denary to binary to hexadecimal (and vice versa) using a simple method that reduces the amount of calculations a student has to do. This spreadsheet is designed with students in mind, showing them a fast and effective way to convert numbers without having to remember too many different stages in the calculation. Learning Objectives: To convert from binary to denary and vice versa To convert from binary to hexadecimal and vice versa Teacher PowerPoint and solution. Student worksheet for Excel. Coming shortly: To convert from hexadecimal to denary and vice versa

OCR GCSE Computer Science Think - Make the Link A presentation developed from the OCR Specification to demonstrate to students how the knowledge and understanding for the new Unit 2 exam correlates with the skills required for the Unit 3 Non-Exam Assessment. By drawing the parallels between the content for the two assessments, I hope to develop stronger students with greater clarity in computational thinking as they approach the NEA in the Autumn term 2017, and prepare for the exam in Summer 2018. Scheme of work and lesson plans currently under development, and will follow.

BTEC First Award in ICT Learning Aim B: Understand what the internet is, how it works, and how it is structured Comprehension exercises. Differentiated questions. Learn/revise for the November exam with these. More to follow for this resource as created.

Document linking Key Stage 2 computing curriculum requirements with units of work. Scratch introductory lesson written by Key Stage 3/4 teacher for local primary school struggling with the new computing curriculum terminology. Teaching the lessons over the Autumn term 2017, so more lessons will be added as created. I use Scratch offline editor, but this could be done on the online version too.

Use these AfL checklists as you cover theory for the A451 exam. Differentiated for main topics to identify where students need more help in preparation for their exam.

Tricky words sheet for J296 Component 1 and Component 2 - Know and recognise these words, so you understand the context of the questions in the exam, plus: Learn how to compare the concepts using the Whereas Game as a ‘fun’ way to prepare for the exam: Instructions to students for playing the Whereas Game: You have been given a WHEREAS card. When instructed, you will have 30 seconds to explain to the class the difference between the 2 key terms you have been given. There must be no speaking (except for the person completing their WHEREAS challenge) until all class members have had a go You must listen carefully as the answer they give could be the answer you need in the May exams.

With students, prior to assessment, we run a walk-through-talk-through lesson, where using a visualiser, we talk through the questions and then the teacher handwrites the answer explaining how they structure it. This has resulted in greater confidence displayed by students in the following assessment. As we have multiple teachers, a solution is provided with possible answers so that there is consistency in guidance given to students. Following the assessment, in the DIRT lesson, we go through a modelled answer to again show students how the teacher would have approached the actual assessment and things they should have picked up on when reading/answering the questions. This assessment is based on: Modern Technologies and the Impact of Modern Technologies.

Revision resource on Networks Golden nuggets of information to revision. Flash cards for cutting out and using as prompts for paired discussion, e.g. one sees the keyword, the other sees the definition .

By creating a Times Table Learning Game on Scratch, students can become familiar with key programming terms: Sequence Selection Iteration Variables Includes lesson powerpoint, student resource and Scratch quiz. Update: Additional resource added - screenshots of Scratch code for quiz in case you are not using Scratch 2 offline editor. Follow on lesson - Direct Reflection and Improvement Time. How much do they now understand.

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.