We I have school management software done on access that I would like to improve on so as to boost the sales. I would like to have a macro that can get student marks on various subjects, including columns for C.A..T. (assignments and tests) ,the final exam Total Marks and Teachers comments. The marks should be entered per class. After marks entry the total marks should be put against a grade e.g. >80% A ; between 70-79% B; 60-69% C. Grading should be adjustable depending on the exam. Once all marks have been entered, now the ranking should be done with the student with highest total marks ranked as 'number one' and vice versa.
This information should then be posted to report cards for each student (This is the selling point). The report card should be automatically generated once the marks are fed. We should have the letterhead of the card being customizable for different schools. Will send you samples of the report cards. Mostly this tallying is done manually here and if it can be automated then the Macro can sell.
Other analysis we want is best improved student and the index of improvement(per class), best improved subject and the index of improvement, average (mean) score of the student (to be in the report card) and lastly but least graphs and charts to show the analysis.