Observation

The expected answer is:

• (i) Primary key identification
• Index number                                                                                                       

 (ii)       Reason for the choice in 6(a)(i)

• Unique identifier/ Uniquely identified each student
• No duplication/Repeated value
• No null value/Cannot be empty.    

    (iii)     Methods the teacher could employ to secure students data

• Data Encryption: data cannot be read by unauthorized persons. A key is needed to unlock the code.
• Use of firewall: prevent illegal access / hacker to the student database (This can be implemented by software, hardware or combination of both).
• Use of antivirus/antimalware: to protect from viruses and malware.
• Use of passwords: prevent unauthorized access to sensitive data. Users can be made to change these frequently to ensure data is protected.
• Physical protection: of the host computer for the DB

(b) Steps to create a drop-down list in an Ms Excel worksheet

• Select the cell or range of cells where the dropdown list will be added
• Click on Data tab
• Click on Data Validation
• Select Settings tab
• Select ‘List” from the allow: drop- down box
• Enter the list source: field using a comma to separate the items or select a range of   cells
• from the wok sheet

OR

• In a new worksheet, type the entries you want to appear in your drop-down list/ Select the cell in the worksheet where you want the drop-down list.
• Go to the Data tab on the Ribbon,
• Click on Data Validation.
• On the Settings tab, in the Allow box, click List.
• Click in the Source box, and Type in the data options separated by comma/ select your list range
• Click on OK

OR

• In a new worksheet, type the entries you want to appear in your drop-down list, select the entries, and give it a name in the Name box
• Select the cell in the worksheet where you want the drop-down list.
• Click on the Data tab on the Ribbon, then click on Data Validation.
• On the Settings tab, in the Allow box, click List.
• Click in the Source box, then press F3, and select the range name, click ok
• Click on OK

          (c) (i) Identification image in Figure1

• Barcode                                                                                                             

              (ii) Other application areas of Barcode