Stephen Dann



Teaching Materials for your customization and use

I've been involved in the teaching marketing for a decade, and prior to that, I had five years undergraduate match practice as a student. So for over 15 years, I've been dealing with higher education as a provider or receiver.  In that time, I'm looked for a range of ways of improving the experience for my tutorial staff, the students, and making my own life a lot easier.  This page has a selection of the forms I've been using to simplify the marking process, provide quality assurance in terms of marks consistency, consistency of feedback, and to allow the students the opportunity to request grading feedback if they require it.
  • Cover Sheets
  • Exam Marks Criteria with Mail Merge
  • From Marking Criteria to Marks Feedback Template

Comment Request  Cover sheets

Back before electronic uploads, in the days of paper called 2001, I developed a process of providing students with compulsory coversheets for their assignments where they had to fill out the cover sheet to request comments on their assignments. 

The default option was "no comments", so students who didn't request comments didn't receive comments.  I found very quickly that this process was well received by the students in the large compulsory classes, since those people who would never look at the comments didn't take up the time and energy of the marking staff so the students seeking feedback gained higher quality responses.

In 2006, I introduced an upgrade the comments request cover sheet as a result of a suggestion from Andrew Henri (student, BUSN3026) who put in a conditional comments request if his grade was below a certain level.  The current operational sheet is the result of six years of R&D, with student feedback and contributions.  Whilst these are obviously branded for my own subjects, there's no real difficulty in adapting them to your own course work requirements.

Note on the Conditional Request Sheet: This assignment request is for a 40% assignment, hence the High Distinction was for 32 (80%) to 36 (90%).  You'll need to substitute your own mark and marking distributions as appropriate

 Basic Request Sheet

  Conditional Request Sheet

Exam Marks Criteria with Mail Merge
Oh how I love the advent of technology.  I've been using printed marking criteria for a while, but this season I decided to mix the two together so that I had each student's marks on file, computer calculated since I've made more than enough calculation errors at 2am during a marking blitz, and now, with the miracle of mail merge, I've got personalised score sheets for the exam.

As I mark the exams, the points per section of the marks criteria are entered onto the Excel spreadsheet (even if this season's sheet was a little bit prone to automatically 'error correcting' one of my formula). When the marking is finished, running the mail merge put the respective mark against the criteria, plus the score for each question and the overall total for the exam on a personalised sheet with the student's name and student number. 

One of the bonuses to this approach is that it cuts back on the number of students questions on the exam feedback when they can see what was expected, what it was worth, and what they scored against the total for each section.

  Exam critera set for the mail merge

  Sample Mail Merge Outcome


Marking Criteria to Marks Feedback Template Sheets

More fun with Microsoft Word functionality - this time, forms, document templates and personalised marks sheets.

This relies on Microsoft Word playing nicely, so your mileage will vary from use to use.   Once you've created a marking criteria for an assessment item, it's time to convert it into a template form for giving feedback to the students.  This is a three step process.

Step 1: Write the criteria.  Or modify one of my marks criteria sheets, but that's really not as valuable as writing your own criteria.  In my case, I give my students the marks criteria before the assignment is due, so they know what they're playing for in the way of grades and expectations.

Step 2: Turn the criteria into a form (Look up Word help on that if you're not used to making forms)

Step 3: Select "Protect Document" from the Tools Menu, then save the protected document as a Word Document Template.  Word will automatically bounce you to the Word Template folder, so if you want to have easier access to the document, save it somewhere less hidden in the depths of the drive.

Step 4: Use the template by double clicking on it, and each time it'll load as a fresh preformatted word document. 

If you want to see a few of these in action, feel free to download and customise the sample marking sheets (To unlock for customisation, just go to the Tools Menu and select "Unprotect Document". Don't forget to protect the document for forms once you've made your changes)

 Student Tutorial Submission Marking Criteria 1 (PDF)

   Tutorial Submission Marking Sheet 1

 Student Tutorial Submission Marking Criteria 2 (PDF)

  Tutorial Submission Marking Sheet 2

 Student Tutorial Submission Marking Criteria 3

  Tutorial Submission Marking Sheet 3

 Student Assignment Marking Criteria 1

  Assignment Criteria 1

 Student Assignment Marking Criteria 2

  Assignment Criteria 2


A homepage
ANZMAC Sponsorships
Marketing Textbooks
Chased by Security
Spam Poetry
Marketing Education
Publications List
Research Projects
Self Aggrandizing