Slide 11
Slide 11 text
Selecting Content 11
■ Topics
■ Organization
■ Specifics
■ Organization
■ Examples
When selecting the content, I like to start on the most macro level: the biggest topics. You want to cover maintaining state, SQL,
defining functions, MySQL, creating templates, etc. These topics go into that end goal: where the student ought to theoretically
be at the end of the material.
Then you start organizing those big topics. This is where you start hitting your first tough decisions. Obviously SQL needs to be
explained before MySQL, and those both need to be explained before you do PHP and MySQL. But where do you discuss sessions?
Well, that kind of doesn’t matter. Do you discuss arrays before control structures or vice versa? I’ll return to this subject later.
The organization of the material makes it easier to learn or not. But you also need to structure it into properly-sized chunks. 50
page chapters are a no-no (as a general rule), as are 2 hours of live instruction without breaks. On the other hand, just explaining
dates and times ends up being a really short chapter or lesson, so where should you put that material?
Next, you need to get into specifics. You’ll discuss for and while loops, but not do...while. You’ll explain running normal queries
but not prepared statements. You’ll do procedural code, but not OOP. The specifics are the most concrete knowledge the student
will go away with and dictates how happy they are with the experience. It’s easy to come up with general topics that everyone
agrees on. And you won’t normally get in trouble for your organization, unless it’s wildly unconventional.
Then you need to structure the specifics within the topics. This can also be tricky. For loops or while loops first? All of these
decisions are impacted by the examples you use.
Good examples make all the difference. Your examples need to be as real-world as possible. Avoid the “here’s something you
could do but never will” examples. It’s a waste of time. If you organize your material well, sometimes you can build up examples
over time, introducing new concepts by adding bits to existing ideas. This makes the learning easier for the students, and saves
you time and space.
It’s best if you can think of the examples during the outlining stage. If not, you’ll end up changing the outline during the
development stage when you struggle with certain examples.
For live classes, I think it’s best to use real-world examples that your students come up with. This is not easy, but it makes the
material more applicable. And you can cheat a bit to implement their example within some additional constraints.