designing a classroom response system using google for mobile learners
TRANSCRIPT
Designing a Classroom Response System using Google
for Mobile Learners
Andreas Dewanto [email protected]
1 October 2014 @ Lecture Theatre 31
Faculty of Science LunchGme Talk on Technology-‐enhanced EducaGon Series
Google Documents: Free “Ms Office” in the Cloud
• Document resembles Ms Word.
• Presenta0on resembles Ms Powerpoint.
• Spreadsheet resembles Ms Excel.
• Form provides the user interface to survey the students and record the data in Spreadsheet.
• Google Form
The Interface
• Google Spreadsheet
The Database
• HTML and Javascript code
The Engine
• Internet Browser
The VisualizaGon
Workflow (cont’d) 2. Link the Survey to Google Spreadsheet
3. Tabulate the responses on the Spreadsheet
Note: use standard Excel funcGons such as SUM( ), COUNTIF( ), etc
sum( )
counGf( )
Note: it is done from Form
Workflow (cont’d) 4. Write/modify the HTML-‐Javascript codes
Note: • It is wrifen in HTML and
Javascript • It involves Google Chart Tools API • It can be downloaded from my
website (follow the link/ QR code below)
• Minimum modificaGon is expected
Gnyurl.com/google-‐crs-‐ver1
Workflow (cont’d) 5. Publish the Form to the students via URL
(recommended to use Gnyurl) or QR code
6. View the result from the browser Recommended browser:
Gnyurl.com/google-‐crs-‐ver1 Features: • Loading the APIs • Querying the Spreadsheet • Drawing pie-‐chart and
column-‐chart to the browser
Gnyurl.com/google-‐crs-‐ver2
More features: • Drawing table to the browser • UpdaGng the table and charts
on real-‐Gme basis • ReporGng error (if any)
during querying
• For more advanced formakng (e.g. super-‐script, subscript, etc) Google Form can be incorporated into Google Site.
• Publish both the Gnyurl (use catchy phrases, for laptop users) and QR-‐code (for “phablet” users) link to the Form.
• Do not show the result unGl the quiz is over. • Run trials prior to the lecture. PotenGal issues could be: – Students are unable to access the Form – Browser is unable to access the Spreadsheet
Resources
• QR Code Generator: www.the-‐qrcode-‐generator.com/
• TinyURL: hfp://Gnyurl.com/ • Codes: sites.google.com/a/sps.nus.edu.sg/ – physichronicles/stuff/google-‐chart-‐tools – physichronicles/stuff/google-‐chart-‐tools2 or simply Google “physichronicles dewanto”