Day 48 - Databases and SQL - 10.23.15

Unit 2 - The Internet
  • Lesson 2.1 The Internet and The Web
    • In this lesson, the goal is to build student understanding of the Internet as a set of computers exchanging bits in the form of packets, and for students to identify the components of their digital footprint. To provide a hook, students compare the designs, strengths, and weaknesses of their favorite web pages. In this context, students use an unplugged activity to understand (in broad brushstrokes) the content and flow of data when browsing the Web. They compare results from different search engines and learn to refine their search techniques. They review how to assess the trustworthiness of web-based media and consider the data flow that permits targeted advertisements. Students employ appropriate tools to explore the hierarchical nature of DNS and IP. Students identify ways that a web developer’s decisions affect the user and ways that the user’s decisions impact society. The tree structure of web documents is introduced alongside HTML and CSS. Paired key encryption and authentication are introduced with an unplugged activity.
    • Lesson 2.1 Reference Card for UNIX, HTML, and CSS
  • Lesson 2.2 Shopping and Social on the Web
    • The goal for this lesson is for students to understand the role of client-side code, server-side code, and databases in delivering interactive web content. The hook is a project in which CS students collaborate with art students to publish content on the Web. Students are provided with JavaScript and PHP code and can access an SQL database from a secure shell command line as well as through PHP. Students compare languages encountered so far to generalize the concepts of sequencing instructions, selection of instructions by conditionals, iteration, and the common roles of variables. Students explore and compare career paths within computing.
    • Essential Questions
      • Q1 - How does the Internet work?
      • Q2 - How can we protect ourselves, our privacy, and our assets when working on the Internet?
      • Q3 - How has the Internet affected society?