• 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. 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.

  1. Documentation of a database for a sports centre.

    Joined 12/01/11 Time/Date 6 _ _/_ _/_ _ Expiry Date 30/17/12 Time/Date 6 _ _/_ _/_ _ To be able to warn them when their membership expires Member on Site Yes Text - Either "Yes" or "No" To show whether member is in the sports centre at the time Query

  2. Database design for a games shop.

    Walcott and Ben often find it difficult to get this data fast and end up spending a very long time to find this information but the customers get impatient and hang up or in case of a email they look somewhere else for their needs.

  1. What is a computer registry?

    A Computer Registry--that is synonymous with Windows Registry--creates a database of information about all hardware, software, devices and programs installed on the computer. It is a repository of information about the computer's configuration. It tracks any changes made to the settings.

  2. Reviewing different multimedia presentations.

    This is a good feature as it makes the product almost addictive as all you want to do is fill in all the body parts to every section. The second good feature to this Multimedia Presentation is that you have to put all the parts of the body in the

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    a glance what the lowest and highest score was, and the class average; from seeing this data she can then tell if the class is doing well or if extra work is required. To calculate the max, min and average, I completed the following steps: 2)

  2. AQA GCSE ICT Specification B

    parallel running. I will then install the new system, having moved all information to the new system. Testing I will assemble a group of system users. I shall ask them to try the system with a limited amount of information.

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