Location: Holroyd Hall Room 133

I N S T RU C T O R

C O N T A C T I N F O RM A TI O N

Instructor: Thomas Blum

Location: Holroyd Hall Room 133

Email:

Phone: 215.951.1139

I N S T R U C T O R B I O

My formal background is in physics (undergraduate at La Salle University and graduate at the University of Rochester). I worked as a postdoctoral researcher for the seven years (at the University of Pittsburgh, University of Manchester, and University of Virginia.) I started teaching at La Salle in 1998. I teach a variety of courses — including over the past two years: Programming Concepts and GUIs, Client-Side Scripting, Open Source Application Development, Mobile Computing, Computer Architecture, Client Support, Administrative Scripting, Computer Electronics, General Physics Laboratory, and Scientists’ Frame of Reference.

COURSE OVERVIEW

This encompasses programming models that support database access. It covers client/server and multi-tiered architectures; development of database applications; Internet and intranet database design and implementation; database-driven Web sites; and use of XML and/or JSON syntax related to databases. The toolset for this course will not be Windows based. An example of a possible toolset is PHP and mySQL on an Apache, Windows or MAC server. The course also considers privacy of data and data protection on servers.

Prerequisite: CIS 523, CIS 622 or permission of instructor.

C O U R S E D A T E S

The course runs from 5/18/2015 to 7/30/2012.

P R E R E Q U I S I T E S

The pre-requisites for this course are CIS 523 Database Management Systems and CIS 622 Introduction to Web

Programming. We will be working with PHP and MYSQL. You will need to install phpmyadmin via a XAMPP installation on your local machine. We will have access to phpmyadmin on a Windows IIS server on La Salle’s system. You will receive the installation directions via a document in Week 1.

LEARNING OBJECTIVES

·  Consider "classical" client/server architecture and the problems associated with it – especially those associated with server-side scripting.

·  Develop examples using client -server architecture on a non-windows database interface

·  Discuss data access, use of objects for data access, and a separate level for data access.

·  Discuss business rules, use of object for business rules and a separate level for business rules.

·  Address scaling and other backend challenges.

·  Design and implement a general class

·  Design and implement a solution for a form process including validation and security

·  Implement a server-side solution with persistence using session variables and/or cookies Design and implement a database solution to a proposed scenario

·  Design problem solution to retrieve information from a database

·  Develop maintenance applications for database tables

·  Develop and implement an authentication and authorization system

R E Q U I R ED T E X T B O O K S A N D M A T E RI A L S

T E X T B O O K S

Programming PHP

by Kevin Tatroe, Peter MacIntyre & Rasmus Lerdorf

O’Reilly

ISBN: 978-1-449-39277-2

S O F T W A R E / H A RD W A R E R E Q U I R E M E N T S

· Software Applications

