From today:
Do “git clone 10am_galaxy.git galaxy” or “git clone 2pm_galaxy.git galaxy2” to unpack in the proper place.
From today:
Do “git clone 10am_galaxy.git galaxy” or “git clone 2pm_galaxy.git galaxy2” to unpack in the proper place.
The handout I distributed in today’s class will be a take-home rather than an in-class XP opportunity. It’s worth up to +8XP and is due on Monday, November 30th at midnight. You can work alone, or in teams of up to three.
To earn these XP, you should:
The end of the semester is fast arriving, and we’re (predictably) not going to have time for everything on the syllabus. Here’s the deal:
This has been a public service announcement.
For this week only, I’ll be having Thursday office hours from 12-2pm, instead of the usual 1-2pm and 3:30-4:30pm.
Quiz #5 has been posted, and is due on Friday by midnight. It is open-notes, timed at 60 minutes, closed-Python, closed-Redis, closed-AI, closed-other-humans, and closed-materials-from-students-who-have-previously-taken-this-course.
Good luck!
While we all wait through this global Microsoft Outlook outage, you can reach me if you need to at stephenclarkdavies@gmail.com.
Since Microsoft’s nationwide outage has paralyzed UMW email systems today, I’m giving everyone an extra day on assignment #7. You can pay me later.
Here’s our in-class XP activity today, plus the video as a bonus:

