Mobile Learning toolkit
  • Home
    • The Toolkit Manual
  • iPAC Framework
    • The iPAC sub-constructs >
      • Personalisation sub constructs
      • Authenticity sub constructs
      • Collaboration sub constructs
      • iPAC framework
      • iPAC sub-constructs
  • iPAC Surveys
  • Video scenarios
    • Personalisation videos >
      • Personalisation
      • Tutorials for refugees
      • Multilingual authoring for elementary students in Science and Languages
      • Student teachers learning ABOUT m-learning
      • Sensational square tale
    • Authenticity videos >
      • History Field Trips
      • Mobilising Statistics
      • Student Teacher Reflections
      • Measuring River Flow in geography fieldwork
      • Temperature Measurement in fieldwork
      • Measuring noise levels in a town
      • Interviewing inhabitants of Helmsley, North Yorkshire
      • Real Time Data Gathering
      • Using mobiles during a heritage visit to Rievaulx Abbey
      • Visiting Rievaulx Abbey
    • Collaboration video >
      • Personal Learning Networks for Teachers
      • Global Collaboration
      • Wiki Story
      • Hole of H: Sarah
    • LTTE week_June 2017
  • App Rubric
    • App Rubric
  • eBooks
  • Online Course
  • Network
  • Links

Real Time Data Gathering in Social Geography using Google Sheets

Picture

Focus: Authenticity - Tool and Task

Vertical Divider

Introduction

This video scenario demonstrates how students use their mobile devices to both collect data and formulate results whilst in the field. This focusses on the use of Google Sheets are used in real time on location. 

​Although data collection can be seen as a relatively traditional activity during field trips, the use of the mobile device in this instance enables the students to process the data on location to provide results and so allows them to analyse data in the field. This enabled a further reflection activity in the field to consolidate the learning on not only the results, but on the process of data capture in the field. This mimics the way in which field work happens out of school.

Objectives of this scenario:

  • to demonstrate how mobile devices (smartphones) can be used to support students during field work
  • to illustrate how a traditional task can be made more authentic and meaningful,yielding real time results with the support of mobile technologies in a non-formal setting
  • to raise awareness of how the setting (in this case Car Parks in a market town) can be transformed into a learning opportunity using mobile technologies

Description of the learning scenario

Students used a pre-loaded database of car registration to see where visitors to Helmsley had come from. They were able then to enter this data into a SS to explore any patterns including:
  • The distance travelled to Helmsley
  • The place from which people had travelled

Impact of the learning scenario on students

Students were able to use the mobiles to reflect on the data as it was being analysed. This allows them to reframe their questions and hypotheses in the field. Whilst this was relatively simple data with more complex data this reduces the gap between data collection and data analysis and allows the students to work with the data in real-time and in real-place. This enhances the learning experience.
Picture



Free Apps
  • AA Distance Calculator App
  • Google Sheets

Picture



Table Device
​Smartphone

Picture
inputting data in the field
Picture
​discussing the data

How could this scenario be extended?

This scenario could be extended in a number of ways.

Firstly, this could be done as a more collaborative exercise with different students attending different car parks in the same or different towns and filling in the google sheets using different tabs.

Secondly, students could record their reflections and guidance for students to use in the following year, based on their experiences. In using the explain everything tool, the teacher could use this in a flipped learning context therefore cutting down on the amount of class preparation time.

Students in involved in this scenario

Matthew Kearney (Technical University of Sydney, Australia), Sarah Jones (Univeristy of Hull, UK), William Hocking (Metis Acadimat, Bergen, Norway)
Picture
Exploring the data
Picture

Rate this exemplar yourself

Comments from users
​

    Please let us know what you think about this video scenario. Was it helpful for you in your context?
    if you wish to find out more about the MTTEP project please leave your name and e-mail address
Submit

Enquiries

For all enquiries about this project, including how to get involved or joining our network, please contact info@mttep.eu

Technical

For technical questions, errors or issues related to the website please contact web@mttep.eu

Email

info@mttep.eu

NOTICE: This project has been funded with support from the European Commission. This website reflects the views only of the project team and the Commission cannot be held responsible for any use which may be made of the information contained therein.

  • Home
    • The Toolkit Manual
  • iPAC Framework
    • The iPAC sub-constructs >
      • Personalisation sub constructs
      • Authenticity sub constructs
      • Collaboration sub constructs
      • iPAC framework
      • iPAC sub-constructs
  • iPAC Surveys
  • Video scenarios
    • Personalisation videos >
      • Personalisation
      • Tutorials for refugees
      • Multilingual authoring for elementary students in Science and Languages
      • Student teachers learning ABOUT m-learning
      • Sensational square tale
    • Authenticity videos >
      • History Field Trips
      • Mobilising Statistics
      • Student Teacher Reflections
      • Measuring River Flow in geography fieldwork
      • Temperature Measurement in fieldwork
      • Measuring noise levels in a town
      • Interviewing inhabitants of Helmsley, North Yorkshire
      • Real Time Data Gathering
      • Using mobiles during a heritage visit to Rievaulx Abbey
      • Visiting Rievaulx Abbey
    • Collaboration video >
      • Personal Learning Networks for Teachers
      • Global Collaboration
      • Wiki Story
      • Hole of H: Sarah
    • LTTE week_June 2017
  • App Rubric
    • App Rubric
  • eBooks
  • Online Course
  • Network
  • Links
✕