- MOKASA joint exam organizers have contacted you to help them analyze their results during April holidays. Create a new workbook and name it as MO_KA_SA EXAM
- Enter the following data in sheet 1 (10 Marks)
- Rename the sheet 1 as SA_CHO (1 Mark)
- Copy the contents of sheet 1 to sheet 2 and rename it as KA_BA_RA_K (1 Mark)
- Use formulars that references the cells to calculate
- Totals (2 Marks)
- Average (3d.p) (3 Marks)
- Insert a title JOINT EXAM and format it as indicated below:
- Font type viner hand ict
- Font size 16.
- Left align the title.
- The other subtitles should be rotated 66o, bolded and italised. (5 Marks)
- Use the IF function to award remarks to the students as follows: (3 Marks)
Mean Remarks >65 Gold 55 – 64 Silver <54 Bronze - Insert a column showing positions and award positions to students basing the scores on means (3 Marks)
- On the last rows enter formulas to count the total number of students from each class.(2 Marks)
- Sort the students list by class position in descending order. (2 Marks)
- Copy the entire worksheet onto worksheet 2 and rename it ‘MOI_GIRLS’.(2 Marks)
- Filter MOI_GIRLS worksheet to show student (s) from ‘RED’ class and whose mean score is less than 50 (4 Marks)
- Insert a bar graph to display the three RATS and Names (1 Mark)
- Title as JOINT EXAM and label the X-axis as marks and Y-axis as Names (3 Marks)
- Place the legend at the bottom of the graph. (1 Mark)
- Save the chart on a new sheet and name it GRAPHICAL_ANALYSIS. (1 Mark)
- Re-arrange your worksheets tabs so that GRAPHICAL_ANALYSIS comes first then SA_CHO, MOI_GIRLS and finally KA_BA_RA_K. (2 Marks)
- Create a worksheet based on MOI_GIRLS and use show all the formulas used in your calculations and name it FORMULARS (2 Marks)
- Print: GRAPHICAL_ANALYSIS, SA_CHO, MOI_GIRLS and KA_BA_RA_K. (4 Marks)
- MOKASA joint exam organizers have contacted you to help them analyze their results during April holidays. Create a new workbook and name it as MO_KA_SA EXAM
- The figure below is a sample design of an advertisement for Maisha Bora Company. Use a desktop publishing package to design the advertisement as follows. (50 Marks)
- Create a new publication named advert with the following page layout
- Paper size: A4,
- Orientation: landscape
- Margins: 5 cm all round
- Set the footer of your publication to display your name on the left edge of the page and index number on the right edge of the page
- Enter text and images as they appear in the sample design.
- Save your publication as Maisha Bora
- Print your publication
- Create a new publication named advert with the following page layout
Join our whatsapp group for latest updates
Tap Here to Download for 50/-
Get on WhatsApp for 50/-
Download MOKASA Joint Evaluation Examination Computer Studies 2 2016- Pre MOCK.
Tap Here to Download for 50/-
Get on WhatsApp for 50/-
Why download?
- ✔ To read offline at any time.
- ✔ To Print at your convenience
- ✔ Share Easily with Friends / Students