The Community for Technology Leaders
RSS Icon
Subscribe
Issue No.05 - September/October (2009 vol.26)
pp: 31-36
Kevin McDaid , Dundalk Institute of Technology, Ireland
Alan Rust , Dundalk Institute of Technology, Ireland
ABSTRACT
Spreadsheet technology is central to the functioning of the financial sector, but professionally created spreadsheets have a high level of error, which highlights the need for innovative supporting processes and tools. The current global financial crisis will likely accelerate this need because anticipated regulation will require novel, innovative risk management methods and technologies that cover development, risk assessment, review, and other spreadsheet activities. These methods will need to be easy to understand and use and will have to serve multiple stakeholders' needs. Test-driven spreadsheet development (TDSD) is one such method. TDSD provides an ideal fit with existing market-leading spreadsheet management processes and can assist managers and auditors in the assessment and control of spreadsheet risk.
INDEX TERMS
end-user software engineering, spreadsheets, office automation, information technology and systems applications, IT and systems, testing and debugging, software engineering
CITATION
Kevin McDaid, Alan Rust, "Test-Driven Development for Spreadsheet Risk Management", IEEE Software, vol.26, no. 5, pp. 31-36, September/October 2009, doi:10.1109/MS.2009.143
REFERENCES
1. R. Panko, "Controlling Spreadsheets," JOnline, vol. 1, 2007; www.isaca.org/Template.cfm?Section=K-NET3&CONTENTID=50616&TEMPLATE=/ ContentManagement ContentDisplay.cfm.
2. R. Panko, "What We Know about Spreadsheet Errors," J. End User Computing, vol. 10, no. 2, 1998, pp. 15–21.
3. S.G. Powell, K.R. Baker, and B. Lawson, "An Auditing Protocol for Spreadsheet Models," Information and Management, vol. 45, no. 5, 2008, pp. 312–320; http://portal.acm.orgcitation.cfm?id=1379454.1379496 .
4. M. Burnett, C. Cook, and G. Rothermel, "End User Software Engineering," Comm. ACM, vol. 47, no. 9, 2004, pp. 53–58.
5. K. Beck, Test Driven Development: By Example, Addison-Wesley, 2003.
6. S.W. Ambler, "Introduction to Test Driven Development (TDD)," 2006; www.agiledata.org/essaystdd.html.
7. K. Beck, Extreme Programming Explained: Embrace Change, Addison-Wesley, 2000.
8. S. Perry, "Automating Spreadsheet Discovery &Risk Assessment," Proc. Conf. European Spreadsheet Risk Interest Group, European Spreadsheet Risk Interest Group, 2008; http://arxiv.org/pdf0809.3016.
9. "Spreadsheet Management," Deloitte, 2008; www.deloitte.com/dtt/cda/doc/contentus_risk_spreadsheet_mgt_020908.pdf .
10. B. George and L. Williams, "An Initial Investigation of Test-Driven Development in Industry," Proc. ACM Symp. Applied Computing, ACM Press, 2003, pp. 1135–1139.
11. H. Erdogmus et al., "On the Effectiveness of the Test-First Approach to Programming," IEEE Trans. Software Eng., vol. 31, no. 3, 2005, pp. 226–237.
12. K. McDaid and A. Rust, "Test-Driven Spreadsheet Development," submitted to J. Visual Languages and Computing, 2009.
13. H. Wasmus and H.G. Gross, "Evaluation of Test-Driven Development," Proc. 2nd Int'l Conf. Evaluation of Novel Approaches to Software Eng., 2007; http://swerl.tudelft.nl/twiki/pub/Main/TechnicalReports TUD-SERG-2007-014.pdf.
14. M. Burnett et al., "Test Homogenous Spreadsheet Grids with the 'What You See Is What You Test' Methodology," IEEE Trans. Software Eng., vol. 28, no. 6, 2002, pp. 576–594.
15. R. Banham, "Up and Away," CFO Online, Dec. 2008; www.cfo.com/article.cfm/12665848/2c_12671474 .
13 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool