QUESTION    4          DATABASE Let’s analyse the same data in Access. Open the database 4_Stats. Open the tblComparison table and then make the following changes: 4.1 Change the Elevation (m) field to a more suitable data type. 1 4.2 Set a suitable field as a primary key. 1 Save and close the table tblComparison. 4.3 Create a form based on the table tblComparison and save it as frmComparison. 2 4.4 Delete the details in the form header and then do the following:   4.4.1 Add the Logo.bmp picture as a logo in the header. 1 4.4.2 Add the text Highest Mountains next to the logo. Font colour must be Blue-Gray, Text 2 and the font size 16pt. 2 4.4.3 Change the background colour of the header section to white. 1 Save and close the form frmComparison. 4.5 Create the following query:   4.5.1 Which high mountains are the most popular to climb? Create a query to show the 3 mountains that are higher than 8500m and have been ascended the most. Save the query as Popular. Show only the fields Mountain and Elevation. Sort the query in descending order according to total ascents. 3 Save and close the query.     [11]

QUESTION 1             FILE MANAGEMENT Open the file 1_Climbing Everest and make the following changes: 1.1 Create a new folder, inside the 1_Climbing Everest folder, named Media and move all the photos and videos into this newly created folder. 3 1.2 Rename the file P1 to About the book. 1 1.3 There is a hidden file called About Brian. Locate this file and change it’s properties so that it is no longer hidden. 2     [6] Follow the instructions as listed below: Right-click on the file (1_Climbing Everest) Select Send to Select Compressed (zipped) folder.  

Question 5 – Web design (HTML) You have been asked to finalise a web page for the school’s intranet. Open the text file 5_Intranet in your HTML editing program and in a browser. Note: ·        An HTML tag sheet has been added below this question for reference. Your final web page should look like the example below:  Right-click the button above and select the Open link in new tab option. Do the following: 5.1 Add an opening tag so that the text ‘Market Day’ is displayed in the tab of your browser. 1 5.2 Locate the text ‘SATURDAY 24 JUNE’ under the heading ‘Highrise Secondary’. Add HTML code so that the text is displayed in bold AND in italics. 2 5.3 Add a tag to draw a horizontal line across the page, in the position shown in the example. 1 5.4 Format the text at the bottom of the page so that it is displayed as follows in a web browser: Right-click the button above and select the Open link in new tab option. Note the following: ·        The text ‘Please contact Lisbe Strydom’ is displayed as a heading that is one size smaller than the heading just above it. Note: Do not change the size of the heading ‘Would you like to become a trader?’ The email address and cell phone number are displayed as normal text (not as a heading) and are in the same paragraph. 2 Save and close the file 5_Intranet.     [6] HTML Tag Sheet Structural / Basic tags Defines the body of web page Contains information about document Starts and end a web page Defines a title for the document Comment Formatting Tags Creates a new paragraph Inserts a line break Text Tags Creates the largest heading Creates the smallest heading Creates bold text Creates italic text Graphics Tags Inserts a horizontal line

QUESTION    4          DATABASE Let’s analyse the same data in Access. Open the database 4_Stats. Open the tblComparison table and then make the following changes: 4.1 Change the Elevation (m) field to a more suitable data type. 1 4.2 Set a suitable field as a primary key. 1 Save and close the table tblComparison. 4.3 Create a form based on the table tblComparison and save it as frmComparison. 2 4.4 Delete the details in the form header and then do the following:   4.4.1 Add the Logo.bmp picture as a logo in the header. 1 4.4.2 Add the text Highest Mountains next to the logo. Font colour must be Blue-Gray, Text 2 and the font size 16pt. 2 4.4.3 Change the background colour of the header section to white. 1 Save and close the form frmComparison. 4.5 Create the following query:   4.5.1 Which high mountains are the most popular to climb? Create a query to show the 3 mountains that are higher than 8500m and have been ascended the most. Save the query as Popular. Show only the fields Mountain and Elevation. Sort the query in descending order according to total ascents. 3 Save and close the query.     [11]

INSTRUCTIONS: Close all applications AFTER you have saved your work. Click on SUBMIT QUIZ at the bottom of this page. This will close your test and after that you need to click next which takes you to the “quiz”  upload where you need to upload all your files.

Read the scenario below that describes the background to the practical tasks you are required to perform. SCENARIO Former Navy rescue swimmer Brian Dickinson was roughly 1 000 feet (305m) from the summit of Mount Everest – also known as the death zone – when his Sherpa, Pasang, became ill and had to turn back. Four hours later, Brian solo summited the highest peak in the world. But the celebration was short lived. Suddenly, without warning, his vision became blurry, his eyes started to burn and within seconds, he was rendered almost completely blind. All alone at 29 035 feet, low on oxygen, and unable to see, Brian was forced to inch his way back down the mountain.  

Which imaging technique is most likely to visualize a structure beneath a calcification?

Bending of a transmitting sound beam after it passes through one medium into another describes:

Which receiver function includes enveloping and rectification? 

Is the wall filter set too high, or too low in the following image?