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
    • Three Temple teams, chapter take home prizes in national competition May 1, 2019
      Three Temple AIS student teams took home awards at the annual Student Chapter Leadership Conference in April, hosted at Temple University. All three teams placed in the Alexion Analytics Challenge, competing with 16 Universities across the country including Arizona State University, Florida International University, and the University of Bridgeport. Faculty adviser Jeremy Shafer was delighted […]
    • Temple MIS Hosts 10th Annual AIS Student Chapter Leadership Conference April 30, 2019
      On April 11-13, Temple MIS hosted the 10th Annual Association for Information Systems Student Chapter Leadership Conference. Over 180 students and faculty attendees from 33 schools participated in the conference. AIS student chapter leaders and members convened in Philadelphia to exchange best practices, network with students from other chapters and engage with industry experts on […]
    • Alum Bryce Buffaloe makes an impact at Google April 30, 2019
      Bryce Buffaloe, MIS ’10, is a product manager with Google. “The job is like being the CEO of your own product,” says the Management Information Systems program graduate. And it’s hard to imagine a more exciting place for that kind of work than Google, whose past products have transformed the business world and our everyday […]