Designing a system that will be used in sixth form or colleges that will keep records of each student’s attendance, test grades and homework grades in each subject they have

Authors Avatar

Introduction  

As part of my AS ICT project I am designing a system that will be used in sixth form or colleges that will keep records of each student’s attendance, test grades and homework grades in each subject they have.

I choice to do this because nowadays students tend to skip lessons when their parent do not have an idea of what their child is up to. By skipping lessons, students miss out on important work which will help in their near future when they sit their exams. Students also are behaving worse now and getting out of control in classes. These students then result in low grades in homework and exams.

By doing this system it will help those students to work harder in their lessons and achieve higher grades.

This system will be used for students in sixth forms and colleges because I feel they are keen to study but are getting out of control. They have chosen to do higher education and they should do well, I feel most people think they have the ability to pass these exams but have no idea how hard the exams are getting.  I feel pupils in primary and secondary schools are still fairly young and can be disciplined. After doing these exams it will still take them further in life.  

The teachers will be using this system at all times to keep up to date for all students. So for every test or homework grade the teacher will input it in the data. This will then show their predicted grades and progress in lessons. The teachers will also take in the daily register to show the attendances.

This system will be able to calculate the average attendance for each student. It will also show the progress of each student when the grades and students effort will be put it. From this you will then able to compare the performance between individuals and the whole school. This will result in knowing the predicted grades. A letter will be sent home to the students who are not keeping up to date with homework and not achieving the grades.    

To do this system, using Excel will useful because there are many functions that can be used. E.g.

-IF function. To send letters home I will be able to use the IF function to send letters to only students under 60% attendances. Also when calculating the predicted grades.

-Macros. I will use macros when clicking on a tab it will find the sheet needed. And also when adding data to the database. The data should be added to the end of the list.

-Vlookup formulas- this will also be useful when editing the percentages for homework or attendance and using it to search for the student.



An analysis of the current system

This system will be used to keep a record of student’s attendance colleges and sixth forms. It will also show the homework marks and test marks and progress the student is achieving from the database. The teachers will input the data and it will be compared the rest of the students in the database. This will let the teachers know automatically if students are not attending school and who are failing to bring homework in. therefore they can help them by making sure their parents know.

To make sure this system will satisfy the users needs I will have to do primary research to find this out. To do this I will interview teachers and students to find out what they think of it. This will give me detailed answers and more specific. But it will be biased. So I will also hand out questionnaires to a get a wide range of information.

Doing this research it will also help me find any problems that will occur and what problems that have occurred in the past.

Interviews

As part of my ICT as level coursework I am designing a system that will keep a record of student’s attendance colleges and sixth forms. The system will have many stages for it to process. This is the process

  • Input student’s name and form.  
  • Input any test scores, homework grades. Any previous exam grades.
  • Select the performance in lessons.
  • This will give the timetables of each student.
  • This will show the progress of student.
  • Total average grade of students in each subject.
  • Compare individual’s results to the class.
  • Predict the grades.

From doing this hopefully it will push students to work harder for exams and attend their lesson more often, if not doing so. If the parent or guardian does not push their child to work harder and if the student is not progressing the satisfied needs then the teacher will have a choice of keeping the student in the college or not.

I would like to find out teachers and students views if they think this system is sufficient.

Join now!

Mr. Trig. A from tutor in Wreake Valley Community College.

 

1). Do you think this system will encourage students to work harder and put more effort in their work, knowing that any low grade or low attendances will get noticed?

‘I think system is a good idea. It will give the students a little discipline and therefore will make the students work more hard and achieve better grades. There also can be disadvantages. This system may have no effect on some students at all.’

2). Would you use this system in your college?

...

This is a preview of the whole essay