Embedded Files
Google Sheets
Google Sheets
Google Sheets is a powerful tool for analyzing data and collaborative editing. For co-teachers this means you can connect with others easily and contribute student data for your groups. Google Sheets is easy to navigate allowing you to create charts and diagrams from any device or location. Even using your mobile phone.
Google Sheets is a powerful tool for analyzing data and collaborative editing. For co-teachers this means you can connect with others easily and contribute student data for your groups. Google Sheets is easy to navigate allowing you to create charts and diagrams from any device or location. Even using your mobile phone.
Learn how you can make the most of this tool by watching the videos below.
Learn how you can make the most of this tool by watching the videos below.
Learn the basic features of Google Sheets such as converting files (.csv and .xlsx files), formatting, creating a database, basic functions/formulas, and useful shortcuts.
Learn some of the more advanced features such as formulas, conditional formatting, and protecting ranges/sheets.
Learn how to use pivot tables, Macros, and the top 10 most common functions in Google Sheets such as:
Average
SUM, SUMIF, SUMIFS
COUNT, COUNTA, COUNTIF
TODAY, NOW
CONCATENATE
Quick Assessments
Quick Assessments
Formative Assessments are useful to gauge understanding during teaching. These assessments determine your next step in providing content and activities to scaffold learning. Below are several great ways to use technology to gather formative data during the learning process.
Formative Assessments are useful to gauge understanding during teaching. These assessments determine your next step in providing content and activities to scaffold learning. Below are several great ways to use technology to gather formative data during the learning process.
Google Slides
Google Slides
Add-on: Peardeck
Add-on: Peardeck
Peardeck is an add-on for Google Slides that allows students to interact with your presentations while also capturing formative assessments as you teach.
Non-tech options are just as valuable as digital ones. Some of our favorite strategies for low-tech or no-tech formative assessments are:
Non-tech options are just as valuable as digital ones. Some of our favorite strategies for low-tech or no-tech formative assessments are:
Glow & Grow
Stars & Stairs
3-2-1
Fist to Five
Muddy Point Card
Ah-ha!
Student Created Criteria
Student Created Criteria
Data Driven Lessons
Data Driven Lessons
Report abuse