Data Tables & Graphs


Graphs & Gradients.pdf

Basic Graphing exercises

10 pages (2021)

Author : K.Barrett Licence : CC-BY-ND Audience : Secondary Physics Year 9+

TES website Link : https://www.tes.com/teaching-resource/-12391914

Content: Basic Guidance on presentation of data - changing default excel graphs to acceptable scientific standard - simple graph plotting exercises - exercises on gradients and area under line - interpreting graphs as mathematical equations.

Excel Graphing Exercises for NCEA L3 Physics 3-1

3 Microsoft Excel files (2021)

Author : K.Barrett Licence : CC-BY-ND Audience : Secondary Physics Year 12+ (Level 3 NCEA)

TES website Link : https://www.tes.com/teaching-resource/resource-12548044

Content: A series of 3 reinforcement Excel workbook data processing exercises intended to specifically hone the skills of graph plotting in NCEA Physics 3-1 practicals. The first sheet in each workbook gives the learning intentions. The “raw data/answers” are included in a hidden sheet. This is for students who already familiar with the basic workings of Microsoft Excel.


L3 Excel graphs part 1.xlsx
L3 Excel graphs part 2.xlsx
L3 Excel graphs part 3.xlsx