<?xml version="1.0"?>
<Main>
	<!------Student 1---------->
	<StudentId>1</name>
	<GroupLessonId>1</age>
	<ExamName>exam 1</ExamName>
	<ExamPeriod>1st sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>1</StudentGroupLessonId>	
	
	<StudentId>1</name>
	<GroupLessonId>1</age>
	<ExamName>exam 1</ExamName>
	<ExamPeriod>2nd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>1</StudentGroupLessonId>
	
	<StudentId>1</name>
	<GroupLessonId>1</age>
	<ExamName>exam 1</ExamName>
	<ExamPeriod>3rd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>1</StudentGroupLessonId>
	
	<StudentId>1</name>
	<GroupLessonId>1</age>
	<ExamName>exam 2</ExamName>
	<ExamPeriod>1st sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>1</StudentGroupLessonId>	
	
	<StudentId>1</name>
	<GroupLessonId>1</age>
	<ExamName>exam 2</ExamName>
	<ExamPeriod>2nd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>1</StudentGroupLessonId>
	
	<StudentId>1</name>
	<GroupLessonId>1</age>
	<ExamName>exam 2</ExamName>
	<ExamPeriod>3rd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>1</StudentGroupLessonId>
	
	<StudentId>1</name>
	<GroupLessonId>1</age>
	<ExamName>exam 3</ExamName>
	<ExamPeriod>1st sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>1</StudentGroupLessonId>	
	
	<StudentId>1</name>
	<GroupLessonId>1</age>
	<ExamName>exam 3</ExamName>
	<ExamPeriod>2nd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>1</StudentGroupLessonId>
	
	<StudentId>1</name>
	<GroupLessonId>1</age>
	<ExamName>exam 3</ExamName>
	<ExamPeriod>3rd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>1</StudentGroupLessonId>
	
	<StudentId>1</name>
	<GroupLessonId>2</age>
	<ExamName>exam 4</ExamName>
	<ExamPeriod>1st sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>2</StudentGroupLessonId>	
	
	<StudentId>1</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 4</ExamName>
	<ExamPeriod>2nd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>2</StudentGroupLessonId>
	
	<StudentId>1</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 4</ExamName>
	<ExamPeriod>3rd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>2</StudentGroupLessonId>
	
	<StudentId>1</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 4</ExamName>
	<ExamPeriod>4th sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>2</StudentGroupLessonId>
	
	<StudentId>1</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 2</ExamName>
	<ExamPeriod>1st sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>2</StudentGroupLessonId>	
	
	<StudentId>1</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 2</ExamName>
	<ExamPeriod>2nd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>2</StudentGroupLessonId>
	
	<StudentId>1</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 2</ExamName>
	<ExamPeriod>3rd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>2</StudentGroupLessonId>
	
	<StudentId>1</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 2</ExamName>
	<ExamPeriod>4th sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>2</StudentGroupLessonId>
	
	<StudentId>1</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 3</ExamName>
	<ExamPeriod>1st sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>2</StudentGroupLessonId>	
	
	<StudentId>1</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 3</ExamName>
	<ExamPeriod>2nd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>2</StudentGroupLessonId>
	
	<StudentId>1</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 3</ExamName>
	<ExamPeriod>3rd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>2</StudentGroupLessonId>
	
	<StudentId>1</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 3</ExamName>
	<ExamPeriod>4th sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>2</StudentGroupLessonId>
	<!------Student 2---------->
	<StudentId>2</StudentId>
	<GroupLessonId>1</GroupLessonId>
	<ExamName>exam 1</ExamName>
	<ExamPeriod>1st sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>3</StudentGroupLessonId>	
	
	<StudentId>2</StudentId>
	<GroupLessonId>1</GroupLessonId>
	<ExamName>exam 1</ExamName>
	<ExamPeriod>2nd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>3</StudentGroupLessonId>
	
	<StudentId>2</StudentId>
	<GroupLessonId>1</GroupLessonId>
	<ExamName>exam 1</ExamName>
	<ExamPeriod>3rd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>3</StudentGroupLessonId>
	
	<StudentId>2</StudentId>
	<GroupLessonId>1</GroupLessonId>
	<ExamName>exam 2</ExamName>
	<ExamPeriod>1st sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>3</StudentGroupLessonId>	
	
	<StudentId>2</StudentId>
	<GroupLessonId>1</GroupLessonId>
	<ExamName>exam 2</ExamName>
	<ExamPeriod>2nd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>3</StudentGroupLessonId>
	
	<StudentId>2</StudentId>
	<GroupLessonId>1</GroupLessonId>
	<ExamName>exam 2</ExamName>
	<ExamPeriod>3rd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>3</StudentGroupLessonId>
	
	<StudentId>2</StudentId>
	<GroupLessonId>1</GroupLessonId>
	<ExamName>exam 3</ExamName>
	<ExamPeriod>1st sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>3</StudentGroupLessonId>	
	
	<StudentId>2</StudentId>
	<GroupLessonId>1</GroupLessonId>
	<ExamName>exam 3</ExamName>
	<ExamPeriod>2nd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>3</StudentGroupLessonId>
	
	<StudentId>2</StudentId>
	<GroupLessonId>1</GroupLessonId>
	<ExamName>exam 3</ExamName>
	<ExamPeriod>3rd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>3</StudentGroupLessonId>
	
	<StudentId>2</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 4</ExamName>
	<ExamPeriod>1st sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>4</StudentGroupLessonId>	
	
	<StudentId>2</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 4</ExamName>
	<ExamPeriod>2nd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>4</StudentGroupLessonId>
	
	<StudentId>2</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 4</ExamName>
	<ExamPeriod>3rd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>4</StudentGroupLessonId>
	
	<StudentId>2</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 4</ExamName>
	<ExamPeriod>4th sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>4</StudentGroupLessonId>
	
	<StudentId>2</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 2</ExamName>
	<ExamPeriod>1st sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>4</StudentGroupLessonId>	
	
	<StudentId>2</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 2</ExamName>
	<ExamPeriod>2nd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>4</StudentGroupLessonId>
	
	<StudentId>2</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 2</ExamName>
	<ExamPeriod>3rd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>4</StudentGroupLessonId>
	
	<StudentId>2</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 2</ExamName>
	<ExamPeriod>4th sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>4</StudentGroupLessonId>
	
	<StudentId>2</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 3</ExamName>
	<ExamPeriod>1st sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>4</StudentGroupLessonId>	
	
	<StudentId>2</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 3</ExamName>
	<ExamPeriod>2nd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>A</Grade>
	<StudentGroupLessonId>4</StudentGroupLessonId>
	
	<StudentId>2</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 3</ExamName>
	<ExamPeriod>3rd sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>4</StudentGroupLessonId>
	
	<StudentId>2</StudentId>
	<GroupLessonId>2</GroupLessonId>
	<ExamName>exam 3</ExamName>
	<ExamPeriod>4th sem</ExamPeriod>
	<ExamSequence>1</ExamSequence>
	<Grade>B</Grade>
	<StudentGroupLessonId>4</StudentGroupLessonId>
