A Numbers¹ spreadsheet that provides teachers with an attractive interface to record, analyse and track progress in students’ grades. Capable of tracking results for up to three classes in the same subject (and can be edited to extend for more classes). Per assessment scores can be recorded from two separate sections independently if desired. Grade boundaries are set per assessment in the designated table. Graphs show % scores in 5% range categories and the grade distribution. A bubble graph helps to visualise if top scorers / low scorers had notable strengths or weaknesses in section A or B of the exam. In the main table achieved grades are compared with target grades and class average deviation from targets are also computed. There is also a bubble chart that can cycle through the assessments which makes it easy for the teacher to click through the assessments and see if there are any notable trends - it is also simple to present the chart to a class to discuss exam performance (my students love this). The Tracking Sheet imports results from the individual test Sheets. On this Sheet you can optionally use weighted percentages for the assessments (e.g. give more challenging assessments higher weighting to account for the difference or give more recent assessments higher weightings to emphasise recent progress). Overall performance is illustrated on the Tracking Sheet with target grade comparisons and distribution graphs. ¹ Numbers is spreadsheet software made by Apple, it opens with the Numbers app available for free with most recent iPhone / iPad / Mac devices also available with a free Apple ID for use in most web browsers.

Activity for practicing calculation of y-intercepts for graphs with a false origin. This worksheet includes five graphs with lines of best fit already plotted. A student needs to draw the gradient triangle, determine the gradient and then use y = mx + c to determine the value of the intercept. Pages with solutions for all graphs are included in the document. The graphs cover a range of topic areas in physics (free-fall, Hooke’s Law, wave intensity, mass-spring oscillation and capacitor discharge). But since a student only needs to determine values for the gradient and intercept students do not need to be familiar with the topic in order to tackle the tasks. Suitable for AQA and OCR Physics A AS-Level and A-Level specifications. (7407, 7408, H156, H556) This worksheet is great for home learning since it has solutions to all questions included in the document and it is part of a series that gradually builds up a range of graphing techniques.

A comprehensive set of basic statistical tests in one spreadsheet. Includes: distribution checker (check whether data is normally distributed), standard error and confidence limits, student’s t-test, chi squared test, Spearman and Pearson correlations. The first sheet has a decision tree to help decide which type of analysis is most appropriate for the data. Simply follow the decision tree and click the link to jump to the relevant sheet for that test. The spreadsheet is built in Apple’s Numbers application (iOS, iPadOS and macOS).

Graph grids for digital graph work in PDF format - use with iPads / tablets and Apple Pencils / styluses etc. The grids available are 8 × 12 and 10 × 14 large squares - each large square being 10 × 10 small squares. Can be used in portrait or landscape.