Convert results to percentages
Often columns have results that are marked out of totals that are not out of 100. Sometimes it is convenient to also have the results as a percentage.
For example, if a quiz is out of 20, the results could be multiplied by 5 to make them out of 100. If the the raw scores are out of number that is not a simple divisor of 100 then the multiplying factor is not so obvious.
TGP handles such operations with the Linear Scale calculation. As with all calculations, a column must be created to store the results that are converted to the percentage.
Suppose you have a column named Week 1 Quiz that has a column maximum of 15. To convert the results in that column to be out of 100 you can do steps like these.
- Choose the Column command in the New menu.
- Enter the column name in the cell for the new column name. The new column is the column that will store the converted results. For example, if the column to be converted is Week 1 Quiz you may want the new column to be named % Week 1 Quiz
- Press the Down arrow key to select the cell with the maximum for the new column.
- Enter the column maximum of 100. (The maximum will normally default to 100, but this step is included for completeness.)
- Choose the Calculation command in the Edit menu.
- Select Linear Scale in the Calculation list.
- Select the column that you want made into a percentage, i.e. Week 1 Quiz in this example, in the Columns list.
- Choose Include.
- Choose OK.
The results converted to a percentage are stored in a separate column. TGP is designed to encourage the keeping of raw scores so they can be used in future calculations with maximum accuracy.
- You can also do the same process with the Calculation Assistant. You can read the steps in the Convert results to percentages with the Calculation Assistant How to Guide for comparison.