Free Technology for Teachers - 2 new articles

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 ...

Click here to read this mailing online.

Here are the latest updates for nurhasaan10@gmail.com "Free Technology for Teachers" - 2 new articles Two Ways to Use Google Sheets to Create Reading Logs 51 More Constitution Day Resources More Recent Articles 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. This post originally appeared on Free Technology for Teachersif you see it elsewhere, it has been used without permission.               Related Stories Webinar Recording - Making Great Handouts With Storyboard That Share Math Playground Activities to Google Classroom How to Add a Materials Section to Google Classroom   • Email to a friend • 51 More Constitution Day Resources Earlier this week I shared some videos and a couple of interactive resources for teaching lessons about the U.S. Constitution on Constitution Day. Constitution Day is this coming Monday and by law all schools receiving federal funds have to offer some kind of instruction on the U.S. Constitution. If you're still looking for some resources to use on Monday, take a look at what Docs Teach has to offer. DocsTeach has sixteen pre-made Constitution Day activities that you can use today. An additional 35 documents and artifacts about the Constitution can be found through a quick search on DocsTeach. About DocsTeach DocsTeach provides you with tools to create online history lessons that are based on primary source documents, images, and videos. There are thirteen templates that you can use to create lessons on the DocsTeach platform. My favorite template is the analysis template that you can use to create lessons that help students learn to analyze documents and images. The lessons that you create on DocsTeach can be shared with your students through the DocsTeach online environment. You can also share your lessons with colleagues by publishing your lesson to the DocsTeach library. This post originally appeared on Free Technology for Teachersif you see it elsewhere, it has been used without permission.               Related Stories Two Interactive Copies of the Constitution for Constitution Day Video Resources for Constitution Day By Request - Get Organized With Google Classroom and More   • Email to a friend • More Recent Articles Three Types of Elementary School Video Projects to Complete on iPads By Request - Get Organized With Google Classroom and More Bookmark It - A Tool for Adding Bookmarks to a Video's Timeline Voicepods - Automatically Turn Text Into Voice Recordings Free Webinars from the Council for Economic Education

---

Safely Unsubscribe • Archives • Preferences • Contact • Subscribe • Privacy

---

Email subscriptions powered by FeedBlitz, LLC • 365 Boston Post Rd, Suite 123 • Sudbury, MA 01776, USA

• Tweet
• Share
• Share
• Share
• Share

About Admin MC3

This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.

Related Post