NECO 2022 DATA PROCESSING (PRACTICAL) VERIFIED ANSWERS

NECO 2022 DATA PROCESSING PRACTICAL ANSWERS

(1B)
(i)
Coming soon

(ii)
(a) Primary key can be defined as the column or columns that contain values that uniquely identify each row in a table.

(b) A table is an arrangement of information in rows and columns containing cells that make comparing and contrasting information easier.

(iii)

• dBASE
• FoxPro
• SQLite
• IBM DB2

(iv) A database is an organized collection of structured information, or data, typically stored electronically in a computer system.

≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠

(2B)
(i)
Coming soon

(ii)

• Apple numbers
• Easy Calc
• GS-Calc
• Lotus 1-2-3

(iii)
(a)
A workbook is a collection of worksheets that are saved together in one file WHILE A worksheet is the grid of columns and rows that information is inputted into.

(b)
Data Sorting is the process of arranging data into meaningful order so that you can analyze it more effectively WHILE Data filtering is the process of choosing a smaller part of your data set and using that subset for viewing or analysis.
≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠≠

(3B)
(i)
Coming soon

(ii)
(a) Eyedropper: It is used to sample or pick up the desired color, pattern, or texture from an object that’s already filled

(b) Fill: It is used to add colored, patterned, textured, and other fills to the inside of objects or other enclosed areas. I

(c) Shape edit: It is used to edit objects, curves, and text by manipulating their nodes.

(d) Outline: It is used to change the appearance of lines and outlines.

(iii)

• Go to the File menu and select Save As. The Save Drawing dialog box opens:
• Browse for the location where you wish to save your drawing.
• You can also choose how to view your files by clicking Choose view in the top right corner:
• Name/rename the drawing in the File name field.
• Click the Save button.