Popular posts

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.