This Python script is designed to process Excel files related to student assessments, calculate scores, and export data in a formatted CSV file for a campus interface. It includes functionality to enter questions for credit, update student scores, and generate a CSV file for campus integration.
Please use this link to install Python on Windows: https://phoenixnap.com/kb/how-to-install-python-3-windows
Please use this link to install Python on MacOS: https://www.dataquest.io/blog/installing-python-on-mac/
The script also requires the following Python packages:
- pandas
- numpy
- openpyxl
- xlrd
You can install these packages by running:
pip install pandas numpy openpyxl xlrd
or you can install these packages by simply running the update_score.py file.
-
Navigate to the directory where the update_score.py is located.
-
Run the script.
python script_name.py
- Follow the on-screen menu to perform different actions.
-
Enter Questions for Credit: You can input questions, correct answers, and point values.
-
Update Student Scores: Updates student scores based on the entered questions for credit.
-
Create Formatted File for Campus Interface: Generates a formatted CSV file for campus integration.
-
Print Question Analysis: Print Detail Question Analysis data on the console.
-
Exit: Exits the script.
Ensure that your Excel files are placed in the assets
folder, and adjust the file paths in the script accordingly.
DetailQuestionAnalysis (22).xlsx
for detailed question analysis.
AssessmentID Proctored Assessment CSV Export (11).xls'
for assessment data.
The updated CSV file will be exported in the output
folder.
If you encounter any issues or have questions, feel free to contact me or sajid through our emails:[email protected]
or [email protected]