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.
Wow! It’ll make learning of IT more inclusive. Keep it up boss.