COMPUTER APPLICATIONS IN BUSINESS

Unit 3: Spreadsheet and its Business Applications Study Notes By Deepak Sir ❖ SPREADSHEET A spreadsheet or worksheet is a file made of rows and columns that help sort, organize, and arrange data efficiently, and calculate numerical data. What makes a spreadsheet software program unique is its ability to calculate values using mathematical formulas and the data in cells. An example of how a spreadsheet may be utilized is creating an overview of your bank's balance.

See Full PDF See Full PDF

Related Papers

Among the specialized analysis tools, spreadsheet applications are the most accessible. In addition, techniques and tools for organizing, processing and presentation of basic data, such as strengthening multiple lists, filtering, running sum, pivot tables they offer, largely satisfy the needs of organization and data analysis activities in the field of economics. For this reason we conducted a study in which we sought to obtain information on how these applications are used in the economic field.

Download Free PDF View PDF

International Journal of Management and Decision Making

Download Free PDF View PDF

Behavior Research Methods, Instruments, & Computers

Download Free PDF View PDF

In this paper, we report some on-going focused research, but are further keen to set it in the context of a proposed bigger picture, as follows. There is a certain depressing pattern about the attitude of industry to spreadsheet error research and a certain pattern about conferences highlighting these issues. Is it not high time to move on from measuring spreadsheet errors to developing an armoury of disciplines and controls? In short, we propose the need to rigorously lay the foundations of a spreadsheet engineering discipline. Clearly, multiple research teams would be required to tackle such a big task. This suggests the need for both national and international collaborative research, since any given group can only address a small segment of the whole. There are already a small number of examples of such on-going international collaborative research. Having established the need for a directed research effort, the rest of the paper then attempts to act as an exemplar in demonstrati.

Download Free PDF View PDF

We developed an internet-based questionnaire on spreadsheet use, and we administered the questionnaire to a large number of users to document how spreadsheets are currently being developed and used in the business world. In this paper, we discuss the results drawn from a large sample of MBA graduates. These results describe current spreadsheet use in organizations, largely confirming the gap that exists between actual practice and best practice. Moreover, our results indicate that this gap occurs in two areas: it appears not only in the skills of individual users but also in the policies of large organizations.

Download Free PDF View PDF

Proceedings of the 9th International Technology, Education and Development Conference (INTED)

Most recent studies suggest that approximately one third of business data in modern organizations is generated using EUD applications developed by non-IT-specialist end-users, most frequently by use of spreadsheet applications. One of the causes of the pandemic of spreadsheet errors, which has been referred to in numerous articles, are inadequately developed end-user spreadsheet applications. Contents pertaining to spreadsheet development offered in Serbian university and LLL courses are primarily based on spreadsheet techniques and capabilities, with complete disregard or marginal recognition of the need to raise awareness of risks and devastating consequences associated with spreadsheet errors. Results of a research on the use of spreadsheets in Serbian SMEs suggest that spreadsheet error prevention and reduction techniques are used rarely. Based on a selection of current best practices, this paper presents several proposals for updating/innovating courses related to spreadsheet d.

Download Free PDF View PDF

This paper explores the impacts of spreadsheets on business operations in a water utility parastatal in Malawi, Sub-Saharan Africa. The organisation is a typical example of a semigovernment organisation operating in a technologically underdeveloped country. The study focused on spreadsheet scope of use and life cycle as well as organisation policy and governance. The results will help define future spreadsheet usage by influencing new approaches for managing potential risks associated with spreadsheets in the organization. Generally, findings indicate that the proliferation of spreadsheets in the organization has provided an enabling environment for business automation. The paper also highlights management, technological and human factor issues contributing to high risks associated with the pervasive spreadsheet use. The conclusions drawn from the research confirms that there is ample room for improvement in many areas such as implementation of comprehensive policies and regulations.

Download Free PDF View PDF

See Full PDF

Sorry, preview is currently unavailable. You can download the paper by clicking the button above.

RELATED PAPERS

Decision Support Systems

Download Free PDF View PDF

Proceedings of the 2010 international conference on Management of data - SIGMOD '10

Download Free PDF View PDF

Arxiv preprint arXiv:0803.0164

Download Free PDF View PDF

Proceedings of the International Conference On Applied Science and Technology 2019 - Social Sciences Track (iCASTSS 2019)

Download Free PDF View PDF

Proceedings of the International Conference on Social Science 2019 (ICSS 2019)

Download Free PDF View PDF

Extended Abstracts of the 2020 CHI Conference on Human Factors in Computing Systems

Download Free PDF View PDF

SSRN Electronic Journal

Download Free PDF View PDF

Sprin Journal of Arts, Humanities and Social Sciences

Download Free PDF View PDF

Informs Transactions on Education

Download Free PDF View PDF