Microsoft Excel 89 Creating a Grade Sheet in Excel

SimpleTutorials

Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.  In this video lesson, we will learn about Creating a Grade Sheet in Excel in Microsoft Excel  You can access the entire Microsoft Excel Course in the following playlist: https://www.dailymotion.com/playlist/xa9hywmicrosoft

Transcript

00:00so let's say what i want to do is i want to go ahead and create out a grade seat and

00:14automatically calculating grade seat uh that is a result seat in microsoft excel so you can actually

00:20do that quite easily so for that around over here let me just go ahead and add in let's say for

00:26example subject right here and then i'm going to go ahead and let's say for example add in quiz

00:31and then let's say for example assignment and i'm going to say midterm let's say for example

00:36and i'm going to say final and total right here so you can see that i got all of these parameters

00:42and let's say this is for a single student let me just select this all and then build this out as

00:47well for subjects i'm going to go ahead and have mathematics i'm going to have computer science

00:53right here i'm going to go ahead and have english just like this and i'm going to go ahead and have

01:00science as well i'm going to adjust the column to go ahead and make room for everything let me just

01:05select all right here and then add in the border as well so let's say for the quiz the student got

01:1218 let's say for example right here for computer science let it be 17 15 and let's say for example

01:1916 right here for the assignment let's say for example it's uh 26 25 for this one and then 24

01:28right here and 23 as well but i don't know like how much is the total mark so i can simply go ahead

01:33and add in the total marks right here just like this so let's say this is out of 20 assignment let's

01:39say it is going to be out of 30 right here midterm it is going to be out of 20 let's say for example

01:45right here and then i'm going to go around and say final right here or finals let's say for example

01:51this is going to be 30 and total is going to be 100 right here just like this so i got these so for

01:59the midterm i'm going to go ahead and add in 15 16 14 and let's say for example 15 right here and for

02:05the finals i'm going to add in 28 27 26 and 25 right here just like this so now i want the total

02:15to be calculated automatically so for that i'm going to go ahead and press ok type in sum and

02:22open up the bracket and select out all of it right here and close out the bracket and you can see that

02:27the total is 87 and if i were to click and drag i get the total marks for each so now what i want is

02:34let's say for example i want the grand total right here just like this and then i'm going to go ahead and

02:40have in person days right here let's say for example and i'm going to go ahead and add in an

02:46overall grade let's say for example and i'm going to go ahead and add in result right here let me just

02:52go ahead and press ctrl x and v to paste it out right here and this is going to be in a table as well

02:58so for the grand total right here i want to go ahead and have a sum of all the totals so for that i'm going

03:04to press equals type in sum open up the bracket select out all right here close the bracket and

03:10then you got the grand total now for the percentage right here so now the percentage is going to be

03:16four subjects right here so i'm just going to go around over here just like this so i'm going to go

03:22ahead right here and let's say for example uh the total marks right here for four subjects is 400 that i

03:29know so i'm just going to go around and press equals and select this as a reference so i'm going to go

03:35ahead and divide it out right here by the total marks let's say for example 400 right here and press

03:42enter you can see 0.82 that is the percentage you don't see percentage right now but as soon as i click

03:49on percentage under the home tab you can see the percentage value right here so now for the overall grade

03:56i want to go ahead and use if condition so i'm just going to go ahead and press equals first i'm

04:02going to say if right here and open up the bracket and then i'm going to select grand total as the

04:09source value so if it is greater or equal to let's say for example 90 it is going to be let's just type

04:16in comma right here this is going to be a plus right here just like this so now once i do that i'm

04:23going to press comma again and now i'm simply going to go ahead and copy this because i want to repeat

04:29this if a bunch of times let's paste this out and let's say if it is above 80 right here then it is

04:36going to be let's say for example just 8. then if i were to go ahead and paste it and if it is above

04:42let's say for example 70 right here then it is going to be uh let's say for example b plus right here

04:50so if it is uh let's say for example uh above let's say for example right here 60 then it is going to

