• 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
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  • Level: GCSE
  • Subject: ICT
  • Word count: 3000

GNVQ intermediate ict unit 4

Extracts from this document...


GNVQ ICT Unit 4 Report Unit 4 Project proposal Jermaine Carthy Project Title Athletics Championship scoring system The purpose of this project is to meet the needs of the person I am going to talk identify below. My description of what the user needs: My user keeps the scores at an athletics championship. At this point of time the scores are kept on paper this can be a problem because the paper can be easily lost and damaged, it is difficult to make back up copies because of it been on paper. This also results in calculating manually, so this slow down the process and may result with inaccurate information. What I am going to do about this is replace this system with an electronic one where all the function/calculations will be taken place on a PC or a lap-top. This piece of hardware will need to be able to run excel 2000 or any other excel preferable a later version. Also it will need to have the capacity to save and back up these system files I create. Furthermore it will need a printer to print out graphs of the information that is created. There is a need to print out graphs because information is easier to comprehend and the graphic presentation will make a quick analysis easier for the coaches and the organisers of the championship. As the user might not have a lot of knowledge of ICT I will create a user guide to help them through the process of scoring using this system. The user is going to need a keyboard, monitor and a processing unit in addition to the storage devices. ...read more.


My prediction is that the final scores are going to change and it will be more competitive with all the teams and will have closer results. The screen dumb, of my spreadsheet before I changed the scores is shown below. If you look at the spreadsheet you can see that "South" won the championship. In the screen shot below you can see that the competition was much harder and that the results were much closer as I predicted. This was because I changed the "Points Grid" (shown on the table below) from 12, 9, 5, 1 to 5, 4, 3, and 2. How I ensured that my work was safe I have saved all my original files in my user area under Unit 4 folder in the schools network system (shown above). I saved my files on to my memory stick as my back up copy (shown above) How I created the interface First of all I renamed the three sheets in my workbook as Input, Interface and Graph. I then highlighted the whole Interface sheet by going in between the blank cell of A and 1 and went to Format- Cells- Patterns and chose a pale colour and clicked OK. Then I went to cell B2 and holding the mouse button down highlighted all the cells from B2 to F3. Next I went to the merge cells button (shown below) in the toolbar and clicked it. Merge cells button I then highlighted the same area and formatted it a different colour. In cell B4 I typed the words "Type the name of the event in the box above". ...read more.


Some new things I learnt were how to create a spreadsheet, as I had never done such a complicated one before. The hardest thing to do and understand was the teaching because we went through the project very quickly because we had to do it in a certain amount of time. The easiest thing was screen dumping, although it had to be re-formatted so that the screen dumps could be kept in the place I wanted it. The macros were a new thing for me and I had to have a few goes to make them work. Doing one macro meant I got the hang of it and the others were much easier. Testing the system was straightforward and I had understood most of the problems that occurred, as I was making the system and in the formal testing. At the end of it all worked out well. The good points of the spreadsheet are doing the formulas, I had trouble with the "MATCH" formula and had to insert it several times into the cells to make it work but the others worked fine. If I did this project again with more time, I would put a password on the file to protect it and may also use hidden files. I will then lock out the user from the formulas so they can't change them. Furthermore I would make it easier for the user to use the spreadsheet by producing a more illustrated/ simpler user manual. Other ideas I had would be to give a choice of graphs to the user and perhaps print out individual team scores from a new grid I would have created. ?? ?? ?? ?? Unit 4 By Jermaine Carthy/Ernest Bevin Collage ...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


    However the disadvantages of this design are that is quite basic and unprofessional. Design Two Here is my second design is similar to my first design, but with a few slight changes. One of the advantages of this design is the new font which looks nice and attractive.


    Windows XP professional 300Mhz central processor 64Mb RAM 1.5 GB free HDD space CD-ROM or DVD drive Advantages are that it is laid out in the sense that files are easily found and it is not to complex system so if you're a beginner you might find this system a

  1. AQA GCSE ICT Specification B

    I will regularly ask the staff about their views on the system, if there's anything that can be improved, etc. Evaluation I will compare the requirements laid out at the start to the end result and establish whether or not the project was a success.

  2. Unit 4 Multimedia -Review for Product 1 KS3 Strategy Presentation

    In the text, the titles and sub-titles are in green, the normal writing has been written in black. The good features for this is that it does look professional and suitable for the target audience, it doesn't have too many colours.

  1. The aim of my project is to make the task of the allocation of ...

    In my model it is used to calculate the show that has been used so that in the event of a certain show it will use the correct price. Vlookup The VLookup is used to "look up" the price for the show that is being performed.

  2. Project 1a. ICT

    In later years when I have grown older I want to produce many different story booklets for the younger generation. These booklets will consist of different stories at different levels. This first booklet 'Bill and Ben the Flower Pot Men's Futuristic Adventure to Space' is only one of the many books I will hope to produce.

  1. Payments Spreadsheet task. - formulas and fomatting

    If the price of the adult is the same as the child, than you workout the cost per child by calculating, 80% of the adult's price. So you take the adult's price divide it by hundred and multiply it by 80 which will give you the cost per child.

  2. Graphics Review - Unit 21 OCR

    Impact: Gives the advice endorser's name - in this case RAC (a big name in terms of car tips, insurance, etc...), increasing the probability of a person clicking. The isolated region makes the viewer question themselves if they were in such a situation. Size: Small - does not restrain bandwidth.

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