Updated GPA calculator - Cumulative, Science, Non-science, by year, by semester, etc.

[bwells46]

Since I'm such an Excel junkie, here's an updated GPA calculator.

It calculates:

• Cumulative GPA
• Science GPA
• Non-Science GPA
• GPA by Academic Year
• GPA by Academic Semester
• GPA by Academic Year and Semester

The calculations are based on the courses you enter in the spreadsheet.

If you have any questions, check the "Key for Use". If the answer is not in there, let me know.

If you would like to see additional features, let me know that as well 🙂

Enjoy!

---

Members don't see this ad.

 

[Mike MacKinnon]

Very Nice, thank you!

Since I'm such an Excel junkie, here's an updated GPA calculator.

It calculates:

• Cumulative GPA
• Science GPA
• Non-Science GPA
• GPA by Academic Year
• GPA by Academic Semester
• GPA by Academic Year and Semester

The calulations are based on the courses you enter in the spreadsheet.

If you have any questions, check the "Key for Use". If the answer is not in there, let me know.

If you would like to see additional features, let me know that as well 🙂

Enjoy!

 

[Sundarban1]

Since I'm such an Excel junkie, here's an updated GPA calculator.

It calculates:

• Cumulative GPA
• Science GPA
• Non-Science GPA
• GPA by Academic Year
• GPA by Academic Semester
• GPA by Academic Year and Semester

The calulations are based on the courses you enter in the spreadsheet.

If you have any questions, check the "Key for Use". If the answer is not in there, let me know.

If you would like to see additional features, let me know that as well 🙂

Enjoy!

Thanks!

I downloaded the last version, for some reason this version is not working. Maybe its the computer not unziping the file. Oh well.

 

[bwells46]

Thanks!

I downloaded the last version, for some reason this version is not working. Maybe its the computer not unziping the file. Oh well.

If the link isn't working for you and you would like the file, PM you email address to me and I'll send it to you.

 

[byeh2004]

ill sticky this 👍

 

[mshheaddoc]

I am not worthy *bows*





Thanks! 😉

 

[bwells46]

I am not worthy *bows*

Dam it feels good to be a gangster

j/k - I'm glad you like it!

 

[gujuDoc]

quick question, this does take into account math courses as a science right???

 

[bwells46]

quick question, this does take into account math courses as a science right???

Sure. All you have to do is type science in under course classification. I didn't build any ability into the spreadsheet for it to dynamically classify courses.

Also, right now the only classifications that it recognizes are Science and Non-Science. If you choose to type something different, for example History, then it will not calculate the correct GPA.

 

[DrBowtie]

Bwells, Excel master, Can you vary the widths as you go down the column? Or must you merge/unmerge cells to accomplish this? Example would be two tables underneath one another.

 

[bwells46]

Bwells, Excel master, Can you vary the widths as you go down the column? Or must you merge/unmerge cells to accomplish this? Example would be two tables underneath one another.

I'm not sure I understand the question. Do you mean vary the row widths as you go down a column or the individual cell widths?

If it's the cell widths, you could do it with a VB macro. However, it would probably be much faster to do it manually unless this is something you're doing over and over again.

 

[DrBowtie]

I mean like column 1 for the first table needs to be 10 width. The table two width needs to be 5. If you use the mouse and adjust left or right it modifies the whole row.
Basically can I make cell A1 10 width and A2 5 width?

 

[Phil Anthropist]

Nice Job!

If you would like to see additional features, let me know that as well 🙂

There is one thing that I'd like to mention. I took a look at your reference...

Grade	Value
A	4
B+	3.5
B	3
C+	2.5
C	2
D+	1.5
D	1
E	0

and noted it goes by half steps.

Most schools go by the half-step or plus/minus grading systems (or variations of these systems).

Depending on the grading system of a person's school, some of these values might need to be changed.

For example, if a student's school uses the following grading system:
A, A-, B+, B, B-, etc.
The corresponding grades would be:
4.0, 3.7, 3.3, 3.0, 2.7, etc. by AMCAS calculations and the program would need to be altered to reflect the changes.

If a person's school utilizes half-step grading, then your program works perfectly.

I'm not particularly skilled at Excel...would it be possible to make a similar GPA calculator for those using plus/minus grading systems?

Again, well done. 👍 I'll try and get around to sticking this in the useful applicant links thread along with your application progress program.

 

[bwells46]

Yeah, it would be very easy to add a +/- reference. I used the half-step since that's what my university uses. However, I did make a note in the "Key for Use" saying that if your school didn't use the + system, then it won't calculate the right GPA for you.

