Skip to content
/ pycor Public

A Python project for automated homework marking via Excel

License

Notifications You must be signed in to change notification settings

Invisi/pycor

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

PyCor

What is this?

This project is for automated homework/exercise marking, based on Excel sheets.

It's achieved by checking an email inbox at a configured interval, comparing the file names of the submitted files to known code names[0], writing some submitted values and a student's matriculation number[1] into the corrector.xlsx and then comparing the generated values to the student's values.

This project was developed as part of my work at FH Aachen, after taking over maintenance of the earlier version by @davahue and @FlowCV.

[0] configured in a corrector.xlsx/.xlsm at B2
[1] may be used to generate different solutions per student

Deployment

Prerequisites

Since this project is based on Excel sheets and Windows's COM object interfaces, you will need an installation of Windows and Excel.

pip is part of the default Python installation on Windows, pipenv can be installed by running:

$ pip install pipenv

Installing

pipenv will take care of installing all needed Python dependencies, you just need to run the following.

$ pipenv sync

Afterwards copy/rename config.example.py to config.py and change values where necessary (a later rewrite might switch to .env via python-dotenv).

$ cp pycor/config.example.py pycor/config.py

The script can then be run via the following command and will check for new mails as defined by DELAY_SLEEP and compare the file names to the code names as defined in corrector.xlsx.

Usage

Pycor can then be run via pipenv run python -m pycor or simply python -m pycor after activating the virtual environment.

Contributors

  • Daniel B. Bung (@FlowCV) - Initiator of the project
  • Daniel Valero (@davahue) - Maintainer until 2018
  • Yannick Linke (@invisi) - Maintainer since 2018

About

A Python project for automated homework marking via Excel

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages