Team 1

<img Cheap Ray Ban Sunglasses class=”aligncenter” numpy alt=”” src=”http://zacharski.org/files/courses/spring2013pics/110t1.JPG” width=”700″ />

Sean,  Brian Schippers, Anthony (Tony) Markish, Max Johnson, Kevin, Patrick Brig, Savannah wholesale nfl jerseys Stuart

Team 2

<img class="aligncenter" alt="" Cheap Jordans src=”http://zacharski.org/files/courses/spring2013pics/110t2.jpeg” wholesale nfl jerseys width=”700″ />

Fawad Shaikh, Brency Bermudez, Holly Maraist, Adam Kotz, Max Beckham, Peter Guerber, Rachel Youmans,

Team 3 “Pick Six”

 Dominique Giles, Chris Baker, Vaughan Butts, Girard Bucello, Jack  Breheny, Audrey Miller NFL Jerseys Cheap (not shown)

Team 4

Sarah French, Katie Gregory,  Patrick Wayand, Rita Artinian, Zachary Williams, David Ayeh

Section cheap jerseys wholesale 1

Team 1

Brian Johnston, Maddie Lord, Michael Wang, Josiah neuberger, Thomas Sangbouasy, Michael Graf

Team 2

<a cheap Air Jordans href=”http://zacharski.org/files/courses/spring2013pics/s1t2n.JPG”>

Austin Wegner, Elisabeth Ashley, James Deflora, Chris King, Brendan Prin

Team 3 “Team Awesome”

Josh Stemmler, Rob Jarvis, Allie Cropp, Oceana jordans for cheap Peemoeller, William Martin

Team Hacked 4

Tim Henderson, Allan Meyer, David fake oakleys Justis, Marcey Dunlap, Robert Patterson

Team 5

David Heller, Alex Lindeman, Nora Almahdali, Sean Lewis, Abdullah Rahmanyar

Section 2

Team 1

<img wholesale nfl jerseys class=”aligncenter” alt=”” src=”http://zacharski.org/files/courses/spring2013pics/s2t1c.JPG” width=”700″ />

Tim Mihelic, Moe Kahn, Frankie de Paola, Kelly Brown, Erica Mathews, Saad Shami,

Team 2 “Terrible Twos”

Greg Hajduk, kinzie brooks, daniela cardona, osato, brennan miller(kneeling), sam jordan

Team 3

Abdul rahmanyar, Lauren kruczyski, david snellings, Dylan Gott, Steven schmith

Team 4

Dan Easterling, Patrick Mullen, Brent Steffey, Yun Lee, Bradley Ruggiero

Team 5

Sean Healy, Scott Plunkett, michael crawford, kyle khalifa, mohamed moaz

week 01

Tuesday 15 January

• Introduction to Computer Science (bits, binary, programming)
  • Laser Organ
  • Ball Bearing Beat Box
  • Makezine
• Introduction to course logistics

Thursday 17 January

• logistics continued – divide into teams
• Introduction to circuits and the Arduino
• Team Project 1
• Homework 1 Handout

week 02

Tuesday 22 January

• Homework 1 demo  delayed – now due Thursday
• Arduino Software
• Team Task  – blinking light and SOS.

Thursday 24 January

• Team SOS demo
• Homework 1 demo
• Circuit #2 and Partner Task.
• Homework 2 Handout

week 03

Tuesday 29 January

• Homework 2 Demo
• Review
• ‘if’ statements (sample code)
• Partner Task – Potentiometer Fun!

Thursday 31 January

•  Homework 3 – due Monday
• Circuit 3
• Functions
• Binary Numbers

week 04

Tuesday 5 February

• a quiz (on the programs we wrote, binary numbers, if statements, functions)
• Lightning Round Remix. A  Team Task
• discussion of while and for loops
• functions that take an argument.

Thursday 7 February

• Lightning Round Remix. Continued
• More practice with loops.
• Circuit #5 (yes, we oakley sunglasses outlet are skipping #4)
• if statements cont’d.
• Homework 4: Functions and Loops.

week 05

Tuesday 12 February

• Circuit 5 Remix.
• Outside of class – Work through the Lady Ada Lesson 5 tutorial and demo the bike light in class. the more blinky modes the more XP.
  • The values of the resistors in the tutorial differs from the values we have in our kit. You will be able to determine which resistors to use from reviewing Circuit #5.
  • If Lesson 5 is confusing, send me email or see me in office hours.  What I hear via email will determine how much I review this material next class.

