VTaL Tracking Sheets - Conditional Formatting

by Hinerau - 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

Tags : CoL, GAFE, Inquiry, VTaL, VTaL 03 Tracking Sheets

2 Comments

Kerry @ Manaiakalani 4 September 2018 at 20:33
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

Add comment

About Me

Kia ora! I am the Head of Technology at Tāmaki College and also teach Digital Technologies.

My target group of learners for my Inquiry 2021 will be my Year 12 NCEA Level 2 class. This group of learners were my target group from my 2020 Inquiry. I would like to inquire into whether Academic Writing exemplars specific to Digital Technologies, in conjunction with the 'Explanation Writing' classroom display resources for Digital Technologies, based on SOLO taxonomy, could accelerate achievement in literacy in my subject.

My target group of learners for my Inquiry 2020 were my Year 11 NCEA Level 1 class. I inquired into the process of using the LearnCoach online programs (content) and VTaL Visible Teaching and Learning (workflow) to accelerate student achievement for Tamaki College students undertaking courses in Digital Technologies NCEA Levels 1, 2 and 3.

In 2019, my inquiry is to maximise pedagogical practices (relating to integrated education, and collaborative teaching and learning), to effectively shift student achievement, supported by digital platforms connected to visible teaching and learning.

My Inquiry in 2018, was to develop a VTaL Purpose-Built Innovative Tool, to enable all elements of the VTaL Framework to be accessible to teachers, in order to accelerate student achievement.

In 2017, my inquiry was based on raising student achievement and shifting teacher practice around effective pedagogical practices including Learn, Create and Share. This will be achieved through the development, implementation and monitoring of the Visible Teaching and Learning Framework.

My Space and My Place