pptx, 422.33 KB
pptx, 422.33 KB
xlsx, 18.83 KB
xlsx, 18.83 KB
xlsx, 21.82 KB
xlsx, 21.82 KB
png, 234.69 KB
png, 234.69 KB
png, 199.14 KB
png, 199.14 KB
png, 233.27 KB
png, 233.27 KB

OCR Cambridge National in IT J836 – R060 Data Manipulation Using Spreadsheets | Complete NEA Skills Resource + Practice Workbooks

Teach every R060 skill before the set assignment, with verified formulas, editable demonstrations and full teacher notes. Aligned to the J836 specification, Version 8 (October 2026).

WHAT’S INCLUDED

Fully editable 94-slide PowerPoint with detailed speaker notes on every slide
Skills Practice Workbook (.xlsx) for students, with yellow task cells across 8 sheets
Solutions Workbook with every formula completed and verified: zero formula errors

FULL COVERAGE
TA1 Planning and designing: design tools, calculation flowcharts (no cell references, as the specification requires), outputs, page layout, house style, HCI and navigation.
TA2 Creating: all 16 named functions (SUM to SUBTOTAL), relative, absolute, named and multi-sheet references, validation, conditional formatting, sorting and filtering, pivot tables, security, what-if and Goal Seek, charts, buttons, macros, hyperlinks and start-up.
TA3 Testing: following a given test plan, valid, invalid and extreme data, recording evidence and retesting.
TA4 Evaluating: moving from stating to describing to explaining effectiveness.

ACCURATE AND PRACTICAL
Every value on the slides comes from the recalculated workbook, and the café sales totals reconcile exactly. The mock spreadsheet grids are editable, with formula bars, and Excel, Google Sheets and LibreOffice Calc differences are noted.

NEA-SAFE BY DESIGN
The marking criteria and descriptor words are explained clearly. The resource covers feedback limits, AI and referencing rules, and authentication. The practice is short skills exercises, not a mock assignment, in line with OCR’s rules on practice material.

GRADUAL RELEASE MODEL
I DO, WE DO, YOU DO and CHECK are labelled with text as well as colour. Support, Core and Stretch tiers make the resource ideal for mixed-attainment classes and learners with SEND.

WHO IT’S FOR
IT departments delivering J836, non-specialist teachers and ECTs who want confident spreadsheet teaching, and Heads of Department who need clear specification mapping and NEA compliance. Works in PowerPoint, Excel, Google Slides, Google Sheets and LibreOffice.

Independent resource, not endorsed by OCR. All data and scenarios are fictional.

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have purchased this resource can review it

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.