Thursday 14 February

• working through the Lady Ada tutorial.
• Lady Ada Team Worksheet
  • video needed for question 7
• Hacker Challenge: 7 segment display
• Homework 5: Baratas Ray Ban complete the Lady Ada bike light. 10XP per mode up to 70XP.

week 06

Tuesday 19 February

• quiz –material from Lady Ada Lesson 5; for loops, functions with arguments, if statements, the logical operators , &&, ||. You should Ray Ban Outlet know the difference between if ((a==1 && b==1) || (c == 1))  and if ((a==1 || b==1) && (c == 1)). For example, what happens if
  • a = Cheap Jordans Sale 1, b = 1, c = 0
  • a = 1, b = 0, c = 1

Thursday 21 February

• intro to arrays
  • team task – 15min – write a function that computes the average of a list
• circuit 4- buttonfied
• circuit 6 – a light sensor
• hw6: Nightlight (due at the beginning of next class)

General Info

Meeting times and location:
Sec 1: TTh 11:00-12:15 Trinkle B6
Sec 2: TTh 3:30-4:45 Trinkle B7
Credits: 3

Instructor: Ron Zacharski

Trinkle B20
googletalk & gmail: ron.zacharski
Office hours:
Wednesday: 11-2 / Friday: 10-12

Nutshell Description

• Normally, this course would be a 15 week course on SQL databases. We will cover all the material from that 15 week course in 11 weeks. The pace of the class is fast.
• The last month of the course will be a mini-course on noSQL databases.
• For the SQL component, we will be going through the textbook, one chapter per week. You are responsible for keeping up with the reading. I will not lecture on material covered in the textbook. In the first 11 weeks there are 5 Readiness Assessment Tests (RATs) that assess whether you have read the material.
• The vast majority of the class time is spent doing not listening to me yabbering away. You will be working on tasks that require you to apply the knowledge you have gained from reading the textbook.
• Because of the hands-on nature of the course, you will need to bring a laptop if you are to gain full benefit from the course.
• There is a 6 week long programming project where teams will design and implement a web application that uses a MySQL database. There is a 3 week long programming project where teams design and implement a web app using a nonSQL database.

Required materials

Textbook: Head First SQL Lynn Beighley Publisher: O’Reilly Media, Inc. Pub Date: August 28, Wholesale Jerseys 2007 Print ISBN-13: 978-0-596-52684-9 http://headfirstlabs.com/books/hfsql

Supplemental material: Depending on your learning style, you may want to pick up a book on PHP programming. There are many good books out there. Among them are

PHP and MySQL Web Development. Luke Welling and Laura Thomsom. Any edition. $34.64 from Amazon.

Head First PHP & MySQL. Lynn Beighley and Michael Morrison. $29.69 from Amazon.

Laptop policy

If you have a laptop I encourage you to bring it to class for several reasons. First, you can install a web server on it and do the in-class lab work (see, for example,the first lab). Second, you can take notes by typing significantly faster than by writing. And finally, you can use the net to research questions I may pose.

Catalog description

Presents logical database modeling and design, emphasizing the construction and analysis of relational schemas. Covers semantics, integrity constraints, functional dependencies, and table normalization. Practical use of relational algebraic operators, the tuple relational calculus, and their expression in declarative query languages. Introduces basic data mining concepts. May involve student team projects to develop small but representative data collection and analysis applications.

Course competencies

On successful completion of this course, you should be able to

• demonstrate a good understanding of SQL including subqueries, joins, and transactions.
• demonstrate the ability to create rudimentary database web applications.
• demonstrate the ability to use the Apache Web Server/MySQL/PHP stack.

Format of course

Teams

During the first day of class, all students will be assigned to permanent teams. Throughout the course, teams will both take team tests and participate in joint activities. Team performance will be one component of your final grade.

This consists of units of study roughly corresponding to the chapters of our textbook. The structure of each unit is as follows. First there will be an assigned reading. Following the reading, there may Ray Ban Outlet be a short multiple-choice test (the Readiness Assessment Test described below). We will then practice applying the material in class both with individual and group work.

Evaluation

