• 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
• Level: GCSE
• Subject: ICT
• Word count: 1521

# Adventure quest information Analysis - At the present they have a database and a spreadsheet to help them organise the whole park.

Extracts from this document...

Introduction

Middle

5.3 Enter a formula to calculate the total load-time for each ride. 5.4 The formula will use the value in ''Load-time per person'' cell (using an absolute cell reference or a named cell). 5.5 Use another column to add the load-time to the run-time to give the total ride time for each ride. 5.6 Sort the spreadsheet. Make sure that all columns are correctly sorted. 5.7 In a suitable cell, enter a formula that uses a function to calculate the average number of people waiting at any time. 5.8 Format the cell to numeric, 0 decimal places. 6.The new system should be able to produce charts showing all the information to be included in reports. 6.1 Use the spreadsheet to create a suitable bar/column chart on a separate sheet. 6.2 Legends should not be used. 6.3 The title, axis and label should be added to graph 2.5 System requirements Hardware requirements Input devices Output devices CPU (central processing unit) Storage Keyboard Mouse Scanner Printer Monitor Pentium III -1 giga hertz 512 Mega bytes memory 1.44 Mega byte floppy 20 memory bytes hard-disk Software requirements Objectives Software use 1,2,3 A database is simply a collection of data. The data could be kept in a card index file, in a filling cabinet or on a computer. There are many software packages that allow a user to create an electronic database that holds data in a convenient way. ...read more.

Conclusion

Field Name Data Type Length/Format Booking Num Text 5 Cust ID Text 7 Date Date/Time dd/mm/yyyy Event Code Numeric 3 Guests Numeric Integer Arrival Time Date/Time hh:mm Deposit Paid Currency � sign 0 d.p. Staff ID Text 4 Screen Input forms Bookings input form Bookings number Customer ID Date Event Code Entity Relationship diagram On EVENT can be booked many times, the relationship between EVENT and BOOKINGS 3.2 Screen input forms Objectives 1,2 and 3 EVENTS Table BOOKINGS Table Field Name Data Type Length/Format Event Code Text 3 Event Type Text 20 Age Text 8 Venue Text 20 Max Number Numeric Integer Min Number Numeric Integer Cost per head Currency � sign 2 d.p. Field Name Data Type Length/Format Booking Num Text 5 Cust ID Text 7 Date Date/Time dd/mm/yyyy Event Code Numeric 3 Guests Numeric Integer Arrival Time Date/Time hh:mm Deposit Paid Currency � sign 0 d.p. Staff ID Text 4 3.3 Spreadsheet design Objectives 4,5 and 6 One EVENT can be booked many times, the relationship between EVENT and BOOKING is one-to-many. EVENT is on the one side of the relationship and the BOOKINGS are on the other side. Section 4 Implementation Database (task1) To create a BOOKINGS table (to include: bookings number, Additional Requirements 1) Create a chart showing in % the amount of time people spend on a ride (loading/ride times) 2) Search for all adult events. Display cost per head Deposit Event Date of events 3) Additional IF statement That checks if waiting times are reasonable or unreasonable ...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

# Related GCSE Software essays

1. ## Design a spreadsheet that can be used by a school tuck shop.

I then checked to see what happened to spreadsheets further along in my workbook and this is what I found happened: * The Profit cell changed its function and added in the extra row and so found a new total including the new product line.

2. ## ICT BTEC UNIT 2 - REPORT

Graphics Card = GeForce 8800 ultra Monitor resolution = 1280 * 1024 RAM = 1Gb Some of the advantages for adobe premier pro are as follows: you can create some of the most high tech and up to date DVDs including blu-rays and HD videos.

1. ## Planning a spreadsheet database for a gun shop.

adding 5 If Calculations are right Test the calculation by observing if the answer is right. Answer should be right. Burma Road Birmingham Bra 4bb Tel: 06531234321 Dear Mr Butt I would to say well done to you for your hard work I received your final design and I would

2. ## AQA GCSE ICT Specification B

Refinements A setting in the options pane allows a window to automatically close when a new one opens. Criteria 4 Criteria Details All text should be at least font size 10. Evaluation The criterion was only partially met; all text was at least font size 10.

1. ## In the following report, I will describe, using screenshots, the advanced features of Microsoft ...

that I required to print and selected 'Print' from the 'File' menu, which opened up the print dialogue box, below. From this dialogue box I chose 'Selection' as the whole sheet was not required to be printed. I then clicked 'Ok' and when this dialogue box disappeared, I clicked on the 'Stop Recording' button from the recording icon, shown below.

2. ## Documentation of a database for a sports centre.

Design Queries are used to look for the data within your database. They are also used to select data to be displayed in a "Form" or "Report". At times the results from a query are exported for mail-merge purposes. Query design should make it understandable to what data fields are

1. ## Evaluating a relational database solution

When I selected what query I wanted to use I then decided which fields I wanted to display in my output designs. This was easy as all I had to do was 'tick' or 'untick' the 'show' row in the query 'design view'.

2. ## computerised spreadsheet for pupil attendance data

Security is provided by making sure there are safeguards to ensure that data is not accidentally or maliciously corrupted. All the user will be able to do is enter the appropriate information in the right sections. The only person who will have total access to all areas both the users

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