A Google Form also needs to be created with similar data fields. A spreadsheet needs to be set up ready for data collection, and decisions made whether to include formulae at the preparatory stage or whether to set up processing after data collection. Preparation: The teacher will need to register for a Google account to access the relevant Google tools. The teacher can then display the completed data set in the spreadsheet, which could be distributed to the class for processing or data analysis could be carried out as a single class exercise. On completion of the form the data transfers to the spreadsheet and is collated with the data from other forms submitted. Then drag your Category to the row field and your Amount to the data field, and set it to sum. ![]() As students set up data collection they are given access to the relevant Google Form URL. To summarize and report results from separate worksheets, you can consolidate data from each into a master worksheet. To get started, select your table and use Insert / Pivot Table. This can be linked to a separate Google tool (Google Forms) which is set up with similar fields to the spreadsheet. Teaching approach: When planning a class investigation which uses shared data, such as a survey, or field work, create a spread sheet using Google docs software. Google forms provides a simple means of collating a large number of sets of data, speedily and without some of the problems encountered when students each transcribe their own data onto a display board. For some investigations, it is helpful to use larger data sets, than single groups could collect during a lesson. Purpose: Usually students work in groups at a practical activity, and use their own results to interpret the outcomes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |