In this assignment you will work with loading data from a csv file into a mongodb and then building a web application that will let the user make queries of the data set. The data is an open data set measuring student test performance.

Skeleton

The skeleton for this project is in my public git file at https://gitlab.csi.miamioh.edu/campbest/cse270ecampbest-public (https://gitlab.csi.miamioh.edu/campbest/cse270e-campbest-public) . I suggest you clone this to your ubuntu instance (not in your working directory but under /home/ubuntu) and the copy the files to your own repository working copy.

Load the data

Create a new mongodb called StudentPerformanceData using the mongo cli.

1. Copy over the skeleton Assignment-13 directory to your working copy.
2. In Assignment-13 the data is in a folder called data.
3. Inside this directory download the file StudentPerformanceData.csv
4. Using the mongoose schema module, create a nodejs program called loadData.js that will read in the StudentPerformanceData.csv and populate the mongodb. Here is the schema that I used: var studentDataSchema = new mongoose.Schema({ gender: String, race: String, parentEducation: String, lunch: String, testPrep: String, math: String, reading: String, writing: String });

5. FYI: You will need to read in the file using the npm module file and I also used the npm module csv to parse the csv record.

Complete the Data Model for the express applica on

1. Look over the express code and see how the data model is used. The name of the exported functions

(which all return promises) are at the end of the file data/StudentDataModel.js

2. A data model is simply a js program that handles all interactions with the data. The functions in this program will be called by express to get and populate the various data elements for the Express application.
   1. You will be building a node module, so all functions you want to make available to world will need to be exported via the exports (https://www.sitepoint.com/understanding-module-exports-exportsnode-js/)
   2. All mongodb calls should be via the mongoose module
   3. Functions that you will need to create are: Remember these functions will use a callback to return the actual data.
   4. addStudent(record)
      1. this method will add a record to the mongodb
      2. close
      3. close the mongodb connection
   5. clear
   6. Calls the mongodb drop function to clear out existing records
   7. getStats
      1. This method will return a datastructure will all the statistics the view is looking to display. I used a whole series of awaits to get each statistic. This method takes in 3 parameters, math, reading and writing and uses the query to select only those records whose scores are greater than the input values.
      2. Use the mongo query logic (https://docs.mongcom/manual/reference/operator/query/) :

When done the existing express code should work with your datamodel. I dont believe you should have to modify any of the app.js or view code.