//Populating the total and average columns public void calculateTotalAndAverage(StudentDataForm sdf) { int totalMock1 = 0; int totalMock2 = 0; double valueAdded = 0; for (int i = 0; i < sdf.dgvStudentProgress.Rows.Count - 1; i++) { totalMock1 += int.Parse(dt.Rows[i][7].ToString()); totalMock2 += int.Parse(dt.Rows[i][9].ToString()); valueAdded += double.Parse(dt.Rows[i][11].ToString()); } sdf.txtTotalM1.Text = totalMock1.ToString(); sdf.txtTotalM2.Text = totalMock2.ToString(); //averages from data input double average = (totalMock1 / (sdf.dgvStudentProgress.Rows.Count - 1)); double average2 = (totalMock2 / (sdf.dgvStudentProgress.Rows.Count - 1)); sdf.txtAverageM1.Text = average.ToString(); sdf.txtAverageM2.Text = average2.ToString(); double avgVA = (valueAdded / (sdf.dgvStudentProgress.Rows.Count - 1)); sdf.txtAverageVA.Text = avgVA.ToString(); //Passing the average of the whole class through the algorithm DataAnalysis da = new DataAnalysis(); double averageGrade = da.progress8Mock1(Convert.ToInt32(average)); double averageGrade2 = da.progress8Mock2(Convert.ToInt32(average2)); sdf.txtAvgGM1.Text = averageGrade.ToString(); sdf.txtAvgGM2.Text = averageGrade2.ToString(); }
//works out the grades by passing the progress 8 scores through DataAnalysis class (grade boundaries) public void gradeWorkout(StudentDataForm sdf) { //Adding the grade to the mock result from DatAnalysis DataAnalysis mock = new DataAnalysis(); #region progress 8 conversions ------------- //new progress 8 measures conversions. for (int i = 0; i <= dt.Rows.Count - 1; i++) { //takes the value from the table and passes through mock 1 (2015 exam boundaries). double prog8 = mock.progress8Mock1(Convert.ToInt32(dt.Rows[i][7])); //takes the value from the table and passes through mock 2 (2016 exam boundaries). double prog82 = mock.progress8Mock2(Convert.ToInt32(dt.Rows[i][9])); //this adds the result into the datagrid. //I need to stop this from rounding sdf.dgvStudentProgress.Rows[i].Cells[8].Value = prog8; sdf.dgvStudentProgress.Rows[i].Cells[10].Value = prog82; //Distance travelled displayed and worked out. double totalDist = mock.distanceTravelled(prog8, prog82); sdf.dgvStudentProgress.Rows[i].Cells[11].Value = (totalDist - (Convert.ToInt32(dt.Rows[i][6]))); } #endregion }