Excel on climate graphs

Getting the students to investigate the three types of climate with real data from worldclimate.com for Singapore, Bombay, India and Alaska, USA .

Students will also perform task such as calculating the temperature range, average temperature and total rainfall to better analyse the different types of climate.

The climate graphs are generated by highlighting the data (temperature and rainfall) and then insert chart wizard.  Select combo chart and tick temperature as the secondary axis.

To get the students to look at real climate data and analyse the climate graphs.

Climate graph on spreadsheet
https://docs.google.com/spreadsheets/d/1IXy3EmGkZpXnkCOoVFA54RP32vQwr_NQgn2iB8QDqlY/edit?usp=sharing

Climate graphs on Excel

https://docs.google.com/spreadsheets/d/1lGcPXIt4tiwOBAqR6k57kn3Tz0_p3OnH/edit?usp=drivesdk&ouid=117561647208614526159&rtpof=true&sd=true

Using Google sheets to generate Graphs

Shared on this @my ICT blog (ezitnew.blogspot.com) and decided to copy and paste to show here too

Sharing how I use Google Sheets to generate scatter graph, comparative line graphs and beach profile for the Coastal GI in helping the students to analyse and represent the data they have collected at ECP.

Creating Scatter graph with best-fit line

Creating a Comparative Line Graph using a Combo Chart with two Y-axes

You can also use this function to create a climograph.  An example -https://docs.google.com/spreadsheets/d/1Y0jjusBUyi8RbZIkiZvlfngDb_DPnLXJdrc-W6fyn1A/edit?usp=sharing

You can get the rainfall and temperature data from http://www.worldclimate.com/

Creating a Beach Profile graph by inserting a line chart.

Coastal GI at ECP - https://sites.google.com/a/moe.edu.sg/sec3geog/geographical-investigation/gi---coast/gi-coast-2016
The spreadsheet which I have created:
https://docs.google.com/spreadsheets/d/1a-Y2IITjjxB6W9FmZmf5KDAhHp0EJApaf-qNT95FDwM/edit?usp=sharing

Using Google Sheets to analyse and represent data for coastal GI

Sharing how I use Google Sheets to generate scatter graph, comparative line graphs and beach profile for the Coastal GI in helping the students to analyse and represent the data they have collected at ECP.

Creating Scatter graph with best-fit line

Creating a Comparative Line Graph using a Combo Chart with two Y-axis

Creating a Beach Profile graph by inserting a line chart.

Coastal GI at ECP - https://sites.google.com/a/moe.edu.sg/sec3geog/geographical-investigation/gi---coast/gi-coast-2016
The spreadsheet which I have created:
https://docs.google.com/spreadsheets/d/1a-Y2IITjjxB6W9FmZmf5KDAhHp0EJApaf-qNT95FDwM/edit?usp=sharing<

GeoHunt

Created an amazing race style "Geohunt" using Google form and QR codes. The data is later collated and represented on the Google spreadsheet for collaborative learning.

 

Using Google form, I made use of the setting to go to different sections according to the option chosen to enable the groups to start off their race at different stations. By setting it as a quiz, points can be awarded to the correct answer at the stations. The total points will be calculated and shown immediately after the student submit the form.
In the edit mode, create the number of sections e.g. I have 20 stations and plus the home page which they select their group, so I created 21 sections. For sections which the questions are similar e.g. the measurements for weather, I simply duplicated them and change the station number. I could also reorder them by clicking on move section.

To add question in the section just click on the plus(+)icon. You can also insert picture or video.

As shown in the picture below, set the question on whether to proceed to the next station as required. Then click on the : (next to required), which is the setting, and click on "Go to section based on answer".

The picture below shows the options of being able to direct them to different sections based on option they have chosen, in this case their group number,  as shown on the edit mode. However when the students access it, they will not see "go to section..."

The picture below shows what the student will see when they access the form. They just need to click on their group and then click on next. They will automatically be directed to the station assigned.

For e.g. when group 20 click on group 20 and then next, it will proceed to the section on station 20.

And when they have completed the task at station 20, the group will click on "Go to the next station" and they will be directed to station 1. So they will just proceed until they reach station 19 then they will choose the option "completed - submit form“ and all their responses will be captured.

I have a total of close to 100 students and did not have enough weather tracker for each group. Initial plan was to get the students to take turn to go to the five stations which the teacher will pass them the weather tracker at the station. But that would mean 4 groups or 20 students at a station which will be too crowded.

That's why I need to create the other 15 stations with QR code in which they will scan and get info to answer the question in the Google form so that they are all spread out in the 20 stations in the school. As I have set it as a quiz, points are automatically given and total up for the race.

You will need to set the question as required so that the students will choose the option to proceed to next station or if they have completed the 20 stations, they can click on "completed - submit form"

Once they choose the option to submit form after completing the 20 stations, they will be directed to this page to submit.

On the edit mode I can collate their responses using the CSV file. They will then use the data to create graphs and analyse their findings.

As introduced by Pierre in the sg learning designer circle, the Google form can be used to create customised quizzes which the students can be directed to another question/story line (section) based on their response. The Google form can be used to create a "Choose your adventure" story. Great for English and even Science.

You can check out how to create the quiz by watching the video below. Hopefully this inspires you to create a personalised quiz for your students to match their abilities. 

My other post on the use of QR codes - http://ezitnew.blogspot.sg/2015/11/qr-codes.html

The Google form accessed by the students:
https://docs.google.com/forms/d/e/1FAIpQLSd6-5Mmi3im7WATgCSzUK8VWhvFVnLmWpdnlaF6mDHL7EyObg/viewform

One main advantage of using Google form is that all the responses are collated on a csv file which can then be converted to a spreadsheet which the students can share the data collated - part of collaborative learning.https://docs.google.com/spreadsheets/d/1w7Mktt6AGOF4RPf0s_rj3TX1p75TmG50CBV-Nw_SzhQ/edit?usp=sharing

The students can also insert chart to represent the data - e.g. scatter graph and comparative line graph using the data extracted.https://docs.google.com/spreadsheets/d/1fbHMvcHbsGHccQh38W7XZl7Sy8yF0EibqM18ZDkumC8/edit?usp=sharing