PHS CyberSchool

Computer Studies SG Grade 12 - 2006

Last updated 12 Dec 2006

Practical examination September 2006 - 3 hours 

• Rename the exam folder YourSurname0612Sept
• All the files necessary for the exam will be in this folder.
• Save all your work in this folder.
• Only do what is required and nothing more.
• Save your work on a regular basis.  

The grade 12 learners annually attend the Klein Karoo National Arts Festival. The tour leader has asked for your assistance with the planning of the excursion. The planning is done for ten days and nine nights

QUESTION 1 SPREADSHEET - 39 marks

Certain calculations must be done on a spreadsheet. Open the spreadsheet QU1 and save it as YourSurnameQU1.

1. Include your exam number or surname (left) and the question number (right) in a page header. 
2. An example of the final spreadsheet appears in the Appendix to Question 1. You may use the answers but will only be marked on the use of formulaes.

Changes - 3 marks

Now bring about the following changes:

1. Column width: Wide enough for the data to be seen. (1)
2. Wrap text of all the sub headings, bold and centred vertically as well as horizontally. (1)
3. Type the following in the relevant cells as in the example: (All cells with ? must get data)
   • A1: Financial planning for KKNK - 7 to 14 April (Bold and 16 pt), Merge cells A1 to H1 and centre the heading. Place a border around the heading. (1)
   • F2: 20
   • G2: 40
   • H2: 60

Accommodation - 3 marks

In column B it is indicated maximum number of persons that can be accommodated in each type of accommodation. For each type there is a fixed amount payable per night (column C) plus a further amount per night per person (column D).

1. F4: Make use of a formula and absolute cell reference to calculate the cost for 20 persons for one night in the tents
   • First get the number of units = (number of persons in group)/(number of persons per unit) [Rounded]
   • Now get the amount payable per unit: Multiply the previous answer by unit cost per night.
   • Now add the amount per person per night: Number of persons multiplied by cost per night per person.
   • Multiply everything by the number of nights.
   • And here is the correct formula =(ROUND($F$2/B4,0)*C4+$F$2*D4)*E4
2. F5 to F7: Copy this formula to cells. (1)
3. G4 & H4: Do the same for 40 and 60 persons and copy the formulae again. (1)
4. Change the colour to red (bold) for the best option for accommodation for each size group. (1)

 Transport - 6 marks

A choice must be made between three different sizes of buses. In column B it is indicated the maximum number of passengers that can be transported in each type. For each type a fixed amount is payable for the hire of the bus (column C) plus a further amount per kilometre (column D).

1. F10: Make use of a function and absolute cell reference to calculate the cost if 20 persons must be transported by kombi.
   • First get the number of vehicles needed: = (number of persons in group)/(number per vehicle) [Rounded]
   • Now get the amount payable for the hire of the vehicles: Multiply the previous answer by: (basic hire once + hire per kilometre x number of kilometres) (3)
2. Copy the formula to cells G10 and H10. (1)
3. F11 & F12: Do the same for the larger vehicles and copy the formulae to cells G11 to H12. (1)
4. Change the colour to red (bold) again for the best option for transport for each size group. (1)

Food - 6 marks

Accommodation does not include meals. There are two options: Buy food every day or Supply it. The estimated amounts per meal for each option are given in columns C and D.

1. F15: Make use of a function and absolute cell reference to calculate the cost to supply food for the group of 20.
   • First add the amounts for the three meals of one day.
   • Multiply this answer by the number of days
   • Now multiply everything by the number of persons. (3)
2. Copy the formula for 40 and 60 persons. (1)
3. F16: Do the same to calculate the cost if the group must buy food every day. (1)
4. Change the colour to red (bold) again for the best option for meals for each size group. (1)

Recreation - 5 marks

1. The group will get the opportunity to attend four different productions. The prices for single tickets are given.
2. F19: Make use of a nested IF-statement and absolute cell reference to do the following calculation: Discount is given for group reservations according to the following criteria:
   • 50 or more in the group: 10%
   • 26 - 49 in the group: 5%
   • 25 or less in the group: Pay the full price.
   If the group is larger than 50, Multiply the total cost by the number of persons and then by 0.9 Otherwise if the group is still larger than 25, multiply by the number of persons and then by 0.95 Otherwise multiply by the number of persons. (3)
3. Copy the formula to G19 and H19. (1)
4. Change the colour to red (bold) in cells F19 to H19. (1)

Final calculations - 5 marks

1. F21 to H21: Make use of formulae to add all the best options for each size group. (1)
2. F22 to H22: Make use of a formula to calculate the cost per person for each size group. (1)
3. Change the colour to red (bold) for the ideal group size. (1)
4. All amounts must be formatted as currency (R). (1)
5. Show gridlines for cells A2 to H22 as well as F2 to H2 as in the example. (1)

Charts - 8 marks

1. Create a column chart in which the cost for the different types of accommodation for the different group sizes is shown. (1)
   1. Chart heading: Accommodation (1)
   2. Label for X-axis: Group size (1)
   3. Legends must be shown. (1)
2. Create a line chart in which the cost of the different types of transport for the different group sizes is represented. (1)
   1. Chart heading: Transport (1)
   2. Label at X-axis: Group size. (1)
   3. Legends must be shown. (1)

Summary - 4 marks

