---
# System prepended metadata

title: Untitled

---

## 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
     -   ![](https://i.imgur.com/PG4EWUx.png)

 - [ ] [ 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 
![](https://i.imgur.com/niAk8XO.png)
 - [ ] [ 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
     - ![](https://i.imgur.com/TlpXceq.png)
 - [ ] [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     
         - ![](https://i.imgur.com/lmA8OOU.png)




### 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
        

