Hello!
I'm a teacher and I'm using Excel as a grading tool. I enter daily scores for my students based on the work they complete. These scores are entered into columns. The heading of each column has the date and a code (a common core state standard for the work being completed).
On a separate tab within that workbook, I have a summary set of data. On this page, I already have an average for each of the standards over the course of the unit. I would also like to be able to see the most recent score for that standard. This is the column I am having trouble with.
To be more specific: For the purposes of this question, I would like to know what formula to use in column AC (for an example) so that I can find the most recent score (from the 5.NF tab) for each student that is a 5.NF.A.1 score (i.e. that matches the code at the top of the AC column)
The (redacted) file can be found here and downloaded to allow for manipulation:
https://www.dropbox.com/s/y1kmc7fkiw6pakj/EXCEL QUESTION FILE .xls?dl=0
(Note: online it looks really strange and has many missing formulas. Please use this link to download the file and open it with excel to see the columns and formulas I'm asking about )
Can anyone help a noob like me figure out how to input the most recent score for a given assignment type?
Thank you!!
I'm a teacher and I'm using Excel as a grading tool. I enter daily scores for my students based on the work they complete. These scores are entered into columns. The heading of each column has the date and a code (a common core state standard for the work being completed).
On a separate tab within that workbook, I have a summary set of data. On this page, I already have an average for each of the standards over the course of the unit. I would also like to be able to see the most recent score for that standard. This is the column I am having trouble with.
To be more specific: For the purposes of this question, I would like to know what formula to use in column AC (for an example) so that I can find the most recent score (from the 5.NF tab) for each student that is a 5.NF.A.1 score (i.e. that matches the code at the top of the AC column)
The (redacted) file can be found here and downloaded to allow for manipulation:
https://www.dropbox.com/s/y1kmc7fkiw6pakj/EXCEL QUESTION FILE .xls?dl=0
(Note: online it looks really strange and has many missing formulas. Please use this link to download the file and open it with excel to see the columns and formulas I'm asking about )
Can anyone help a noob like me figure out how to input the most recent score for a given assignment type?
Thank you!!