Data Tables & Graphs
Graphs & Gradients.pdfBasic Graphing exercises
10 pages (2021)
Author : K.Barrett Licence : CC-BY-ND Audience : Secondary Physics Year 9+
TES website Link : not currently available
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
Microsoft Excel files (2021)
Author : K.Barrett Licence : CC-BY-ND Audience : Secondary Physics Year 12+ (Level 3 NCEA)
TES website Link :not currently available
Content: A series of 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 hidden sheets.
This is for students who already familiar with the basic workings of Microsoft Excel.
L3 Excel graphs ball on ramp.xlsxL3 Excel graphs part 1.xlsxL3 Excel graphs part 2.xlsxL3 Excel graphs part 3.xlsxExcel Graphing Exercises for NCEA L2 Physics 2-1
Microsoft Excel files (2021)
Author : K.Barrett Licence : CC-BY-ND Audience : Secondary Physics Year 12+ (Level 3 NCEA)
TES website Link : not currently available
Content: A series of reinforcement Excel workbook exercises intended to specifically hone the skills of graph plotting for the Physics 2-1 investigation.
The first sheet in each workbook gives the learning intentions. The “raw data/answers” are included in hidden sheets.
L2 excel Concorde acceleration.xlsx