Loading…
ESTCA 2021 has ended
π‘­π’“π’π’Ž 𝑨𝑻𝑨 π‘·π’“π’†π’”π’Šπ’…π’†π’π’• 𝑱𝒂𝒔𝒐𝒏 π‘Ίπ’„π’‰π’Šπ’π’π’Šπ’π’ˆ, 𝒕𝒐 𝒂𝒍𝒍 π’Žπ’†π’Žπ’ƒπ’†π’“π’”:
                 President’s Address
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Evaluate your overall Convention experience:
https://surveys.teachers.ab.ca/s3/2021-Teachers-Convention-Annual-Review

Open until the end of March, with many prizes associated!
---------------------------------------------------------------------------------------------------------------------------------------------------

                     π™ˆπ™€π™§π™œπ™šπ™­ 𝙄𝙣𝙨π™ͺπ™§π™–π™£π™˜π™š
Morgex Insurance is proud to sponsor the 2021 ATA Conventions. Request a quote and you could win 1 of 5 Home Office Prizes worth $5,000 each. Click on the Convention’s Sponsor page for additional information.
Back To Schedule
Thursday, February 11 • 11:40am - 12:40pm
Auto-Marking Labs and Activities involving Unique Student-Generated Data for Math and Science using Google Spreadsheets

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.


Students can collect unique data, entering their data, all intermediate calculations, and final answers into Google Forms, which will export to Google Spreadsheet. The Google Spreadsheet will use the student data to calculate an answer key for the first intermediate step, check the students' data against a range of permissible answers, and assign a single mark if the students' intermediate answer falls within this range. It then uses the students answer (whether correct or not), to generate an answer key for the second intermediate answer, and the process repeats. At the end, it will total the marks assigned and give a final mark for the student. Once set up, this allows for teachers to quickly mark labs and activities with student-generated values, checking the accuracy of each calculation, and carrying the mistakes through. For this session, prior knowledge of spreadsheets is highly recommended.

Presentation: https://albertamathresources.school.blog/estca-convention/
Vimeo Video of Presentation: https://vimeo.com/502792015
YouTube Video of Presentation: https://youtu.be/V7w7Sym3KF0

Speakers
avatar for Michael Bayer

Michael Bayer

Math/Physics teacher, Wm. E. Hay Stettler Secondary Campus (WEHSSC)
https://albertamathresources.school.blog/



Thursday February 11, 2021 11:40am - 12:40pm MST
013 Numeracy (sec. focus)