NORTH CENTRAL TEXAS COLLEGE COURSE SYLLABUS

 

The North Central Texas College (NCTC) Course Syllabus provides the following as required by the Texas Higher Education Coordinating Board (THECB): (1) a brief description of the course including each major course requirement, assignment and examination; (2) the learning objectives for the course; (3) a general description of the subject matter of each lecture or discussion; and (4) any required or recommended readings.  Contact information for the instructor is also provided. The Course Syllabus also provides institutional information to indicate how this course supports NCTC’s purpose and mission. Information specific to a particular section of the course will be included in the Class Syllabus and distributed to enrolled students.

 

Course Title: Intermediate Web Programming
Course Prefix & Number: ITSE2302	Section Number: 400	Term Code: Spring 2017
Semester Credit Hours: 3	Lecture Hours: 32	Lab Hours: 32
Course Description (NCTC Catalog):   Intermediate applications for web authoring. Topics may include server side includes (SSI) Perl, HTML, Java, JavaScript, and/or ASP.
Course Prerequisite(s): (WECM suggested prerequisite) Competency in basic Web programming or departmental approval.
Course Type: o - Academic General Education Course (from Academic Course Guide Manual but not in NCTC Core) o - Academic NCTC Core Curriculum Course x - WECM Course

 

Name of Instructor:	William Hill
Campus/Office Location:	Gainesville Campus, Room 502C
Telephone Number:	Office: 940-668-3340
E-mail Address:	whill@nctc.edu

 

Name of Chair/Coordinator:	Judy Archer
Office Location:	Corinth Campus, Room 233
Telephone Number:	Office: 940-498-6292
E-mail Address:	jarcher@nctc.edu

 

 

REQUIRED OR RECOMMENDED COURSE MATERIALS

Required: Text Book: Murach’s PHP and MySQL, 2^nd edition, by Joel Murach and Ray Harris; ISBN: 978-1-890774-79-0                               

 

Required: An account with a web hosting company such as GoDaddy.com, HostGator.com, or Bluehost.com  will be required to use by the end of the first week of class for setting up a remote site to host the web pages you will be creating in the course. Please utilize suggested guidelines by web hosting companies when registering your domain name. If you decide to use a hosting company other than the one I have recommended, then you will need to make sure that they offer a C-panel, FTP access, MySQL database, scripting (PHP and JQuery). If you are unclear about this, then email me in Canvas. Also, a flash drive is required for the labs – recommended minimum of 8 GB.

 

 

COURSE REQUIREMENTS, EVALUATION METHODS AND GRADING CRITERIA

# of Graded Course Elements	Graded Course Elements	Weighted Percentage Values
18	Homework Assignments	20% of grade.
18	Lab Assignments	40% of grade.
18	Quizzes	20% of grade.
4	Exams	20% of grade.

 

 

 

GRADING SCALE

	A	>= 89.5%		D    >= 59.5%
	B	>= 79.5%		F    >=   0.0%
	C	>= 69.5%

 

 

INSTITUTIONAL LEARNING GOALS

o           A quality general education curriculum in all associate degree programs.

o           Quality freshman and sophomore level courses in arts and sciences which parallel the lower division offerings of four-year colleges and universities.

x          Quality technical programs leading directly to careers in semi-skilled and skilled occupations, and quality technical education programs up to two years in length leading to certificates and associate degrees.

o           Quality programs and services in support of adult literacy and basic skills development as a mean of workforce enhancement and expanding access to higher education.

 

 

 

PROGRAM PURPOSE STATEMENT

NCTC seeks to implement its goal of providing quality technical programs leading directly to careers in semi-skilled and skilled occupations, and quality technical education programs up to two years in length leading to certificates and associate degrees by offering a coherent sequence of courses with appropriate breadth and depth to prepare students for success in the workforce.

 

ATTENDANCE POLICY

Attendance is based on participation in this online class, so you are expected to actively participate in the assignments and the graded discussion forums on a weekly basis. I also expect you to check your email everyday on M-F. I do not check emails on the weekends from Friday at 5:00 pm to Monday morning at 9:00 am.

 

