{"id":"https://openalex.org/W1994177203","doi":"https://doi.org/10.1016/s0953-5438(00)00048-5","title":"Comparing two spreadsheet calculation paradigms: an empirical study with novice users","display_name":"Comparing two spreadsheet calculation paradigms: an empirical study with novice users","publication_year":2001,"publication_date":"2001-04-01","ids":{"openalex":"https://openalex.org/W1994177203","doi":"https://doi.org/10.1016/s0953-5438(00)00048-5","mag":"1994177203"},"language":"en","primary_location":{"id":"doi:10.1016/s0953-5438(00)00048-5","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0953-5438(00)00048-5","pdf_url":null,"source":{"id":"https://openalex.org/S23117883","display_name":"Interacting with Computers","issn_l":"0953-5438","issn":["0953-5438","1873-7951"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310311648","host_organization_name":"Oxford University Press","host_organization_lineage":["https://openalex.org/P4310311648","https://openalex.org/P4310311647"],"host_organization_lineage_names":["Oxford University Press","University of Oxford"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Interacting with Computers","raw_type":"journal-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/A5016084249","display_name":"Markku Tukiainen","orcid":"https://orcid.org/0000-0002-8630-5248"},"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":"M Tukiainen","raw_affiliation_strings":["University of Joensuu, Department of Computer Science, P.O. Box 111, FIN-80101 Joensuu, Finland","University of Joensuu, Department of Computer Science, P.O Box 111, FIN-80101 Joensuu, Finland#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Joensuu, Department of Computer Science, P.O. Box 111, FIN-80101 Joensuu, Finland","institution_ids":[]},{"raw_affiliation_string":"University of Joensuu, Department of Computer Science, P.O Box 111, FIN-80101 Joensuu, Finland#TAB#","institution_ids":["https://openalex.org/I175532246"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5016084249"],"corresponding_institution_ids":["https://openalex.org/I175532246"],"apc_list":{"value":2635,"currency":"GBP","value_usd":3232},"apc_paid":null,"fwci":0.5801,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.77122877,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"13","issue":"4","first_page":"427","last_page":"446"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":1.0,"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":1.0,"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.9592999815940857,"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.9585999846458435,"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/computer-science","display_name":"Computer science","score":0.8343533873558044},{"id":"https://openalex.org/keywords/abstraction","display_name":"Abstraction","score":0.6123220920562744},{"id":"https://openalex.org/keywords/modularity","display_name":"Modularity (biology)","score":0.6099843978881836},{"id":"https://openalex.org/keywords/empirical-research","display_name":"Empirical research","score":0.5678766965866089},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.4899072051048279},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3508007526397705},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.3438418209552765},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.3277128338813782},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3243825435638428},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.11426055431365967},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.0718386173248291}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8343533873558044},{"id":"https://openalex.org/C124304363","wikidata":"https://www.wikidata.org/wiki/Q673661","display_name":"Abstraction","level":2,"score":0.6123220920562744},{"id":"https://openalex.org/C2779478453","wikidata":"https://www.wikidata.org/wiki/Q6889748","display_name":"Modularity (biology)","level":2,"score":0.6099843978881836},{"id":"https://openalex.org/C120936955","wikidata":"https://www.wikidata.org/wiki/Q2155640","display_name":"Empirical research","level":2,"score":0.5678766965866089},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.4899072051048279},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3508007526397705},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3438418209552765},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3277128338813782},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3243825435638428},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.11426055431365967},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0718386173248291},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C54355233","wikidata":"https://www.wikidata.org/wiki/Q7162","display_name":"Genetics","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/s0953-5438(00)00048-5","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0953-5438(00)00048-5","pdf_url":null,"source":{"id":"https://openalex.org/S23117883","display_name":"Interacting with Computers","issn_l":"0953-5438","issn":["0953-5438","1873-7951"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310311648","host_organization_name":"Oxford University Press","host_organization_lineage":["https://openalex.org/P4310311648","https://openalex.org/P4310311647"],"host_organization_lineage_names":["Oxford University Press","University of Oxford"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Interacting with Computers","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6899999976158142,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":34,"referenced_works":["https://openalex.org/W43120215","https://openalex.org/W233411397","https://openalex.org/W590961618","https://openalex.org/W617431016","https://openalex.org/W1505042564","https://openalex.org/W1522006088","https://openalex.org/W1541866506","https://openalex.org/W1783449014","https://openalex.org/W1969045719","https://openalex.org/W1986116291","https://openalex.org/W1992962448","https://openalex.org/W2014132843","https://openalex.org/W2017140369","https://openalex.org/W2029413239","https://openalex.org/W2030893860","https://openalex.org/W2041170271","https://openalex.org/W2042031818","https://openalex.org/W2044132121","https://openalex.org/W2072707233","https://openalex.org/W2074257305","https://openalex.org/W2074731714","https://openalex.org/W2080546811","https://openalex.org/W2093987194","https://openalex.org/W2095148351","https://openalex.org/W2120704737","https://openalex.org/W2133247167","https://openalex.org/W2139850700","https://openalex.org/W3124066374","https://openalex.org/W4231799929","https://openalex.org/W6603053221","https://openalex.org/W6609105917","https://openalex.org/W6630107938","https://openalex.org/W6638079754","https://openalex.org/W6821841224"],"related_works":["https://openalex.org/W4230687177","https://openalex.org/W1968829728","https://openalex.org/W2349859869","https://openalex.org/W2051365847","https://openalex.org/W2367249529","https://openalex.org/W3120118008","https://openalex.org/W2088885441","https://openalex.org/W4214765864","https://openalex.org/W1943342825","https://openalex.org/W2042226922"],"abstract_inverted_index":{"Empirical":[0],"studies":[1],"of":[2,35,41,50,68],"spreadsheet":[3,36,53,80,88,107,113],"programming":[4],"have":[5],"commonly":[6],"shown":[7],"high":[8],"overall":[9],"error":[10,126],"rates":[11],"but":[12],"only":[13],"little":[14],"attention":[15],"has":[16,63],"been":[17],"paid":[18],"to":[19,52,57],"reasons":[20],"for":[21,28],"these":[22,48],"errors.":[23],"One":[24],"often":[25],"mentioned":[26],"cause":[27],"errors":[29,69],"is":[30,77],"the":[31,39,60,78,105,111,120],"low":[32],"conceptual":[33,61,73],"level":[34,62,74],"systems,":[37],"e.g.":[38],"lack":[40],"abstraction":[42],"and":[43,87,110],"modularity":[44],"mechanisms.":[45],"By":[46],"offering":[47],"kinds":[49],"mechanisms":[51],"users,":[54,103],"we":[55,96],"wanted":[56],"study":[58,100],"whether":[59],"an":[64,98],"effect":[65],"on":[66],"types":[67],"produced.":[70],"The":[71,116],"higher":[72],"paradigm":[75,109],"offered":[76],"structured":[79,112],"calculation":[81,108,114],"paradigm,":[82],"which":[83],"utilizes":[84],"goals,":[85],"plans":[86],"data":[89],"structures":[90],"in":[91],"computation.":[92],"In":[93],"this":[94],"paper,":[95],"present":[97],"empirical":[99],"with":[101],"novice":[102],"comparing":[104],"traditional":[106],"paradigm.":[115],"results":[117],"show":[118],"that":[119],"two":[121],"different":[122,125],"paradigms":[123],"produce":[124],"behaviors.":[127]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2015,"cited_by_count":1}],"updated_date":"2026-02-25T21:11:00.739837","created_date":"2025-10-10T00:00:00"}
