Data Centric Application Development

Schedule

All content is subject to change

Last updated: 2/10/2017

Week Class Date Topics Readings and tasks due

1

1

1/17/17

Course Introduction, Software used in this class

Activities: Exercise 1

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/19/17

Chapter 1 – Introduction to web development with PHP

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

Activities:

  • Exercises 1.1, 1.3
  • HTML Challenge (begun in class)
Lynda – HTML Essential Training, with James Williamson (Sections 3 & 5)
Murach – pages 4 – 21

2

3

1/24/17

Chapter 1 – Introduction to web development with PHP

  • How to edit and test a PHP application

· How to use NetBeans to develop a PHP application

Activities:

  • Review Solutions to Challenges
  • CSS exercise
Lynda – HTML Essential Training, with James Williamson (Sections 6 & 7)

Murach – Pages 22 – 41

HTML Challenge

2

4

*1/26/17

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/31/17

 QUIZ 1 – HTML

3

6

2/2/17

Chapter 2 – How to code a PHP application

  • Conditional Statements

Activities:

  • Exercise 2.2
  • Review Solution to Challenge 2.1
Murach – Pages 72 – 91

Challenges 2.1

4

7

2/7/17

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/9/17

SNOW DAY

5

9

2/14/17

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
Challenge 2.3
(Upload it.  Do not print.)Murach – Pages 96 – 123

5

10

2/16/17

Review for Exam 1

6

11

2/21/17

Exam 1

6

12

2/23/17

Activities:

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

7

13

2/28/17

Activities:

  • MySQL Exercise #2
  • Export / Import your work

7

14

3/2/17

Quiz 2 – MySQL
8 15 3/7/17 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 16 3/9/17 Chapter 4 – How to use PHP with a MySQL database

  • Using PDO with SELECT statements

Activities:

  • PDO exercise 2
 Murach – Pages 138 – 156

9

17

3/14/17

SPRING BREAK – NO CLASSES
9 18 3/16/17 SPRING BREAK – NO CLASSES

10

19

**3/21/17

Activities:

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

10

20

3/23/17

Chapter 5 – How to use the MVC pattern

  • Introduction to functions

Activities:

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

Murach – Pages 160 – 179

11

21

3/28/17

Activities:

  • Review Challenge Solution 4.2

Review how to upload your work

Murach – Pages 180 – 188

Challenge 4.2

11

22

3/30/17

Review for Exam 2

12

23

4/4/17

Exam 2

12

24

4/6/17

Chapter 5 – How to use the MVC pattern

  • MVC concepts

Activities:

  • Begin challenge 5.1 together in class

13

25

4/11/17

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/13/17

Chapter 7 – How to work with form data

  • Selection lists
  • text areas

Activities:

  • Exercise 7.2
MurachPages 224 – 230

14

27

4/18/17

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/20/17

Chapter 12 – How to work with cookies and sessions

  • How to work with sessions

Activities:

  • Review challenge 12 solution
  • Exercise 12.2
Challenge 12

15

29

4/25/17

Review for exam 3

15

30

4/27/17

Exam 3

* Last date to drop is 1/30
** Last date to withdraw is 3/22

Office Hours

10 am - 11:30 am, Monday
10 am - 11:30 am, Wednesday
10 am - 11:30 am, Friday
Other times by appointment

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 3 other subscribers

Recent Comments
    • Professors Martin and Sclarow join the MIS department January 17, 2017
      Assistant Professor of Practice, Marie-Christine Martin and Assistant Professor of Practice, Steven E. Sclarow joined the Fox School’s Department of Management Information Systems in January 2017. Prior to Temple, Professor Martin was a Technology and Services executive with 20+ years of experience working at three of the largest global IT providers, while Professor Sclarow, has […]
    • Professor Doyle receives Fox School Musser award November 17, 2016
      Professor Martin Doyle received the 2016 Fox School Musser Excellence in Leadership Award for Faculty Service. The award was presented at the 20th annual Musser Award reception and dinner Nov. 16, 2016, in Mitten Hall, on Temple University’s Main Campus. Professor Doyle was recognized for his leadership and service to the Department of Management Information […]
    • Professors Wattal and Greenwood receive fellowships November 13, 2016
      Professors Sunil Wattal and Brad Greenwood received prestigious named research fellowships at the Fox School’s Eighteenth Annual Research Roundtable and Teaching Awards on November 9th, 2016. These fellowships are only awarded to the top researchers in the school. In addition, a number of MIS faculty and doctoral students were also honored with research and teaching awards. […]