//Cluster 1-3 String Value
private static String getCluster1and2StringGrade1(String Subject1, String Subject2, String Subject3, String Level, String StudentId, List <FinalComp> listGrades)
{
return("[" + "(" + getValue(Subject1, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject1) + ") + " +
"(" + getValue(Subject2, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject2) + ") + " +
"(" + getValue(Subject3, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject3) + ")" +
"]/" + (SubjectUnit.getWeight(Level, Subject1) + SubjectUnit.getWeight(Level, Subject2) + SubjectUnit.getWeight(Level, Subject3)));
}
public static void HS1And2(DataTable HonorsTable, int termPeriod, String StudentId, String Level)
{
DataRow drow = HonorsTable.NewRow();
drow["Cluster1Format"] = "[(Math*" + SubjectUnit.getWeight(Level, "MATH") + ") + (Science*" + SubjectUnit.getWeight(Level, "SCIE") + ") + English*" + SubjectUnit.getWeight(Level, "ENGL") + "]/" + (SubjectUnit.getWeight(Level, "MATH") + SubjectUnit.getWeight(Level, "SCIE") + SubjectUnit.getWeight(Level, "ENGL"));
drow["Cluster2Format"] = "[(SLGE*" + SubjectUnit.getWeight(Level, "SLGE") + ") + (Acctg*" + SubjectUnit.getWeight(Level, "BUSI") + ") + (Computer*" + SubjectUnit.getWeight(Level, "COMP") + ")]/" + (SubjectUnit.getWeight(Level, "SLGE") + SubjectUnit.getWeight(Level, "BUSI") + SubjectUnit.getWeight(Level, "COMP"));
if (termPeriod.Equals(1))
{
if (Level.Equals("HS I"))
{
drow["Cluster3Format"] = "[(PE*" + SubjectUnit.getWeight(Level, "PHED") + ") + (RVED*" + SubjectUnit.getWeight(Level, "RVED") + ") + (HE*" + SubjectUnit.getWeight(Level, "HOME") + ") + (Music*" + SubjectUnit.getWeight(Level, "MUSI") + ") ]/" + (SubjectUnit.getWeight(Level, "PHED") + SubjectUnit.getWeight(Level, "RVED") + SubjectUnit.getWeight(Level, "HOME") + SubjectUnit.getWeight(Level, "MUSI"));
}
else
{
drow["Cluster3Format"] = "[(PE*" + SubjectUnit.getWeight(Level, "PHED") + ") + (RVED*" + SubjectUnit.getWeight(Level, "RVED") + ") + (Music*" + SubjectUnit.getWeight(Level, "MUSI") + ") ]/" + (SubjectUnit.getWeight(Level, "PHED") + SubjectUnit.getWeight(Level, "RVED") + SubjectUnit.getWeight(Level, "MUSI"));
}
}
if (termPeriod.Equals(2))
{
drow["Cluster3Format"] = "[(PE*" + SubjectUnit.getWeight(Level, "PHED") + ") + (RVED*" + SubjectUnit.getWeight(Level, "RVED") + ") + (HE*" + SubjectUnit.getWeight(Level, "HOME") + ") + (Art*" + SubjectUnit.getWeight(Level, "ARTS") + ") ]/" + (SubjectUnit.getWeight(Level, "PHED") + SubjectUnit.getWeight(Level, "RVED") + SubjectUnit.getWeight(Level, "HOME") + SubjectUnit.getWeight(Level, "ARTS"));
}
if (termPeriod.Equals(3))
{
drow["Cluster3Format"] = "[(PE*" + SubjectUnit.getWeight(Level, "PHED") + ") + (RVED*" + SubjectUnit.getWeight(Level, "RVED") + ") + (HE*" + SubjectUnit.getWeight(Level, "HOME") + ") + (Art*" + SubjectUnit.getWeight(Level, "ARTS") + ") ]/" + (SubjectUnit.getWeight(Level, "PHED") + SubjectUnit.getWeight(Level, "RVED") + SubjectUnit.getWeight(Level, "HOME") + SubjectUnit.getWeight(Level, "ARTS"));
}
drow["StudentId"] = StudentId;
HonorsTable.Rows.Add(drow);
}
//Cluster 1-3 Numeric Value
private static Double getCluster1and2NumericGrade1and2(String Subject1, String Subject2, String Subject3, String Level, String StudentId, List <FinalComp> listGrades)
{
return(Math.Round(((getValue(Subject1, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject1)) +
(getValue(Subject2, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject2)) +
(getValue(Subject3, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject3)))
/ (SubjectUnit.getWeight(Level, Subject1) + SubjectUnit.getWeight(Level, Subject2) + SubjectUnit.getWeight(Level, Subject3)), 3));
}
private static Double getCluster3Numeric(String Subject1, String Subject2, String Subject3, String Subject4, String Subject5, String Level, String StudentId, List <FinalComp> listGrades, int termPeriod)
{
if (Level.Equals("Grade 1") || Level.Equals("Grade 2"))
{
if (termPeriod.Equals(3))
{
return(Math.Round(((getValue(Subject1, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject1)))
/ (SubjectUnit.getWeight(Level, Subject1)), 3));
}
else
{
double temp;
return(temp = Math.Round(((getValue(Subject1, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject1)) +
(getValue(Subject2, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject2)))
/ (SubjectUnit.getWeight(Level, Subject1) + SubjectUnit.getWeight(Level, Subject2)), 3));
}
}
else if (Level.Equals("Grade 3") || Level.Equals("Grade 4") || Level.Equals("Grade 5") || Level.Equals("Grade 6") || Level.Equals("Grade 7"))
{
double temp;
temp = Math.Round(((getValue(Subject1, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject1)) +
(getValue(Subject2, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject2)))
/ (SubjectUnit.getWeight(Level, Subject1) + SubjectUnit.getWeight(Level, Subject2)), 3);
return(temp);
}
else if (Level.Equals("HS I") || Level.Equals("HS III"))
{
return(Math.Round(((getValue(Subject1, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject1)) +
(getValue(Subject2, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject2)) +
(getValue(Subject3, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject3)) +
(getValue(Subject4, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject4)))
/ (SubjectUnit.getWeight(Level, Subject1) + SubjectUnit.getWeight(Level, Subject2) + SubjectUnit.getWeight(Level, Subject3) + SubjectUnit.getWeight(Level, Subject4)), 3));
}
else if (Level.Equals("HS II"))
{
return(Math.Round(((getValue(Subject1, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject1)) +
(getValue(Subject2, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject2)) +
(getValue(Subject3, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject3)))
/ (SubjectUnit.getWeight(Level, Subject1) + SubjectUnit.getWeight(Level, Subject2) + SubjectUnit.getWeight(Level, Subject3)), 3));
}
else if (Level.Equals("HS III"))
{
return(Math.Round(((getValue(Subject1, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject1)) +
(getValue(Subject2, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject2)) +
(getValue(Subject3, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject3)))
/ (SubjectUnit.getWeight(Level, Subject1) + SubjectUnit.getWeight(Level, Subject2) + SubjectUnit.getWeight(Level, Subject3)), 3));
}
else
{
return(Math.Round(((getValue(Subject1, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject1)) +
(getValue(Subject2, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject2)) +
(getValue(Subject3, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject3)) +
(getValue(Subject4, StudentId, listGrades) * SubjectUnit.getWeight(Level, Subject4)))
/ (SubjectUnit.getWeight(Level, Subject1) + SubjectUnit.getWeight(Level, Subject2) + SubjectUnit.getWeight(Level, Subject3) + SubjectUnit.getWeight(Level, Subject4)), 3));
}
}
public static void Grade3To5(DataTable HonorsTable, int termPeriod, String StudentId, String Level)
{
DataRow drow = HonorsTable.NewRow();
drow["Cluster1Format"] = "[(Math*" + SubjectUnit.getWeight(Level, "MATH") + ") + (Science*" + SubjectUnit.getWeight(Level, "SCIE") + ") + English*" + SubjectUnit.getWeight(Level, "ENGL") + "]/" + (SubjectUnit.getWeight(Level, "MATH") + SubjectUnit.getWeight(Level, "SCIE") + SubjectUnit.getWeight(Level, "ENGL"));
drow["Cluster2Format"] = "[(SLGE*" + SubjectUnit.getWeight(Level, "SLGE") + ") + (Computer*" + SubjectUnit.getWeight(Level, "COMP") + ") + (RVED*" + SubjectUnit.getWeight(Level, "RVED") + ")]/" + (SubjectUnit.getWeight(Level, "SLGE") + SubjectUnit.getWeight(Level, "COMP") + SubjectUnit.getWeight(Level, "RVED"));
//drow["Cluster3Format"] = "[(PE*" + SubjectUnit.getWeight(Level, "PHED") + ") + (Art*" + SubjectUnit.getWeight(Level, "ARTS") + ") + (Music*" + SubjectUnit.getWeight(Level, "MUSI") + ")]/" + (SubjectUnit.getWeight(Level, "PHED") + SubjectUnit.getWeight(Level, "ARTS") + SubjectUnit.getWeight(Level, "MUSI"));
drow["Cluster3Format"] = "[(PE*" + SubjectUnit.getWeight(Level, "PHED") + ") + (Music*" + SubjectUnit.getWeight(Level, "MUSI") + ")]/" + (SubjectUnit.getWeight(Level, "PHED") + SubjectUnit.getWeight(Level, "MUSI"));
drow["StudentId"] = StudentId;
HonorsTable.Rows.Add(drow);
}
private static String getCluster3String(String Subject1, String Subject2, String Subject3, String Subject4, String Subject5, String Level, String StudentId, List <FinalComp> listGrades, int termPeriod)
{
if (Level.Equals("Grade 1") || Level.Equals("Grade 2"))
{
if (termPeriod.Equals(3))
{
return("[" + "(" + getValue(Subject1, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject1) + ")" +
"]/" + (SubjectUnit.getWeight(Level, Subject1)));
}
else
{
return("[" + "(" + getValue(Subject1, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject1) + ") + " +
"(" + getValue(Subject2, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject2) + ")" +
"]/" + (SubjectUnit.getWeight(Level, Subject1) + SubjectUnit.getWeight(Level, Subject2)));
}
}
else if (Level.Equals("Grade 3") || Level.Equals("Grade 4") || Level.Equals("Grade 5") || Level.Equals("Grade 6") || Level.Equals("Grade 7"))
{
return("[" + "(" + getValue(Subject1, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject1) + ") + " +
"(" + getValue(Subject2, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject2) + ")" +
"]/" + (SubjectUnit.getWeight(Level, Subject1) + SubjectUnit.getWeight(Level, Subject2)));
}
else if (Level.Equals("HS I"))
{
return("[" + "(" + getValue(Subject1, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject1) + ") + " +
"(" + getValue(Subject2, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject2) + ") + " +
"(" + getValue(Subject3, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject3) + ") + " +
"(" + getValue(Subject4, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject4) + ")" +
"]/" + (SubjectUnit.getWeight(Level, Subject1) + SubjectUnit.getWeight(Level, Subject2) + SubjectUnit.getWeight(Level, Subject3) + SubjectUnit.getWeight(Level, Subject4)));
}
else if (Level.Equals("HS II"))
{
return("[" + "(" + getValue(Subject1, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject1) + ") + " +
"(" + getValue(Subject2, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject2) + ") + " +
"(" + getValue(Subject3, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject3) + ") + " +
"]/" + (SubjectUnit.getWeight(Level, Subject1) + SubjectUnit.getWeight(Level, Subject2) + SubjectUnit.getWeight(Level, Subject3)));
}
else if (Level.Equals("HS III"))
{
return("[" + "(" + getValue(Subject1, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject1) + ") + " +
"(" + getValue(Subject2, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject2) + ") + " +
"(" + getValue(Subject3, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject3) + ") + " +
"]/" + (SubjectUnit.getWeight(Level, Subject1) + SubjectUnit.getWeight(Level, Subject2) + SubjectUnit.getWeight(Level, Subject3)));
}
else
{
return("[" + "(" + getValue(Subject1, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject1) + ") + " +
"(" + getValue(Subject2, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject2) + ") + " +
"(" + getValue(Subject3, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject3) + ") + " +
"(" + getValue(Subject4, StudentId, listGrades) + "*" + SubjectUnit.getWeight(Level, Subject4) + ")" +
"]/" + (SubjectUnit.getWeight(Level, Subject1) + SubjectUnit.getWeight(Level, Subject2) + SubjectUnit.getWeight(Level, Subject3) + SubjectUnit.getWeight(Level, Subject4)));
}
}
public static void HS4(DataTable HonorsTable, int termPeriod, String StudentId, String Level)
{
DataRow drow = HonorsTable.NewRow();
drow["Cluster1Format"] = "[(Math*" + SubjectUnit.getWeight(Level, "MATH") + ") + (Science*" + SubjectUnit.getWeight(Level, "PHYS") + ") + English*" + SubjectUnit.getWeight(Level, "ENGL") + "]/" + (SubjectUnit.getWeight(Level, "MATH") + SubjectUnit.getWeight(Level, "PHYS") + SubjectUnit.getWeight(Level, "ENGL"));
drow["Cluster2Format"] = "[(SLGE*" + SubjectUnit.getWeight(Level, "SLGE") + ") + (Economics*" + SubjectUnit.getWeight(Level, "BUSI") + ") + (Computer*" + SubjectUnit.getWeight(Level, "COMP") + ")]/" + (SubjectUnit.getWeight(Level, "SLGE") + SubjectUnit.getWeight(Level, "BUSI") + SubjectUnit.getWeight(Level, "COMP"));
if (termPeriod.Equals(1))
{
//modification 10/20/11 HOME to SHOP
drow["Cluster3Format"] = "[(PE*" + SubjectUnit.getWeight(Level, "PHED") + ") + (CAT/CAS*" + SubjectUnit.getWeight(Level, "COIN") + ") + (RVED*" + SubjectUnit.getWeight(Level, "RVED") + ") + (HE*" + SubjectUnit.getWeight(Level, "SHOP") + ") ]/" + (SubjectUnit.getWeight(Level, "PHED") + SubjectUnit.getWeight(Level, "COIN") + SubjectUnit.getWeight(Level, "RVED") + SubjectUnit.getWeight(Level, "SHOP"));
}
if (termPeriod.Equals(2))
{
drow["Cluster3Format"] = "[(PE*" + SubjectUnit.getWeight(Level, "PHED") + ") + (CAT/CAS*" + SubjectUnit.getWeight(Level, "COIN") + ") + (RVED*" + SubjectUnit.getWeight(Level, "RVED") + ") + (HE*" + SubjectUnit.getWeight(Level, "HOME") + ") + (Music*" + SubjectUnit.getWeight(Level, "MUSI") + ") ]/" + (SubjectUnit.getWeight(Level, "PHED") + SubjectUnit.getWeight(Level, "COIN") + SubjectUnit.getWeight(Level, "RVED") + SubjectUnit.getWeight(Level, "HOME") + SubjectUnit.getWeight(Level, "MUSI"));
}
if (termPeriod.Equals(3))
{
drow["Cluster3Format"] = "[(PE*" + SubjectUnit.getWeight(Level, "PHED") + ") + (CAT/CAS*" + SubjectUnit.getWeight(Level, "COIN") + ") + (RVED*" + SubjectUnit.getWeight(Level, "RVED") + ") + (Shop*" + SubjectUnit.getWeight(Level, "SHOP") + ") + (Music*" + SubjectUnit.getWeight(Level, "MUSI") + ") ]/" + (SubjectUnit.getWeight(Level, "PHED") + SubjectUnit.getWeight(Level, "COIN") + SubjectUnit.getWeight(Level, "RVED") + SubjectUnit.getWeight(Level, "SHOP") + SubjectUnit.getWeight(Level, "MUSI"));
}
drow["StudentId"] = StudentId;
HonorsTable.Rows.Add(drow);
}