Technology for Educators

December 29, 2010

This Blog Has Moved

Filed under: Uncategorized — Sue Frantz @ 6:28 pm has served me well, but operating on their servers comes with some limitations that don’t work well for the kind of blog that I have. You can now find me at I’ve imported all of my old blog posts to the new server, so if you want to revisit a post, you can do that over there. If you have this blog coming into your RSS feed reader, click here to get the new feed. I’ll see you over there!

Google Calendar: Create One for Your Class

Filed under: Uncategorized — Sue Frantz @ 11:42 am

There are two things on my computer I have open at all times: My email and my calendar. While I use the Outlook calendar, I sync it with Google Calendar so that any changes I make it one appear in the other. (How to sync Outlook and Google Calendar.)

There are a few advantages to using Google Calendar, such as.

  • It syncs easily with my Android phone.
  • I can use YouCanBook.Me so my students can create appointments with me on their own. (See this blog post.)
  • I can see all of my scheduled reminders. (See this blog post.)
  • I can share a calendar with my partner. All of our social engagements and travel go there.

Here’s another advantage. I can create a calendar for my class schedule that way I don’t have to dig out my syllabus to see what’s coming up. I can just look at my calendar. By creating it as a separate calendar, I can turn it off when I’m not using it so it doesn’t clutter up my day-to-day calendar. I can also create is as a publicly-accessible calendar so my students can also access it in their own calendars without having to dig out their syllabus.

And that’s what I did for my class. After creating the calendar, I put all of my course dates into a CSV file which I created in Excel, and uploaded to the calendar.

On the left you can see my calendars.

“Sue Frantz” is my personal calendar that I sync with Outlook. To the right you can see my “Sue Frantz” calendar items are displayed in blue.

“Psych 100” is the public calendar I created for my course. The “Psych 100” calendar items are in blue-green. (The colors are customizable.)

The “Tasks” calendar is shut off.

“Verla & Sue” is the calendar I share with my partner.


Other calendars:

“” displays my reminders.

“Weather” gives me the weather forecast for the next few days.


Create a Google Calendar

Click the “Add” link to generate this page. Put in your calendar name (I called mine Psych 100). Include a description and location if you’d like.

Crucially important: Select your time zone. When we import all of your calendar data from the CSV file, if you haven’t selected a time zone, all of your times will be off by 5 hours or so.

Check the box next to “Make this calendar public.” Or, if you’d rather just share it with the students in your class, set the permissions to “See all event details” then copy and paste all of your students’ email addresses at once. (It doesn’t much matter to me if the greater internet public knows on what date I’m covering chapter 7. Besides, my syllabus is on my website.)

When you click “Create Calendar” at the top of the page, the page will disappear, and you’ll be returned to your main calendar page. If your new calendar isn’t there, count to five, and reload the page.

Now, just because you have a calendar doesn’t mean that anyone knows about it. Even the people you’ve given permission. Let’s do some tweaking and then get the URL to give to our students.

Click the down arrow next to your calendar. Select the color you’d like. Appearance is important.

Now select “Calendar settings.” On that page, scroll to the bottom to see this.

If you want to embed your calendar on a webpage, copy the html code, edit your webpage in html view, and paste the code where you want it the calendar to appear. A word of warning: Some browsers don’t allow iframes, so any visitor with such a restriction won’t see your calendar.

Alternatively, provide a link to your calendar. In the “Calendar Address” section, click “HTML” to get the URL.

This is what the public calendar looks like.

Clicking any of the events calls up more information about the event.


At the very bottom right of the calendar is this icon. For your students who have Google Calendar, clicking will add your class calendar to their calendars.

To see my Psych 100 calendar go to my Psych 100 webpage. The link to the calendar is under the syllabus information.


Create the CSV file

While you could click on each date and time to enter your calendar events, it would be tedious. Instead, we’re going to create a CSV file to upload to the calendar. It’s still a little work, but less tedious.

Open Excel (or any other spreadsheet program). Save the file as CSV file so the file has a .csv extension. For example, I opened Excel, went to “Save As,” typed in Psych100 and selected CSV from the dropdown menu.

Google Calendar allows no room for error. The calendar headings have to be written like this. The only two that you absolutely need though are Subject and Start Date. (To use as a template, download this CSV file here.)


Uploading the CSV file

When your file is ready, go to Google Calendar, and click the “Add” link under “Other Calendars.” Select “Import Calendar.”

Before you do anything else, change the calendar to the one you want to import to, in this case I was importing to the Psych 100 calendar. You do not want to accidentally upload to the wrong calendar. If you do, there is no way to reverse the import. You will have to delete each entry manually.

Browse to the location of the CSV file you’d like to import. Then click “Import.”


Make sure the time and date cells in the CSV file are formatted as time and date. (Right click on the cell, select “Format Cells,” then click on time or date and choose the appropriate formatting. In the template, the time is set to a ‘custom’ setting. That’s okay.)

If you upload the file and the events don’t display as you’d like, you have to remove them from Google calendar manually, one at a time. You may want to only put a couple events in your CSV file to start. If they show up okay, go ahead and enter the rest.

I chose to keep my Subject entries short. Those are what will appear on the calendar when you’re looking at the week or day view. If they’re long, they’ll be truncated.

If you delete events and then try to upload them again without making any changes to the entry, you’ll get an error saying that Google Calendar wasn’t able to upload a certain number of events. The easiest solution is to make a small change to each event in the Subject column. On the subsequent upload, Google Reader will interpret it as a brand new event and upload it.

