3.8 Spreadsheets, modelling and simulations


The increasing capabilities of computers have allowed individuals and organizations to develop software that can be used to test “what-if” scenarios and create simulations and models of real-world events.

Spreadsheets, through the use of worksheets and graphs, can be used to manage, predict using a series of “what-if” scenarios, and display financial details of businesses.

Modelling and simulations can be used to recreate or predict the conditions that may result from an event, for example, the areas that will be affected by coastal flooding as a result of different levels of global warming.

It is important that the ITGS student is aware of the benefits of creating accurate spreadsheets, models and simulations as well as the social impacts that could result from simulations being unable to replicate the real world, and the ethical issues that may arise during the development of the model.

Possible scenarios

Students are expected to carry out practical activities using spreadsheets, for example, the development of a spreadsheet that allows a teacher to add marks from a class test so as to generate information such as the grade for the test.

Students are expected to use modelling and simulations to reinforce their theoretical knowledge, and to apply the ITGS triangle to a range of real-life scenarios.

IT concepts to address in this topic

Theoretical and practical concepts for spreadsheets

Modelling and simulation technologies and considerations

Developing and using models and simulations