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

Share via Whatsapp

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

Q

SECTION

 

ACTIVITY

MARKS

1

a)

(i)

Creating a database name “LANJET”

1

   

(i)

Table 1

-Creating and naming tables 1 Mark each (Check correct naming in capital letters)

-Creating and naming fields 8 Fields each ½ Mark

-Correct Data types

SchoolCode, SchoolName, Address, TelNo: Text RegFee: Currency

Table2

TeamID, TeamName: Text

Table3

TeamID: Text

GoalsFor& Goals Against: Number

 

3

 

 

4

 

2

 

1

 

1

 

1

 

1

   

(ii)

PK – SchoolCode, TeamID and TeamIDeach ½ Mark Correct 3 Relationships each 1 Mark

3

   

(iii)

Creating data entry forms 3 @1Mark Data Entry 15 @½ Mark

3

 

B

 

Query displaying Fixtures

3

     

Use of correct Fields

2

C

Correct Query Formulae for Played, Won, Drawn, Lost, Goal

12

Difference and Points @2Marks

Naming of Queries 1 Mark

1

 

D

(i)

Printing tables

1

   

(ii)

Printing Fixtures Results

1

   

(ii)

Printing the League Report

1

         

2

A)

a)

Name saved as LANJET

1

     

Borders available for all entries

3

     

Data entered correctly with correct decimal places and formatting of the tables

9

   

b)

Check correct Absolute formulas and relative cell references for each person

5 Relative cell References @ 1 Mark

 

5

Join our whatsapp group for latest updates

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


Tap Here to Download for 50/-




Why download?

  • ✔ To read offline at any time.
  • ✔ To Print at your convenience
  • ✔ Share Easily with Friends / Students


Get on WhatsApp Download as PDF
.
Subscribe now

access all the content at an affordable rate
or
Buy any individual paper or notes as a pdf via MPESA
and get it sent to you via WhatsApp

 

What does our community say about us?