# Reference

## Examples

You will find sample CSV and Excel files inside the `tests/` folder.

## Data Processing

Identify Student
- Relate existing Students enrolled in the Course Period based on their Student ID, or Username, or First and Last Names.
- Student ID: exact match.
- Username: Comparison is done using lowercase and trimmed strings.
- First and Last Names: Comparison is done using lowercase and trimmed strings.

Assignments
- Relate existing Assignments (for a given teacher, course period and quarter) in RosarioSIS.
- Grades contained in the related columns are processed this way: comma `,` is converted to point `.` (decimal separator), and non numeric characters are stripped. Asterisk `*` grades / characters are kept, to excuse a student.
- Existing grades are updated.

## Options

- Import first row: check it if your file does not contain a header with column names.
