• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  • Level: GCSE
  • Subject: ICT
  • Word count: 2661

Designing a Computer Games Database

Extracts from this document...


Candidate number Centre Number 10654 Contents Page A (6) Choice of Problem 3 B (6) Description of problem 3 Investigation and analysis of the problem and specification solution 4 Investigation 4 Analysis 4 Specification 4 evaluation criteria. 4 Implementation Of Solution Resources 6 Data verification and Validation 6 Data and program structures 6 Testing of solution 7 Documentation of Solution user-guide 7 technical guide 8 Evaluation of solution 11 Choice of Problem Right now the computer games are one of the fastest growing industries in the world. A rapidly increasing number of platforms running vast numbers of games are now available to consumers. There is a maze of titles that vary greatly in quality and style. Also not every computer has the specifications to run every game. There are numerous genres of computer game that will only interest certain people. As you can see the computer game market can be a mine field for the consumer looking for the right game. Recently released games often retail for around �40 so with the costs involved buying the right game can become quite important. Description of problem My answer to this problem is a computer game database. The purpose of this would be to allow people to check a title against the list to find out its vital information. ...read more.


To do this I had to make up values for products the amount they would sell for and the amount they would cost to buy. Product Sold Bought In stock Buy cost (�) Sell price (�) Profit/loss (�) Sales Profit (�) sinkers bar 12 40 28 0.18 0.31 -3.48 3.72 can'o'coke 46 50 4 0.32 0.49 6.54 22.54 sausage role 8 30 22 0.04 0.55 3.2 4.4 burger 23 30 7 0.12 0.7 12.5 16.1 doughnut 13 40 27 0.2 0.4 -2.8 5.2 biscuit 4 20 16 0.05 0.15 -0.4 0.6 slushy 47 100 53 0.3 0.5 -6.5 23.5 coffee 13 100 87 0.21 0.6 -13.2 7.8 short bread 3 20 17 0.1 0.15 -1.55 0.45 Cash at open (�) Cash at close (�) Total profit (�) Overall profit/loss 100 184.31 84.31 -5.69 After about an hour I worked out from my fake sales a value for my total profit and overall profit. After the time it take to put the information in the spreadsheet gave the same answer. I tried the same thing a few more time with different information 2 more times. It gave a different answer the third time but I'm pretty sure that was me not the sheet making the mistake. ...read more.


You will need to follow the same routine for typing in the information in the bought, buy cost and sell price fields. It should be noted that buy cost is worked out on a individual basis. Most products you sell will not be bought individually so you will need to divide the amount you get buy the cost to get an individual price. With things like coffee witch contain various separately bought items a price will have to be estimated for one. After that you will need to copy the formulas to the appropriate boxes. All the boxes that contained 0's are formulas. The first product in the list already has all its formulas in the right place. Only the first box in each formula column will contain a formula. You need to select it and right click to copy it. Then in the column bellow it highlight the empty cells right click and select paste special. Repeat this for all the formula columns. some formulas will need to be edited for the cells bellow your product fields. Highlight the cell bellow the total profit header, in the box near the top the formula =SUM will appear. You need to tell the sheet what is wants to add up. Look at the first and the last cells in the sales profit column. By looking at the sides you can find the grid references for those cells. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Software essays

  1. Design a spreadsheet that can be used by a school tuck shop.

    order =H3/100*$I$1 =H3+I3 =H4/100*$I$1 =H4+I4 =H5/100*$I$1 =H5+I5 =H6/100*$I$1 =H6+I6 =H7/100*$I$1 =H7+I7 =H8/100*$I$1 =H8+I8 =H9/100*$I$1 =H9+I9 =H10/100*$I$1 =H10+I10 =H11/100*$I$1 =H11+I11 =H12/100*$I$1 =H12+I12 =H13/100*$I$1 =H13+I13 =H14/100*$I$1 =H14+I14 =H15/100*$I$1 =H15+I15 =H16/100*$I$1 =H16+I16 =H17/100*$I$1 =H17+I17 =H18/100*$I$1 =H18+I18 total expenditure =SUM(J3:J18) income =$U$20 wages =wages!$Q$5 electricity 25 Total number bought total cost each inc VAT

  2. To start my project I have chosen that I would do a spreadsheet for ...

    My end user would use the spreadsheet that I will design. My end user would be the shop owner who is using this as a super calculator and would help them get good outcomes from the spreadsheet. The end user requirements should be: Fast data search Accurate calculations Easy to use (user friendly)


    The column would have listed all the phone numbers of every patient. This would have made the database more user-friendly, which would have helped achieve my 1st objective even more.


    following programs Cyberlink, PowerDVD and Roxio Creator which may come standard with the drive however the optical drive in the Dell Precision T7400 may run with the previous programs but don't come as standard. CPU HARDDRIVE RAM GRAPHICS CARD OPTICAL DRIVE Dell Precision T7400 Intel Xeon X5482 (3.20GHz,1600FSB,2x6MB,Quad Core)

  1. Planning a spreadsheet database for a gun shop.

    * Spreadsheet can automatically calculate data. * It is more efficient and reliable than using manual methods such as paper. Software: I have narrowed it down to only two Software's that I can us to solve this issue. They are: Microsoft Access: Microsoft access is a software which is not useful for data calculation and presenting graphs.

  2. What is a computer registry?

    It tracks any changes made to the settings. Computer registry should not be edited manually. However when you observe any of the following errors, the registry would need a clean up: The speed of the computer is not the same as it used to be earlier. The computer faces frequent crash though there is no error or problem.

  1. AQA GCSE ICT Specification B

    Company Name, Logo and Address Customer Title, Initial and Surname Billing Address Delivery Address Date of Order Type of Order Order Details Payment Details Net Cost (includes cost of personalization) VAT Cost Total Cost Projected Dispatch Date Company Name, Logo and Address Projected Dispatch Date VAT Rate Product Prices Customer

  2. Youth Club Database Solution

    It reads: =(AVERAGE(M4:M79))/100 This formula works out the average in the range M4 to M79 and then is divided by 100 to turn it into a percentage. Front Ends and Vlookup The first sheet pf my system is called a Front End, and is a neat way of presenting a

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work