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.
Category: data coaching
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.
Efficient spreadsheets in the classroom – Split & Combine Names
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.
Efficient Spreadsheets in the Classroom – Cell Referencing
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: […]
Efficient Spreadsheets in the Classroom – Helpful Tips for Teachers
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
photo by lukas blazek on unsplash 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 their own teaching […]
Using Students’ Interests to get them Excited About Data
Start with a hook Distance Learning has been both a blessing and a curse. Most parents and educators are fully aware of the negative side of not having kids in classrooms or physically at schools. I’d like to focus on an opportunity I took with my son for personalized learning. This got him excited about […]
Coaching in Schools: Using Data to Clearly Communicate Your Work to Others
If you are an instructional coach, technology coach or data coach in a school or district, the following scenario might sound familiar to you. In my role as a technology & innovation specialist I am the point person for 28 classroom teachers, 22 instructional assistants and 630 second grade and third grade students. In addition […]