It is recommended to take it off directly to the end.

Today's notice in the class group: students applying for the experimental class need to report their GPA to the League Secretary.

The experimental class is a small class. There are only 30 students in one class. The teacher is also very powerful. Not only that, but the atmosphere must be different

At the beginning of the freshman semester, I had the opportunity to register for the experimental class. It was said that we interviewed our teachers. It was very good. Some GPA3.0 or so were enrolled. At that time, I was GPA3.63, but I was afraid that I would not report if I failed to report!

So that, in the first semester of sophomore year, Data Structure spent more than half of the semester in the experimental class (our teachers talked too fast), causing a great burden.

This time I had a chance, but the exam of last semester was not ideal. I don't know whether I can succeed this time, but I don't care! Apply first.

Next is how to use excel tables to quickly calculate the average GPA.

The GPA formula is as follows: credits of each subject * sum of grade points/sum of credits of all subjects

Here we need this function: sumproduce ， sum It means summation, product Is quadrature. When combined, it is the sum of the products.

First, copy the score of the educational administration network directly to the excel form.

1.png

2.png

As shown in the above figure, the score column G3-G28 and the score column H3-H28

Sum of credit points of each subject The formula is: SUMPRODUCT(G3:G28, H3:H28)
Total credits of all subjects The formula is: SUM(G3:G28)

The final formula is: =SUMPRODUCT(G3:G28, H3:H28)/SUM(G3:G28)

The final result is:

The first semester of freshman year 3.63
The second semester of freshman year 3.64
The third semester of freshman year 2.78
The first semester of sophomore year 3.24
The second semester of sophomore year 3.38
The third semester of sophomore year 3.55
The first semester of junior year 3.36

Comprehensive (all) 3.44

Don't ask me why my GPA is so low in the third semester of my freshman year, because it was in primary school! In primary school, when it was the hottest time in summer, there were only two courses, a total of more than 10 days. Most of us didn't care to attend classes, which led to Multicore programming What a mess!!!

A painful lesson

I can write so many words with such a simple formula!

semester school year credit Grade point Course name achievement Course nature
two 2015-2016 three four Data Structure and Algorithm (I) ninety-one Major Compulsory
two 2015-2016 four three point three three College English B eighty-two Public Foundation Compulsory
two 2015-2016 six three point six seven Advanced Mathematics (II) eighty-five Public Foundation Compulsory
two 2015-2016 two point five four Discrete Mathematics (I) ninety-two Major Compulsory
two 2015-2016 one three point three three Metalworking Practice B+ Practice Compulsory
two 2015-2016 three three point six seven Ideological and Moral Cultivation and Fundamentals of Law eighty-six Public Foundation Compulsory
two 2015-2016 one point five four General Physics Experiment (I) A Public Foundation Compulsory
two 2015-2016 four three point three three General Physics (I) eighty-four Public Foundation Compulsory
three 2015-2016 two two point three three Multicore programming C+ Major Elective
three 2015-2016 one three point six seven Program Design Training A- Practice Compulsory
one 2015-2016 four four Fundamentals of Programming A Major Compulsory
one 2015-2016 two two point six seven Introduction to Computer Science B- Major Compulsory
one 2015-2016 four three point three three College English C eighty-three Public Foundation Compulsory
one 2015-2016 three point five four linear algebra ninety-three Public Foundation Compulsory
one 2015-2016 six four point three three Advanced Mathematics (I) ninety-six Public Foundation Compulsory
one 2015-2016 two two point six seven Outline of Modern Chinese History seventy-six Public Foundation Compulsory
one 2015-2016 one two point three three Military theory seventy-two Public Foundation Compulsory
one 2015-2016 one three military training B Practice Compulsory
two 2016-2017 three point five four point three three Operating system principle ninety-five Major Compulsory
two 2016-2017 three point five two point six seven digital logic seventy-six Major Compulsory
two 2016-2017 two point five three point three three Number Theory and Combinatorics B+ Major Elective
two 2016-2017 three point five three point six seven Probability Theory and Mathematical Statistics eighty-eight Public Foundation Compulsory
two 2016-2017 two four computing method A Major Elective
two 2016-2017 six three point six seven Introduction to Mao Zedong Thought and Socialism with Chinese Characteristics eighty-five Public Foundation Compulsory
two 2016-2017 two one Situation and policy qualified Public Foundation Compulsory
three 2016-2017 two three point three three Cognition Practice B+ Practice Compulsory
three 2016-2017 one four Course Design of Operating System Principles A Practice Compulsory
one 2016-2017 one four Course Design of Data Structure A Practice Compulsory
one 2016-2017 two point five four Data Structure and Algorithm (II) ninety-four Major Compulsory
one 2016-2017 four three Circuit and Electronic Technology eighty-one Major Compulsory
one 2016-2017 four three point three three College English A eighty-four Public Foundation Compulsory
one 2016-2017 two point five three point three three Discrete Mathematics (II) eighty-three Major Compulsory
one 2016-2017 three three Basic Principles of Marxism seventy-eight Public Foundation Compulsory
one 2016-2017 one point five three point six seven General Physics Experiment (II) A- Public Foundation Compulsory
one 2016-2017 four two point six seven General Physics (II) seventy-five Public Foundation Compulsory
one 2017-2018 two point five three point six seven Fundamentals of Linux and Unix Programming eighty-seven Major Elective
one 2017-2018 two point five three point six seven Object-oriented programming A- Major Elective
one 2017-2018 two point five four Java Programming A Major Elective
one 2017-2018 three point five three Compilation Principle eighty Major Compulsory
one 2017-2018 four point five three Principles of Computer Composition eighty Major Compulsory
one 2017-2018 three point five three point six seven Database Principle eighty-six Major Compulsory
one 2017-2018 one three point six seven Course Design of Database Principles A- Practice Compulsory
one 2017-2018 one three Course Design of Principles of Computer Composition B Practice Compulsory
one 2017-2018 three three point six seven Mobile Internet technology A- Major Elective
one 2017-2018 two two point three three computer graphics C+ Major Elective
one 2017-2018 two three point three three Data Warehouse and Data Mining eighty-four Major Elective
Last modification: February 27, 2018
© Allow specification reprint
Do you like my article?
Don't forget to praise or appreciate, let me know that you accompany me on the way of creation.