This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Test-Driven Development for Spreadsheet Risk Management
September/October 2009 (vol. 26 no. 5)
pp. 31-36
ASCII Text
x 
 
Kevin McDaid, Alan Rust, "Test-Driven Development for Spreadsheet Risk Management," IEEE Software, vol. 26, no. 5, pp. 31-36, September/October, 2009.
 
 
BibTex
x
 
@article{ 10.1109/MS.2009.143,
author = {Kevin McDaid and Alan Rust},
title = {Test-Driven Development for Spreadsheet Risk Management},
journal ={IEEE Software},
volume = {26},
number = {5},
issn = {0740-7459},
year = {2009},
pages = {31-36},
doi = {http://doi.ieeecomputersociety.org/10.1109/MS.2009.143},
publisher = {IEEE Computer Society},
address = {Los Alamitos, CA, USA},
}
 
 
RefWorks Procite/RefMan/Endnote
x 
 
TY - MGZN
JO - IEEE Software
TI - Test-Driven Development for Spreadsheet Risk Management
IS - 5
SN - 0740-7459
SP31
EP36
EPD - 31-36
A1 - Kevin McDaid,
A1 - Alan Rust,
PY - 2009
KW - end-user software engineering
KW - spreadsheets
KW - office automation
KW - information technology and systems applications
KW - IT and systems
KW - testing and debugging
KW - software engineering
VL - 26
JA - IEEE Software
ER -
 
Kevin McDaid, Dundalk Institute of Technology, Ireland
Alan Rust, Dundalk Institute of Technology, Ireland
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.

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 .

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, Sept.-Oct. 2009, doi:10.1109/MS.2009.143
Usage of this product signifies your acceptance of the Terms of Use.