</Main>

<Student>
	<Id>1</Id>
	<Lastname>Student 1</Lastname>
	<Firstname>Stud 1</Firstname>
	
	<Id>2</Id>
	<Lastname>Student 2</Lastname>
	<Firstname>Stud 2</Firstname>
</Student>

<GroupLesson>
	<Id>1</Id>
	<LessonName>Maths</LessonName>
	<TeachingGroupName>A1</TeachingGroupName>
	
	<Id>2</Id>
	<LessonName>Physical Education</LessonName>
	<TeachingGroupName>A1</TeachingGroupName>
</GroupLesson>


<GroupLesson>
	<Id>1</Id>
	<GroupLessonId>1</GroupLessonId>
	<StudentId>1</StudentId>
	
	<Id>2</Id>
	<GroupLessonId>2</GroupLessonId>
	<StudentId>1</StudentId>
	
	<Id>3</Id>
	<GroupLessonId>1</GroupLessonId>
	<StudentId>2</StudentId>
	
	<Id>4</Id>
	<GroupLessonId>2</GroupLessonId>
	<StudentId>2</StudentId>
</GroupLesson>

<Absences>
	<StudentId>1</StudentId>
	<Period>1st sem</Period>
	<Count>3</Count>
	
	<StudentId>1</StudentId>
	<Period>2nd sem</Period>
	<Count>2</Count>
	
	<StudentId>1</StudentId>
	<Period>3rd sem</Period>
	<Count>6</Count>
	
	<StudentId>2</StudentId>
	<Period>1st sem</Period>
	<Count>8</Count>
	
	<StudentId>2</StudentId>
	<Period>2nd sem</Period>
	<Count>1</Count>
	
	<StudentId>2</StudentId>
	<Period>3rd sem</Period>
	<Count>3</Count>
</Absences>