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 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.
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.
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.