Blog

Question 4 – Spreadsheet The 4Visits_Besoeke spreadsheet sho…

Question 4 – Spreadsheet The 4Visits_Besoeke spreadsheet shows the number of guests that visited some animal farms in our country over five years. Open the 4Visits_Besoeke spreadsheet and work in the Bookings_Besprekings worksheet. 4.1 Calculate in cell G4 the amount of money that guests paid ‘The Tiger Canyon’ for accommodation for the period 2015 – 2019 (adults plus children). The tariffs for adults and children respectively are shown in columns C and D and the number of visitors are shown in columns E and F. (3) 4.2 The animal farms are awarded with stars according to the number of guests that visited the farm over five years. The following criteria is used to award an animal farm with a star: Gold for more than 700 visitors (Adults + Children) Silver for more than 550 visitors (Adults + Children) Bronze for more than 450 visitors (Adults + Children) No star for less than 451 visitors (Adults + Children). Use a function in cell H4 to determine which star ‘The Tiger Canyon’ will receive. (5) 4.3 Carli used a function in cell D22 to calculate the average tariff for children. Unfortunately, she made a mistake in the function. Rectify this error. (1) 4.4 Change the colour of the sheet tab to a blue colour. (1) 4.5 Remove the comment that appears in cell H22. (1) Save and close the 4Visits_Besoeke spreadsheet. [11]  

INSTRUCTIONS AND INFORMATION 1. Owing to the nature of…

INSTRUCTIONS AND INFORMATION 1. Owing to the nature of this three-hour examination, it is important to note that you will NOT be permitted to leave the examination session before the end of the examination period. 2. Insert your examination number in the header of EVERY document that you create or save. 3. A copy of the master files can be downloaded at any stage from the data page. Should there be any problems with a file/files, please visit the EXAM CONNECT Zoom. 4. This question paper consists of SEVEN questions. 5. Answer ALL the questions. 6. Ensure that you save each document using the file name given in the question paper. Save your work at regular intervals as a precaution against possible power failures. 7. Read through each question before answering or solving the problem. Do NOT do more than is required by the question. 8. At the end of the examination you must upload all your files in the UPLOAD Quiz. Make absolutely sure that all files can be read.No .pdf files or .laccdb files 9. During the examination you may use the help functions of the programs which you are using. You may NOT use any other resource material. 10. If data is derived from a previous question that you cannot answer, you should still proceed with the questions that follow. 11. Unless instructed otherwise, you must use formulae and/or functions for ALL calculations in questions involving spreadsheets. Use absolute cell references only where necessary to ensure that formulae are correct when you copy them to other cells in a spreadsheet. 12. In all questions involving word processing, you should set the language to English (South Africa). Assume the paper size to be A4 Portrait, unless instructed otherwise. 13. You’ll need the following files to complete this test:   Question  Suggested time  Marks Question 1 Word processing 31 minutes 31 Question 2 Word processing 17 minutes 17 Question 3 Spreadsheet 41 minutes 41 Question 4 Spreadsheet 11 minutes 11 Question 5 Database 40 minutes 40 Question 6 HTML 20 minutes 20 Question 7 General (Integration) 20 minutes 20 TOTAL   180 minutes 180 marks

Tema: Indien jy passievol oor wilde diere is en jy graag ‘n…

Tema: Indien jy passievol oor wilde diere is en jy graag ‘n verskil in hulle lewens wil maak, werk dan vrywilliglik by The Tiger Canyon. Help die ongelooflike personeel met hulle bewaringspogings en ervaar die wonder van wilde diere! Carli werk op die tierplaas. Sy lei toeriste op toere om die tiere op die plaas te bekyk. Sy doen spyseniering vir funksies op die plaas en sy is ook verantwoordelik vir die bemarking van die tierplaas. Sy gebruik haar rekenaar om administratiewe take uit te voer. Vraag 1 – Woordverwerking Die bestuurder van The Tiger Canyon het ‘n nuusbrief geskep om aan besoekers te versprei. Sy het vir Carli gevra om die dokument te redigeer. Maak die lêer gestoor as 1Tigers_Tiere oop. 1.1 Verander die kas (‘case’) van die hoofopskrif van die dokument, ‘The Tiger Canyon’, na hoofletters. (1) 1.2 Omraam die hoofopskrif van die dokument . Jy mag enige formaat vir die omraming gebruik. (1)   Regsklik op hierdie knoppie en selekteer die “Open link in new tab” opsie.         1.3 Formateer alle ‘Heading 3’-style in die dokument na ‘n nuwe opskrifstyl genoem ‘Tigers’. (1)   Gebruik die formatering hieronder vir die ‘Tigers’-styl:     Stel die lettertipe (‘font’) op Tahoma 12 pt. (1)   Beskadu die teks met ‘n groenerige kleur. (1)   Alle paragraafopskrifte, wat met ‘heading 3’-styl geformateer is, in die dokument moet outomaties na die nuwe styl opdateer. (1)     1.4 Formateer die paragrawe onder die opskrif ‘Distribution in South Africa’, wat begin met die teks ‘Tiger Canyon …’ en eindig met die teks ‘… tiger in Africa.’ as volg: 1.4.1 Verander die spasiëring van die paragrawe na 3 pt voor en 3 pt na die paragraaf. (1) 1.4.2 Verander die reëlspasiëring na presies (‘exactly’) 14 pt. (2) 1.4.3 Brei die karakterspasiëring met 1.5 pt uit (‘expand character spacing’). (1)     1.5 Vind die prentjie van die tier in die ‘Habitat’-paragraaf. Voeg ‘n hiperskakel (‘hyperlink’) op die prentjie as volg in:   Die hiperskakel moet met die webwerf http://www.tigers.com koppel. Die teks ‘King of Nature’ moet vertoon as die muis oor die hiperskakel beweeg word. (3) 1.6 Vind die paragraafopskrif ‘Habits’. Formateer die paragraafopskrif, insluitende die teks in die paragraaf, sodat dit op ‘n nuwe bladsy, in landskap sal vertoon. (2) NOTA: Slegs hierdie paragraaf in die dokument moet na landskap verander word.

Thoth, an ancient Egyptian god of wisdom and learning, has a…

Thoth, an ancient Egyptian god of wisdom and learning, has abducted Ahmes, a famous Egyptian scribe, in order to assess his intellectual prowess. Thoth places Ahmes before a large funnel set in the ground (see figure below). It has a circular opening 1,000 ft in diameter, and its walls are quite slippery. If Ahmes attempts to enter the funnel, he will slip down the wall. At the bottom of the funnel is a sleep-inducing liquid that will instantly put Ahmes to sleep for eight hours if he touches it. Thoth hands Ahmes two objects: a rope 1,006.28 ft in length and the skull of a chicken. Thoth says to Ahmes, “If you are able to get to the central tower and touch it, we will live in harmony for the next millennium. If not, I will detain you for further testing. Please note that with each passing hour, I will decrease the rope’s length by a foot. Is it possible to reach the central ankh tower and touch it? ​   ​   Ahmes’ dilemma. Note that there are two ankhshaped towers. One stands on a cylindrical platform in the center of the funnel. The platform’s surface is at ground level. The distance from the platform surface to the liquid is 500 ft. The other ankh tower is on land, at the edge of the funnel. ​