We've moved! Visit
The Keyword
for all the latest stories about
life at Google
and our
student programs
.
Student Blog
Brought to you from your @GoogleStudents friends. From pre-university to PhD (and beyond), we got you.
Student Tip: Use Google Docs and Calendar to Import Class Syllabi
September 3, 2010
Taylor Bell is a
Google Student Ambassador
at Boise State University. From time to time, we'll have ambassadors like Taylor share some of their favorite tips and tricks for making Google tools and applications useful for student life. If you have a tip to share on this blog, please let us know!
So you probably all already know that
Google Calendar
is a lifesaver when it comes to organizing classes. The problem, though, is that sometimes professors don’t create a Calendar-ready syllabus for us! Don’t fret – here I'll share how I've managed to harness the power of
Google Docs
to streamline a Calendar for each of my classes, so hopefully you can do the same.
Start by loading the template located at
http://bit.ly/importtemplate
, then rename it to correspond to the name of the class syllabus you’re working on. Leaving the header row, fill in the assignment and due date, as well as the time.
After you’ve finished filling in your due dates, go to File > Download As > CSV. This will create a comma-delimited text file of your schedule that’s ready to be imported directly into Google Calendar.
With your CSV saved to your computer, head over to Google Calendar. Go into Settings (in the top right corner), then click Calendars. Scroll down to the “Create New Calendar” button then create a calendar with the name of your class. In my case, the class is called "Technical Communication" (it's a good one). Once your calendar is created, go back to Calendar Settings, and click on “Import Calendar.” Then locate your .csv file, and choose your newly-created calendar.
After clicking the Import button, you will receive a message about successfully importing your events, and they will show up automatically on your Calendar! There are, of course, variations available. For example, if you prefer to just have one calendar called “School,” you could use the import template to create one massive CSV for all of your classes, then follow the rest of the steps. Either way, it beats typing in each individual due dates manually!
Posted by Taylor Bell, Student Ambassador at Boise State University
Labels
A Day in the Life of a New Grad in Google Dublin
7
AdCamp
2
AdMob
11
Ambassador Program
14
APAC
7
Appy Trails
28
Back to School
4
Better Know a New Grad
1
Better Know an Intern
15
Better Know an Office
4
Black History Month
10
Caitlin Talks to an Engineer
9
Chrome Extensions
3
Chromebook
1
College Tips by Google
1
Community
14
Conferences
16
consortium
1
CSSI
5
Day in the Life
2
deSTEMber
1
Development Programs
1
Diary of a Business Associate Intern
1
Diary of a Summer Intern
41
Diary of a Summer Intern - Erika
9
Diary of a Summer Intern - Franklin
3
Diary of a Summer Intern - Jess
3
Diary of a Summer intern - Luke
3
Diary of a Summer Intern - Madelaine
4
Diary of a Summer Intern - Pablo
3
Diary of a Summer Intern - Rio
4
Diary of a Summer Intern 2012
18
Diary of an MBA Intern
2
Education
19
EMEA
47
Europe
8
Events
13
Exploring Design at Google
4
GHC15
6
Going Green
6
Gone Google
2
Google Code University
1
Google Code-in
1
Google Games
3
Google Japan
1
Google Lime Scholarship
1
Google on campus
2
Google Online Marketing Challenge
10
Google Science Fair
2
Google.org
1
Google+
6
Googlers
14
Googlers Beta
11
Grace Hopper
11
GradTips
9
Hangouts On Air
21
Inside ITRP
6
Intern Insights
31
Intern Program
72
Interns Making an Impact
7
Interviews
1
Jobs
5
just for fun
30
K-12 (Pre-university)
14
LATAM
3
Life at Google
17
Middle East
1
My Path to Google
45
My Summer at Google
15
My Summer at Google 2012
10
North America
4
Office Environment
4
Open Source
9
PhD
7
Products
94
Programs and Competitions
116
Recruiter Tips and Tricks
15
Rice Plus
4
Scholarships
56
Search
1
STEM
2
STEP
1
Student Tips
15
Students
13
Summer of Code
1
Teach Parents Tech
10
Tech Students
3
Tips and Tricks
27
Women in Engineering
21
Young Innovators
10
YouTube
3
Archive
2020
Jul
May
Mar
Feb
Jan
2019
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2018
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2017
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2016
Nov
Oct
Sep
Aug
Jul
Jun
Apr
Mar
Feb
Jan
2015
Dec
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2014
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2013
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2012
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2011
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2010
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2009
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2008
Dec
Nov
Oct
Sep
Feed
Follow @GoogleStudents
Interested in opportunities and programs for students? Visit
google.com/students
.