Assignments for April 3

Story for discussion

Data exercise: Using this CSV file from the Department of Education (you’ll need to change the .doc to .csv), I’d like you to answer the following questions using Access or sqlite. You’ll need to look at this file, which explains the database field names.

  1. How much money was spent on each Award Type?
  2. How much money went to 4-year public universities or colleges
  3. Which congressional district got the most in grants? Find out who represents that district.

About this entry