Tusedays 4:00-6:30 TEB 240
Office Hours 2-4 T/TH
Instructor: Dr. Gerry Swan (gswan@uky.edu)

Week	Topics	Assignment Due
1/15	Course Introduction Setting Up Accounts
1/22	Passing Data (POST vs. GET) Basic Calculations Variables Redirection	1. Be ready to work in PHP on SWEB account. Write help@sweb.uky.edu to request MySQL access 2. Read Chapter 1 in the Information Systems book
1/29	Looping MySQL Basic DB Application	1. Create an interaction that takes some input from a user and creates a customized response.
2/5	Basic DB Application	1. Modify the code in the display part of the basic DB application to work with your table from the EDC 777 database.
2/12	Server Side Includes Relational Databases and Joins LEFT ON SQL Aggregation with GROUP BY	1. Create a new application based on the basic DB application
2/19	Relational Databases and Joins JOINS for > 2 tables Creating a dynamic pulldown menu	1. Alter you previous application to include a second table. 2. Read the following essays on web 2.0 and programming in your head
2/26	Creating a custom WHERE statement based on user input empty() Keyword Search MySQL PHPMyAdmin Search Code	1. Research and develop the delete mechanisms for the gradebook application. You can do one that removes records from the assignments table when a student is deleted or one that removes grades for an assignment when that assignment is deleted.
3/4		1. Bring in an idea for a final project 2. Complete the search example by integrating a keyword search 3. Revisit the DELETE JOIN
3/11	Spring Break
3/18	Creating an authentication system with cookies	Midterm Due: A polished grade book application that: - calculates individual assignment grades - calculates a student class grade - includes ability to add, update and delete records for all tables
3/25		Create a DB driven authentication system usign an iD, Passowd and User Level. Have some element of the home page change based on the user level (e.g. background color)
4/1	File upload form File Upload Code File upload form 2
4/8
4/15
4/22	ajax.php ajax2.php gethint.phps time.phps - AJAX - Tutorial
4/29	ajax example 3 ajax example 4	Final Application Due:

Office:134C Taylor Education Building
PHP/MySQL Resources

Course Description:
This course addresses the use and integration of web scripting in an academic setting. This course will address the four themes of the conceptual framework for the UK professional education unit:  research, reflection, learning, and leading.  Students will be given the opportunity to review, analyze, discuss, and apply research from diverse perspectives in education.  Reflection will also be integrated into students’ learning opportunities through the production of written essays, group discussion and media production to help students take advantage of the analytical and problem-solving skills that comprise critical professional reflection on one’s own teaching. This course emphasizes the commitment of the professional education unit to ensure that its graduates move into their professional lives equipped for life-long learning as educators who will be active in leading colleagues in their schools, districts, and professional organizations.  The ultimate goal in addressing these four themes is to produce teacher leaders who work together to improve student learning among diverse populations and improve education in Kentucky and beyond. Additionally, students will be prepared to serve a more diverse population of learners through exploration of how all people learn.

Course Goal and Objectives
This goal of the course is to help the inservice teacher integrate appropriate technology in their instruction. Specifically, the course addresses the following objectives:
1) Participants will be able to use a variety of technology applications for educational purposes
2) Participants will learn to integrate technology into their teaching strategies to enhance and manage learning.
3) Participants will develop a intellectual framework for critiquing and designing educational experiences incorporating media

Required Materials
All students will be required to have a USB pen drive to transfer work to and from class. Pen drives can be purchased from a variety of places and should be 128 MB.

Expectations and Grading
To do well in EDC 777, you should come prepared to all class sections and actively participate in them. You must complete your assignments fully and turn them in on time. No late assignments will be accepted unless the instructors are contacted beforehand.

Final project - 20%
Midterm - 20%
Weekly Assignments - 60% (this will consist of reading reactions, minor software assignments etc.)

Plagiarism
Students should familiarize themselves with the Student Code regarding plagiarism (section 6.3.1), which can be obtained from the office of the Dean of Students or retrieved from http://www.uky.edu/StudentAffairs/Code/part2.html section 6.3.1. Plagiarism of any type will result in a failing grade.

Class Attendance and Participation
Class attendance is required for all class sessions. Information will be presented in each class that is not available through other means. Successful completion of course objectives requires that students have hands-on experience with hardware and software that is used during class sessions. Missed class will be counted as a failed assignment.