This post contains the basics of what you need to use this.
To get started, you need to start on the course list page. The process is as follows:
- Filling in the courses and their information
- Configuring how to calculate the totals
- Planning the sequence
Filling in Course Information
You will need to create a list of courses as required by your program so that they can be used in this sequence. For each course, you’ll need the following pieces of information:
- Course code: The shorthand representation of the course
- Course name: What the course is called
- Course type: Labels if the course is compulsory or an elective. In the template, I have the codes ‘C’ for compulsory and ‘E’ for elective.
- Credits: How many credits are being earned for completing the course successfully.
- Status: Indicates if the course has been completed or is ongoing. In the template, I have ‘C’ for completed and ‘O’ for ongoing.
This is probably the most time-consuming part that you have to do but once you are done, the rest will be easy.
Configuring the totals
Given the information you have placed onto your course list, now is the time to determine your totals.
In the ‘Totals’ window, I’ve created a default template for you but you can and may need to adjust the categories to better reflect your requirements.
The totals requires nothing more than the =SUM() and =SUMIFS() functions. Here’s how to use it:
Begin with the =SUMIFS() function. This function adds cells if they meet a certain condition. For this eaxmple, I’ll show you how to add the total compulsory credits necessary to complete the major. Here are the steps:
Select the cell you want to edit and type in “=SUMIFS(”
You’ll need 3 criteria to fill in: sum_range, criteria_range and criteria.
Your sum_range is what will be added. In this case, you highlight the cells under the “credits column”.
Then you’ll need the column that the previous column will be compared to. That will be the column titled as “Credit type” (it is beside the credits column on the left).
Finally, you’ll need the criteria. This defines the condition that determines whether or not a cell is included in the sum. In this case, you would only want to include the compulsory courses, so type in “C”.
Your end result should be something like this:
Hit enter and your total should show up. Repeat the process for the other totals until it is complete.
For the totals in bold, you simply need the =SUM() function and add the necessary rows. Here’s an example of me added the credits earned below:
Here the earned credits cells are defined as Q3 and Q4, so I simply input it as such.
A quick way to specify which cells you would like to add is to click on a cell to edit, type in “=SUM(“ or “=SUMIFS(” and then click on a cell and drag your mouse up or down the column. You can also use the function search feature, look up the functions and then fill in the blanks.
Planning the Sequence
Once you have your course list set up, the next part is easy. Go to your course sequence page and follow the instructions here.
Click on the course code cell that you want to edit. You’ll notice an arrow which indicates a drop down menu.
Click on the arrow and then menu pops out. Select the course code that you would like to input.
Upon selecting the course code, the name of the course should automatically appear beside it.
Repeat this process until you have completed your sequence.
You also have a notes section where you can write down additional information that you need to know.
You are now done!
That is just the basics however. If the default template is insufficient, you are encouraged to customize it however you wish.
I wish you luck on your educational career and hope you find this useful. You can post questions and comments below!