Get premium membership and access revision papers, questions with answers as well as video lessons.

Got a question or eager to learn? Discover limitless learning on WhatsApp now - Start Now!

Coe 121: Inroduction To Computer Applications Question Paper

Coe 121: Inroduction To Computer Applications

Course:Bachelor Of Business Administration

Institution: Moi University question papers

Exam Year:2011

MS EXCEL
STUDENT RECORDING FORM

ADM SUSUBJECT ACHIEVEMENT MATH’S
RESULT MATH’S
GRADE
NAME MATHS ENGLISH KISWAHILI CHEMISTRY BIOLOGY POINTS
1 KILIMO 55 77 98 78 49
2 KIOKO 81 96 44 66 92
3 KOKO 70 97 69 45 84
4 MUTISO 64 69 88 65 76
5 MUTURI 89 88 71 78 91
6 NGWARE 44 78 92 54 89
7 KASII 93 97 44 59 72
Repetitive mark
Total subject mark
Average
Calculate total marks in every subject and total marks for each student.
Total No. of students.

Calculate (math’s + English total marks) divide by (Biology + Chemistry total marks)
Find the repetitive marks in all the subjects (MODE).
Find average subject marks.
In math’s performance find the middle mark
What’s middle mark squared?
Insert the following columns total student mark, maths grade,

Calculate math’s grade given that if student achieve
Below 50 E
51 - 65 D
66 - 75 C
76 - 85 B
Above - 85 A

Then math’s Result given that if student get
Below - 50 Fail
51 - 65 Refer
66 - 75 Pass
76 - 85 Credit
Above - 85 Distinction

Then find student’s points given that if total student mark per student is as follows:
Below - 350 40 points
351 - 360 50
361 - 370 60
371 - 380 70
381 - 400 80
Above - 400 90

Create three worksheet and name them as follows pie chart, line chart and column chart.
Create a pie chart to display students and their performance in Kiswahili (make marks to be inside the sector)
A column chart to display performance in Maths, English and Kiswahili.
Line chart to display all the subject performance (include chart title for all category representation).
Format all the charts in their respective worksheet.
(Any necessary Columns & rows can be added in addition to arrangements).

Coe 121: Inroduction To Computer Applications Question Paper

More Question Papers

Popular Exams