5:03 p.m.
Hello all,
If you are interested in a handy spreadsheet that calculates the electives for you, please
check out the attached sheet. It calculates the elective hours needed for that student at
that point in time. You do not have to use it, it's only if you want to. I tested it
under different scenarios and I believe I have it working properly, however, if you notice
that it doesn't work in the case of a particular situation, please let me know. I
know the instructions are very wordy, but I was trying to be detailed and comprehensive
and are only needed in case you aren't sure what to enter in a particular place.
Example below.
1. I've added a button that clears that resets the spreadsheet with just a push.
In order to this, you will need to enable the macros.
2. Enter in the minimum number of hours the student still needs to reach 120 hours.
3. Add up the hours needed for core, major, minor and/or concentration and enter that
number. (Total number of required hours.)
4. This is the total number of free electives needed, auto calculating hours to 120
minus hours required. If they are at 120 hours or their hours required for core/major
exceeds the hours needed to reach 120, the number will be zero.
5. Enter in the minimum number of hours needed to reach 39 upper-division hours.
6. Add up the total number of upper-division hours the student still needs (anything
in red that is not in progress) and enter that number.
7. This is the total number of upper-division free electives needed, auto calculating
hours to 39 UD minus required UD. If they are at 39 UD or their hours required for major
exceeds the hours needed to reach 39 UD, the number will be zero.
8. This is the number of free electives that can be lower- or upper-division. This
number is automatically calculated by taking number of free elective hours needed to reach
120 and subtracting the upper-division free electives needed. If all the required free
electives need to be upper-division, this number will be zero.
9. To reset the data, click on the Reset button.
[cid:image004.png@01D58B2B.BD3417A0][cid:image009.png@01D58B2B.BD3417A0][8][cid:image012.png@01D58B2B.BD3417A0][7][cid:image012.png@01D58B2B.BD3417A0][cid:image019.png@01D58B2B.BD3417A0][6][cid:image012.png@01D58B2B.BD3417A0][cid:image028.png@01D58B2B.BD3417A0][3][5][cid:image012.png@01D58B2B.BD3417A0][3][2][cid:image009.png@01D58B2B.BD3417A0][cid:image047.png@01D58B2B.BD3417A0][4][cid:image050.png@01D58B2B.BD3417A0][cid:image038.png@01D58D80.6B7D6D10][cid:image028.png@01D58B2B.BD3417A0][cid:image053.png@01D58B2B.BD3417A0][cid:image054.png@01D58B2B.BD3417A0][cid:image040.png@01D58D80.6B7D6D10][cid:image062.jpg@01D58B2B.BD3417A0]
Example DW:
[cid:image042.png@01D58D80.6B7D6D10][cid:image067.png@01D58B2B.BD3417A0][cid:image068.png@01D58B2B.BD3417A0][cid:image044.png@01D58D80.6B7D6D10][cid:image037.png@01D58A8E.69B2EAE0]
[cid:image046.png@01D58D80.6B7D6D10][cid:image057.png@01D58D80.6B7D6D10][cid:image075.png@01D58B2B.BD3417A0][cid:image076.png@01D58B2B.BD3417A0][cid:image077.png@01D58B2B.BD3417A0][cid:image059.png@01D58D80.6B7D6D10][cid:image080.png@01D58B2B.BD3417A0][cid:image080.png@01D58B2B.BD3417A0][cid:image080.png@01D58B2B.BD3417A0][cid:image080.png@01D58B2B.BD3417A0][cid:image081.jpg@01D58B2B.BD3417A0]
If you have any questions, send me an email at
Amanda.Garcia@utsa.edu<mailto:Amanda.Garcia@utsa.edu>. [Imagine fun emojis here.]
Regards,
Amanda Garcia
Program Coordinator
Advising Administration
University of Texas at San Antonio
210-458-6519
