Showing posts with label Progress Chart. Show all posts
Showing posts with label Progress Chart. Show all posts

Friday, September 14, 2018

Two Ways to Use Google Sheets to Create Reading Logs

Google Forms and Google Sheets are my go-to tools when I need to collect and organize data. One of the things that I often help teachers do with data in Google Forms and Sheets is create progress trackers or reading logs. There are two ways that you can do this. The first method outlined below is the easier method as it simply requires following a template. The second method outlined below is a little more difficult but the benefit is that you can have students or a teacher's aide enter data to record progress toward a stated numerical goal like "read 1,000 pages this month."

Method #1 - Use Flippity's Progress Tracker Template
Flippity offers eighteen templates that you can use in Google Sheets. One of those templates is a progress tracker template. This template will create a sheet into which you enter student names, goals, and the units that you're tracking (pages, minutes, steps, etc). After you enter that data into the template you can publish the sheet and Flippity will provide you with a simple webpage that displays progress as a colored bar graph. Watch my video for step-by-step directions on using Flippity's progress tracker template.




Method #2 - Google Form + Pivot Table in Google Sheets
The benefit of using this method is that you can have students or a teacher's aide enter information into a Google Form and then you will see the the data in a spreadsheet that you can manipulate to see the data in terms of tracking progress toward a goal. The downside to this method is that unless you're willing to share the spreadsheet with students or set your Google Form to "Respondents Can See summary charts and text responses" they won't see their progress unless they ask you for the information. Take a look at my screenshots below for an outline of the steps needed to duplicate my reading log made by using Google Forms and Sheets.

Step 1 - Create a Google Form in which you ask for name, goal, and pages read that day (or week if that's how you'd prefer to track).


Step 2 - Create a Google Sheet of responses.


Step 3 - From the "Data" drop-down menu in Google Sheets select "Pivot Table."


Step 4 - In the right hand menu that appears on the Pivot Table sheet click "Add" next to "Rows"  then select "Your name," "Your goal," and "Number of pages read."

Step 5 - In the right hand menu of the Pivot Table sheet click "Add" next to "values" then choose "number of pages read."

Step 6 - Admire your summarized data.

Tuesday, December 26, 2017

Track Progress Toward Goals With This Google Sheets Template - Best of 2017

As I do during this week every year, I am taking some time off to relax and prepare for the new year. Every day this week I will be featuring the most popular blog posts of the year. Here is one from January.

This morning I received an email from a subscriber to the Practical Ed Tech newsletter. She had read my tip of the week about using Google Keep to set goal reminders, but she needed something that would be easier to manage with a large group of students. My suggestion was to try Flippity's Progress Indicator template for Google Sheets. The template makes it easy to create a progress chart that will update whenever you update the data in your spreadsheet. In the video embedded below I provide an overview of how to use Flippity's Progress Indicator template.

Monday, January 9, 2017

Track Progress Toward Goals With This Google Sheets Template

This morning I received an email from a subscriber to the Practical Ed Tech newsletter. She had read my tip of the week about using Google Keep to set goal reminders, but she needed something that would be easier to manage with a large group of students. My suggestion was to try Flippity's Progress Indicator template for Google Sheets. The template makes it easy to create a progress chart that will update whenever you update the data in your spreadsheet. In the video embedded below I provide an overview of how to use Flippity's Progress Indicator template.

Thursday, August 13, 2015

How to Create a Progress Chart in Google Sheets

Flippity provides a handful of great Google Sheets templates. I've featured their Random Name Picker, Flashcard, and Jeopardy templates in the past. The latest Flippity template that I've tried is their Progress Indicator template. With that template you can create a progress chart that will update whenever you update the data in the chart. In the video embedded below I provide an overview of how to use Flippity's Progress Indicator template.