Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The goal of this lab is to create a dashboard in JavaFX summarizing a large dataset. For the first assignment, use the 2015 CSV file

The goal of this lab is to create a dashboard in JavaFX summarizing a large dataset. For the first assignment, use the 2015 CSV file for City of Vancouver property tax assessments:

http://data.vancouver.ca/datacatalogue/propertyTax.htm

Your dashboard should have displays for each of the following information:

Average property value and standard deviation for the entire data set.

Average house age and standard deviation for the entire data set.

Total house value change for the entire data set (current land value previous land value).

Count the number of Commercial, One Family and Multiple Family Dwelling for the entire data set.

The maximum value, minimum value, and number of homes with house value by increments of $25000. For example, this could be a table, bar chart, or pie chart, which shows the number of homes with value from (thousands) 100 125, 125-150, 150-175, 175-200, etc all the way to the maximum first bin or interval that has 0 (this should be somewhere in the millions..)

The user should be able to double-click on any of the displays for items 1-5 to drill down to show more detail on the calculation. The next level of detail should be a stage with a ListView by street name, and then double-clicking on a given item should open another stage showing the calculation by postal code. For example, double-clicking on the property value should show a display of property values by postal code. Double-clicking on a given postal code should then show the property values by street name.

Marks:

Property value and standard deviation are shown properly +2

House age and standard deviation are shown properly +2

House value change is shown properly +2

Number of property types are shown properly +2

House values histogram is shown properly +2

Double-clicking on items 1, 2, or 3 shows the calculation by street name, and then by postal code. +4

Create an HTML user guide with screenshots of your interface of where the professor should look to find the information for items 1-6. Also write 1 sentence explaining why you chose your chart type for displaying the information. +2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Modeling And Design

Authors: Toby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish

5th Edition

0123820200, 978-0123820204

Students also viewed these Databases questions