Grading is based on a method developed by Professor Lee Sheldon at Indiana University. It is based on obtaining experience points (XP). The number of XP determines what level you are at. You start the class at Level Zero and with 0 XP. The level you obtain at the end of the semester determines your final grade. Here is the chart:

If you are at Level Zero when mid-semester reports are due, I will report your work as unsatisfactory.

RATs -Readiness Assessment Tests – 600XP

There will be approximately 5 short multiple-choice readiness assessment tests given during the course. Each test will be taken individually, then, immediately after, the same test will be taken as a team. Each individual test is worth on average 60 points; each team quiz is also worth on average 60XP. Makeup tests will not be given.

Final – 250XP

The final will be a comprehensive take home final. Often the fate of what grade you receive for a class, hinges on how well you perform on the final given at the last possible moment of the semester.  Our final will work differently. Starting around the midpoint of the semester, I will be posting questions and problems which are part of the final for the course. You can elect to complete the work anytime between the time the problem is posted and our official final exam time. You will gain 10% more XP if you complete the work within a week of the problem being posted.

Projects – 700XP

The projects will be team based using Agile Software Development with Scrum. Scrum is a software development process that works on a development cycle called a sprint. In the case of this class, sprints will be two weeks long. At the end of each sprint each team will demo their application. Projects will also require use of the Git versioning system and GitHub. A significant portion of the XP for the projects is given for strictly conforming to the Scrum process and Git.

MySQL Project
The MySQL Project involves writing a web application using PHP and MySQL about the difficulty level of developing a simple shopping site or simple social networking site.

nonSQL project
This project will involve installing one of the nonSQL servers mentioned on the homepage (e.g., Apache CouchDB) and writing a simple cloud application such as a very rudimentary GoogleDocs application.

Worksheets/Labs -600 XP 

A good deal of class time will be directed at doing hands-on work. Sometimes a group will collaborate on one task. At other times, each individual must Cheap Ray Ban Sunglasses do something (for example, the first task is to get a web server, and mysql server running), but the idea is that everyone in the team will help make sure each individual will succeed.

Team participation – 120XP

Each student will rate the helpfulness of all members of their group. Individual group participation scores will be the sum of the points they receive from other members of their team. Each team member distributes 100 points to other members of the team. The average team participation score will be 100 points. The rater must differentiate some of their ratings (they cannot assign the same rating to all members).

Accommodations for students with special needs

Any student with a documented disability may receive a special accommodation to complete any requirements of this course. If you are have a disability or believe you have one you may wish to self-identify. You may do so by providing documentation to the Office of Disability Services located in Room nfl jerseys cheap 203 of George Washington Hall (Phone: Voice 540-654-1266, Fax: 540-654-1163). Appropriate accommodations may then be provided for you. If you have a condition that may affect your ability to exit the premises in an emergency or that may cause an emergency during class, you are encouraged cheap nfl jerseys to discuss sensaciones this in confidence with me and/or anyone at the Office of Disability Services. This office can also answer any questions you have about the Americans with Disabilities Act (ADA).

Schedule

The class schedule is posted on the course website.

Important details

Here are some other important things you should know.

• Regarding XP.  As in a computer game, there is no negotiation for what XP you need to attain a certain level. For example, level 11 (the level associated with an A-) requires 2000 XP. Last semester someone sent me email saying they had 1998 XP, they worked really really hard all semester and deserved an A-. I gave him the A- but starting now the boundaries are hard and there is no negotiating.
• Cheating. Every semester I have multiple cases of people cheating either through plagiarism or collusion (see above definitions). Minimally, I give a person a 0 for that submission. When I taught a New Mexico, I automatically flunked people for an instance of cheating. For example, last semester two people worked together on the final exam.  When I sent email telling them they got a zero, one wrote back complaining that this would really affect their final grade. In this class, most of the work will be done in groups, but be very mindful of when you should be doing work on your own.
• Crowd sourcing and reducing my Cognitive Load. Here’s the deal. When communicating with me please error on the side of giving me too much information. Last semester, I received emails with sentences like “My partner was Austin” (when there were 3 Austins in the class) or “I worked with Matt”.  It reduces my cognitive load if you specify what section you are in and give full names.

Prior to semester start

If you have time during break, and are looking for something fun to do, here are some possibilities:

