Thursday 10/23 – Automation & Assignment Filters

🎯 Learning Intention

I will create filters and automation to organize tickets by technician and urgency.

✅ Success Criteria

I can filter tickets assigned to me and build a simple formula or filter view that updates automatically.

💭 Why Are We Learning This?

Automation saves time and reduces human error—core habits in professional IT work.

☀️ Warm-Up Prompt

“What’s one repetitive task you wish your computer could do for you?”

🧠 Mini-Lesson

• Demo Filter Views and SORT + FILTER formulas.

• Introduce basic IF statement for auto-flagging overdue tickets:

  =IF(TODAY()-Date>3,"⚠ Overdue","On Track")

🛠 Independent Work

• Create filter views by Assigned To.
• Add an Overdue column using the IF formula.
• Highlight overdue rows automatically.

🌙 Exit Reflection

“How could automation improve other parts of our classroom or workplace systems?”

📅 Reminder: Friday—documentation and reflection.