Trendlines: 12 Days of Chanutech, Day 4

To celebrate the holiday season, I'll be posting 12 Days of easy classroom tech ideas you can use right away!

Weekend Edition!
Day 4: Trendlines in Google Sheets
This one snuck by me last August, but Google added the ability to add trendlines to its Google Sheets charts and graphs!

Science and math teachers know that this has always been a major feature missing from Google Sheets. When students create graphs, they have the option to add a linear or exponential trendline, and an option to display the R-squared and coefficient values.



Here's a link to the specific instructions: https://support.google.com/docs/answer/6075154

Have fun! See you Monday!

Comments

Post a Comment

Popular Posts

Google Drawings! 12 Days of Techmas, Day 10

Image
To celebrate the holiday season, I'll be sending out  12   Days  of easy classroom tech ideas you can use right away!   Weekend Edition! Day  10: Google Drawing A little used feature of the Google Apps system is  Google Drawings . I think this is because of its name: it  seems to imply free-hand drawing  on a computer, which may seem of limited use to most teachers. A Barely-Educational Example  (Keep reading for better examples!) However, free-hand is the  least  useful tool in Google Drawings. Where it really shines is in  free-layout text and shape drawing .  Google Drawings is  perfect for making concept maps and graphic organizers . You can make an organizer and share it with your students, or they make make their own.   Maybe these examples I whipped up might seem more educational: Concept Map about Fine Arts [Ironically, the example concept map of Fine Arts above is an  ugly color-tastrophe , but st
Read more

17 Classroom Tricks for your Whiteboard, Projector, and Doc Camera

Image
The combination of whiteboards, projectors, and document cameras is more powerful than many teachers realize. In the hectic rush of our everyday teaching, it's too easy to fall back on using these powerhouse tools as little more than digital overhead projectors.  So, here's what I call some "mini-tricks" to get more out of your whiteboard setup! Take a picture!  Your document camera is great for taking a snapshot of that worksheet you are projecting.  Many have a snapshot button right on the case; others use a little software program (ELMOs use ImageMate). Take lots of pictures! Are you presenting your notes via the document camera?  Take a quick picture for every page.  You can upload the pictures to Google Drive, DropBox, or Moodle, and share them with your students. Take video!  Most document cameras have an adjustable lens that can face horizontally.  It is a snap to record snapshots or videos of your students with the camera's software. Draw on m
Read more

Take Your Google Docs With You Before You Graduate

Image
Taking Your Google Data With You Before You Graduate:   Google Takeout Students who use Google Apps in school can amass a large number of docs, presentations, etc, representing a huge amount of academic work. Because these docs are stored in the cloud, you could lose them when your school deactivates your account after you graduate.  Fear not! Google Takeout lets you download and save all of the Google Drive and Gmail data that your created when you were in school. Go to https://www.google.com/settings/takeout . If prompted, sign in with your school Google Account. . Scroll down and turn OFF the data that you do NOT need to save. This is up to you. You know best which services you used and need to archive. NOTE: There are limits to the number of times you can archive your data, so choose wisely the first time. Click Next . Leave “File type” and “Delivery method” unchanged and click “ Create archive .” When archiving is done, you will see a screen like the one
Read more