Unit 00 · Practice
Practice
Every unit in this course ends with a practice, and the practice is what you turn in for that unit. This is the first one. It's about the syllabus, and it's here so you can learn how a practice works before there's any SQL in the way.
I grade practice on completion. The page tells you whether each answer is right, so what I'm grading is that you did the work. That also means there's no reason to have AI do a practice for you. What I said about AI covers how I think about that.
There are four steps. After them there's a note about what I see when you turn a practice in, and what to do next.
Most questions have an answer box and a Check button. When you check an answer, the page tells you right away whether it's correct. If it isn't, change it and check again. You can try as many times as you need.
The list of questions on the left shows where you are. An empty dot means you haven't started that question. Yellow means you've tried it. Green means it's done.
This course is SDEV 201. First type 200 in the answer box and click Check, so you can see what a wrong answer looks like. Then type 201 and check again.
Before you go on, click History under question 1. Both of your tries are there, with the time. Every practice keeps a history like this, and I can see it when you turn the practice in. You can't clean the history up, and I don't want you to. A messy history is normal, and it's what I expect to see. All that matters is that you get to the right answer by the end.
The rest of the questions are about the syllabus. Have the syllabus open in another tab. When a question asks for a number, type only the number.
What percentage of your final grade is the final exam?
How many hours after a due date can you still turn something in for full credit?
After that window has passed, what percentage penalty does late work get?
On Tuesdays, what hour do drop-in office hours start? Type just the number.
How many hours in advance does an office hours appointment have to be booked?
Reload this page now. Your answers are still here. Your work is saved in this browser, on this computer. Closing the tab is fine, and so is restarting your computer.
The last four questions are multiple choice. Pick an answer and click Check, and it tells you why that answer is or isn't the one.
Which of these are the drop-in office hours, when you can join the Zoom room without an appointment?
You're stuck on a practice question. Which of these is a good way to use AI?
How is the final exam taken?
You need more time on an assignment than the 48-hour late window gives you. When do you have to ask for an extension?
This part is the same for every practice in the course.
- Type your name in the box below, the way it shows up in Canvas.
- Click Download submission. A file is saved to your computer, usually in your Downloads folder. It has a summary of what you finished and the full history of what you tried. You don't need to open it or change anything in it.
- Go to the Start here practice assignment in Canvas, click Start Assignment, upload that file, and submit.
You can turn a practice in as many times as you want. The last one is the one that counts. If you're partway through a practice and want to be safe, download what you have and turn it in. Then do it again when you finish.
That same file is how you move to a different computer. Your work is saved in the browser you did it in, so it won't show up on another computer, or in another browser on the same one. If you need to switch, download your submission here. On the other computer, open the same practice, click Resume from a file, and choose the file. Everything comes back. You can try that now if you'd like to see it work. It just loads the answers you already have.
When you're done, download your submission file and upload it to the Start here practice assignment in Canvas. It carries a summary of your progress and the record of every attempt you made on this page. You can submit as many times as you like; the last one counts.
Attempts are saved in this browser. To keep going on another computer, download your submission here and resume from it there.
When you turn in a practice, I see which questions you finished and the answer you ended up with on each one. That's what your credit is based on.
The file also has your full history. I do not typically go back and read through it. If a question took you 100 tries, that's fine. It doesn't affect your grade at all.
There are two reasons the history is there. The first is the check-in. If you're struggling in the course, it's very useful for me to see how you've been working with the material. The second is that it discourages having AI do the work. If you finish a whole practice in five minutes and get everything on the first try, that's great. But then I'm going to expect that same ability when we talk. The only time you need to worry is when your practices don't match how you do when you're talking to me.
Don't change the file. It has to be exactly what you downloaded from this site. There's a checksum in it, and my tools tell me when a file has been edited. If you edit one to make something look finished, I'll reject the whole assignment.
Don't share the file either. I also have a tool that compares histories across the class. Two people who worked separately don't end up with the same tries at the same times. If two histories are the same, or nearly the same, I'll know a file was shared.
Could somebody get around that with enough effort? Probably. But it would be a huge pain. It's much easier to just do the practice yourself. You need to know this material for the final anyway.
Once you've turned in your file on Canvas, you're done with this unit. I should have it graded within the next week.
If you just did a bunch of work, take a break. It's always good to step away from the computer for a bit.
When you're ready, the next thing to do is Unit 01. There are two ways to get there. On this site, click SQL for Data Analytics at the top left to go back to the home page, and then pick Unit 01. Or open the Unit 01 assignment in Canvas and follow the link there.