Year 7 ICT at Key Stage 3 - Unit 4: Models - Rules and Investigations

In this unit, you will learn how simple models are built by first investigating rules, then by seeing how rules can govern the behaviour of simple models by the use of spreadsheets. You will discuss the ways in which different models could be used to present different information in a spreadsheet, identifying the inputs, the rules (formulae) and the outputs. You will also learn the use of absolute cell referencing and other formulae that will make the model more appropriate for the end user. You will test the effectiveness of the model by using sample data representing a number of scenarios as well as chart creation.