Using algebra, functions and graphs

Starters

Click on the links above for starter activities, assignments, skill activities and web links related to this module.

We welcome feedback and contributions. If you have any comments, ideas or resources to offer please contact June Haighton.

Please note that resources added most recently are at the bottom of the page.

Graphs of Functions in Excel
This activity shows students how to draw graphs of algebraic functions in Excel. Teacher Notes included.

Student Information (application/msword, 1.1 MB) (application/pdf, 1.8 MB)

Hire a Coach
Uses Excel in real contexts to introduce the concepts of gradient and intercept for linear graphs. Teacher Notes included.

Student Information (application/msword, 624 KB) (application/pdf, 110 KB)

Linear Graphs
Powerpoint presentation and activity to introduce linear graphs. Teacher Notes included.

Student Information (application/msword, 136 KB) (application/pdf, 49 KB)
Powerpoint file (application/octet-stream, 106 KB)

Plumbers' Prices
An introduction to the graphical solution of simultaneous equations using Excel in real contexts. Can be used as a follow-up to Hire a Coach. Teacher Notes included.

Student Information (application/msword, 249 KB) (application/pdf, 94 KB)

Road Test
Includes data from a road test on a sports car. Use at the start of the course for practice in drawing and interpreting graphs. Optional use of spreadsheet. Teacher Notes included.

Student Information: (application/msword, 207 KB) (application/pdf, 142 KB)
Spreadsheet (application/vnd.ms-excel, 16 KB)

Area under a Graph
Powerpoint presentation to introduce area under a velocity-time graph accompanied by examples for students to try. Optional use of spreadsheet/graphic calculator. Teacher Notes including answers.

Students information and teacher notes (application/msword, 216 KB) (application/pdf, 68 KB)
PowerPoint presentation (application/vnd.ms-powerpoint, 119 KB)

Large and Small
Powerpoint presentation and examples from real contexts to introduce, practise or revise standard form. Teacher Notes including answers.

Students information and teacher notes (application/msword, 402 KB) (application/pdf, 136 KB)
PowerPoint presentation (application/vnd.ms-powerpoint, 154 KB)