Using Google Sheets to Teach Charts and Tables
Google Sheets is often considered a red-headed step-child within the set of Google tools (similar to Microsoft Excel). Of all the Google and Microsoft apps available, it is one of the “geekier” apps because of all of the complicated formulas and math involved.
Both Google Sheets and Microsoft Excel are relatively simple to use if you take a little time to explore and understand some basic things. For an example, here is a sample of what you can do with inserting Charts to visualize data that you can use with students.
Step 1 – Get the data
Here is some sample data you can use with your students. Courtesy of Ms. Tappin.DateDayHigh AM TideHigh PM TideLow AM TideLow PM TidePhase of Moon5/3/20Sun5.35.10.00.01st Qt5/5/20Tues5.56.0-0.8-0.5Waxing Gib5/7/20Thurs5.56.5-0.8-0.6Full5/9/20Sat5.16.3-0.7-0.3Full5/11/20Mon6.04.5-0.10.3Waning Gib5/13/20Wed18.104.22.168.8Waning Gib5/15/20Fri22.214.171.124.03rd Qt5/17/20Sun126.96.36.199.63rd Qt5/19/20Tues188.8.131.52.4Waning Cres5/21/20Thurs184.108.40.206.3Waning Cres5/23/20Sat220.127.116.11.2New5/25/20Mon18.104.22.168.3New5/27/20Wed22.214.171.124.4WaxingCres529/20Fri126.96.36.199.5Waxing Cres5/31/20Sun5.25.00.00.21st Qt6/2/20Tues5.15.8-0.2-0.3Waxing Gib
Copy this tide data into a new Google Sheet.
Step 2 – Customize Your Chart
Follow the steps outlined in the slides below by watching the video to get step by step guidance.