Elective ICT Practical 2017 & Subjective

Elective ICT Practical 2017
PRACTICALS
- (a) With the help of an appropriate text editor, create the HTML codes to produce the page below:
(b) Set the title of the page to your full name and index number. The program codes must be properly indented.
E.g.:
<p>
<u>Item</u>
</p>
(c) Save the file as FORM.HTML in the folder created. [15 marks]
2. The table below shows the registration of mobile telephone subscribers of the various network operators in a country from 2008 to 2014.
(a) Use a spreadsheet program to create the table below:
YEAR | NETWORK OPERATOR | ||
SIMPSONS | STAR | RAPAPA | |
2008 | 673 | 764 | 894 |
2009 | 761 | 876 | 948 |
2010 | 788 | 797 | 837 |
2011 | 872 | 747 | 821 |
2012 | 827 | 802 | 797 |
2013 | 392 | 347 | 833 |
2014 | 903 | 399 | 837 |
(b) Using appropriate formula compute the:
(i) column totals for each network operator
(ii) grand total of subscribers on yearly bases
(c) Create a bar chart to compare the subscribers on yearly bases.
(d) Insert a footer with your full name
(e) Save the workbook as SUBSCRIBERS in the folder created. [15 marks]
3. (a) Using an appropriate database, create a database and save as DATA in the folder created.
ID-NO | SOCIAL | ENGLISH | FRENCH | LEVEL |
10097 | 87 | 65 | 77 | 1 |
10099 | 76 | 84 | 76 | 2 |
10022 | 66 | 77 | 87 | 3 |
10077 | 54 | 55 | 22 | 2 |
10064 | 67 | 89 | 90 | 1 |
(b) Create:
(i) the structure for the table above and save as SCORES.
(ii) a form that will enable users to enter the data in SCORES and save as SFORM.
(c) Use the form in 3 (b)(ii) to enter the data as shown in the table above.
(d) Create a query to retrieve:
(i) data from SCORES and organize it as shown in the structure in the structure below;
ID-NO | LEVEL | SOCIAL | FRENCH | LEVEL |
save as ROQUERY.
(ii) all records for LEVEL 1 and save as L1QUERY. [15 marks]
ELECTIVE ICT PASCO 2017 ESSAY
- (a) What is physical topology with respect to computer networking?
(b) Identify the following network topologies
(i)
(ii)
(c) Explain the topologies identified in 1(b)
- (a) Explain e-business
(b) State three benefits of e-business
- (a) What is:
(i) Relationship, as used in database;
(ii) Lookup field?
(b) Explain the following database relationship types:
(i) One-to-one;
(ii) one-to-many;
(iii) many-to-many
- (a) What is:
(i) Computer port;
(ii) Computer bus;
(iii) Clock speed of a central processing unit (CPU)?
(b) State one difference between:
(i) Data bus and address bus;
(ii) Magnetic disk and optical disc.
- (a) Explain internet chatting
(b) What is a cookie?
(c) List four examples of browsers
Recommended:
- Elective ICT Practicals 2018 and Subjectives
- Elective ICT Pasco 2017 Objectives
- Elective ICT trial Questions
- Elective ICT Trial Questions-2
Join our Discussion Forums below.
<<< CLICK HERE TO JOIN OUR GENERAL 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.