OCR Cambridge Nationals IT (J836) – R060 Data Manipulation Using Spreadsheets

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.