NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ775899
Record Type: Journal
Publication Date: 2007-Oct
Pages: 31
Abstractor: Author
Reference Count: 49
ISSN: ISSN-0731-9258
Impact of a Spreadsheet Exploration on Secondary School Students' Understanding of Statistical Graphs
Wu, Yingkang; Wong, Khoon Yoong
Journal of Computers in Mathematics and Science Teaching, v26 n4 p355-385 Oct 2007
This case study investigated the impact of a spreadsheet (EXCEL) exploration on the understanding of statistical graphs among twenty Singapore secondary school students of average ability. Four EXCEL templates were constructed to allow students to explore four aspects of statistical graphs: zero in scale, effect of different scales, size pictogram, and cumulative line graph. The exploration was guided with questions and interactive feedback embedded in the templates. The students worked in pairs and took a pre and posttest about statistical graphs. Pair discussion, field notes, and online entries captured by macros were analyzed, resulting in the identification of an "isolated approach" and "a relational approach" used by these students in their EXCEL exploration. Three quarters of the students showed gain scores in the posttest, suggesting positive impacts of this exploration on students' understanding of statistical graphs. The findings suggest further effort to extend the use of spreadsheet to other statistics and mathematics topics. Several areas for further research are discussed. (Contains 7 figures, 2 tables and 2 notes.)
Association for the Advancement of Computing in Education. P.O. Box 1545, Chesapeake, VA 23327-1545. Tel: 757-366-5606; Fax: 703-997-8760; e-mail:; Web site:
Publication Type: Journal Articles; Reports - Research
Education Level: Secondary Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Identifiers - Location: Singapore