{"id":"https://openalex.org/W4294975889","doi":"https://doi.org/10.2308/issues-2021-010","title":"Getting Students Ready for Accounting Spreadsheets: Training for Basic Spreadsheet Skills with Pre/Post Assessments","display_name":"Getting Students Ready for Accounting Spreadsheets: Training for Basic Spreadsheet Skills with Pre/Post Assessments","alternate_titles":[],"publication_year":2022,"publication_date":"2022-09-08","ids":{"openalex":"https://openalex.org/W4294975889","doi":"https://doi.org/10.2308/issues-2021-010"},"language":"en","primary_location":{"id":"doi:10.2308/issues-2021-010","doi":"https://doi.org/10.2308/issues-2021-010","is_oa":false,"landing_page_url":"https://doi.org/10.2308/issues-2021-010","pdf_url":null,"source":{"id":"https://openalex.org/S6450948","display_name":"Issues in Accounting Education","issn_l":"0739-3172","issn":["0739-3172","1558-7983"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["abdc-a","anvur-scientific","cwts-core","jufo-1","norway-1","poland-40","russia-white-list-3","vabb-shw"],"host_organization":"https://openalex.org/P4310316290","host_organization_name":"American Accounting Association","host_organization_lineage":["https://openalex.org/P4310316290"],"host_organization_lineage_names":["American Accounting Association"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Issues in Accounting Education","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W4294975889"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5068019229","display_name":"A. Faye Borthick","orcid":"https://orcid.org/0000-0002-2122-464X","observed_orcids":["https://orcid.org/0000-0002-2122-464X"]},"institutions":[{"id":"https://openalex.org/I181565077","display_name":"Georgia State University","ror":"https://ror.org/03qt6ba18","country_code":"US","type":"education","lineage":["https://openalex.org/I181565077"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"A. Faye Borthick","raw_affiliation_strings":["Georgia State University"],"raw_orcid":"https://orcid.org/0000-0002-2122-464X","affiliations":[{"raw_affiliation_string":"Georgia State University","institution_ids":["https://openalex.org/I181565077"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5036814850","display_name":"Gary P. Schneider","orcid":"https://orcid.org/0000-0002-9504-6284","observed_orcids":["https://orcid.org/0000-0002-9504-6284"]},"institutions":[{"id":"https://openalex.org/I135369504","display_name":"California State University, Monterey Bay","ror":"https://ror.org/00mjdtw98","country_code":"US","type":"education","lineage":["https://openalex.org/I135369504"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Gary P. Schneider","raw_affiliation_strings":["California State University, Monterey Bay"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"California State University, Monterey Bay","institution_ids":["https://openalex.org/I135369504"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.0658,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.74476321,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"38","issue":"2","first_page":"63","last_page":"84"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12378","display_name":"Accounting Education and Careers","score":0.9955999851226807,"subfield":{"id":"https://openalex.org/subfields/1402","display_name":"Accounting"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T12378","display_name":"Accounting Education and Careers","score":0.9955999851226807,"subfield":{"id":"https://openalex.org/subfields/1402","display_name":"Accounting"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T12671","display_name":"Management and Marketing Education","score":0.00139999995008111,"subfield":{"id":"https://openalex.org/subfields/3304","display_name":"Education"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.00139999995008111,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/spreadsheet-skills","display_name":"spreadsheet skills","score":0.8500000238418579},{"id":"https://openalex.org/keywords/excel-training","display_name":"Excel training","score":0.6919999718666077},{"id":"https://openalex.org/keywords/pivot-tables","display_name":"pivot tables","score":0.6119999885559082},{"id":"https://openalex.org/keywords/if-statements","display_name":"if statements","score":0.7720000147819519},{"id":"https://openalex.org/keywords/data-aggregation","display_name":"data aggregation","score":0.7630000114440918},{"id":"https://openalex.org/keywords/lookup-functions","display_name":"lookup functions","score":0.6660000085830688},{"id":"https://openalex.org/keywords/macros","display_name":"macros","score":0.6010000109672546},{"id":"https://openalex.org/keywords/scaffolding","display_name":"scaffolding","score":0.7279999852180481},{"id":"https://openalex.org/keywords/pre-post-assessment","display_name":"pre- and post-assessment","score":0.8130000233650208},{"id":"https://openalex.org/keywords/cognitive-load","display_name":"cognitive load","score":0.6840000152587891},{"id":"https://openalex.org/keywords/business-problem-solving","display_name":"business problem solving","score":0.6309999823570251}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7542635202407837},{"id":"https://openalex.org/C61423126","wikidata":"https://www.wikidata.org/wiki/Q187432","display_name":"Scripting language","level":2,"score":0.6419646143913269},{"id":"https://openalex.org/C166955791","wikidata":"https://www.wikidata.org/wiki/Q629579","display_name":"Macro","level":2,"score":0.6197023391723633},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.580703616142273},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.4876233637332916},{"id":"https://openalex.org/C2778370645","wikidata":"https://www.wikidata.org/wiki/Q5668585","display_name":"Note-taking","level":2,"score":0.42297008633613586},{"id":"https://openalex.org/C18762648","wikidata":"https://www.wikidata.org/wiki/Q42213","display_name":"Work (physics)","level":2,"score":0.42111027240753174},{"id":"https://openalex.org/C2777200299","wikidata":"https://www.wikidata.org/wiki/Q52943","display_name":"Conversation","level":2,"score":0.4117036759853363},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.23543646931648254},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.22823143005371094},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.12851017713546753},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C46312422","wikidata":"https://www.wikidata.org/wiki/Q11024","display_name":"Communication","level":1,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.2308/issues-2021-010","doi":"https://doi.org/10.2308/issues-2021-010","is_oa":false,"landing_page_url":"https://doi.org/10.2308/issues-2021-010","pdf_url":null,"source":{"id":"https://openalex.org/S6450948","display_name":"Issues in Accounting Education","issn_l":"0739-3172","issn":["0739-3172","1558-7983"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["abdc-a","anvur-scientific","cwts-core","jufo-1","norway-1","poland-40","russia-white-list-3","vabb-shw"],"host_organization":"https://openalex.org/P4310316290","host_organization_name":"American Accounting Association","host_organization_lineage":["https://openalex.org/P4310316290"],"host_organization_lineage_names":["American Accounting Association"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Issues in Accounting Education","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality education","id":"https://metadata.un.org/sdg/4","score":0.9901999831199646}],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":27,"referenced_works":["https://openalex.org/W2060966585","https://openalex.org/W2089066421","https://openalex.org/W2089236283","https://openalex.org/W2112338634","https://openalex.org/W2130736456","https://openalex.org/W2136507509","https://openalex.org/W2139466555","https://openalex.org/W2139645498","https://openalex.org/W2235151888","https://openalex.org/W2309377202","https://openalex.org/W2955819390","https://openalex.org/W2982284427","https://openalex.org/W3029583515","https://openalex.org/W3034933658","https://openalex.org/W3043477315","https://openalex.org/W3080746133","https://openalex.org/W3095709727","https://openalex.org/W3121207719","https://openalex.org/W3123402592","https://openalex.org/W3124208183","https://openalex.org/W3164286348","https://openalex.org/W3173466393","https://openalex.org/W3194689603","https://openalex.org/W4200521730","https://openalex.org/W4211055544","https://openalex.org/W4220983994","https://openalex.org/W7063754100"],"related_works":["https://openalex.org/W2948496579","https://openalex.org/W2569559910","https://openalex.org/W2022476280","https://openalex.org/W2193215577","https://openalex.org/W2139466555","https://openalex.org/W602868001","https://openalex.org/W7127137378","https://openalex.org/W1525496783","https://openalex.org/W2955819390","https://openalex.org/W4401499375"],"abstract_inverted_index":{"ABSTRACT":[0],"This":[1],"case":[2,74,81,129],"is":[3,124],"intended":[4],"to":[5,10,20,126,141],"impart":[6],"basic":[7],"spreadsheet":[8,46,56,114,145],"skills":[9,51,146],"students":[11,64,134],"that":[12,65],"do":[13],"not":[14,139],"have":[15],"them.":[16],"It":[17],"trains":[18],"them":[19],"transform":[21],"data,":[22,33,41],"create":[23],"formulas":[24],"(with":[25],"functions,":[26],"IF":[27],"statements,":[28],"and":[29,44,69,77,103,108,144],"absolute":[30],"references),":[31],"aggregate":[32],"look":[34],"up":[35],"values,":[36],"configure":[37],"pivot":[38],"tables,":[39],"sort":[40],"record":[42],"macros,":[43],"extract":[45],"tasks":[47],"from":[48],"conversation.":[49],"These":[50],"are":[52,138],"needed":[53],"for":[54,58,63,86,96,111],"subsequent":[55],"analyses":[57],"solving":[59],"business":[60],"problems.":[61],"Suitable":[62],"can":[66],"copy":[67],"cells":[68],"develop":[70],"simple":[71],"formulas,":[72],"the":[73,100,113,117,128,131],"offers":[75],"pre-":[76],"post-assessment":[78],"questions.":[79],"The":[80],"provides":[82],"scaffolding":[83],"resources:":[84],"flashcards":[85],"Excel":[87],"features,":[88],"a":[89,93,120],"work":[90,101],"plan":[91],"template,":[92],"narrated":[94,109],"video":[95],"getting":[97],"started":[98],"with":[99,106],"plan,":[102],"guidance":[104],"(scripts":[105],"screenshots":[107],"videos)":[110],"performing":[112],"tasks.":[115],"Using":[116],"context":[118],"of":[119],"gradebook":[121],"application,":[122],"which":[123],"familiar":[125],"students,":[127],"minimizes":[130],"cognitive":[132],"load":[133],"experience":[135],"because":[136],"they":[137],"trying":[140],"learn":[142],"accounting":[143],"simultaneously.":[147]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4294975889","counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":2}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2022-09-08T00:00:00"}
