Elective ICT Practicals 2020
Elective ICT WASSCE Practicals 2020.
Answer all the questions.
- Payment for telephone calls in a country is calculated based on the following conditions:
Types Of Call | Amount For First 3 Minutes | Amount For Every Addition Minute |
Local | 10 | 5 |
Trunk | 20 | 10 |
Foreign | 30 | 15 |
Calls made on a particular day are as shown below:
Customer Name | Call Type | Duration In Minutes | Amount Payable |
Yoko | Local | 8 | |
Fafana | Foreign | 10 | |
Ali | Foreign | 9 | |
Yaba | Trunk | 20 | |
Mawusi | Local | 13 | |
Kali | Local | 2 | |
Ogbara | Foreign | 3 |
Using an appropriate spreadsheet program and the table above:
(a) Calculate the:
(i) amount payable per customer;
(ii) maximum amount due per type of call;
(iii) total amount due the operator of the call centre that day.
(b) Using the header facility, insert your full name and index number.
(c) Save work as CALLS in the folder created [15 marks]
- A continuous assessment report created by a teacher is shown in Figure 1.
Continuous Assessment
Index No | Candidate | Subjects | |
English | Mathematics | ||
10000 | Dennis Brown | 56 | 80 |
10001 | Robert Asante | 85 | 70 |
Figure 1
Using an appropriate text editor:
(a) Write the HTML codes to produce the document in Figure 1.
(b) Use heading level 1 for “Continuous Assessment”.
(c) The title of the document should be a “Class 1 Assessment”.
(d) Add a third entry to the table with your index number and full name for the Index No and Candidate columns respectively. Assign yourself any marks for the two subjects.
(f) Save the document as ASSESSMENT.HTML in the folder created. [15 marks]
Check Also: Elective ICT Practical 2019
- Write Use an appropriate database application to design a database and name it DBCustomers in the folder created.
(a) Create an appropriate database with the following fields:
(i) Customers-Id: Format this field such that it accepts only letters as the first two characters and only numeric for the last four characters. Example ZZ8888
(ii) First_Name: Text
(iii) Last_Name: Text
(iv) Country: Must be formatted to be a Lookup field; with the following regions displayed in a combo box to be selected from: Ghana, Togo, Benin, Nigeria, Sierra Leone and Kenya.
(v) Location: Text
(vi) Tel-Number: Must be formatted to appear like 030-X-XXX-XX. It must accept only numerics with X as a place holder.
(b) Save the table as tblCustomers.
(c) Enter the following records into the table:
Customer-Id | First_Name | Last_Name | Country | Location | Tel-Number |
GH001 | Nora | Amanor | Ghana | Tema | 030-5-624-83 |
TG001 | Kofigo | Akafu | Togo | Pinu | 063-4-541-89 |
NG001 | Rafui | Okelu | Nigeria | Kanu | 029-5-642-93 |
BN002 | Kareen | Djubeli | Benin | Benin | 092-5-472-88 |
(d) Create a query to show the fields Customer-Id, Customer_Name, Country, Location and Tel-Number from the tblCustomers, where Customer_Name is the merged fields of the First_Name and Last_Name from the tblCustomers.
(e) Save the query as QRYCUSTOMERS.
[15 marks]END OF PAPER
Recommended:
- Elective ICT Practicals 2020
- Elective ICT Practical 2017 & Subjective
- Elective ICT Pasco 2017 Objectives
- Elective ICT Practicals 2018 and Subjectives
- Elective ICT Pasco 2018 Objectives
- Elective ICT trial Questions
- Elective ICT Trial Questions-2
Join our Discussion Forums below.
<<< CLICK HERE TO JOIN OUR WHATSAPP GROUP >>>
<<< CLICK HERE TO JOIN STUDENTS FORUM ON WHATSAPP >>>
<<< CLICK HERE TO JOIN OUR TEACHERS PORTAL GH ON TELEGRAM >>>
<<< CLICK HERE TO JOIN OUR ICT TEACHERS PLATFORM>>>
Please don’t forget to share this post. Click on the WhatsApp, Facebook, Twitter, Instagram button below to share the post.