• 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: 1475

I have been commissioned by a market research company to analyse the popularity of computer games with the teenage market.

Extracts from this document...


Modelling assignment. I have been commissioned by a market research company to analyse the popularity of computer games with the teenage market. The market research company requires a list of games, the name of the console, price of the game and the rating of each game (from1-10). To complete this assignment I will be required to complete some research into the games and their popularity with the teenage audience. I will then use the information that I have compiled to perform some calculations. Transferring data I am going to extract data from the database, which I made previously as part of my database assignment. I will extract the data by creating a query. This is a screen dump of the query in Access. This is the data that I extracted from the table in Access and saved as a spreadsheet. The reason why I moved the data was so that I would be able to use Excel and the data collected in order to do some calculations and create charts. Setting up the spreadsheet I formatted the spreadsheet by changing the font used in the spreadsheet to Palatino Linotype, changing the headings so that they are now in bold. I also formatted all of the columns so that the information in them would be able to fit into them and I formatted the column 'Price' so that all of the data that is entered into it will be currency, and will have a � sign in front of it and the data will automatically be to two decimal places. ...read more.


There are two parts to the IF formula that I used, one part of the formula makes sure that games with a popularity rating of 6 or over will be called 'Popular'. The other part of the formula makes sure that all the games with ratings of 5 or under will be called 'Not popular'. I dragged the corner of cell F2 down, with the formula in it, so that all of the games would have an IF formula, which will correspond to their rating. I verified that the IF formula was working by checking the rating with the popularity rating. If the rating was 5 or under then the popularity rating should be that it is 'Not popular'. However, if the rating is 6 or over, the game should have been rated as 'Popular'. Also, I looked through most of the cells with the IF formula in them to check that they all correspond with the cells next to them. I did not need to change the page orientation or page set up as I had already done this earlier on. As you can see from the screen dump below, all of the data from the spreadsheet fits onto one page. As the Market research company only want the 10 most popular games, I will need to delete all the other games. I will sort out the 10 most popular games by sorting the games by their ratings. ...read more.


I did this by copying the Game name and Ratings columns onto a new sheet. I then highlighted these two columns and clicked on the chart wizard button. I created a simple column graph by using the chart wizard. I formatted the graph by changing the alignment of the game names so that it was easier to read them. I also changed the font size and type of the writing so that it also much easier to read the writing. I chose to use a column graph as I think that it shows the data better than another chart. For the market researchers it will be very easy to compare the ratings. Further investigations The spreadsheet could be further enhanced and improved by adding this data: * The genre of the game - this will allow the market researchers to see, which types of genres are most popular. * The number of players who can play the game - this will allow the market research company to see whether or not people prefer to play one player or multi-player games. I do not think that the spreadsheet needs any more formulas in order to improve it. I also don't think that the data there can be calculated by using any formulas. I created a folder entitled 'Modelling', in this folder there are all the spreadsheets that I have created and my assignment as well. Here is a screen dump, which shows where I have saved all my work. Hanna Cheung Exam number: 8032 Centre name: SHCC Centre number: 56515 ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. Model Price Chart.

    drinks sold @ 60p and 400 cold drinks sold @ 54p, the profit should be �1. If hot drinks are sold @ 60p and cold drinks are sold @ 53p, there should be a profit of -�3 (i.e. a loss)

  2. DTP analyse

    These pages are built up as a series of text frames containing text and graphic frames containing images. DTP is inexpensive yet it can produce great result provided that the printer is of a high quality. DTP also offers Spell checker and error corrections, which can be very useful.


    Button Selection BMW logo; 9 buttons hyperlinked to sheets named in data section. A textbox with heading BMW. Picture as heading. Tables with specification of car. Two pictures. Large picture heading title. 4 3 Series (C) "Button and tab layout as slide 1" Models available.

  2. Making a mail-merge for the company "mobiles4u".

    The align feature is as good as the table feature because if you use the left align, right align or centre it would put the writing into columns so it would look like a newspaper article. An extremely good feature on Microsoft Word would be the save and open button

  1. Develop a spreadsheet application for the Ibis Hotel.

    From the last few years, the hotel has been using typewriters and in some cases handwritten work has also been done. In the nearby hotels, all are using computerised systems. In order to improve services, the general manager has decided to introduce a computerised system for the hotel.

  2. Design a computer system to help a leisure centre run more effectively

    If this solution was possible, it can dramatically decrease the outgoing of the leisure centre. Not only that but it would also help us to gain more customers to join our leisure centre. By computerisation, we can improve the workers own self-satisfaction as they felt their job is been more up-to-date and technological.

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