## GRADEBOOK AND DASHBOARD REVISION
### GENERAL
- [Card](https://trello.com/c/8wgTUDj4)
- [ ] ask the new Ops members to walkthrough the gradebook after using it for maybe once or twice so that they will have an idea how it works.
- during onboarding, orient them how to use it and orienent them again after using it once or twice
### GRADEBOOK
- [ ] [Incomplete mark](https://trello.com/c/KRYZNEXi) - I remember we retained it as it will be our basis or a tie breaker for the students. This is what I've explained to everyone. Are we going to retain this or reflect the real status on the gradebook itself
- [ ] [Remove email address display](https://trello.com/c/2VKX1K4o) - can be easily done by changing the reference
- [ ] [All lookups should be via github](https://trello.com/c/JaU6chUE) - straightforward change and can be easily implemented
- [ ] [Attendance via zoom](https://trello.com/c/PE34omvV) - apply what is done in the remote courses
- [ ] [Raw attendance copied from attendance dashboard to have formula](https://trello.com/c/TlKGxK6n)
- [ ] add the formula instead of manually pasting > split text to column > and copying to the specific column
- [ ] Paste the data in Cell O4 and columns J and K should have formulas instead of manually pasting the split data
- 

- [ ] [ Missing Submissions + Attendance tab to have the dropdown option](https://trello.com/c/312cefTK) - will display both (all units + dropdown) as some Ops members prefer to have the other one
- Add the dropdown in this part
- [ ] [ Cell B10 from SET-UP tab should not be importranged but can be modified](https://trello.com/c/CMHHhDgi)
- change the reference from the importrange
- 
- [ ] [Submission Tracker Tab add student grading status](https://trello.com/c/dVxQM5Mo)
- Display "do not grade" or something if student already reached 3 missed submissions. Insert it below
- 

### DASHBOARD
- [ ] [Delete unused tab accomodated by platform updates](https://trello.com/c/yuqgsXqn)
- tabs suggested to be deleted
- High level dash - they said they haven't been using this
- Comp certs - not needed anymore since were not going to use Zapier
- Status - not used
- TF List
- Roster
- Discussion System
- Funnel
- Zoom Logins - to be placed in 1 pw

### [OLD DASHBOARD REVISIONS CARD](https://trello.com/c/gXdw1O2J/1929-kickoff-revision-of-on-campus-course-dashboards)
- [ ] Unit number should be based session dates not based on number of weeks it has passed from the start date
- update the unit number count by using `weeknum formula`. Same goes wit the withdrawal
- [ ] Improve high level dashboard -- based on Course Ops, they haven't been using this and this is one of the tabs they want removed -- is this still useful or we can remove this already since we we already have the at-risk dashboard