In my last blog post, we dealt on how to create a simple list using Microsoft Excel. We learnt how to identify the ranges of cells. We were able to differentiate rows from columns. In this blog post, we shall be learning how to use the table we created to create an automated continuous assessment table.
A common continuous assessment table will have the following features as shown in the image below
[img]http://3.bp..com/-faVElwNoBbI/WBsdBUJgLvI/AAAAAAAAEHU/YLtJU5qMAB8NlNaleG384w1GHcpeveDVACLcB/s640/continuous.png[/img]

As you can see, I added extra columns to the table we created in my previous post. So you have to adjust your table to look like mine mine by adding Assignment , Test, Exam, Total, Grade columns to your table. Also, create the second table on the right with headings From and To.
While I wait for you to add the extra columns, I will fill in the names, ages and gender as shown in the picture below

[img]http://3.bp..com/-vgv7o2x1Mhs/WBshSGNZFcI/AAAAAAAAEHg/Ya64ym3JfrciBpxt9rpIOI7m4fD23ADewCLcB/s640/continuous.png[/img]

Here comes the sweetest part . As you know, the Total is the addition of the Assignment, Test and Exam. So we would want a situation where the total score is automatically displayed once the values for assignment,test and exam have been entered. For example, I want the value under Total to display 40 if the values under Assignment ,Test and Exam are 10, 18 and 12 respectively. Got it? This will surely save us the time and stress of having to punch our calculator each time we want to fill in the total scores.
To achieve this, we will have to give excel a simple instruction. Let Us take Amaka as an example.
I would like to display Amaka's total score in cell G2 by summing up the values in D2, E2 and F2 as illustrated in the table below.
[img]http://2.bp..com/-TtjCUlR5jNA/WBsw_1NUUgI/AAAAAAAAEHw/kb5gs-_w02UROHGg-h7AiG7odhCr_DkMwCLcB/s640/continuous.png[/img]

So to display the total in cell G2, simply click on cell G2 and type without spaces =D2+E2+F2 and hit the enter button.
[img]http://3.bp..com/-Tm5TNlfmQbs/WBs4SCjOAhI/AAAAAAAAEIE/jx-qOTnRh30_C93Bu4dHTOyYfsF3zjfwwCLcB/s640/continuous.png[/img]
Viola! You'll have your answer as displayed in the image below!
[img]http://1.bp..com/-pZ4JNtd2270/WBs6gozBSII/AAAAAAAAEIQ/bDAoRgLT9ug5m4VZI-hzn0K95DKTglvXgCLcB/s640/continuous.png[/img]

=sum(D2:F2)
Isnt this way shorter?

If we have to do that of Jane, we shall be entering in cell G3 without spaces =D3+E3+F3 and then hitting the enter button. But then we may have a long list that entering the formulas into their corresponding cells may be strenuous. To avoid this, we simply place our cursor on the bottom-right corner of cell G2, then hold down your left-click button and drag down to cell G13 . See image below. Alternatively, instead of holding down the button, we simply double click.

[img]http://3.bp..com/-rgonTZ9TRgE/WBtTHeNuuEI/AAAAAAAAEIg/XzYqF9f-oTkW7V463jhwQYz1N44ZoQkPQCLcB/s640/continuous.png[/img]
Now fill in the assignment, test and exam cells and you'll see the Total automatically update!

In my next blog post, we shall be displaying the students' grade on column H. This column will tell us when a student's score is an A, B, C, D, E or an F automatically. This can be achieved by using the IF STATEMENTS. When you learn the IF STATEMENTS properly, you can call yourself a programmer
Follow me on https://www./profile/christian-nwodo to keep tab on my updates

WATCH VIDEO BELOW


https://www.youtube.com/watch?v=9dlkYQjKPi4

StepTwo:
=sum(D2:F2)

Isnt this way shorter?

Very good. It is shorter but then , it doesn't explain the arithmetic behind the formula ....

Will introduce it when we have a larger table

Lalasticlala seun can I get a FP?

emymeeky:

Very good. It is shorter but then , it doesn't explain the arithmetic behind the formula ....

Will introduce it when we have a larger table

d explanation is urs to do.

StepTwo:


d explanation is urs to do.

And I'll be doing just that

so so wonderful. God bless

Thanks for reading

keep it up bro. pls I didn't get d Content in d column FROM AND TO and its relevance. thanks

Didoris:
keep it up bro. pls I didn't get d Content in d column FROM AND TO and its relevance. thanks

Just to demonstrate how we shall be displaying the grades in my next post. It'll be relevant in the next tutorial.

Thanks for reading.

Please sir show us d if statement... Very important.