This function picks an email from an array of students who submitted assignments and checks for a match in the array containing all students' emails while traversing. Once found, it deletes the email from the array (all students email array). At the end of the loop, the emails of students who did not submit will remain and the function returns an array containing their emails, the number of students who submitted, and the number of students who didn't. 😁😁😁 Not the best of solutions but it was fun giving it a try.

This is really an interesting challenge, it did take some thinking. so here's my answer.

const studentsData = async function () {
  const allStudent = await fetch("all-student.txt").then((res) => res.text());
  const studentsSubmitted = await fetch("students-submitted.txt").then((res) =>
    res.text()
  );

  const allStudentArr = allStudent.split("\n");
  const studentsSubmittedArr = studentsSubmitted.split("\n");

  const studentsNotSubmitted = allStudentArr.filter(
    (students) => !studentsSubmittedArr.includes(students)
  );

  console.log(allStudentArr, "all students");
  console.log(studentsSubmittedArr, "students that submitted");
  console.log(studentsNotSubmitted, "students who didn't submit");

  console.log(
    `Students who turned in there assignments are ${studentsSubmittedArr.length}, while ${studentsNotSubmitted.length} students didn't submit`
  );
  console.log(
    `Total number of students are ${
      studentsSubmittedArr.length + studentsNotSubmitted.length
    }`
  );
};

studentsData();

Here's how I went about it

First I converted the google sheet files to text (txt) files so that they can be readable in a JavaScript file.

Both file names are:

all-student.txt
students-submitted.txt

Then I declared an asynchronous function called studentsData, which is responsible for handling all data fetching and doing all calculations.

Since both, all students data and does students that submitted are given I used the snippets shown below to get the text files as strings into my script file.

  const allStudent = await fetch("all-student.txt").then((res) => res.text());
  const studentsSubmitted = await fetch("students-submitted.txt").then((res) =>
    res.text()
  );

Note the use of res.text(), this is because it's a text file the script is reading.

If you should log allStudent and studentsSubmitted variables to the console, the data shown will be similar to the below picture:

The above image is in a string type which isn't needed, so I converted it to an array for both allStudent and studentsSubmitted variables making use of the split("\n") method.

"\n" denotes new line also read about the split method here

 const allStudentArr = allStudent.split("\n");
 const studentsSubmittedArr = studentsSubmitted.split("\n");

Now for the final step, I filter through the array of allStudentArr (all students email) checking if students that submitted their assignment are in the all students array.

If the above statement is true, then return the remaining students for the all students array.

By doing this I got all the answers for the task.

const studentsNotSubmitted = allStudentArr.filter(
    (students) => !studentsSubmittedArr.includes(students)
  );

Behind the scene I did Google some things, like

• making use of the split method (I knew there was a way to convert strings to an array, but I couldn't remember)
• writing an async function that reads text files (initially I just used the fetch method separately which wouldn't have worked)

That's it, I enjoyed working on the challenge.

The function receives both emails as string inputs. It checks emails in the general emails string that are not contained in the emails of those that submitted the assignment by utilizing the filter function. The emails are also converted to small letters in case there is a mix of cases.

It is expected that the file is downloaded in CSV (character-separated values) and the strings copied as inputs to the function.