nrich
enriching mathematics
Skip over navigation
Home
Home
Students
Guide and features
Teachers
Guide and features
STEM
Science, Technology, Engineering and Mathematics
AskNRICH
Forum
early years
Featured Early Years Foundation Stage; US Kindergarten
Early years
primary
Featured UK Key Stage 1&2; US Grades 1-4
Primary teachers
secondary
Featured UK Key Stage 3-5; US Grades 5-12
Secondary teachers
primary lower
Featured UK Key Stage 1, US Grade 1 & 2
primary
primary
Featured UK Key Stage 2; US Grade 3 & 4
secondary lower
Featured UK Key Stages 3 & 4; US Grade 5-10
secondary
secondary upper
Featured UK Key Stage 4 & 5; US Grade 11 & 12
Topics
translate
Excel Interactive Resource: Number Grid Functions
Stage: 3 and 4
Challenge Level:
The interactive screens section this month is based on two downloadable Excel files:
Products on a Number Grid
and
Number Grid Functions
.
These were two GCSE coursework introductions.
They are made available here for teachers who might wish to present these investigations to their students using the Excel files.
But if these examples stimulate other similar presentations, so much the better.
"Products on a Number Grid" invites students to notice that the product formed by the values in opposite corners of a rectangle on a number grid maintain a constant difference for all positions of a rectangle of a fixed size.
"Number Grid Functions" is a more general treatment. Here students are invited to consider the effect of translations around a number grid of varying width, first of a simple sum, but beyond that to other operations or functions.