SQL for Data Analytics · About the final exam
About the final exam
The final exam is on Thursday, December 10, from 12:00 to 2:00 PM, in person, on paper, at the Auburn Center, room 310 (1221 D St NE, Auburn).
The final is half your course grade.
On paper, in person (recommended). About 10 questions, similar to the practices you've done all quarter, with two hours to work. This is the option I recommend for most students. You have plenty of time, and the format is straightforward.
One-on-one on Zoom, during finals week. I ask you two or three questions over about 15 to 20 minutes, and how well you do on them is your grade on the final. It works a lot like the midterm check-in, except it's graded, and it can cover anything from the quarter. You share your entire screen and keep your webcam on for the whole meeting. Most students find this more stressful than the paper exam.
You don't need to sign up for anything yet. If you can't make it on December 10, get in touch with me and we'll set up the Zoom option.
The final covers the whole course. Questions may ask you to:
- Write a query that gets specific information from one or more tables.
- Read a query and say what it returns.
- Create a table, or insert rows into one.
- Write a query from an entity relationship diagram.
- Draw an entity relationship diagram for a set of tables.
The questions are meant to be clear. There are no trick questions. If you can do the kinds of problems in the practices, you're ready.
You can't bring your own notes. A cheat sheet with the syntax of every command you'll need comes with the exam. It's the next page, so you can get used to it before the exam.
Thursday, December 10, at 11:59 PM is the last moment I can accept any work for the course, late or otherwise. I submit grades the next day, so anything that isn't in by then isn't scored.