THE HOMEWORK: 1. Create a Student Profile Data about Colleges from the U.S. Department of Education ...
THE HOMEWORK: 1. Create a Student Profile Data about Colleges from the U.S. Department of Education ? Already done! You have Alex Chen's full profile already. You don't need to create another one unless your professor specifically asks. Alex Chen is the student you are working for. 2. Design a Tableau Dashboard to Help Alex Choose Colleges You will use College Scorecard data to build an interactive dashboard. The dashboard’s goal: help Alex find colleges that fit his profile. But you cannot do everything from his profile — so choose a few important elements. Examples of important elements from Alex's profile you could pick: Element from Alex's profile How to represent it in Tableau (with College Scorecard data) Strong Computer Science/Engineering Filter for schools that offer Computer Science degrees (major: CIP codes) Good Financial Aid Use Average Net Price (lower = better aid) or Percentage Receiving Aid Location near Tech Hubs Focus on states like CA, NY, MA, WA (Seattle, SF, Boston, etc.) Good Internship/Employment Outcomes Use Median Earnings after Graduation (higher = better) Diversity Use % of students of different ethnic backgrounds Medium to Large Universities Use Enrollment size (say > 5,000 students) ???? You must select 3-4 of these elements to focus on. (not all!) 3. Build the Dashboard in Tableau Here’s the step-by-step inside Tableau: a) Import College Scorecard Data Open Tableau Click Data ? Connect to a file ? upload the College Scorecard CSV. b) Choose Key Fields (dimensions and measures) Examples: Name of school (INSTNM) State (STABBR) Average Net Price (NPT4_PUB or NPT4_PRIV) Median Earnings 2 years after entry (MD_EARN_WNE_P10) Undergraduate Enrollment (UGDS) % Receiving Federal Aid (PCTPELL, PCTFLOAN) Fields related to Computer Science majors (CIP codes: 11 for CS) c) Create Filters or Parameters Location filter: only show schools in certain states (CA, WA, MA, etc.) Average Net Price filter: show only affordable schools (customizable) Enrollment filter: show only medium to large schools (UGDS > 5,000) Major/Program filter: highlight CS programs if possible (based on available data) d) Build Visuals Map of the USA showing where schools are Bar charts ranking schools by Median Earnings or Net Price Filters on the side (state, price range, enrollment size) e) Put everything together in one or more Dashboards Title: "College Search for Alex Chen" Organize visuals clearly Add filters that Alex can use to narrow down. f) (Optional but good!) Create a Story A Story = a sequence of dashboards. Example: Page 1 = Location filter ? Page 2 = Financial Aid ? Page 3 = Career Outcomes. 4. Write a Short PDF Explaining Your Dashboard You must write 2 parts: a) How to use the dashboard (Instructions) Example: "Use the filters on the right to select states." "Adjust the Average Net Price slider to find affordable colleges." "Click on a school name to see more details about earnings and enrollment." b) Why you made these choices (Justification) Explain briefly: Why you focused on location, financial aid, CS programs, size, etc. Why these are important for Alex’s goals (computer science career, financial concerns, etc.) Why you didn’t include everything in the profile (limits of the data). 5. Turn In Two Files ? A packaged Tableau file (.twbx) ? A PDF with your dashboard explanation Quick Summary Checklist ???? Step What to Do Done? 1 Use Alex Chen’s profile ? 2 Choose 3-4 important factors ? 3 Build Tableau visuals and dashboard ???? 4 Write a PDF (Instructions + Justification) ???? 5 Submit Tableau + PDF ???? IMPORTANT: I already did the assignment I'm gonna send it to you I just need a correction. The feedback of the professor is:Your verbal description refers to some of the right ideas, but I don't understand your graphics at all. In particular, it's not clear how they would help anyone to narrow their college search to a particular list of schools. The problem is that none of the graphics allow the user to identify particular schools. They show aggregates of various measures over different categories of schools, but the schools themselves are hidden in the aggregates. I also don't see any interactive features--sliders, drop-down menus, dashboard actions, etc. This submission, unfortunately, largely misses the mark on the assignment. As a general rule, I would suggest rereading the assignment statement carefully before submitting. Of course, you are also responsible for following the guidance I give in class.
