Tech Talk - ep.58 - Sheets - Working with Classroom Data
0:55 Find Marks in Classroom
2:30 Download your data to Sheets
6:15 Filter button on simple data formula turned horizontally
7:25 Filter function to pull data out
11:00 Filter function used horizontally
16:25 Explaining cell references like Battleship
17:00 Writing a function that pulls data from another sheet(tab)
22:20 Instantly select the entire sheet
23:50 Paste Values after pulling data with a function
24:45 Use the FORMAT PAINT button
26:20 Alternating colours (banded rows)
27:27 Conditional Formatting
31:45 Layering your Conditional Formatting rules
33:30 Create Dynamic Charts with Student Drop-down list
36:55 Data Validation (create a drop-down list)
40:10 Insert a Chart based on your filtered data
***
Visit the TLDSB Technology site at https://tldsb.ca/techservices.