Developing a web-based teaching and learning resource for cost benefit analysis: CBA Builder
Dan Wheatley, Nottingham Trent University
Published June 2011
‘CBA (Cost Benefit Analysis) Builder’ is a free-to-use web-based interactive teaching and learning resource, which can be used by students to aid in their understanding of cost benefit analysis. CBA is used widely in industry in both the public sector (e.g. the UK Department for Transport’s COBA) and also in the private sector. In this sense, improving the quality of teaching and learning of this subject, and student engagement with it, will help to improve student employability by providing students with skills that will be sought by employers.
The need for the resource was identified after teaching cost benefit analysis to undergraduate students on Economics degrees within Nottingham Business School, and also to students studying Quantity Surveying and Construction Management in the School of the Built Environment at Nottingham Trent University (NTU). Students commented that grasping key concepts such as discounting future values to present values could be quite difficult. Working through real-life examples, and getting hands-on experience would therefore help students to understand the relevance of the different concepts learned and to gain practical experience. Developing a web-based, and free to use, resource would also allow students to access it away from University. This project was joint-funded by the Economics Network and the Centre for Education in the Built Environment (CEBE) as part of the Teaching and Learning Development Projects 2010/11. The main objectives of the project were to:
- Create a free to use web-based resource for teaching and learning of CBA.
- Create an interactive resource for teaching and learning of CBA which provides (i) an in-depth online textbook of CBA information; (ii) hands-on experience with worked (flash) examples; (iii) the ability to create your own simple and advanced CBA, and; (iv) downloadable exercises and worksheets.
- Create a resource which can be used in formative and non-formative assessment.
- Improve student engagement with CBA through new methods of teaching and learning.
- Improve student employability through improved knowledge of a common method of project appraisal used in both the public and private sector.
The project began with the multiple activities of constructing the CBA Builder website and writing the content for the online textbook element of the site. This took much of the first four to five months of the project, with the remaining time spet developing the CBA Builder Microsoft Excel-based CBA creation tools. The initial draft website iterations were hosted through the Economics Network website before the site went live in October 2010 on its own URL (www.cbabuilder.co.uk) which was purchased as part of the project. Following useful feedback relating to functionality and presentation of the resource from Martin Poulter from the Economics Network, the website underwent a series of alterations and amendments to improve usability/functionality and the presentation of the site. The final site layout and design was then decided upon (see screenshot 1, also showing the dropdown menu for ‘CBA Explained’ area of the online textbook). Further amendments and additions to the site were made throughout the project following feedback from staff and students, as well as to enhance the depth of content on the site. A significant amount of effort was also required to secure the external trial/feedback sessions with eventual success through sessions held at two Universities.
Screenshot 1: CBA Builder Site Home Page
The resource is available at www.cbabuilder.co.uk. Following the original objectives, the resource contains an online textbook, flash animations, and a detailed links section containing links to relevant textbooks, journal articles, and web resources. The site also includes CBA Builder Simple and Advanced Excel-based CBA construction tools. CBA Builder Simple allows users to construct a CBA using a number of separate tabs, and is particularly suitable for teaching and learning applications. CBA Builder Advanced allows more detailed CBAs to be constructed. CBA Builder Advanced is therefore suitable for more in-depth practical applications of CBA, or more advanced teaching and learning applications. The CBA Builder tools allow users to enter one-off costs and benefits, recurring costs and benefits, discount to present value, compound values, produce results (NPV, BCR), perform discount rate sensitivity analysis, and perform CBA period sensitivity analysis (see screenshots 2-5). Finally, the resource includes a series of downloadable exercises and worksheets, many of which are designed for use with the CBA Builder Simple and Advanced tools (see example in screenshot 6 and 7).
Screenshot 6: Website worksheets page
Visit this resource
Screenshot 7: CBA Builder Worksheet
Visit this resource
Dissemination of the project has taken two forms: (1) feedback sessions with students, and; (2) staff involvement through workshops held at NTU. The feedback sessions with staff involved two feedback workshops held at NTU, one at the beginning of the project, and one in January 2011. The student feedback sessions included two sets of feedback from students at NTU (including Economics and Business Economics students). One of these sessions was held during the academic year as part of a module being taught to second year undergraduate students. These trial sessions also involved the use of the resource in a coursework assessment. In addition external feedback sessions were held with Business and Finance students at University of Leeds (facilitated by Dr Surender Munjal), and two separate trials were held with Health and Economics students at Frederick University, Cyprus (facilitated by Dr Despena Andrioti).
The resource has been well received on the whole – evident in the feedback responses from the external and internal student sessions. Table 1 summarises the responses (as a percentage) to the range of questions asked in the feedback survey completed by all the resource trialists. Overall the results indicate that students found the resource useful and engaging as a method of teaching and learning CBA. This is reflected in the proportions of students reporting they would recommend the resource to other students, and those that considered the resource to have improved their understanding of CBA (questions 5 (a) and (b)). Feedback relating to the online textbook element of the resource was also particularly positive. Respondents indicated the materials were easy to understand, interesting, and well-linked, and that the material is relatively comprehensive. The feedback results were compounded by written comments from students which further suggested a positive reaction to the resource. Student feedback included the following comments:
“Very good software, much more interactive approach.”
“Thoroughly enjoyed the session as brought theory to life.”
“The resource is very useful, especially the [flash] examples on how to use the discount rate etc. when constructing cost benefit analysis.”
“It is an excellent tool, well constructed, and sufficient for use [by] non-economists and accountants.”
In addition the students provided some useful feedback on the resource evident in the responses to questions regarding missing content in Table 1 (questions 2(d), 3(c) and 4(d)), and in the following written comments:
“The resource is good. More animations would make it better.”
“Example was good. Would like to see it extended to further topics.”
“The CBA [Builder] Simple is too similar to the CBA Builder Advanced.”
This feedback largely focused on the number of flash animations, which was increased during the course of the project (from four to six), and also in relation to putting additional features into the CBA Builder Excel-based tools, including CBA period sensitivity analysis. The latter element of this feedback was especially useful. Much feedback was also received from staff and colleagues regarding ways of improving and expanding the features of CBA Builder Simple and Advanced, as well as differentiating the two versions of the tool further (something suggested in the third comment above). All of the feedback was used in the development of the tool which has been through a series of iterations since the beginning of the project.
Table 1: Summary of feedback from trial sessions
|Strongly agree||Agree||Neutral||Disagree||Strongly disagree|
1. Online Textbook Materials
|(a) I found the content of the online textbook easy to understand||27%||53%||17%||3%||0%|
|(b) The material stimulated my interest for the subject||24%||65%||8%||3%||0%|
|(c) The sections of CBA material are well linked||16%||61%||23%||0%||0%|
|(d) Examples included are clear and interesting||29%||59%||9%||3%||0%|
|(e) There is missing material or subjects which are not covered||0%||11%||21%||57%||11%|
|2. Flash Animations|
|(a) The flash animations improved my understanding of key concepts||11%||70%||19%||0%||0%|
|(b) The flash animations are easy to use||19%||58%||23%||0%||0%|
|(c) The examples used in the flash animations are interesting||22%||57%||21%||0%||0%|
|(d) More flash animations are needed||18%||18%||39%||25%||0%|
|3. Links and References|
|(a) I found the list of references to texts and journal articles useful||8%||71%||21%||0%||0%|
|(b) I would use the links to download journal articles/purchase texts||4%||71%||21%||4%||0%|
|(c) There are missing references or texts which should be included||15%||8%||46%||31%||0%|
|4. CBA Builder Simple and Advanced|
|(a) CBA Builder Simple is useful for constructing CBAs||35%||65%||0%||0%||0%|
|(b) CBA Builder Advanced is useful for constructing CBAs||28%||72%||0%||0%||0%|
|(c) The templates include all the elements I need to construct a CBA||12%||56%||32%||0%||0%|
|(d) There are missing features on the CBA Builders||0%||28%||34%||31%||7%|
|(a) I would recommend a student to use this resource||56%||44%||0%||0%||0%|
|(b) Using the resource improves my understanding of CBA||26%||74%||0%||0%||0%|
In addition to the feedback collected from the student trials, feedback was also received (including useful comments for amendments and further development) from the organisers of the external sessions. These were also indicative of the resource offering a positive impact for teaching and learning of CBA. Comments from staff included “Overall a very useful tool”, “Interesting way of teaching [CBA] in classroom/seminars”, and, “It is definitely a very helpful tool ... I’m sure that the students will love it.” Positive feedback was also gathered from staff at NTU during the internal workshops. Staff at NTU had a chance to see the evolution of the project as workshops were held at the beginning and approximately half way through the project year. A further positive outcome of the project is that it has provided a useful opportunity to network and collaborate with staff at NTU and other institutions. For example, plans are in place to expand one of the worksheets which was dual authored with Surender Munjal (University of Leeds). The forward plan for the resource is to continue to gather input from other members of staff at NTU, and other institutions, to continue to improve and expand the resource.
Developing CBA Builder has been enjoyable and hopefully has successfully delivered on the original aims of providing a web-based resource for teaching and learning of CBA. CBA is a practical project appraisal tool, and as such lends itself to hands-on, interactive teaching and learning. The feedback gathered during the development of the resource has gone into improving the functionality, presentation and depth of the resource. Student and staff feedback suggest that the resource is useful, enhances engagement with CBA, and goes some way to providing a ‘one-stop shop’ of sorts for teaching and learning of CBA (although there is much expansion required to make this a reality). The project has required a lot of time and effort to produce thus far, but has been well worth it. Hopefully with input from teachers of CBA from a range of institutions the resource will continue to expand and develop in future, and in doing so enhance the student experience, and learning outcomes, of teaching and learning CBA.