• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Performance Charts - The aim of this task is to produce a simple chart comparing the points gained by each house from a sample event from last year's Sports Day, and comparing the points gained by boys and girls from these houses.

Extracts from this document...


Design Task 3 Performance Charts The aim of this task is to produce a simple chart comparing the points gained by each house from a sample event from last year's Sports Day, and comparing the points gained by boys and girls from these houses. In this case, the results that I shall use are from the 100m. As it is a graph that must be created, and number manipulations must be carried out, I believe that a spreadsheet would be the most effective solution. I believe Microsoft Excel to be the most effective solution to this problem. Not only am I comfortable with its features, but also it can fully complete the task, without the need for other software to be used. (This is aside from Microsoft Word needed for the design, testing and evaluation.) The features that I shall use are: * The data can be placed into an easy to read and analyse format, so that it can be easily interpreted. This will allow me to compare and select the data that must be placed into the chart. * There are many graphs that are available to me. Some of these include: column, bar, pie, line and XY scatter. ...read more.


This has been highlighted in orange above. Click next to continue. iii. This stage is used to add titles, labels etc. On the first tab, add the title: "A chart showing the points gained by the houses, and the respective points gained by boys and girls in last year's 100m." In the box underneath, the x-axis box, "HOUSE" should be entered, and "POINTS AWARDED" should be entered into the y-axis box. There are also tabs called "axes", "gridlines," "legend," and "data labels". Nothing needs to be changed in these, as the default settings are correct. However, select the "data table" tab, as I believe that a data table should be added. Add a tick in the 'show data table' box, and then check that there is a tick in the 'show legend keys' box. Continue to the final stage. iv. This stage is not vital to the success of the task. Choose the top option, placing the chart on a separate page. This is simply easier to use and to display. The chart has now been created. * Whilst viewing the chart, I believe that the zoom must be changed to 67%, as this allows the best view of the entire chart. To do this, simply click on View>Zoom>Custom, and enter 67. ...read more.


This is an annotated overall view of what the chart will look like when printed out. NOTE: The bars are not to the correct proportions, but are drawn simply to replicate how the printout will appear. TESTING PLAN To test whether this task has been performed in a correct manner, I need to ascertain whether the figures used for the chart are correct, and whether they have been used correctly to give accurately sized bars. To test the task, I shall perform the addition of the points mentally, and then plot these points onto a graph. This graph will again be done by hand, allowing for no computer errors. I will then compare the two graphs, the manually produce one and my final printout. It the proportions are identical, I can assume that I have completed this task successfully. This comparison will be done in the testing section of the task. From quickly finding the appropriate figures from those given to me on disk, I believe that these are the sums that I need to perform to gain the figures with which to test my task: AUSTEN Boys: = 5+13+13+9 Girls: = 15+13+3+3 BRONTE Boys: = 9+12+9+12 Girls: = 11+9+10+15 DICKENS Boys: = 11+5+5+7 Girls: = 5+11+11+9 GREENE Boys: = 11+6+9+8 Girls: = 5+3+12+9 CHRISTOPHER KURWIE - 1 - Task 3 11PS CHRISTOPHER KURWIE - 6 - Task 3 11PS ...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. OCR Nationals Unit 21 - Task 8

    - Magic Wand tool With the Magic Wand tool I clicked on the background of the picture, and then it enabled me to delete it, which I did, leaving me with just the shuttle. This is what I was left with: Just the shuttle is left courtesy of the Magic Wand Tool.

  2. System requirements analysis

    change fail Re-record macros, but this time, whilst recording macros, change the doctors name as well. 2 Appointments page: combo boxes Change of name for each address, DOB etc. Day and doctor combo boxes do not work, when you click on a certain day, the date does not change, but the name changes according to the postcode.

  1. I suppose that without the help from the above technologies and other technologies, Mr ...

    Secondly, using the integrated 802.11b/g wireless networking, Mr Potts is able to connect to the Internet and access his email. He is also able to connect Bluetooth peripheral such as headsets or keyboards. He is also able to use applications like Word, PowerPoint and Excel Word, PowerPoint and Excel on his PDA using Microsoft Office Mobile.

  2. Design Section

    I am using Microsoft Excel because; * Ease of data storage and editing - I shall need to save quite a lot of data to the computer e.g. (customers details) * Spreadsheets function - I will need an Spreadsheet to record details of the customers and for the project to show the company e.g.

  1. How important was the aim of reducing the burden on the ratepayers in the ...

    England's economy and society began to be transformed as population increased, increased industrialisation required greater mobility of Labour and changes in land structure and the character of farming taking place. From the 1790's onwards there were individual parishes responding. In 1789, the outbreak of the French Revolution produced shockwaves which

  2. The task that I am going to provide a solution for is to produce ...

    The insurance also offers an extra driver criterion, which can be added at an increased cost. Thomas then offers a discount to the customers if they have had no claims varying from the past year or five years. Thomas then calculates the quote by multiplying the basic cost with all

  1. GCSE I.T Analysis

    at a time whereas when using a computerised system many people can see the data all at once. When using this system extra staffs are needed to administer the program. Using a computerised system solves many problems and there are many advantages to it.

  2. We are neither impressed nor shall we be honoured, your majesty

    Even then, she does not do the job herself. The list is prepared by officials at number ten. Cloaked in mystery, the whole process used to be a top secret happening. More recently there have been many attempts to publicise the honours. For the 2004 New Year's list nominations the public contributed a higher number of nominations than ever before.

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