Home Gamification Quick – Add Scholar Birthdays to Google Calendar

Quick – Add Scholar Birthdays to Google Calendar



All of us have a calendar of issues to maintain observe of. Workers assembly dates, dwelling soccer video games, PLN conferences, and extra. Lately, I had a trainer ask me how she may shortly add all of her college students birthdays to Google Calendar.™ Clearly, we will one after the other create a calendar occasion. Nevertheless, can’t there be a greater manner? Right here is easy methods to add pupil birthdays to Google Calendar… or any listing of occasions.

Which Google Calendar?

Your Google account has a default calendar. The calendar ID is your common e-mail. Nevertheless, you possibly can have a number of calendars! I apparently have 30. Use my free Add-on DelCal to create an inventory of your whole calendars and delete those you now not use. It, as with all of my Add-ons, collects NO person information.

You could need to create a calendar JUST for sure occasions. For instance, would you like all the house soccer video games to be in your default calendar? By making a separate Google Calendar you possibly can toggle displaying these occasions. This manner the scholar birthdays don’t get confused with college conferences.

Create a Particular Google Calendar

That is after all non-obligatory. There are a lot of good causes to maintain it easy and put all the things onto your default calendar. Nevertheless, there are additionally many good causes to create totally different calendars.

In the sidebar use the plus icon next to the Other calendars heading to create a calendar to Add Student Birthdays to Google Calendar

To create a brand new calendar, find “Different calendars” on the left hand facet of your Google Calendar. Click on the plus icon. This provides you with a drop down to pick out “Create new calendar.”

After clicking the plus icon for Other calendars click on Create new calendar  Add Student Birthdays to Google Calendar

Use CalAdd to Create a Calendar

Alternatively, create a brand new calendar utilizing my Add-on CalAdd. A easy menu immediate asks you what you need to title your calendar and it’s created for you.

As with all of my Add-ons, CalAdd by Alice Keeler collects NO USER DATA.

Create A number of Calendar Occasions at As soon as

CalAdd lets you, in bulk, add a number of occasions to Google Calendar without delay. Use the Extensions menu in any Google Sheet to pick out “CalAdd by Alice Keeler.”

Extensions menu for CalAdd by Alice Keeler

Calendar ID

Until you might be utilizing your default Google Calendar, which has a calendar ID that matches your e-mail deal with, you will have to find the calendar ID of the calendar you want to add occasions to.

Calendar Settings

One option to get the calendar ID is to go to Google Calendar and hover over the calendar on the left hand facet till 3 dots seem. Go to Settings for that calendar. Scroll down and discover the Calendar ID. Copy this.

The opposite option to get the calendar ID is to make use of the choice “Checklist All Calendars” from the menu in “CalAdd by Alice Keeler.” This may insert a brand new sheet with the listing of your whole calendars and the ID. Copy the ID you want to use.

Need Extra Assist with This? Turn out to be a Premium Member


In any Google Sheets spreadsheet, use the Extensions menu to pick out “CalAdd by Alice Keeler.” You’ll be prompted for the calendar ID. This may add a sheet to the spreadsheet

Spreadsheet showing the setup of CalAdd by Alice Keeler. The calendar title, calendar ID, and headings of Event Title, Description, and Times. There is a sample event. An arrow points to row 4 to indicate to start adding events there.

Row 3 is an instance. Begin your occasions listing in row 4.

Scholar Birthdays

Create an inventory of your pupil names in column A. It’s non-obligatory so as to add an outline in column B.

Date Format

For every birthday it would be best to add it to column C within the format of mm/dd/yyyy hh:mm:ss. For instance if a college students birthday is February twenty eighth enter 02/28/2012 12:00:00.

mm/dd/yyyy hh:mm:ss

Choose All Day Occasion

Scholar birthdays are all day occasions. You do NOT have to fill out the top date since birthdays are solely in the future. Examine the checkbox for “All Day Occasion.”

Add to Google Calendar

Use the menu to pick out “CalAdd by Alice Keeler” and select “Create occasion.” This may add all the pupil birthdays to the Google Calendar without delay.

Add Extra Birthdays

CalAdd by Alice Keeler will bear in mind your calendar ID. Use the menu to “Make Extra Occasions.” This may add a brand new sheet to the spreadsheet, permitting you to create a brand new listing of pupil birthdays.

5 Methods to Clear Out Your Gmail

The best way to clear out your gmail. You need to maintain a clear inbox to extend your productiveness. Listed here are 5 ideas from Alice Keeler on easy methods to maintain your Gmail inbox clear.

FASTER! Create Rubrics for Google Classroom

Rubrics for Google Classroom are sluggish to create and arduous to reuse. Strive GC Rubric by Alice Keeler to create quicker and higher rubrics for Google Classroom.

Quick – Add Scholar Birthdays to Google Calendar

Add a number of Google Calendar occasions without delay. CalAdd by Alice Keeler makes it quick so as to add pupil birthdays to Google Calendar. Or any listing of calendar occasions.

Bulk suspend google accounts


BULK SUSPEND GOOGLE ACCOUNTS. For admin of Google Workspace accounts. This free Add-on by {CLAYCODES} lets you create an inventory of customers and bulk droop person accounts.

How Are Click on Right here Made

Are you questioning “How are click on right here made?” You see “Click on Right here” in lots of web sites or emails. Listed here are the steps for easy methods to create your individual hyperlinks so folks can click on right here.



Please enter your comment!
Please enter your name here