2. Advanced Functionality

Editing Data outside of the Software

The data created by the software can be edited by other database software supporting SQLite. I recommend DB Browser for SQLite.

Data Types

Names: string, must be unique within the database. IDs: Randomly generated 8 digit integers. Grade: Integer, must be between 9 and 12. CSA Level: String, must be None, Community, Service, or Achievement. CSA Hours: Float

Report Templates

Report templates can be customized to your liking by creating custom HTML and CSS. Do this at your own risk, however, as I cannot guarantee that the reports will work. Below is each template and the variables they use.

program_template_v2.html

• {{ total_students_enrolled }} - total students enrolled in program
• {{ total_overall_hours }} - sum of all student hours
• {{ total_students_none }} - count of students with no level
• {{ total_students_community }} - count of students with the Community level
• {{ total_students_service }} - count of students with the Service level
• {{ total_students_achievement }} - count of students with the Achievement level
• {{ total_hours_none }} - Sum of hours completed by students with no level.
• {{ total_hours_community }} - Sum of hours completed by students with the Community level.
• {{ total_hours_service }} - Sum of hours completed by students with the Service level.
• {{ total_hours_achievement }} - Sum of hours completed by students with the Achievement level.
• {{ total_hours_above_none }} - Amount of hours completed beyond requirement for students with no level, but not enough for Community.
• {{ total_hours_above_community }} - Amount of hours completed after obtaining the Community level, but before obtaining the Service level.
• {{ total_hours_above_service }} - Amount of hours completed after obtaining the Service level, but before obtaining the Achievement level.
• {{ total_hours_above_achievement }} - Amount of hours completed after obtaining the Achievement level.

student_template_v2.html

• {{ name }} - Student name
• {{ grade }} - Student grade
• {{ student_id }} - Student ID
• {{ csa_hours }} - CSA hours completed
• {{ csa_level }} = CSA Level completed
• {{ rem_hours }} = Hours to next CSA level. Displays Finished! if no next level.