{"id":"https://openalex.org/W2165963312","doi":"https://doi.org/10.1109/fie.2011.6142980","title":"Teaching computational thinking to non-computing majors using spreadsheet functions","display_name":"Teaching computational thinking to non-computing majors using spreadsheet functions","publication_year":2011,"publication_date":"2011-10-01","ids":{"openalex":"https://openalex.org/W2165963312","doi":"https://doi.org/10.1109/fie.2011.6142980","mag":"2165963312"},"language":"en","primary_location":{"id":"doi:10.1109/fie.2011.6142980","is_oa":false,"landing_page_url":"https://doi.org/10.1109/fie.2011.6142980","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2011 Frontiers in Education Conference (FIE)","raw_type":"proceedings-article"},"type":"article","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/A5045227171","display_name":"Kuo-Chuan Yeh","orcid":null},"institutions":[{"id":"https://openalex.org/I130769515","display_name":"Pennsylvania State University","ror":"https://ror.org/04p491231","country_code":"US","type":"education","lineage":["https://openalex.org/I130769515"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Kuo-Chuan Yeh","raw_affiliation_strings":["Department of Computer Science and Engineering, The Pennsylvania State University, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, The Pennsylvania State University, USA","institution_ids":["https://openalex.org/I130769515"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5012344034","display_name":"Ying Xie","orcid":"https://orcid.org/0000-0002-9189-6046"},"institutions":[{"id":"https://openalex.org/I106969075","display_name":"Idaho State University","ror":"https://ror.org/0162z8b04","country_code":"US","type":"education","lineage":["https://openalex.org/I106969075"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ying Xie","raw_affiliation_strings":["Department of Educational Leadership and Instructional Design, Idaho State University, USA"],"affiliations":[{"raw_affiliation_string":"Department of Educational Leadership and Instructional Design, Idaho State University, USA","institution_ids":["https://openalex.org/I106969075"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034097062","display_name":"Fengfeng Ke","orcid":"https://orcid.org/0000-0003-4203-1203"},"institutions":[{"id":"https://openalex.org/I103163165","display_name":"Florida State University","ror":"https://ror.org/05g3dte14","country_code":"US","type":"education","lineage":["https://openalex.org/I103163165"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Fengfeng Ke","raw_affiliation_strings":["Department of Educational Psychology and Learning Systems, The Florida State University, USA"],"affiliations":[{"raw_affiliation_string":"Department of Educational Psychology and Learning Systems, The Florida State University, USA","institution_ids":["https://openalex.org/I103163165"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5045227171"],"corresponding_institution_ids":["https://openalex.org/I130769515"],"apc_list":null,"apc_paid":null,"fwci":2.6836,"has_fulltext":false,"cited_by_count":31,"citation_normalized_percentile":{"value":0.92513966,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"F3J","last_page":"1"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10731","display_name":"Educational Games and Gamification","score":0.9973000288009644,"subfield":{"id":"https://openalex.org/subfields/3204","display_name":"Developmental and Educational Psychology"},"field":{"id":"https://openalex.org/fields/32","display_name":"Psychology"},"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.9959999918937683,"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/computational-thinking","display_name":"Computational thinking","score":0.879765510559082},{"id":"https://openalex.org/keywords/stipulation","display_name":"Stipulation","score":0.6640737056732178},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6429687738418579},{"id":"https://openalex.org/keywords/mathematics-education","display_name":"Mathematics education","score":0.6348236799240112},{"id":"https://openalex.org/keywords/meaning","display_name":"Meaning (existential)","score":0.5534614324569702},{"id":"https://openalex.org/keywords/recall","display_name":"Recall","score":0.4368320107460022},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.33045727014541626},{"id":"https://openalex.org/keywords/psychology","display_name":"Psychology","score":0.21814975142478943},{"id":"https://openalex.org/keywords/cognitive-psychology","display_name":"Cognitive psychology","score":0.14681264758110046}],"concepts":[{"id":"https://openalex.org/C2780368719","wikidata":"https://www.wikidata.org/wiki/Q5157342","display_name":"Computational thinking","level":2,"score":0.879765510559082},{"id":"https://openalex.org/C2781451568","wikidata":"https://www.wikidata.org/wiki/Q16965475","display_name":"Stipulation","level":2,"score":0.6640737056732178},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6429687738418579},{"id":"https://openalex.org/C145420912","wikidata":"https://www.wikidata.org/wiki/Q853077","display_name":"Mathematics education","level":1,"score":0.6348236799240112},{"id":"https://openalex.org/C2780876879","wikidata":"https://www.wikidata.org/wiki/Q3054749","display_name":"Meaning (existential)","level":2,"score":0.5534614324569702},{"id":"https://openalex.org/C100660578","wikidata":"https://www.wikidata.org/wiki/Q18733","display_name":"Recall","level":2,"score":0.4368320107460022},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.33045727014541626},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.21814975142478943},{"id":"https://openalex.org/C180747234","wikidata":"https://www.wikidata.org/wiki/Q23373","display_name":"Cognitive psychology","level":1,"score":0.14681264758110046},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C542102704","wikidata":"https://www.wikidata.org/wiki/Q183257","display_name":"Psychotherapist","level":1,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/fie.2011.6142980","is_oa":false,"landing_page_url":"https://doi.org/10.1109/fie.2011.6142980","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2011 Frontiers in Education Conference (FIE)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4","score":0.7699999809265137}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W1500151553","https://openalex.org/W1966585167","https://openalex.org/W1990060255","https://openalex.org/W2101338329","https://openalex.org/W2106357912","https://openalex.org/W2116817443","https://openalex.org/W2220638545","https://openalex.org/W2339183141","https://openalex.org/W4237403970","https://openalex.org/W4246293799"],"related_works":["https://openalex.org/W2387124463","https://openalex.org/W4386886339","https://openalex.org/W3166876819","https://openalex.org/W1541295543","https://openalex.org/W2360854227","https://openalex.org/W2356608832","https://openalex.org/W2383267283","https://openalex.org/W2366856596","https://openalex.org/W2347393629","https://openalex.org/W2558370951"],"abstract_inverted_index":{"Recently,":[0],"higher":[1],"education":[2,173],"has":[3],"seen":[4],"an":[5,76],"increasing":[6],"emphasis":[7],"on":[8],"the":[9,62,107,129,136,155,172],"prominent":[10],"role":[11],"of":[12,109,154,174],"computational":[13,73,156,175,185],"thinking":[14,19,48,74,176,186],"in":[15,30,43,75,88,141,158,167,183,187],"all":[16,39],"disciplines.":[17,40],"Computational":[18],"is":[20,49],"advocated":[21],"as":[22],"not":[23,54],"only":[24],"a":[25,35],"fundamental":[26],"skill":[27],"or":[28,123],"concept":[29],"computer":[31],"science":[32,45],"but":[33,112],"also":[34],"core":[36],"competency":[37],"for":[38],"Teaching":[41],"students":[42,52,69,104,180],"non-computer":[44],"majors":[46],"computing":[47],"challenging":[50],"because":[51],"do":[53],"have":[55,115],"experts'":[56],"mental":[57],"models.":[58],"This":[59],"study":[60],"investigates":[61],"knowledge":[63],"gap":[64],"that":[65,103],"non-computing":[66],"major":[67],"college":[68],"(n=126)":[70],"possess":[71],"about":[72],"introductory":[77],"MS":[78],"Excel":[79],"course":[80],"by":[81],"measuring":[82],"their":[83],"performance":[84],"using":[85,100,117,147,184],"spreadsheet":[86,148],"functions":[87,111],"three":[89],"categories:":[90],"recall,":[91],"application,":[92],"and":[93,120,150,165,177,189],"problem":[94,190],"solving.":[95,191],"The":[96],"empirical":[97],"result,":[98],"analyzed":[99],"ANOVA,":[101],"shows":[102],"can":[105],"recall":[106],"meaning":[108],"those":[110],"seem":[113],"to":[114,144],"trouble":[116],"them":[118],"correctly":[119],"precisely":[121],"(cued":[122],"uncued).":[124],"Students'":[125],"test":[126],"results":[127],"suggest":[128],"following":[130],"issues:":[131],"(1)":[132],"problems":[133,143,163],"with":[134],"understanding":[135],"data":[137],"type,":[138],"(2)":[139],"failure":[140],"translating":[142],"productive":[145],"representations":[146,157],"functions,":[149],"(3)":[151],"inadequate":[152],"stipulation":[153],"precise":[159],"forms.":[160],"Addressing":[161],"these":[162],"early":[164],"explicitly":[166],"future":[168],"classes":[169],"could":[170],"improve":[171],"alleviate":[178],"difficulties":[179],"may":[181],"experience":[182],"learning":[188]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}