Courses‎ > ‎Software Development‎ > ‎Dyrland-Weaver‎ > ‎Work-Term_1‎ > ‎

Work 10: Selecting Success

posted Oct 17, 2017, 10:05 AM by JonAlf Dyrland-Weaver   [ updated Oct 17, 2017, 10:05 AM ]
With your duo, write a Python script named that will access the database built in your last assignment to
  • Look up each student’s grades
  • Compute each student’s average
  • Display each student’s name, id, and average
  • Create a table of IDs and associated averages, named "peeps_avg" (thank team Sparkly Spectacular Sushi)
  • Facilitate updating a student's average
  • Facilitate adding rows to the courses table
To test the last 2 features, you should add lines to the end of courses.csv to reflect a new term's worth of course enrollment for your peeps (students).
File under 10_db in the workshop, with your local submodule name in this format: lastaF-lastbF