Scrapes the various Foundations Course site profiles for each student and calculates how much each student has completed.
- Python 3.6+
- Chrome
- pipenv (
brew install pipenv
)
- Install the geckodriver with the following command. It can also be installed via
pip
if you're an unfortunate Windows user.brew install geckodriver
- Install the Chrome Driver by visiting the downloads web page and downloading the latest stable release. Once you have it downloaded, decompress the archive and move the resulting file to a directory that is on your path.
pipenv install
to create the virtual environment and get packages installed.pipenv shell
to activate environment- Open the
students.tsv
file. - Copy pasta the students you need from the Foundations Course Student Registration (Responses) spreadsheet. Copy columns B-F.
python main.py
to start the process.- When the program completes, there will be a
scores.csv
file created. Open that file. - Copy pasta the contents into your cohort spreadsheet.
- As soon as you paste, a clipboard icon will appear in the lower-right hand corner of the data. Click that and choose "Split text into columns".