College student novice spreadsheet reasoning and errors Public Deposited

http://ir.library.oregonstate.edu/concern/graduate_thesis_or_dissertations/44558g91b

Descriptions

Attribute NameValues
Creator
Abstract or Summary
  • The spreadsheet has become a common technology tool and is now a predominant form of end-user programming. Some of the same features that make spreadsheets excellent tools for ad-hoc development can introduce errors into the final product. Although a variety of research has been performed investigating methods to detect errors in spreadsheets, little has been done to investigate initial reasoning errors. The spreadsheet error taxonomy developed by Rajalingham, Chadwick, and Knight (2001) includes categories for reasoning errors that have not yet been investigated. Previous studies have categorized errors in existing spreadsheets, but have not analyzed the source of the error. This study investigates the reasoning of college students while developing spreadsheets and examines the reasoning associated with errors generated in spreadsheet development. For this study, a phenomenological qualitative design incorporated a think-aloud protocol, interviews, and recordings of spreadsheet development of three purposefully-selected students. Data sources were analyzed to determine their reasoning, the types of errors produced based on the taxonomy, and associations between reasoning and errors. The findings indicated that students used different types of reasoning in the mathematical phases of spreadsheet development than they do in the spreadsheet implementation phase. As novice spreadsheet developers, the students had significant difficulties translating problems into mathematical representations. Spreadsheet skills and concepts improved with practice through the course, but mathematical representations remained problematic. The students enjoyed using the spreadsheet as a tool for doing mathematical reasoning. Several themes emerged as the study progressed: Reasoning differences during mathematical and spreadsheet phases of development; using icons for functions affected conceptualization of the functions; copy operations were perceived as ―painting‖ rather than applying a formula to a series; and the effectiveness of the taxonomy for categorizing reasoning errors . The results suggested modifications to student learning experiences leading to more accurate spreadsheet development: Integrate spreadsheets into mathematics courses; increase education in spreadsheet development; integrate formal design and testing components to the spreadsheet curriculum; include spreadsheet errors in the curriculum
Resource Type
Date Available
Date Copyright
Date Issued
Degree Level
Degree Name
Degree Field
Degree Grantor
Commencement Year
Advisor
Committee Member
Non-Academic Affiliation
Keyword
Subject
Rights Statement
Language
Replaces
Additional Information
  • description.provenance : Submitted by James Hoag (hoagj@onid.orst.edu) on 2008-09-04T11:38:50Z No. of bitstreams: 1 Hoag dissertation.pdf: 1378455 bytes, checksum: e4f860d9fc350d6efef785f78798c816 (MD5)
  • description.provenance : Made available in DSpace on 2008-09-15T14:23:13Z (GMT). No. of bitstreams: 1 Hoag dissertation.pdf: 1378455 bytes, checksum: e4f860d9fc350d6efef785f78798c816 (MD5)
  • description.provenance : Approved for entry into archive by Linda Kathman(linda.kathman@oregonstate.edu) on 2008-09-15T14:23:13Z (GMT) No. of bitstreams: 1 Hoag dissertation.pdf: 1378455 bytes, checksum: e4f860d9fc350d6efef785f78798c816 (MD5)
  • description.provenance : Approved for entry into archive by Julie Kurtz(julie.kurtz@oregonstate.edu) on 2008-09-10T20:08:48Z (GMT) No. of bitstreams: 1 Hoag dissertation.pdf: 1378455 bytes, checksum: e4f860d9fc350d6efef785f78798c816 (MD5)

Relationships

In Administrative Set:
Last modified: 08/08/2017

Downloadable Content

Download PDF
Citations:

EndNote | Zotero | Mendeley

Items