- Joined
- Oct 28, 2006
- Messages
- 33
- Reaction score
- 0
Hello everyone!
I've gotten tired of searching around for a convenient way to calculate and keep track of my science GPA each semester, so I made up a spreadsheet and thought I'd share. It's nothing fancy, but I've entered some formulas so you can just type the course name, # of credit hours, and your letter grade. I did the plus/minus system with the normal A 4.0, A- 3.67, B+ 3.33, etc. Just enter the grade as "A", "A-", "B",....I've assigned numerical values to go with these letter/symbol combinations that are typed into that column. I put a few sample courses in to show how it works.
Okay, how to use it:
1. Enter in all of your courses with the information mentioned above in the first three columns. Don't edit anything in the other columns or you'll mess up the functions I've set up.
2. You'll see "#N/A" in all of the rows that do not have information. This will also appear in the Total GPA section. Ignore it until you've entered all your courses, then you can delete all of the rows which contain no courses. After you clear those, your calculated GPA should appear at the bottom. I've allowed space for 33 courses (I think). If you've taken more than 33 BCP courses, then I'm assuming you're smart enough to edit the file to fit your additional courses. 😀
3. When you want to add additional courses later (to the rows left blank), just copy/paste and entire existing row into the rows that you want to enter info. This will copy the functions you need into the new rows. Just edit over any course/grades that were copied into the rows and it will update the GPA with every change!
Hope this helps some of you. 🙂
I've gotten tired of searching around for a convenient way to calculate and keep track of my science GPA each semester, so I made up a spreadsheet and thought I'd share. It's nothing fancy, but I've entered some formulas so you can just type the course name, # of credit hours, and your letter grade. I did the plus/minus system with the normal A 4.0, A- 3.67, B+ 3.33, etc. Just enter the grade as "A", "A-", "B",....I've assigned numerical values to go with these letter/symbol combinations that are typed into that column. I put a few sample courses in to show how it works.
Okay, how to use it:
1. Enter in all of your courses with the information mentioned above in the first three columns. Don't edit anything in the other columns or you'll mess up the functions I've set up.
2. You'll see "#N/A" in all of the rows that do not have information. This will also appear in the Total GPA section. Ignore it until you've entered all your courses, then you can delete all of the rows which contain no courses. After you clear those, your calculated GPA should appear at the bottom. I've allowed space for 33 courses (I think). If you've taken more than 33 BCP courses, then I'm assuming you're smart enough to edit the file to fit your additional courses. 😀
3. When you want to add additional courses later (to the rows left blank), just copy/paste and entire existing row into the rows that you want to enter info. This will copy the functions you need into the new rows. Just edit over any course/grades that were copied into the rows and it will update the GPA with every change!
Hope this helps some of you. 🙂
