AD-StudentManagement

Development of a simple Active Directory - Student Management System in Python for teaching purposes. It is assumed that a pupil is exactly in one school class.

Supports

• Import of students with their classes from csv file
• Removal of former students and classes

Includes:

• Simple CLI based UI
• VBScripts for installing prerequisits on file server and domain controller

Installation

1. Install a Windows Domain Controller and if required a file server and a Windows Client
2. Install Python on the computer on which you want to run this student management software.
3. Download and unzip or clone the software from Github.
4. Navigate to downloaded and unzipped or cloned folder
5. Use the package manager [pip](https://pip.pypa.io/en/stable/) to install requirements.

   pip install -r requirements.txt

6. Copy or rename settings-template.py to settings.py and enter the appropriate data of your domain.
7. Edit VBScript vbScripts\installPrerequisitesDC.vbs, specify your domain name and run the script as the domain administrator on the domain controller.
8. Run VBScript vbScripts\installPrerequisitesFS.vbs as the domain administrator on the file server.
9. Edit students login VBScript vbScripts\studentsLogon.vbs, specify your domain and your file server names.
10. Create GPO StudentsLogonPolicy on OU Students.
• Edit this GPO, navigate to User Configuration > Policies > Windows Settings > Scripts (Logon/Logoff)
• Double-click Logon in the right pane and click Show files. A folder whose name ends in User\Scripts\Logon\ is displayed.
• Copy your logon script files into this folder.
• In the Logon Properties window, click Add.
• Click Browse to open the logon script directory, then select your logon script file and click OK.
• Verify that the logon script now appears in the list on the Logon Properties window.
• Close the Group Policy Management Editor window for your GPO, then close the Group Policy Management window.

Program start

python importStudents.py [path to csv import file]

Example:

python importStudents.py import/students.csv

Testing

Start the test program with unit tests

testImportStudents.py

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

Please make sure to update tests as appropriate.

License

MIT