A focused lesson guiding students through Task 3 of the Westwood School Trips assignment, from running the test plan and capturing screenshot evidence to writing a Mark Band 3 evaluation. What’s included 21-slide PowerPoint split into two sections: Rigorous Testing and System Evaluation. A mark scheme overview covering the 14 marks across Topic Areas 3 and 4. Guidance on testing categories, screenshot standards, and documenting failed tests and retests. Evaluation prompts for calculations, outputs, what-if scenarios, HCI and security. A check-understanding question with answer reveal, a reflection task, and a submission checklist. Learning objectives: Complete technical and usability testing using the test plan, with precise screenshot evidence. Evaluate spreadsheet functionality against the client requirements and what-if targets. Critique HCI usability, navigation and presentation at Mark Band 3 standard. Suitable for: KS4 students taking OCR Cambridge Nationals in IT (J836), unit R060. Ideal before or during the Task 3 write-up. Clear Mark Band 1–3 progression, practical screenshot dos and don’ts, a four-step remedial action process, and an end-of-task checklist students can tick off.

A ready-to-teach lesson showing students how to choose the right chart for their data, build line, column and doughnut charts in Excel or Google Sheets, and style them professionally. What’s included 18-slide PowerPoint using an I do / We do / You do structure, with key vocabulary, worked examples, a video slide and checked answers for the class activities. Practical worksheet with four tasks: fixing flawed charts, choosing a chart type, building three charts from data tables, and a formatting self-audit. Full answer key. Learning objectives Select the right chart type for the data’s purpose and audience. Build line, bar/column and pie/doughnut charts from tables in spreadsheet software. Customise titles, colours, axes and layout for clear, professional charts. Suitable for KS3 Computing / IT, also useful as a GCSE or vocational IT spreadsheet skills lesson. Works with Excel or Google Sheets. Fits one double lesson (80 minutes). Key features to highlight Real-world business scenarios, a “spot the mistake” diagnostic task, step-by-step chart creation, a self-assessment checklist, and minimal prep needed.

An introductory lesson that walks students through the full Westwood School Trips brief: the scenario, client requirements, supplied assets and what each of the three coursework tasks demands. What’s included: 22-slide PowerPoint covering the scenario, trip costs, pupil payment schedule and supplied assets. A task-by-task overview: planning and design, essential calculations and outputs, what-if modelling, security, testing and evaluation. Mark Band 1–3 progression and a four-stage coursework action plan. Two check-understanding questions with answer reveals, plus an HCI discussion task with suggested answers. Learning objectives: Deconstruct the scenario, client requirements and asset files. Plan the three coursework tasks across planning, spreadsheet modelling and testing. Apply Mark Band 3 criteria for functionality, HCI and data security. Suitable for: KS4 students taking OCR Cambridge Nationals in IT (J836), unit R060. Ideal as the opening lesson before Task 1. Key features to highlight: A complete overview of the brief in one lesson, clear links to each client requirement, and a stage-by-stage action plan students can follow through the coursework. It works as the entry point to Task 1–3.

A ready-to-teach lesson that helps students break down the Westwood School Trips brief and produce detailed, Mark Band 3 design documentation before they build anything. What’s included 21-slide PowerPoint covering the scenario, trip costs, payment schedule and supplied assets. Design guidance for HCI and navigation, formulas, data validation, outputs and what-if models. Recommended design tools: wireframes, HCI flowcharts and data dictionaries. A Mark Band 1–3 progression slide, an “independent user test” checklist and common planning pitfalls. A check-understanding question with answer reveal, a peer-review discussion task and a completion checklist. Learning objectives Deconstruct the scenario by identifying all pupil costs, instalment splits and client requirements. Select and apply design tools to plan worksheets, navigation, validation rules and outputs. Produce detailed, fit-for-purpose design documentation that another person could implement. Suitable for: KS4 students taking OCR Cambridge Nationals in IT (J836), unit R060. Ideal as the launch lesson for the coursework. Key features: Worked cost and payment breakdowns, clear links to each client requirement, a focus on the “could someone else build it?” standard, and a pitfalls slide that targets common mark losses.

A complete spreadsheet lesson teaching students when to use COUNT, COUNTA, COUNTBLANK and COUNTIF. It includes text and numerical criteria, plus a business-themed exam-style assessment. What’s included: 20-slide PowerPoint with a function comparison matrix, COUNTIF syntax breakdown, step-by-step build and worked warehouse example. A common syntax pitfalls slide, two check-understanding questions with answer reveals, and a key takeaways summary. Exam-style worksheet built on an “Apex Logistics” dataset, with three sections: single-criterion verification, multi-criterion COUNTIFS, and error diagnosis and correction. Full answer key. Learning objectives: Distinguish between COUNT and COUNTA for numeric and non-empty cells. Construct single-criterion COUNTIF formulas with exact text matches. Use comparison operators within quotation marks to count against numerical thresholds. Suitable for: KS3 Computing/IT and KS4 spreadsheet units (e.g. OCR Cambridge Nationals R060 preparation). Works with Excel or Google Sheets. Fits one double lesson (80 minutes). Key features to highlight A clear “frequency vs magnitude” explanation, a worked example, error-spotting tasks that target common mistakes, and an exam-style worksheet with a realistic business dataset.

