The document outlines tasks for preparing notes on life skills and managing student marks using a spreadsheet program at Maji Mazuri Technical. It includes specific instructions for formatting a document on life skills, inserting images, and creating a spreadsheet for student results with calculations for total and average marks. Additionally, it requires the creation of a bar chart to visualize the student results and saving the work for later printing.
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
0 ratings0% found this document useful (0 votes)
2 views2 pages
Assignment 2
The document outlines tasks for preparing notes on life skills and managing student marks using a spreadsheet program at Maji Mazuri Technical. It includes specific instructions for formatting a document on life skills, inserting images, and creating a spreadsheet for student results with calculations for total and average marks. Additionally, it requires the creation of a bar chart to visualize the student results and saving the work for later printing.
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
[Link]
TASK I
Maji Mazuti Technical
asked to prepare the notes,
invited a motivational speaker to give a talk an life skills, You have been
(a) Open a wort processing program and key in the following information as iLappears, Save itas
lifeskills in the KNECEXAM folder. (8 marks)
Rafe Sanes
This refers to the skills needed to make the most out of life. Life skills are usually associated with
wnaging and living a better quality lite. They help us to accomplish our full potential
Any skill that is useful in your life ean be around us and equip ourselves with the relevant
considered a life skill, By learning new skills tools to cope with the challenges that fife
‘we increase our understanding of the world throws at us
Essential Life Skills
Certain skills may be more ar less relevant to you depending an life circumstances, your culture,
beliefs, age, geographic location, etc, Different life skills will be more or less relevant at different
times our lives, for example:
4 Study skills: needed when at school or college,
(i) Negotiation skills: needed when buying something, like cloths and other basic necessities.
‘4is) Employability skills: needed when searching for a job,
tiv) Time management and organizing skills: are important in everyday life of an individual
(b) Apply the following formats in the document created in (a):
(i) Sub title “essential life skills"; Verdana and size 18, (1 mark)
(ii) Line spacing 1.5 (1 mark)
(c) Insert an Jn ymargin drop cap to the first letter of the first paragraph. (1 mark)
(d)" Insert a picture of your choice in the third paragraph, (1% marks)
(Apply the text wrapping style of sight to the picture: (1 mark)
(ii) Resize the picture to only stretch within the paragraph. (1b mark)
(d) Save changes to print out Jater. (1 mark)
1920/1028 3 ‘Turn over
November 2018 TASK 2 [Link]
A lecturer of computer class at Maji Mazuri Technical uses spreadsheet program to maintain
students* marks,
(8) Open a spreadsheet program and key in the following data as it appears in Figure 1, Save the
work book as clacsresults in the KNECEXAM folder. (S-marks)
COMPUTER CLASS END OF TERM 1 RESULTS
No. | Student | ICT Maths | Programming | Total [ Average
name marks | mark
T_ [Ann 70 a
2 |Peter_| 76 | 36 28 [
3_| Paul 36 EH B I
4 [Allan ot 56
3_| Brian 3 | 36
6 [Amos 6 46.
7 [Jane 36 83 = i
& Pauline AT 74
9 [Selina [se | 40 7
10 | Alice x 45
Figure |
(b) Using an appropriate function, determine:
(total mark for each student;
(ii) average mark for each student. {2 marks)
(c) Porat the data in cells G2 to G11 to zero decimal places. (1 mark)
(2) Using an appropriate function, determine the remark ofeach student given that. student gets a
“Pass” when the total marks is greater or equal to 150 otherwise a “Fail” G marks)
(ch Create an embedded bar chart showing the total marks for each student. Format the chart as
follows;
(i) Chart title: Computer Class Results
(ii) X-axis label: Student names. (3 marks)
(f) Save the changes to print out later, Sheot] with the bar chart, (1 mark)
1920/1028 4
Naventher 2018