Extra+Web+2.0+Tools

This page will present a few activities that are specifically designed to improve students skills in the use of spreadsheets, databases and graphs.
=Spreadsheets: Zoho Sheet = []



Spreadsheets have the ability to tabulate, calculate and graph data that is entered. Students can learn to gather results from an experiment that was done in class and tabulate the data onto a Zoho sheet. Zoho sheets are online spreadsheets and can be accessed online, shared, imported, exported and printed. The task may include students using data loggers to collect data on the temperature and pH of water collected by the teacher from nearby ponds and rivers, then tabulating the data on Zoho. This would still cover other syllabus outcomes such as:

Outcome 5.15: A student gathers first-hand data accurately 5.15 Gathering first-hand information a) Make and record observations and measurements accurately

They would also develop skills in:

Outcome 5.17: A student explains trends, patterns and relationships in data and/or information from a variety of sources 5.17 processing information d) organise data using a variety of methods including diagrams, tables, spreadsheets and databases e) identify trends, patterns, relationships and contradictions in data and information

Outcome 5.18: A student selects and uses appropriate forms of communication to present information to an audience. 4/5.18 presenting information b) select and use an appropriate medium to present data and information e) use drawings, diagrams, graphs, tables, databases, spreadsheets and flow charts to show relationships and present information clearly and/or succinctly

Students will find using Zoho sheets more engaging as they would be learning a new computer literacy skill which would allow them to be challenged intellectually.

=<span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">Databases: Midomi and Zoho Creator = <span style="font-family: 'Comic Sans MS',cursive;">[]



<span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">**Description** <span style="font-family: 'Comic Sans MS',cursive;">Students can develop their skills in using databases by first doing a search on a music database such as Midomi while teachers can briefly explian how databases are organized collections of data. Midomi is an example of a voice based search engine that has a large database on music. As another example, students may search up a particular animal on a database created by Microsoft Access. After this, they may attempt to create their own database on the classification of organisms for example.

<span style="font-family: 'Comic Sans MS',cursive;">Students will also develop many other essential skills such as:

<span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">5.17: A student explains trends, patterns and relationships in data and/or information from a variety of sources <span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">5.17 processing information <span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">d) organise data using a variety of methods including diagrams, tables, spreadsheets and databases <span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">e) identify trends, patterns, relationships and contradictions in data and information

<span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">Outcome 5.18: A student selects and uses appropriate forms of communication to present information to an audience. <span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">4/5.18 presenting information <span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">b) select and use an appropriate medium to present data and information <span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">e) use drawings, diagrams, graphs, tables, databases, spreadsheets and flow charts to show relationships and present information clearly and/or succinctly

=<span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">Graphs: Kids Zone - Create a Graph = <span style="font-family: 'Comic Sans MS',cursive;">[]

<span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">**Description** <span style="font-family: 'Comic Sans MS',cursive;">Using Kids Zone's "Create a Graph", students are given a simple interface for putting in graph data and creating different styles of graphs and other visual interpretations of data. Students could be given a task where they must create a graph to give a visual interpretation of results in an experiment. For example, the experiment may involve students collecting data on the temperature of water while an ice is melting in it. This would also include the syllabus outcome where:

<span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">Outcome 5.15: A student gathers first-hand data accurately <span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">5.15 Gathering first-hand information <span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">a) Make and record observations and measurements accurately

<span style="font-family: 'Comic Sans MS',cursive;">Students will also develop many other essential skills such as:

<span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">Outcome 5.17: A student explains trends, patterns and relationships in data and/or information from a variety of sources <span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">5.17 processing information <span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">d) organise data using a variety of methods including diagrams, tables, spreadsheets and databases <span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">e) identify trends, patterns, relationships and contradictions in data and information

<span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">Outcome 5.18: A student selects and uses appropriate forms of communication to present information to an audience. <span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">4/5.18 presenting information <span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">b) select and use an appropriate medium to present data and information <span style="background-color: #ffffff; font-family: 'Comic Sans MS',cursive;">e) use drawings, diagrams, graphs, tables, databases, spreadsheets and flow charts to show relationships and present information clearly and/or succinctly

<span style="font-family: 'Comic Sans MS',cursive;">The playful colours on the interface also keep the learning interface fun and less dull.