This project is a Google Sheets workbook that analyzes data from a language center called "AprendΓ© Hablando". The workbook contains information on 1,000 students, including their names, email addresses, and grades. It calculates students' final grades based on their scores on two partial exams and a final project. It also tracks students' achievements, such as honors and discounts. Additionally, the workbook includes various charts and graphs that help visualize the data.
 |
 |
βοΈ The information provided in this sheet is fake and was generated using the free tool Mockaroo (https://www.mockaroo.com/). The complete database is located on the fifth sheet, "DATA".
βοΈ A database of 1000 fictional students, including details like their student ID, name, gender, email, and performance data for language courses they've taken.
βοΈ Calculation of final grades based on two mid-term exams (40% each) and a final project (20%).
βοΈ Identification of students who received academic honors or discounts on future courses based on their performance.
βοΈ Highlighting of student information using conditional formatting to easily visualize results.
βοΈ Access to detailed information on individual students by inputting their student ID in the "Student Info" sheet.
βοΈ Course statistics by language and level, including the number of students enrolled, the average grade, and percentage of students receiving honors.
βοΈ Data visualization through various charts and graphs.
If you have any question, comments, or suggestions, do not hesitate to contact me (melisa.s.rossi@gmail.com).
