Computer Studies Paper 2 Questions and Answers - Lanjet Joint Mock Exams 2022

Instructions to candidates

1. Type your name and index number at the right hand corner of each print out
2. Write your name and index number on the CD-ROM provided
3. Answer all the questions
4. Passwords should not be used while saving your work
5. All answers should be saved in the CD-ROM provided
6. Make the print out of the answers on the answer sheets provided
7. Arrange your print out and stable them together
8. Hand in all the print outs and the CD-ROM provided
9. Candidates should check the question paper to ascertain that no question is missing.

QUESTIONS

1. The data in the tables below was extracted from LANJET football league management system.
   Table 1: TEAMS TABLE
   

   School Code	School Name	Address	Tel No	Reg Fee
   01	Anestar High	Box 273	024542148	50000
   02	Gabriel School	Box 2454	025485267	35000
   03	Kabarak High	Box 458	025478756	47000
   04	Sacho High	Box 635	032547855	24000
   05	Nairobi High	Box 2446	032458754	12000
   06	Nakuru High	Box 6589	015487564	14000
   07	Baringo High	Box 1254	031204543	50000

   Table 2: FIXTURES TABLE
   

   Team ID	Team Name
   01	Anestar High
   02	Gabriel School
   03	Kabarak High
   04	Sacho High
   05	Nairobi High
   06	Nakuru High
   07	Baringo High

   Table 3: RESULTS TABLE
   

   Team ID	Team Name	Goals For	Goals Against
   01	Anestar High	6	6
   02	Gabriel School	5	2
   03	Kabarak High	5	4
   04	Sacho High	2	5
   05	Nairobi High	4	3
   06	Nakuru High	1	1
   07	Baringo High	0	6

   1.                                      
      1. Create a database named “LANJET” to store data above (14 Marks)
      2. Create relationships between the tables (4½Marks)
      3. Use form to enter data into the tables (10½Marks)
   2.                        
      1. Create a query to display the fixtures for the league (3 Marks)
   3. Create a query and use it to generate a report for a league which displays Games played, Won, Drawn, Lost, Goals For, Goals Against, Goals difference and Points taking note that a win earns a team 3 points, draw 1 point and a loss 0 points (15 Marks)
   4. Print the:
      1. Three tables
      2. Output for query results on Fixtures
      3. The league report (3Marks)
2. The LANJET Bank of Kenya (LBK) exchange rates on a certain day for foreign currencies against the Kenya shillings (Kshs) were as follows
   

   Currency	LBK Mean Rate (Kshs)
   1 US Dollar	67.0222
   1 sterling pound	137.7984
   1 Euro	96.6552
   1 S.A Rand	10.3100
   1 Sweddish Kroner	10.4509

   John, Gilbert, Geofrey, Weldon and Bernard trade in buying and selling of foreign currencies. On that day they bought the following foreign currencies from LBK.
   

   Name	U.S Dollars	Sterling Pounds	Euros	S.A Rands	Swedish Kroner
   John	400	200	340	1200	290
   Gilbert	500	400	400	2000	3000
   Geofrey	200	600	300	4000	5000
   Weldon	600	200	200	1000	3000
   Bernard	400	200	600	2000	1000

   They then sold their foreigner currencies at the following rates
   

   Name	U.S Dollars	Sterling Pounds	Euros	S.A Rands	Swedish Kroner
   John	70.5	139.0	96.7910	10.4213	10.6725
   Gilbert	69.0	138.5	96.79	10.5712	10.2676
   Geofrey	70.0	141.5	96.76	10.3974	10.7432
   Weldon	69.55	139.0	96.80	10.6371	10.5942
   Bernard	69.5	138.5	96.40	10.7218	10.6155

   1. Using a spreadsheet package, represent the above information in one worksheet and save it as LANJET (13mks)
   2. Using formulae with absolute and relative cell references, determine the total profit made by each trader. (14mks)
   3. Round off the profit for each trader to zero decimal places (2mks)
   4. Generate a form and use it to add details for Wesley with the following details
      

      Name	U.S Dollars	Sterling Pounds	Euros	S.A Rands	Swedish Kroner
      Wesley	69.8	140.5	96.75	10.4563	10.4689

      (13mks)
   5. Use a function to determine the trader who got the highest profit (3mks)
   6. Format the first table as follows:
      • Set the direction of the labels to 45degrees (2mks)
      • Centre vertically all the records (1mk)
   7. Print the worksheet, the form (Print screen of it) and the graph (2mks)

 MARKING SCHEME