• 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
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  • Level: GCSE
  • Subject: ICT
  • Word count: 3704

ICT AQA 2006-2008 Problem 2, Theme Park Software

Extracts from this document...


Introduction Page 3 Software Justification Page 4-6 Software Final Choice Page 7 Hand Drawn Plan 1 Page 8-9 Sheet 1 Page 8 Sheet 2 Page 9 Evaluation of Hand Drawn Plan 1 Page 10-11 Sheet 1 Page 10 Sheet 2 Page 11 Hand Drawn Plan 2 Page 12-13 Sheet 1 Page 12 Sheet 2 Page 13 Evaluation of Hand Drawn Plan 2 Page 14-15 Sheet 1 Page 14 Sheet 2 Page 15 Testing Plan Page 16 Implementation Page 17-21 Testing Page 22-26 Table Page 22-23 Screen shots with references and explanations Page 24-28 Evaluation Page 29-30 Texts Page 29 Table Page 30 Main Presentation Page 31-34 Sheet 1 Page 31 Sheet 2 Page 32 Sheet 1 showing formulas Page 33 Sheet 2 showing formulas Page 34 Introduction I again have been given the role of Bernie, however I have been given another problem to find a solution to. I need to create a system for Barry, who is currently responsible for marketing and he wants some help with working out costs for his latest idea of creating DVDs showing the different attractions at the park. There are going to be two different types of publicity packs, one being the standard pack and the other being the ticket agent pack. I will need to create two hand drawn designs before starting to create the actual system. This will help me to use the best and most simple layout while creating the formulas that I will need to use. Consequently I will need to evaluate my designs, and then go to choose the correct software to use, after my choice I can begin to produce the system. Design Section In this section of the tasks (problem 2) I have been asked to produce a system which will explain and work out the details of selling such items as DVDs in packages. There are two different types of packages which I will have to find out the cost of producing. ...read more.


Similarly I will be explaining formulas and formula references and text types/styles. I will also be justifying my choices for font colours, effects such as bold, italic and underline, plus the use of special operation, for instance the references to different sheets (='Sheet 1'! followed by the cell reference.). Layout; on this sheet I am going to show raw calculations while still trying to keep a simple look. I have kept the upper half for the standard pack and the lower half for the ticket agent pack calculations. I will resize the columns so that the text and numeric data fits into the cell. I will want to keep the data clear and allow for the data to be adapted just in case the costs change. Formulas; I will be using more complex formulas in this section as I will need specific cell data from the previous sheet. Also since I have renamed the sheet it self the reference needs to include the new name for the sheet. However despite the multifaceted formulas the way it is laid out means that the final appearance makes it easier to understand. Text; Again like the pervious sheet I want to use a simple font and colours to make it more comfortable to the eye and so it is easier to change data just in case of modification of costs. Evaluation of Hand Drawn Plan 2 Page 1 of 2. As I did in the pervious evaluation of hand drawn design 1 I will have to analyze the content as well as the overall appearance keeping in mind the cell references and formulas which are vital when working out the costs as they have to be extremely accurate. I will also justify all effects put on text and backgrounds. Layout; Rather than splitting the data up into two sections I will just keep all the data on one sheet. ...read more.


Has the cell been formatted correctly? (If yes there is no problem and should come up with correct answers) Round up the number of people paying for the full entry fee I have formatted the cell so the total is rounded. Rather than 31.30 coming up only 31 shows, this proves it is correct. 9 To see if correct results are outputted. The final formula is correct, and all steps have been followed correctly. Must show amount of people needed to cover costs This is also correct as shown in the screenshot. Screenshots These are the screen shots to match the testing grid above. Test No. Screen shots 1 2 3 4 5 6 7 I cannot show a screen shot for this, but by comparing data in the table above with the data given in the booklet, I can prove that the answers are correct and that all procedures have been taken to produce correct answers. 8 The actual answer would be 31.20, but I have rounded it to the nearest whole number, which shows as 31. 9 Evaluation Now that I have finally completed the task in hand I can go through an overview of the stages. My initial task was to create a system for Barry, who is currently responsible for marketing and he wants some help with working out costs for his latest idea of creating DVDs showing the different attractions at the park. The job itself demanded concentration as the formulas needed precise references to get accurate results otherwise consequently the output would be negative. However now that I have completed it all and it all fits in I could have improved and refined a few minor details such as the spacing between the tables and grids. On the next page there is a checklist showing what I did correctly and what needed to be refined, also if it was done correctly. Item Was it done correctly? What could be improved? Must show all costs. YES Validation YES I could have refined the message rather than put in a simple error code for the validation rule. ...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. Different types of technology How I use ICT at home and at school

    This can lead to being abused or assaulted in real life, having data or my identity stolen, having my details stolen and other things. MSN need to give a better awareness to kids of the dangers it holds. Another danger that can happen through MSN are viruses .MSN is full

  2. Advantages & disadvantages of ICT

    Robots reduce the need for human labour (people can lose their jobs). Robots are not well suited to tasks that require initiative or flexibility. Many business people like to meet the person they are dealing with face-to-face. It seems important to shake a person's hand and observe body language (their vibes).

  1. The use of ict has changed the way in which people work. Explain the ...

    The is where the plastic card is inserted and must be inserted the right way round. The amount of cash that the customer required is released here.ATM Used by many people when banks or closed or there are queues inside.ATM's allow people to;Get Cash outFind out balance in their account, Change PIN, Make Deposits e.g.

  2. The impact of ICT on a person with special/particular needs

    What the computer does for Sarah is essentially allows her to actually hold and maintain a job. In her state, finding a suitable and doable job would be near-impossible. However, with the computer allowing Sarah to work at home, it has been possible for Sarah to get a job.

  1. Computer Systems Assignment 2

    and Amazon let you type in a search straight from your desktop and it shows you on a little screen what has come up. You can have a gadget to produce your emails and you can have a performance gauge.

  2. Database Coursework

    Deleting customers within 1 minute: since deleting a customer needs no work at all, it should only take around 1 minute to delete a person's record. My system allowed me to delete a customer successfully, within 30 seconds with the click of a button.

  1. Introduction for a Software

    And since most of the coaches in NAME OF SCHOOL are teachers, it would be likely that they would have something else to worry about other then football which means they could forget how some players had perform in certain match.

  2. Test Plan for Software

    change the data in the field It should prevent the action from taking place and trigger a message informing the user that the value in the field should not be changed 16 Validation : for the field, Height - The value should be in the range of 140 to 200

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