VTaL Tracking Sheets - Conditional Formatting

by - 15:57

After delivering my workshop at Sydney GAFE recently, and attending the workshop of a fellow colleague Gerhard Vermeulen, directly after my own, I was lucky enough to gain feedback and insight within both workshops into the use of conditional formatting to apply the traffic light colour codes more easily within the VTaL tracking sheets.

This has meant a quicker and more efficient turnover within the marking system, as grades are entered either via the Workspace 'assessed' function, or grades entered directly into VTaL tracking sheets themselves.

The following are a series of screenshots, to demonstrate the formula that is added into the sheets, and the marking process that enables the colour codes to be updated within the sheets for various tasks.

1 - Open the Google Sheet




2 - Click on Format > Conditional Formatting > Add the 'Rules'




3 - Enter Grades into Workspace, or into the Google Sheet




4 - Click on Assessed with the Workspace




5 - Grades turn 'Green' for Assessed work




6 - View 'Started' to see which students have started the task




7 - Enter 'Started' into the Google Sheet

You May Also Like

2 Comments

  1. Hi Hinerau

    You have done a lot of work here on creating your tracking sheets and I love the conditional formatting which populates a colour into the cell as well. Do you have a video 'how to' or larger screenshots you could share?

    ReplyDelete
    Replies
    1. Hi Kerry, I don't have a video how to at this stage. However, I dropped the screenshots into a doc before I deleted them. Let me know if the doc is useful :) https://goo.gl/U6ZBG9

      Delete