Computer Studies Paper 2 Pre Mock Questions and Answers - Mokasa I Joint Examination July 2021

Share via Whatsapp

Instructions to candidates

  1. Indicate your name and index number at the top right hand corner of each printout
  2. Write your name and index number on the CD/Removable storage medium provided.
  3. Answer all the questions
  4. All questions carry equal marks
  5. Passwords should to be used while saving in the CD/Removable storage medium
  6. All answers must be saved in your CD/Removable storage medium
  7. Make a printout of the answers on the answer sheet
  8. Arrange your printouts and tie/staple them together
  9. Hand in all the printouts and the CD/Removable storage medium used
  10. This paper consist of 5 printed pages
  11. Candidates should check the question paper to ascertain that all the pages are printed as indicated and that o questions are missing


QUESTIONS

  1. MASL is a company thatengages in the sales of the following Mobile service providers: Faiba, Gateway, vodafone and SAF. The company uses sales representatives who operate at various regions in Nakuru town. Each sales representative presents monthly sales to the manager (Values are in Ksh).

     
    Mobile_Accessories Sales LTD
    2 Product type
    3 Sales Rep Faiba Gateway Vodafone SAF Total Sales 
    4 Kipkulei 24000 37500 39500 49500  
    5 Tom 15000 26500 21500 25500  
    6 Sharon 5500 14800 3500 16500  
    7 Oscar 7000 15500 14500 64500  
    8 Linda 11000 69000 2200 64500  
    9 Danelaw 33500 12000 14500 25500  
    10 Muriithi 15500 80000 17200 23500  
    1. Using spreadsheet package,
      1. Enter the information given in the table 1 into a worksheet.Save workbook as MASLREPS and rename sheet 1 as Sales. (20 marks)
      2. Validate all the cells in the Product Type columns to allow entry of numeric data only.
        A message, “Invalid data! Enter numbers” should be displayed whenever a cell is typed with non-numeric data. (3 marks)
    2. Using formulae, determine the;
      1. Total sales for each Sales representative (2 marks)
      2. Producttype Total Sales for each month. (2 marks)
    3. Each sales person earns Bonus points for the sales of each product type based on the following criteria.
      • 1 point if sales are greater than 50,000 for Faiba,
      • 2 points if sales are greater than 60,000 Gateway,
      • 3 points if sales are greater than 50,000 Vodafone
      • 2 points if sales are greater than 60,000 for SAF
        Insert a column BonusPoints and compute the points of each sales Person. (4 marks)
    4. Insert a blank column Awards and based on the Total Sales earned by each sales representative. Use a function to display the remarks on Awards as follows: (5 marks)
      Total Sales                                                  Awards
      More than 250,000                                         Cash
      More than 100, 000 and less than 250,000     Voucher
      Less than 100,000                                       Try again
    5. Format the figures in worksheet as follows: (4 marks)
      • Title and subtitle:
        • Double underline
        • Font type – Algerian
        • Font size 26
      • Apply borders to the data in the workbook.
    6. Rotate Up, all the Product Type heading labels in the worksheet. (1 mark)
    7. Generate a column chart to representthe Total sales for each salesrepresentative. Label your chart accordingly and place it in worksheet 2 renamed as CHART. (7 marks)
    8. Print MASL and CHART (2 marks)
  2. Using word processing program type the document as it appears and save it as EDUC AI
    ARTIFICIAL INTELLIGENCE IN EDUCATION
    For decades, science fiction authors, futurists, and movie makers alike have been predicting the amazing (and sometimes catastrophic) changes that will arise with the advent of widespread artificial intelligence. So far, AI hasn’t made any such crazy waves, and in many ways has quietly become ubiquitous in numerous aspects of our daily lives. From the intelligent sensors that help us take perfect pictures, to the automatic parking features in cars, to the sometimes frustrating personal assistants in smart phones, artificial intelligence of one kind of another is all around us, all the time.
    WWWWWWWWWWWWWWWWW
    • Automation of basic activities in education, like grading.
    • Educational software can be adapted to student needs.
    • It can point out places where courses need to improve.
    • Students could get additional support from AI tutors.
    • AI may change where students learn and how they acquire basic skills.
    • It is altering how we find and interact with information.
      Automation basic activities in education, like grading.
      In lower grades, teachers often find that grading takes up a significant amount of time, time that could be used to interact with students, prepare for class, or work on professional development.A1 can be used to automate grading systems and present the output in tables .


      GRADE THREE COMMON EXAMINATION
      SIR NAME  LANGUAGE  SKILLS  COMPUTING SKILLS ENVIRONMENTAL SKILLS Total Score
      Macmillan 87 50 78     
      Trevor 92 95 76
      Johnstone 73 85 90
      Kathleen 67 56 75
      Count        
      Highest Scores        
      Educational software can be adapted to student needs.
      From kindergarten to graduate school, one of the key ways artificial intelligence will impact education is through the use of application programs.learners can draw 3D diagrams such as the one shown below
      UPUPUPUU
      Teachers may not always be aware of gaps in their lectures and educational materials that can leave students confused about certain concepts. Artificial intelligence offers a way to solve that problem.
      1. using a word processing application software type the document below as it appears and save it as EDUC AI (22 Marks)
      2. Copy the document EDUC AI in a new document and save it as EDUC AI2 then use it to answer the questions that follows (2 Marks)
      3. Format the heading as follows;
        • Center align, font size – 14, font color – red, font type – Algerian, double underline, scale – 130% (3 Marks)
      4. Insert your name, Adm No ,system time as a header and your class and page number as a footer (2 Marks)
      5. Spell check the document to remove all typing errors (2 Marks)
      6. Center align the first paragraph (1 Mark)
      7. Find all occurrences of the word AI in the document and replace with “Artificial Intelligence “ (1 Mark)
      8. Resize the diagram between the last two paragraphs and move it to the second paragraph and send it behind text (3 Marks)
      9. On the grade three table,
        1. Split the cells in the total score column to separate each students’ marks (1 Mark)
        2. Insert a new row at the bottom of the table to display the average total scores and merge the first four columns of the row (3 Marks)
      10. Use appropriate function to calculate:
        1. Total score (2 Marks)
        2. Number of students who did each exam (2 Marks)
        3. Highest score attained in each subject (2 Marks)
        4. Average total scores (2 Marks)
        5. Print EDUC AI (1 Mark)
        6. EDUC AI2 (1 Mark)


