Creating A Result Management System Used To Analyze Students Data,scores And Aggregates Using Microsoft Excel.

Creating A Result Management System Used To Analyze Students Data,scores And Aggregates Using Microsoft Excel.

There are different ways to create a result management system in excel(using VB through the developer menu,the basic way of inputing data(labels,values and formulas) manually,you could even go ahead to use V lookup or H lookup after creating an existing data set e.t.c). I could go on and on but for the purpose of this post,we'll be talking about how we achieved the above manually by creating a database for students,creating a result grading system and finally generating their report sheets. Firstly,we thought about what educational level(i.e primary,secondary or tertiary) result management system we wanted to create and settled with primary school. After that we created a student database(containing their names,gender,age,class and current academic session) for 30 pupils using the "Data validation menu." After that we created columns for their Reg number,Total marks obtainable,each of the subjects offered,Obtained marks,Average,Grade,Class position and Remark respectively. Thereafter, we simply inputed their respective reg numbers,inputed the fixed number of obtainable marks and inputed their respective scores for each subject. For their respective total obtained marks,we used the "Sum function" to get the total score they obtained. We used the "Average function" to get the average of the total obtained score. We then used the "Nested IF function" to get their grades and used the "Rank function" to get their respective class positions although this involved using "both relative and absolute cell referencing". Finally we used the "IF Statement function" to get their respective remarks.Now if any data "we inputed without a formular" is erased from this system we created and another inputed to replace it,the result will change accordingly. We also generated a report card for the students and we did this by designing the template we wanted first then we created a marksheet on another page from the existing data we already had,went back tobthe templateband used the "V lookup function" to find all of their data from the marksheet and it's with this that we've come to the end of this post. Thank you🙏 for your time and thank you @NgSideHustle.