Objective
Make a list of students who did not submit their feedback. Please refer the youtube video: This is my link: https://youtu.be/R3jzHfU7W84.
You can download the video if you want 106 mb
https://drive.google.com/file/d/1iNm6pUZeXypx4mNe0DRjgdzZNpZ5Td57/view?usp=sharing
Alternate link https://u.pcloud.link/publink/show?code=XZb9PIXZKxBwXbnqD3jEs4ikj9046jbFlJqk
Alternate link https://filetransfer.io/data-package/yPdow6cT#link
Alternate link https://www.transfernow.net/dl/20211121Rdtns0fT Info about files
course registered by all students.csv
This contains the list of all courses for which he/she is registered.
course master dont open in excel.csv
This contains the LTP for every course. Ensure you open in libreoffice/notepad++/vscode/etc. DONT open in Excel of it will convert LTP to dates.
course feedback submitted by students.csv
This contains the feedback by students, this you will check which subject feedback is not submitted by students.
course master for Backup.zip
This contains the course master dont open in excel.csv, in case you opened in excel, replace that file with this one.
studentinfo.csv
personal info about student Output File:
course feedback remaining.xlsx Strict Excel file.
This is self explanatory, for adding info in this file, you will need to take help of studentinfo.csv and course registered by all students.csv
The algorithm.pdf explains the logic too along with the video.
1
