DigCompEdu Competence area
Progression Level
Minimum digital skills level of Students
Minimum digital skills level of Educators
Learning/Teaching situation
Collaborative data collection, flipped learning activity, in class or home learning.
Target group
All ages.
Ingredients
- PC/laptop/smartphome
- Internet connection
- Access to Google drive
Description
Using shared spreadsheet such as Google sheet will allow students to collaborate and collect data in one place. The data can then be studied and analyzed by each student individually. The data can be used to create graphs and diagrams to display the information in a visual manner.
How to do it (step by step)
Step 1
The teacher must open Google sheets and create a relevant spreadsheet.
Step 2
The teacher shares link to the students. With clear guidelines on how to complete the spreadsheet.
Step 3
Students may need to be taught how to use some functions of the spreadsheet.
Step 4
The teacher sets the data collection activity and associated presentation task.
Step 5
Students carry out research.
Step 6
Students input data into Google Sheet.
Step 7
Further independent activities are then carried out by the students to analyze and present the data.
There is more…
- Google sheets works in the same way as Microsoft Excel.
- You can use mathematic functions: sum of chosen cells, extractions and count cells with certain response etc.
- You can have multiple sheets in one document. You can link them together with functions.
- With shared access it can be a great collaborative tool, but you could use it without the data collection activity and supply the data to be analysed.
- You can leave comments directly in the file, even tag people, so they will be notified.
- When you are done, you can download, print your sheets, and attach directly to an email.