In the beginning… A while ago we had created a system for the teachers and counselors at our school to be able to collect social-emotional learning data. We asked teachers to input information through a Google Form which was connected to a spreadsheet. We then used the spreadsheet to connect to Data Studio to display […]
Google Data Studio for the win! Over the years, I’ve done a lot of work with data visualization through the use of Google Data Studio. I love Data Studio, or DS, or GDS, because it syncs very quickly with Google Sheets, a csv file, or tons of other connectors. GDS is mainly used by people […]
Unit planning for next year Recently I was working with my colleague, David Lee, on designing a grade 5 math unit for next school year. The unit is the first unit of the year for Grade five around the Number And Operations In Base Ten strand of the Common Core Curriculum. The basic concepts are […]
Automatically highlight your data with Conditional Formatting! Here are a few ideas basic ways to get started. There is also a custom formula for advanced users!
Drop Down Menus aka Data Validation. Setting this up correctly can help save time and also eliminate human error for data entry in your spreadsheet.
In this article I will show you a way to combine data from more than one cell and put it together into a single cell. I will also show you how you can break apart data in a single cell across multiple cells.
What are spreadsheets again? In my last article I talked about the basic layout of a spreadsheet. I also mentioned a few of the most common uses for teachers and educators. Based on my experience, teachers have used spreadsheets primarily for the following: 1. Lists: tasks, items in an inventory, birthdays, emails, attendance 2. Grades: […]
This is the first part in a series on beginner tips for using spreadsheets to help teachers be more efficient in the classroom. Common Digital Tools Teachers understand Google Docs & Google Slides, but not so much with Google Sheets. Word processing documents, presentation software, spreadsheets. As teachers, these are digital documents that we use […]
Building A Foundation for Strong Data Culture in Schools Overview Collaboration, communication, creation, workshops, conferences, professional development. These are all concepts that go hand-in-hand with teaching. Teachers are used to workshops and conferences where they are able to connect with other educators on current best practices in education. These opportunities allow them to improve on […]
Create a local community map using Datawrapper. Free student and teacher guide included wth step by step directions.