Final Project

Final Project: Building a Data Dashboard

Finding a way that works for you to aggregate all the data you need and look at it in different ways can be a huge help to counselors or anyone who works with data every day.

For your final project, use the Google Sheet below to build a data dashboard that will work for you. It is suggested that you work with a partner or as a team as you go through the process.

Sample Worksheet: Credit: School Counselors in Dorchester, SC

• Look at the tabs. Which ones do you need? Which ones need to be deleted? Which ones do you need to add?

• Data validation has been let in the top two rows as an example. What do you need to change? To add? Remember that if several people are sharing this datasheet, data validation becomes very important so that data will remain consistent. NOTE: Data validation is only entered in the fields needed- not down the entire column. It makes the spreadsheet get too large to load and manipulate easily.

• How will you copy your data from other worksheets and link it to this worksheet?

• How will you use Vlookup to manipulate this data?

• How will you use filtering to look at this data?

• How can you use pivot tables to look at this data in different ways?

• Which formulas can help you look at this data?

If you're interested in creating your own dashboard, watch this video and give it a try!

Creating Dashboards in Google Sheets