{"id":"https://openalex.org/W2081379656","doi":"https://doi.org/10.1109/vlhcc.2013.6645237","title":"An empirical study of spreadsheet authors' mental models in explaining and debugging tasks","display_name":"An empirical study of spreadsheet authors' mental models in explaining and debugging tasks","publication_year":2013,"publication_date":"2013-09-01","ids":{"openalex":"https://openalex.org/W2081379656","doi":"https://doi.org/10.1109/vlhcc.2013.6645237","mag":"2081379656"},"language":"en","primary_location":{"id":"doi:10.1109/vlhcc.2013.6645237","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2013.6645237","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2013 IEEE Symposium on Visual Languages and Human Centric Computing","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/A5022792110","display_name":"Bennett Kankuzi","orcid":null},"institutions":[{"id":"https://openalex.org/I175532246","display_name":"University of Eastern Finland","ror":"https://ror.org/00cyydd11","country_code":"FI","type":"education","lineage":["https://openalex.org/I175532246"]}],"countries":["FI"],"is_corresponding":true,"raw_author_name":"Bennett Kankuzi","raw_affiliation_strings":["School of Computing, University of Eastern Finland, Joensuu, Finland","Sch. of Comput., Univ. of Eastern Finland, Joensuu, Finland#TAB#"],"affiliations":[{"raw_affiliation_string":"School of Computing, University of Eastern Finland, Joensuu, Finland","institution_ids":["https://openalex.org/I175532246"]},{"raw_affiliation_string":"Sch. of Comput., Univ. of Eastern Finland, Joensuu, Finland#TAB#","institution_ids":["https://openalex.org/I175532246"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5036923336","display_name":"Jorma Sajaniemi","orcid":null},"institutions":[{"id":"https://openalex.org/I175532246","display_name":"University of Eastern Finland","ror":"https://ror.org/00cyydd11","country_code":"FI","type":"education","lineage":["https://openalex.org/I175532246"]}],"countries":["FI"],"is_corresponding":false,"raw_author_name":"Jorma Sajaniemi","raw_affiliation_strings":["School of Computing, University of Eastern Finland, Joensuu, Finland","Sch. of Comput., Univ. of Eastern Finland, Joensuu, Finland#TAB#"],"affiliations":[{"raw_affiliation_string":"School of Computing, University of Eastern Finland, Joensuu, Finland","institution_ids":["https://openalex.org/I175532246"]},{"raw_affiliation_string":"Sch. of Comput., Univ. of Eastern Finland, Joensuu, Finland#TAB#","institution_ids":["https://openalex.org/I175532246"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5022792110"],"corresponding_institution_ids":["https://openalex.org/I175532246"],"apc_list":null,"apc_paid":null,"fwci":3.8884,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.93452594,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"15","last_page":"18"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9998999834060669,"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"}},"topics":[{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9998999834060669,"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"}},{"id":"https://openalex.org/T11875","display_name":"Statistics Education and Methodologies","score":0.9828000068664551,"subfield":{"id":"https://openalex.org/subfields/2613","display_name":"Statistics and Probability"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10731","display_name":"Educational Games and Gamification","score":0.9642999768257141,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/debugging","display_name":"Debugging","score":0.9632068872451782},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8053123950958252},{"id":"https://openalex.org/keywords/domain","display_name":"Domain (mathematical analysis)","score":0.6998090744018555},{"id":"https://openalex.org/keywords/mental-model","display_name":"Mental model","score":0.6383554339408875},{"id":"https://openalex.org/keywords/think-aloud-protocol","display_name":"Think aloud protocol","score":0.6275112628936768},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5060529112815857},{"id":"https://openalex.org/keywords/empirical-research","display_name":"Empirical research","score":0.5050082802772522},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.4102596640586853},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.38058650493621826},{"id":"https://openalex.org/keywords/usability","display_name":"Usability","score":0.2084910273551941},{"id":"https://openalex.org/keywords/psychology","display_name":"Psychology","score":0.15459537506103516},{"id":"https://openalex.org/keywords/cognitive-science","display_name":"Cognitive science","score":0.14056789875030518},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.07842585444450378},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.07284024357795715}],"concepts":[{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.9632068872451782},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8053123950958252},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.6998090744018555},{"id":"https://openalex.org/C2982912361","wikidata":"https://www.wikidata.org/wiki/Q1851867","display_name":"Mental model","level":2,"score":0.6383554339408875},{"id":"https://openalex.org/C78821406","wikidata":"https://www.wikidata.org/wiki/Q391810","display_name":"Think aloud protocol","level":3,"score":0.6275112628936768},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5060529112815857},{"id":"https://openalex.org/C120936955","wikidata":"https://www.wikidata.org/wiki/Q2155640","display_name":"Empirical research","level":2,"score":0.5050082802772522},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.4102596640586853},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.38058650493621826},{"id":"https://openalex.org/C170130773","wikidata":"https://www.wikidata.org/wiki/Q216378","display_name":"Usability","level":2,"score":0.2084910273551941},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.15459537506103516},{"id":"https://openalex.org/C188147891","wikidata":"https://www.wikidata.org/wiki/Q147638","display_name":"Cognitive science","level":1,"score":0.14056789875030518},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.07842585444450378},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.07284024357795715},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/vlhcc.2013.6645237","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2013.6645237","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2013 IEEE Symposium on Visual Languages and Human Centric Computing","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Partnerships for the goals","score":0.41999998688697815,"id":"https://metadata.un.org/sdg/17"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W77497644","https://openalex.org/W587033199","https://openalex.org/W1508879959","https://openalex.org/W1976624123","https://openalex.org/W2022557060","https://openalex.org/W2041170271","https://openalex.org/W2093987194","https://openalex.org/W2100650984","https://openalex.org/W2112338634","https://openalex.org/W2121305681","https://openalex.org/W2154671002","https://openalex.org/W2162363818","https://openalex.org/W2899108003","https://openalex.org/W4205646467","https://openalex.org/W6755439393"],"related_works":["https://openalex.org/W4321442002","https://openalex.org/W2015265939","https://openalex.org/W2284072287","https://openalex.org/W2611067230","https://openalex.org/W2155788121","https://openalex.org/W4235469518","https://openalex.org/W2081379656","https://openalex.org/W4234091924","https://openalex.org/W2035506785","https://openalex.org/W1985289793"],"abstract_inverted_index":{"In":[0],"this":[1],"paper,":[2],"we":[3],"report":[4],"on":[5,114],"an":[6,106],"empirical":[7],"study":[8,110],"exploring":[9],"the":[10,48,59,72,115],"nature":[11,60],"of":[12,15,35,61,80,131],"mental":[13,63,129],"models":[14,64,130],"spreadsheet":[16,119,127],"authors":[17,73],"when":[18],"they":[19,88,99],"are":[20],"explaining":[21],"and":[22,39,43,55,82,95,121],"debugging":[23,122],"their":[24,36,75],"own":[25,37],"spreadsheets.":[26,50,132],"Study":[27],"participants":[28],"were":[29,53],"first":[30],"asked":[31],"to":[32,41,57,104,126],"explain":[33,74],"one":[34],"spreadsheets,":[38],"then":[40],"find":[42],"fix":[44,105],"seeded":[45],"errors":[46],"in":[47,65,78,86],"same":[49],"Talk-aloud":[51],"protocols":[52],"collected":[54],"analyzed":[56],"reveal":[58],"participants'":[62],"these":[66],"activities.":[67],"The":[68],"findings":[69,111],"indicate":[70],"that":[71,124],"spreadsheets":[76],"mainly":[77,100],"terms":[79],"real-world":[81],"problem":[83,92],"domain":[84,93],"concepts;":[85],"debugging,":[87],"constantly":[89],"switch":[90],"between":[91],"concepts":[94,103],"spreadsheet-specific":[96,102],"concepts,":[97],"although":[98],"use":[101],"identified":[107],"error.":[108],"These":[109],"provide":[112],"insights":[113],"need":[116],"for":[117],"developing":[118],"authoring":[120],"tools":[123],"correspond":[125],"authors'":[128]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}