Given an internet connected computer, outline a step by step procedure for carrying out the following operations; (a) How to log on to www.mybooks.com and o...

Assessment: WAEC SSCE - Data Processing - 2015 (Essay and Test of Practical Work) Subject: Data Processing

Question 1 Report

Given an internet connected computer, outline a step by step procedure for carrying out the following operations;

(a) How to log on to www.mybooks.com and obtain the prices of books W, X, Y, Z and M.

(b) 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". Assume that the prices of the books are given in dollars, [use $1.00=N120.00].

(c) How to send the workbook in 5(b) as an attachment to your father's email address (myfather@yahoo.com) with the subject "Price of Books".

Answer Details

5(a) Obtaining the prices of the books

  1. Switch on the internet-connected computer.
  2. Open a web browser such as Google Chrome, Mozilla Firefox or Opera.
  3. Click the address bar, type www.mybooks.com and press Enter.
  4. Locate the list of books and identify the price column.
  5. Read and record the dollar prices of books W, X, Y, Z and M.

5(b) Worksheet showing the prices and naira equivalents

  1. Open Microsoft Excel or another spreadsheet package.
  2. Enter the headings and values below in the worksheet.
ABC
1BookPrice ($)Naira Equivalent (₦)
2W12.501,500.00
3X15.001,800.00
4Y8.751,050.00
5Z20.002,400.00
6M10.001,200.00
  1. In cell C2, enter =B2*120 and press Enter. This gives ₦1,500.00 for book W.
  2. Use the fill handle to copy the formula from C2 down to cells C3:C6. Thus, b7aira equivalent = dollar price × 120.
  3. Click File, select Save As, type Prices of Books as the file name and click Save.

5(c) Sending the workbook as an attachment

  1. Open a new browser tab and visit an email service provider, for example www.yahoo.com or www.gmail.com.
  2. Sign in with a valid email address and password.
  3. Click Compose or New Mail.
  4. Type myfather@yahoo.com in the To box.
  5. Type Price of Books in the Subject box.
  6. Type a brief message, for example: Attached is the prices of books for your perusal.
  7. Click the paper-clip Attach icon, browse to the saved workbook Prices of Books, select it and wait for the upload to finish.
  8. Click Send.

Download The App On Google Playstore

Everything you need to excel in your exams

Green Bridge CBT Mobile App
Personalized AI Learning Chat Assistant
200,000+ Exam Questions Across IGCSE, JAMB, WAEC & NECO
Over 3,900 Lesson Notes
Offline Support - Learn Anytime, Anywhere
Green Bridge Timetable
Literature Summaries & Potential Questions
Track Your Performance & Progress
In-depth Explanations for Comprehensive Learning