Procrastimarking

Ah: procrastimarking. This is Clayton's marking: i.e., the marking we are doing when we are not doing any marking. Now that previous s...

read more "Procrastimarking"

Round and MRound

I discovered recently that, not only is there an MRound (read more here ), there is also a ROUND function in Excel so that the cells display...

read more "Round and MRound"

Using Mround in Excel

When I am marking student's work, I use an Excel spreadsheet to record my impressions. I have written more fully why this is elsewhere (...

read more "Using Mround in Excel"

Excel tab name length

When I am marking, I use Excel to provide student feedback. This is because Excel adds up. I used to use Word using formulas, but as Word do...

read more "Excel tab name length"

The thorny problem of Word marking sheets

In a previous shared office a colleague always looked for the EASIEST way to do things. He had a very disruptive and creative approach to ...

read more "The thorny problem of Word marking sheets"

Using VLookup in Excel

Do you have related data which you have to regularly - and manually - add to a marking sheet? I use Excel to mark, and need both the student...

read more "Using VLookup in Excel"

Marking rubrics and feedforward

It is that time of the year to appreciate the joys of assignment marking. I have explored this topic before ( here ), but we can always take...

read more "Marking rubrics and feedforward"

Using bullet points in Excel

I have briefly inherited an on-campus course from another staff member, stepping into the breach during Covid-19 to each this course online....

read more "Using bullet points in Excel"

Excel if statements with an in between range

When marking, I try to automate as much as possible by using marking rubrics in Excel supported by formulas. All markers need do is enter ...

read more "Excel if statements with an in between range"

Tertiary education administration systems

I was talking to an educator who is part of a professional development group at their institution considering stress in the workplace, and...

read more "Tertiary education administration systems"

Bias: up the lead judging

I was recently reading a post on LinkedIn which talked about the marker bias that we can introduce without realising it. This is why secon...

read more "Bias: up the lead judging"

Excel tab name repeated in sheet cell

To streamline my student's research report - or article - marking at the end of their projects, I use a rubric set up in a spreadsheet...

read more "Excel tab name repeated in sheet cell"

Rounding sums to two decimal places in Excel

I had an interesting problem. I created an Excel spreadsheet assignment marking rubric with many items and categories, which self-added an...

read more "Rounding sums to two decimal places in Excel"

Love teaching: loathe marking

I was wondering recently why lecturers largely appear to the teaching, but loathe the marking. After some consideration, I came down to...

read more "Love teaching: loathe marking"