Print Individual Mark with airSlate SignNow

Add individual mark

[Music] this is Ramon with your favorite channel complex in this video I will show you one shade that I have made for calculating yourself making consolidated sheet and printing the individual sheets like you can see the mark sheet for the individual student so let's go through it so here we go okay so today's my shoot is in Excel format because you know actually is used for mathematical calculations so it's much better and easier to perform these calculations in ms excel so let me reduce you with some sheet areas so here on the top we have this school name under that is the name of the shade I what purpose f is for that sheet so this is consolidated map sheet and you can definitely type here term as well like you can say midterm okay here we go here will be the school name let's both calm tricks this is my channel name and here we have roll numbers it's up to you whatever you wanna define here so I'm starting with one two three four up to 50 this particular sheet will be for 50 student yeah 450 students and here we will write the name of the students let's pause okay this is our student name here we will write all the obtained marks that are obtained by one particular student all in one single line so here we will type these and you can see there here we have one formula for some calculation here what we what we are doing there we just calculating all the obtained marks and then in the next column we are taking the average you can say the percentage and next in column it's a grade like a plus a and b plus b c plus etc so here what have i criteria i will show you in the formula F grade is for 33% and below 33 he grade is for 33 and greater than thirty three D grade is 450 and greater than 50 C grade is 460 and greater than 60 and B grade is 470 and the greater than 70 a grade is 480 and a plus grade is four sorry a grade is 480 and greater than 80 a plus grade is 490 and greater than 90 so you can just see these greater than symbol and equal to symbols if I miss something just let me know I hope I described it fair so in the next column calculating percentage of total marks and in the next it is a class position basically this formula it calculates the position of a particular student in class depending upon the percentage so here we are calculating personal Terry we are taking reference as a percentage sorry we are taking percentage as a reference for grading students class positions so here we go this formula is very complex so I will not discuss in detail because this is a combination of more than one formulas okay here we go this is a class standards this is up to you you can write it manually so whatever you want it doesn't affect any of these columns in this sheet so next is fine yeah for fine there's some calculation suppose one student is absent where for two papers three papers so he's missed one paper so whatever that is so we will calculate fine here so whenever we are typing a right now like we type a it will calculate automatically u xx so here you can type here this is a fine for epsilon that you can define whatever you want let's suppose you write here ten so what will happen if you go up so it will ten plus ten twenty so it's all it is all row it is already it is all automatically calculating ten fine for one leave one absent okay so here it will calculate a total option in exam only this is for the example because only it has no any kind of relation with this class attendance so it's up to you whatever you want to define it or if you want to leave it it doesn't matter so okay so next here is the some condition that some schools require these are hygiene like there are some grading techniques that these schools use call J's or whatever so here it is ABCD it is up to T so we can select here suppose a cleanliness be punctuality game a homework you see so here everything is done on this single sheet you no need to do anything on the second sheet so now the main thing these are our subjects so definitely we need to define some maximum marks for these subjects not some for all in fact so we need to define the maximum marks for these subjects so if we scroll down here then you can find out for English let's suppose we are going to give fifty mm 50/50 for each subject I'm just posing I'm not making it's up to you whatever your criteria is if your marks are 150 20 so you can write out whatever you want this is our class cell here you can type the class so it will display only on the individual markets not here yet anywhere in this because a consolidated here it will not display anything so let's suppose we type fifths you see the class fee and here you can write the date current date that we are going to display on the individual mark sheet so this is our total overall structure of the consolidated market it's up to 50 students it's increasing well but you have to definitely drag and increase the formula ranges so if I scroll to this so here these are the gratings that are we using here in hygiene and cleanliness but punctuality and homework okay we are done here let's go to next sheet it is cool him here here school logo whatever you want that's what I type here come to X okay here we have complex school these two think that you have pretty fine manually so mark sheet okay and logo you can replace of your own okay here is students name we don't need to do anything because here already I have a pride we look up formula here also so as I mentioned before the class it will automatically get from the main consolidated 280 if we double click here we can see it is showing our reference to consolidated and cell number of 35 and if we go here so here it is f 85 and our sheet name is consolidated okay so let's move to any individual shoot okay this subject list it is automatically generated from the previous sheet consolidated sheet from here if you make any change here then automatically this change will reflect on the next way light like suppose if you type here sorry and this yes t subject these are also coming from here yeah so if you write here English grammar so scroll down into the English grammar here update it also and here also next year also these marks are received from the previous sheet with the formula same and the subjects are saved so no nothing need to do here it will automatically generate here we have same we look up formula to get the marks obtained marks of the individual student and here also we are calculating the percentage of individual subject suppose somebody gets some marks in English and it will calculate English percentage separately overall it will definitely calculate at the end but here this is per subject calculation of the average and the grade it will also display the grade of in particular subject so okay so the Oh everything is done here no need to update anything here my hygiene clearly there's particular sorry punctuality homework everything is displayed here and as I mentioned earlier this is the date that we entered in consolidated shield so I just need to a little bit formated okay don't so here what it's doing it is calculated these total marks in fact there is one formula it is calculating from not from the consolidated sheet it is calculating here on this sheet this marks sheet so this sum have no reference with the consolidated sheet so for why I created this one because you know sometimes we need to create one individual so you wait - we don't want we just want to put in the blank sheet so for that case we can put our desired values here then we can bring it out so only for that purpose I have calculated this some formula here here it will calculate to obtain marks that we see from the consolidated sheet and here we will calculate percentage and here it is the overall grade of the student so let's suppose we just fill up one or two columns for one student [Music] [Music] okay so here we go now you can see here that these values are automatically calculated so well this is total log of all obtained marks and this is percentage this is the overall grade of the particular student and this is the class position now see you can see he got he got 57 he got 57 percent so definitely he will stand first in the class and the other guy who is at 53 percent he got second position and the remaining all or at third position and here definitely we will fill out as this is brilliant student so we will give him good marks but it it's not compulsory because sometimes it's been you shouldn't do not have good hygiene incurred punctuality and these qualities but it doesn't matter which is it just for example don't take it on serious don't take it serious just okay so here we are going mark sheet okay so we have already entered maximum marks yeah exactly it's done okay oh we have first student dot roll number one enter yeah here we go comm channel and English grammar 2002 45 by 35 size 20 so let's match it with consolidated sheet so 20 45 35 20 so these are the same grading and the percentage of a student in the particular subject these are the grades in particular subject this is a hygiene cleanliness perte punctuality and homework grades so this is the overall maximum marks this is some of all obtain marks this is percentage and here we have the great D so here we go these are all detail that we need to print here so you can just go click ctrl P and it will display you our print previews you can see it it is just single page and definitely it will print on a four page and in this this is a print preview of our mark sheet so if we type two so it will immediately get the result of roll number two so this is the all that I have done for today now definitely took too much time but now I'm happy since head this will help it so because a lot of people asking me my colleagues my friends and some of my family people because they are in school too they asked me to help in this matter so I have prepared this sheet so I will upload it on my website link so I will show the link here so you can download it and you can use it as you want so you are free to make any kind of changes and if you need some kind of change from my side so definitely I am here to help you so thank you and thank you for your time and thanks for waiting my English don't forget to subscribe and like my channel because this we really helped me and definitely I need your help to grow my channel and it supports me lord thank you take care bye [Music]