Thanks to Jeff Shirey of Avonworth Middle and High School (Pittsburgh, PA) for joining the NGPF podcast recently. In addition to being an accomplished salsa dancer outside the classroom (his living room has a dance floor), Jeff is a spreadsheet whiz inside the classroom. I became aware of Jeff’s work through this news story that focused on his passion for spreadsheets. Jeff shares his insights on favorite projects, how he introduces spreadsheets to his middle schoolers and how he differentiates instruction for his more advanced students. You will certainly walk away with some ideas on how to incorporate spreadsheets in your classroom. Enjoy!
- 0:00~1:18 – Introduction
- 1:18~4:10 – Jeff’s private sector experience
- 4:10~5:13 – A little background on Avonworth Middle and High Schools in Pittsburgh
- 5:13~6:05 – Uber self driving car test in Pittsburgh
- 6:05~8:15 – Jeff’s passion for spreadsheets
- 8:15~11:02 – Introducing spreadsheets to younger students
- 11:02~12:30 – Training students to use Microsoft applications
- 12:30~16:00 – Favorite projects: Long trip planning project
- 16:00~16:24 – Word from our sponsor, Next Gen Personal Finance
- 16:24~23:07 – Favorite activity: Stock portfolio competition
- 23:07~24:49 – How did students perform with their stock picks?
- 24:49~28:30 – Budgeting activity example
- 28:30~29:24 – Individual or group projects? What works best with spreadsheets?
- 29:24~31:40 – Differentiating instruction with advanced students
- 31:40~35:15 – Stocks spreadsheet activity example
- 35:15~36:06 – Advice to fellow teachers about spreadsheets
- 36:06~38:03 -Spreadsheet concepts that students struggle with
- 38:03~38:44 – Comparison of Excel vs. Google Sheets
- 38:44~39:58 – Conclusion
- “Anytime you can incorporate spreadsheets into your projects, that’s great.”
In case you are looking for more ideas, here’s an NGPF newsletter devoted to spreadsheets