SQL for Data Analytics · Learning to Learn

Learning to Learn

Watch25 min

Before any SQL, this video is about how learning actually works, and how to get more out of the time you put into this class.

Learning to Learn25 min

Pause and answer

Take a couple of minutes with these before you move on. They're just for you. They aren't graded or turned in. Answer first, then open mine and compare.

Explain the concept of "distributed practice" in your own words and why it's more effective than cramming.

How I'd answer it

It's spreading your practice out over time instead of doing it all at once. One hour a day for seven days, instead of seven hours in one day.

Cramming feels better while you're doing it. After seven hours on something you feel really competent. But most of that is sitting in short-term memory, and it's gone within a few days. When you spread it out, you come back the next day and some of it has faded, and you have to work to pull it back. That feels worse, but recalling it after a gap is the thing you're trying to train. That's what builds the kind of memory that's still there a month later.

The goal of your learning should be to build a "mental model" rather than only memorizing facts. How might you approach your studies differently to focus on building this kind of understanding?

How I'd answer it

Memorizing a command only helps you when you run into the exact problem that command fits. A model of how things work lets you reason about problems you've never seen.

So instead of rereading or copying things down, I'd spend the time connecting things. Put it in my own words. Come up with my own example. Ask how this idea is different from the one I learned last week, and when I'd use each. Try to explain it to somebody else. And test myself before I look at the answer, even on the basic stuff, because the only way to find out whether I actually know something is to try to use it.

Feels like learning vs. is learning

A lot of what feels like studying doesn't do much, and the things that work tend to feel slower and harder while you're doing them.

That's not because rereading or highlighting are bad. They're tools, and they help when they're supporting something else. On their own they just don't make you learn anything. It's like trying to hammer in a nail with a screwdriver.

Sort it

For each one, decide: does it mostly feel productive, or does it actually stick?

Why spreading it out works

If you put seven hours into something in a single day, you'll feel like you've got it by the end. That feeling is common enough that it has a name, the illusion of competence. Most of what you just took in is only in short-term memory.

Coming back a day later is harder. It feels like you forgot everything. But recalling something after a gap is exactly the skill you're trying to build, and every time you do it, it fades more slowly.

Try it

Two students each study seven hours. One does it all on day 1. The other does an hour a day for a week. Drag the test day and see who remembers more.

This is a sketch of the pattern the research shows, not data from real students.

So when I tell you to start early, it isn't really so you'll have time to ask for help, although that's nice too. It's because you can't do distributed practice the night before something is due.

What this looks like in this course

I've tried to build all of this into the course, so you mostly just have to go along with it.

  • When I ask you to pause the video and answer something, actually pause it. Even if you have no idea. Spend thirty seconds trying. Watching without doing that is like going to the gym and lifting a one pound weight over and over.
  • Answer the questions under each video. Come up with your own answer before you open mine.
  • Work a little most days. Pick your days and times, put them on your calendar, and guard them. Asynchronous means you get to choose your structure. It doesn't mean you can get away with not having one.
  • Don't skip the basics because you think you already know them. The first few lessons are going to feel simple on purpose. A piano player never graduates from practicing scales.
  • Take breaks, and sleep. A lot of what you learned gets sorted out while you're asleep. Don't trade sleep for cramming.

If you want more on any of this, the book I'd recommend is Make It Stick: The Science of Successful Learning.