would like to build a test reporting system. i have all of the tests, answer choices and correct answers. i have also built it already in excel using pivot tables but now i need something more professional. so an admin will enter student's test answers into a form, will check for correct answers and the report will calculate score and generate customizable reports with graphs showing results per question type, section, etc. currently i have 10 tests that i would like to be able to show trending for the results for each student. needs to hold 100s of student test records and up to 5 simultaneous users. i use zoho crm so ideally would also be able to connect/import some student records but not a requirement. i have uploaded an example of the excel file that i am currently using to build this report. all the test formats are similar, just the questions/answers are different. need to show results trend by date across the tests.
Writer is a powerful online word processor, designed for collaborative work.