What is the autoionization of water? (2 points)    

29 Right click on the button below and select  “open link in a new tab” to view the table which represents a spreadsheet, answer all of the questions below.   29.1 Using a formula (unit price x quantity) to calculate the subtotal of each of the actual purchases. Place your answer in D6 (2) 29.2 Using a formula calculate the totals of the each of the food items (place your answers in F6. (1) 29.3 Calculate the total shopping bill (place your answer in F15) (2) 29.4 Using a function determine the quantity of different items in the cart. Place your answer in F16 (2) 29.5 Using a function to determine what the price of the most expensive item. Place your answer in F17. Use the unit price. (2) 29.6 Using a function to add in today’s date. Place your answer in F2. (2)    

1 You would like to start a computer centre on a school campus. Which communication network would you most likely use? (1) a)                WAN   b)               LAN   c)                GAN   d)               MAN         2 A printer is usually connected to a computer by a…. (1) a)                bus line   b)               internal clock   c)                usb port   d)               serial port         3 The built-in facility of Windows XP or later to automatically add new hardware: (1) a)                32-bit data bus   b)               TCP/IP   c)                Windows Explorer   d)               Plug and Play         4 A type of primary memory that always retains its contents when the power is off. (1) a)                HDD (Hard Disk Drive)   b)               ROM (Read Only Memory)   c)                RAM (Random Access Memory)   d)               Cache memory         5 A storage device is classified as an …………… device (1) a)        b)        c)        d)       input output input/output none of the above          

28 Timothy would like to set up a table in Access of the data seen in the spreadsheet. The table must contain information on the Medicine Code, Medicine Name, Available Stock and Medicine Price including VAT. Right Click the button below and select “Open in a new Tab to view the database.       28.1 How many fields would the table require? (1) 28.3 How many records does the table contain? Assume this is all the data. (1) 28.4 The code field is a primary key. What is a primary key? (2) 28.5 The ability to accurately extract specific information from a large amount of data is one of the most important functions of a database. A filter can be used to perform this task.   a) What is another name for a filter in a database i.e. something can be executed to get specific information? (1) b) Enter the criteria to list all medicines where the stock is below 50. Give the fieldname as well. (2)    

4.1 Indicate which page you would turn to if you want to find: 4.2.1 Political map of Africa: page 4.2.2 The solar system: page (2)

3.1 The line scale on the map is 1cm=160km, what would the word scale be for 1cm=120km? (2)

3.3 The distance between Durban and Beaufort West is 5cm. Use the map scale to work out the real-life distance in km. Show your calculations (3)

18 The operating system and other system utilities are responsible for the operation and maintenance of the computer system.   18.1 Name any two operating systems for personal computers. (2) 18.2 Name any operating system for a smart phone or a consumer tablet. (1) 18.3 Give three functions of an operating system. (3) 18.4 Name the process of loading the core of the operating system from storage to primary memory. (1) 18.5 Name the ROM chip that holds the programs that execute the above operations. (1) 18.6 What is the function of a device driver. (2)    

22 Which of the following is a primary resource of data research a) Conducting a survey   b) Online magazines   c) Using a search engine   d) JournalsOnline videos   23 Which of the following is a connection from a HTML-based page to another page or file?   a) Anchor   b) Bookmark   c) Hyperlink   d) Metadata   24 Which of the following is the purpose of the SUM function in a spreadsheet?   a) To calculate the total of a selection of values   b) To display the largest number from a selection of values   c) To represent a selection of data as a column-chart   d) To return the number of values within a selection   25 Which of the following terms is the action of moving from one slide to another in a presentation?   a) Animation   b) Embedding   c) Hyperlink   d) Transition     A promotional presentation to advertise a new hotel requires an appropriate professional business background.   26 Which of the following would be the most appropriate?   a) A photo of an untidy hotel room   b) An animated clip-art image of a hotel   c) An image of a hotel lounge showing customers   d) A randomised colour background on every slide

I must email my instructor ALL pages of my scratch work neatly numbered within 5 minutes of completing the exam.  All scratch work must match the answers entered on the exam.