Getting Students Ready for Accounting Spreadsheets: Training for Basic Spreadsheet Skills with Pre/Post Assessments
Issues in Accounting Education · 01.05.2023 · 38 (2) · 63-84
DOI: 10.2308/issues-2021-010 ↗Kurz gefasst
Fachartikel in der Zeitschrift Issues in Accounting Education, online erschienen am 30.05.2023. Verfasst von A. Faye Borthick und 1 weiteren Autor:innen. Die Arbeit wurde bisher 3-mal zitiert (Crossref) und nennt 40 Literaturangaben.
Abstract (Originalsprache)
This case is intended to impart basic spreadsheet skills to students that do not have them. It trains them to transform data, create formulas (with functions, IF statements, and absolute references), aggregate data, look up values, configure pivot tables, sort data, record macros, and extract spreadsheet tasks from conversation. These skills are needed for subsequent spreadsheet analyses for solving business problems. Suitable for students that can copy cells and develop simple formulas, the case offers pre- and post-assessment questions. The case provides scaffolding resources: flashcards for Excel features, a work plan template, a narrated video for getting started with the work plan, and guidance (scripts with screenshots and narrated videos) for performing the spreadsheet tasks. Using the context of a gradebook application, which is familiar to students, the case minimizes the cognitive load students experience because they are not trying to learn accounting and spreadsheet skills simultaneously.
Zitieren
APA
Borthick, A. F., & Schneider, G. P. (2023). Getting Students Ready for Accounting Spreadsheets: Training for Basic Spreadsheet Skills with Pre/Post Assessments. Issues in Accounting Education, 38(2), 63-84. https://doi.org/10.2308/issues-2021-010
Vancouver
Borthick AF, Schneider GP. Getting Students Ready for Accounting Spreadsheets: Training for Basic Spreadsheet Skills with Pre/Post Assessments. Issues in Accounting Education. 2023;38(2):63-84. doi:10.2308/issues-2021-010
BibTeX
@article{Borthick2023,
author = {Borthick, A. Faye and Schneider, Gary P.},
title = {Getting Students Ready for Accounting Spreadsheets: Training for Basic Spreadsheet Skills with Pre/Post Assessments},
journal = {Issues in Accounting Education},
year = {2023},
volume = {38},
number = {2},
pages = {63--84},
doi = {10.2308/issues-2021-010}
}
EUVIMED