k!dIDNSUBJECTCUNITCLEVELCDESCCþPOINTCþQUESTIONCþ 1.00000ICT OCR ICT A project 1B SS 1-2 . . Write about the workings of a model, which you have used. - Write about what the spreadsheet model ACTUALLY DOES - what does it store and what does it calculate? 2.00000ICT OCR ICT A project 1B SS 3-4 . . Write about how you have used the different options available within the model. - Make a change to the spreadsheet and write about what happens 3.00000ICT OCR ICT A project 1B SS 5-7 . . Write about how you have used a model to make decisions - Make SEVERAL changes to the model and write about what actually happens 4.00000ICT OCR ICT A project 1B SS 5-7 . . Write about the consequences of these decisions. - Describe the results of your changes - include before and after printouts, say what you WILL do before, and say what the results were AFTER 5.00000ICT OCR ICT A project 1B SS 8-10 . . Use a model to discover the patterns within it; - Write about how the results change for each change to the input - there must be changes in different columns 6.00000ICT OCR ICT A project 1B SS 8-10 . . Understand how the model operates; - Make changes in different columns. Describe what the spreadsheet is doing, in terms of sums, to change the results - say what each formula does.. Print out before and after for each change 7.00000ICT OCR ICT A project 1B SS 8-10 . . Make simple predictions - Predict what the results of the changes will be and write about what actually happens - you must have both increases and decreases 8.00000ICT OCR ICT A project 1B SS 11-13 . . Explore the effects of changing the data within the model; - Increase the number in a cell, print the results, then decrease the same number and print it. Do this for several cells. Write about the results. 9.00000ICT OCR ICT A project 1B SS 11-13 . . - Predict, precisely, what the results of a number of changes will be and write about what actually happens. Were your predictions correct? 10.00000ICT OCR ICT A project 1B SS 11-13 . . Make simple predictions about some of the effects of these changes. - Say what happened when you made several changes to the spreadsheet 11.00000ICT OCR ICT A project 1B SS 14-16 . . Use a complex model to discover the patterns within it; - Add extra columns with complex functions 12.00000ICT OCR ICT A project 1B SS 14-16 . . Change the rules of the model; - Change some of the data (numbers) in the model 13.00000ICT OCR ICT A project 1B SS 14-16 . . - Change some of the formulas in the model 14.00000ICT OCR ICT A project 1B SS 14-16 . . Write about how valid the model is. - Describe a situation where the spreadsheet could be used. 15.00000ICT OCR ICT A project 1B SS 17-19 . . develop the model by changing the rules to solve a given task; - Use the model to answer some what-if questions by changing data 16.00000ICT OCR ICT A project 1B SS 17-19 . . - Use the model to answer some what-if questions by changing formulas 17.00000ICT OCR ICT A project 1B SS 17-19 . . Write about how valid this model is in solving the task. - You write about how well the spreadsheet does its job. 18.00000ICT OCR ICT A project 1B SS 17-19 . . - Write about how the spreadsheet has been improved 19.00000ICT OCR ICT A project 1B SS 20-22 . . Design a complex computer model to provide the solution to a given task; - Describe what your spreadsheet will be used for - what it will store, what it will calculate. 20.00000ICT OCR ICT A project 1B SS 20-22 . . - Provide initial design sketches of your spreadsheet including layout, formatting and formulas 21.00000ICT OCR ICT A project 1B SS 20-22 . . - Give reasons why you are using each formula - explain what each formula does 22.00000ICT OCR ICT A project 1B SS 20-22 . . - Evaluate how well your model works - what does it do, what does it NOT do, how could it be improved, how could a real company uise it? 23.00000ICT OCR ICT A project 1B SS 20-22 . . Give reasons, related to the task, for choosing a piece of software for the solution; - Give reasons why you have chosen this particular software for this task - what does it does that other programs don't? 24.00000ICT OCR ICT A project 1B SS 20-22 . . Use the software to construct the computer model - Describe how you created the model 25.00000ICT OCR ICT A project 1B SS 23-25 . . Use the software to provide the answers required to solve the problem - Use the model to answer some what-if questions - say what happens, what you did to solve the problem, what the effect of the changes is 26.00000ICT OCR ICT A project 1B SS 23-25 . . - Include screen dumps of how you made and developed the spreadsheet 27.00000ICT OCR ICT A project 1B SS 23-25 . . Write about how the model was created - Describe the features of the software that you used to create the model 28.00000ICT OCR ICT A project 1B SS 26-28 . . Write about how suitable the software was for this purpose - Explain how the features of the software they used made the task easier or otherwise to complete 29.00000ICT OCR ICT A project 1B SS 26-28 . . - Explain how easy it was to use the software to change variables