Google Sheet and Forms 24-25

Instructor: Sara Hoffman shoffman@wls4kids.org, 419-344-6740

Course Title:  Google Sheets & Forms for Educators

Registration Link: 

Cost: $555 - TAWLS members can request tuition reimbursement

Location: Whitmer CTC room 121

●      Enter through door 14 by the dumpsters.

●      There is a key pad by door 14, but you will need to request temporary access to the CTC to use your fob.

Skill Level Required:  Basic knowledge of Google Sheets and  Forms.

Course Description: This 3-credit hour course equips educators, administrators, and secretaries with the skills to leverage Google Sheets and Forms to enhance efficiency and organization. Through a blend of hands-on instruction, engaging activities, and real-world scenarios, participants will gain mastery in essential functions, explore powerful add-ons like FormMule and Autocrat, and unlock the potential of Forms for assessments and data collection.  

Agenda

Classes meet from 3:30 - 7:00 PM

 1) Oct 15, 2024 - Introduction to Google Forms

2)  Oct 17, 2024 - Form Creation and Data Management

3)  Oct 22, 2024 - Foundational Skills in Google Sheets

4)  Oct 24, 2024 - Advanced Google Sheets & Collaboration

5)  WEDNESDAY, Oct 30, 2024  - FormMule & Autocrat for Automation

6)  Nov 7, 2024 - Flippity.net & Gamification

7)  Nov 12, 2024 - Class Work Session

8)  Friday, Nov 14, 2024 - Course Wrap-Up & Project Presentation

Grades:

1)     Assignment #1 (10%)

2)     Assignment #2 (10%)

3)     Assignment #3 (10%)

4)     Assignment #4  (10%)

5)     Assignment #5 (10%)

6)     Assignment #6 (10%)

7)     Final Assignment (15%)

8)     Participate in class interactions on Google Classroom Discussions. (25%)

 Technology Concerns/Skills required

●      Basic knowledge of Google Applications is necessary to be successful in this class. This is not a beginner’s class.

●      Participants will bring a charged computer with them to each class.