This lesson is aimed at Year 10 (or able Year 9) Computing students and covers the principles of string handling. It would also suit Year 11 students who need to practice these skills before beginning the practical project. This lesson has been taught as part of the OCR GCSE Spec, but would be just as relevant to other specifications that students understand string handling. The lesson gives specific examples of a range of string handling features such as: Converting to a string Converting to lower/upper case Counting the length of a string Concatenating Slicing Splitting There are examples of code for of these principles in the slideshow, so that students can practice as they go through the lesson. There is also a worksheet which will allow students to put the ideas from the lesson into practice.

This is a very comprehensive revision lesson (for Year 11 GCSE students) covering 2.2 in the OCR Computing spec. the use of variables, constants, operators, inputs, outputs and assignments the use of the three basic programming constructs used to control the flow of a program: * sequence * selection * iteration (count and condition controlled loops) the use of data types: integer real Boolean character and string casting the common arithmetic operators the common Boolean operators. The concepts are illustrated with Python examples and there are questions built into the PowerPoint. The worksheet asks students to show their understanding of the concepts covered in the lesson, by identifying them within a Python program. There is also a link to a Quizizz online multichoice test. (This is actually a resource that anyone can access but was written to support this lesson)

Two completely resourced lessons, covering 1.1, 1.2 and 1.3 of the Cambridge Nationals Spec. The learning points are designed to match the content of this part of the specification. The resources consist of: Two lesson PowerPoints (with learning objectives) Links to online quizzes (via the Quizziz website) Example case study scenario, with two student activities These resources are aimed at Year 10 students who are new to this topic. The resources could also be used with and adapted for different courses, where similar principles of the project lifecycle are studied.

This lesson covers the content of 2.5, specifically: • characteristics and purpose of different levels of programming language, including low level languages • the purpose of translators • the characteristics of an assembler, a compiler and an interpreter • common tools and facilities available in an integrated development environment (IDE): -editors error diagnostics run-time environment translators. The lesson was written for OCR’s specification, but should work equally well for similar concepts covered in other specifications. There are activities built into the slides and the presentation contains a link to a multi-choice “Quizizz” quiz. These are always freely accessible, but are always written for and tied to specific lessons. Please note - when I use this lesson with my students, I set an exam question homework but I cannot include this since it is paid third-party content.

A one-page cheatsheet for MS Excel. This resource is aimed at students who are new to using spreadsheets (or who need to recap the basics) and is designed to be used to support the teaching of spreadsheets to Key Stage 3 or 4 students. The sheet covers basic formulae, formatting, use of functions and absolute/relative cell addressing. I have used this to support my own teaching of spreadsheets and have made the resource available as a download from our VLE, as well as providing laminated copies for classroom use.