DATA PROCESSING PRACTICAL ANSWERS
(1A)
To be done using a computer.
(1Bi)
(i) I ensured to create backup regularly
(ii) I ensured to exit properly from the MS Access database after working.
(1Bii)
(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.
(1Biii)
(i) dBASE
(ii) FoxPro
(iii) SQLite
(iv) IBM DB2
(iv) A database is an organized collection of structured information, or data, typically stored electronically in a computer system.
===========================
(2A)
To be done using a computer.
(2B)
(i) I ensured to save periodically to avoid loss of progress while working.
(ii) I ensured to adhere to instructions while working.
(2Bii)
(i) Apple numbers
(ii) Easy Calc
(iii) GS-Calc
(iv) Lotus 1-2-3
(2Biii)
(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.
===========================
(3A)
To be done using a computer.
(3Bi)
(i) I ensured that all text is outlined correctly
(ii) I set the page size dimensions including bleed size, without drawing trim marks.
(3Bii)
(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.
(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.
(3Biii)
(i) Choose the file
(ii) Locate the folder where you want to save the file.
(iii) Choose a version from the version list box
(iv) Enter a file name for the drawing in the provided space
(v) Click Save.
===========================
COMPLETED