Indiana Connected Educators Conference

Google Sheets has so many different functions that can be used throughout a classroom on a regular basis - so this is going to showcase 3 of those functions. We will be using Google Sheets to create Escape Room activities, collecting data on content assessments, sending home communication/communicating with staff. For the escape rooms I will share a template and then walk thru a few different ways that this can be modified for multiple contents. To use as a data assessment piece we will look at all the functionality that the settings in a Google form can do and then linking those to a Google sheet to then analyze the data. These two items can be done with no previous skill or knowledge of Google for Education tools. For communication, this is integrating Slides/Forms/Sheets together using the auto-crat add-on. This is building on to those basic skills and for anyone with intermediate knowledge of the Google For Education tools prior to the session. This can be used to send common communication home to parents but wanting to include specifics to a particular child - maybe a grade update. It can be used to create PD certificates or any certificate that you may want to give inside a classroom or for a staff setting. A folder of templates connected together already will be shared and then we will walk thru creating their own.