Online course history/planning

Communication online course history/planner tool

This Google Sheet includes online courses offered during the past three years.  It should provide some insight into what to expect to see on future schedules.  To maximize your use of the planner, you may wish to filter the data.  A tutorial for filtering the planner is in included below.

Planner details:

  • The planner includes two tabs.  The first tab lists only online COM courses.  The second tab includes online General Education and ECCE options as well as online elective options.  The courses included on the second tab are limited so that you see the courses that are the most likely options for COM majors. It does not include courses with substantial prerequisites, that most COM majors would lack, or courses that are typically restricted to online majors in other programs.
  • The first tab notes whether the COM courses are a core requirement, a media elective, an interpersonal/organizational elective, or an open elective (can count as either of the two elective types.) . The second tab notes categories for General Education and ECCE.
  • Lower-division (100- and 200-level) courses are highlighted.  Remember: you can include as many as 72 hours of lower-division credit in your 120 hour degree so you should avoid the lower-division hours UNLESS you have fewer than 72 lower-division, or you need to complete a General Education requirement.

How to filter Google Sheets

Click on the course history/planner link to access the Google sheet.  You do not need to filter the course history/planner, but filtering the data may help you focus on the details more effectively.

Look for the filter icon (it looks like a funnel) in the top-left hand corner.  Click the icon and select “create temporary filter view” from the drop-down menu.

Image shows the Google Sheet of online communication courses. It highlights the position of the "filter data" icon.


When you create the filter view, you will see a lined-triangle icon next to the heading of each column. Click on one of these heading icons to access the filter options for that column.


Image shows the Google Sheet of online communication courses. It highlights individual filter icon in the header of each of the data columns.

Click on “Sort A-Z” to sort the column alphabetically.

Look further down, and you will see a listing of every value for that column.  In this example, the column is noting which courses were offered for the fall 2016 semester.  Courses that were offered are noted with an “X” and courses that weren’t offered are not, so this list includes “blanks” and “x”. Currently, the sheet is displaying all courses, so there is a checkmark next to each of the entry types, to indicate that the sheet is displaying that data.  If you want to remove the blanks, so that the sheet only displays courses that were offered, click on the checkmark next to “blanks” to remove it, and then click the OK button.


Image shows the Google Sheet of online communication courses. It displays the filter options menu, which you access by clicking on the filter icon in the header of a data column.


Here, you see the sheet displaying only the courses that were offered for the fall 2016 semester.  You can also see that the lined-triangle icon of the FL 16 column has turned into black funnel icon, to indicate that this column has been filtered.  If you want to see the full list of courses again, you must click on the black funnel icon to access the filter options menu and either return the checkmark next to “blanks” or click the “select all” link, which selects all values for that column.


Image shows the Google Sheet of online communication courses. It shows what happens if you filter the sheet to show fall 2017 courses. This results in the sheet displaying 4 fall 2017 courses and hiding every course that was not offered that semester.