NotesFAQContact Us
Collection
Advanced
Search Tips
50 Years of ERIC
50 Years of ERIC
The Education Resources Information Center (ERIC) is celebrating its 50th Birthday! First opened on May 15th, 1964 ERIC continues the long tradition of ongoing innovation and enhancement.

Learn more about the history of ERIC here. PDF icon

Back to results
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
ISBN: N/A
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: pubs@aapt.org; Web site: http://scitation.aip.org/tpt
Publication Type: Journal Articles; Reports - Descriptive
Education Level: N/A
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Identifiers: N/A