Waec Data Processing Paper 2,Essay May/June 2016 Answers

Waec  Data Processing Paper 2,Essay May/June 2016 Answers


1.
(a) Data handling is the process/way of ensuring that data is obtained, stored, archived or disposed in a manner that retains its integrity/in a secured manner .
OR
Data handling is basically the process/way of imputing and storing data in a computer. The Data is then processed into information

(b) There are two ways of handling data which are:

(i) Electronic method : This is the use of electronic systems such as Computers, storage media like video tape, CD, DVD, Memory Cards and other electronic devices to obtain, store, archive, share or dispose data.
(ii) Non-electronic/Manual method : This involves the use of paper files, journals, laboratory notebooks, human effects and other non-electronic means to store or share data.

(c) Factors to be considered when handling data electronically

1. Data Integrity
2. Regular update of data
3. Validation of data
4. Security of data/Encryption
5. Type of Data
6. Type of storage to be used
7. Data volume/Size
8. Access Control
9. Regular Anti-Virus Update
10. Limit Physical access to storage media
11. Regular Backups
12. Ensure Data Recoverability
13. Login/Password
14. Record Date and Time
15. Power Supply

2.
(a) Information processing is the process of acquiring/obtaining/collecting/gathering/retrieving , manipulating/handling/analysing , recording/storing and
presenting/display/dissemination of information.
OR
Information processing refers to the manipulation of digitized Information by Computers and other digital electronic equipment.

(b) Steps involved in Information processing are:

(i) Collation of Information
(ii) Organization of Information
(iii) Analysis of Information
(iv) Interpretation of Information

(c) Advantages of using Computer for Information processing are:

1. Efficiency
2. Automation
3. Reliability
4. Volume/Storage
5. High speed
6. Accuracy
7. Security
8. Sharing of Information/Sharing of Resources
9. Economical
10. Lower overall cost
11. Versatility
12. Service Improvement
13. Easy retrieval

(d) Disadvantages of using Computers for Information processing

1. High initial investment cost
2. Loss of jobs due to Computerization
3. Requires specialized personnel
4. Extra cost of retraining of staff
5. Virus/Hackers susceptibility
6. Face-to-Face Interaction among staff may be reduced
7. Prone to unauthorized access
8. Overwriting/Loss of Data
9. Power dependent
10. System failure/ system malfunctioning


3.
(a)
(i)

Information transmission is the process of sending Information from one point to another through a channel.
(ii) Example: Printing of document; classroom instruction, receiving radio signals; DSTV signals, Telegraph, GSM, Photography, Facsimile, Town Crying, Smoke Message, Use of Birds, Story Telling, Signs/Signals, Internet, Satellite signals, Blowing Horns, Drum Beating, Fire Lighting etc.

(b)
(i) DOS, OS 2, PC-DOS, Palm-OS.
(ii) MS Windows, Mac-OS, Linux
(iii) Xenix, Zenix, Unix, Linux, Mac OS, VMS, Mainframe OS

(c) Features of a Graphical User Interface (GUI)

(i) Windows
(ii) Icons
(iii) Menus
(iv) Pointing device (mouse)


4.
(a) Qualities of good Computer professional:

1. Multitasking ability
2. Adaptability
3. Analytical skills
4. Attention to detail/Accuracy
5. Commitment to learning/ Abreast with current trends
6. Communication skills
7. Problem-solving/Troubleshooting capabilities
8. Competence
9. Technical Writing Skills
10. Aptitude for Mathematics
11. Ability to Memorise
12. Certification
13. Reliability
14. Disciplined
15. Trustworthy

(b) Computer Professional Bodies in Nigeria:

1. Computer Professionals Registration Council of Nigeria (CPN)
2. Nigeria Computer Society (NCS)
3. The Institute of Software Practitioners of Nigeria (ISPON)
4. Information Technology Industry Association of Nigeria (ITAN)
5. Nigeria Internet Group (NIG)
6. Internet Service Providers Association of Nigeria (ISPAN)

(c) (i) Wi-Fi - Wireless Fidelity
(ii) GUI - Graphical User Interface.




5.
(a)

 (i)
=SUM(D2,D3,D4,D5,D6,D7,D8,D9,D10,D11)
OR
=(D2+D3+D4+D5+D6+D7+D8+D9+D10+D11)
OR
=SUM (D2:D11)
OR
=SUM (D11:D2)

(ii)
 =AVERAGE (D4:G4)
OR
= (D4+E4+F4+G4)/4
OR
=AVERAGE (D4, E4,F4,G4)
OR
=SUM (D4:G4)/4
OR
=SUM(D4,E4,F4,G4)/4

(iii)
 Max Function.
OR
=MAX(E2:E11)

(iv)
Click on cell H8
Type “=SUM(D8:G8)”
Press “Enter”
OR
Click on D8
Hold down the Mouse and stop at H8/ Highlight D8 to H8
Click on Summation icon on the Menu Bar
OR
Click on H8
Type “=SUM (D8, E8,F8,G8)
Press “Enter”
OR
Click on H8
Type =SUM (D8:G8)
Press Enter

(v)
=IF(I11> 59, “PASSED”, “FAILED”)
OR
=IF(I11>= 60, “PASSED”, “FAILED”)

(b)
(i) MS PowerPoint
(ii) Presentation
(iii) Double-click on the icon
OR
Right-click on the icon
Select open
(iv) Title Slide
(v) Slide Show View Icon/Slide Show Icon/ Slide Show
(vi) F5
(vii)
-Insert Shapes
-Insert Textbox
-Insert WordArt
-Insert Comment
-Insert Video
-Insert Symbols
-Sound
Table
Clipart
Equation
New Slide
Pictures
Header/Footer
Date & Time
Text Box
Smileys etc.




6.
(a)
 (i) To Create a folder on the desktop

-Right-click on the desktop and select “New”
-Select “Folder”

(ii) Naming the folder

-Click on the default name of the new folder
-Type-in the name, Press enter or click elsewhere on the desktop
OR
Right-click on the folder icon and select “Rename”
-Type-in the New Name
OR
Select the folder, Click on the Default Name/New Folder,
Type New Name, Press Enter.

(iii) Sending a file to the new folder

-Double-click on “My Documents” folder icon
-Right-click on the desired file icon and select “copy”
-Open the folder created
-Paste the copied file
OR
Select the file in My Documents Folder,
Drag it to the created Folder on the Desktop,
Drop/Release the Mouse button
OR
Open the File in My Document ,
Click on File, Save As,
Select Desktop, Select Target Folder,
Click on Save.

(iv) Renaming the folder

-Right-click on the folder icon and select “Rename”
-Type-in the new name “RESULTS”
OR
Select the folder, Click on the Default Name/New Folder,
Type “RESULTS” as the New Name, Press Enter.

(b)
(i)
(I) Date of Birth---Date/Time
(II) Fees-------------Currency

(ii)
(I) –create a blank database and give it a name
-click on the “create” tab on the menu bar and select “table design/design
view”
-Type the field names and set the data types as required. Save the file
(II) –select the Mat.No field
-Right-click on the field and select primary key
OR
-Select the Mat.No field
-click on the primary key icon on the menu bar
(III) -click on the FullName field
-set the field size to 50
OR
Click on the FullName Field, Go to the Field Properties,
Change the Field Size from 255 to 50