waec data processing

DATA PROCESSING OBJ:
1-10: BCBDDDBBAA

*DATA PROCESSING*
1 – 5 ππ

(1a)
A function is a predefine formula that perform calculates using specific value in orderly manner

(1b)
(i)Date and time
(ii)Statistics and test

(1c)
It the value of a different cell on the current worksheet

(1di)
(i)Relative
(ii)Absolute

(1dii)
(i)Relative = A1+B1
(ii)Absolute

*OR*

(1a)
A function in MS Excel is a predefined formula that performs calculations using specific values in a particular order.

(1b)
(i) Compatibility
(ii) Database

(1c)
A cell referencing in Excel refers to the value of a different cell or cell range on the current worksheet or a different worksheet within the spreadsheet.

(1di)
(i) Relative reference
(ii) Absolute reference

(1dii)
(i) Relative: =G2*H2
(ii) Absolute: =\$A\$2

==========

(2a)
(i)Typing
(ii)Photocopying
(iii)Lamination

(2b)
(i)Printer
(ii)Photocopy machine
(iii)Computer system

(2c)
(i)MS excel
(ii)MS word

(2d)
(i)Anti-virus software
(ii)System dependency

*OR*

(2a)
(i) Photocopying
(ii) Scanning
(iii) Printing

(2b)
(i) Computer system
(ii) Scanner
(iii) Printer

(2c)
(i) Microsoft Office
(i) Microsoft Excel

(2d)
(i) He should make sure his anti virus is up to date
(ii) He should use USB Disk Security always

===========

(3ai)
Press Ctrl + , (comma) while nothing is selected (i.e select Pick tool and click on blank place and then press CTRL+, and then you have permanetly set up default angle to “0”).

(3aii)
Align Right: R.
Align Left: L.
Align Center Vertically: C.
Align Center Horizontally: E.

(3aiii)
Hold down the Ctrl + Home keys together as following screenshot shown, the cursor will be jump to the cell A1 from anywhere of the worksheet.

(3b)
(i) It tell Google or any search engine to find the exact format

==============

(4ai)
(I)Easy to access
(II)Easy it to retrieve
(lII)efficient maintenance

(4aii)
(I)Financial difficulties
(II)spellings and handwriting skills
(II)technical problem

(4bi)
(i)It warms you up: Air conditioning is useful over the winter months too, it cools you down in the summer but multi-function systems keep you warmer during the cold snaps as well.

(ii)It improves air quality: Run air conditioning systems and they filter particles from the air which can harmful to human health.

(4bii)
(i)To Prevent Loss of Data
(ii)To Save Time and peace of mind

*OR*

(4ai)
(i) Its ability to replcate data automatically helps in data recovery if database in any site is damaged
(ii) When a component fails, the functioning of the system continues may be at a reduced performance, hence, making it reliable
(iii) It has a lower communication cost

(4aii)
(i) Constant use of computers to process informaton in school will make students technological dependent.
(ii) Deterioration of the teacher role in the learning process
(iii) Excessive individualization of learning due to computer usage can lead to denial of the teacher
(iv) Use of computer which may hinder step by step students mental activity by the teacher stops them from developing creative abilities and entrepreneur spirit and initiative

(4bi)
(i) To help in cooling the computers
(ii) To control dust in the computer laboratory

(4bii)
(i) To prevent loss of data
(ii) To protect the computer equipment connected to power by stabilizing the voltage passing through.

(5a)
The steps the secretary would take to displace the number for f words
– He would go to menu bar
– Click on reference
– Then click on view menu
– Then click on document summary
– This would display number of words lines of text number of pages and number of paragraphs

(5b)
– The secretary will open the two documents
– The secretary will click on the menu bar
– The point to view with the mouse pointer
– Then click on cascade the windows
– The two windows will display simultaneously

(5c)
– Go to menu bar
– Click on file menu
– Click on document directory
– The right click on the file that has the document you want to protect
– Then click on password protect

136 Views