If you missed last month’s post on our new College Counseling Cheatsheet, read more here to catch up.

In spending much of the past several years working with college counselors, the idea here is to share some “best practices” gleaned from many sources. As such, I am sharing here a “cheatsheet,” a daily 30-minute activity, reminder, or provocation for college counselors about something they might do today that you can integrate into your work calendar. The format is a CSV file, which you can easily upload into your own Google (or other) calendar, so that you can see right there in your calendar an idea for something you might do today.

After August’s test-run, we’ve made some adjustments for September based upon your feedback, which includes only providing activities during weekdays, leaving you alone on weekends.

Here’s the file for September. Try it out, and give me some feedback! Did I miss anything? Do you have any good ideas to share? Any thoughts? See below for instructions on how to proceed!

——————————

Here’s how to make this work…

1. Download the CSV file for this month to your computer. (For this year, I will make a monthly file and post it here around the middle of the previous month, ideally. In the future, if this works for people, I’ll create one annual file as well.)

2. Open your Google Calendar and create a new Calendar by clicking the + next to “Other Calendars." (At this stage, I have searched online and found that there are parallel processes to import a CSV file into other calendars, such as iCal and Outlook; I’m choosing just to focus on Google here, though!)

3. Select “Create New Calendar” from the options provided.

4. On the subsequent page, name the calendar, provide a description, adjust for your time zone, and select “create calendar.” [There will be monthly uploads — this year — for the cheatsheet, so once you create this calendar once, you will not have to do it again as you can just import the downloads monthly to this calendar, which is a better idea than uploading them directly into your calendar, as we’ll show you later. Also, the items are all scheduled for 7-7:30am, but you can move them later.]

5. Now navigate back to your Google Calendar, and you will see your “Cheatsheet” calendar in the right-hand navigation bar. If you scroll-over it, you will see three dots to the right of it, which, when selected, will reveal a menu. Select “Settings and sharing.”

6. The next page you see will have “Cheatsheet” selected, but you need to move up to the “Import & export” option and select “Import.” Then choose the CSV file you previously downloaded and then be sure to select the proper “Cheatsheet” calendar in the “Add to calendar” section. This is important! Choose the correct calendar into which you want this file’s contents imported! Then, when you have the correct settings, select “Import.”

7. You should see a pop-up window appear with the total number of imported activities. Now, when you navigate back to your Google Calendar, you will see the items for the current month appear on your calendar. (Sometimes you may have to wait a few minutes for the imported items to appear; be patient.) When they do appear and you select an item, you will see a title and a description to explain that day’s task, and you may also see a link. Now, each item is scheduled for 7-:7:30am because that is most likely when I will attend to that task. I am a huge proponent of timeboxing, and so I will break my day up into tasks that need to get done around my scheduled appointments, so if 7-7:30am does not work, I will move the item to a time later in the day. (Just drag-and-drop it to free time!) Another tip here is that if you right-click on any item, you will see a window appear, and at the top of that window, you will see three dots. If you select the three dots, you can copy this item to your main calendar. This works well if you use scheduling software, as this process will make sure you are blocked off to do this work. And you can also drag the item to different times throughout your day to suit your needs and to accommodate your schedule. Put differently, if it isn’t blocked off on your calendar, then it won’t get done!

I also scheduled each item 7-7:30am because that is before my work day begins. Personally, on a weekly basis, typically on Sunday evenings, I’ll take a few minutes to look ahead at my schedule for the week and block off times to do the essential work of the coming week. For these cheatsheet items, all I have to do it add them to my calendar and then move them to where I want them in my days!

Of course, I created these items based on my own school’s schedule and practices, so you can always move items to different days to suit you and your purposes. For example, some of you might outsource your School Profile, so the dates I provide might be too early or too late for your needs. In this case, simply move this task to an appropriate day or time!

In the end, I hope these are helpful to others! However, as I mentioned before, I welcome feedback, especially in regards to things that don’t work, things that might be improved upon, and ideas that I haven’t included. Let me know your thoughts!