Graduate Thesis Or Dissertation
 

College student novice spreadsheet reasoning and errors

Public Deposited

Contenu téléchargeable

Télécharger le fichier PDF
https://ir.library.oregonstate.edu/concern/graduate_thesis_or_dissertations/44558g91b

Descriptions

Attribute NameValues
Creator
Abstract
  • 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
  • Keywords: Reasoning, Spreadsheet, Errors, Education
License
Resource Type
Date Available
Date Issued
Degree Level
Degree Name
Degree Field
Degree Grantor
Commencement Year
Advisor
Committee Member
Academic Affiliation
Non-Academic Affiliation
Subject
Déclaration de droits
Publisher
Peer Reviewed
Language
Replaces

Des relations

Parents:

This work has no parents.

Dans Collection:

Articles

La vignette Titre Date de téléchargement Visibilité actes
file details Hoag_dissertation.pdf 2017-08-08 Public Télécharger