SE10X grading script improvement
==
[Link to SE10x cheatsheet](https://hackmd.io/c/r1HrLuDtN/https%3A%2F%2Fhackmd.io%2Fh304Fn6ES0uJwcQb7e_LWA%3Fedit)
## Key outcomes
*What are the outcomes you want? (if this tool can now do xx, this is when we celebrate!)*
* [ ] **Reduce data capture processing time by xx**
* Minimize operations' task of manually re-triggering it
* What is the current processing time (per person)?
* ~1.5hr for 70 students (SE103 Jun2018)
* What step is taking the longest? Is it normal?
* Are there steps we can skip (redundant, unnecessary)?
* [ ] **Send individual student emails containing HR and Leetcode performance**
* Recipient list
* Send only to non-withdrawn participants
* Send only to those who have not received the email
* [ ] **Generate weekly summary for exec team**
* Data
* How do we summarize the data?
* What fields are needed? We should be able to toggle its use/non-use
* How do are thresholds indicated for each submission and overall?
* How to handle errors when the field is empty?
* Recipient list
* Dynamic and reusable (not hardcoded)
* We should be able to toggle its use/non-use
* Sending the email
* What is the report layout needed?
* How to connect to the mailer tool?
* Script should catch errors in name/email
* Send to the correct recipients
* Check for duplicates
* [ ] **Knowledge transfer to ops team**
* [x] Pre-training checklist
* [x] Overview of the submission manager script
* [x] Define key milestones
* [x] How do we know that they have understood the sessions?
## Timelines
* [x] Mar 18: Initial discussion of timelines
* [x] Mar 28: Gather pre-training checklist
* [x] Apr 1: Review and signoff from Tim and Nathan
* [x] Apr 1: Send README for SE10x ubmission Manager
* [x] Pre-requisites
* [x] Overall process
* [x] Airtable walkthrough
* [x] Apr 1: Investigate and list down [current script issues](https://hackmd.io/uII6O5hSTR2EilY1ScD-OQ?both)
* [x] Apr 5: Kickoff operations team's [pre-training checklist](https://hackmd.io/KpXLc38SRYKkx8EqLlx8Zg?view)
* [x] Apr 9: Complete pre-training tasks
* [x] Apr 9: Kickoff tutorials with Tim and Nathan
* [ ] xx - Milestone 1
* [ ] xx - Milestone 2
* [ ] xx - Milestone 3
## Who are involved?
* Anyone who is interested to learn scripting
* Pat
* Karen
* Elena
* Daphne
* Wouldn't this be too technical for everyone?
* Let them join first session and they can re-assess participation
{"metaMigratedAt":"2023-06-14T20:41:29.000Z","metaMigratedFrom":"Content","title":"SE10X grading script improvement","breaks":true,"contributors":"[{\"id\":\"809c1ba1-d414-41a6-bc5a-e046fe5d9b68\",\"add\":8849,\"del\":6376}]"}