~welcome~

~welcome to this ict blog~
~this is a blog about study in ict at school~
~please enjoy~

Thursday 19 January 2012

Case Study 3 Modelling

Q1 What might be the differences between a computer system set up for gaming compared to one set up for a business to use? Think about the different hardware that might be needed.


A1 A computer system for gaming would be more expensive but also more powerful. Why? Because they need to run high tech computer games that require speed and a large memory. There would be a large screen (better for the eyes), a High speed CPU or Tower with a lot of RAM and ROM and the latest system, a DVD drive, a High speed modem and loud speakers.
A system for a business would be less expensive because office ladies don't need so much speed. They would only need a large screen (better for the eyes), a normal CPU with a modern but quite basic system and a printer.


Q2 Earl has got £800 to spend. How can Shaheen work out if he has got enough money? What if he doesn't have enough? What methods could Shaeen use to help her work out the prices of these different options?


A2 She can use a Excel worksheet and the "Sum" option. then enter the prices in and calculate. If he doesn't have enough money Shaheen can find him some cheaper options. She can also make a price list or spreadsheet page to find out the prices of different choices. 


Q3 What does Shaheen need to do to this spreadsheet model so that it is ready to use? 


A3 She needs to add the formulas of how much the customer has to spend and to work out whether the customer has got enough money.


Q4 How can Shaheen use the spreadsheet model to help her with the new customer? What changes might she need to make to her spreadsheet model? 


A4 She could show the spreadsheet to the customer and tell him the prices of the other choices.. Then the new customer can choose which option he wants to buy.


Q5 How else could Shaheen present this information to make it easier to read?


A5 She could use a bar graph or chart to make it easier to read.

No comments:

Post a Comment