Computer Studies Paper 2 Questions and Answers - Lainaku II Joint Mock Examination 2023

INSTRUCTIONS TO CANDIDATES

• Write your name and index number on the CD-R/ CD-RW provided.
• Write the name and version of the software used in each question attempted in the printouts used.
• Answer all the questions.
• All questions carry equal marks.
• Passwords should not be used when saving files.
• All files must be transferred to the CD-R/ CD-RW.
• Make printouts of your answers on the papers provided for printing.
• Arrange your printouts and tie/ staple them together.
• Hand in all the printouts and the CD/removable storage medium provided.
• Candidates must answer the questions in English

1.  
   1. Open a word processing program and type the document below as it appears and save it as CBC. (15 marks)
                                PARENT’S ROLES IN COMPETENCY BASED CURRICULUM
      Kenya has embraced a Competency Based Curriculum (CBC) to increase skills development and instill values in the learner. Parental empowerment and engagement in the learning process is essential to the learner’s growth and development. As a parent, you are the first educator, trainer and source of authority for your child. The purpose of this brochure, therefore, is to give you more information about CBC and your role in the learning process of your child.
                                                  WHAT IS COMPETENCY BASED CURRICULUM?
      This is a process that gives learners an opportunity to be actively involved in learning. It facilitates identification and development of learner’s unique talents and abilities through different career pathways after grade 9. CBC assists learners acquire, nurture and apply values in day to day living
                                                WHY THE CHANGE FROM 8-4-4 CURRICULUM TO CBC?
      The Competency Based Curriculum was rolled out nationally in January 2019 in Early Years Education. The difference between 8.4.4 and CBC;
      

      From 8-4-4	To CBC
      Focuses on teaching	Focuses on practical learning
      Focuses on memorization of content	Focuses on application of knowledge
      Focuses on academic achievement	Focuses not only on academic achievement but also on skills development and nurturing of values
      Focuses on examination and results	Focuses on what the learner is expected to achieve and provision of feedback on the learner’s progress
      Focuses on competition	Focuses on collaboration
      Not all learners transited to the next level	Facilitates smooth transition for all learners
      Less emphasis on talent and career progression	More emphasis on talent identification and career development
      Less parental engagement in learning	More parental empowerment and engagement

      
      The following are general roles to support the learning of your child in CBC
      • Provide basic necessities.
      • Protect your child from physical and emotional harm.
      • Instill and nurture morals and values.
      • Teach and guide children to make the right choices and make them aware of consequences.
      • Teach and model proper use of resources.
      • Instill a sense of responsibility by ensuring children participate in age-appropriate chores.
      • Help in enhancing learning achievements in your child as guided by the teacher.
      • Engage with the teacher to enrich your child’s learning experiences.
      • Provide tender, loving care to boost your child’s emotional safety and a sense of belonging.
      • Take part in school activities such as academic clinics, talent
        Required
   2. Set page margins as follows:
      1. Left margin: 6 Picas (2 marks)
      2. Right, Top and Bottom margins: 3 Picas (2 marks)
   3. Apply 1.5 line spacing on the entire document (2 marks)
   4. Insert an in margin drop cap on paragraph 1 dropped to 4 lines (2 marks)
   5. Save the document as CBC-1 (2 marks)
   6. Print out the following:
      1. CBC (2 marks)
      2. CBC-1 (2 marks)
2.  
   1. The following is an extract from Wavumbuzi Entrepreneurship Challenge showing the performance of different participants over the Six-week period.
      

      	A	B	C	D	E	F	G	H	I	J	K	L
      1	WAVUMBUZI ENTREPRENEURSHIP CHALLENGE
      2				SCORED POINTS
      3	NAME	SEX	SCHOOL	WK1	WK2	WK3	WK4	WK5	WK6	TOTAL POINTS	AVERGAGE POINTS	MEDAL
      4	Satrah	F	LSS	80	180	360	500	700	900
      5	Dennis	M	MHS	100	200	300	400	650	800
      6	Jules	F	CSS	75	120	225	350	480	600
      7	Faith	F	BHS	60	100	250	320	450	630
      8	Dylan	M	KHS	90	150	350	600	750	680
      9	Kenan	M	FMSS	70	160	210	320	500	700
      10	Sheillah	F	SSS	80	170	300	480	535	670
      11	Pauline	F	NHS	100	250	400	650	800	1000
      12	Albert	M	JSS	50	100	200	430	500	660
      13	Fiona	F	MGHS	80	150	320	450	490	600
      14
      15	TOTAL FOR FEMALE
      16	TOTAL FOR MALE

      
      
      1. Using a spreadsheet package, enter the above information and save it as (11 marks)
         Wavumbuzi Challenge
      2. Format the worksheet to appear as it is (4 marks)
      3. Rename the worksheet containing the data as Wavumbuzi-1 (1mark)
      4. Copy the contents of Wavumbuzi-1 to another worksheet and rename it as Wavumbuzi-2 (2 marks)
   2. Type a formula at:
      1. Cell J4 to compute the total points for Sarah (2 marks)
      2. Apply the formula to the appropriate cells (1 mark)
   3. Type a function at:
      1. Cell K7 to compute the Average Points for Faith. (2 marks)
      2. Apply the function to the appropriate cells. (1 mark)
   4. A participant earns a medal based on the Average Points scored as follows:
      

      Average points	Medal
      500 and above	Gold
      300-499	Silver
      Below 300	Bronze

      
      
      1. Type a formula in L5 to determine David’s medal (3 marks)
      2. Apply the formula to other appropriate cells (2 marks)
   5. Insert a blank column after average points and label it RANK. Using appropriate function, compute the rank of the participants based on the average points in descending order (5 marks)
   6.  
      1. Using appropriate functions, compute the:
         1. Total points for the female per week in cell D15 (2 marks)
         2. Total points for the male per week in cell D16 (2 marks)
      2. Apply the functions to the appropriate cells (2 marks)
   7. Using Wavumbuzi-1 worksheet, create a bar chart showing how various participants performed in the six-week challenge and Move it to a new worksheet: (7 marks)
      1. Insert the Chart Title as: WAVUMBUZI SIX WEEK CHALLENGE PERFORMANCE
      2. Insert X-axis as: PERFORMANCE SCORES
      3. Insert Y-axis as: PARTICIPANT NAME
      4. Display the legend at the bottom
      5. Rename the worksheet containing the chart to WavumbuziChart
   8. Print out each of the following: (3 marks)
      1. Wavumbuzi -1
      2. Wavumbuzi-2 (showing the formulas)
      3. WavumbuziChart

MARKING SCHEME