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
- 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:
- 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