The Reflective Formative Assessment Spreadsheets were made to display questions that engage students in rich discussion, use cell referencing to collect information from students as they develop understanding, and generate graphs instantaneously that help teachers to modify their instruction in a way that corrects and extends student understanding.

Descriptions of the spreadsheets can be found in The Physics Teacher magazine, (“Using Spreadsheets to Assess Learning,” Phys. Teach. 45, 34-37, Jan. 2007), Cable in The Classroom magazine, (“A Driving Force,” page 28, January 2007), and in a flash slideshow which is best viewed with a 1024x768 screen resolution.

Below are prepared assessments that can be downloaded, unzipped and used.