Header Ads

Preparing a simple continuous assessment with Microsoft Excel

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

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


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


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.

 Viola! You'll have your answer as displayed in the image below!


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.
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.lindaikejisocial.com/profile/christian-nwodo to keep tab on my updates WATCH VIDEO BELOW