 They are all this is a video about the check on the score sheet received from the TCS. Once the exams are over you will be receiving these two folders that is you will be receiving the online and offline folders that is one will be containing configured report subject wise and the MPTL subject wise score. These two folders contains the score sheets. The rest of the now I am going to explain you the checks to be done on this sheets. In the NPTL configured report subject wise sheet what we need to do is we need to do a check on this. Once you receive this score sheet kindly check the name, email ID, date of birth and application number or there in this configured data sheet. If it is missing kindly send it back to the TCS concerned respective people you will be given an email ID using that email send an email to that person TCS contact person and get those details in the configured excel sheet. Once before sharing these sheets we will be checking it once and after that only we will be sending if it is missing in that sheet kindly ask those details from the TCS and get the appropriate response sheet from the TCS. This is actually the response of the candidate whatever the answers they have selected in the online paper. So this is the online paper response sheet for each and every candidate whatever answers they have selected you could able to see it in this sheet. So for each and every section for each and every question it will be given a question ID so you will not be having the question number in this sheet. So question ID will be the reference for us and option ID will be given here option name also will not be displayed here. So once you receive this sheet you know the total number of candidates who are present on the first exam. So for basic campus say like 15 candidates are present or 30 candidates are present let me see how many candidates are present in this examination since 55 candidates are present for this examination each should have 4 rows commonly that is not 4 rows actually it is 5 rows I think actually it is question ID, question value, option ID score and correct option these are the 6 columns that will be static for all the candidates these may not be changed. So question ID will be given for each and every questions for all the sections and the question type whatever it is MCQ, MSQ or short answer type questions will be displayed here option ID and sequence which is not necessary that is just for reference and the score we need to get for all the candidates and the correct option ID or value is the one which we need to compare it with the candidate selected option ID or value. So these 6 columns will be static for 6 rows will be static for all the response sheet. So now what we need to do is this is the candidate response over here this is the candidate response for this candidate that is Shankaran he has given the result, score and question status selected option ID or value. So for question number question ID 1611 his answer is correct what he has selected we can see it over here selected option ID or value here is 41186 and the correct option ID what we have selected in the back end is 41186 since both matches he has been given a score 2 and does mark being correct and the question status he has been marked for review or he would have answered whatever may be this we can take it as a reference only this is not much needed. So let me see for the answers which is wrong so here what the answer is the correct app option ID or value should be 41191 but he has selected 41190 so it is wrong and he has awarded 0 marks similarly we can check the scores for MCQ once you receive this kindly check this criteria that is compare the selected option ID or value and correct option ID or value for 2 or 3 candidates and confirm whether this auto graded value is ok that is it is fine the scores are awarded fine once you are ok with this then you need to share it to the professor. So this is for MCQ type for short answer type what you will be given is the question number is short answer so here no option ID or value would be there since for short answer type of questions the candidate needs to type his response in the online software so in that the correct option ID or value should be minus 2 but what he has entered is that is in the selected option ID or value what he has given is 0 so he is awarded 0 marks for that since the answer is from so the candidate may give minus 1 also here so some of the candidates have given you can check it over here if the candidate has given minus 1 minus 1.25 he may awarded some marks but what the software will do is it will search for the exact answer if it is minus 2 then only it will award mark if it is minus 1.9 also it won't award marks so what we need to do is we need to check it out here since if the candidate has given minus 1.9 here then we can ask the professor whether he can provide any marks to the candidate if he says ok you can change the source score here and you can highlight it with the color and for minus 2 if the candidate has given minus 2 space if a space was there then the candidate will be awarded 0 only so what we need to check is we need to check whether the answer is minus 2 matches here minus 2 and if he has given wrong answer we need to provide him the correct marks for the question so if there may be a minus value or my space value also if a space is detected over there then he will be awarded 0 so whatever is given in the selected correct option ID or value in the back end it should be exactly match with it and the space or any other two more spaces if he has added that will also be considered as a wrong answer only and then what we need to do is for MCQ similarly we need to check the options for MSQ type of questions it is similar to that of the MCQ and the two option IDs which have been set in the back end should match with the selected option ID or value for the candidate's response if he has given one answer is correct he will be it will be marked as PC here that is partial correct you can ask the professor whether he can give marks or not if he accepts to give the marks kindly provide the score here and finally you need to do the sum of it sum of all the scores so if these type of questions are given if these types of questions are given here we need to send a draft mail to the professor once we receive these type of response sheet from the professor once you receive the response sheet what we need to do is we need to share the so these are the checks to be done here so once you receive this response sheet from the TCS what we need to do is we can check randomly the MCQ type of question and SC type of question whether the marks are awarded appropriately then if not we need to report it to the TCS that the online evaluation has been done wrong what we need to do is we need to check the MCQ type of questions if the answers are the correct option ID and selected option ID matches with the same and the scores are awarded correctly then we can leave it so if the scope if for any criteria if it has been mentioned as wrong if both are matches and then also if they have given wrong answer and they have not given the score we need to report it to the TCS these are the checks to be done at first so once these checks are done what we need to do is we need to send these sheets to the professor that is consolidated score sheet and respond sheet respond sheet for the course name you need to mention it here that is this is for 8th November and for 1st November also you need to give it to the professor so you need to mention him in the mail that the short answer type of questions has to be evaluated by him or by the TA's by cross checking it with the correct option ID and the selected option ID and these sections need to be highlighted with some other color and this should be mentioned in the email so that the professor or the TA will look into this and they will provide marks for this and at last what we need to do is we need to do a sum of this some of these scores for all the candidates so this is a thing we need to do in this file similarly the respond sheet for the 1st November has also to be checked and that respond sheet has to be given to the professor along with this so these are the sheets to be shared to the professor respond sheet for the first exam and the second exam and this consolidated score sheet should be provided by us now this sheet how I will explain you how to prepare this consolidated score sheet this consolidated score sheet will be given to you this NPTEL subject-wise score this sheet will be provided to all the IITs from the TCS so on seeing this sheet once we open this sheet this response sheet will be given to you based on the date wise first and eighth and the subject wise scores also will be given to you based on the dates first and eighth this is a subject wise score sheet which will be given to you for the final candidates for the exam this is only for 1st November so for 8th November also you'll be given a sheet like this so you need to prepare the consolidated score sheet which should be in this format so the first format should be course ID template should be in this format course ID roll number first name email and then we need to map the assignments goes to the professor and these logics will be given to you once the course ends the professor will be posting the exam score calculation logic in the announcement and forum based on this we need to put these columns over here and the scores also we need to mention here exam score exam score from TCS out of 100 this column has to be filled once the professor says confirmation since the confirmation mail to you once this that SAT questions and MCQ questions are evaluated by the professor calculate those scores from the response sheet this response sheet you need to calculate this overall score for each and every candidate if there is any changes you can calculate this score and you need to mention here you need to update the score at first what you need to have is final exam score from TCS out of 100 and faculty updated score should be given here and one more column final updated score from faculty out of 100 so we will share you this template for you in this template you need to fill on the details first it should contain course ID roll number applicant first name email ID the assignment map and the details of this that is a calculation logic should be given a column over here the final exam score from TCS out of 100 which should be updated here from this sheet out of 100 this sheet contains the score from TCS out of 100 so this is a total score over here do a we look up based on this email ID this email ID and have a you will be given a final registered data is it what we need to do is we need to prepare another sheet that is the sheet to be sent to the professor should contain present details here absent details in the second sheet and the third sheet should contain the consolidated score in the consolidated score the template should be in this format as follows so as for this what we need to do is we need to get the course ID roll number name email ID from the final candidate data template that is we have obtained the app attendance details here in this sheet right in the from this sheet you need to take the first name email ID and all this details and you need to copy these in this excel sheet and you need to map the assignment details also here and then you need to update the final score from TCS out of 100 from the sheet they have given to you subject wise course should they would have been shared with you from this sheet we need to get the total score out of 100 or it may be out of 70 the exam may be out of 70 also so you need to calculate the total score get this total score in the sheet that we are going to send to the professor do a we look up and get the scores from TCS and then what is this column final updated score from faculty out of 100 this should be that whatever the professor has evaluated know in this file the professor may have given some marks as life changes will be there so if he has given some marks calculate this in this column and then do a we look up based on the email ID and get the scores here from the faculty out of 100 so that's it if there is no change then copy the final score from the TCS out of 100 and paste it here as I say since we have received the confirmation from the professor that there is no change if there is no change you can copy this column out of 100 and paste it here else you need to copy the updated score from there to here now we are going to map the assignment details here assignments course here so before mapping this assignments course here we need to take a dump from the online courses portal this assignment dump has to be taken from the online courses portal once all the deadlines gets over from the course so what we need to do is before taking the dump you need to log into the course using the reviewer email ID not using the course email ID that is admin email ID before taking the dump we need to log into the online courses portal using the reviewer login ID each and every course will be having a reviewer ID which will be shared to you you will be given the reviewer email ID reviewer one at npcl.itm.ac.im and the password will be given to you so for each and every course before taking the dump you need to log into the reviewer ID not using the admin ID just log into this click on each and every assignments and check whether the due date has been ended or not since the due date has been over I have taken the assignment dump on 12 level for all the assignments the assignment due date has been over so I have taken the assignment dump and what you need to do is you need to get the assignments code for this so you need to the assignment name the in the dump you may get the assignments which have been created for reference admin ID but they may have deleted further so what we need to do is we need to check it first we need to check whether those assignments which are in live that is the candidates have submitted that only we need to add in the dump so first login to the scores check whether these assignments whatever assignments are visible in the reviewer login that assignments course only should be in this profile dump so this assignment one score has not been here since they have created this assignment and they have used Google Forms this course has to be given from the professor so once you receive that score from the professor you can get it so mention this column is even and leave it as blank if it has course here kindly check the dump if the dump has assignments course you can get the assignments code for those candidates alone and check assignment to assignment to the assignment number is 78 so it may have duplicate also assignment to may be repeated here anymore again so what you need to do is the assignment number what it has is 78 and assignment 2 is view viewable in the public so in the reviewer login so you can take this code for assignment 3 also it's viewable assignment 4 5 so you need to check all these columns new assessment is created only for reference and this is not available in this online courses portal so you can delete these columns 5 6 7 and 8 these are the assignments course which are to be taken so to take this assignment school what we need to do is from the consolidated sheet to a be look up and get these assignments course alone this 8 assignments course alone and get the average assignments course since the professor has given the formulas average assignment score out of 100 you need to fill this column the formula is that we need to sum up all the A1 to A8 assignments and average assignment score out of 100 you need to calculate it so average of it divided by 8 is you will be getting the average assignment score out of 100 and then 40 percentage of assignments for the professor has given 40 percentage of average of all assignments so I'm doing it step by step so we need to mention all the steps in separate columns so 40 percentage assignment score final score from TCS out of 100 and final updated score from faculty out of 100 after his reevaluation from the scholarship then 60 percentage of exam score over here I have calculated it since this is out of 100 I have calculated it for 16 to 60 by 100 and rounded off that value so final certificate score will be a combination of 40% assignment score plus 60% examinations score so once you create this template you need to fill all these columns it might be lack over here for few professor which who may not be giving us a logic for that you need leave those columns consolidated assignment score and the exam score a column as blank and send this to the professor and get the logic from him and then get the do the calculation if he has given the calculation already do these calculation and keep this final certificate score as ready so if he has provided some marks then he will be filling it here and he may be giving you else you need to fill this column if the professor has given the scores separately if not you just take this as an exam score and convert it over for 60% and then do the final calculation this needs to be given to the NPTEL for uploading the scores in the portal for uploading the scores in the NOC website you need to give the scores in the following format so that template I will be sharing it to you that is 2 dB so assignments core template will be there and update exams core template will be there what you need to fill is roll number should be added here that is from the consolidated score sheet what you're giving it to the professor you need to copy the roll number from this and the assignment scores which had to be given a 12 a 14 or 8 assignments are there for elements of official representation so fill 8 assignments course over here and delete this rest of the columns and give this score assignments core template and the second one is you need to fill the update exams core template in this NOC course ID which should be in the format of NOC 15 IEFN this is HS16 since they have 8 candidates marking it here and the roll number has to be given here score from assignment whatever we are publishing in the website it should be out of 100 so what you need to do is we are calculating it here for 100 average assignment score out of 100 so this assignment scores has to be displayed in the NOC website so out of 100 assignment score should be displayed here exam score out of 100 if the exam is for 80% what you need to do is you need to convert it to 100% and then copy that cells here and paste it and again what you need to do is final score final score it should be out of 100 that is the 60 percentage exam score plus 40% this is a final certificate score this should be copied and given to the NPTEL that's it and one more detail what we need is before we need to upload it in the NOC portal we need the assignment mapping details which is which needs to be in the following format this assignment map A map should be given to the NPTEL for uploading it in the website so what you need to do is you need to mention the course ID here this template will also be given to you you need to do is you need to give the course ID here total assignments has to be given here so since it has 8 assignments you are giving 8 and go and check in the online courses portal and provide the details here since it has 8 weeks in this they have given 8 weeks so I have mentioned 8 weeks here an assignment map the first week they have given A1 weeks you need to mention here is 1 so since it has 8 weeks you need to mention it here each week has one assignment so I have given in this format some may have some may be like this A1, A2, A3 may belong to first week so whatever is given in this portal check with the week wise details and give the assignment map detail for each and every course using this only we will be updating it in the NOC portal so these are the sheets that has to be shared to NPTEL and the professor so you will be given a format that whatever needs to be shared with the professor has to be like this to professor what we need to share is we need to share the response sheet and the consolidated score sheet this sheet will be taken from the final candidate registered data the present candidate details alone we need to take no need of taking the absent candidate details we need to take the assignment scores for them do the calculation and keep it ready present and candidate maps and candidate details also should be given over here and the response sheet for both the exams has to be kept ready these sheets has to be shared to the professor once you receive this you need to proceed this consultant score sheet and update the format that I will be giving to you to DB these for these sheets course to be or to be given in this assignments code template and updates code template and this sheets to be shared to the NPTEL for uploading in the NOC portal