1. Compares an answer key to student responses on an exam that is composed of 150 questions, and generates a score (1 if student response matches the answer key and 0 otherwise.)
2.Computes the overall score for each student as a percentage.
3. Computes the overall score for each question.
4. Sorts the student scores
a. Numerically (by student ID)
b. Best to last (by score)
5. Sort the question scores
a. By question number
b. Hardest to easiest
Your final assignment is to take two variations of the certification exam (Form A and B) and their associated domains and recreate the 6 steps from above, plus two additional steps:
1.Merge the student responses to the question domains. Use the question domain to provide the student with a measure of how they performed in the five categories.
2. Merge the student’s overall score with the five domain scores. These domain scores help the student and their advisor to know the areas the student should work on to improve their overall score.
. You will submit a final report with two sections.
· A section of the student part of the report is sorted by student ID and includes the variables student ID, the exam form taken, overall score, overall percentage (in nnn.n% format), domain scores and percentages (Notice the order of the variables.)
· A section of the student part of the report is sorted by overall percentage (greatest to least) and includes the variables student ID, which exam form taken, overall percentage, overall score, percentages and domain scores (Notice the order of the variables.)
· A section of the student part of the report should contain a boxplot graph of the five domains using percentages as the response.
· A section of the question part of the report is sorted by exam form then by question number and includes the variables exam form, question number, and overall percentage. (Notice the order of the variables.)
· A section of the question part of the report is sorted by question overall percentage (easiest to hardest) and includes the variables question overall percentage, exam form, and question number. (Notice the order of the variables.)
Your code from the project steps should take you most of the way. Major additions are
1. More data. The Exam has two variations. Please note that the Form A data that is used in the final project is structured differently than the Form A data you used in your project steps. See note 2.
2.The answer key is imbedded in the student response file. You will need to create two data frames from the student response file (1) the answer key and (2) the student responses.
3. You will need to link questions to their respective domains, then aggregate student’s scores by domain. The domains are linked to questions within an exam form.
4. The necessity of combining the student results while not losing track of the exam form and the appropriate domain.
5. The creation of a graph.
6. Your project is submitted in two parts:
a. The report document with your student scores section and question section is submitted as a pdf.
b. The code is uploaded and submitted in a separate assignment from the report as either a word doc or pdf.
In order to receive full marks, check the following in your final report:
· All percentages should be formatted as nnn.n%.
· A single line from a table should not wrap onto anther line or a second page. For instance, in the first table of the student section, make sure all 14 variables for a given student fit on a single page.
· Add appropriate titles and labels to your tables, graphs, and sections.
· There should be no code in your project report. All code goes in the second document.
· Tables should be neat and orderly, and the variables should be easily identified.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
