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

Authors Avatar

Hanna Cheung                        Exam number:  8032                      

 Centre name: SHCC        Centre number: 56515

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. The ‘Rating’ column was also formatted so that only numbers can be entered and there will be no decimal places in this column.

Join now!

To check the accuracy of the data that was entered into my spreadsheet I verified the data in my spreadsheet with the data that I originally compiled my research on a piece of paper. This check was to ensure that all of the information that I entered into the spreadsheet was correct.

As I formatted the ‘Price’ and ‘Rating’ columns, data entered that does not fit into the criteria I gave them will be altered so that they will fit into the criteria. For example if a number with any decimal places is entered into the ‘Rating’ ...

This is a preview of the whole essay