THE CENTER FOR TEACHING, LEARNING, AND ASSESSMENT @CGCC
  • Instructional Design
    • Course Planning & Design (IDR)
    • Backward Design
  • Instructional Technology
    • Canvas
    • Cisco Webex
    • Concourse Syllabus Training
    • Google@CGCC
    • Grading in Canvas
    • Migrating Instruction Into Canvas
    • Resources
    • Respondus
    • TurnItIn
  • Teaching & Learning
    • Be an Effective Teacher
    • Base Camp
    • Hybrid Summit
    • Accessibility Peak
    • Teaching & Learning Blog
    • Workshops
  • Assessment
    • Assessment Overview
    • Assessment Process
    • General Education Student Learning Outcomes
    • GEAR (General Education Assessment Resources)
    • Canvas Assessment Guides
  • About Us

Use Google Sheets to Schedule and Send Birthday Greetings to Your Students Automatically!

9/13/2022

0 Comments

 
Picture
Picture
My story
This summer I saw a video on sending personalized automated birthday cards to your students. It piqued my interest and I decided to try it out this year. While there are other ways to collect your student information, I started off with a Google form to collect birthdays and a few other pieces of information from this. I plan to send this out in my welcome letter to students for my classes and post in the week 1 getting started materials.

Picture

Skills/Tools Needed
  • Google slides (to create your personalized birthday message)
  • Google forms (to create a survey to collect your students' birthday information) - alternatively you can collect the information some other way and then input that data into a Google spreadsheet
  • Google spreadsheet (this is where the birthday information is kept)
  • Autocrat - an extension for Google spreadsheets (to automatically send the Birthday greeting/card)
Instructions
Click the link below for detailed "How-To" instructions.
Birthday Card "How-To"

Other Uses
If you have the email information for your class from SIS, you can copy that and use Autocrat to send a card or other information working with the Google spreadsheet and Autocrat (send them all a personalized card after the first exam, last week of class, etc)
Link for the video transcript: Birthday Message Autosend Video Transcript
Give it a Try!
The work is front-loaded and you learn a few more tools that can come in handy! Once you get to know Autocrat, I see all kinds of uses for this! You can also set this up for end-of-semester messages to students, some sort of congrats or recognitions, etc. 

Picture
Share your ideas
If you have other creative ways to utilize Google or Autocrat, please let us know at: ctla@cgc.edu. If you would like to be a CTLA Tech Tuesday guest blogger, please sign-up here: Guest blogger Sign-up Sheet

Your Faculty Liaisons, Jen & Vanessa
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Picture

    Categories

    All
    Asynchronous (Fully Online) Courses
    Audio
    Canvas
    Cisco Webex
    Communicating With Students
    Faculty Development
    Free
    Google
    Graphic/Course Design
    Hybrid Teaching
    Hyflex
    Instructional Technology
    Interactive Tools
    Live Online... Live
    Multiple Attendance Options
    OER
    Policies
    Professional Development
    Teaching Tips
    Tech Tuesday
    Video

    Author

    Awesome people who want to help you do awesome stuff in the classroom! Join the conversation here or in our Facebook Group: CGCC Center for Teaching, Learning, and Assessment 

    Archives

    January 2023
    December 2022
    November 2022
    October 2022
    September 2022
    August 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    November 2021
    October 2021
    September 2021
    August 2021
    July 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020

    RSS Feed

THE CENTER FOR TEACHING, LEARNING, AND ASSESSMENT
Chandler-Gilbert Community College


TOPICS

Adjunct Faculty
Canvas
Help & How to Guides
Staff Resources
Workshops
Assessment

SUPPORT Hours

Monday - Thursday
9am - 5pm

​Friday
9am - 4pm

Contact Us

Phone: 480-726-4245
Email: CTLA@cgc.edu

Pecos Campus: MSQ150
SUBMIT A REQUEST FOR ASSISTANCE
REQUEST FOR COMBINING CANVAS COURSES

After Hours Assistance

Maricopa Canvas Support Website
Support Line: 1.888.994.4433
Submit a ticket to helpdesk@cgc.edu

Picture
© Chandler-Gilbert Community College, 2020.
  • Instructional Design
    • Course Planning & Design (IDR)
    • Backward Design
  • Instructional Technology
    • Canvas
    • Cisco Webex
    • Concourse Syllabus Training
    • Google@CGCC
    • Grading in Canvas
    • Migrating Instruction Into Canvas
    • Resources
    • Respondus
    • TurnItIn
  • Teaching & Learning
    • Be an Effective Teacher
    • Base Camp
    • Hybrid Summit
    • Accessibility Peak
    • Teaching & Learning Blog
    • Workshops
  • Assessment
    • Assessment Overview
    • Assessment Process
    • General Education Student Learning Outcomes
    • GEAR (General Education Assessment Resources)
    • Canvas Assessment Guides
  • About Us