Abstract
Generation of test cases for end-user programmers is crucial to assure the correctness of their code. In this paper we investigate the automatic generation of test cases for programs that are written in Visual Basic for Applications and are used in MS Excel. We implement a metaheuristic search method to generate tests that achieve a satisfactory statement and branch coverage. Furthermore, in our methodology the code coverage is visualized. The generated test cases and the visualization enable end users to better understand the behavior of the programs and increase the probability of detecting errors when the code is changed at a later time.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Abraham, R., Erwig, M.: Ucheck: A spreadsheet type checker for end users. J. Vis. Lang. Comput. 18(1), 71–95 (2007)
Burnett, M.M., Sheretov, A., Ren, B., Rothermel, G.: Testing homogeneous spreadsheet grids with the ”what you see is what you test” methodology. IEEE Trans. Software Eng. 28(6), 576–594 (2002)
Díaz, E., Tuya, J., Blanco, R., Javier Dolado, J.: A tabu search algorithm for structural software testing. Computers & Operations Research 35(10), 3052–3072 (2008)
Harman, M., Mansouri, S.A., Zhang, Y.: Search-based software engineering: Trends, techniques and applications. ACM Comput. Surv. 45(1), 11 (2012)
Ko, A.J., Abraham, R., Beckwith, L., Blackwell, A.F., Burnett, M.M., Erwig, M., Scaffidi, C., Lawrance, J., Lieberman, H., Myers, B.A., Rosson, M.B., Rothermel, G., Shaw, M., Wiedenbeck, S.: The state of the art in end-user software engineering. ACM Comput. Surv. 43(3), 21 (2011)
Lawrance, J., Clarke, S., Burnett, M.M., Rothermel, G.: How well do professional developers test with code coverage visualizations? An empirical study. In: VL/HCC, pp. 53–60 (2005)
Panko, R.: Spreadsheet errors: What we know. What we think we can do. arXiv preprint arXiv:0802.3457 (2008)
Rothermel, G., Li, L., DuPuis, C., Burnett, M.M.: What you see is what you test: A methodology for testing form-based visual programs. In: ICSE, pp. 198–207 (1998)
Ruthruff, J.R., Prabhakararao, S., Reichwein, J., Cook, C.R., Creswick, E., Burnett, M.M.: Interactive, visual fault localization support for end-user programmers. J. Vis. Lang. Comput. 16(1-2), 3–40 (2005)
Tracey, N., Clark, J., Mander, K.: Automated program flaw finding using simulated annealing. ACM SIGSOFT Soft. Eng. Notes 23, 73–81 (1998)
Waeselynck, H., Thévenod-Fosse, P., Abdellatif-Kaddour, O.: Simulated annealing applied to test generation: landscape characterization and stopping criteria. Emp. Soft. Eng. 12(1), 35–63 (2007)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Musliu, N., Slany, W., Gärtner, J. (2013). Automated Test Case Generation in End-User Programming. In: Dittrich, Y., Burnett, M., Mørch, A., Redmiles, D. (eds) End-User Development. IS-EUD 2013. Lecture Notes in Computer Science, vol 7897. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-38706-7_25
Download citation
DOI: https://doi.org/10.1007/978-3-642-38706-7_25
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-38705-0
Online ISBN: 978-3-642-38706-7
eBook Packages: Computer ScienceComputer Science (R0)