Question 5
Given an internet connected computer, outline a step by step procedure for carrying out the following operations:
- how to log on to www.mybooks.com and obtain the prices of books W, X, Y, Z and M.
- how to tabulate the prices in a worksheet, showing the prices in dollars and the naira equivalent, for each book and save the workbook as “Prices of Books”.
- how to send the workbook in 5(b) as an attachment to your father’s email address (myfather@yahoo.com) with the subject “Prices of Books”.
Assume that the prices of the books are given in dollars, [use $1.00 = N120.00]
Observation
The expected answers were:
(a) Step 1- Launch the internet browser and Type www.mybooks.com in the address bar.
Step 2 - Click on “go” or press the “Enter” key.
Step 3 - Type Price of W,X,Y, Z, and M respectively in the search box to search for the books and their prices
OR
Scroll through lists of books and their prices
OR
Click on icon that shows list of books and prices
(b)
Steps:
- Launch MS Excel
- Enter “Name of Book” “Book Price $”, “Book Price N” in any row respectively
[Accept any valid cell reference e.g. cells A1 to D1]
- Enter/Type the book names in cells under the “Name of Book”
[Accept any valid cell reference e.g. cells B2 to B6]
- Enter/Type prices in dollars in cells under “Book Price $”,
[Any valid cell reference e.g. cells C2 to C6]
- Click on the cell under “Book Price N”
- Type the formula to multiply dollar price with 120.
[Accept any valid cell reference e.g. “=C2*120” OR
“=Price of Books in $ *120” and press the “Enter” key.]
- Copy the formula to other cells under “Book Price N”/ Repeat step (v) for all books/ Press the fill handle of the cell in (v) above, and drag down to other books.
- Click on File, Save As/Ctrl+ S /F12,
- Type “Prices of Books” as File Name
- Press Enter/Click on Save.
(c) Steps:
- Launch email / Open email account and Click on “Compose/New message
- In the “To” bar/box/field, type myfather@yahoo.com.”
- In the “Subject” bar/box/field, type “Prices of books”
- Click on “attach files/ attachment” to attach
- Browse for the saved file “prices of books.xls”
- Click on “attach files” to attach the file
- Click on “Send” to send your mail.
OR
Click on File -
Select share -
Click on E-Mail -
Select send as attachment -
Type myfather@yahoo.com -
Click on send -
OR
Right click on the file icon -
Select send to -
Click on mail recipient -
Type myfather@yahoo.com -
Click on send -
OR
Click in File -
Select save & send -
Click on send using E-Mail -
Click send as attachment -
Type myfather@yahoo.com -
Click on send -
There was poor response to the questions signifying candidates’ lack of practical knowledge.