If your course pretty much stays the same from term to term, for the next term all you need to do is change the dates.


Google Calendar bonus tip

You can add icons to your events. Here are how the icons appear with my calendar. Yellow icons for dates when assignments are due; red icons for exams.

And here’s how they appear when you follow the public link to the calendar.

To get the icons, from your Google Calendar page, look in the top right corner. Click on the green beaker to go to Google Labs.

Enable the one called “event flair.” Go back to your calendar. When you click on an event, the icon palette appears on the right. Select the appropriate icon. Remember, in public calendars, everyone who accesses the calendar can see the icon.

While you’re poking around in Google Labs for calendar gadgets, check out “year view,” “dim future repeating events,” “jump to date,” and “world clock.”


If you’ve read this entire post and don’t use Google Calendar yet. Consider it. It provides some nice flexibility. It certainly makes it easy to change the schedule at the term progresses. Of course you still need to let students know what the changes are, but you’ll know that everyone has the same information on their calendars.

November 12, 2010

A Little Reflection

Filed under: Uncategorized — Sue Frantz @ 9:52 am

I started writing this blog in April 2009, and I see that the blog recently passed the 10,000 views mark. That could mean that 10,000 individuals stopped by once and have never come back. It could mean that one person has been sitting at home clicking through my website, day after day after day. No, that’s not me. WordPress tells me that they don’t include my visits in their statistics.

I know that many people drop in because they’re searching for something specific, and Google sends them my way. I even know what they’re looking for; WordPress tells me. I have one post that accounts for 40% of the hits on my blog – 40%, that’s not a typo. It is the Smartboard Alternative post. If you haven’t read it, you’re apparently missing out on something. It’s probably the most magic-like technology that I’ve written about. It’s truly a phenomenal idea. You point a Wii remote at the wall, and using an infrared pen you click on the wall to control your computer. How is that not magical?

Here are the top 21 search terms used to find my blog. All of them point to that Smartboard post. All of them. All 1,100 of them.

I’m not sure what it means though. Is it something cool that people just want to try out? I know that must be true for some. Or are people using this in their classrooms? I have some friends who are. Given the cost of smartboards combined with decreasing educational budgets, I wouldn’t be surprised.

Visits to my homepage account for 20% of the hits on this blog. Those are my regulars, most likely including you, visiting my homepage to see what’s new. Thanks for stopping by! You’re who I have in mind when I write. Leave a comment every now and again. I love hearing from you!

The next two most popular blog posts are PowerPoint’s presenter view and using mailmerge to link Word and Excel. Together they account for 15% of hits, almost equally split between the two. I get that. I have no quarrels with Microsoft, but their help files don’t operate like I do. (In all fairness, lots of people may be searching for Microsoft Office solutions simply because so many people use Microsoft Office.) When I’m struggling for a solution, I toss my request to the search engine gods. I ask The Google (or The Bing, or The Yahoo – okay, rarely The Yahoo). Almost invariably I find my solution in someone’s blog or discussion board of some kind. They’re real people asking real questions and getting answers from real people.

And that’s why, 560 years after Gutenberg gave us the printing press, we still have teachers.

May 5, 2009

Flipping Typical: Preview Your Fonts

Filed under: Uncategorized — Sue Frantz @ 7:18 am

Looking for a new font for your syllabus? Tired of Times New Roman?

This is a practical and simple idea. The website Flipping Typical identifies 60 fonts on your computer and displays them all at once. Type in whatever you’d like to see and that text will be displayed in those fonts. Want to see it in bold or italics? Highlight the text, then CTRL-B for bold and CTRL-I for italics.

If you want to change the font at the top of the screen, either click on the font you want from the list below or click in the black box and type in the font of interest.

The site doesn’t bring in all of your fonts; I don’t know how it selects the ones it does. However, if you type a font you have in the black bar, it will add it to your default list. The next time you visit the site, that font will appear in your list of fonts.

Clicking “A-Z” on the far left of the black bar will order your fonts alphabetically.

And that’s all there is to it. Amazingly simple.

April 10, 2009


Filed under: Uncategorized — Sue Frantz @ 6:16 pm

Let me start with my ‘blog goal’ and a little bio.

I have a minor addiction to new technology.  But not just any technology.  I’m looking for technology (ideally, free) that either makes my job easier or makes it easier for my students to learn.

Yes, I have students. I started teaching college students in Kansas as a grad student back in 1989, and I’m still teaching college students, but now in the beautiful Pacific Northwest at Highline Community College.  If you’ve ever flown into Seattle, you’ve likely flown over my campus.

The tools I’ll be talking about aren’t always ones I’ve tried with my classes.  I don’t believe in using new technology just for the sake of using new technology.  It has to serve a pedagogical purpose.  But just because a tool doesn’t work for what I’m trying to accomplish doesn’t mean it’s not useful for someone else.  For example, psychology is my area, so I don’t have much need for math tools that can handle calculus, but when I come across such tools, I’ll be sure to fill you in.

Some of the technologies I’ll discuss are well-established tools.  Others are hot off the press; so hot, that they may still be in beta testing.  Although, keep in mind that Google Docs and Gmail are both, technically, still in beta testing.   ‘Beta testing’ has more meaning in some circles than others.

Your comments are most welcome!  If you’ve tried some of the technologies mentioned in this blog, let me know how they worked for you.  If you’re trying to solve a particular pedagogical issue and are having trouble finding the right tool, let me know.  If you come across a new tool that you think should get an airing here, let me know.

With that as a quick introduction, let’s get to the content!

Blog at

%d bloggers like this: