A290/A590 Main Menu

Tools for Computing/Topics In Programming:
Introduction to SQL Programming.


"What one man can invent another can discover."

-Sherlock Holmes "The Adventure of the Dancing Men"


Instructor: Jeff Whitmer

Jeff Whitmer

  • Office: Luddy Hall 2050 (IF2050).
  • Office Hours:

    • Spring 2021: By Appointment Only.

  • Office Hour Special NOTES:
    • Any changes to my office hours will be posted here.

      • Tuesday, May 10, 2022: FIRST DAY THIS CLASS MEETS.

  • Luddy Hall 2050 (IF2050) Office Phone: 855-3974.
  • E-mail: jwhitmer@cs.indiana.edu.

Meeting Times: (Summer Session 2022)

  • Tuesday/Wednesday/Thursday: 12:30 - 1:45pm EDT (Section 7880 and 7881) in Luddy Hall 0006 (IF 0006).

animated GIF

Important Updates for All Students
enrolled in Summer Session 2022


[LAST UPDATED: 6/20/2022]


  • ACTIVE Course Engagement scores, Final Averages and Final Grades: are now posted on Canvas. Final Grades have been submitted to the Registrar and should be visible to you tomorrow, 6/21/2022.

  • I have been able to modify the Canvas grading scale so it matches the original grading scale explained below. This means your final average and Final Grade as displayed on Canvas are official and confirmed accurate and correct.

  • A note on the ACTIVE Course Engagement Score: The A290/A590 ACTIVE Course Engagement score represents my evaluation of your preparation and participation in the class meetings as well as your overall engagement in the course both in and out of class. As noted on the first day, just being the one saying the most doesn't mean you will get the highest rating. Similarly, being quiet doesn't mean you'll get a low score. Being at every class doesn't mean you will get a high score, and being absent a very few times doesn't mean you'll get a low score. It is important to understand that I "see" a great deal from my position. ALSO NOTE that you cannot expect a high participation score if you missed a substantial number of the class meetings. You were all advised of the possible consequences of chronic absenteeism on the first day as well as several times during the course. You can not be engaged when you are not present. None of these issues applied to a vast majority of the class with almost all scores in the 90s and none below 80. As a consequence, the class average was 92.10%. This means virtually all of you were present and engaged virtually all of the time.

    Here are a few additional details on Final Grades. Grading Scale Adjustment: Since the performance by the class as a whole was, by far, the best I've ever had, I could not justify any adjustment to the original grading scale. So, the original scale was used, 90-80-70-60 with the top and bottom 2.5% being the +/- grade. Everyone worked hard and I think that is reflected in the final grades each of you, even without any adjustments. Again, I think virtually all of you were actively involved and this is reflected in the scores and final grades.

    Remember, your final average was based on the following "weights" for each course component as published on the website the first day of class:

    Attendance: 5% (.05)
    Assignments/Programs: 75% (.75)
    MINI/CAT/JIT/Quiz: 10% (.1)
    ACTIVE Course Engagement: 10% (.1)

    Together, these add up to 100% and if you multiply your averages by these percentages, you will get your final average. NOTE: While final averages are published to 2 decimal places, they are stored and calculated to 6 decimal places.

    A NOTE ON "BORDERLINE" GRADES: After the original grading scale was confirmed and initial final grades were determined, I checked to see if any students were on the "borderline" for a higher grade. PLEASE be careful to note that "borderline" in this course means within .1 -.2% (tenths of a percent), NOT within 1-2% (full percent). For every student, I looked carefully at every aspect of the course, from projects to attendance to assignments at least once, if not twice. If the work was of consistent quality in all areas, the higher grade was probably given. HOWEVER, if there were one or more areas where the scores/averages were consistently lower, or if there was missed work, then the higher grade was not given. Just so you are clear, since I have taken the time to review all this information already, unless you find a mathematical error in your averages, I will not be open to a request for a grade change.

    The final distribution of grades was: 8 A+, 9 A, 1 A-, 0 B+, 1 B, 0 B-, 0 C+, 0 C, and 0 C-. Overall, this means there were 18 A, and 1 B. Thanks to everyone for their hard work, especially during the compressed timeline of a summer session. I hope you found the course interesting and useful. Best of luck in the future to each of you.

  • Assignment 3 scores posted and and Assignment Averages confirmed correct, emails on the way. Assignment 3 scores are posted on Canvas. Everyone should receive an email with their Assignment 3 score and some comments by the end of today. This was an very good set of submissions as a group. Almost everyone showed a good, clear understanding of what was expected. The average on Assignment 3 for the class was 96.84%, which is outstanding. Scores on Assignment 3 ranged from 100 to 79 out of a possible 100, with 7 100, 11 in the 90s, 0 in the 80s, and 1 in the 70s. The most common oversights were to not declare a Primary Key (PK) for each table or not realizing that CONSTRAINT had to be used to create the Composite PK for Enrollment and then ALTER had to be used to establish the Foreign Keys for Enrollment.

    The overall averages for the three Assignments was also outstanding. For the class, the average was 96.63%, with 1 average of 100, 17 averages in the 90s, and 1 in 80s. NOTE: The Assignment average calculated by Canvas have been confirmed correct. ALSO NOTE: Active Course Engagement scores, Final Averages, and Final Grades will be published sometime in the next two days (Sunday or (most likely) Monday), as previously announced. PLEASE NOTE: I realize you may be looking at your current average and have concerns about your Final Grade. Keep in mind what you currently see on Canvas does not include your Active Course Engagement score nor does it reflect any adjustments I may make in the final grading scale. Please be patient and allow me time to consider these rather than contacting me with concerns that are not well founded at this point. I appreciate your cooperation with this.

  • CAT 4 scores posted. Canvas MINI/JIT/CAT Averages and Attendance Averages confirmed correct: Just a quick note to let everyone know I have posted the CAT 4 scores and confirmed the MINI/JIT/CAT averages on Canvas match my records. Overall, the class average was 94.41% which is far and away the very best average I have seen in this course. There were 9 averages of 100, 5 in the 90s, 3 in the 80s, and 2 in the 70s. As noted at the beginning of the course, missing one or two of these small point value assignments would have minimal impact on your final average, but as some of these very low averages reveal, some students missed a very substantial number of these assignments which will impact final averages.

    I also have confirmed the Attendance averages on Canvas are accurate, keeping in mind that on Canvas they are rounded up or down to the nearest whole number when displayed, but the more accurate value is preserved when calculating the final average.


Graduate Assistants, Summer Session 2022:

Isaiah Sherfick

Isaiah Sherfick

Email: isherfic@iu.edu

  • Office Hours/Appointments: Available online during all class meeting times. Appointments also available and strongly encouraged.
    PREFERRED Appointment times:
  • Monday: 12:30pm - 2:30pm and Thursday: 12:30pm - 2:30pm. These are on days we do not have class to give you more options.