 Good Noon On. In this video I am going to explain you how to take the attendance details that is the present and absent candidate details for the candidates who have appeared for the examination. To take the present and absent candidate details we need to get the final candidate data that is nothing but the candidates who have been enrolled for the exams that is for those who have paid for writing the exam on the current run. For each and every run the exams will be held on two dates. For example the July run the exams held on July 6th and July 12th. So we need to get the candidate data for those for the candidates for registering for the exam on two dates. So this overall candidate data will be sent to all other IITs from NPTEL. Once you receive the overall candidate data this has to be rearranged in a particular order based on the final candidate data template. This template will be shared to all the candidates and all the other IITs which needs to which the data has to be rearranged based on this order. So once you receive the final candidate data this final candidate data will be shared to you in four files in this order. These are the files. First November offline for example I am taking the November exam candidate data. So for the next and March run you will be getting the candidate data for the particular exam dates. So this is the first November offline candidate data, first November online data, eighth November offline data and eighth November online data. Likewise you will be getting the candidate detail for the March run like March 1st or the exam date will be deferred. So offline data and online data will be based on the dates. So once you receive the candidate data you need to arrange these in this template. In course wise manner. So I am going to take the online candidate data. The candidate data will be sent to you in this format. What you need to do is we are going to rearrange it. I am going to arrange it for one particular course. So I am doing a filter here. I am going to collect the final candidate data for language and society course. So after doing this filter, copy these details and arrange it in this order. Applicant name. Next what we need is a date of birth, email ID, application sequence number, participant ID. In this data they have not given the participant ID. So the participant ID will also be given to you from the TCS. This participant ID will be given to you from the TCS. So keep this cells as blank. The hall ticket number will be given in the final candidate data. Copy these details and then follow the hall ticket number. The course name. You can mention it here. Since we are taking this final candidate data separately course wise. Separately in the course wise manner. So we can rename this sheet as the course name as language and society. Now I have renamed this accent based on the course name. So we need to take this final candidate data details separately in the course wise manner. Then the second one since the course name needs to be mentioned here. Language and society. The course ID will also be given here. The exam date is November 1. So I have mentioned here. They have given this test center name city. Actually the exam test center city and state has not been given over here. So we can take these details from the attendance sheet which will be given to us from the TCS once we receive the attendance details. So we are going to leave these also blanks. This participant ID needs to be kept blank. Test center state and city also we can keep it as a blank one. So these details we can take it from the online attendance. Online and offline attendance. So these are first details, first candidate data details. For 8th one, for 8th online data. Again we need to do a filter here. Copy the same like this. And then the whole application sequence number, All ticket number, course name, course ID remains the same in the exam date. And the test center state and city needs to be kept blank. So we have taken the final candidate data for the course language and society. For the remaining courses we need to take in the similar format only. So whatever details we are going to take like attendance details or the score details, Whatever details we are going to take it further we need to take in the same format as that of this final candidate data template. These fields remains to be in the same order as that of this. This need not be changed further. So this is the final candidate data we have kept ready. Then what we have to do is likewise we need to take the final candidate data for offline candidates also. So this candidate data has been kept ready now. Then we are going to map up with the attendance. So you will be receiving the attendance also in separate sheets. For first number you will be receiving a separate online attendance sheet and for 8th attendance 8th exam online you will be getting a separate attendance sheet. So then what you need to do is you need to combine the first and 8th online attendance in the same order as that of this. This template needs to be followed in all the sheets. So now I am going to take the name, name and date of birth, email ID, attendance template, application sequence number. In this sheet also the participant ID is missing. So actually we will be giving you the participant ID separately from the next run. This participant ID will be given to you. So there won't be any problem for you to get this participant ID in the certain sheet. So in the certain template whatever you receive from the TCS will have the participant ID. So for the demo purpose since I don't have the participant ID I am doing it here separately. Then the hall ticket number, course name is language and society. This course ID needs to be copied here. The center name, city and state will also be given. For 8th number also I have taken all the details over here. Hence attendance template for the course language and society has been kept ready. All these details has to be filled in the order asset of this template. So now what we need to do is we need to map the present and absent candidate details. Also copy this attendance here. Hence attendance details has also been kept ready in this attendance template. Now what we need to do is we need to map up with the final candidate registered data. This is to cross check whether the present and absent candidate count matches with the total registered count. So what you need to do is take the attendance template sheet and the final candidate data sheet.