a(i) Define the term file organization.
(ii) Group the following file organization attributes under the appropriate heading as shown below.
I. It does not support use of tapes
II. Records are inserted one after the other
III. It does not generate random keys to identify location
IV. It generates random key to identify locate
| S/NO | Sequence File Organization |
Indexed File Organization |
| 1 | ||
| 2 | ||
| 3 |
b(I) State two safety rules observed in a computer laboratory
(ii) List three internet browsers
(a) Explain the use of Custom Slide Show in Microsoft PowerPoint application.
(b) State two functions of Rehearse Timings in Microsoft PowerPoint.
(c) List four types of illustrations that can added to presentation from the insert tab of Microsoft powerpoint.
The Local Area Network (LAN) in a certain school is connected to the internet. The school also has a management system (MIS) which is used to enroll staff and students in the school. The system requires that users be authenticated before access is granted. Students are also allowed to use computers in the network during their leisure time.
a(i) State two problems associated with an uncontrolled access to the internet by the students
(ii) How can the problems stated in 4a(i) be prevented?
(b) Give one reason for users' authentication before access to the system is granted
(c) To use the mIS, a staff is expected to log in using a registered username and password.
Table below shows login activities and the login steps to the to the MIS. Specify te correct order or steps in the login process in column Y using the letter A-E attached to the login activities in column X.
| X: Login Activity | Y: Login Step |
| A: system authenticates username and password | (i) |
| B: click on login | (ii) |
| C: enter password | (iii) |
| D: (access granted/denied) | (iv) |
| E: enter username | (v) |
Highlight the steps to perform the following
(a) creating a new table
(b) generating a query
(c) creating a splít form
(d) printing a report
(a) A document is created in MS Word but the user realizes that part of the document are cut off when it is print previewed in portrait orientation. Highlight the steps to change the ori- entation to- landscape and print the document on A4 paper.
(b) A teacher working on student's results broadsheet in Microsoft Excel needed to keep the headings in view" while scrolling through the results. The teacher also needed to compare each student's record with a version of the file earlier submitted to the Head of Department (HOD) to effect all suggestions
(i) Name the concept of keeping the headings visible while scrolling through a worksheet in Microsoft Excel.
(ii) Outline the steps to keep the headings fixed while scrolling in Microsoft Excel worksheet.
(iii) Identify two actions to display each student record at the same time on both versions of the result file.
(iv) Highlight the steps to achieve the named actions in 6b(iii).
(c) List two gadgets needed to display the content of a laptop computer to an audience in an auditorium.
