OBJECTIVES: 1. Gain a deeper understanding of how criteria are applied in educational assessment.2. Learn how to identify students whose scores meet a specified standard level.3. Understand the process of calculating the percentage of students meeting a given criterion.4.Practice using Excel's conditional formatting features to highlight or identify specific data points.5. Apply Excel formulas to automate the identification process and calculate percentages.