4 Starter/Extension Activities based on Complex Logic Gates, suitable for KS3 who have just learnt the topic or for KS4 revision.

Included is an exam style paper to ensure that students understand the theoretical areas of R094, I have also developed and made a mark scheme for the same paper. These can be used and edited as you see fit. On the question paper, I have highlighted in bold key words so that students understand what the question needs them to do (e.g. “Explain two methods”) This has been delivered to SEN Students at Year 10, and they have thrived with this material after going over the content in the weeks prior to taking this assessment.

This worksheet was designed for students to be able to understand and complete a short research task about certain key figures in Computer Science. It is scaffolded so that they know exactly what information they need to obtain and how it is laid out.

This worksheet was designed to expose KS3 students to the different Legal, Ethical situations there could be when involved with technology and using technology. This could also be used as a nice refresher for KS4/GCSE Students.

A nice short activity for GCSE students to recap their understand of Logic Gates and Truth Tables. Worksheet includes 3 different questions of varying difficulty where they need to draw the logic gate and complete the truth table for the given expression.

This word document has 10 challenges in total all of varying difficulty where students either have to create an object or a shape, there are also complex challenges such as creating a kaleidoscope and creating animals faces. Designed to be fun starters and extension activities and can also be used to fill time in lessons and keep students active in the lesson and engaged.

A PowerPoint to give KS3 an insight into codebreaking and encryption and for them to have a go at encrypting and decrypting

A brief for creating a network in Packet Tracer for students to understand basic networking skills and interlinking devices.

A case study and task for the students to start thinking like they were putting in their own implementation of a section of the network. It is accompanied by a notes sheet as well so they can note down while completing the walk round. At the end of the task sheet they will need to complete a write up and evaluation of what is required to complete the installation.

HTML Tags memorization task with extension tasks at the end as well to reinforce their learning.

HTML Project for KS3 and KS4 includes a framework brief and also what to change in CSS as well.

These ready-to-teach slides show learners how to design spreadsheets that look clear, consistent and professional. They focus on good user interface (HCI) design and on making spreadsheets easy for the user to read and use. The slides cover: Why good HCI design matters, and how to match a design to a set colour scheme or set of graphics Tables: what they are, their benefits (sorting, filtering, auto-expanding, easier charts) and step-by-step instructions for creating one Text presentation: choosing a typeface and font size, and using bold and italic for emphasis Borders and colour: structuring information, showing where users should enter data and keeping colours to a limited scheme Alignment: best practice for text, headings and numbers Conditional formatting: using colour scales and custom rules to highlight data automatically, such as showing scores above 50% in green and below 50% in red The slides are fully editable and work well for whole-class teaching, independent work or catch-up lessons. This resource is not endorsed by OCR.

This pack of 10 units builds learners’ spreadsheet skills step by step. It starts with the basics of planning and core techniques, then moves on to the advanced functions that let learners create effective, professional spreadsheet solutions. Key Spreadsheet Skills Spreadsheet Terminology: cells, ranges, worksheets, workbooks and the key vocabulary learners need Basic Spreadsheet Formulae: building calculations with operators and cell references Using Functions: SUM, AVERAGE, MIN, MAX and other common functions Formatting Data: number formats, currency, dates and percentages Formatting Design and Layout: making spreadsheets clear, professional and easy to use Creating Graphs and Charts: choosing and presenting suitable charts for the data Advanced Spreadsheet Skills Counting Cells Which Meet Criteria: COUNTIF and related functions Getting Data from a Table: lookup functions for retrieving information IF Statements: logical tests and decision-making formulas Data Validation: controlling input and reducing errors Ideal for: Teaching R060 spreadsheet skills from scratch Independent learning, revision and homework Learners in Years 10–11 on the OCR Cambridge Nationals in IT (J836) This resource is not endorsed by OCR.

R060 Formatting Data – Lesson Slides (OCR Cambridge Nationals IT J836) These ready-to-teach slides show learners how to choose the right format for different types of data in a spreadsheet. A key point throughout is that formatting changes how data looks but not the value stored. They also cover how the right format improves usability and helps the spreadsheet process data correctly. The slides cover: What formatting data means and why it matters for the user interface (HCI) Finding the format options on the Home tab Number: general values such as quantities and scores, and changing decimal places Currency: displaying the £ symbol with two decimal places Percentage: entering values as decimals (0.25 shows as 25%) Date: entering dates as DD/MM/YYYY and changing how they’re displayed Text: keeping leading zeros and spaces, using a phone number as a worked example Common pitfalls, such as Text format stopping a formula from calculating The slides are fully editable and work well for whole-class teaching, independent work or catch-up lessons. This resource is not endorsed by OCR.

Using Functions Learners discover how built-in functions make calculations quicker and easier than writing formulae by hand. Using a shopping-list spreadsheet, they practise four key functions: SUM: adds up a range of values AVERAGE: finds the mean MIN: finds the lowest value MAX: finds the highest value Along the way they learn how a function is set out: an equals sign, the function name, then a cell range inside brackets. They also learn to select a range by clicking and dragging, and to reuse the same steps for each function. By the end, they can confidently summarise a set of data with functions.

Basic Spreadsheet Formulae Learners find out how spreadsheets do calculations automatically. They write formulae that start with an equals sign, use the arithmetic operators (+, −, *, /) and refer to cells instead of typing in values, so results update whenever the data changes. Practical tasks let them build and copy formulae across a spreadsheet, which gives them a solid base before moving on to functions and the more advanced techniques.