Make a summary of the best option expenses for a group of 40 at the bottom of the spreadsheet. 

1. Copy the relevant amounts to cells B25 to B30 so that the contents will automatically be corrected if any changes are made to the existing spreadsheet. (1)
2. Create a pie chart in which it is indicated what portion of the expenses for this group goes to each commodity.
   1. Chart heading: Expenses for group of 40 (1)
   2. No legend must be shown. (1)
   3. Labels as well as percentages must be shown on the chart. (1)

   [39]

QUESTION 2 DATABASE - 27 marks

Open the database KKK. 

Make the following queries from the table Details - 14 marks

1. Paid less than R500 
   1. Show only the records of learners who at this stage have paid in less than R500. 
   2. Include and show the following fields: Name, Amount_in and all the particulars of parents. 
   3. Sort  the records in alphabetical order according to the names of the learners. 
   4. Save the query as 1 Less than R500 (2) 
2. Indemnity form 
   1. Show only the following fields for all learners who have not yet submitted an indemnity form. Name of learner, name of parents, telephone number, name and number of medical aid. 
   2. Save the query as 2 No form (2) 
3. Special request 
   1. Show the following fields for all learners with some or other special request: Name and date of birth of learner, name and telephone number of parents and the request. 
   2. Save the query as 3 Request. (2) 
4. Outstanding 
   1. Create a query to show the name Name, Amount_Total and Amount_in and the Amount_Outstanding  
   2. Show only the names and outstanding amount of all those who still owe something. 
   3. Save the query as 4 Outstanding (2) 
5. Age 
   1. Create a query which will calculate the age of the learners. 
   2. Show only the name of the learners, date of birth and age. 
   3. Save the query as 5 Age (2) 
6. Forms in 
   1. Create a query to show the numbers of forms in or not returned. 
   2. Show the totals returned or not returned. 
   3. Save the query as 6 Form summary (2) 
7. Birthday 
   1. Create a query to calculate which learners will be having their birthday during the festival. The dates of the festival are Saturday, 7 April to Sunday, 14 April. 
   2. Show the names of the learners and their birthdates. 
   3. Save the query as 7 Birthday (2) 

Report - 10 marks

Create a report using the table Details. 

1. The following fields must NOT be included in the report: - ID, birth_date, total amount due, parents details, form_in and request. 
2. Group the report according to the name of the medical aid and sort the records alphabetically according to the names of the learners in each group. (2) 
3. Add a summary for each group indicating how many people belong to each medical aid. (2) 
   1. At the end of the report the following summary must appear: 
      1. Number of persons in the touring group. (2)
      2. Total amount paid in by the whole group. (In Rand and cent) (2) 
      3. Average amount paid in by each learner. (In Rand and cent) (2) 
4. Save the report as Details. 

Switchboard - 2 marks

1. Create switchboard and command buttons which will open the:
   1. Query showing the age of the learners. (1)
   2. The report Details (1) 

Opening - 1 mark

1. Do something to the database so that it opens at the switchboard. (1) 

[27]

QUESTION 3 WORD PROCESSING - 20 marks

The secretary had to type the indemnity form. Unfortunately she made a mistake and saved it as a text file. You are asked to help format it to appear as the example again. Look at the Appendix to Question 3.

Retrieve the text file QUEST3. Change the filename to YourSurnameQU3 and save it as a WORD PROCESSING document. Now bring about the following changes as indicated on the attached example: 

1. Page size: A4 (1) Margins: Top, bottom, left and right: 2.5 cm (1) 
2. Font: For the whole document: Arial 12 pt (until other instructions) (1) 
3. Alignment: Justified (1) 
4. Single line spacing (until other instructions) (spacing before and after paragraphs).  (1) 
5. Type your exam number or surname left and the question number right in the page header. (1) 
6. Centre the main heading in capital letters and 18pt (Name of the school). (1) 
7. Centre the sub heading in capital letters and 16 pt (Indemnity form). (1) 
8. Place a border around this section as in the example. (1) 
9. Replace all occurrences of "parent" with "parent/guardian" and "course" with "tour". (1) 
10. Set your own tabs with leaders to form the lines. (1) 
11. Set your own tabs above the words SIGNATURE OF PARENT/GUARDIAN and DATE as in the example. (3) 
12. Change the section (Mention here ......) to 11 pt and italics. (1) 
13. Make use of numbered bullets at the bottom section of the document. Position of the bullet at 0.5 cm and text to follow at 1.5 cm. (1) 
14. Align the section on the medical aid and text that follows indented at 1.5 cm. (1) 
15. Add the last paragraph by copying it from the text file INSERT_TEXT. (1) 
16. The whole new paragraph is in Arial 11 pt, justified and italics. (1) 
17. Change the line spacing to 1.5 for the sections, which have to be filled in. (1) 
18. Everything must still fit onto one page. (1) 
19. Save the final version.

[20] 

QUESTION 4 INTEGRATION - 6 marks

Open the file QU4. Save the files as YourSurnameQU4. 

1. Copy only the summary of the spreadsheet QU1 to the location as indicated in the example. (2) 
2. Include the correct fields from the table Details in the database and create form letters for all the learners going on tour. Save the file. (2) 
3. Merge your letter and save it as YourSurnameQU4Merged (2) 

[6]

TOTAL [92]