Data Centric Application Development

Schedule

All content is subject to change

Last updated: 10/3/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 – 41HTML 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
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

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

10/17/17

Quiz 2 – MySQL

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 2 other subscribers

Recent Comments
    • MIS alums are digital entrepreneurs October 27, 2017
      Like many entrepreneurs, Peter Hwang’s idea for what he hopes is the next big thing came to him when he spotted a hole in the market’s offerings: while traveling for work in NYC, he couldn’t find a quick way to find a good meal near his location without scrolling through unhelpful restaurant peer review sites. […]
    • Top 15th for the sixth year in a row! October 27, 2017
      For the sixth year in a row, the Fox School’s Department of Management Information Systems (MIS) Bachelor of Business Administration major in Management Information Systems (BBA MIS) made the US News and World Report Undergraduate Business Specialties national ranking. In the 2018 ranking, which is based on data from 2017, Temple MIS was ranked 14th […]
    • ITACS Spans Continents With New Expansion into China October 26, 2017
      Six years after launching at Temple’s Fox School of Business, the IT Auditing and Cyber Security graduate program (ITACS) is going global. In November, Assistant Professor and ITACS founder Richard Flanagan will teach the first-ever ITACS course in China, part of the new ITACS degree program in partnership with the Beijing National Accounting Institute (BNAI). […]
    SOTD