NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ891963
Record Type: Journal
Publication Date: 2007-Jan
Pages: 4
Abstractor: As Provided
Reference Count: 20
ISSN: ISSN-0031-921X
Using Spreadsheets to Assess Learning
Wagner, Judson E.
Physics Teacher, v45 n1 p34-37 Jan 2007
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).
American Association of Physics Teachers. One Physics Ellipse, College Park, MD 20740. Tel: 301-209-3300; Fax: 301-209-0845; e-mail:; Web site:
Publication Type: Journal Articles; Reports - Descriptive
Education Level: N/A
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A