TEACHER IN NEED!!!!

Hello! Let me start by saying I only know BASICS about excel. I mean, I am proud of myself for finding the average of a few cells! That being said, I have created a gradebook for my grade level to help us track the data of our students. This spreadsheet breaks down our tests by Common Core standard. There are 9 standards on each test. Basically each student has 9 grades that are calculated by percentage.

Our goal would be for each class to have a separate sheet in the book that would break down the data for us. We would like to know exactly which students mastered (76% and above), partially mastered (70-75%), and did not master (74% and below) each standard. We would love to be able to input the data into the first sheet, which contains all of the classes, and this data transfer into individual sheets where the teacher can easily see how the students performed on each standard.

First, is this possible? Could our life really be made that simple? Or this is just unrealistic. I know excel can work wonders, but I don't know if this is too much! I have no idea how to attach a file or I would so you could look at our spreadsheet.

Again, I don't know the first thing about it so I would actually need someone who is willing to help out a bunch of tired, overworked and underpaid teachers out of the kindness of their heart!! I am positive I would not understand your directions!