Though the traditional campus has a breaks (e.g., fall break, Thanksgiving, finals week), we don't do that with online courses. We just forge ahead until the last day of class. See the Moodle Calendar.

---

**Last week (week 6)**

- Grading
  - I incorrectly assigned 0s to a number of you for the class 8 quiz. That should be fixed now.
  - To be safe, it would be good to check the your scores in the Moodle Gradebook are what you expect. 
    - Everything should be graded through unit 11 (prep/class/lab 11 & persp/quiz/hw 10).
    - I will accept late work, but I probably won't notice late submissions.
    - Email me if you find issues or if you'd like to submit something late.

- Perspectives 5
  - I appreciated your comments on data privacy, e.g., Diego's example in his posting. 
    <https://moodle.calvin.edu/mod/forum/discuss.php?d=324910>
  - My team had a similar situation with our SLO Twitter data. 

- Unit 5 - Relational databases homework
  - [Spring 2022, Fall 2023] Relational databases (units 9-10, last week) were a challenge for most everyone.
  - Review the 1-M and M-M relationships in the SPJ database schema & instance example (see class 9), see:
    - <https://cs.calvin.edu/courses/info/601/09databases/class/relational-model.html#4>
    - <https://cs.calvin.edu/courses/info/601/09databases/class/relational-model.html#9>
    - Or: `data/teams.sql` and `images/teams-schema.png`
    - Notes:
      - There are no comma-separated list fields in pure relational databases.
      - The foreign key goes on the many side.
      - Create many-many relationships using two one-many relationships.
  - In this course, we're happy with a minimal, basic understanding of the concepts.
    - [Spring 2023] Interestingly, last spring's student did remarkably well because they were mostly MAcc students taking accounting systems at the time.
    - MAcc students will eventually take that course.
    - MDS students will take a database elective course.

---

**Next week (week 7)**

- Recap
  - Relational data (units 9-10) is highly structured
  - Textual data (units 11-12) is highly UNstructured
  - Geospatial data (units 13-14 - next week) is very mathematical and voluminous.
- For all three topics, we're contenting ourselves with:
  - Basic understanding of the fundamental nature of the data.
  - Introductory experience with wrangling techniques for that data.

- Geospatial data
  - Note that for the optional, interactive mapping exercises, you will need to switch to HTML output for this unit because one of the tools we're using, Leaflet, is an interactive, HTML-based tool. This is not required, but is sort of cool. Demo lab 13.
  - The more I see of the world, the more I'm convinced of the profound effect that geography has on politics, society, history, etc.  

- Project
  - Project 1 (due tonight)
    - Submit a short, written vision statement. 
    - The primary concern here is identifying the nature of the data you're interested in exploring. Examples from last year included analyses of:
      - Production from organic farming businesses in the Midwest (the student's family owns an organic farm) - the data came from the USDA.
      - US housing cost trends (the student's company did work in this space) - the data came largely from Zillow.
      - the theory that soccer/futbol players born in certain times of the year do better - the data was scraped from online soccer stats sites.
    - I'll give comments on your ideas soon (probably Monday).
  - Project 2 (due next Saturday)
    - Submit an updated project vision with more details on the dataset(s) that you've been able to collect.
    - The primary concern here is verify that you can get the data, understand its structure, and do some preliminary wrangling and EDA.

---

**Hebrews 12:1** - Perseverance

- <https://www.biblegateway.com/passage/?search=hebrews%2012&version=NRSV&interface=print>

- Keep going, we're nearly done with this (accelerated, eight-week) course.
- Let me know if you need anything to keep you going!
- Cf. Ken Bratt's commencement address
