Hi You could either use google forms to populate values or let them enter straight onto sheet With a simple sheet I would probably let them enter directly onto sheet….with a more complicated sheet with calculated columns and pretty formatting I would use google forms to protect the sheet jim [signature_1213693253] Jim Sibley Director [id:[log in to unmask]] http://cis.apsc.ubc.ca/ Faculty of Applied Science University of British Columbia | xʷməθkʷəy̓əm (Musqueam Territory) CEME 1214-6250 Applied Science Lane Vancouver, BC Canada V6T 1Z4 Phone 604.822.9241 Email: [log in to unmask]<applewebdata://285DF69B-4A03-4096-8CA2-A77E89C8EB2A/UrlBlockedError.aspx> Check out my book Getting Started with Team–Based Learning<http://www.learntbl.ca/> Check out my TBL website at www.learntbl.ca<http://www.learntbl.ca/> © Copyright 2020, Jim Sibley, All rights reserved The information contained in this e-mail message and any attachments (collectively "message") is intended only for the personal and confidential use of the recipient (or recipients) named above. From: Neil Haave <[log in to unmask]> Date: Thursday, March 12, 2020 at 11:10 AM To: "Sibley, James Edward" <[log in to unmask]> Cc: "[log in to unmask]" <[log in to unmask]> Subject: Re: Resources for moving in-person TBL classes online? Hi Jim, This is a helpful tip. So do you have students post into a Google Form and then that is collected into a Google Sheet which then is shared once team answers have been collected? Neil Neil Haave, PhD Professor, Biology<https://www.augustana.ualberta.ca/disciplines/biology/>, Augustana Faculty, Camrose, AB Associate Director, Centre for Teaching & Learning<https://www.ualberta.ca/centre-for-teaching-and-learning> [Image removed by sender.] Teaching Professor Conference Advisory Board member<https://www.magnapubs.com/teaching-professor-conference/advisory-board.html> [Image removed by sender.]<https://www.magnapubs.com/teaching-professor-conference/> email<mailto:[log in to unmask]> | website<https://www.ualberta.ca/augustana/about-us/academic-staff/neil-haave> | blog<http://activelylearning2teach.blogspot.ca/> | Twitter<https://twitter.com/nhaave> | LinkedIn<https://ca.linkedin.com/in/neilhaave> "Education should not be intended to make people comfortable; it is intended to make them think." Hanna Holborn Gray, President, University of Chicago, 1978-1993 On Thu, 12 Mar 2020 at 11:46, Sibley, James Edward <[log in to unmask]<mailto:[log in to unmask]>> wrote: Hi Here is how we use Google docs….the instructor prepares a sheet before class (this sheet even has calculated columns) instructor then posts google sheet URL and students type in the in their answers…and when instructor finally display sheet it acts as the simultaneous reveal [cid:170cfef84724cff311] [signature_1213693253] Jim Sibley Director [id:[log in to unmask]] http://cis.apsc.ubc.ca/ Faculty of Applied Science University of British Columbia | xʷməθkʷəy̓əm (Musqueam Territory) CEME 1214-6250 Applied Science Lane Vancouver, BC Canada V6T 1Z4 Phone 604.822.9241 Email: [log in to unmask] Check out my book Getting Started with Team–Based Learning<http://www.learntbl.ca/> Check out my TBL website at www.learntbl.ca<http://www.learntbl.ca/> © Copyright 2020, Jim Sibley, All rights reserved The information contained in this e-mail message and any attachments (collectively "message") is intended only for the personal and confidential use of the recipient (or recipients) named above. From: Team-Based Learning <[log in to unmask]<mailto:[log in to unmask]>> on behalf of Amanda Rees <[log in to unmask]<mailto:[log in to unmask]>> Reply-To: Amanda Rees <[log in to unmask]<mailto:[log in to unmask]>> Date: Thursday, March 12, 2020 at 10:26 AM To: "[log in to unmask]<mailto:[log in to unmask]>" <[log in to unmask]<mailto:[log in to unmask]>> Subject: Re: Resources for moving in-person TBL classes online? Dear Amy Today is our last day before spring break and who knows if we'll come back together after that so here's what I'm doing. * introducing students to google docs so they can create items for a gallery walk together. * introducing them to ZOOM * introducing them to google hangouts just for chatting in general without the set up of zoom. * creating a google form to ask students about access to wifi, laptops, their three major concerns about shifting to online etc. There's a new fb page for folks called "Remote Teaching Resource Group" that has folks saying what they are planning but interesting updates of software etc. I noticed a message about making ZOOM more accessible during this challenging time. So, this might be a place to come back to as we all work this out. Manda Amanda Rees, Ph.D. Professor of Geography Coordinator: Columbus Community Geography Center<https://csuepress.columbusstate.edu/ccgc/> Chair: Teaching & Learning Enhancement Committee Editorial Board: Journal of Geography (2020-2022) Mailing Address: Dept. History & Geography, Columbus State University, 4225 University Ave, Columbus, GA, 31907 Office Location: 350 Yancey Center One Arsenal Place, 901 Front Ave, Columbus, GA 31901<https://www.columbusstate.edu/maps/images/Map2016_WEB2_.jpg> On Wed, Mar 11, 2020 at 2:02 PM Amy E. Hughes <[log in to unmask]<mailto:[log in to unmask]>> wrote: Hi, everyone -- What are some of the best resources, tools, and advice available to TBL instructors teaching in-person classes who will (or might) need to move their courses online? In particular, I'm curious about: 1) how TRATs can be done online/virtually 2) the best videoconferencing tools (or other tools) to facilitate TRATs, team discussions, full-class discussions, and application activities in "real time" 3) technologies or methods to enable students to do presentations of team-based assignments that would otherwise happen in person. Currently, I am using Canvas to provide content (PDFs/videos), collect and assess written assignments, and record grades in my TBL class. But we meet in person 2x/week, during which we do RATs, application activities, team projects, etc. How do I move those activities online? Many thanks for your guidance and advice, Amy Hughes Dr. Amy E. Hughes (she/her) Associate Professor of Theatre & Drama Head, Bachelor of Theatre Arts (BTA)<https://smtd.umich.edu/programs-degrees/degree-programs/undergraduate/theatre-drama/bachelor-of-theatre-arts-in-theatre/> University of Michigan, Ann Arbor [log in to unmask]<mailto:[log in to unmask]> Bio: http://bit.ly/AEHughesUM Coeditor, A Player and a Gentleman: The Diary of Harry Watkins, Nineteenth-Century US American Actor: http://bit.ly/PlayerGentleman and http://harrywatkinsdiary.org Author, Spectacles of Reform: Theater and Activism in Nineteenth-Century America: http://bit.ly/HughesSpectacles ________________________________ To unsubscribe from the TEAMLEARNING-L list, please click here.<https://lists.ubc.ca/scripts/wa.exe?SUBED1=TEAMLEARNING-L&A=1> Further information about the UBC Mailing Lists service can be found on the UBC IT website. ________________________________ To unsubscribe from the TEAMLEARNING-L list, please click here.<https://lists.ubc.ca/scripts/wa.exe?SUBED1=TEAMLEARNING-L&A=1> Further information about the UBC Mailing Lists service can be found on the UBC IT website. ________________________________ To unsubscribe from the TEAMLEARNING-L list, please click here.<https://lists.ubc.ca/scripts/wa.exe?SUBED1=TEAMLEARNING-L&A=1> Further information about the UBC Mailing Lists service can be found on the UBC IT website. ######################################################################## To unsubscribe from the TEAMLEARNING-L list, please click the following link: https://lists.ubc.ca/scripts/wa.exe?SUBED1=TEAMLEARNING-L&A=1 Further information about the UBC Mailing Lists service can be found on the UBC IT website.