State Test Data Dive (Fictitious)

As a science instructor our goal is to ensure that all students meet their learning goals. In the case meeting their goal means, achieving or exceeding projected state test scores.

This analysis compares state projected scores and actual scores in order to determine trends in test results.

The following procedure was use to assess data.

MySQL:

• Join data sets
• Perform basic calculations
• Filter results
• Clean data

Excel:

• Aggregate data
• Verify calculations
• Clean data
• Data Validation
• Vlookup

Tableau:

• Filter and sort date
• Join data sets
• Create visualizations

****All data has been anonymized and randomized to ensure confidentiality. This is a fictitious version of the actual data dive report. This is not a representation of actual student results or class performance. All data was created for the purpose of demonstrating analytical technics and skills. A real analysis was conducted but not distributed.