Analyze Data

Which platform are you using?

Sort the data in descending order based on the "Score" column. Then, sort the data in ascending order based on the "Test Score" column.

Step 1: Sort and Organize

Apply a filter to the "Grade" column, allowing only the values "9" and "10"

Step 2: Filter Your Data

Step 3: Conditional Formatting

Apply conditional formatting to highlight test scores below 60. Use a different formatting style to highlight test scores above 80.

Step 4: Analysis and Conclusion

Calculate the average test score for each grade level. Write a summary highlighting any trends or observations you can infer from the sorted and filtered data.

Step 1: Sort and Organize

Sort the data in descending order based on the "Score" column. Then, sort the data in ascending order based on the "Test Score" column.

Step 2: Filter Your Data

Apply a filter to the "Grade" column, allowing only the values "9" and "10"

Step 3: Conditional Formatting

Apply conditional formatting to highlight test scores below 60. Use a different formatting style to highlight test scores above 80.

Step 4: Analysis and Conclusion

Calculate the average test score for each grade level. Write a summary highlighting any trends or observations you can infer from the sorted and filtered data.