Event Attendance Scanner
(xlookup)

This episode teaches you how to build an attendance scanner for quickly and easily taking attendance at large school events.

Take Attendance For Me

(code with A.I.)

This episode shows how A.I. can write spreadsheet formulas to build an attendance scanner that displays both present and absent students

Stop Filling Formulas
(ArrayFormula)

This episode teaches you how to use the ArrayFormula command instead of filling down formulas.

Data Subgroups

(filters)

 This episode teaches you how to use filters to narrow data sets.

Work With Text

(split, concatenate)

This episode teaches you how to combine and split text in a spreadsheet.

Student Call Slips

(vlookup)

This episode teaches you how to use the vlookup function to make printable bulk call slips for students, including classroom numbers by period for easy delivery.



Student Call Slips

(dropdowns)

This episode extends the previous Call Slip application to include dropdown menus to more easily select students by name

Schedule Changes

(send automated emails)

 Here's a basic Schedule Change Request Form that automatically emails a student's parents when they request a schedule change, ensuring that parents know about and consent to important academic decisions that their students are making.