Spreadsheet is one of the most widely-used end-user development tools nowadays. It is used by a large number of end-users to perform financial calculations in global enterprises. Nowadays spreadsheets are mostly developed by end-users instead of professional programmers. Studies show that over 90% of spreadsheets contain errors. In some cases, these errors can lead to over 100 million US dollars of difference from the actual values.
Students of this project will help analyse the spreadsheets and corresponding emails released by a global enterprises. They will help prepare experimental subjects and develop analysis tools in Java, Python or Go. Interested students are encouraged to take a look of a presentation downloadable at http://sccpu2.cse.ust.hk/castle/materials/Custodes.4.pdf .
UROP1000 UROP1100 UROP2100 UROP3100 UROP4100
Students should have good knowledge in Excel, Java programming and data clustering. They will need to pick up existing analysis techniques for spreadsheets, and help carry out the associated experiments.
Applicant's Learning Objectives:
This project aims to achieve the following objectives:
- To learn how to characterize the errors commonly found in spreadsheets.
- To learn how to carry out empirical experiments on spreadsheets.
- To learn new spreadsheet analysis techniques.