04:58be b right here just like this so this is what i want to go ahead and add in so you can see that these

05:05are all of it so i'm just going to go around over here add in more and if it is greater than let's say

05:11for example right here um greater than or equal to 50 let's say for example then it is going to be a

05:19c right here so i'm going to go ahead type in c then i'm going to go ahead right here and then copy

05:26this out so let's just go ahead and copy the if right here the c and i'm going to go ahead and paste

05:32it out and you can see that i can go ahead right here and let's say this is greater than 40 it's going to

05:38be uh d so if everything else is not correct then i'm simply going to go ahead and type in f

05:45so i'm going to start closing bracket now and as i close it you can see that each bracket highlights

05:50and then if i were to press enter you see the overall grade as well so apart from that i want

05:57to add the result as pass or fail so above 40 is passed and otherwise it's failed so i'm just going

06:02to press equals add in an if condition and open up the bracket select out the grand total and i'm

06:08going to press uh greater than or equal to and then i'm going to say 40. so if it is greater than or equal

06:15to 40 then it is going to be passed otherwise it is going to be fail right here and i'm going to close

06:20the bracket and this is what you have right here so i'm just going to go around over here and center

06:26align it out right here just like this and i'm going to go ahead and center align up align all of these

06:32marks right here just like this as well so this is what you have and apart from that i want to have

06:37the student detail so i'm going to press ctrl x and bring this data form downwards right here just

06:44like this and i'm going to go ahead and add in details right here like student name right here just

06:50like this and i'm going to go around and say role number right here just like this then i'm going

06:56to go ahead and say subject right here just like this so you can see that i got these details as

07:02well and let me just go ahead and add in my detail right here just like this and let's say my rule

07:08number is 31 and subject is going to be um right here so a subject is uh actually not necessary because

07:18i have it right here so great let's say for example i'm going to be in eight so this is what you have as

07:23you can see right here so now i can even go ahead and let's say for example bring it down right here

07:29and arrange this out and then i can go ahead and select out all right here uh just like this

07:36so let's just go around over here and insert this to the left as well and then insert it out onto the

07:42top i can select all of these right here just like this and then go around over here and let me just

07:49press ctrl z i'm going to go around over here and add in an outside border let's add in a thick outside

07:55border right here so this is what you have so i'm going to go ahead and resize this out right here

08:01i'm going to resize this out as well resize this out as well and you got an automatically calculating

08:08result right here just like this so you got this out right here so i'm just going to go ahead right

08:13here add in uh let's say for example a bottom border right here on all of these right here and i'm

08:19going to go ahead and center align this out just like this as well uh so this is what you have as

08:25you can see and this is what you have let's just go ahead and resize this out as well so you can see

08:30that i got all of the details right here just like this and i got an automatically calculating result so

08:37if i were to go ahead and type it zero you can see that everything else it changes out so this is

08:42going to be let's say for example 12 right here and so forth if i were to go ahead and let's say for

08:48example add enough failing marks right here you can see that i can go ahead and change up the marks

08:53you can see that everything gets calculated accordingly right here just like this and this

08:59is what you have so under uh 40 right here as you can see right and if it is under 40 right here then

09:06you actually have a fail so let's just go around over here and as you go ahead and do that you can

09:11actually go ahead and add in the marks as you want so i'm just going to go around over here

09:16type in the details right here just like this so let's just go around over here

09:21uh just like this right here or maybe i'm going to say 24 27 28 29 right here midterm is going to be

09:3114 13 16 and let's say for example 18 and you can see that everything uh gets calculated dynamically

09:39right here just like this so this is what you have as you can see so that is how you can go ahead

09:45and create out a result seat and automatically calculating result seat as you like inside of

09:52microsoft excel so i hope you found this video useful be sure to hit the like button don't forget to share

09:59this out with your friends and family and for more contents like these do follow simple tutorials

Category

Transcript

Be the first to comment

Recommended