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 […]
Category: data literacy
Maximize your time with Google Add Ons for Free
There is only so much time in one day Google Add Ons have become part of my everyday routine. I spend a lot of time inside spreadsheets and documents. Since I work in a school that uses Google Workspaces for Education, most of my time is spent in the Google ecosystem. A big part of […]
Data Studio can help teams effectively communicate their data
There are benefits to working in large schools. Larger schools usually mean more resources. Those resources could be staff, money, students, and even spaces. With an increase in resources also comes an increase in the need for organization and communication.
Create a great STEAM program with Data Studio
A big thank you to Kelli Buxton (@KelliBuxton) for the historical information about the technology team. A Bit of History A number of years ago, Singapore American School rolled out a one to one iPad program in the elementary school. With nearly 2000 students in the elementary school, this was quite a large task to […]
Give Teachers Access to the Data They Need
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 […]
I want to share my data, but it’s private. Now what?
Have you ever wanted to share an example of a spreadsheet or dashboard with someone else but you were worried about having them see the real data because of privacy issues? Many times, I need to create a sample data set, but still keep the integrity of the actual data. I’ll show you a few ways to quickly create sample data sets to use in Google Sheets or Google Data Studio.
Help Your Students Understand How to Organize Data
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 […]
How teachers can stay organized in a data-rich environment
Teachers have a lot of data to deal with. Staying organized and having a system can help teachers be more efficient.
Efficient Spreadsheets for Teachers: Automatically Highlight What Cells Look Like
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!
Efficient Spreadsheets for Teachers – Drop down menus
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.