Chamarla,
To let you judge for yourself whether I can do this, I will send you a sample spreadsheet that calculates the AVERAGE grade in each subject for each attendance level (e.g. Students with an attendance score of 2 out of 10 averaged 63% for Maths, whilst those with an attendance score of 4 scored 47%).but the site will not allow me to send it unless you send me a Private Message first,
I designed dashboards, reports and interactive spreadsheets and managed databases for twenty years at a leading multinational.
Now work from home in the UK across five freelance sites with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting.
I can work under a Confidentiality and Non-Disclosure Agreement if required, and start as soon as you pay the fee into the site.
Hope you find this of interest and look forward to hearing from you.
Bob Allen-Turl