Life Orientation (Ict Component)

EXEMPLAR -10- NC(V)/2009

LIFE ORIENTATION (ICT COMPONENT)

NQF LEVEL 4

(Second Paper)

2009

(********)

(X-Paper)

09:00 – 12:00

EXEMPLAR

CANDIDATES HAVE 15 MINUTES BEFORE THE SESSION STARTS TO READ THROUGH THE PAPER.

This question paper consists of 11 pages.

TIME: 3 HOURS
MARKS: 200
______

INSTRUCTIONS AND INFORMATION

1.
2.
3.
4.
5.
6.
7.
8. / Answer ALL the questions.
Read ALL the questions carefully.
Number the answers correctly according to the numbering system used in this question paper.
Ensure that your EXAMINATION NUMBER appears on all printouts.
Printouts to be marked must be arranged in the same order as that of the questions in the examination paper. Only hand in the printouts you want to have marked.
Printing time is included in the three hours allocated. No extra time will be given for printing.
The time indicated in brackets after each section heading is a guideline to be able to finish the paper on time.
Write neatly and legibly.
SECTION A – SPREADSHEET
BACKGROUND:
You are doing a research project regarding different climate zones. As part of your project you need to present the information you collected at your local library to high school students. Draw up the following summary of information to explain and compare different climate zones and related matters, using a spreadsheet program.
QUESTION 1A
Create a spreadsheet with the information as indicated below:
1. / Insert a header with your EXAMINATION NUMBER (left) and QUESTION 1A (right).
2. / Set all the page margins to 2.54cm/1"/10°.
3. / Use the font Arial, size 10.
4. / Centre the column headings.
5. / The Desert Rainfall (mm) column must be displayed with one decimal as indicated. ALL the other figures MUST be displayed as integers.
6. / Insert horizontal and vertical lines as indicated.
7. / Adjust the column widths to fit the contents.
8. / Preview your spreadsheet and ensure that everything prints on one A4 portrait page.
9. / Save the spreadsheet as CLIMATE.
10. / Print the spreadsheet without row and column headings (borders) and put the printout in your examination folder. / [16]
CLIMATE ZONES
╪
Month / Rainforest / Rainforest / Desert / Desert
Temperature
(˚C) / Rainfall
(mm) / Temperature
(˚C) / Rainfall
(mm)
January / 25 / 280 / 21 / 2.0
February / 28 / 200 / 26 / 3.0
March / 26 / 250 / 28 / 0.0
April / 26 / 240 / 30 / 0.0
May / 26 / 300 / 34 / 0.0
June / 26 / 230 / 36 / 0.0
July / 26 / 200 / 38 / 0.0
August / 24 / 180 / 35 / 1.8
September / 28 / 120 / 33 / 0.0
October / 28 / 150 / 25 / 0.0
November / 29 / 160 / 26 / 2.8
December / 26 / 140 / 23 / 5.0

QUESTION 1B

Retrieve the document CLIMATE and make the changes as indicated on the spreadsheet and in the instructions below:
1. / Change the question number in the header to QUESTION 1B.
2. / Bold and underline the main heading in row 1 and centre it over Column A to Column F.
3. / Change the font size of the main heading (row 1) to Arial 16.
4. / Change the appearance of the column headings to bold and italics.
5. / Insert the column 'Percentage Rainforest Rainfall' as indicated on the table.
6. / Add the 'AVERAGE TEMPERATURES' and 'TOTAL RAINFALL (mm)' rows as indicated on the table.
7. / Give formulae for the cells marked with letters of the alphabet. Use cell references and copy the formulae where indicated with the arrow:
A / AVERAGE TEMPERATURES = the average temperatures for the whole year. Display with 2 decimals.
B / TOTAL RAINFALL (mm) = the sum of all the rainfall for the year. Display as integer.
C / PERCENTAGE RAINFOREST RAINFALL = the rainfall for each month as a percentage over the total rainfall for the rainforest. Use absolute cell reference and display the answer as %.
8. / Insert the horizontal and vertical lines as indicated.
9. / Change the column widths to fit the spreadsheet on one A4 Portrait page. Do not use the ‘fit to page’ function.
10. / Make a pie chart to show each month’s rainfall for the Rainforest.
10.1 / Supply a suitable title for the chart and include your EXAMINATION NUMBER.
10.2 / Do not show the legend.
10.3 / Display the category name and value as well as the leader lines on the chart.
10.4 / Place the chart as an object in the worksheet, below the information table.
10.5 / Change the label fonts to Courier New 8 and move, if necessary' to have it neatly presented and legible.
11. / Preview your work before you print and make sure that the table and pie chart fits on one A4 Portrait page.
12. / Save the spreadsheet as CLIMATE 2 and print. Place your printout in your examination folder
CLIMATE ZONES
Month / Rainforest / Rainforest / Percentage / Desert / Desert
Temperature (˚C) / Rainfall
(mm) / Rainforest
Rainfall / Temperature
(˚C) / Rainfall
(mm)
January / 25 / 280 / 21 / 2.0
February / 28 / 200 / C / 26 / 3.0
March / 26 / 250 / 28 / 0.0
April / 26 / 240 / 30 / 0.0
May / 26 / 300 / 34 / 0.0
June / 26 / 230 / 36 / 0.0
July / 26 / 200 / 38 / 0.0
August / 24 / 180 / 35 / 1.8
September / 28 / 120 / 33 / 0.0
October / 28 / 150 / 25 / 0.0
November / 29 / 160 / 26 / 2.8
December / 26 / 140 / 23 / 5.0
AVERAGE TEMPERATURES / A / A
TOTAL RAINFALL (mm) / B / B
[32]

