ArticlePDF Available

Abstract and Figures

Just as good grammar, punctuation, style, and content organization are important to well-written documents, basic fundamentals of spreadsheet design are essential to clear communication. In fact, the very principles of good writing should be integrated into spreadsheet workpaper design and organization. The unique contributions of this paper are an integration of a review of the literature on spreadsheet design, with the results of a convenience survey of CPAs, and a "Spreadsheet Design Checklist" for pedagogy. The checklist is intended as a reference for use until the student or professional becomes proficient in basic spreadsheet design and organization and the checklist becomes just as "second nature" as creating well-written memoranda.
Content may be subject to copyright.
A preview of the PDF is not available
... There are numerous studies (see for example, Leon et al, 2012;Barnes et al, 2009;Ferreira & Visser, 2012 ) outlining detailed controls addressing various stages of the spreadsheet lifecycle, and the provision of controls built into specialised applications e.g. banking and investment, specific products/tools e.g. ...
Article
Full-text available
The key to maximising the effectiveness of spreadsheet models for critical decision making is appropriate risk governance. Those responsible for governance need, at a macro level, to identify the specific spreadsheet risks, determine the reasons for such exposures and establish where and when risk exposures occur from point of initiation to usage and storage. It is essential to identify which parties could create the exposure taking cognisance of the entire supply chain of the organisation. If management’s risk strategy is to control the risks then the question reverts to how these risks can be prevented and/or detected and corrected? This paper attempts to address each of these critical issues and to offer guidance in the governance of spreadsheet risk. The paper identifies the the risk exposures and sets out the responsibilities of directors in relation to spreadsheets and the spreadsheet cycle. Spreadsheet risk exposure can be managed in terms of setting the control environment, undertaking risk assessment, providing the requisite information and communicating with internal and external parties as well as implementing spreadsheet lifecycle application controls and monitoring activities.
Article
Given that the usage and complexity of spreadsheets in the accounting profession are expected to increase, it is more important than ever to ensure that accounting graduates are aware of the dangers of spreadsheet errors and are equipped with design skills to minimize those errors. Although spreadsheet mechanics are prevalent in accounting curricula, less attention has been given to design considerations that can reduce the incidence of spreadsheet errors. The extant literature provides evidence of the most common types of spreadsheet errors and explanations as to why they occur. Using the work of Panko and others, this paper outlines a three-step approach for introducing spreadsheet design practices to novice spreadsheet developers. To facilitate design instruction, this paper provides a summary of foundational readings related to spreadsheet errors as well as specific teaching strategies for addressing the most common spreadsheet errors identified in the literature.
Conference Paper
As documents become disseminated widely, establishing the context for interpretation becomes difficult. We argue that high-impact documents require embedded user assistance facilities for their readers (not authors) to cope with their semantic complexity. We suggest to illustrate such documents and their players with a semiformal background ontology, an interpretation mapping between domain concepts and semantic objects, and to enable with this setup semantic interaction. We showcase the feasibility and interactional potential of user assistance for documents based on interactional semantic technology with an exemplary implementation for a high-impact Excel spreadsheet.
Article
Full-text available
Numerous surveys have established the importance of communication skills for entry- level accountants, but none has identified the specific communication skills needed. To help us identify what skills to emphasize in an accounting curriculum, members of the Institute of Management Accounting (IMA) and the American Institute of Certified Public Accountants (AICPA) were surveyed to determine (1) the relative importance of 32 business communication skills cited in business communication literature and (2) the level of satisfaction with college preparation in those skills. Based on mean ratings on two five-point scales, English skills (pertaining to spelling, grammar, and punctuation) were significantly more important than oral and writing skills. Nine communication skills were identified as needing emphasis in an accounting curriculum. In addition, the ratings varied significantly by respondent organization (AICPA versus IMA), office size, and business activity (assurance/tax, finance, other). Suggestions on how to use these results to improve an accounting curriculum are provided.1
Article
This papers describes an exploratory study into the early phase of getting to know end-user software during which users make use of a variety of information resources, including the user interface/program itself, manuals, on-line help, examples provided in the manuals and other sources. In particular, how do novices make use of the worked-out examples often provided in manuals and during training? Building on earlier research on the self-explanation effect, thinking aloud data from 10 participants were analysed to see how examples were studied and how they were used during problem solving. Important effects of self-explaining comparable to findings in other domains were found in this study. For instance, those participants who self-explain with the goal to discover meaning prove to be better problem solvers than those who do not self-explain or who focus more on syntactical aspects of examples.
Article
The commercial spreadsheet is 21 years old and is now a commonplace business tool. To assess its impact on today’s modern business, this paper presents research based on a questionnaire survey of 227 respondents drawn from a range of business disciplines, and at various levels within their organisations. The results suggests that over 80 per cent are regular spreadsheet users, with Excel being the dominant spreadsheet. However, while its use in a variety of business applications is apparent, often only relatively low-level features of the spreadsheet are utilised. Limited and inappropriate training persists and it is argued that unless this issue is embraced and appropriate resources channelled into developing expertise in this area, companies are unlikely to fully capitalise on the potential of the spreadsheet to encourage knowledge transfer and enhance workplace performance.