I'll look at adding the +/- system and have a page where the user can choose which grading system to use.

I'm not familiar with the +/- system so can you write the values out for me? For example, you listed B- as 2.7 so what's a C+, C, C-, etc.? Is it C+ = 2.3, C = 2.0, C- = 1.7, D+ = 1.3, D = 1, D- = 0.7, E+ = 0.3, E =0?

Thanks for the suggestion!

 

[ltrain]

I mean like column 1 for the first table needs to be 10 width. The table two width needs to be 5. If you use the mouse and adjust left or right it modifies the whole row.
Basically can I make cell A1 10 width and A2 5 width?

nope...can't do this...all cells in a column must be the same width.

 

[DrBowtie]

I did figure out that if you make A and B both 5. Then merge A and B you can have the effect. It makes the one 10 and the other 5.

 

[hnbui]

Yeah, it would be very easy to add a +/- reference. I used the half-step since that's what my university uses. However, I did make a note in the "Key for Use" saying that if your school didn't use the + system, then it won't calculate the right GPA for you.

I'll look at adding the +/- system and have a page where the user can choose which grading system to use.

I'm not familiar with the +/- system so can you write the values out for me? For example, you listed B- as 2.7 so what's a C+, C, C-, etc.? Is it C+ = 2.3, C = 2.0, C- = 1.7, D+ = 1.3, D = 1, D- = 0.7, E+ = 0.3, E =0?

Thanks for the suggestion!

A= 4.0
A-= 3.7
B+= 3.3
B= 3
B-= 2.7
C+= 2.3
C= 2.0
C-= 1.7
D+= 1.3
D= 1
D-= .7
F= 0

hth

also, when i try inserting a row it doesn't calculuate the grade points in the G column. I mean am i inserting the row correctly? I go to the insert tab and then row. Should i insert the rows after all the filled rows or should i try to insert a row inbetween? I've tried it both way and it doesn't seem to be working for me....
🙁 🙁

 

[Sundarban1]

Its a great idea, however Its not working for me either. Each time I try to enter a class that is not previously listed, the spreadsheet goes wild. If I enter a b-, or try to change the class names that are not in the lookup field, it does not work.

Great start though!

 

[bwells46]

Its a great idea, however Its not working for me either. Each time I try to enter a class that is not previously listed, the spreadsheet goes wild. If I enter a b-, or try to change the class names that are not in the lookup field, it does not work.

Great start though!

You have to drag and copy the cells in the grade points column for any new rows you add. I'll look into adding a function so that you don't have to do this.

After this, it should work fine. I'll try it myself and make sure it's not a bug.

The spreadsheet isn't setup to accept - grades right now. That's the next feature I'll add.

 

[gujuDoc]

You have to drag and copy the cells in the grade points column for any new rows you add. I'll look into adding a function so that you don't have to do this.

After this, it should work fine. I'll try it myself and make sure it's not a bug.

The spreadsheet isn't setup to accept - grades right now. That's the next feature I'll add.

Hey, so you'll be able to fix it so that it can accept both +/- grades and also on the 3.3, 3.7, 2.3, 2.7 scale right?????// Oh and Math classes like Stats and Calculus are taken into account for BCPM right??????

If you could do that and update us, I'd be your bestest bestest friend in the world. Cuz that would be perfect. 😍

 

[bwells46]

Hey, so you'll be able to fix it so that it can accept both +/- grades and also on the 3.3, 3.7, 2.3, 2.7 scale right?????// Oh and Math classes like Stats and Calculus are taken into account for BCPM right??????

If you could do that and update us, I'd be your bestest bestest friend in the world. Cuz that would be perfect. 😍

Yeah, I'll add in the +/- grade functionality.

I don't have a way to dynamically classify courses so whatever you tell the program is a science course, it will factor that into your science GPA. The same goes for non-science courses.

Once I finish adding this, I'll post the new program and a more detailed user guide.

 

[hnbui]

Yeah, I'll add in the +/- grade functionality.

I don't have a way to dynamically classify courses so whatever you tell the program is a science course, it will factor that into your GPA.

Once I finish adding this, I'll post the new program and a more detailed user guide.

thanks man 👍

 

[gujuDoc]

YAY, you are my new bestest friend. Thanks a bunch for your help. I owe you big time.

 

[bwells46]

YAY, you are my new bestest friend. Thanks a bunch for your help. I owe you big time.

Not a problem 🙂

I'll post the new program when it's done.

 

[bwells46]

Here's the new program:

http://forums.studentdoctor.net/showthread.php?t=215314

 

[Noway]

nice work!