Educational Data
Visualization Project

Louisiana State University
Math 4020

Project Background

Solution: Create a user-friendly website to be able to view and compare school data in an easy an meaningful way that requires no background in data analysis

Project Goals

Step 1: Inventory

Where can we find the data?

What data is availible?

NCES and La believes web views

NCES and La believes web views

Step 2: Cleaning Data

What does this mean?

Why is this necessary?

Script solution

Merging Data Sets

from T4!$ to (,this)

Step 3: Analysis

Need to analyze the data to provide meaningful numbers and graphs

The EOC Scores (Algebra, Geometry, US History, etc.) are given with % Excellent, Good, Fair, and Needs Improvement

How do you graph 4 numbers for each school in a meaningful way?

Solution: One number summary

Step 3: Analysis (Cont.)

One Number Summary

  1. Proposal:
    1.5(%Ex) + %Good = [0, 150] (related to school performance score calculation)
  2. Proposal:
    1.5(%Ex) + %Good + .5(%Fair) = [0, 150]
  3. Proposal:
    	      		a(%Ex) + b(%Good) + c(%Fair) + (1-a-b-c)(%NI)
    Where a, b, c satisfy some optimality condition
    Fact: a ≈ 0.8, b ≈ 0.3, c ≈ 0.2, d ≈ -0.3 is not far from optimal
  4. Proposal:
          			The function should be our best estimate of the mean of the actual class data
    µ in (µ,σ) that minimizes X²
    Maximum likelihood

Algebra 2014-2015 Scores

y= %Excellent

x= Estimated Mean

Algebra 2014-2015 Scores

y= (1.5)(% Excellent) + % Good

x= Estimated Mean

Algebra 2014-2015 Scores

y= (0.8)(% Excellent) + (0.3)(% Good) + (0.2)(% Fair)+ (-0.3)(% Needs Im.)

x= Estimated Mean

The same trend, other subjects

(Shown here is Geometry 2014 – 2015)

The same trend, other subjects

(Shown here is Geometry 2014 – 2015)

The same trend, other subjects

(Shown here is Geometry 2014 – 2015)

Step 4: Presentation

Where can we find the data?

R Studio Example

Shiny Example

Step 4: Presentation Cont.

GUI BrainStorming

Presentation Cont.

What graphical representation should we use?

Radar chart and line graph were examples of possible ways to visualize test scores

Working Demo

Are we Done Yet?

What will the project do?

What we hope it accomplishes

FIN

Thank You

/