topic Re: grading schemes: issue with no rounding in Canvas Question Forum
https://community.canvaslms.com/t5/Canvas-Question-Forum/grading-schemes-issue-with-no-rounding/m-p/57752#M3854
<HTML><HEAD></HEAD><BODY><P> <LI-USER uid="239813"></LI-USER> ,</P><P></P><P>When I used a points based system, the points needed were found by starting off with a percentage (89.5, 79.5, 69.5, ...) and converting it into points, so you may find that many faculty already know what percentages they want to use.</P><P></P><P>Here's what it could look like going the other way. Assume that you have 700 points possible, and you've decided that you need 650 for an A, 600 for a B, 550 for a C, and 500 for a D. You don't need any points for an F.</P><P></P><P><SPAN class="lia-inline-image-display-wrapper" image-alt="225347_pastedImage_1.png"><IMG src="https://community.canvaslms.com/t5/image/serverpage/image-id/25103iC436590EEA6E8DF5/image-size/large?v=1.0&px=999" role="button" title="225347_pastedImage_1.png" alt="225347_pastedImage_1.png" /></SPAN></P><P></P><P>The % Needed column was found by dividing the points needed by the total points 700.</P><P></P><P>What you need to put into Canvas is the lowest percent possible, and since Canvas takes 2 decimal places, I round those <STRONG>down</STRONG> to 2 decimal places.</P><P></P><P>The Points column at the end is if you re-multiply to see how many points a person could get. So a person with 649.95 points could get an A, but it's unlikely that a point-based system will be giving someone that 0.95 points, so 649 doesn't reach the threshold and would be a B.</P><P></P><P>Now, the important piece in there is <STRONG>ROUND DOWN</STRONG> to 2 decimal places.</P><P></P><P>If you look at the D, it needs 71.42857% and if you round that using normal rules, you would get 71.43%. But 71.43% of 700 is 500.01, so getting a 500 points would be an F.</P><P></P><P>Excel has =ROUNDUP() and =ROUNDDOWN() functions to help. They either round up or round down to the number of decimal places given in the formula.</P><P></P><P>Here's what my formulas looked like.</P><P></P><P><SPAN class="lia-inline-image-display-wrapper" image-alt="225348_pastedImage_3.png"><IMG src="https://community.canvaslms.com/t5/image/serverpage/image-id/25104i69221FB968AF52CA/image-size/large?v=1.0&px=999" role="button" title="225348_pastedImage_3.png" alt="225348_pastedImage_3.png" /></SPAN></P><P></P><P>The numbers in the % Needed column were actually given as proportions (0.9285714 instead of 92.865714) and displayed as percentages. That means to round to 2 decimals places as a percent, I need 4 decimals as a proportion, and that's why I used the 4 with the number of decimals on the round down command</P><P></P><P>If you manually adjusted for percents, so you had the number 92.865714, you could rounddown to 2 decimal places.</P></BODY></HTML>Sat, 30 Jan 2021 00:32:37 GMTJames2021-01-30T00:32:37Z