Skip to content

mathcoder3141/LA-Code-Test

Repository files navigation

Following are the CSV Data sets are as follows:

  1. UsersDumpForCodeTest.csv
    1. Fields: UserID, country, certifications
    2. Description: This data set contains information on countries and certifications associated with the user. UserId uniquely identifies the user.
  2. AssessmentScoreForCodeTest.csv
    1. Fields: TestId, UserId, assessment_name, score
    2. Description: This data set contains scores for assessments(tests) that the user has taken. TestID uniquely identifies the test that the user has taken.
  3. UserSurveyResultsForCodeTest.csv
    1. Fields: TestID, question, answer
    2. Description: Surveys are presented to users after they finish taking the test. A survey consists of a collection of questions and answers. And a survey is tied to a TestID.
  4. AssessmentRealTimeEventsForCodeTest.csv
    1. Fields: TestID, assessmentname, eventcode, timestamp
    2. Description: While the user is taking an assessment(test) , real time events are collected which represent the various stages of a test. Following are the event codes:
      1. STRASMNT: When the user chooses to start the assessment
      2. RDYASMNT: When the assessment environment is loaded and ready for the student to work on it
      3. GRDDOM: Grades a domain (sub-section) of an assessment
      4. GRDASMNT: Grades the entire assessment
      5. VIEWASMTDIAG: When the student views a diagram-hint on the assessment
      6. VIEWASMTGRADINGHINT: When the student views a grading-hint
      7. CANCASMNT: When the user selected to cancel the assessment
      8. ABNDNASMNT: When the user never completes the assessment or walks out/abandons the assessment.
      9. CMPLASMNT: When the assessment is complete
My tasks were:
  1. Analyze these data sets and present your analysis. This is an open ended task to exercise your creativity.
  2. Find the average time taken to complete an assessment, group by assessment name.
  3. Generate a list of users that fit the following criteria:
    1. Got 80% or above on an assessment.
    2. Had a 100% chance of referring a friend.
    3. Is based in the USA.
    4. Has received AWS certifications.
    5. Sort by test scores and most taken assessments first.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published