← Back to projects
プレミアム · 7 days to submit
UFO Hunter Dashboard
Turn thousands of UFO sightings into a dashboard with a drop-down menu and charts.
This project is not translated into your language yet: the instructions stay in English.
The UFO dashboard project walks you through the process of taking a large data file and turning it into a usable Excel dashboard, complete with graphs and drop-down menu selections. The dashboard shows the number of UFO sightings over time from around the United States.
Premium project
Log in or create an account to start a project and follow your progress.
How you are graded
Each project is graded out of 100; you need 70 points to pass. Some criteria are checked automatically in your workbook, the rest are judged by the AI.
- Day of the week and year columnsAutomaticColumns E and F of the data sheet hold TEXT and YEAR formulas for every sighting.10 pts
- Dashboard sheetAutomaticA worksheet named "Dashboard" exists.5 pts
- List of shapesAutomaticColumn K lists each shape once, with "All" at the top.10 pts
- Shape drop-downAutomaticCell D2 of the dashboard has a drop-down list fed by the list of shapes.10 pts
- COUNTIFS tablesAutomaticCOUNTIFS formulas count the sightings by state, by day of the week and by year.15 pts
- The "All" option worksAutomaticThe COUNTIFS are wrapped in an IF that handles "All".10 pts
- ChartsAutomaticA map or bar chart for states, a bar chart for days and a scatter plot for years.10 pts
- Dashboard layoutAutomaticNarrow margin columns and regular data columns, as in the instructions.10 pts
- Look and clarityAITitle, colors, readable charts and a dashboard a boss could use.20 pts