Using Spreadsheets to Assess Learning
ARTICLE
Judson E. Wagner
Physics Teacher Volume 45, Number 1, ISSN 0031-921X
Abstract
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).
Citation
Wagner, J.E. (2007). Using Spreadsheets to Assess Learning. Physics Teacher, 45(1), 34-37. Retrieved March 28, 2024 from https://www.learntechlib.org/p/106468/.
ERIC is sponsored by the Institute of Education Sciences (IES) of the U.S. Department of Education.
Copyright for this record is held by the content creator. For more details see ERIC's copyright policy.