PapersFlow Research Brief
Spreadsheets and End-User Computing
Research Guide
What is Spreadsheets and End-User Computing?
Spreadsheets and End-User Computing is the field studying end-user software engineering, meta-design, trigger-action programming, spreadsheet errors, debugging techniques, and applications in smart homes and IoT, alongside socio-technical aspects of software development.
This field encompasses 15,978 works focused on end-user software engineering and spreadsheet error mitigation. Research addresses debugging methods and gender factors in programming. It examines trigger-action programming for IoT and smart home systems.
Topic Hierarchy
Research Sub-Topics
Spreadsheet Error Detection
Researchers develop automated tools and visualization techniques to identify formula errors, data inconsistencies, and logical faults in spreadsheets. Studies analyze error taxonomies, prevalence in real-world usage, and user correction behaviors.
End-User Software Engineering
This area investigates programming support for non-professional developers using spreadsheets, macros, and visual languages. Research covers end-user debugging practices, tool design, and software evolution patterns.
Trigger-Action Programming
Studies examine rule-based automation in IFTTT, Zapier, and smart home platforms focusing on usability, expressiveness limits, and error-proneness. Research develops formal verification methods for trigger-action rules.
Meta-Design for End-Users
Researchers explore frameworks enabling users to evolve software systems post-deployment through customizable components. Applications span educational tools, collaborative platforms, and adaptive interfaces.
Gender Differences in End-User Programming
Analyses investigate participation gaps, confidence levels, and learning trajectories between genders in spreadsheet and visual programming contexts. Studies propose interventions to promote inclusivity.
Why It Matters
End-user computing enables non-experts to build and maintain software, reducing reliance on professional developers in domains like operations research and financial reporting. "Factorial Sampling Plans for Preliminary Computational Experiments" by Max D. Morris (1991) provides sampling methods for computational models implemented in spreadsheets, cited 2644 times for efficient input-output analysis in preliminary experiments. "Lowering the barriers to programming" by Caitlin Kelleher and Randy Pausch (2005), with 875 citations, details languages and environments that make programming accessible to novices, supporting end-user development in education and business. Studies like "An Exploratory Study of How Developers Seek, Relate, and Collect Relevant Information during Software Maintenance Tasks" by Andrew J. Ko et al. (2006) reveal information-seeking behaviors during debugging, informing tools that aid spreadsheet users in error correction.
Reading Guide
Where to Start
"Lowering the barriers to programming" by Caitlin Kelleher and Randy Pausch (2005) first, as it provides a foundational taxonomy of accessible programming environments directly relevant to end-user computing novices.
Key Papers Explained
"Factorial Sampling Plans for Preliminary Computational Experiments" by Max D. Morris (1991) establishes sampling for spreadsheet-based computational models, which "Operations Research: Applications and Algorithms" by Wayne L. Winston (1988) extends to linear algebra and model-building processes. "Lowering the barriers to programming" by Caitlin Kelleher and Randy Pausch (2005) builds on these by addressing novice accessibility, while "An Exploratory Study of How Developers Seek, Relate, and Collect Relevant Information during Software Maintenance Tasks" by Andrew J. Ko et al. (2006) applies insights to debugging unfamiliar code in end-user contexts. "A small matter of programming: perspectives on end user computing" (1994) synthesizes empirical perspectives on end-user challenges across these areas.
Paper Timeline
Most-cited paper highlighted in red. Papers ordered chronologically.
Advanced Directions
Research centers on persistent challenges in spreadsheet errors and trigger-action programming for IoT, as described in the 15,978 works. No recent preprints or news in the last 6-12 months suggest focus remains on foundational debugging and socio-technical analyses from top papers like Ko et al. (2006).
Papers at a Glance
| # | Paper | Year | Venue | Citations | Open Access |
|---|---|---|---|---|---|
| 1 | Factorial Sampling Plans for Preliminary Computational Experim... | 1991 | Technometrics | 2.6K | ✕ |
| 2 | Operations Research: Applications and Algorithms | 1988 | Technometrics | 1.7K | ✕ |
| 3 | Financial Reporting: An Accounting Revolution. | 1982 | The Journal of Finance | 998 | ✕ |
| 4 | Lowering the barriers to programming | 2005 | ACM Computing Surveys | 875 | ✕ |
| 5 | Simulation: The Practice of Model Development and Use | 2014 | — | 868 | ✓ |
| 6 | Wiley encyclopedia of operations research and management science | 2011 | Choice Reviews Online | 784 | ✕ |
| 7 | Principles of inventory and materials management | 1982 | — | 703 | ✕ |
| 8 | An Exploratory Study of How Developers Seek, Relate, and Colle... | 2006 | IEEE Transactions on S... | 663 | ✕ |
| 9 | Why Johnny Can’t Prompt: How Non-AI Experts Try (and Fail) to ... | 2023 | — | 661 | ✓ |
| 10 | A small matter of programming: perspectives on end user computing | 1994 | Choice Reviews Online | 606 | ✕ |
Frequently Asked Questions
What are common challenges in end-user spreadsheet programming?
End users face difficulties commanding programming power due to errors and limited debugging skills. "A small matter of programming: perspectives on end user computing" (1994) explores problems in end-user-driven application development based on empirical research. Solutions involve meta-design and trigger-action programming to enhance computational access.
How do researchers address spreadsheet errors?
Debugging techniques target understanding unfamiliar code during maintenance tasks. "An Exploratory Study of How Developers Seek, Relate, and Collect Relevant Information during Software Maintenance Tasks" by Andrew J. Ko et al. (2006) observed developers working on unfamiliar programs for debugging. Findings show time spent on information seeking, applicable to spreadsheet error resolution.
What methods lower programming barriers for end users?
Taxonomies of languages and environments make programming accessible to novices since the 1960s. "Lowering the barriers to programming" by Caitlin Kelleher and Randy Pausch (2005) presents such a taxonomy for novice programmers. These approaches support end-user computing in spreadsheets and beyond.
How is end-user computing applied in computational modeling?
Computational models represent systems via mathematical functions implemented in programs like spreadsheets. "Factorial Sampling Plans for Preliminary Computational Experiments" by Max D. Morris (1991) introduces sampling plans for efficient model evaluation. This aids end users in operations research and simulation.
What role does prompting play in modern end-user computing?
Non-AI experts struggle to design effective prompts for large language models in instruction-taking tasks. "Why Johnny Can’t Prompt: How Non-AI Experts Try (and Fail) to Design LLM Prompts" by J.D. Zamfirescu-Pereira et al. (2023) examines prompting as a design technique for natural language interactions. Results highlight failures and needs for better end-user tools.
What is the current state of research in this field?
The field includes 15,978 works on end-user software engineering, spreadsheet errors, and IoT applications. No recent preprints or news coverage in the last 12 months indicates steady maturation. Emphasis persists on socio-technical systems and debugging.
Open Research Questions
- ? How can automated tools detect and correct spreadsheet errors without professional programming knowledge?
- ? What socio-technical factors influence gender participation in end-user programming?
- ? How do trigger-action programming paradigms scale to complex IoT and smart home deployments?
- ? What information-seeking strategies optimize debugging in end-user spreadsheet maintenance?
- ? How can meta-design principles empower end users to evolve their own computational applications?
Recent Trends
The field holds at 15,978 works with no specified 5-year growth rate.
Recent paper "Why Johnny Can’t Prompt: How Non-AI Experts Try (and Fail) to Design LLM Prompts" by J.D. Zamfirescu-Pereira et al. with 661 citations integrates prompting challenges into end-user computing.
2023No preprints or news in the last 12 months indicates stable emphasis on core topics like spreadsheet errors and debugging.
Research Spreadsheets and End-User Computing with AI
PapersFlow provides specialized AI tools for Computer Science researchers. Here are the most relevant for this topic:
AI Literature Review
Automate paper discovery and synthesis across 474M+ papers
Code & Data Discovery
Find datasets, code repositories, and computational tools
Deep Research Reports
Multi-source evidence synthesis with counter-evidence
AI Academic Writing
Write research papers with AI assistance and LaTeX support
See how researchers in Computer Science & AI use PapersFlow
Field-specific workflows, example queries, and use cases.
Start Researching Spreadsheets and End-User Computing with AI
Search 474M+ papers, run AI-powered literature reviews, and write with integrated citations — all in one workspace.
See how PapersFlow works for Computer Science researchers