April 22, 2024
April 22, 2024
Embedded Files
Teacher-friendly Spreadsheet Hacks
Teacher-friendly Spreadsheet Hacks
I was sick all last week, so I had lots of time to scroll Instagram. In my doom scrolling I found some neat spreadsheet tricks that I thought could be useful to teachers...so of course I had to bring them to you!
I was sick all last week, so I had lots of time to scroll Instagram. In my doom scrolling I found some neat spreadsheet tricks that I thought could be useful to teachers...so of course I had to bring them to you!
Disclaimer:
Disclaimer:
All of these hacks can be done in Google Sheets!! Depending on your version of Microsoft Excel, they may or may not work there.
Progress Tracker
Progress Tracker
Having your kids do a project or assignment with multiple steps or stages? This progress tracker is a fantastic visual for keeping tabs on your students as they move through it. The video shows you how to do it on your own, but you KNOW I'VE GOT YOU COVERED with a template that you can take and bake!
Text Split
Text Split
So many times we get/make reports and spreadsheets where all the information is shoved into one cell, which isn't always helpful. We tend to want to have things like first name and last name in separate columns...which can be A LOT of copying and pasting. Watch the video for a quick way split text into different columns.
Split column excel trick.movInserting Images into Cells.movInsert Images into Cells
Insert Images into Cells
Adding images to spreadsheets has been a hassle in the past! No more! It's a breeze! Watch the video for how to do it in seconds!
Assignment Tracker
Assignment Tracker
This could be a cool way for students to track assignments and due dates! Disclaimer though, I am a novice at this and can't get the "45401 Days Overdue" to go away on rows without dates. If you can work some magic on it, let me know! (I didn't include the video on this one, because it was difficult to follow) I feel like it is very ignorable if you see this being of value. For student use, simply copy the link that I have provided and paste it into your Canvas page. It will force them to make a copy.
Page updated
Report abuse