For years I’ve wanted to grade quizzes anonymously, but I could never figure out how to do so. Finally I have, within the Uleth setup.
I just posted the slides for my lecture to the Department yesterday: Class 2.0: Digital technology & digital rhetorics in the undergraduate classroom.
Abstract: This lecture discusses some preliminary results from an ongoing research project on the use of digital technology and digital rhetorics in the undergraduate classroom. The goal of the project is to explore how these technologies and rhetorics can address common problems in the literature classroom: weak composition skills, lack of engagement, poor preparation. Initial, at this point still largely anecdotal, results suggest that the committed integration Web 2.0 technologies and rhetorics in the classroom can greatly improve outcomes in this area.
The lecture discusses how these techniques are used and some of the results we have seen.Read the rest of this entry »
Below are links to spreadsheets containing my standard formulas for converting from letters grades to percentages and vice versa.
I use the first formula (letter grades to percentages) when I am marking work qualitatively (e.g. essays, translations, and other things that are not easily scored numerically), but need a number to use in calculating the final grade; I use the second formula (percent to letter grade) when I am calculating the final grade for submission to the University (the University recrds only letter grades). With some tweaking, you could use this second formula to convert to grade points or to other systems (e.g. First/Second class, and so on).
There are two versions of each formula: a dynamic and a static version. The static version is simply the formula I use in my spreadsheets and it is based on the letter:percentage equivalences defined elsewhere on my website. The dynamic version is built within the spreadsheet using numbers supplied by the user. This has the advantage of being adaptable, but it has the disadvantage of requiring you to copy more cells into your own spread sheet if you want to use it (because it depends on internal references, you need to copy both the formula and the table of equivalences in the stylesheet). In both cases, there are instructions (hopefully clear) on how to use the formulas in your own grade spreadsheets.
Here is the text of the static formula (it assumes its data is coming from cell A32 in the first case and A35 in the second. The easiest way of adapting it to your own uses is to paste the formulas into cells B32 or B35. After you have done that they should autoatically change depending on where you place them in the spreadsheet):
Open/Libre office version: http://ubuntuone.com/1iBn3HjozhiNpzEV4W7siQ
Excel Version (converted by Open Office): http://ubuntuone.com/0qcsHBnCKcHD5wrkT5bSTw