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
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
    • Temple AIS students win big in national competition May 23, 2018
      Five Temple University undergraduate teams were winners in contests judged during the Association for Information System’s Student Chapter Leadership Conference in Dallas in April. The contests pitted Temple against schools in the U.S. and abroad, including the universities of Alabama, Georgia, Michigan and Colorado; Saudi Arabia’s Prince Sultan University and the University of Gdansk in […]
    • Alumni Michael Luckenbill and Joshua Sandoe are well-prepared for new challenges May 23, 2018
      While Michael Luckenbill ‘08 and Joshua Sandoe ’16 are no longer students, they’ve never stopped learning. Luckenbill has handled business intelligence for a food service conglomerate, merged technologies for two music giants and created custom financial asset software. Sandoe has only worked for one company since graduation, but his job changes every six months, meaning […]
    • Recent MIS grads Emily Schucker and Frank Tkachenko find their paths to success May 23, 2018
      Emily Schucker ’17 thought she’d major in biology when she began studying at Temple University.  Frank Tkachenko ’18 planned to reinvent himself. Both found their paths thanks to the Fox School of Business. Schucker enjoyed technology, but she couldn’t see juggling her people-focused personality with solitary technical work. Then she learned about the Management Information […]
    SOTD