From today:
Do “git clone 10am_hobbies.git hobbies” or “git clone 2pm_hobbies.git hobbies2” to unpack in the proper place.
Btw, your Redis instance number is listed on the port numbers page (far right column).
Email me for a Zoom link!
Since we didn’t get as far as I was hoping to today, I’ve extended the Redis assignment date until Thursday the 19th at midnight.
For this week only, I’ll be having Thursday office hours from 12-2pm, instead of the usual 1-2pm and 3:30-4:30pm.
A couple people have requested a sneak peek at the next homework, so I went ahead and posted it. It’s due Tuesday the 17th at midnight. You’ll know everything you need to start it by the end of class tomorrow!
From today’s class, the final git bundles for:
As usual, download the appropriate one and then “git clone 10am.git sunny” or “git clone 2pm.git hairdryer“.
You will absolutely, positively NOT want to procrastinate on Assignment #6, the first stop on your rest-of-the-semester Database Tour® project! Read the assignment soon, and carefully. Then read it again soon thereafter, and carefully. Then send me questions!
This (and the remaining tour stops) is not for the faint of heart!
From today’s class, the git bundles for:
To open these, download them and then “git clone 10am.git sunny” or “git clone 2pm.git hairdryer“.
From today’s class, the git bundles for:
To open these, download them and then “git clone 10am.git sunny” or “git clone 2pm.git hairdryer“.
Quiz #4 is a 60-minute affair, and is due at midnight Thursday, October 29th. As is usually the case, it is open-notes, closed-AI, closed-SQLite, closed-MariaDB, closed-Python, and is to be completed entirely on your own, with no help from others, not even those not at UMW.
Good luck!
Couple people getting wrapped around the axle today with their connections and cursors. I know it’s annoying, and I’ve repeated this mistake several times in my career, but unlike SQLite, where you can do:
conn = sqlite3.connect(...) cursor = conn.execute(...) results = cursor.fetchall()
in MariaDB you instead have to do this slightly different thing:
conn = mariadb.connect(...) cursor = conn.cursor() cursor.execute(...) results = cursor.fetchall()
Takeaway: it’s not conn.execute() with the mariadb package, but rather cursor.execute().
From today’s class, the git bundles for:
To open these, download them and then “git clone 10am.git sunny” or “git clone 2pm.git hairdryer“.
So many people have had to wait on email backs-and-forths to get MariaDB passwords working that I’ve extended assignment #4 one day past its original deadline. Sorry for all the trouble, everybody!
Those 40-point assignments just keep on comin’! They’re an excellent way to raise your grade, among other things. Assignment #5 in particular is your first foray into the world of Web applications, and merely involves learning the simple basics behind static web pages. It’s due on Monday the 26th at midnight.
Make sure you follow the instructions so that your site is up 24×7, instead of “just when your laptop is on” or “just when you’re thinking of it yourself.”
Here are Stephen’s solutions to the fall break query practice opportunity.
From today’s class:
Hot on the heels of assignment #3 is assignment #4, also due next week. Get galaxy-hoppin’ real soon!
Quiz #3 has been posted to Canvas, and is due by midnight (11:59:59pm) on Tuesday, October 20th. Good luck!
Assignment #3, a console/terminal-based app in Python, has been posted and is due on Monday. Send questions when you have them!
Every semester I teach an XP-based class I have a nervous student or two who, around midterm time, says “omigosh I’m only at 150 points at the halfway mark and I need to get 500 just to get a B!!” or some such.
Let me try to make you feel better in three different ways:
Carry these thoughts with you into fall break if you’re a worrier.
From today’s class:
As I mentioned in class, I had actually posted quiz #2 before we had gone over the Foreign Key SQL syntax in class, so I feel iffy about holding you accountable for those items. To remedy this, I’ve given everybody an extra +4XP on that quiz, which should make up for it.
Here is the schema creation code we wrote in class today.
For this Tuesday only (9/29), my office hours will be 11am-12pm instead of the usual 10am-11am.
Quiz #2 has been posted to Canvas, and is due next Sunday at midnight. It’s open-book, open-notes, timed at 45 minutes, and must be completely entirely on your own, with no help from other people (even others not currently at UMW) or from AI assistants like ChatGPT. Good luck!
Assignment #2 has been posted, and is due at 11:59:59pm on Wednesday Sept 30th at midnight. This one involves plenty of new concepts and new tools, so get started and don’t delay!
I always find it somewhat amusing (as well as annoying) how difficult the last question of my Canvas quizzes always seems to be. Finding the correct pledge, typing it, and “signing” one’s name by typing it below the pledge are apparently onerous and error-prone tasks. Eight students managed to mess it up in one way or another on this quiz. 🙂
For this reason, even though that “question” was worth no points, I did award a bonus +1XP to every student who typed and signed their pledge correctly the first time. Enjoy!
Just a note that I’ll be having office hours on Thursday at slightly different times than I announced before. The new times for Thursday are: 1-2pm and 3:30-4:30pm.
In response to student questions:
5” but other times strings like “B37“.08:00” or “18:55“. For dates, use a format like “2026-09-13“.Here’s my solution to the Ben & Jerry’s requirements description problem.
A number of people turned in the most recent codingbat submission by typing the correct Honor Pledge, as required….but then forgetting to “sign” it (in this case, by typing your full name as your signature).
Adulting tip: if you’re routinely in the habit of submitting documents without signatures, get out of that habit ASAP. If you file your taxes, and don’t sign it, the federal government flat will not count that as a legal submission, and you’ll face fines or even jail. If you don’t sign your marriage license, you are not married. If you don’t sign your driver’s license, you cannot legally drive. If you don’t sign your loan application, you don’t get the loan. Etc.
If you’re one of those who failed to sign your pledge, simply reply to my recent chastisement email and type out the pledge again in full, and sign your name (by typing it below the pledge).
Quiz #1 has been posted to Canvas, and is due next Monday at midnight. Remember the rules for quizzes: they are open book, open notes, but closed-Python, closed-AI, closed-Internet (other than your Canvas window, duh) and closed-other-humans. This one is timed at 30 minutes. Take it alone in a quiet place. And good luck!
Lab aides are available on a walk-in basis this semester at the following times:
| Day | Time | Location | Lab Aide |
|---|---|---|---|
| Sunday | 3-5pm | HCC 111 | Kaleb |
| Monday | 6-8pm | JFH 022-Lab | Morgan |
| Tuesday | 6-8pm | JFH 022-Lab | Olivia |
| Wednesday | 6-8pm | JFH 022-Lab | Nathan |
| Thursday | 6-8pm | JFH 022-Lab | Olivia |
| Friday | 3-5pm | JFH 022-Lab | Kaleb |
Assignment #1 has been posted, and is due next Wednesday at 5pm. (Note: this assignment is to be submitted physically, rather than electronically, and hence the building must be open for you to stick it in my folder. I can only guarantee the building will be open until 5pm. If you’re later than this, and you luck out and it turns out the building is open, I’ll never know you were late.)
This assignment is not for the faint of heart! It will require serious, unrushed thinking. Do not procrastinate!!
I realized that I forgot to ask for people’s pronouns along with their names yesterday, as is my custom. So let me just say: if you think there’s a chance of me misgendering you, please send me email telling me what your preferred pronouns are. If you don’t think there’s a chance of that, and you’re sure that I would guess correctly what your pronouns are based solely on your appearance, you need do nothing.
You might not realize this from where you sit, but it’s darn challenging for professors to learn 50-75 new names and faces every semester. And that’s without dealing with jet lag complications!
One of the ways I expedite learning students’ names is practicing. (Some might call this “cheating.” I call those people “haters.”) I download everybody’s “mug shot” from Banner, and run through the faces like flash cards, gradually learning to associate a name with a face.
It used to be that all Banner students had a mug shot, period. (I think it’s the pic that appears on our EagleOne card.) But for the past few years, I’ve noticed that there are plenty of gaps where for some mysterious reason no picture is registered with you in the Banner system.
So why am I telling you this? Because you can earn another easy and valuable +1XP by providing me with a mug shot (meaning, a portrait of you looking fairly normal doing something interesting (or not) but most importantly: your face fully visible on the portrait. It can be a silly snapshot or your prom dress from high school: I just need a face to go with your name.)
For students who already have such a Banner mug shot, you have already been proactively awarded the aforementioned +1XP on the scoreboard. If not, you can still claim this point if you follow these three directions:
When I receive any of the above emails, I will do my best to get their point awarded and their picture & name added to my little black book.
Oh, and one other thing: this is due before class on Wednesday of this week. It’s not a hard task, it’s just remembering to do it.
I almost never check or receive “Canvas messages” and only saw one from a student today by accident. Please, to get in touch with me always use email (my first name _AT_ umw _DOT_ edu) and you’ll have better luck!
In order to earn any experience points (XP) at all for this class, you’ll need to sign up on the class scoreboard. Do this right away, and get your first +1XP of the semester!
IMPORTANT NOTE: you should choose a secret screen name that does not resemble your real name in any way, and you should keep it secret from others throughout the semester.
Assignment #0 has been posted, and can net you up to +20XP! It’s due on September 1st.
You can earn up to +3XP each week for the first eight weeks of class by completing Python challenges on codingbat.com.
To earn these points, first create an account on codingbat.com. Please use your UMW email address. Then, click on “prefs” in the upper-right, and enter my email address (stephen _AT_ umw _DOT_ edu, written as a correct email address) as the “Teacher Share” value, and the string “CPSC 350 fall 2026” as the “Memo”. Make sure you click the correct button after entering each field (one is called “Share” and the other is called “Update Memo.”)
Then, each week, you can complete all of the items in the following codingbat sections:
To claim your credit for the week, you need to send me an email with subject line “CPSC 350 codingbat week # turnin” (where “#” should be replaced with an integer from 1 to 8). In the body of the email, you must type (not copy/paste) the following pledge, followed by your full name (first and last, and middle initial if any) as your signature:
“I hereby declare upon my word of honor that I have completed all the items on this week’s codingbat challenge on my own, with no help from other people or websites, and without pressing the ‘Show Solution’ button on any problem.”
I must receive this email no later than midnight on the day listed above in order for you to receive XP for the week.
Good luck, and happy coding!
Greetings, earthlings, and welcome to the fall 2026 edition of CPSC 350 with Stephen!
This site is gonna be hip-hoppin’ with all kinds of great stuff real soon, so stay tuned!