Calendar Resources

Fun with Google Calendars

Note: I have created calendar data for SY20-21 but have not posted it. If you're interested, let me know and I am happy to share!

Note: Excel calendar files posted here were last updated on September 3, 2019. We ALWAYS recommend checking the AHS Official Bell Schedule for changes. If you see any errors with my Excel files, please let me know so I can fix them!

Have I told you how much I love Google Calendar? So much. Google Calendar allows users to import data from spreadsheets. So what? You can magically add every class to your own calendar(s) in just a few clicks with an already-formatted data file provided by me, your friendly school librarian.

Option One: Generic Google Calendar

• Generic Calendar Data for SY19-20 (CSV)

This spreadsheet is a generic schedule for the year. Just download the file to your computer, and upload to a calendar of your choosing. This two-minute video shows you how:

• How to Upload Calendar Data [recorded 9/5/13; not updated for recent Calendar changes but basically the same idea; let me know if you'd like to see an updated video]

Option Two: Customized Google Calendar

• Custom Calendar Data for SY19-20 (Excel)

This version is meant to be customized with YOUR schedule. Detailed directions are given on the first page but basically you type your schedule into the grid, save the next tab in CSV format, then upload to your calendar using the same process as in the screencast above. See, magic.

Warning: Calendar imports CANNOT be undone, except by manually deleting EVERY SINGLE event, so if you're not sure what you're doing PLEASE experiment on a disposable test calendar or ask for help! It can be useful to create a new blank calendar before beginning so that your class schedule and personal calendar are kept separate, regardless.

Feeling hardcore? Check out Google's help page on CSV requirements.

Weekly Schedule Wall Calendar

Ever wanted to make your own of the weekly schedule flip calendar we have at the library's front desk? Now's your chance.

• • Weekly Wall Schedule (PowerPoint) [updated 9/3/19]

Ours is made of page protectors, loose-leaf rings, and a bull clip. Pro tip, there's a piece of cardboard from the back of a memo pad slid in with the first page so the corners don't flop down when you hang it on the wall. You're welcome.