A complete lesson teaching students how VLOOKUP searches a table and returns related data, with a worked example, troubleshooting and a student records case study. What’s included: 20-slide PowerPoint covering how VLOOKUP works and its four arguments. A step-by-step worked product lookup, a video slide, common errors and VLOOKUP’s limitations. A check-understanding question and a formula-writing task, both with answer reveals. A “Student Records System” case study worksheet with 10 questions in three parts: formula construction, absolute referencing for batch processing, and troubleshooting. Full answer key. Learning objectives: Deconstruct the four arguments of the VLOOKUP formula. Use exact-match lookups to retrieve specific records. Diagnose column index limits and common lookup errors. Suitable for: KS3 Computing/IT and KS4 spreadsheet units, including OCR Cambridge Nationals R060 preparation. Works with Excel or Google Sheets. Fits one double lesson (80 minutes). Key features to highlight: A real-world “barcode scanner” hook, a step-by-step worked example, coverage of #N/A, #REF!, absolute referencing and trailing spaces, and a realistic school-records scenario students can relate to.

A complete lesson on how validation protects data integrity: list, range, length, presence and format checks, plus how to write clear, user-friendly error messages. What’s included: 20-slide PowerPoint covering GIGO, validation vs verification, and why “sensible doesn’t mean true”. Step-by-step set-up in Excel, a video slide, and the core validation types. A worked NHS blood pressure example, a check-understanding question and an independent application task, both with answer reveals. “Form Field Constraint & Validation Design” worksheet with four tasks: an NHS patient form data dictionary e-commerce checkout rules critiquing and rewriting poor error messages boundary testing and validation vs verification. Full answer key. Learning objectives: Distinguish between validation and verification and their roles in system reliability. Implement list, range, length and presence checks. Design user-centred error alerts that help users correct invalid entries. Suitable for: KS3 Computing/IT, KS4 spreadsheet units, and OCR Cambridge Nationals R060 preparation (data validation is a client requirement in the coursework). Fits one double lesson (80 minutes). Key features to highlight: Real-world scenarios from the NHS, online retail and HR, a strong HCI focus on writing good error messages, a “spot the bad alert” critique task, and normal, boundary and erroneous test data practice.

A complete lesson teaching students to build IF statements, avoid the “boundary trap”, and combine IF with COUNTIF to summarise results, using an exam-board grade modelling worksheet. What’s included 22-slide PowerPoint covering decision logic, the three IF arguments, comparison operators and a step-by-step pass/fail build. Common errors, boundary conditions, and a worked example combining IF and COUNTIF. A video slide, two check-understanding tasks with answer reveals, and a discussion on avoiding hardcoded values. “Grade Boundary Modelling” worksheet with four tasks: logic and boundary traps, COUNTIF aggregation, syntax diagnostics, and a nested IF extension. Full answer key. Learning objectives Construct three-argument IF statements using appropriate comparison operators. Debug common syntax errors involving speech marks, commas and cell references. Combine IF classification with COUNTIF to summarise data. Suitable for KS3 Computing/IT and KS4 spreadsheet units, including OCR Cambridge Nationals R060 preparation. Works with Excel or Google Sheets. Fits one double lesson (80 minutes). Key features to highlight A memorable “railway points” analogy, a focus on the >= vs > boundary mistake, good modelling practice through parameter cells and absolute references, and a stretch task on nested IFs.

20-slide lesson guiding OCR Cambridge Nationals IT R060 students through Task 2: building the Westwood School Trips spreadsheet to Mark Band 3 standard. This editable PowerPoint takes students step by step through Task 2, using the Westwood School Trips (WST) scenario: a 5-day Barcelona trip for 30 pupils and 3 staff. Learning objectives Use formulas and functions to model trip costs, pupil instalments and payment summaries Set up data validation, protection passwords and clear navigation that meet the WST client’s needs Produce the four required charts and separate what-if models What’s covered The scenario and the supplied assets (CSV data files, logo, test plan) Trip cost breakdown (£21,600 total, £720 per pupil) and the deposit/instalment schedule Data validation: Yes/No drop-downs with input messages and error alerts COUNTIF, SUM and outstanding-balance calculations Automated report of pupils who still owe money (FILTER / lookup approaches) The four management charts: cost breakdown, number paid, value paid, paid vs outstanding What-if modelling: 36 pupils, and a 5% accommodation discount Cell locking, sheet protection and the workbook password HCI design: navigation, house style and currency formatting What good coursework evidence looks like (value views, formula views, dialog screenshots) Built-in checks A multiple-choice formula question with an answer reveal A Scenario B calculation with a worked answer A final readiness checklist Ideal for: Year 10/11 Cambridge Nationals IT, during coursework lessons or as a revision guide.

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.

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.

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.

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.

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.

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.

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