QUESTION 1C

Retrieve the document CLIMATE2 and follow the instructions below to create a line graph to compare the temperatures of the rainforest with those of the desert.
1. / The chart title should be:
COMPARISON OF RAIN FOREST AND DESERT TEMPERATURES
EXAMINATION NUMBER
QUESTION 1C
2. / Give the chart suitable titles for the X- and Y- axes.
3. / Show the legend at the bottom.
4. / The data label should include the Value.
5. / Place the chart as a new sheet.
6. / Preview your work before you print and make sure that everything fits in well and that everything is legible.
7. / Save the graph as CLIMATE3 and print only the line graph. / [11]

QUESTION 2A

Create a new spreadsheet with the information as indicated below:
1. / Insert a header with your EXAMINATION NUMBER (left) and QUESTION 2A (right).
2. / Set the margins to 2.54cm/1”/10°.
3. / Insert the Heading 'THE WATER CYCLE' in bold, underlined and font size 16 at the top centre of the page.
4. / Type the words: 'The water cycle is explained in the following diagram:' underneath the heading (left aligned).
5. / Insert a Cycle diagram into the worksheet. There should be place for THREE steps, namely:
'Step 1: Clouds form as air rises and cools'
'Step 2: Rain falls from clouds'
'Step 3: Water evaporates
6. / Change the format of the diagram so that the height is 8 cm and align it to the left below the text.
7. / Change the font of the 3 steps to Courier New 8.
8. / Insert a relevant picture (clip art) to the right of the cycle diagram. The height should be the same as the diagram.
9. / Open a word processing program and follow the instructions:
9.1 / Type the following text in your word processing program using font Comic Sans MS size 10.
9.2 / Save the document as DESERT. Do not print the word processing document.
9.3 / Copy the text into your spreadsheet program using the Paste Special function.
9.4 / Place the text box below the diagram and picture.
9.5 / Draw a thick border around the text and change the size of the box, if necessary, to fit the page.
Deserts get incredibly hot during the day because, with little water in the air, no clouds form to stop the sunlight from reaching the ground. At night, the lack of clouds in the sky means that any heat is lost quickly, making deserts extremely cold.
10. / Copy the relevant part of the table in QUESTION 1B (CLIMATE2) and paste it below the text (leave one row open). Do the changes and calculations as indicated.
10.1 / Move the column heading 'Month' as indicated on the table.
10.2 / Add the column 'Saving per Month' in bold, italics and centre it.
10.3 / Add the 'SAVINGS FOR THE YEAR', 'INTEREST', '5.5%' and 'TOTAL' rows as indicated on the table, right aligned.
10.4 / Use the following information to do the calculations as indicated on the table:
A farmer in the rainforest saves R150.00 a month on irrigation for every 100 mm of rain per month and decides to invest the money.
A
B
C
D / SAVING PER MONTH = R150.00 for every 100 mm of rain per month.
SAVINGS FOR THE YEAR = the sum of all savings per month.
INTEREST (5%) = 5% of the Savings for the year.
TOTAL = the sum of the Savings for the year and the Interest.
10.5 / All calculations should be displayed as currency with TWO decimals.
Month / Rainforest Rainfall (mm) / Saving
per
Month
January / 280 / A
February / 200
March / 250
April / 240
May / 300
June / 230
July / 200
August / 180
September / 120
October / 150
November / 160
December / 140
SAVINGS FOR THE YEAR
INTEREST
TOTAL / 5.5% / B
C
D
11. / Preview your work. Everything should fit on one A4 Portrait page.
12. / Save the spreadsheet as WATER and print. / [45]

