{"id":"https://openalex.org/W2035506785","doi":"https://doi.org/10.1109/vlhcc.2014.6883040","title":"Visualizing the problem domain for spreadsheet users: A mental model perspective","display_name":"Visualizing the problem domain for spreadsheet users: A mental model perspective","publication_year":2014,"publication_date":"2014-07-01","ids":{"openalex":"https://openalex.org/W2035506785","doi":"https://doi.org/10.1109/vlhcc.2014.6883040","mag":"2035506785"},"language":"en","primary_location":{"id":"doi:10.1109/vlhcc.2014.6883040","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2014.6883040","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2014 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","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":["University of Eastern Finland, School of Computing, Joensuu, Finland","Sch. of Comput., Univ. of Eastern Finland, Joensuu, Finland#TAB#"],"affiliations":[{"raw_affiliation_string":"University of Eastern Finland, School of Computing, 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":["University of Eastern Finland, School of Computing, Joensuu, Finland","Sch. of Comput., Univ. of Eastern Finland, Joensuu, Finland#TAB#"],"affiliations":[{"raw_affiliation_string":"University of Eastern Finland, School of Computing, 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":0.8735,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.76140718,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"157","last_page":"160"},"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.9987999796867371,"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.9987999796867371,"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/T10731","display_name":"Educational Games and Gamification","score":0.9753000140190125,"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/T11810","display_name":"Complex Systems and Decision Making","score":0.9613000154495239,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7963520288467407},{"id":"https://openalex.org/keywords/domain","display_name":"Domain (mathematical analysis)","score":0.7802999019622803},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.7339270114898682},{"id":"https://openalex.org/keywords/domain-model","display_name":"Domain model","score":0.6465863585472107},{"id":"https://openalex.org/keywords/mental-model","display_name":"Mental model","score":0.6421408653259277},{"id":"https://openalex.org/keywords/perspective","display_name":"Perspective (graphical)","score":0.6165435910224915},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.41234874725341797},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.3794006109237671},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.33029231429100037},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.31990042328834534},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.2948026657104492},{"id":"https://openalex.org/keywords/domain-knowledge","display_name":"Domain knowledge","score":0.19939857721328735},{"id":"https://openalex.org/keywords/cognitive-science","display_name":"Cognitive science","score":0.08584561944007874}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7963520288467407},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.7802999019622803},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.7339270114898682},{"id":"https://openalex.org/C92548554","wikidata":"https://www.wikidata.org/wiki/Q2262868","display_name":"Domain model","level":3,"score":0.6465863585472107},{"id":"https://openalex.org/C2982912361","wikidata":"https://www.wikidata.org/wiki/Q1851867","display_name":"Mental model","level":2,"score":0.6421408653259277},{"id":"https://openalex.org/C12713177","wikidata":"https://www.wikidata.org/wiki/Q1900281","display_name":"Perspective (graphical)","level":2,"score":0.6165435910224915},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.41234874725341797},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3794006109237671},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.33029231429100037},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.31990042328834534},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2948026657104492},{"id":"https://openalex.org/C207685749","wikidata":"https://www.wikidata.org/wiki/Q2088941","display_name":"Domain knowledge","level":2,"score":0.19939857721328735},{"id":"https://openalex.org/C188147891","wikidata":"https://www.wikidata.org/wiki/Q147638","display_name":"Cognitive science","level":1,"score":0.08584561944007874},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/vlhcc.2014.6883040","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2014.6883040","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2014 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/10","display_name":"Reduced inequalities","score":0.4000000059604645}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W1524044080","https://openalex.org/W1969600276","https://openalex.org/W2081379656","https://openalex.org/W2095148351","https://openalex.org/W2100650984","https://openalex.org/W2112338634","https://openalex.org/W2118615399","https://openalex.org/W2119896264","https://openalex.org/W2120704737","https://openalex.org/W2121305681","https://openalex.org/W2135473121","https://openalex.org/W2154671002","https://openalex.org/W2327041912","https://openalex.org/W2342091124","https://openalex.org/W4230945824","https://openalex.org/W4239720002","https://openalex.org/W6631507706"],"related_works":["https://openalex.org/W4232844628","https://openalex.org/W2374471852","https://openalex.org/W171356793","https://openalex.org/W1587887330","https://openalex.org/W2166877816","https://openalex.org/W60702408","https://openalex.org/W2479071323","https://openalex.org/W1760744708","https://openalex.org/W2349037640","https://openalex.org/W2035506785"],"abstract_inverted_index":{"Earlier":[0],"research":[1],"on":[2],"spreadsheet":[3,33,57,72,80,91,139],"authors'":[4],"mental":[5,27,129],"models":[6,28],"has":[7],"shown":[8],"that":[9],"people":[10],"possess":[11],"several":[12],"types":[13],"of":[14,63,126],"information":[15],"about":[16],"spreadsheets.":[17,119],"Especially,":[18],"when":[19,38],"explaining":[20],"a":[21,78],"spreadsheet,":[22],"the":[23,32,52,56,64,112,121,124,127,135,138,142],"real-world":[24],"and":[25,31,40,49,55,70,83,97,110,131,141],"domain":[26,53,68,95,128,143],"are":[29],"prominent":[30],"model":[34,54,73,130,140],"is":[35],"suppressed,":[36],"but":[37],"locating":[39],"fixing":[41],"an":[42],"error,":[43],"one":[44],"must":[45],"constantly":[46],"switch":[47],"back":[48],"forth":[50],"between":[51,66,137],"model,":[58],"which":[59],"requires":[60],"frequent":[61],"use":[62,125],"mapping":[65,136],"problem":[67,94],"concepts":[69],"their":[71],"counterparts.":[74],"This":[75],"paper":[76],"introduces":[77],"new":[79],"visualization":[81],"tool":[82,88,102,122],"its":[84],"empirical":[85],"evaluation.":[86],"The":[87,101],"translates":[89],"traditional":[90],"formulas":[92],"into":[93],"narratives":[96],"highlights":[98],"referenced":[99],"cells.":[100],"was":[103],"found":[104],"to":[105,108,114,133],"be":[106],"easy":[107],"learn":[109],"helped":[111],"participants":[113],"locate":[115],"more":[116],"errors":[117],"in":[118],"Furthermore,":[120],"increased":[123],"appeared":[132],"improve":[134],"model.":[144]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}