4 Tips for Sorting in Google Sheets

As teachers we need to utilize data constantly. Google Forms is an excellent way to collect data from formative assessments. The purpose of formative assessment is to utilize the data to form what your next steps are. To reteach, to examine the quality of your...

Google Sheets: Toggle Text Wrapping

Unlike the old Google Sheets, the new Google Sheets does not text wrap by default. When students submit paragraph text to a Google Form, or if your spreadsheet data is long strings of text, you may want to toggle the text wrapping on and off. Toggling the text wrap...

Google Sheets: Create a Map

  Today I needed a map of the countries that participate in the TIMSS study. The website provided a list of the countries, I just needed to map them. Google Sheets From Google Drive (http://drive.google.com) create a new Google spreadsheet. Copy Highlight the...

8 Google Forms Formative Assessment Tips

If you use Google Forms for formative assessment quizzes here are some tips for managing the resulting spreadsheet. Ask for Student ID Number (SID) When organizing data it is important that your data match. Trying to sort data by student name can be sketchy when...

Google Forms: Trick for Listing a Lot of Dates

  At the start of each class my students fill out a quick Google Form to indicate their attendance in class. I also use this to ask my students if they have any questions, comments, concerns or compliments. This gives me an opportunity to listen to each student...
Page 30 of 38« First...1020...2829303132...Last »