You just finished teaching your first PSYCH 248 lab section, and it’s time to calculate the grades. Your wonderful teaching assistant created an Excel file with all of the students’ exam grades, homework grade, and lab grade as well as their gender. Your next steps are to calculate each student’s final grade, convert those scores to letter grades, and describe the distribution of scores.   Data Management Steps:

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Background: You just finished teaching your first PSYCH 248 lab section, and it’s time to calculate the grades. Your wonderful teaching assistant created an Excel file with all of the students’ exam grades, homework grade, and lab grade as well as their gender. Your next steps are to calculate each student’s final grade, convert those scores to letter grades, and describe the distribution of scores.

 

Data Management Steps:

1. Download the CA1_Dataset.csv file from Blackboard.
 
2. In Excel, calculate the final Number Grade, Letter Grade, and Z-score for each student.
a. To calculate the Number Grade, type a numerical equation after an = sign in a cell or use the =AVERAGE() formula; however, keep in mind that the =AVERAGE() formula will always give you the regular mean, not the weighted mean. Grades for this course are comprised of three parts: lecture exams (60%), homework (20%), and lab (20%).
 
b. To calculate the Letter Grade, use the =IF() formulawith a series of logic statements or enter the data by hand. For this assignment, let’s convert Number Grade into Letter Grade using the following rubric: A (90-100), B (80-89), C (70-79), D (60-69), F (<60).
c. To calculate the Z-score, use the =STANDARDIZE() formula on the Number Grade variable. This formularequires three components: x (i.e., one student’sNumber Grade), the sample mean, and the sample standard deviation. You can calculate the sample mean and standard deviation for Number Grade using the =AVERAGE() and =STDEV() formulas.
i. Create a new column called Abs(Z-score). In this column, use the =ABS() formula on the Z-score variable you just created to get the absolute values of each Z-score.
 
3. Now that you have filled in your dataset, save your file and open it in JASP.
a. In the Data View, apply value labels to the Gender variable by clicking on the title of the column and entering the labels accordingly (0=Woman, 1=Man).
b. Make sure that each variable has the correct “column type” (i.e., nominal, ordinal, or scalar).
 
 
 
5. Frequencies
a. How many women were in the class?
b. Paste the frequency table that shows this data below.
 
6. Percentages
a. What percentage of the class identified as men?
b. How is the Valid Percent column different from the Percent column?
 
7. Distribution Plots
a. For the Number Grade variable, create a Distribution Plot and apply a density curve. Paste the graph below.
b. Does this plot appear to be fairly normal?
 
8. Normality/Skewness
a. What is the skewness value for the Number Grade variable?
b. Does this mean the distribution of Number Grades is normal or skewed? Why?
The table below presents a dataset featuring student information and their academic performance. 

Columns include:

1. **ID Number**: Unique identifier for each student.
2. **Gender**: Denoted as 0 for women and 1 for men.
3. **Exam 1, Exam 2, Exam 3**: Scores for three different exams.
4. **Homework**: Homework scores for each student.
5. **Lab**: Lab work scores for each student.
6. **Number Grade**: Overall numerical grade.
7. **Letter Grade**: Not displayed here.
8. **Z-Score**: Not displayed here.

Each row represents a separate student's data entry. The table provides a comprehensive snapshot of individual exam performances, homework, lab scores, and overall grades which could be useful for educational analysis and assessments.
Transcribed Image Text:The table below presents a dataset featuring student information and their academic performance. Columns include: 1. **ID Number**: Unique identifier for each student. 2. **Gender**: Denoted as 0 for women and 1 for men. 3. **Exam 1, Exam 2, Exam 3**: Scores for three different exams. 4. **Homework**: Homework scores for each student. 5. **Lab**: Lab work scores for each student. 6. **Number Grade**: Overall numerical grade. 7. **Letter Grade**: Not displayed here. 8. **Z-Score**: Not displayed here. Each row represents a separate student's data entry. The table provides a comprehensive snapshot of individual exam performances, homework, lab scores, and overall grades which could be useful for educational analysis and assessments.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman