We have discussed the idea of a computer model in ICT lessons, and also the idea of using Excel (or Open Office) to produce random numbers.
Imagine that your Maths teacher gave you some homework that was to roll a die and count up the number of times each number comes up. Is that the sort of thing you can do with a spreadsheet? Of course it is!
Just counting the numbers would keep your Maths teacher happy, but how could you make your spreadsheet look better? What the person operating the model sees is called the user interface, and in this part of the task you're going to create your model and design the user interface. It would be more obvious that your model represented a die if you could see the face of the die and which spots were showing. Are you up to the challenge?
To help you, all of the possible faces for the die are shown below - you should be able to see which spots appear when. The rules* for turning the spots on and off are probably simpler than you think! Look at each spot in turn - can you see when it should be there and when it shouldn't?
To help you, look at the two links below - one is to a die model done as a web-page (so you can see what your model might look like), the other is an Excel file containing a formula that will give you a random number from one to six.
spreadsheet with random number (each time you press the F9 key, the cell B2 will show you another random number from 1 - 6; that's effectively the same as rolling a die.)
* Remember that a model is made up of rules and variables. In this case the variables are the numbers rolled on the two dice, and the rules tell us which spots should appear.
Your task is to create a spreadsheet model of a die with a good user interface. It should contain:
a random number from 1 - 6 to represent the number thrown on the die