CASchoolsThis study focuses on analyzing the performance of various elementary schools in school districts across different counties based on several factors such as socio-economic conditions, resources available, and student demographics.
The data encompasses 420 schools in California with the following details:
School Name
County
Grades (Students’ grade)
Student Enrollment (Number of students)
Number of Teachers
Percentage Qualified for Calworks (income assistance program)
Percentage Qualified for Lunch (Lunch program for low income students)
Number of Computers
Expenditure per Student (in USD)
Average Income (District’s Average Income)
Percentage of English Learners
Average Reading Score
Average Math Score
You have been asked to:
Compare student performance (read and math scores) across different schools.
Understand the relationship between resources (teachers, computers, expenditure) and student performance.
Examine the impact of socio-economic factors (income, Calworks, lunch) on student performance.
You will be performing various analysis using Excel, follow the prompt and answer the questions below.
Leave a Reply