During weeks seven and eight we learned more insight on common assessment terms such as population, sample, and norming. These terms appear when referring to norm-referenced tests and criterion-referenced tests, the difference between the two being norm- referenced are compared to results of similar groups of people while criterion-referenced are compared to the body of tested knowledge. Continuing with terms commonly used in assessing is the importance of validity which is the whether the assessment measures what it is supposed to measure. Validity goes hand in hand with reliability meaning whether the results can be reproduced under the same conditions meaning can you trust the results. We learned a lot about how to compare scores on excel using terms such as mean, medium, mode, Z-score, and T-score. All of these terms are important to know so that when we receive assessment reports as teachers, we are able to understand the materials and able to explain the information to others.
We practiced putting scores into excel to analyze how students were progressing, by making bar/pie charts we can get a simpler breakdown of what students are struggling in what areas or those who seem to be performing above average. Also, it can be used as a reflection on our own instruction, if the whole class struggled in one area maybe consider reteaching the subject before continuing. Excel is a great tool for breaking down assessments and scores to gather intel for future lesson planning’s.


