CIS 247 - Web Application Programming II

Description
This course teaches students how to write server-side script programs that interact with relational databases to build dynamic, interactive Web pages. Students build Web applications that provide capabilities such as database searches, shopping cart capabilities, login security, and other dynamic functionality. This course includes the development of server-side script programs as well as relational database development, deployment, and security over the Internet. Students are encouraged, but not required, to also take CIS 171 before or concurrent to this course.

Credit Hours: 3
Contact Hours: 3

School: School of STEM
Department: Computer Information Systems
Discipline: CIS

Major Course Revisions: Prerequisite
Last Revision Date Effective: 20220215T17:59:53
Course Review & Revision Year: 2026-2027

Course Type:
Program Requirement- Offering designed to meet the learning needs of students in a specific GRCC program.
Course Format:
Lecture - 1:1

General Education Requirement: None
General Education Learner Outcomes (GELO):
NA

Course Learning Outcomes:

Explain what a computer program is and how computer languages are used to solve problems.
Understand the role of client-side scripting languages like JavaScript and how they work with HTML and CSS to produce output to the user.
Be able to use JavaScript to write simple programs, understanding how to use variables, arrays, methods, objects, decisions and loops.
Describe the Document Object Model, why it’s important, and the major components of it that are used in JavaScript.
Explain what an event is, write event handlers, and connect them to events of controls and other constructs that use them.
Describe jQuery, and demonstrate its use by calling various methods from the library to accomplish useful Web page enhancements.
Describe Ajax, and demonstrate its purpose and benefit by using it within a Web page to provide asynchronous content updates in cooperation with its surrounding container.
Describe the popular APIs in use at the present time (i.e. HTML5, Google Maps, etc.) and demonstrate their benefit by integrating their popular features into Web pages.
Understand the importance of error-handling on a Web page and demonstrate effective error handling using JavaScript.
Use JavaScript to build content panels such as sliders, modal windows, tabbed panels, and accordions.
Demonstrate several techniques for filtering and sorting data.
Add enhancements to HTML forms, including the ability to validate components and make it easier for users to identify and correct invalid entries within them.
Use creativity and alternative thinking to brainstorm new ideas and possible solutions to problems and issues.
Complete work accurately, with attention to detail.

Approved for Online Delivery?: Yes

Course Outline:
I. Introduction to web development and PHP

II. How to code a PHP application

III. Introduction to relational databases and MySQL

IV. How to use PHP with a MySQL database

V. How to use the MVC pattern to organize your code

VI. How to test and debug a PHP application

VII. How to work with form data

VIII. How to code control statements

IX. How to work with strings and numbers

X. How to work with dates

XI. Relational Databases and SQL

XII. How to create secure websites

XIII. How to work with cookies and sessions

XIV. Course Review and Final Project

Mandatory CLO Competency Assessment Measures:
None

Name of Industry Recognize Credentials: n/a

Instructional Strategies:
Lecture: 30-60%
Facilitated discussion: 0-20%
Group work: 0-10%
Lab work: 10-40%

Mandatory Course Components:
A series of ten significant Web applications that require students to demonstrate the various techniques delineated in the course outcomes.

Academic Program Prerequisite: None
Prerequisites/Other Requirements: CIS 241 C or Higher
English Prerequisite(s): None
Math Prerequisite(s): None
Course Corerequisite(s): None
Course-Specific Placement Test: None
Course Aligned with IRW: NA
Consent to Enroll in Course: No Department Consent Required

Total Lecture Hours Per Week: 3
Faculty Credential Requirements:
Master’s Degree (GRCC general requirement), Other (list below), Professionally qualified through work experience in field (Perkins Act or Other) (list below)
Faculty Credential Requirement Details: The instructor must have knowledge of and experience building Web Sites using the LAMP stack, PHP, MySQL. Instructors must also have a significant amount of programming experience in industry.

Maximum Course Enrollment: 24
Equivalent Courses: none
Dual Enrollment Allowed?: Yes
Number of Times Course can be taken for credit:
Programs Where This Courses is a Requirement:
Computer Programming, A.A.A.S.
People Soft Course ID Number: 102816
Course CIP Code: 11.9999

High School Articulation Agreements exist?: None