스프레드시트 사용에 관한 연구
A study on Use of a Spreadsheet (Excel)
0
조회
0
다운로드
1
인용
0
참고문헌
키워드
초록
A spreadsheet is a office automation software which has been widely used in almost all areas in business. A spreadsheet is used for calculation, data analysis, model building and so on. As a result, spreadsheet is a very im[portant tool for generating knowlege in a firm. Errors in a spreadsheet model can cause a serious financial damage in a corporation. However in Korea few researches for reducing errors have been performed. Neither serious efforts to reduce errors have been executed by corporations. In this research we provided summarized the results from a survey for spreadsheet usage, summarized researches on errors in spreadsheet up to now, and suggested a rules and structured development method for reducing errors in a spreadsheet. Errors in spreadsheets are prevalent. To solve this serious problem, we need much more attention on this problem in research area. Corporations must put more efforts on setting policies and rules. And also we need the government's concern and support.
Abstract
A spreadsheet is a office automation software which has been widely used in almost all areas in business. A spreadsheet is used for calculation, data analysis, model building and so on. As a result, spreadsheet is a very im[portant tool for generating knowlege in a firm. Errors in a spreadsheet model can cause a serious financial damage in a corporation. However in Korea few researches for reducing errors have been performed. Neither serious efforts to reduce errors have been executed by corporations. In this research we provided summarized the results from a survey for spreadsheet usage, summarized researches on errors in spreadsheet up to now, and suggested a rules and structured development method for reducing errors in a spreadsheet. Errors in spreadsheets are prevalent. To solve this serious problem, we need much more attention on this problem in research area. Corporations must put more efforts on setting policies and rules. And also we need the government's concern and support.
참고문헌 (29)
- 박경아, "한국과 미국의 스프레드시트(엑셀) 사용자의 사용경험에 따른 차이분석 연구", 한국비즈니스리뷰, 2(2), pp.99~118 (2009)
- 손정훈, "업무-지식 통합기반의 차세대 지식경영 모델", 지식경영연구, 11(2), pp.1~16 (2010), 한국지식경영학회
- 이대용, "기업에서 쓰는 엑셀 대학에서 꼭 배우기" (2011), 비엔엠북스
- 조윤형, "조직의 지식창출에 대한 학습조직의 구조적 특성 및 학습자 특성의 효과 : 인지된 조직지원의 조절효과", 지식경영연구, 12(1), pp.17~37 (2011), 한국지식경영학회
- 최은수, "정보기술이 지식경영활동과 성과에 미치는 효과에 대한 실증분석", 지식경영연구, 10(3), pp.51~80 (2009), 한국지식경영학회
- Caulkins, J. P., "Spreadsheets errors and decision making: Evidence from field interviews", Journal of Organizational and End User Computing, pp.1~23 (2007)
- Chan, Y. E, "The use of spreadsheets in organizations: Determinants and consequences", Information and Management, 31, pp.119~134 (1996)
- Clermont, M. A, "spreadsheet auditing tool evaluated in an industrial context", Proceedings of the European Spreadsheet Risks Interest Group Annual Conference Cardiff, pp.35~46 (2002)
- Cragg, P., "Spreadsheets modelling abuse: An opportunity for OR?", Journal of the Operational Research Society, 44, pp.743~752 (1993)
- Davies, N., "Auditing spreadsheets", Australian Accountant, 57(11), pp.54~56 (1987)
- Ditlea, S, "Spreadsheets can be hazardous to your health", Personal Computing, pp.60~69 (1987)
- Freeman, D, "How to make spreadsheets error-proof", Journal of Accountancy, 181(5), pp.75~77 (1996)
- Galletta, F., "An empirical study of spreadsheet error-finding performance. Accounting", Management & Information Technology, 32, pp.79~95 (1993)
- Janvrin, D., "Using a structured design approach to reduce risks in end-user spreadsheet development", Information and Management, 37, pp.1~12 (2000)
- Kruck, S., "Testing spreadsheet accuracy theory", Information and Software Technology, 48, pp.204~213 (2006)
- "What we know about spreadsheet errors" (2006)[URL]
- Panko, R, "What we know about spreadsheet errors", Journal of End-User Computing, 10, pp.15~21 (2010)
- Panko, R., "The corpuses of spreadsheet errors", Proceedings of the 33rd Annual Hawaii International Conference on Systems Sciences, pp.1~8 (2000)
- Panko, R., "Hitting the wall: errors in developing and code inspecting a “simple” spreadsheet model", Decision Support Systems, 22, pp.337~353 (2009)
- Powell, S,, "An Auditing Protocol for Spreadsheet Models", Information & Management, 45(5), pp.312~320 (2008)
- Powell, S., "Impact of Errors in Operational Spreadsheets", Decision Support Systems, 47, pp.126~132 (2009)
- Powell, S., "A Critical Review of the Literature on Spreadsheet Errors", Decision Support Systems, 46, pp.128~138 (2008)
- Rajalingham, K., "Classification of spreadsheet errors", Proceedings of the European Spreadsheet Risks Interest Group Annual Conference, pp.23~34 (2000)
- Read, N, "Spreadsheet Modelling Best Practice", Business Dynamics IBM, Apr, ~ (1999)
- Ronen, B., "Spreadsheet analysis and design", Communications of the ACM, 32(1), pp.84~93 (1989)
- Saariluoma, P., "Transforming verbal descriptions into mathematical formulas in spreadsheet calculation", International Journal of Human-Computer Studies, 42, pp.915~948 (1994)
- "Best Practice Spreadsheet Modelling Standards Version 4.1" (2005)[URL]
- "European Spreadsheet Risks Interest Group"[URL]