Goal 1. Learn how to create interactive charts with Google Chart Tools. 2. Learn how to connect Google Charts with online data sources. Requirements: Use Google Charts (JavaScript API) to visualize a data set of your choice. A few examples are listed below. Create a dashboard with at least three (3) charts and at least two (2) controls. 1. a. b. C. You don't have to visualize all the data in the spreadsheet. Select the columns that you find useful or interesting Write detailed comments in the code. Read the data directly from a Google Sheets. Don't manually enter the data in the code. Don't load data from a local file. i. If you have never used Google Sheets, here is a tutorial. There are plenty of other tutorials online. 2. Example data sets You may use one of the many data sets from (JSE) data archive. These data sets have been curated and cleaned up, so it can save you some time. Here are some examples. a. . Real estate plots (Look for woodardds at JSE web site for more details.) MLBattendance data (Look for MLBattendtxt at JSE web site for more details.) Used cars (Look for Kuiper xdis at JSE web site for more details.) .Pizza size (Look for pizzasize.txt at JSE web site for more details.) (Look for Northampton Housing Price at JSE web site for more details.) b. You want to choose a data set with many rows few columns, then you have limited choices in building your visualization. If it has too many rows, your visualization may be crowded Feel free to use other data sets. and columns. If there are to0 c. 3. for Read lecture notes on the course web site and specific options and data format requirements. Dashboards and controls are discussed here 4. This web page has information on JavaScript editing. testing, and debugging tools. Grading guidelines: Your program must work "out of the box. My TA or I will just copy and paste your code to jsbin.com (or another JavaScript playground site) to test your program. You can easily test it yourself. The program must meet all the requirements above. Points will be deducted for missing requirements . . .Points will be deducted if the program has no or very few comments. Late submissions may be accepted with the following conditions o lf it's 1 or 2 days late from the posted deadline, a 30% penalty will be imposed. In other words, the highest grade you will possibly get is 70 out of 100. lf it's 3 to 6 days late from the posted deadline, a 50% penalty will be imposed. In other words, the highest grade you will possibly get is