" />

KCSE Exam Preparation

Just beyond simplicity

KCSE Computer Projects

Year 2013 KCSE Programming Project

Posted by Thaddeus Bah Masika on March 26, 2013 at 8:20 AM

 

Computer studies

project

2013

MASOMO BORA SCHOOL EXAMINATION AWARDS SYSTEM

Masomo Bora is a secondary school that offers the 8-4-4 curriculum of education. Each class in the school has two streams.

Every term, the school offers three examinations referred to as opener, mid-term and end-term. For each examination, the total score for each student is computed for all the subjects taken. At the end of the term, the students are ranked based on the average off their totals in the three examinations. The termly average is used to compute the annual average score for each student. All students in Form 1 and Form 2 take eleven subjects while those in form 3 and form 4 take eight subjects.

 

The school awards the best performing students at the end of every term. Then top three students in each class are awarded book vouchers whose values are as shown in the table below:

VOUCHER VALUE

CLASS                      POSITION 1                               Position 2                                        Position 3

FORM 1                    1,100                                            900                                                   600

Form 2                      1,300                                            1,000                                               700

Form 3                     1,600                                             1,200                                               800

Form 4                     2,000                                             1,500                                              1,000


 

The most improved student in each class is awarded a badge and a book voucher of a value equivalent to that awarded to the 2nd best student in their class. To determine the most improved student, the difference between opener and mid – term totals and that between mid-term and end – term totals are considered.

 

Students who leave the school before the end of the term are not considered for awards. Those who join the school after some examinations have been taken are considered for awards on the basis of the examinations take.

At the end of each term, each student is issued with a report form for the three examinations to take to their guardians. Students who score a termly average below 40% are required to attend remedial classes.

 

At the end of the year, students with the highest annual average score for the year in form 1, form 2 and form 3 have their fees for subsequent years waived. The stream with the highest mean annual score in the entire school and their class teacher are sponsored for a trip.

 

Develop a well documented computerised system to:

a) Capture the appropriate data

b) Perform the required computations

c) Generate:

i). Class lists

ii). Report forms

iii). A list of students who:

• Are awarded book vouchers

• Are awarded badges

• Are required to attend remedial classes

• Have their fees waived

• Will go for a trip and their accompanying class teacher.

iv). Merit list

 

 

 


Categories: General Questions

Post a Comment

Oops!

Oops, you forgot something.

Oops!

The words you entered did not match the given text. Please try again.

Already a member? Sign In

83 Comments

Reply Paul
6:14 AM on March 30, 2013 
I can't wait for this year's project. I always look forward to solving each years project and put my skills to use.
Reply Wamucii Kabue
2:14 PM on April 8, 2013 
Hi am a form four student in LCVR,,,,,and i was wondering if you could give me any tips on 2013's project am worried and we haven't even gotten the question please help...and rumor has it that it got released two days ago
Reply shalixx
10:40 AM on April 10, 2013 
hi!please how can i get papers for the 2013 project?please help.
Reply Thaddeus Bah Masika
8:24 PM on April 10, 2013 
Wamucii Kabue says...
Hi am a form four student in LCVR,,,,,and i was wondering if you could give me any tips on 2013's project am worried and we haven't even gotten the question please help...and rumor has it that it got released two days ago


Hello Kabue,
Don't worry yet, you still have enough time to handle 4 projects. We will all start together and ensure we all finish in time to also prepare for the rest of the papers.
Good Luck!
Reply Thaddeus Bah Masika
8:25 PM on April 10, 2013 
shalixx says...
hi!please how can i get papers for the 2013 project?please help.


Hello Shalixx,
No need to panic, am sure your teacher will get you the papers as soon as they are released.
Have a wonderful day!
Reply onesmus
11:08 AM on April 11, 2013 
i do not know how to do my project kcse 2013
Reply onesmus
11:10 AM on April 11, 2013 
kcse project 2013
Reply Thaddeus Bah Masika
11:39 AM on April 11, 2013 
onesmus says...
i do not know how to do my project kcse 2013


Don't worry, we will give guidance once we all have the paper! Meanwhile prepare yourself by reading more about relationships and queries!
Reply BONIFACE
3:13 PM on April 12, 2013 
KCSE 2013 TITLE: MASOMO BORA SCHOOL EXAMINATION AWARD SYSTEM
Reply Thaddeus Bah Masika
7:41 PM on April 12, 2013 
BONIFACE says...
KCSE 2013 TITLE: MASOMO BORA SCHOOL EXAMINATION AWARD SYSTEM

Hello Boniface,
Kindly send the scanned copy to my email thadeusbah@gmail.com so that I may have a look and present it well! Thanks for the heads up!
Reply Natalie
3:35 AM on April 14, 2013 
I have tried to analyze the project with my fellow Form four students, and we came up with quite a large number of tables, it really looked unrealistic.
Please help me on how I should approach this project.
Thank you in advance.
Reply Dunross
4:51 AM on April 14, 2013 
this project looks confusing
Reply Thaddeus Bah Masika
10:42 PM on April 15, 2013 
Natalie says...
I have tried to analyze the project with my fellow Form four students, and we came up with quite a large number of tables, it really looked unrealistic.
Please help me on how I should approach this project.
Thank you in advance.


Hello Natalie,
Tables are not as many as you think, in fact they may range from 4 to 7 tables. This exam is not confusing either, you just need to break down the questions into manageable sections and handle it bit by bit. For instance, you may need to start with basic tables e.g. student records table to link to class records table and exam records table. Most of the question will be handled in queries or reports depending on what software you are using.
Reply khadija
4:47 PM on April 17, 2013 
hey lads, am also a form 4 student, just reviewed your comments n thought that we'd make up a big team that wld be hlpfull if we are ready to help each othr,, yeah the tables are many but will dcrease when you relate them,,, they'll not exceed 7,,, if nyone thnks he o she wana join me n cooprtn leme know
Reply Natalie
2:56 AM on April 18, 2013 
so....ummm....what fields are in the class records table..? And how do you reduce the number of tables for the three different exams for 3 different terms....?
Reply Thaddeus Bah Masika
6:09 AM on April 24, 2013 
Natalie says...
so....ummm....what fields are in the class records table..? And how do you reduce the number of tables for the three different exams for 3 different terms....?


Fields will vary depending on how much info you want to capture, however, class_id & class_name will be basic. some may add class_teacher, class_prefect etc
Reply Franklin Ngumbi
6:26 AM on April 24, 2013 
how many r we supposed to come with?
Reply Thaddeus Bah Masika
6:56 AM on April 24, 2013 
Franklin Ngumbi says...
how many r we supposed to come with?


How many what?
Reply Franklin Ngumbi
3:23 PM on April 24, 2013 
Thaddeus Bah Masika says...
How many what?

Sorry,i meant number of tables
Reply Franklin Ngumbi
3:27 PM on April 24, 2013 
Access is commonly use to program in high school.can in other programmin language be incorperated?

Vote for your school and win 4hr seminar from our team in your school discussing tips n tricks of programming based on this years project. Add you school on the answers if it is missing! May the best team win

Facebook Like Button