sociology
UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS
General Certificate of Education
Advanced Subsidiary Level and Advanced Level
9713/02
APPLIED INFORMATION AND COMMUNICATION TECHNOLOGY
Paper 2 Practical Test A
May/June 2008
2 hours 30 minutes
Additional Materials:
Candidate Source Files
*0000000000*
READ THESE INSTRUCTIONS FIRST
Make sure that your Centre number, candidate number and name are clearly visible on every printout, before it is sent to the printer.
Carry out every instruction in each task.
Before each printout you should proof-read the document to make sure that you have followed all the instructions correctly.
At the end of the assignment put all your printouts into the Assessment Record Folder.
If you have produced rough copies of printouts, these should be neatly crossed through to indicate that they are not the copy to be marked.
The number of marks is given in brackets [ ] at the end of each question or part question.
This document consists of 4 printed pages.
IB08 06_9713_02/3RP
© UCLES 2008
[Turn over
2
You work as an ICT consultant for the Tawara Beach Hotel. You are going to analyse the details of the hotel’s mini-bus services.
1 Using a suitable software package, open the file J8BUS.CSV
2 Insert 4 new rows at the top of the worksheet.
[1]
3 Place these labels in the correct cells:
•
Delays in cell A1,
•
Average in cell A2,
•
Maximum in cell B2,
•
Long in cell C2.
[1]
4 In the Late column, enter a formula to calculate the number of minutes by which the bus was late. This must be displayed in a 00:00 time format. If the bus was early this should return 00:00
[4]
5 In the Minutes column, enter a function to calculate the minutes by which the bus was late as an integer value.
[2]
6 In the Route column, enter a formula to extract the route number from the Bus Code. The route number is the third character of the Bus Code
[4]
7 In the Passengers
General Certificate of Education
Advanced Subsidiary Level and Advanced Level
9713/02
APPLIED INFORMATION AND COMMUNICATION TECHNOLOGY
Paper 2 Practical Test A
May/June 2008
2 hours 30 minutes
Additional Materials:
Candidate Source Files
*0000000000*
READ THESE INSTRUCTIONS FIRST
Make sure that your Centre number, candidate number and name are clearly visible on every printout, before it is sent to the printer.
Carry out every instruction in each task.
Before each printout you should proof-read the document to make sure that you have followed all the instructions correctly.
At the end of the assignment put all your printouts into the Assessment Record Folder.
If you have produced rough copies of printouts, these should be neatly crossed through to indicate that they are not the copy to be marked.
The number of marks is given in brackets [ ] at the end of each question or part question.
This document consists of 4 printed pages.
IB08 06_9713_02/3RP
© UCLES 2008
[Turn over
2
You work as an ICT consultant for the Tawara Beach Hotel. You are going to analyse the details of the hotel’s mini-bus services.
1 Using a suitable software package, open the file J8BUS.CSV
2 Insert 4 new rows at the top of the worksheet.
[1]
3 Place these labels in the correct cells:
•
Delays in cell A1,
•
Average in cell A2,
•
Maximum in cell B2,
•
Long in cell C2.
[1]
4 In the Late column, enter a formula to calculate the number of minutes by which the bus was late. This must be displayed in a 00:00 time format. If the bus was early this should return 00:00
[4]
5 In the Minutes column, enter a function to calculate the minutes by which the bus was late as an integer value.
[2]
6 In the Route column, enter a formula to extract the route number from the Bus Code. The route number is the third character of the Bus Code
[4]
7 In the Passengers