• Join over 1.2 million students every month
• Accelerate your learning by 29%
• Unlimited access from just £6.99 per month
Page
1. 1
1
2. 2
2
3. 3
3
4. 4
4
5. 5
5
6. 6
6
7. 7
7
8. 8
8
9. 9
9
10. 10
10
11. 11
11
12. 12
12
13. 13
13
14. 14
14
15. 15
15
16. 16
16
17. 17
17
18. 18
18
19. 19
19
20. 20
20
21. 21
21
22. 22
22
23. 23
23
24. 24
24
25. 25
25
26. 26
26
27. 27
27
28. 28
28
29. 29
29
30. 30
30
• Level: GCSE
• Subject: ICT
• Word count: 3704

# ICT AQA 2006-2008 Problem 2, Theme Park Software

Extracts from this document...

Introduction

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.

Middle

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.

Conclusion

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

# Related GCSE ICT Systems and Application essays

1. ## Different types of technology How I use ICT at home and at school

The ability to share files is also extremely useful. If I really need a song and my friend has it, he can use MSN to send it to me. He can also send me other things such as photos, videos and games. If I'm having trouble with some work, he can send me an example in which would give me a clearer understanding.

2. ## Test Plan for Software

- Numeric only Enter an extreme or erroneous data to test the validation it should prevent the action from taking place and trigger a message informing the user that the Value should only be in the range and numeric only 17 Validation: for the field, Contact Number - It should

It has become an integral* part of their life. Almost all of the families & organisations have access to the Internet & other technology available through ICT. Through ICT an individual can benefit from many services such as online banking, online shopping, email, chat online with distant friends, search for relevant files & materials & also store personal details with security.

2. ## GCSE Excel Project ICT

However there is an immediate problem, as it is covered by the button the user is not able to input the value, however the idea of the scheme is that the user will not input the value but the buttons (attached to macros)

1. ## ICT Coursework (MarcoS)

* First of all insert by typing in, the heading on the cells like, Customer, Select customer, Tel, E-mail, Project, Name, Size, Type, Bedroom, Floor. See picture. * Also you need to add the macro buttons as shown in figure, except the macro called in the picture "Audit Transfer".

2. ## GCSE ICT Coursework Write-up

Alternatively, you can click on the up and down arrows on the right hand side of the box to change the number of rows. 6. Click on the "OK" button at the bottom of the box or press "enter" and the table will appear.

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

She can connect socially with old friends, re-unite with people she hasn't seen in a while and make lots of new friends. Facebook has become a web of socialising. The need to socialise outside of the virtual world is eliminated whether that causes a negative or positive effect on our current generation has no impact on meeting Sarah's needs.

2. ## Ict Powerpoint Coursework

I am going to include only 2-3 images in each slide as this is what the majority of respondants voted for. My Final Design The final designs would include 9 slides made with Microsoft PowerPoint; the slide will include the information shown below: Slide 1: The front page includes the logo of S.A.

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