MARKING SCHEME

QN

Section/Activity

Marks

Max mark

Marks awarded

1.

a)       

Creating workbook MASL REPS

  • Naming Worksheet 1 As Sales
  • Typing data accordingly,into rows/columns
  • Input validation, with correct parameters

1 mark

1 mark

18 marks

3 marks

23 marks

 

b)       

Using correct formulae to:

  1. Total Sales for each sales rep
  2. Total Sales for each product

2 marks

2 marks

4 marks

 

c)       

Inserting Bonus Points column& Computing points

  • Create column
  • Using appropriate function or formulae

Calculate/compute bonus

1 mark

1 mark

2 marks

4 marks

 

d)       

Inserting column Awards

  • Use of IF function to display remarks

1 mark

4 marks

5 marks

 

e)       

Formatting worksheet

  • Double underline
  • Font type – Algerian
  • Font size – 26pts
  • Applying borders to data in worksheet

1 mark

1mark

1 mark

1 mark

4 marks

 

f)        

Rotating headings: All Product Type heading labels(Sales Rep., Faiba, Gateway, Vodafone, SAF, Total Sales).

1mark

1 mark

 

g)       

Inserting chart: Total sales vs Sales representatives

  • Chart title
  • X axis title
  • Y axes title
  • Legend
  • Data labels (Minimum & maximum ranges)

Renaming worksheet 2 as CHART

1 mark

1mark

1 mark

1 mark

1 mark

1 mark

1 mark

7 marks

 

h)       

Printing worksheets:

  • MASL
  • CHART

1 mark

1 mark

2 marks

 

 

TOTAL MARKS

50 MARKS

 

Qestion 2 -Word Processing

No.

Particulars

Marks

Award

a.

fully typed text

5

 

4 Paragraphs indication @ 1/2 Mark each

2

 

dropcap

1

 

columns

1

 

Bullets

1

 

line between columns

1

 

paragraph title italics & bolding

2

 

Correctly filled table

3

 

table correct outer border

1

 

table row shading and text color( white)

1

 

correctly drawn diagram

3

 

saving with correct file name

1

 

b

creating a copy

1

 

saving with correct file name

1

 

c

heading format @ 1/2 Mark each

3

 

d

correct header

1

 

correct footer

1

 

e

spelling error free

2

 

f

correct alignment

1

 

g

finding and replacing all

1

 

h

resizing diagram

1

 

object placement

1

 

text readability over graphics

1

 

j

i

cell splitting

1

 

ii

inserting row

1

 

cell merging

1

 

appropriate row heading

1

 

k

i

total score

2

 

ii

number of students

2

 

iii

highest score

2

 

iv

average total score

2

 

l

i

print EDUC AI

1

 

ii

print EDUC AI2

1

 

TOTAL MARKS

50

 

Join our whatsapp group for latest updates

Download Computer Studies Paper 2 Pre Mock Questions and Answers - Mokasa I Joint Examination July 2021.


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?

Join our community on:

  • easyelimu app
  • Telegram
  • facebook page
  • twitter page
  • Pinterest