{"id":959,"date":"2013-05-12T23:18:57","date_gmt":"2013-05-13T06:18:57","guid":{"rendered":"http:\/\/hybridclassroom.com\/blog\/?p=959"},"modified":"2013-05-12T23:18:57","modified_gmt":"2013-05-13T06:18:57","slug":"dynamic-response-vs-lesson-planning","status":"publish","type":"post","link":"https:\/\/www.hybridclassroom.com\/blog\/?p=959","title":{"rendered":"Dynamic Response vs. Lesson Planning"},"content":{"rendered":"<p>DYNAMIC RESPONSE VS. LESSON PLANNING<br \/>\nRichard White<br \/>\n2013-04-27<\/p>\n<p>&#8220;We plan now so we can improvise later.&#8221;<\/p>\n<p>Tuesday had been a decent day with the students in my Computer Science class. After having taken a few days to work through the concept of a flat-file database, and writing a small AddressBook.py program that would manage their contacts, I&#8217;d taken Tuesday to introduce the concept of a relational database. The transition from &#8220;rows and columns&#8221; in a text file to &#8220;records and fields&#8221; in a database was easy enough, and after a quick look at a typical page on Reddit&#8211;essentially a large discussion board where people can write a follow threaded messages&#8211;we&#8217;d designed our own tables that would do the same thing. We were all set for Thursday when students would actually start writing a Python program to implement the idea.<\/p>\n<p>We were poised to work on this activity, just as my students had done for the last couple of years&#8230; but late Wednesday evening, as I anticipated the next day&#8217;s teaching, I decided to change it.<\/p>\n<p>It was one of those realizations that comes later, only after you&#8217;ve planned something and maybe even tried it out a few times, a realization that reveals in shocking and funny ways how hard it can be to anticipate everything. I realized that one potential stumbling block for students in the past couple of years had been the fact that using databases requires the introduction of a new language&#8211;Structured Query Language, or SQL&#8211;which I probably (certainly) hadn&#8217;t prepared them for. In the rush to get them working on the Python code, I&#8217;d glossed over some of the key concepts that they&#8217;d need to understand if this assignment was going to be useful in building their understanding.<\/p>\n<p>This was partly by design. At the end of the school year, there was little time to devote to a large unit like this, so I&#8217;d opted to try to squeeze it all into a week, and the students were faring about as well as you&#8217;d expect they would: they were getting confused and frustrated by trying to do too much too quickly.<\/p>\n<p>So Wednesday night, from 11pm to 12am, I sat down and bashed out a new discussion\/demonstration for the next day. It would be laptops-closed for twenty minutes or so as we developed GradeKeeper, a database that I could use to track their scores on assignments. We would develop the tables in class&#8211;studentTable, assignmentTable, scoreTable&#8211;emphasizing the concept of primary keys and foreign keys&#8211;and then I would show them a working model of the database in class. I &#8220;quickly&#8221; jotted down the development process that I wanted to take them through in class, and threw together (in SQLite) the database itself that I would show them, with 3 sample students, 6 assignments, and 18 recorded scores.<\/p>\n<p><a href=\"http:\/\/hybridclassroom.com\/blog\/wp-content\/uploads\/2013\/05\/gradeKeeper-keys.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/hybridclassroom.com\/blog\/wp-content\/uploads\/2013\/05\/gradeKeeper-keys.jpg\" alt=\"gradeKeeper-keys\" width=\"1200\" height=\"937\" class=\"aligncenter size-full wp-image-961\" srcset=\"https:\/\/www.hybridclassroom.com\/blog\/wp-content\/uploads\/2013\/05\/gradeKeeper-keys.jpg 1200w, https:\/\/www.hybridclassroom.com\/blog\/wp-content\/uploads\/2013\/05\/gradeKeeper-keys-300x234.jpg 300w, https:\/\/www.hybridclassroom.com\/blog\/wp-content\/uploads\/2013\/05\/gradeKeeper-keys-1024x799.jpg 1024w, https:\/\/www.hybridclassroom.com\/blog\/wp-content\/uploads\/2013\/05\/gradeKeeper-keys-150x117.jpg 150w, https:\/\/www.hybridclassroom.com\/blog\/wp-content\/uploads\/2013\/05\/gradeKeeper-keys-400x312.jpg 400w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/a><\/p>\n<p>It was an hour later before I finally crawled into bed, but that new lesson, presented the next morning, turned out to be just the &#8220;Ohhhhh&#8230; I get it!&#8221; step that had been missing in my students&#8217; understanding in previous years.They still weren&#8217;t ready to run out and develop the DicussionBoard program completely on their own just yet, but they had a much better idea of the method behind the madness when their programs executed an otherwise arcane-looking SQL query.<\/p>\n<p>Now you probably don&#8217;t teach Computer Science and those five or six paragraphs above may be a bit arcaane themselves, but the point is this: planning what we do in the classroom is, for me, a vital step in improving my effectiveness as a teacher. Without planning I can certainly walk into the classroom and speak extemporaneously, and if I&#8217;m lucky and the material isn&#8217;t too technical, my brighter kids will be able to pick up most of what I&#8217;m talking about.<\/p>\n<p>But to be most effective, we need to carefully consider the logical steps that will help our students build their understanding of a topic. That kind of careful consideration comes with planning, and (in the example above) comes with reflecting on plans that have been delivered in the past.<\/p>\n<p>Lesson planning is a good first step, but it needs to be followed by reflection on the effectiveness of the lesson as well, and with a willingness to improvise as required. Lesson planning doesn&#8217;t mean that we are required to strictly adhere to those plans, lock-step and with no awareness or consideration of how students are responding to the experience.<\/p>\n<p>But it&#8217;s a good first step to delivering great instruction, and will provide a jumping off point for furter development and exploration of your teaching strategies.<\/p>\n<p>Whether it&#8217;s notes on paper, a text file on the computer, or a PowerPoint presentation, planning instruction will make you a better teacher.<\/p>\n<p>Give it a try!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DYNAMIC RESPONSE VS. LESSON PLANNING Richard White 2013-04-27 &#8220;We plan now so we can improvise later.&#8221; Tuesday had been a decent day with the students in my Computer Science class. After having taken a few days to work through the concept of a flat-file database, and writing a small AddressBook.py program that would manage their &hellip; <a href=\"https:\/\/www.hybridclassroom.com\/blog\/?p=959\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Dynamic Response vs. Lesson Planning<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[57,22],"tags":[],"_links":{"self":[{"href":"https:\/\/www.hybridclassroom.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/959"}],"collection":[{"href":"https:\/\/www.hybridclassroom.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hybridclassroom.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hybridclassroom.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hybridclassroom.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=959"}],"version-history":[{"count":4,"href":"https:\/\/www.hybridclassroom.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/959\/revisions"}],"predecessor-version":[{"id":964,"href":"https:\/\/www.hybridclassroom.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/959\/revisions\/964"}],"wp:attachment":[{"href":"https:\/\/www.hybridclassroom.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=959"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hybridclassroom.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=959"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hybridclassroom.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=959"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}