Question 3
(a) Table 1 shows the actions performed by a company on its stored files.
Tick the actions that will ensure that the files are kept confidential and secured.
Table 1
S/N |
ACTIONS |
TICK |
1. |
Use of anti-virus |
|
2. |
Use of backup |
|
3. |
Use of biometrics |
|
4. |
Use of folder |
|
5. |
Use of manual file |
|
6. |
Use of password |
|
(b) List two disadvantages of computer files as compared to manual files.
(c)(i) Define charts as it relates to MS Excel.
(ii) Give two types of charts in MS Excel.
Observation
The expected answer is:
SN |
ACTIONS |
TICK |
1. |
Use of antivirus |
√ |
2. |
Use of backup |
√ |
3. |
Use of biometrics |
√ |
4. |
Use of folder |
|
5. |
Use of manual file |
|
6. |
Use of password |
√ |
- Disadvantages of computer files compared to manual files
- Data inconsistency – different file may contain different information of a particular object or person
- Data redundancy – this leads to when the same data is stored in multiple location
- Data sharing- each application program uses its own specific data files, thus, such data cannot be shared to multiple users
- Data isolation- data is isolated in separate files, hence, it is difficult to update and to access particular information from data files
- Unauthorised user can find your files easily
- Hacker can take advantage of your computer file system if it is not password protected or encrypted
- Difficulty in Accessing the file
- Expensive to maintain
- Integrity Problems
- Security Problems
- Easily overwritten
- files are easily corrupted
- Power failure/irregular supply of electricity
- Danger of computer fraud
- Limited Data Sharing
- Skilled labour with proficiency in computers is required.
- (i)Definition of charts
- A chart is a tool that allow data in a worksheet to be visually display in a variety of different format
such as Bar, Column, Pie, Line, Area, Doughnut, scatter, surface, or Radar charts.
- It is a visual representation of data in both columns and rows from a worksheet which can bring more understanding to the data than just looking at the numbers.
- A chart is a graphical representation of data which allow user to see the result of data for better understanding and to predict current and future data in excel.
- A chart is a visual representation of data in both columns and rows.
- Charts allow the audience to see the meaning behind the numbers, and also show comparisons and trends much easier.
- A chart is a tool used in Excel to communicate data graphically
(ii) types of charts
- Column Chart
- Line Chart
- Pie Chart
- Doughnut Chart
- Bar Chart
- Area Chart
- XY (Scatter) Chart
- Bubble Chart
- Stock Chart
- Surface Chart
- Radar Chart
- Combo Chart
- Pivot Chart
The question tested candidates ‘knowledge of computer files. The Chief Examiner reported that most of the candidates struggled with the question.