Data Centric Application Development

Schedule

All content is subject to change

Last updated: 9/18/2017

Week Class Date Topics Readings and tasks due

1

1

8/29/17

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

8/31/17

Chapter 1 – Introduction to web development with PHP

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

Activities:

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

2

3

9/5/17

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

HTML Challenge

2

4

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

9/12/17

QUIZ 1 – HTML

3

6

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

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

9/21/17

Chapter 2 – How to code a PHP application

  • Understanding PHP include statements

Activities:

  • Review Solution to Challenge 2.3
  • Exercise 2.4
Challenge 2.3

5

9

9/26/17

Review for Exam 1

5

10

9/28/17

Exam 1

6

11

10/3/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
Murach – Pages 96 – 123

6

12

10/5/17

Activities:

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

7

13

10/10/17

Activities:

  • MySQL Exercise #2
  • Export / Import your work

7

14

10/12/17

Quiz 2 – MySQL

8

15

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

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

**10/24/17

Activities:

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

9

18

10/26/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

10

19

10/31/17

Activities:

  • Review Challenge Solution 4.2

Review how to upload your work

Murach – Pages 180 – 188

Challenge 4.2

10

20

11/2/17

Review for Exam 2

11

21

11/7/17

Exam 2

11

22

11/9/17

Chapter 5 – How to use the MVC pattern

  • MVC concepts

Activities:

  • Begin challenge 5.1 together in class

12

23

11/14/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

12

24

11/16/17

Chapter 7 – How to work with form data

  • Selection lists
  • text areas

Activities:

  • Exercise 7.2
Murach – Pages 224 – 230

13

25

11/21/17

FALL BREAK – NO CLASS

13

26

11/23/17

FALL BREAK – NO CLASS

14

27

11/28/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

11/30/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

12/5/17

Review for exam 3

15

30

12/7/17

Exam 3

* Last date to drop is 9/11/2017
** Last date to withdraw is 10/24/2017

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 1 other subscriber

Recent Comments
    • New MIS faculty bring expertise in healthcare, social media, analytics and machine learning August 31, 2017
      Sezgin Ayabakan (Ph.D., University of Texas, Dallas), JaeHwuen Jung (Ph.D., University of Minnesota), and Konstantin Bauman (Ph.D., Moscow State University) join the MIS department as Assistant Professors in fall 2017. Dr. Ayabakan, who was previously an Assistant Professor at University of Baltimore and faculty fellow at the Schaefer Center for Public Policy, is researching healthcare […]
    • Dr. David Schuff is the new MIS Department Chair August 7, 2017
      The Fox School of Business is excited to welcome Dr. David Schuff as the new chair of the Department of Management Information Systems (MIS). Since joining the faculty in 2000, Schuff has played a major role in elevating the reputation of the department through his exceptional teaching, research, and leadership. David’s service to Fox and […]
    • Yusuf G. Mandviwalla endowment May 16, 2017
      The new Yusuf G. Mandviwalla endowed scholarship fund will provide financial support to undergraduate students majoring in MIS who have both financial need and high academic performance. The $50,000 endowment, which includes a match from the Fox School, was created by Munir and Nazneen Mandviwalla in memory of Munir’s father Yusuf G. Mandviwalla. According to […]
    SOTD