Using Spreadsheets to Assess Learning
Physics Teacher Volume 45, Number 1, ISSN 0031-921X
Spreadsheets can be a powerful tool when it comes to teaching physics. From data analysis and graphing to animated simulations, Excel[R] is a very versatile program for the educator and learner alike. This paper describes and supports another use for Excel through Reflective Formative Assessment Spreadsheets (RFAS). To illustrate the use of RFAS, Fig. 1 shows a released AP Physics question that one student, a group of students, or the entire class may see when they access a prepared RFAS file from a shared drive. Notice that this file has been given a PowerPoint[R] look by removing scrollbars and gridlines and by using the Full Screen option (Fig. 1, arrow a). Students navigate from one question to the next using the tabs (Fig. 1, arrow b).
Wagner, J.E. (2007). Using Spreadsheets to Assess Learning. Physics Teacher, 45(1), 34-37.