How to create a dashboard

1. Create a visual report and edit the current google sheet.
2. In your google spreadsheet file, list all the spreadsheet urls you will access in your sources tab.

• Note that even your source are from the same spreadsheet, tabs has their own gid so the urls are still not the same.

3. In your report page1, list all the column that you will need in the dashboard.
4. Give each row a proper score_type to group the same type of assignments together.
5. For the leaderboard visualization, you will need to give a number in column params to tell how many students to be displayed.