• install a MySQL and Apache webserver on your laptop using XAMPP
• play around with node.js  – a javascript web server – way cool.
  • see the resources listed under April 5th – node.js day, below
• start learning PHP
• learn how to use the git versioning system and github.

week 01

Tuesday 15 January

• Intro to Course
• Intro to DB

Thursday 17 January

• lab 1: the XAMPP stack – handout
• preferred alternative install for Linux: https://help.ubuntu.com/community/ApacheMySQLPHP

week 02

Chapters 1 & 2

Tuesday 22 January

• RAT 1: chapter 1: 1 3×5 card of notes
• intro to PHP (pdf of slides)
• alien abduction zip file.

Thursday Oakleys sunglasses Outlet 24 January

week 03

Chapter 3

Tuesday 29 January

• Intro to PHP continued
• PHP and MySQL in 15 slides (or so)
• Team Task – finish alien2013
• Partner Task – basic blogging site – CPSC Posts (demo)

Thursday 31 January

• RAT 2: chapters 2 & 3: 1 3×5 card of notes (test is picky about syntax)

week 04

chapter 4

Tuesday 5 February

• Lightning round
• tomatoes.sql & world.sql   (note: these sql files only contain the tables – you should first create a database)

Thursday 7 February

• First 45 minutes:
  • Introduction to Scrum.
  • Discussion of project
  • Requirements of First Sprint
  • Intro to GIT  (Git video)
  • Git Cheat Sheets:  This one, and another
  • GIT assignment –
  • Session control and dangerous characters
• Last 30 minutes
  • finish blog and demo.

week 05

chapter 5 & start of project

Tuesday 12 February

• GIT assignment demo
• The project
  • self-organize into teams (2-4 people per team)
  • Project design meeting ~ 20 minutes
  • Sprint email due Wednesday 11:59pm
• PHP – Sessions and dangerous characters
  • session code at https://github.com/zacharski/sessionDemo.git— do git clone
  • pdf of slides

Thursday 14 February

•  PHP odds and ends

week 06

chapter 6

Tuesday 19 February

• RAT 3 – chapters 4-6 – 1 3×5 card

Thursday 21 February

• Lightning Round
• umw.sql
• world.sql (you probably already have this)
• tomatoes2.sql

<img class="alignleft" title="sql2" alt="" src="http://www.zacharski.org/wp-content/uploads/2010/02/sql2.jpg" width="270" NFL Jerseys Cheap height=”313″ />

Spring 2013

Sec 1: TTh 11:00-12:15 Trinkle B6
Sec 2: TTh 3:30-4:45 Trinkle B6

Instructor: Dr. Ron Zacharski

gmail & googletalk: ron.zacharski

Office hours:
Wednesday: 11-2 / Friday 10-12

XP Spreadsheet

Course Description

This course provides an introduction to databases and their application. We will also examine database integration into web applications. The course covers both SQL, an industry standard database model, and more cutting edge approaches such as Facebook’s Cassandra database system, Google’s BigTable, Apache CouchDB, and Amazon’s Dynamo–all designed to handle petabytes of data.

Hands-on nature of course

Here is a nutshell description of the course.

Textbook. The textbook is Head First SQL by Lynn Beighley. This book is structured as a workbook. There are pages where you are meant to pencil in your answers. The answers are then given on the next page. So you have a choice. You can read through the chapter without fully engaging your head skipping the fill-in-the-blanks part and just reading the answers. Or you can use this book to actively learn the material. The price of the book is only wholesale nfl jersyes $30 at Amazon so writing in the book isn’t that financially painful.

Last semester cheap oakleys I read How to Become a Cheap Jordans Straight-A Student: The Unconventional Strategies Real College Students Use to Score High While Studying Less by Cal Newport (his Soundtrack: blog Study Hacks is worth checking out). In his book he recommends an approach to reading assignments where you skim the assigned reading instead of reading comprehensively since the instructor will lecture on the material. While I think this advice is great for many classes it is not an approach that will be effective in this class. When I give a reading assignment I will assume you know the material and worked through the examples in the text.

Class time. I am trying to avoid lecturing on the same material covered cheap Air Jordans in the textbook. The lecturing I will do will center on PHP programming. The majority of class time will be devoted to working through problems, clearing up any confusions, and working hands-on with a database. To that end you will need to bring to class either a laptop or USB memory stick containing a working apache web server- mysql server – php stack.