Create a spreadsheet, which quick and easily adds up the points into a table just by typing the finishing positions into one of the sheets.

Authors Avatar

Major project

Introduction

For the last 6 years I have been driving karts in the national championship, I have moved up through the junior ranks and am now into my last year of junior karting at the highest level of 100cc J.I.C.A. racing before moving into the senior karting classes next year. I have noticed that although the results for each race are recorded off transponders, arranging them into points and championship order can be very slow and in accurate. I plan to create a spreadsheet, which quick and easily adds up the points into a table just by typing the finishing positions into one of the sheets. The system will automatically change the scores for points and place them into a table with points order. I will be able to broadcast this onto the Internet with a site I shall create. I will then ask people who want the scores to each event to sign up, they will then be added to a mailing list and will have the results posted to them each time they are amended. I could also use this site to advertise for some sponsors. If enough people where to visit I think it would be worth wile the sponsors advertising on my site.

Analysis

For me to be able to analyse each task successfully I will have to read the booklet carefully deciding what the tasks are, that I need to analyse and how many of the tasks there are.

There of course many small problems which go together to make the big problem these problems are as follows.

  1. System to create a drivers championship

  1. use a database to create a mailing list

  1. A4 sheet to display the championship table


Problems

This sheet shows an explanation of all the problems, I will demonstrate what exactly it is that I plan to do in a short account for all three

Task1

System to create a drivers championship

Problem

I must create a championship table using a computer program that I have at my disposal. The reason for my doing this is that over the past few years of karting that I have been involved, the organisation of karting has improved with the introduction of computers, but still the scouring is done in an insufficient way were as the scores are taken down by hand and then just simply typed out on the computer.

My aim is to create a system to score a championship simply by typing in the finishing position of each driver. The number of points for each finishing position will already be stored in the computer and just by typing in the finishing position, the computer will work out which driver has how many points and the computer wil then sort the scores out into the order of the highest scoring person first in the table.

Task2

Database mailing list

Problem

For my second task I will create a mailing list of all the drivers taking part in each championship, after each round in the race calendar I will send the amended results to each of the people involved in that particular race. I will have to use filters to decide  and make sure that I send he right table to the right driver at the right time. With there being over 200 drivers involved in each championship, sorting the correct table and sending it to the correct drivers may be quite a complicated task to do.

Task3

Desk top publishing

Problem

As my final task I shall use a desktop publishing program to create a distinctive piece of paper which displays the championship table, which I will have already created, so that it is easy to read and stands out. I will then use my database mailing list to send out the right number of copies required to each driver.

Join now!

Analysis

Task1

System to create a drivers championship

For me to be able to complete this task I first must analyse the points that will need to be output and the points that will need to be input.

Information to output

  • Various A4 sheets for each class showing the championship in the order of points: this should contain the number of drivers in each class, the drivers race numbers, the points they have scored at each round and the total number of points scored by each driver.
  • The round at which the points ...

This is a preview of the whole essay