Last Day to Withdraw: For the Spring 2017 semester, the last day to withdraw from a course with a “W” is April 6, 2017. If a student decides to officially drop this course, then it is the student’s responsibility to submit the required forms to the registrar. Students who cease attending and who do not complete a drop slip prior April 6, 2017 will earn a grade of “F”.

 

DEPARTMENTAL PURPOSE STATEMENT

The purpose of the Computer Information Technology Department is to prepare students for successful entry level careers in the IT or networking industry, and/or prepare students for success in pursuing higher education in the Computer Information System & Networking fields.

 

STUDENT LEARNING OUTCOMES

WECM End-of-Course Outcomes: Create and use client-side and server-side scripts to design and implement dynamic websites.

At the completion of this course, the student will be able to:

1. Demonstrate understanding of programming and problem solving skills.
2. Demonstrate how to design, develop, implement, and test simple computer programs.
3. Document computer programs.
4. Perform numeric (algebraic) and string based computation.
5. Use control statements in the programs.
6. Accept and validate user input and produce output.
7. Understand how to perform basic testing and debugging of programs.
8. Understand the basics of Object Oriented Programming.

 

GENERAL DESCRIPTION/LEARNING OUTCOMES OF SUBJECT MATTER FOR EACH LECTURE/DISCUSSION

	Topic		General Description/Learning Outcomes of Subject Matter
	Introduction to Web Development with PHP		Architecture of a web application; how to edit and test a PHP application; using NetBeans to develop a PHP application
	How to Code a PHP Application		Basic PHP skills; getting data from a request; working with data; coding control statements; using PHP documentation
	Introduction to Relational Databases with MySQL		Relational databases; SQL statements for data manipulation; MySQL; using PHP MyAdmin
	How to Use PHP & MySQL Databases		PHP for working with MySQL; getting data from a result set
	Using the MVC Pattern to Organize Your Code		Introducing the MVC pattern; coding functions; redirecting requests
	How to Test and Debug a PHP Application		Introduction to testing and debugging; debugging with xDebug and NetBeans
	Working with Form Data		Getting data from a form; displaying data on a web page
	Coding Control Statements		Coding conditional expressions; coding selection structures; coding iteration structures
	Working with Strings and Numbers		How to work with strings; how to work with numbers; other skills for working with strings and numbers
	Working with Dates		How to use timestamps to work with dates; how to use objects to work with dates
	Working with Arrays		Creating and using arrays; creating and using associative arrays; using functions to work with arrays; working with arrays of arrays
	Working with Cookies and Sessions		How to work with cookies; how to work with sessions
	Creating and Using Functions		Basic skills for working with functions; creating and using libraries of functions; advanced skills in working with functions
	Creating and Using Objects		Creating and using classes; coding class constants, properties, and methods; working with inheritance
	Using Regular Expressions, Handling Exceptions, and Validating Data		How to use regular expressions; how to handle exceptions
	Creating Secure Web Sites		Using a secure connection; using authentication; working with encrypted data
	Sending Email and Accessing Other Web Sites		How to send email; how to get data from other servers
	How to Work with Files, Uploads, and Images		Working with files; uploading files; working with images
