pupil

Hi, Can you please help me to create a small macro to calculate % in the background and then do a summation on the sheet. Let me explain further. I have 10 pupils and they wrote 3 tests. I must now calculate the results and report on how they did per test. There are 4 results brackets and I...

Hi All, I'm working on this problem about test scores and I'm trying to figure out why I'm getting a different number when I get a mean of pupil grade score percentages versus when I do the other way by getting a mean for each individual test and then averaging that? I have noticed that if the...

Hi all, A Change of job has left me not using excel for a number of years so just after a pointer to get me in the right direction to help a school out. So I have a list of 90 pupils that are joining from another school. Each pupil has been allowed to name 3 friends they would like to be...

Hi All, I have an excel file for pupil timetables. In cell "C1" i have a dropdown menu which changes to each pupil name. Below this is the pupils timetable for the week. I have created a macro that automatically changes the dropdown to the next pupil and then prints the pupil timetable, then...

Hi, I am a teacher from the Netherlands and I would like to create a tool that lets Excel enter a grade (double digit number, i.e 6.7) in a cell next to a pupils name based on information in another cell in another worksheet. This is what I have: Multiple worksheets: Worksheet 1 = contains...