Question 6: Information management

Question 1 – Multiple choice Various options are given as possible answers to the following questions. Choose the answer e.g. 1.11 D.

8.3 c) Indicate which table property will be used to ensure the following outcome by choosing the correct property from the drop-down list: The surnames must always be shown in capital letters. (1)

8.3 b) Indicate which table property will be used to ensure the following outcome by choosing the correct property from the drop-down list: Data must be entered in a name field e.g. the field may not be left empty. (1)

The following screenshot is an example of a possible spreadsheet that can be used by your school. It was created in Microsoft Excel.          A B C D           E   1 Name Surname  Male/Female   BirthDate      AmountPaid   2 Bianca           Meyer            F 24/2/2003 R500.00   3 Karabo          Moloi             M                                5/11/2002 R400.00   4 Nawisha       Gardien        F                                  17/1/2003 R300.00   5 Tsepo             Mvunga        M                                12/10/2002 R400.00  

After the Covid-19 pandemic and closing of businesses in your community there are high levels of unemployment. You and your friends decided to rent a space in the local library and to establish a programme for providing community members with computer skills. There are 6 computers available in the library but you will also use mobile devices. You and you friends will also help the participants to create and print CV’s to apply for new jobs.

5.5 An advertisement for a computer specifies that it has an on-board 1000 Gigabit NIC.What does the “1000 Gigabit” refer to? (1) 5.6 Distinguish between the functions of a server and a client in a network. (2) 5.7 A proxy server is commonly found on a network. Give TWO advantages or benefits of using a proxy server. (2) 5.8 What is the main function of a web server? (1)

8.3 a) Indicate which table property will be used to ensure the following outcome by choosing the correct property from the drop-down list: The gender field must always show “M” for male except when “F” for female is entered. (1)

4.20 Windows provides a few useful utilities to perform general housekeeping on your computer to optimize its performance. Which tab will you choose to open up all of these utilities. Only choose ONE and fill your answer in in the space provided: (Fill in only the letter without the bracket) a)   Windows Accessories b)   Windows Administrative tools c)   Windows PowerShell d)   Windows System (1)

8.3 d) Indicate which table property will be used to ensure the following outcome by choosing the correct property from the drop-down list: There cannot be more that 25 characters in a name field. (1)