Student Rights & Responsibilities		NCTC Board policy FLB (Local) Student Rights and Responsibilities states that each student shall be charged with notice and knowledge of the contents and provisions of the rules and regulations concerning student conduct.  These rules and regulations are published in the Student Handbook published in conjunction with the College Catalog.  All students shall obey the law, show respect for properly constituted authority, and observe correct standards of conduct.
Scholastic Integrity		Scholastic dishonesty shall constitute a violation of college rules and regulations and is punishable as prescribed by Board policies. Scholastic dishonesty shall include, but not be limited to cheating on a test, plagiarism, and collusion.
STUDENT SUPPORT SERVICES
Disability Accommodations Statement		The Office for Students with Disabilities (OSD) provides accommodations for students who have a documented disability.  A disability is anything that can interfere with learning, such as a learning disability, psychological challenge, physical illness or injury. Accommodations may include extra time on tests, tests in a distraction- reduced environment, volunteer note taker in class, etc.   On the Corinth Campus, go to room 170 or call 940-498-6207. On the Gainesville Campus, go to room 110 in the Administration (100) Building or call 940-668-4209.  Students on the Bowie, Graham, Flower Mound, and online campuses should call 940-668-4209 to arrange for an intake appointment with OSD.   North Central Texas College is on record as being committed to both the spirit and letter of federal equal opportunity legislation, including the Americans with Disabilities Act (ADA) of 1990, ADA Amendments Act of 2009, and Section 504 of the Rehabilitation Act of 1973 (P.L. 93-112).
Financial Aid, Scholarships, and Veterans Services		The Financial Aid Office is responsible for administering a variety of programs for students who need assistance in financing their education.  The first step for financial aid is to complete a FAFSA.  For more information, please visit your nearest Financial Aid Office.
Early Alert and NCTC CARES		The NCTC Early Alert program has been established to assist students who are at risk of failing or withdrawing from a course. Your instructor may refer you to this program if you are missing assignments, failing tests, excessively absent, or have personal circumstances impacting your academic performance. If submitted as an Early Alert you will be notified via your NCTC e-mail address and then contacted by a Counseling and Testing advisor or counselor to discuss possible strategies for completing your course successfully. The NCTC CARES (Campus Assessment Response Evaluation Services) Team addresses behavior which may be disruptive, harmful or pose a threat to the health and safety of the NCTC community-such as stalking, harassment, physical or emotional abuse, violent or threatening behavior, or self-harm. As a student, you have the ability to report concerning behavior which could impact your own safety or the safety of another NCTC student. Just click the NCTC CARES Team logo posted on MyNCTC, or send an e-mail to CARESTeam@nctc.edu.  As always, if you feel there is an immediate threat to your own safety or welfare (or to another student), please call 911 immediately.
Other Pertinent Information               Tobacco Policy                       NOTICE		The usage of cell phones, MP3 players, PDAs and other electronic devices is prohibited in class. All these devices will be turned off in the classroom. (See instructor regarding emergencies.) Usage of tobacco products of any kind is not permitted in the classroom. The instructor reserves the right to amend the syllabus at any time during the semester. Any announcements/information disseminated during class will take precedence over the syllabus. Assignments are due on the assigned due date. Late assignments will not be accepted. No Excuse! NCTC restricts the use of all tobacco products including cigarettes, cigars, pipes and smokeless tobacco on campus property. NCTC is aware that tobacco use influences underage students which cumulates unsightly tobacco litter and interferes with assuring clean air for all who come to NCTC. NCTC recognizes the health hazards of tobacco use and of exposure to second hand smoke. Information on a tobacco cessation program is available for students, faculty, staff who wish to stop using tobacco products. We would like to "thank you" for your help in making our campuses Tobacco-Free. For questions or concerns please contact the Office of Vice President of Student Services at 940.668.4240.     While we provide the locations to download the software for this class, it is your responsibility to install the software on your computer, and ensure it is executing properly. NCTC is not and cannot be responsible for installing any of the software programs and the proper operation of your computer.

 

 

Tentative Schedule for ITSE2302 – Intermediate Web Programming

 

Week 1: 1/16—1/20  (School Closed for Martin Luther King Day on Monday, 1/16/2017)

Chapter 1 – Introduction to Web Development with PHP

Week 2: 1/23—1/27

Chapter 2 – How to Code a PHP Application

Week 3: 1/30—2/3

Chapter 3 – Introduction to Relational Databases and MySQL

Week 4: 2/6—2/10

Chapter 4 – How to Use PHP with a MySQL Database

 

Week 5: 2/13—2/17

Chapter 5 – How to Use the MVC Pattern to Organize Your Code

 

Week 6: 2/20—2/24 Exam 1 (chapters 1, 2, 3, 4, & 5) turned on from 2/20 at 8:00am to 2/22 at 10:00pm.

Chapter 6 -- How to Test and Debug a PHP Application

Week 7: 2/27— 3/3

Chapter 7 -- How to Work with Form Data

Week 8: 3/6— 3/10 

Chapter 8 – How to Code Control Statements

 

Spring Break: 3/13—3/17  School is closed. Classes will resume Monday, 3/20.
Mr. Hill will be unavailable during Spring Break.

Week 9: 3/20—3/24

Chapter 9 – How to Work with Strings and Numbers

Week 10: 3/27—3/31

Chapter 10 – How to Work with Dates

 

Week 11: 4/3—4/7 Exam 2 (Ch 6, 7, 8, 9, & 10) turned on from 4/3 at 8:00 am to 4/5 at 10:00 pm.

