|
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: 0310
|
Term Code: Spring 2021
|
|
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.
|
|
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:
|
Corinth Campus, Room 202
|
|
Telephone Number:
|
940-498-6463
|
|
E-mail Address:
|
whill@nctc.edu
|
OFFICE HOURS
|
Monday
|
Tuesday
|
Wednesday
|
Thursday
|
Friday
|
|
|
|
|
|
|
|
|
|
|
|
|
|
As posted in Canvas and by appointment.
|
QUESTIONS, CONCERNS, or COMPLAINTS
|
Name of Chair/Coordinator:
|
Susan Svane
|
|
Office Location:
|
Corinth Campus, Room 232
|
|
Telephone Number:
|
Office: 940-498-6292
|
|
E-mail Address:
|
ssvane@nctc.edu
|
|
Name of Instructional Dean:
|
Debbie Huffman
|
|
Office Location:
|
Gainesville Campus, Room CTC2106
|
|
Telephone Number:
|
940-668-3357
|
|
E-mail Address:
|
dhuffman@nctc.edu
|
REQUIRED OR RECOMMENDED COURSE MATERIALS
Required: Text Book: Murach’s PHP and MySQL, 3rd edition, by Joel Murach and Ray Harris; ISBN: 978-1-943872-38-1
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 with Linux server, 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. If you cannot afford web hosting, then you need to let me know immediately.
COURSE REQUIREMENTS, EVALUATION METHODS AND GRADING CRITERIA
|
# of Graded Course Elements
|
Graded Course Elements
|
Weighted Percentage Values
|
|
16
|
Homework Assignments
|
20% of grade.
|
|
16
|
Lab Assignments
|
40% of grade.
|
|
16
|
Quizzes
|
20% of grade.
|
|
4
|
Exams
|
20% of grade.
|
|
|
A
|
>= 90%
|
|
D >= 60%
|
|
|
B
|
>= 80%
|
|
F >= 0%
|
|
|
C
|
>= 70%
|
|
|
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 is based on your presence in this class and you are expected to actively participate in the assignments and class discussions on a weekly basis. I also expect you to check your email every day on M-F. I do not check emails on the weekends from Friday at 5:00 pm to Monday morning during office hours.
Last Day to Withdraw: For the Spring 2021 semester, the last day to withdraw from a course with a “W” is April 3, 2021. 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 3, 2021 will earn a grade of “F”.
Policy for Late Assignment Submission: No late assignments will be accepted for full credit – you will lose points for late submission of any assignment. No late work will be approved for acceptance after 2 weeks from the original due date. If approved by the instructor, you may submit the late assignments as an attachment to a Canvas Email. The assignments will be graded at the end of the semester IF they will make a difference to your overall grade. That is, for example, if you have a course grade of a “C” and you had late work submitted according to the guidelines above, IF it would raise your letter grade to a “B”, then I would grade the late work. If it would not make a difference, the late work will not be graded, and the previously recorded zero will remain in place. No late assignments will be accepted after the 6th week of eight-week courses or the 14th week of 16-week courses. There will be NO exceptions to this policy.
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.
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 and MySQL
|
Relational databases; SQL statements for data manipulation; MySQL; using PHP MyAdmin
|
|
How to Use PHP with a MySQL Database
|
Connecting to a database and handling exceptions; getting and modifying data
|
|
How to use 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
|
|
How to Work with Form Data
|
Getting data from a form; displaying data on a web page
|
|
How to Code Control Statements
|
Coding conditional expressions; coding selection structures; coding iteration structures
|
|
How to Work with Strings and Numbers
|
How to work with strings; how to work with numbers; other skills for working with strings and numbers
|
|
How to Work with Dates
|
How to use timestamps to work with dates; how to use objects to work with dates
|
|
How to Create and Use 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
|
|
How to Create and Use Functions
|
Basic skills for working with functions; creating and using libraries of functions; advanced skills in working with functions
|
|
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; how to work with cryptography
|
|
How to Work with Files, Uploads, and Images
|
Working with files; uploading files; working with images
|
Tentative Schedule for ITSE2302 – Intermediate Web Programming
Week 1: 1/18 – 1/22 (School Closed for Martin Luther King Day on Monday, 1/18/2021)
Chapter 1 – Introduction to Web Development with PHP
Week 2: 1/25 — 1/29
Chapter 2 – How to Code a PHP Application
Week 3: 2/1 — 2/5
Chapter 3 – Introduction to Relational Databases and MySQL
Week 4: 2/8 — 2/12
Chapter 4 – How to Use PHP with a MySQL Database
Week 5: 2/15 — 2/19
Chapter 5 – How to Use the MVC Pattern to Organize Your Code
Week 6: 2/22 – 2/26 Exam 1 (chapters 1, 2, 3, 4, & 5) turned on from 2/24 at 8:00am to 2/26 at 10:00pm.
Chapter 6 -- How to Test and Debug a PHP Application
Week 7: 3/1 — 3/5
Chapter 7 -- How to Work with Form Data
Week 8: 3/8 —3/12
Chapter 8 – How to Code Control Statements
Spring Break: 3/15 – 3/19 School is closed. Classes will resume Monday, 3/22.
Mr. Hill will be unavailable during Spring Break.
Week 9: 3/22 — 3/26
Chapter 9 – How to Work with Strings and Numbers
Week 10: 3/29 —4/2 April 3rd is last day to drop with a “W”
Chapter 10 – How to Work with Dates
Week 11: 4/5 — 4/9 Exam 2 (Ch 6, 7, 8, 9, & 10) turned on from 4/6 at 8:00 am to 4/8 at 10:00 pm.
Chapter 11 – How to Create and Use Arrays
Week 12: 4/12 —4/16
Chapter 12 – How to Work with Cookies and Sessions and Chapter 13 – How to Create and Use Functions
Week 13: 4/19 — 4/23
Chapter 15 – How to Use Regular Expressions, Handle Exceptions, & Validate Data
Week 14: 4/26 — 4/30 Exam 3 (Ch 11, 12, 13, and 15) turned on from 4/27 at 8:00 am to 4/29 at 10:00 pm
Chapter 21 – How to Create Secure Web Sites
Week 15: 5/3 — 5/7
Chapter 23 – How to Work with Files, Uploads, and Images
Week 16: 5/10 — 5/14 Final Exam (over Ch. 21 and 23) turned on from 5/10 at 8:00 am to 5/12 at 10:00 pm; Commencement is Friday, 5/15.
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.
Student Handbook
Students are expected to follow all rules and regulations found in the student handbook and published online.
Academic Dishonesty
Scholastic dishonesty shall include, but is not limited to cheating, plagiarism, academic falsification, intellectual property dishonesty, academic dishonesty facilitation and collusion. Faculty members may document and bring charges against a student who is engaged in or is suspected to be engaged in academic dishonesty. See Student Handbook, “Student Rights & Responsibilities: Student Conduct ([FLB(LOCAL)]”.
Consequences for academic dishonesty may include:
1) A grade of 0 for the work in question.
2) Possible academic suspension.
Complaint Procedures
If the complaint involves a problem with an instructor, the student shall discuss the matter with the instructor before requesting a conference with the department chair… If the complaint involves a grade received, the student shall collect all tests, papers, daily assignments, class notes and other relevant material prior to the conference with the instructor in question. (See Student Handbook > Discussion of Complaint)
ADA Statement
North Central Texas College is committed to providing equal access to educational opportunities to its students with disabilities by providing assistance through “reasonable accommodations”; and a variety of services and resources through the Special Populations Office. The College does not discriminate on the basis of disabilities in admission or access to its programs. Students are responsible for notifying the office of their need for assistance at least two weeks prior to the beginning of a semester. Students with documented disabilities such as mobility, hearing or visual impairments, learning, and/or psychological disorders are eligible for services. The Special Populations Office on the Gainesville Campus is located in the Counseling/Testing Center room ASC 108 (next door to the bookstore). For assistance, call 940/668-4216 ext. 344.
Civil Rights
In compliance with Title VI of the Civil Rights Act of 1964 (P.L.88-352), Title IX of the Education Amendments of 1972 (P.L. 92-318). and the Age Discrimination Act of 1978 (P.L. 92-256), North Central Texas College does not discriminate against or exclude from participation in any of its programs or activities, either in the student body or the staff, any person on the grounds of sex, race, color, religion, age, handicap, national origin, or veteran status.
Web Page
Visit the North Central Texas College web page for information on registration, financial aid, counseling/advising, and cost of tuition and fees. You will also find information on the catalog and semester schedules as well as courses of study. You can keep up with what is happening on campus by checking the calendar of events and the sports news. The web has information on the library as well as links to other areas of interest. Check out our web page at http://www.nctc.edu
Additional content for this course may be found in your Canvas account. Please check there for updates and news.
Disability Services (Office for Students with Disabilities)
The Office for Students with Disabilities (OSD) provides support services for students with disabilities, students enrolled in technical areas of study, and students who are classified as special populations (i.e. single parents).
Support services for students with disabilities might include appropriate and reasonable accommodations, or they may be in the form of personal counseling, academic counseling, career counseling, etc. Furthermore, OSD Counselors work with students to encourage self-advocacy and promote empowerment. The Counselors also provides resource information, disability-related information, and adaptive technology for students who qualify.
If you feel you have needs for services that the institution provides, please reach out to either Wayne Smith (940) 498-6207 or Yvonne Sandman (940) 668-4321. Alternative students may stop by Room 170 in Corinth or Room 110 in Gainesville. 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).
http://www.nctc.edu/student-services/disability-services/index.html
Support Services
Counseling and Testing staff offer a variety of services to current and prospective students, such as College 101, placement testing, academic advising and course registration, transfer assistance, and College Success seminars (Time Management, Study Skills, Test Anxiety, Choosing a Major, Learning Style Strategies, Career Exploration), and much more. http://www.nctc.edu/counseling-testing/index.html
Student Success offers academic coaching, tutoring, including a Writing Center, a Math Lab, free 24/7 online tutoring through Grade Results and assist new students acclimate to college by providing computer lab services for prospective students. First generation students can also participate in TRIO, which offers specialized support services.
http://www.nctc.edu/student-services/student-success/tutoring/index.html
Financial Aid offers financial resources for students that qualify, visit the financial aid offices for more information. http://www.nctc.edu/financial-aid/index.html
EEOC Statement
North Central Texas College does not discriminate on the basis of race, color, national origin, gender, religion, age, or disability in the employment or the provision of services.
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.
Childcare Reimbursement Program
The Childcare Reimbursement Program provides support services for NCTC students pursuing a career in a technical field of study to help them complete their career plans. The program will reimburse technical declared students a percentage of their daycare expenses if the child is attending a licensed or registered daycare facility. This is on a first come first serve basis, and is available to students on all 5 campuses. Please note, we do not have a childcare facility on any of our 5 campuses. This is a reimbursement program only.
Students who wish to become eligible for Childcare Assistance Program need to:
· Declare in a technical field of study
· Establish financial need
· Ex: Pell Grant recipient, Food Stamp recipient, W2, etc.
· Complete a Childcare Reimbursement Program Application and provide all necessary documentation. The Application can be found online at http://www.nctc.edu/_documents/default-source/student-services/2017-networks-packet.pdf
For more information, please contact Yvonne Sandmann on the Gainesville Campus at 940-668-3300, or by email at ysandmann@nctc.edu.
Student Success Center
The Student Success Center is designed to help all students at NCTC develop tools to achieve their academic goals. The center links students to FREE tutoring, including a Writing Center, a Math Lab, and free online tutoring in the evening. The program helps students acclimate to college by providing students free interactive workshops. For more information, please visit your nearest Student Success Center.
Other Pertinent Information
Dropping Courses:
If a student’s personal circumstances dictate that he or she needs to reduce his/her academic load, that student should confer with his/her advisor for assistance in adjusting the number of courses being taken. A grade of “W” will be given to students who officially withdraw from a course, or “drop”, at least by Thursday of the 11th week of a Fall or Spring semester, or a proportional number of weeks prior to the end of a flex-entry course or summer session. Any drops after this will be made with the approval of the instructor and the Department Chair.
It is the student’s responsibility to initiate the action necessary to drop courses under the conditions outlined above. This requires the completion of a petition for course drop form available in the Registrar’s Office on any NCTC Campus or by going to the NCTC website at www.nctc.edu and clicking on Admissions and Registration. Choose the forms on-line option and follow directions for submission of form. This form must be submitted on or before the last day to drop with a “W” (see Academic Calendar in front of catalog for specific date) and it is not available until after the official date of record. Prior to the official date of record, a student should go to the Registrar’s Office and complete the required forms.
Students who register for courses are required to drop any courses they no longer wish to attend or a final grade will be assigned. Instructors may drop students from courses for non-attendance by completing a petition for course drop.
Class Communications:
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.
Program Capstone Requirements
The capstone for all the Information Technology Certificates is a comprehensive program exam with a score of 70% or higher. Exam must be scheduled with the Department Chair upon completion of a certificate.
The capstone requirement for the all Information Technology AAS Degrees is a program specific course directly related to the degree. This course may not be substituted and should be taken the last semester before graduation. You will find more information about the capstone course for your degree in the catalog.
Certificate Programs:
If you are planning to complete a certificate, you must take the competency exam prior to graduation. Contact Susan Svane at ssvane@nctc.edu within three weeks of graduation.
Tobacco-Free Campus
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 the Dean of Student Services at 940.498.6445.
Notice
While we provide the locations to download the software for this class, it’s 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.
Unit Competencies
I. Demonstrate usage of PHP and create multipart scripts.
Performance Objectives:
The student will:
1) Demonstrate usage of PHP start and end tags.
2) Demonstrate coding a PHP script
3) Use assignment statements to assign values to variables.
4) 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
II. Demonstrate usage of PHP to display dynamic content, send email, work with files, and uploading files to a website.
Performance Objectives:
The student will:
1) Demonstrate usage of HTML and PHP to display dynamic content, submitting forms, and redirecting to a new location.
2) Demonstrate working with files, paths, and permissions.
3) 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:
1) Establish a database connection and set user privileges.
2) Create a database table, insert data into the table, and select/display data from the table.
3) Create a user table for authentication of users with logins.
4) Set cookies to count time and for authentication.
5) 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:
(1) Foundation Skills
(a) Basic Skills: A worker must (i) read, (ii)write, (iii) perform arithmetic and mathematical operations, (iv) listen, and (v) speak effectively.
(b) 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.
(c) Personal Qualities: A worker must display (i) responsibility, (ii) self-esteem, (iii) sociability, (iv) self-management, (v) integrity, and (vi) honesty.
(2) Workplace Competencies
(a) 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.
(b) 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.
(c) 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.
(d) Systems: A worker must understand complex interrelationships as in (i) understanding systems, (ii) monitor and correct performance, and (iii) improve and design systems.
(e) 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.