CourseTester written by S. Robbins Course with 5 students after inialization: Ordered by name Course: CS1713 Intro to Programming instructor: Zhang, Weining, semester Fall 2007 The maximum average: 93.18, the minimum average: 75.37, the average is 85.21 Students: ------------------------------------------ Name: Adams, John Q, ID: abcd Exam scores: 65.00, 92.90 Lab scores: 67.00, 72.80, 81.0 Quiz scores: 45.00, 68.00, 82.00, 90.00 Course average: 77.54 ------------------------------------------ Name: Adams, John X, ID: @0002 Exam scores: 89.00, 93.30 Lab scores: 95.00, 88.30, 97.0 Quiz scores: 88.00, 93.00, 97.00, 89.00 Course average: 92.58 ------------------------------------------ Name: Adams, Samuel S, ID: notp Exam scores: 68.00, 73.30 Lab scores: 88.00, 72.30, 69.0 Quiz scores: 76.00, 92.00, 84.00, 76.00 Course average: 75.37 ------------------------------------------ Name: Jefferson, Thomas J, ID: Num3 Exam scores: 87.00, 96.70 Lab scores: 99.00, 87.00, 94.0 Quiz scores: 95.00, 73.00, 94.00, 89.00 Course average: 93.18 ------------------------------------------ Name: Washington, George T, ID: firstp Exam scores: 98.00, 87.50 Lab scores: 57.00, 89.40, 94.0 Quiz scores: 40.00, 70.00, 65.00, 87.00 Course average: 87.38 ------------------------------------------ John Q. Adams second lab is 93.45 Ordered by name Course: CS1713 Intro to Programming instructor: Zhang, Weining, semester Fall 2007 The maximum average: 93.18, the minimum average: 75.37, the average is 85.83 Students: ------------------------------------------ Name: Adams, John Q, ID: abcd Exam scores: 65.00, 92.90 Lab scores: 67.00, 93.45, 81.0 Quiz scores: 45.00, 68.00, 82.00, 90.00 Course average: 80.64 ------------------------------------------ Name: Adams, John X, ID: @0002 Exam scores: 89.00, 93.30 Lab scores: 95.00, 88.30, 97.0 Quiz scores: 88.00, 93.00, 97.00, 89.00 Course average: 92.58 ------------------------------------------ Name: Adams, Samuel S, ID: notp Exam scores: 68.00, 73.30 Lab scores: 88.00, 72.30, 69.0 Quiz scores: 76.00, 92.00, 84.00, 76.00 Course average: 75.37 ------------------------------------------ Name: Jefferson, Thomas J, ID: Num3 Exam scores: 87.00, 96.70 Lab scores: 99.00, 87.00, 94.0 Quiz scores: 95.00, 73.00, 94.00, 89.00 Course average: 93.18 ------------------------------------------ Name: Washington, George T, ID: firstp Exam scores: 98.00, 87.50 Lab scores: 57.00, 89.40, 94.0 Quiz scores: 40.00, 70.00, 65.00, 87.00 Course average: 87.38 ------------------------------------------ After trying to add a duplicate id Ordered by name Course: CS1713 Intro to Programming instructor: Zhang, Weining, semester Fall 2007 The maximum average: 93.18, the minimum average: 75.37, the average is 85.83 Students: ------------------------------------------ Name: Adams, John Q, ID: abcd Exam scores: 65.00, 92.90 Lab scores: 67.00, 93.45, 81.0 Quiz scores: 45.00, 68.00, 82.00, 90.00 Course average: 80.64 ------------------------------------------ Name: Adams, John X, ID: @0002 Exam scores: 89.00, 93.30 Lab scores: 95.00, 88.30, 97.0 Quiz scores: 88.00, 93.00, 97.00, 89.00 Course average: 92.58 ------------------------------------------ Name: Adams, Samuel S, ID: notp Exam scores: 68.00, 73.30 Lab scores: 88.00, 72.30, 69.0 Quiz scores: 76.00, 92.00, 84.00, 76.00 Course average: 75.37 ------------------------------------------ Name: Jefferson, Thomas J, ID: Num3 Exam scores: 87.00, 96.70 Lab scores: 99.00, 87.00, 94.0 Quiz scores: 95.00, 73.00, 94.00, 89.00 Course average: 93.18 ------------------------------------------ Name: Washington, George T, ID: firstp Exam scores: 98.00, 87.50 Lab scores: 57.00, 89.40, 94.0 Quiz scores: 40.00, 70.00, 65.00, 87.00 Course average: 87.38 ------------------------------------------ A copy of George Washington: Name: Washington, George T, ID: firstp Exam scores: 98.00, 87.50 Lab scores: 57.00, 89.40, 94.0 Quiz scores: 40.00, 70.00, 65.00, 87.00 Course average: 87.38 George Washington with first quiz 19.15: Name: Washington, George T, ID: firstp Exam scores: 98.00, 87.50 Lab scores: 57.00, 89.40, 94.0 Quiz scores: 19.15, 70.00, 65.00, 87.00 Course average: 87.38 Goerge Washing should not have changed in the course: Ordered by name Course: CS1713 Intro to Programming instructor: Zhang, Weining, semester Fall 2007 The maximum average: 93.18, the minimum average: 75.37, the average is 85.83 Students: ------------------------------------------ Name: Adams, John Q, ID: abcd Exam scores: 65.00, 92.90 Lab scores: 67.00, 93.45, 81.0 Quiz scores: 45.00, 68.00, 82.00, 90.00 Course average: 80.64 ------------------------------------------ Name: Adams, John X, ID: @0002 Exam scores: 89.00, 93.30 Lab scores: 95.00, 88.30, 97.0 Quiz scores: 88.00, 93.00, 97.00, 89.00 Course average: 92.58 ------------------------------------------ Name: Adams, Samuel S, ID: notp Exam scores: 68.00, 73.30 Lab scores: 88.00, 72.30, 69.0 Quiz scores: 76.00, 92.00, 84.00, 76.00 Course average: 75.37 ------------------------------------------ Name: Jefferson, Thomas J, ID: Num3 Exam scores: 87.00, 96.70 Lab scores: 99.00, 87.00, 94.0 Quiz scores: 95.00, 73.00, 94.00, 89.00 Course average: 93.18 ------------------------------------------ Name: Washington, George T, ID: firstp Exam scores: 98.00, 87.50 Lab scores: 57.00, 89.40, 94.0 Quiz scores: 40.00, 70.00, 65.00, 87.00 Course average: 87.38 ------------------------------------------ Course sorted by id: Ordered by ID Course: CS1713 Intro to Programming instructor: Zhang, Weining, semester Fall 2007 The maximum average: 93.18, the minimum average: 75.37, the average is 85.83 Students: ------------------------------------------ Name: Adams, John X, ID: @0002 Exam scores: 89.00, 93.30 Lab scores: 95.00, 88.30, 97.0 Quiz scores: 88.00, 93.00, 97.00, 89.00 Course average: 92.58 ------------------------------------------ Name: Jefferson, Thomas J, ID: Num3 Exam scores: 87.00, 96.70 Lab scores: 99.00, 87.00, 94.0 Quiz scores: 95.00, 73.00, 94.00, 89.00 Course average: 93.18 ------------------------------------------ Name: Adams, John Q, ID: abcd Exam scores: 65.00, 92.90 Lab scores: 67.00, 93.45, 81.0 Quiz scores: 45.00, 68.00, 82.00, 90.00 Course average: 80.64 ------------------------------------------ Name: Washington, George T, ID: firstp Exam scores: 98.00, 87.50 Lab scores: 57.00, 89.40, 94.0 Quiz scores: 40.00, 70.00, 65.00, 87.00 Course average: 87.38 ------------------------------------------ Name: Adams, Samuel S, ID: notp Exam scores: 68.00, 73.30 Lab scores: 88.00, 72.30, 69.0 Quiz scores: 76.00, 92.00, 84.00, 76.00 Course average: 75.37 ------------------------------------------ Course sorted by average: Ordered by Course Average Course: CS1713 Intro to Programming instructor: Zhang, Weining, semester Fall 2007 The maximum average: 93.18, the minimum average: 75.37, the average is 85.83 Students: ------------------------------------------ Name: Adams, Samuel S, ID: notp Exam scores: 68.00, 73.30 Lab scores: 88.00, 72.30, 69.0 Quiz scores: 76.00, 92.00, 84.00, 76.00 Course average: 75.37 ------------------------------------------ Name: Adams, John Q, ID: abcd Exam scores: 65.00, 92.90 Lab scores: 67.00, 93.45, 81.0 Quiz scores: 45.00, 68.00, 82.00, 90.00 Course average: 80.64 ------------------------------------------ Name: Washington, George T, ID: firstp Exam scores: 98.00, 87.50 Lab scores: 57.00, 89.40, 94.0 Quiz scores: 40.00, 70.00, 65.00, 87.00 Course average: 87.38 ------------------------------------------ Name: Adams, John X, ID: @0002 Exam scores: 89.00, 93.30 Lab scores: 95.00, 88.30, 97.0 Quiz scores: 88.00, 93.00, 97.00, 89.00 Course average: 92.58 ------------------------------------------ Name: Jefferson, Thomas J, ID: Num3 Exam scores: 87.00, 96.70 Lab scores: 99.00, 87.00, 94.0 Quiz scores: 95.00, 73.00, 94.00, 89.00 Course average: 93.18 ------------------------------------------ Only Samuel Adams removed Ordered by name Course: CS1713 Intro to Programming instructor: Zhang, Weining, semester Fall 2007 The maximum average: 93.18, the minimum average: 80.64, the average is 88.44 Students: ------------------------------------------ Name: Adams, John Q, ID: abcd Exam scores: 65.00, 92.90 Lab scores: 67.00, 93.45, 81.0 Quiz scores: 45.00, 68.00, 82.00, 90.00 Course average: 80.64 ------------------------------------------ Name: Adams, John X, ID: @0002 Exam scores: 89.00, 93.30 Lab scores: 95.00, 88.30, 97.0 Quiz scores: 88.00, 93.00, 97.00, 89.00 Course average: 92.58 ------------------------------------------ Name: Jefferson, Thomas J, ID: Num3 Exam scores: 87.00, 96.70 Lab scores: 99.00, 87.00, 94.0 Quiz scores: 95.00, 73.00, 94.00, 89.00 Course average: 93.18 ------------------------------------------ Name: Washington, George T, ID: firstp Exam scores: 98.00, 87.50 Lab scores: 57.00, 89.40, 94.0 Quiz scores: 40.00, 70.00, 65.00, 87.00 Course average: 87.38 ------------------------------------------