o PHP editor of your choice (see http://en.wikipedia.org/wiki/List_of_PHP_editors)

o phpmyadmin– via downloads (XAMPP do a google search to find the most recent download for your machine)

o Mysqlworkbench—download and directions for creating a database and using the package. http://csc-srv1.lasalle.edu/mccoey/mysqlworkbenchinstaller/

· Additional hardware, for example

·  Microphone, ear phones and Place to save class and home work

ONLINE RESOURCES

·  http://www.php.net/manual/en/ (PHP)

·  http://www.w3schools.com/html5/ (HTML5)

·  http://validator.w3.org/ (HTML Validator)

·  http://www.w3schools.com/css/ (CSS)

·  http://jigsaw.w3.org/css-validator/ (CSS Validator)

·  http://www.w3schools.com/js/ (JavaScript)

·  http://www.w3schools.com/jquery/ (jQuery)

·  http://www.w3schools.com/json/ (JSON)

·  http://www.w3schools.com/ajax/ (AJAX)

ONLINE BOOKS

To find one set of relevant ebooks in La Salle University Connelly Library collection, go to the online catalog and do a keyword search on "safari online".

Title(s) relevant to this course include:

·  Learning PHP, MySQL, JavaScript, and CSS: a step-by-step guide to creating dynamic websites / Robin Nixon

·  Beginning PHP and MySQL: from novice to professional / W. Jason Gilmore

·  JavaScript by example / Ellie Quigley

·  Speaking in styles: fundamentals of CSS for Web designers / Jason Cranford Teague

·  The ultimate HTML reference / Ian Lloyd

T E C H N I C A L S U P P O R T

Technical support information will be provided by academic computing. They may be reached by contacting

215.951.1788. You may also submit a help request by visiting http://helpdesk.lasalle.edu. The help desk cannot resolve issues dealing with software that is used specifically for this course.

C O U RS E S T R U C T U R E

This course will be set up by giving a folder for each week of class. You will be asked to read the directions and complete the assignments. For most weeks, the typical learning module format will be

·  Directions for the module

·  Tutorials

·  Slide presentations

·  Posted examples

·  Weekly assignment(s)

Majority of course work will be done online. When working online, assignments, conversations, and postings that are scheduled and due in a week’s time are expected to be completed in that week. The online week runs from Tuesday 12:01 AM to following Monday evening (11:59 PM). Weekly folders will be available for your use by 12:01 on Tuesday. If you have a schedule issue, during the course, you need to contact me as soon as possible. I am planning to host online synchronous sessions for additional help. The synchronous sessions will be your opportunity to get additional help with course materials. The sessions will be archived so you can view them later.

C O U RS E R E Q U I R E M E N T S

P A R T I C I P A TI O N

Completion of student assignments and project is required.

We will be holding several synchronous sessions. You can expect we will be working together for one hour from 7-8 on those nights. Meetings will be schedules as needed.

P R O J E C T /A S S I G NM E N T D U E D A T E S

There will be individual assignments which build on the material covered each week. Students are also expected to code materials from the presentations themselves.

There will be a semester project due the last week of the semester.

L E A R N E R E X P E C TA T I O N S

Students are expected to:

· Complete all readings, look through the slides and posted examples, watch the tutorials, and complete assignments for that week.

· Check the online course material and email at least 3 times a week.

· Participate actively in both online and in-class sessions by asking questions

· Engage the instructor immediately if any problems arise that may prevent the student from completing the above weekly requirements

The instructor is expected to:

· Post all course materials and assignments in a timely manner

· Make him/herself available by email and/or online chat for student questions or concerns

· Check the course regularly

· Provide each student with timely feedback on their progress in the course

· Grade and return all assignments in a timely manner

E V A L U AT I O N AN D AS S ES SME N T O F L E A RN E R P E R F O R M A N C E

A C A D E M I C H O N E S T Y

A high level of responsibility and academic honesty is expected from our students and it is imperative that a student demonstrates high ethical standards in his/her academic work. Academic dishonesty includes, but is not limited to, submission as one’s own work or material that is not one’s own. Plagiarism from the web or from any other source is unacceptable and will be dealt with under the university’s policy on plagiarism. Students suspected of academic dishonesty are subject to disciplinary actions. Please refer to the LaSalle Student handbook.

If you have a question about the authenticity of your work, LaSalle makes available to you a data base service called “Turn It In”. You instructor will give you all the information to use it. The purpose of this service is to help you identify areas where you might improve our writing and source referencing.

C O U RS E P O L I C I E S

L A T E W O R K P O L I C Y

In the event that an assignment is turned in late, you are required to notify me by email that the work has been completed. At my earliest convenience, I will then grade the late work and update your grade.

C O M M U NI C A TI O N

Please be aware when you email me with a question or concern to allow 24 hours for a response. In most cases the reply will be much sooner. I believe that prompt and relevant feedback to your questions, and concerns, is of extreme importance.

Concerning email, you must put your NAME on the email and YOUR CLASS AND THE ASSIGNMENT OR ISSUE YOU ARE REFERRING TO IN THE SUBJECT LINE OR the reply may be delayed. Please comply with this request to ensure a prompt response from me. Another mode of communication is the synchronous tool. The class synchronous area allows us to chat in "real-time" during a mutually arranged appointment.

E T I Q U E T T E

Please understand that there is a certain type of etiquette that must be upheld in the class when turning in college work. To this end, refrain from slang, derogatory language, caps, and any potentially offensive forms of expression. Hence, when you approach your instructor or other students with questions or comments, you should always

maintain a professional tone.

G R A D E S

The intention is to grade assignments within one week after the scheduled due date. I ask that you please refrain from asking questions on grades before the one week window.

A superior level of competency

A- very good level of competency

B+ good level of competency

B average, satisfactory level of competency

B- less than average level of competency

C marginally satisfactory level of competency

F failure to demonstrate a satisfactory level of competency

I work not completed within the current semester period

W an authorized withdrawal from a course (This must be processed by the graduate office.)

Each week students will have approximately 1.5 to 2 hours of lecture material. Students are expected to reproduce lab work presented in the lecture material. This lab work will include student coding of material presented.