QUESTION 2B

Create a spreadsheet with the information as indicated below:
1. / Copy only the table in QUESTION 2A (WATER) to the top of the new sheet.
2. / Insert a header with your EXAMINATION NUMBER (left) and QUESTION 2B (right).
3. / Hide Column B.
4. / Display the formulae for the Savings per rainfall table.
5. / Adjust the column widths to display all formulae.
6. / Save the spreadsheet as WATER 2 and print. / [6]
TOTAL SECTION A: / 110
SECTION B – DATABASE
You are employed as an assistant at the Bazaar Fabric and Curtain Shop. You are requested to prepare a database, using a database program, to keep record of the available fabrics in the shop.

QUESTION 3A

1. / Create the database using the filename FABRICS1.
2. / Create a table with the following fields:
EXAMINATION NUMBER (NOTE: type your examination number, not the words ‘EXAMINATION NUMBER’ – Auto Number field.)
FABRIC – Text field, maximum 20 characters
COLOUR – Text field, maximum 10 characters
PRICE PER METRE – Currency field
TOTAL METRES – Number field (integers)
DATE – Date field, Short date
3. / Save the table as QUESTION 3A and your EXAMINATION NUMBER.
4. / Print the structure of the database. Note that in the Print Table Definition the following should be selected: ‘Include for Table’ (nothing should be selected), ‘Include for Fields’ (‘Names, Data Types, and Sizes’) and ‘Include for Indexes’ (‘Nothing’) / [22]

QUESTION 3B

1. / Copy the document and save the copy as QUESTION 3B and your EXAMINATION NUMBER.
2. / Key in the following records:
EXAM NUMBER / FABRIC / COLOUR / PRICE PER METRE / TOTAL METRES / DATE /
1 / Cotton / Orange / R 15.95 / 20 / 2008/12/13
2 / Velvet / Green / R 29.95 / 7 / 2008/12/13
3 / Silk / White / R 69.95 / 16 / 2009/01/05
4 / Denim / Blue / R 19.95 / 25 / 2009/01/12
5 / Nylon / Yellow / R 35.95 / 10 / 2009/01/22
6 / Satin / Purple / R 35.95 / 20 / 2009/02/26
7 / Linen / Violet / R 39.95 / 50 / 2009/03/04
3. / Sort the database in alphabetical order according to the FABRIC name.
4. / Print the data for all the records in QUESTION 3B. / [22]

QUESTION 3C

1. / Create a standard, columnar form using the Form Wizard. Include ALL the available fields.
2. / Add the following as a header to your form using Font: Arial 20 and bold it:
Bazaar Fabric and Curtain Shop
3. / Add your EXAMINATION NUMBER (left) and QUESTION 3C (right) as footer to your form.
4. / Add the following record using a form:
EXAM NUMBER / FABRIC / COLOUR / PRICE PER METRE / TOTAL METRES / DATE /
8 / Leather / Natural / R 75.95 / 30 / 21/03/2009
1. / Save the form as QUESTION 3C and your EXAMINATION NUMBER.
2. / Print the forms displaying all the information. Hand in ALL the prints for marking. / [18]

QUESTION 3

1. / Create a Query based on the table of QUESTION 3B, using Design View and include the following fields:
FABRIC PRICE PER METRE TOTAL METRES
2. / Sort the information descending according to the TOTAL METRES field.
3. / Only fabrics with more than 15 metres should be displayed.
4. / Save the query as QUESTION 3D and your EXAMINATION NUMBER.
5. / Run the query and print. / [10]

QUESTION 3E

1. / Create a Report based on your Query in QUESTION 3D using the Report Wizard.
2. / Add a new column called VALUE and calculate the value of each of the available fabrics. All the figures in this column should be displayed as currency with 2 decimals.
3. / Add the word TOTALS at the end of the report below the FABRIC column. The total metres available (displayed as integers) as well as the total value of the fabrics (shown as currency with 2 decimals) should be calculated and displayed in the report.
4. / Add QUESTION 3E (top left) and your EXAMINATION NUMBER (top right) as a heading for the report.
5. / Align all new text and extend lines where necessary to display a neat report.
6. / Save the Report as QUESTION 3E and your EXAMINATION NUMBER.
7. / Print your Report. / [18]
TOTAL SECTION B:
GRAND TOTAL: / 90
200

Copyright reserved Please turn over