 Now we will start with the attendance and the certificate module, I am Vania Gripal from IET, DAVV Indore and he is Rajdeep Penge from DIICT, Gandhinagar. This is the FDP coordinator's interface, whenever the FDP coordinator logs in, he will be seeing the list of all the workshops and when he will be clicking on any of the particular workshops, then he will be able to see the list of dates for which the schedules for the particular workshop has been assigned. On clicking on any of the particular dates, we can see the details of the participants and their absent and the present. In attendance module, we have different views for the FDP coordinator, the FDP coordinator can view the attendance of the participants and he can also update the attendance. The RCC coordinator can only view the attendance and generate the Excel report and the principal delivery manager can generate the reports based on the filtering conditions. Now we move on to the FDP coordinator's module, we can see the, whenever the FDP coordinator logs in, he will be able to see the list of the dates for which the schedules for the particular workshops are being done and whenever he will be pressing it on the blue button, he will be able to see the, he can update the attendance and when he is updating the attendance, the button will turn to green and after the update, he can see whatever he has updated. There are also gray buttons which are disabled, the gray buttons are for the past sessions and the blue buttons are for the active sessions. The admin, the FDP coordinator downloads the attendance sheet and he will get the signature of all the participants and then he will be uploading it. He can also, this is the attendance sheet, he can upload the attendance sheet and then he can view the uploaded attendance sheet. Now we will move on to the remote center coordinator's interface. Starting with the remote center, the basic objective of remote center coordinator is to manage the remote center. So remote center can see the attendance for that particular remote center. So as we can see the list of workshops that the remote center coordinator sees and a similar interface is there. Just the thing is that instead of the editable checkboxes there, right now we have just the display attendance button. So only the attendance gets displayed in this part. Then one more feature is there that report, the attendance report for the. The attendance will be filled manually or something automatically. The earlier module what she explained in there, the attendance will be filled manually by the. You didn't have anything like biometric interface or something. They can fill 15 means 15, 20 means 20, there is no counter check, right? That is why we have to, we have that attendance sheet where the participants have to sign that attendance sheet and we can verify it so that there should be no discrepancy in that. So it is a manual work. No, no, no, it gets worse than that because what the manual team does is wherever they can also look at the AVU footage, snapshots and then they go back to the remote center and say you are saying that 15 people attended but actually only 4 heads. So that also, that much monitoring has to do because the earlier workshops were run with government funding so that the remote center used to get money per participant. So they will enroll so many and nobody will be there, there were cases where the students were asked to attend because our people asked 4 heads, so next time 15 heads but never some student. So they are cheating to collect money from the government so that huge thing was coming. So if we go into the funded mode category, I do not think all these things is necessary but it is a past. But it is always good thing that you can integrate the biometrics. Not biometrics. What I asked, what I had asked them to do is, biometrics we cannot insist at every remote center. So what I had asked them to do is whatever is the, your signature which form is uploaded that I can do image analysis and find out how many have signed, that can be done at least. 11 signature in a day one and then show every day new signature. I think they can, I think they can but there are some people who are genuine so they will say that I have not signed anything yet. Okay. Attendant sheet, when our attendance sheet is under, it has a particular barcode. So attendance sheet is being sent from over side or they don't? Generated. They print. Okay. Generated dynamically. I was thinking of actually doing some barcode etc but everything they can biometrics is the only way and the verification should be done on server. So their biometric impression should be stored on server, they have to come put the thumb print so that it will verify by the server. Yeah, continue. So this is sort of attendance report that the remote center coordinator can see. We have added two new features in this part. That was the requirement here that the total number of participants that can be generated that have attended the session on that particular day. So that is here the last row that it can be shown. The second feature that we have added is the total number of sessions that the participants attend and the percentage attendance of the participant. Those two features we have added in this part. Now moving on to one of the most important parts that has been assigned to us of fetching the grades actually from IIT Bombayx. So as we know the online component is hosted on IIT Bombayx and the grades will be fetched from there. So this is the basic structure of the interface, the process flow that I can, I have understood and I can tell you that here in the center there is this T-Cube user interface. On the right-hand side the IIT Bombayx, MySQL database, Mongo database and here our T-Cube MySQL database. Now what happens is the core structure and the grading policy of the course hosted online is stored in the Mongo database of IIT Bombay. While the actual marks for each participant and each question are stored in MySQL database. So we have to get the core structure from Mongo and get the actual marks from MySQL. So this has been, it has took a lot of time for me to understand. So this is basically. Why do you have to get the core structure? Sir, the structure of the IIT Bombayx database is such that it stores the marks with a problem ID for each problem and each participant. So we have to filter it accordingly from MySQL. But these problem IDs are actually stored in the Mongo database only. So we have to get those problem IDs from Mongo database. And the Mongo database has this complex structure wherein it is a hierarchy. First question is why Mongo they have used? Whenever the course is generated. Anything special support that they are getting from using the hybrid databases or only for the sake of only passion. Let's use somewhere mango, somewhere use raspberry strawberry, orange. Sir, whenever the course is generated, each course can have variable number of fields, variable number of questions, variable types of questions. So all this is variable and it cannot be directly stored in MySQL. Why? Because MySQL table is fixed. So we have to get the. Create new table. Sir, but if a particular field does not exist. Create a field. Sir, but it cannot be applicable to all the courses. Why not? There are so many applications which are running on MySQL. Do you say that MySQL doesn't have the capability of handling such kind of structure. It is a too much complex structure that it is not acceptable for the MySQL to sustain the load. The thing is that whether you ask your mentor also why there are two databases. Whether it is originally available, that is why you have taken or you have worked out something. Sir, it's actually the open edX database structure that has. Okay. Why open edX? There may be some reason why Mongo. So not specifically, but they have created in sort of Mongo. They are creating, they are distributing the data in three collections. So, and this is particularly important as they are using the active version stable to store the course definition. The structure stable in which all these things are stored, the blocks, course chapters and problems and definition. So this is not a fixed structure of a course, it gives the flexibility of generating the course as well as generating the types of questions that we want to add, types of modules that we want to add. So, all this flexibility is actually given by the Mongo database. Sir. How does Mongo do things? Sir. Yes. Yeah. Let him present. His time is going on. Don't interfere. This is, you have to answer the question. Why Mongo? Then this is kind of flexibility what you are saying is whether it is not possible with other database like you are saying MySQL. That is what the question was. Yeah. So exactly, sir, whatever I have understood from this partner, both the databases. No problem. If you don't know the answer, say that I don't know. It's not an issue. Right? Rather than giving the wrong answer, it is always good. I always suggest that. Except I don't know. Sir, I don't know the exact answer. I'm whatever I have understood. I'm telling you that for me, it has been this much that the convenience for course creation that is the Mongo giving. So that is what I have understood from this. The next part is, so this is a complex database structure and a hierarchy of a whole lot of blocks that they have made. So understanding this. So till now we have got this much till this much that we have created some participants for testing purpose in IIT Bombay X and we are the marks here are for a particular email ID. Since we know that email ID is unique between both TQ and IIT Bombay X. So we are using email ID and we are getting the marks for that structure. The marks shown are this final percentage marks of online component after applying all grading conditions from the grading policy that we are getting from IIT Bombay X. And these marks have been mapped with TQ database using the unique email ID that we are getting. There is some improvement part that is still remaining in this that we have to actually store these marks in the database and use forward it further to the first certificate generation to get the actual grades to generate certificates. That part is still remaining and I will be doing it in the next way I am here so I will be doing it. Next we will move on to the certificate module. In this we will be generating the certificates for all the participants who have fulfilled the grading criteria and whenever the principal delivery manager logs in he will be able to see all the list of the active workshops. He can also switch to a particular workshop in which he will be able to see all the remote centers registered for the particular workshop and in the left there is a button download template. He can download the template for the face to face component to fill the marks and then he will upload it after uploading the marks he will generate the marks for the participants. The admin can also see the participants in a particular workshop. You are coming for a second time right? So how many times you are going to come? This is the last time? Okay, thank you.