Blog

OM JOU LêERS OP TE LAAI: Maak seker dat die lêers waaraan j…

OM JOU LêERS OP TE LAAI: Maak seker dat die lêers waaraan jy gewerk het gestoor is op jou rekenaar Maak WORD, EXCEL, ACCESS en NOTEPAD++ toe Al jou lêers moet opgelaai word in die OPLAAI quiz wat volg na hierdie quiz. Sodra jy heeltmal klaar is met jou vraestel, klik die “SUBMIT QUIZ” knoppie regs onder Om dan na die OPLAAI Quiz te navigeer moet jy die “NEXT” knoppie klik (regs-onder) en jy het 15 minute om die lêers waaraan jy gewerk het op te laai Let asb: GEEN .PDF of /.laccdb lêers nie.

Question 2 – Word processing Carli created an electronic for…

Question 2 – Word processing Carli created an electronic form for guests to make bookings Open the 2Bookings_Besprekings document. 2.1 Remove the watermark that appears in the document. (1) 2.2 Group the two images on the first page of the document (1) 2.3 Find all occurrences of the words ‘Tiger Canyon’ and replace them with the words ‘The Tigers Canyon’, highlighted in a yellow colour. (2) 2.4 Locate the bulleted list on page 1 of the document. Right-click on this button and select the “Open link in new tab” option Format the bulleted list as follows: Change the bullets to the Webdings symbol (character code 228).  Align the bullets at 0.5 cm from the left margin. Set the distance between the bullets and the text at 0.5 cm. (1) (1) (1) 2.5 Locate the word ‘distinctly’ in the first paragraph of the text. Use a Word Processor feature and replace this word with a suitable synonym. (1) 2.6 Locate the table on the second page of the document. Insert a caption below the table. The caption must read Table 1: Tariffs. (2) 2.7 Continue working in the third row of the table. 2.7.1 Edit the drop-down field in the second column of the third row as follows: Remove the option R970. Add help text ‘Tariff’ to the control. 2.7.2 Work in the last row of the table. Change the text form field in this row to the current date format. (1) (1) (1) 2.8 Go to the ‘Book now!’ section on the last page of the document. Change the options under the heading ‘Book now!’ to resemble the example below: Right-click on this button and select the “Open link in new tab” option **NOTE: Set AND apply a 6cm hyphenated leader tab, as shown above, to ALL options. (3) 2.9 A table of sources has been created for this document. Insert an automatic bibliography below the heading ‘Bibliography’. (1) Save and close the 2Bookings_Besprekings document. [17]

Question 5 – Database  Carli keeps record of all guests that…

Question 5 – Database  Carli keeps record of all guests that visit ‘The Tiger Canyon’ in a database. Open the 5Guests_Gaste database file. Work in the Visitors_Besoekers table. 5.1 Insert a primary key on the most appropriate field. (2) 5.2 Change the InternetAccess_InternetToegang field to a Yes/No field. Display ‘yes’ and ‘no’ in this field, and not a checkbox (1) 5.3 Change the Surname_Van field so that duplicates will be allowed (1) 5.4 Create a lookup field for the Gender_Geslag field so that either ‘F’ for Female or ‘M’ for Male will be displayed. (2) 5.5 Format the Date of Birth_Geboortedatum field to the long date format. (1) 5.6 The default country must be South Africa (1) 5.7 Use a validation rule in the Adults_Volwassenes field so that no number bigger than 7 will be accepted in this field. Remember to use a suitable validation text in this field. (2)   Save and close the Visitors_Besoekers table   5.8 Open the Tiger_Tier table Use an input mask in the RegNo_RegNo field so that the registration number of the farm is displayed as follows: Three compulsory digits; followed by the ‘/’ sign followed by 3 compulsory capital  Save and close the Tiger_Tier table. (3) 5.9 Open the Information_Inligting query. Sort the query in descending order according to the Surname_Van field. (1) 5.10 Modify the query so that   5.10.1 Only the following fields are displayed: Surname_Van, Name_Naam, and the Date of Birth_Geboortedatum (1) 5.10.2 Display only South African visitors that were born after 1 January Save and close the Information_Inligting-query.  (3) 5.11 Open the Costs_Koste query Create a calculated field with the name ‘Total Amount’ and calculate the total amount of money that each group of visitors had to pay for the stay at ‘The Tigers Canyon’. Save and close the Costs_Koste query (4) 5.12 Open the Details_Besonderhede form.   5.12.1 All names of the Country_Land in the form must appear in italics (1) 5.12.2 Insert today’s date in the header of the form. (1) 5.12.3 Change the list box in the Occupation_Beroep field in the form to a combo (1) 5.12.4 Apply conditional formatting so that the name South Africa, is formatted to a red colour font. Save and close the Details_Besonderhede form. (2)  

Instruksies en inligting 1. As gevolg van die aard van hi…

Instruksies en inligting 1. As gevolg van die aard van hierdie drie-uur-eksamen is dit belangrik om daarop te let dat jy NIE toegelaat sal word om voor die einde die eksamensessie te verlaat NIE. 2. Tik jou eksamennommer in die bladsyboskrif (‘header’) van ELKE dokument wat jy skep of stoor. 3. ‘n Kopie van die meesterlêers (‘master files’) kan enige tyd tydens die eksamen sessie afgelaai word. Indien daar enige probleme met ‘n lêer is, gaan dadelik na die Exam CONNECT Zoom sessie toe.   4. Hierdie vraestel bestaan uit SEWE vrae. 5. Beantwoord AL die vrae.   6. Maak seker dat jy elke dokument stoor deur die lêernaam wat in die vraestel gegee word, te gebruik. Stoor jou werk gereeld as ‘n voorsorgmaatreël teen moontlike kragonderbrekings.   7. Lees elke vraag deur voordat jy dit beantwoord of die probleem oplos. MOENIE meer doen as wat deur die vraag vereis word NIE.   8. Aan die einde van die eksamen moet jy jou lêers in die OPLAAI Quiz gaan indien. Maak asb. seker dat ALLE lêers gelees kan word.Geen .pdf of .laccdb lêers nie asb.   9. Gedurende die eksamen mag jy die hulpfunksies gebruik van die programme wat jy gebruik. Jy mag GEEN ander hulpbronmateriaal gebruik NIE.   10. Indien data afgelei is uit ‘n vorige vraag wat jy nie kon beantwoord nie, moet jy steeds voortgaan met die vrae wat volg.   11. Tensy anders aangedui, moet jy formules en/of funksies vir ALLE berekeninge in vrae oor sigblaaie gebruik. Gebruik absolute selverwysings slegs waar nodig om seker te maak dat formules korrek is wanneer jy dit na ander selle in ‘n sigblad kopieer.   12. Vir alle vrae oor woordverwerking moet jy die taal op ‘English (South Africa)’ stel. Neem aan dat die papiergrootte A4 Portret (‘Portrait’) is, tensy anders aangedui.   13. Die eksamenlêergids wat jy saam met hierdie vraestel ontvang, bevat al die lêers wat hieronder aangedui word. Maak seker dat jy al die lêers het voordat jy met hierdie eksamen begin.        

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]