Data Centric Application Development

Schedule

All content is subject to change
Last updated: 2/9/2018

Week Class Date Topics Readings and tasks due
1 1

1/16/2018

Course Introduction

Activities:

  • Discuss the software titles used in this class, and the
    purpose of each one
  • Walk through the creation of a “hello world” web
    application
Software installations (per video tutorial sent out),

Lynda – HTML Essential Training

  • The Introduction
  • Chapter 1 (“The Importance of HTML” and “Basic HTML
    syntax” only)
  • Chapter 2 (All but “Understanding Content Models”)
1 2

1/18/2018

Chapter 1 – Introduction to web development with PHP

  • The architecture of a web application
  • The product discount application

Activities:

  • Exercises 1.1, 1.2
  • Challenge 1
Lynda – HTML Essential Training, with James
Williamson (Sections 3 & 5)
Murach – pages 4 – 21
2 3

1/23/2018

More web development basics

Activities:

  • Review Solutions to Challenges
  • CSS exercise
Lynda – HTML Essential Training, with James
Williamson (Sections 6 & 7)
Murach – Pages 22 – 41
Challenge 1
2 4

*1/25/2018

Chapter 2 – How to code a PHP application

  • Basic PHP skills· How to get data from a request

Activities:

  • Exercise 2.1
Murach – Pages 46 – 71
3 5

1/30/2018

QUIZ 1 – HTML
3 6

2/1/2018

Chapter 2 – How to code a PHP application

  • Conditional Statements

Activities:

  • Review Solutions to Exercise 2.1
  • Exercise 2.2
Murach – Pages 72 – 91
4 7

2/6/2018

Chapter 2 – How to code a PHP application

  • Loops and Counters

Activities:

  • Exercise 2.3
  • Review Solution to Challenge 2.2
Challenge 2.2
4 8

2/8/2018

CLASS CANCELED / GO EAGLES!
5 9

2/13/2018

  • Review Exam 1 Study Guide
  • Review Solution to Challenge 2.3
  • Exercise 2.4
 Challenge 2.3 (Due 2/9 by midnight)
5 10

2/15/2018

Exam 1
6 11

2/20/2018

Chapter 3 – Introduction to relational databases and MySQL

  • An introduction to relational databases
  • The SQL statements for data manipulation
  • An introduction to MySQL
  • How to use phpMyAdmin

Activities:

  • Exercise 3.1
Murach – Pages 96 – 123
6 12

2/22/2018

Activities:

  • MySQL Exercise
  • Updating your MySQL password
Lynda – MySQL Essential Training with Bill Weinman, Chapter 2
7 13

2/27/2018

Activities:

  • MySQL Exercise #2
  • Export / Import your work
7 14

3/1/2018

Chapter 4 – How to use PHP with a MySQL database

  • Introduction to PDO
    Using PDO with INSERT, UPDATE, and DELETE

Activities:

  • PDO Exercise 1
 Murach – Pages 126 – 137
8 15

3/6/2018

SPRING BREAK – NO CLASS
8 16

3/8/2018

SPRING BREAK – NO CLASS
9 17

3/13/2018

Quiz 2 – MySQL
9 18

3/15/2018

Chapter 4 – How to use PHP with a MySQL database

  • Using PDO with SELECT statements

Activities:

  • PDO exercise 2
Murach – Pages 138 – 156
10 19

**3/20/2018

Activities:

  • PDO Exercise 3 (suggestion box)
  • How to upload your work
10 20

3/22/2018

Chapter 5 – How to use the MVC pattern

  • Introduction to functions

Activities:

  • Review Challenge 4.1
  • PDO Exercise 4 (suggestion box with functions)
11 21

3/27/2018

Activities:

  • Review Challenge Solution 4.2
  • Review how to upload your work
Murach – Pages 180 – 188Challenge 4.2
11 22

3/29/2018

Review for Exam 2
12 23

4/3/2018

Exam 2
12 24

4/5/2018

Chapter 5 – How to use the MVC pattern

  • MVC concepts

Activities:

· Begin challenge 5.1 together in class

13 25

4/10/2018

Chapter 7 – How to work with form data

  • Radio Buttons
  • Check boxes
  • Special characters

Activities:

  • Review Challenge 5.1 solution
  • Exercise 7.1
Challenge 5.1

Murach  – Pages 210 – 223

13 26

4/12/2018

Chapter 7 – How to work with form data

  • Selection lists
  • text areas

Activities:

  • Exercise 7.2
Murach – Pages 224 – 230
14 27

4/17/2018

Chapter 12 – Work with cookies and sessions

  • How to work with cookies

Activities:

  • Review Challenge 7 solution
  • Exercise 12.1
Challenge 7

Murach – Pages 350 – 365

14 28

4/19/2018

Chapter 12 – How to work with cookies and sessions

  • How to work with sessions

Activities:

  • Exercise 12.2
Challenge 12
15 29

4/24/2018

Review for exam 3
15 30

4/26/2018

Exam 3

* Last date to drop is 1/25/2018
** Last date to withdraw is 3/21/2018

Office Hours
  • Tues 4pm-5pm (SP200 / MIS3502 clinic)
  • Wed 10am-11am (SP209 Office)
  • Thurs 1pm-2:30pm (SP200 / MIS3501 clinic)
  • Other times by appointment
Recent Comments
    • Pang’s government spending research wins multiple awards March 1, 2019
      Min-Seok Pang doesn’t follow sports.  “I’m a news junkie, and politics is like my sport,” said the Associate Professor of Management Information Systems at the Fox Business School. So back in 2013, when late-night TV hosts were mocking the botched rollout of HealthCare.gov, the website integral to the Affordable Care Act, Pang stayed on top […]
    • New faculty bring expertise in cybersecurity and innovation November 25, 2018
      Associate Professor Anthony Vance said the most common cybersecurity mistake people make is password reuse. To minimize the threat of a data breach, every online account password must be unique. All that memorization? Impossible. “If you try to remember all the passwords in your head, they’ll be weak. You shouldn’t even try,” said Vance, who […]
    • Fox IT Advisory Board Chair prepares students for real-world challenges November 25, 2018
      During his years overseeing information technology organizations for several large corporations, Bruce Fadem was always surprised that many new employees, even those with newly awarded degrees, were not well prepared for real-world challenges. “Their knowledge was three to five years behind the times,” Fadem said. Temple’s Department of Management Information Systems is an exception, in […]