Student Behaviour Tracker

This is a very cheeky request for help. Now approaching 70 I've forgotten most of what I knew about Excel.

I'm a Chair of Governors at an 11-16 school. I receive notifications about pupils who have been suspended (also known as fixed term exclusion). Roughly I have about 200 individual suspensions over 1 year. I want to record and analyse these. The information to record is

Name: Last and First (about 30-40 students)

Reason for exclusion (usually 1 or possibly 2 out of about 8 categories) 

Length of exclusion 1 - 15 days

Flags e.g. SEND; PP, 

Year group: 7, 8 , 9 10, 11

Date 

As many of the students are repeat offenders I'd like to set the spreadsheet up so by either by typing the name or through an editable drop down list the name appears once and then the reason for the suspension and date is entered (as opposed to multiple entries appearing on the same page).

I'd then like the spreadsheet to report, using an editable date range:

By pupil name; the number of suspensions; total number of days and total number of days for each category of exclusion

By suspension category: number of suspensions; total number of days for each category

By flag: number of suspensions; total number of days for each category

Year group: 7, 8 , 9 10, 11: number of suspensions; total number of days for each category

I've looked at some cheap packages e.g. at  Etsy but I cant see anything that does this. There are commercial packages, intended for whole school, but cost several hundred - thousand plus, pounds. 

Thanks in advance if you are interested and my apologies to you if you feel this is an inappropriate request.

Regards

Nick