Each teacher of a school sends the registrar an Excel worksheet with the grades of the students and you are asked to create a system that includes:
1. The layout of the Excel worksheet that should be generated by each teacher and sent by email to the registrar as a comma separated values (csv) file.
2. A program that will read all worksheets and generate a master text file called grades.csv
3. A second program that will extract from the grades.csv file all the grades for a certain student defined by the registrar and its average and will display a screen with the results
To test the programs, create the Excel file of at least three teachers of different courses with at least 5 students each and show the results obtained when running the two programs you coded.