Chapter 11 – How to Create and Use Arrays   April 6^th is last day to drop with a “W”

 

Week 12: 4/10—4/14  

Chapter 12 – How to Work with Cookies and Sessions and Chapter 13 – How to Create and Use Functions

Week 13: 4/17—4/21

Chapter 14 – How to Create and Use Objects and Chapter 15 – How to Use Regular Expressions, Handle Exceptions, & Validate Data

Week 14: 4/24—4/28 Exam 3 (Ch 11, 12, 13, 14, 15) turned on from 4/24 at 8:00 am to 4/26 at 10:00 pm

Chapter 21 – How to Create Secure Web Sites

 

Week 15: 5/1—5/5
Chapter 22 – How to Send Email and Access Other Web Sites and Chapter 23 – How to Work with Files, Uploads, and Images

 

Week 16: 5/8—5/12  Final Exam (over Ch. 21, 22, & 23) turned on from 5/8 at 8:00 am to 5/10 at 10:00 pm; Commencement is Friday, 5/12.

 

 

Unit Competencies

 

1. Demonstrate usage of PHP and create multipart scripts.

            Performance Objectives:

            The student will:

• Demonstrate usage of PHP start and end tags.
• Demonstrate coding a PHP script
• Use assignment statements to assign values to variables.
• Demonstrate usage of PHP to get variables from forms.

Assessment:

Lab/Homework assignments

Multiple choice quiz for each chapter

Multiple choice exam covering textbook chapters

 

1. Demonstrate usage of PHP to display dynamic content, send email, work with files, and uploading files to a website.

            Performance Objectives:

            The student will:

• Demonstrate usage of HTML and PHP to display dynamic content, submitting forms, and redirecting to a new location.
• Demonstrate working with files, paths, and permissions.
• Demonstrate the process for uploading files to a website.

Assessment:

Lab/Homework assignments

Multiple choice quiz for each chapter

Multiple choice exam covering textbook chapters

 

III. Demonstrate knowledge of MYSQL database and using cookies to track users.

            Performance Objectives:

            The student will:

• Establish a database connection and set user privileges.
• Create a database table, insert data into the table, and select/display data from the table.
• Create a user table for authentication of users with logins.
• Set cookies to count time and for authentication.
• Demonstrate knowledge of a Session, usages of session variables, and managing user preferences within a session.

Assessment:

Lab/Homework assignments

Multiple choice quiz for each chapter

Multiple choice exam covering textbook chapters

 

 

 

 

 

Workforce Education Program Elements (SCANS Skills)

 

The Secretary’s Commission on Achieving Necessary Skills (SCANS) conducted extensive research and interviews and determined that “workplace know-how” consists of two elements:  foundations skills and workplace competencies.  Upon successful completion of the courses in this program, students will have demonstrated the following competencies: 

 

• Foundation Skills

 

• Basic Skills: A worker must (i) read, (ii)write, (iii) perform arithmetic and mathematical operations, (iv) listen, and (v) speak effectively.

 

• Thinking Skills: A worker must (i) think creatively, (ii) make decisions, (iii) solve problems, (iv) visualize, (v) know how to learn, and (vi) reason effectively.

 

• Personal Qualities: A worker must display (i) responsibility, (ii) self-esteem, (iii) sociability, (iv) self-management, (v) integrity, and (vi) honesty.

 

 

• Workplace Competencies

 

• Resources: A worker must identify, organize, plan, and allocate resources effectively.  This includes (i) time, (ii) money, (iii) material and facilities, and (iv) human resources.

 

• Interpersonal Skills: A worker must work with others effectively to (i) participate as a member of a team, (ii) teach others new skills, (iii) serve clients/customers, (iv) exercise leadership, (v) negotiate, and (vi) work with diversity.

 

• Information: A worker must be able to (i) acquire and use information, (ii) organize and maintain information, (iii) interpret and communicate information and (iv) use computers to process information.

 

• Systems: A worker must understand complex interrelationships as in (i) understanding systems, (ii) monitor and correct performance, and (iii) improve and design systems.

 

• Technology: A worker must be able to work with a variety of technologies, e.g. (i) select technology, (ii) apply technology, and (iii) maintain and troubleshoot equipment.