How to Compare Percent v. Grade
MPD

MCS PAR Dept

Created Oct 31, 2024

How to Compare Percent v. Grade

113
    d

Google Docs

10 Steps
1

Open the Grade Verification Grade & % No Match and Highlight the Percent Column

Open the Grade Verification Grade & % No Match and Highlight the Percent Column
2

Click on Decrease decimal places

Click on Decrease decimal places
3

Right click on Percent Column Heading & select Copy

Right click on Percent Column Heading & select Copy
4

Right click on Percent Column Heading & select Paste Special > Values

Right click on Percent Column Heading & select Paste Special > Values
5

In the first empty column type in the formula =E2-F2 (Percent - Grade)

In the first empty column type in the formula =E2-F2 (Percent - Grade)
6

Copy down the whole column

Copy down the whole column
7

Turn on the filter

Turn on the filter
8

Click on extract (56)…

Click on extract (56)…
9

Uncheck 0 & -1

Uncheck 0 & -1
10

The only ones remaining have a mismatch between grade and percent

The only ones remaining have a mismatch between grade and percent
Well done!
Create how-to guides like this in a snap. Get Tango now.