ERIC Number: EJ891963
Record Type: Journal
Publication Date: 2007-Jan
Abstractor: As Provided
Reference Count: 20
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).
Descriptors: Portfolio Assessment, Student Evaluation, Spreadsheets, Evaluation Methods, Physics, Science Instruction, Teaching Methods, Computer Uses in Education, Computer Software, Educational Technology, Computer Assisted Testing
American Association of Physics Teachers. One Physics Ellipse, College Park, MD 20740. Tel: 301-209-3300; Fax: 301-209-0845; e-mail: firstname.lastname@example.org; Web site: http://scitation.aip.org/tpt
Publication Type: Journal Articles; Reports - Descriptive
Education Level: N/A
Authoring Institution: N/A