College of Southern Nevada

Department of Computer and Information Technology

CIT 252- Web Database Development

16-week course (August 30, 2021- December 19, 2021)

Credits: 3

Description: Design and implementation of interactive, data-driven websites that integrate HTML/CSS, a scripting language (Active Server Pages or PHP), and a database.

Student Learning Outcomes:

By the end of this course, a student will be able to:y the end of this course, a student will be able to:

  1. Develop web database applications using ASP.NET or PHP.
  2. Organize data into a normalized database.
  3. Formulate SQL queries to extract information from a database.
  4. Modify a database using a scripting language and SQL.
  5. Create an interactive, database-driven website.

Instructor Information:

Instructor Name: Mahima Pandey

Contact phone: (702) 651-4850

Contact E-mail: mahima.pandey@csn.edu
(Preferably, use Canvas system for all communications regarding this course)

Office Location: Green Valley Center, 101-D (1560 W. Warm Springs Road, Henderson, NV 89014)

Office Hours: Tuesday 11:00 AM – 12:00 PM Office hours on Canvas Conference and on-line meetings can be arranged by appointment.

Course meeting time/days: Online – 24/7

Course meeting Location: Online, please login to Canvas course and click at Conference in the Navigation panel

Course Pre or Co-Requisites: CIT 151 or Instructor approval.

Textbook: PHP and MySQL Web Development, 5th Edition, Luke Welling, Laura Thomson ©2017 |Addison-Wesley Professional ISBN-13: 978-0321833891

 Software requirements

You will be required to install software and download student data files on your computer to complete the course work. All web pages will be produced using a text editor, such as Notepad++ for a PC or BBEditfor a Mac. Download Notepad++ https://notepad-plus-plus.org/ or BBEdit http://www.barebones.com/products/bbedit/index.html. 

Late Work policy

Follow the due dates assigned for each assignment in the Module section of Canvas. If you miss any assignment, quiz, or exam due to an emergency you must communicate with me as soon as possible. There will be 10% deduction per day, until 5 days after the due date for late submissions. No course work can be submitted after the last day of this semester.

Method of Evaluation

Grades are based on exams, graded discussions, and projects assigned throughout the semester. All assignments will be submitted via the Canvas assignment drop box. Detailed instructions will be provided in the text of the requirements for each of the assignments. If Canvas email system fails and you must use a different system to submit your assignments, send your assignment files to my alternate email address. All exams are delivered through the Canvas system. All exams will have strict time limits and detailed information will be provided at least a week before the date of the exam.

Grade determination

A = 100% - 94%
A = < 94% - 90%
B+ = < 90% - 87%
B = < 87% - 84%
B- = < 84% - 80%
C+ = <80% - 77%
C = < 77% - 74%
C- = < 74% - 70%
D = <70% - 60%
F = <61%

Important Note

If you have any concerns about this course and/or me, please contact me first. If I cannot resolve your issue, please contact CIT Department Office at 702-651-5976. You will be directed to the appropriate Program Director or the Department Chair. You will remain anonymous, if possible, and all communications will be strictly confidential. Please DO NOT wait until the last minute to make your concerns known to me and/or to the CIT Department.

CSN Student email - All students enrolled at CSN have a CSN Student Email account. All information from the college will be sent to your CSN-issued student email address (enrollment information, financial aid information, cashier information, college events, etc.). It is extremely important that you check your student email daily. You can access your student email through GoCSN (go.csn.edu). Once you validate your student email address you will have access to Microsoft Office 365 for up to five devices and 1TB of OneDrive storage. Visit the CSN Information web site for additional information.

Attendance Policy - College assumes maturity, seriousness of purpose, and self-discipline for meeting the responsibilities associated with each course. If you will need the instructor to sign documents testifying about your attendance, YOU must come to the instructor after each class you attend to let them know you were there. Class participation is a strong aspect of this course, and your participation is always encouraged.

Academic Integrity - Taking the words of others or presenting the ideas of others as your own not only limits your academic research skills, it also violates the CSN’s Student Academic Integrity Policy. Cheating on exams or other course work also violates the CSN Student Academic Integrity Policy. You can find more information about CSN’s Academic Integrity Policy at the Academic Integrity Web Site. The minimum penalty for such offenses in this course is to fail the assignment. Failing the course will also be considered as an option. Infractions of the CSN Student Academic Integrity Policy may lead to suspensions, expulsion, transcript notations or other sanctions.

You SHOULD NOT attempt to pay anyone to complete your work. You SHOULD NOT consult any web sites that provide answers to assignments.

CSN Americans with Disabilities Act (ADA) Statement and current Disability Resource Center (DRC) Contact Information - The College of Southern Nevada is committed to making physical facilities and instructional programs accessible to students with disabilities. If you have a disability that may have some impact on your work in this class and for which you may require accommodations, please visit the Disability Resource Center (DRC) so that such accommodations can be considered. All discussions will remain confidential. The DRC has offices on all three campuses. These serve as the focal point for coordination of services for students with disabilities. If you have a physical, emotional, or mental disability that “substantially limits one or more major life activities (including walking, seeing, hearing, speaking, breathing, learning and working),” and will require accommodation in this class, please contact the DRC at West Charleston 702 – 651 – 5644, or email at WCDRCStaff@csn.edu or at North Las Vegas 702–651–4045, or email at CYDRCStaff@csn.edu or at Henderson 702–651–3795 , or email at HCDRCStaff@csn.edu. For Deaf and Hard of Hearing Services contact the DRC using 70 –651–4448, or email at Deaf.HH.Services@csn.edu. Any student who receives an accommodation letter from the DRC, please meet with me to discuss the provisions of those accommodations as soon as possible.

Student Rights & Responsibilities - When you choose to become a student at CSN, you accept the rights and responsibilities of membership in CSN’s academic and social community. You can find policies covering students such as the Student Conduct, Students’ Right to Know, Students’ Academic Integrity, and Disruptive and Abusive Student in the following locations:

  • Catalog and Student Handbook (Catalog Web Page) in the Policies and Procedures section.
  • CSN Website (Student Policies) under the heading “Student Policies.”

College Library Services - CSN Libraries provides support for students completing assignments that require research and the use of information. Librarians are available to students for one-on-one assistance locating and citing quality information either online at the library information or at one of our campus libraries. Find more information on our main website at the library main page.

Safety - This class does not have an experiment lab and therefore we will not be concerned about following specific safety strategies. However, Approved classroom safety procedures are posted in each classroom and are to be followed. Students are to familiarize themselves with the nearest exit to use during fire alarm exercises. Do NOT use the elevators during these drills. Students will take ALL personal belongings with them when exiting the building. No student will be allowed back into the facility until all clear is given.

Public Health Directives (COVID-19) - Students must follow all active CSN public health directives while enrolled in this class. Properly worn face coverings are mandatory for all faculty and students in the classroom as well as on campus. CSN public health directives are found at the CSN Covid-19 Information. Students who do not comply with these directives will be asked to leave the classroom. Refusal to follow the guidelines may result in further disciplinary action according to the CSN Student Conduct Code found at the Student Conduct Issues including being dropped from the course.

Counseling and Psychological Services (CAPS) - The Counseling and Psychological Services (CAPS offers short-term, problem-focused counseling to CSN students who may feel overwhelmed by the responsibilities of college, work, family, and relationships. Clinicians are available to help students cope with stresses and personal issues that may interfere with their ability to perform in school. The service is provided confidentially and free to currently enrolled students. To schedule an appointment, please call CAPS at WC (702) 651-5518, at NLV (702) 651-4099, and at HN (702) 651-3099.

Food and Housing Insecurity Support - Any student who has difficulty affording groceries or accessing sufficient food to eat every day, or who lacks a safe and stable place to live and believes this may affect their performance in the course, is urged to contact Counseling & Psychological Services (CAPS), for a list of resources and support.

References Safari Tech Books available through the library offer an excellent source of supplemental resources that you may use for this course. To find Safari Books Online, go to the https://libguides.csn.edu/  . Click at the “Go to A-Z list”, button. In the A-Z Databases page that appears, click S to filter. The link to Safari Books Online should be at or near the top of the list. You will have to select “Not Listed? Click here.”  Initially, you will have to enter your student email address, then create an account with Safari. Subsequently, you will use your email address and your Safari password to access the Safari resources.

Required extra- or co-curricular activities - All activities are based on projects and exams assigned throughout the course. Any required extra activities will be clearly explained in class.

Additional fees - There are no additional fees for this course.

Advising & Coaching Services - Advisor/Success Coaches help students assess academic strengths and limitations, learn academic success strategies, explore careers, declare a major, navigate the educational system, access campus and community resources, and connect to campus life. The department also manages the CSN Faculty E-Alert System assisting instructional staff by working with students on strategies and interventions that lead to successful course completion. Contact Information: Charleston Campus: Building D – Student Services Area : 702–651–5670, North Las Vegas Campus: Student Services Area : 702–651–4049, Henderson Campus: Building B – Room 120 : 702 – 651–3165. Visit the Advising web site for more information.

Additional Notes

My responsibilities:

  1. I will reply to your e-mail messages within one business day. Replying to phone calls may take at most two days.
  2. I will make sure to accommodate all your learning needs and will answer your questions in a timely manner.
  3. I will try my best to resolve any issues.
  4. I will return feedback and grade on assignments and exams within one week of the due date.

Your responsibilities:

  1. You will stay active in classroom discussions and activities. Let me know if you find any discrepancies in the syllabus, course material, or activity due dates, as soon as possible.
  2. You will monitor the deadlines for projects and exams and ask questions.
  3. You will do your best in class and will not hesitate to ask for help.
  4. You will review my feedback on your assignments and exams and let me know of any questions or concerns as soon as possible.

Withdrawal Policy - Instructors do not have the option of withdrawing students. For official withdrawal dates and other IMPORTANT college dates, look at the online schedule at the CSN Calendar https://www.csn.edu/semester-calendar-dates  and locate the calendar for the current semester.

You are strongly encouraged to discuss your decisions with an academic counselor, academic adviser or success coach AND Student Financial Services, because these decisions may affect your financial aid and Satisfactory Academic Progress. Students receiving financial aid may find their awards reduced.

If you wish to receive a W in lieu of a grade, you MUST withdraw yourself officially from the class. Once you have withdrawn (dropped), you must discontinue attending class. Alternatively, you may wish to change from Credit to Audit and continue to attend the class.

Change to Audithttps://at.csn.edu/sites/default/files/documents/auditing_classes_form_0.pdf  Print the form and fill it out, check the boxes, sign, and date. Submit the completed form in person at the Registrar’s Office. To avoid visiting the registrar’s office in person, you may scan or photograph the signed form and send it, using your CSN student email, along with a clear color copy of your state ID to MyCSN.Updates@csn.edu

The following dates are for 16-week sessions:

September 5 - Last day for 100% refund

September 13 - Last day for 50% refund

September 13 - Last Day to Drop a Class WITHOUT a Grade of W

November 5 - Last Day to Officially Change from Credit to Audit

November 5 - Last Day to Drop a Class WITH a Grade of W

November 25- November 26 – Thanksgiving Break

December 22 - Grades are Due from Instructors

Class policies - All exams will be taken online administered through the Canvas system.

Due to the Covid-19 issues, until we are back to normal operating schedule, you will take your exam from anywhere with access to Internet.

All course material is available online in Canvas. While the design of this course allows flexibility in your scheduling, please realize that the deadlines are just as strict as any other course. You should check the calendar and discussion postings daily and allocate your time accordingly to complete the readings and to be prepared for the exams. Due dates will be strictly adhered to. You will use the mail and discussion features of Canvas to contact me or ask questions.

A note on the assignment release schedule - To stay on task, I release chapter material and assignments on a timely basis. Exams can only be taken during the scheduled period. E mail me if you need to have access to some study material ahead of time due to any reason. Please send an e-mail message informing me about any links that have disappeared from your view or is scheduled to be visible, and it is not.

Online section offer flexibility where you need to manage your time to achieve success. I will assign programming projects that will be graded, and you will have to take exams by specified due dates. It is extremely simple to ignore due dates and fall behind which I hope we can seriously avoid!

A rule of thumb for a 3-credit class is that you attend class about 3 hours a week and study a minimum of 6 hours a week outside of the classroom. IT work can be time-consuming.

This is a single person class; meaning that you must turn in your own work. You are not allowed to collaborate or consult with anyone else while working on an exam. You are not allowed to collaborate on completing assignments. You should not be looking at each other’s code for assignments. You can freely discuss items in the general sense. Cheating in any form will not be tolerated.

Internet Access - Internet access is your responsibility. This class can be accessed from any computer with Internet access anywhere in the world. Therefore, excuses such as “My computer is not working” or “My provider was down” are not acceptable. If you find yourself in a real jam, you may drive to any CSN site and use one of the computers in the CSN open computer labs. Of course, if there is a computer problem originating from CSN, then I will take corrective action. But in all other instances, it is your responsibility to ensure your own Internet access.

Software Lab - The software lab will be virtual and will be available starting on August 30, 2021. For location/date/time information, please visit this CIT Information web site. Click on Networking and Software Lab Hours

“Software Lab - Due to Covid-19 issues, software lab will be operated virtually. Detailed information will be provided in Canvas on the first day of class.”

Networking Lab - The networking lab will be open by appointment only. For location/date/time information, please visit the CIT Information Web site. Click on Networking and Software Lab Hours

Academic Advising

Academic Advisors help students assess academic strengths and limitations, learn academic success strategies, explore careers, declare a major, navigate the educational system, access campus and community resources, and connect to campus life. Contact Information: Charleston Campus: Building D – Student Services Area: 702–651–5670, North Las Vegas Campus: Student Services Area : 702–651–4049, Henderson Campus: Building B – Room 120 : 702–651–3165. For more information visit Academic Advising https://www.csn.edu/advising

Centers for Academic Success (CAS) - Centers for Academic Success (CAS) provides quality DROP-IN academic assistance to all students enrolled in for-credit courses at CSN. Tutors are available for most general education courses and some historically challenging courses. Academic learning support includes assistance with learning strategies, Canvas, Smarthinking online tutoring, Microsoft Office, reading, writing, oral presentations, math, and science. CAS tutors also provide support to study groups and assistance for placement test preparation. CAS is open Monday through Sunday to be more accessible to all students. Hours for all locations are Monday – Thursday 9:00 am to 6:00 pm and Friday – Sunday 11:00 am to 4:00 pm. You may visit the CAS web site for more details about online and in-person services. You may also contact us at one of our offices: Charleston Centers (651- 5732), North Las Vegas Learning Commons (651-4232), Henderson Learning Commons (651- 3125).

Excess credit fee information - Please visit the Excess Credit Information for information about the excess credit fee applied in certain circumstances.

TITLE IX Resources - More information is available at the Title IX for more information.

Objectionable materials - Instructors have the responsibility to set and maintain standards of classroom behavior appropriate to the discipline and method of instruction. No objectionable materials or language will be used during this class. This includes all possible modes of the class: online and in person. The instructor will make the final determination regarding any objectionable materials or language. Students may not engage in activity the instructor deems disruptive or counterproductive to the goals of the class. Instructors have the right to remove offending students from class.

Recording Class - Recordings of the class is not allowed without the explicit permission of the instructor.

Early Alert Program - Early Alert Referral Program (MyCoyotePLAN) – A referral program to connect students with college resources when assistance is needed to achieve success. Referrals may be initiated by faculty and staff as well by students through MyCoyotePLAN. After a referral is submitted, students will receive an email notification and will be contacted by the department to which they were referred to offer assistance.

TRIO Student Support Services - One stop shop for first-generation college, financial aid-eligible and disabled students offering tutoring, academic advising, career exploration, college-transfer assistance, and development of college success strategies. Contact information: North Las Vegas Campus: Building E Room 109 : 702–651–4441 or visit the TRIO’s web site.

Printing @ CSN - Printing in CSN classrooms, computer labs and libraries falls under Print Wise. Print Wise provides each CSN student with a $10 credit toward printing at the start of each semester, which will provide for up to 200 black and white copies at 5¢ a page, or 40 color copies at 25¢ a page. After that, you may put money into your account online or at the CSN Cashier’s Office to purchase additional prints at the same rate. It is your responsibility to maintain your printing accounts to cover printing expenses during each semester. More information about the Print Wise system may be found at the Printwise Information.

Disclaimer - This syllabus is subject to change with advance notice. Notices will be posted in the online forum. It is your responsibility to stay informed.

Course Contract -

This syllabus is a course contract for the duration of the semester. By continuing with this course students agree to the terms set forth in this syllabus and will adhere to all rules and policies outlined.

Information contained in this syllabus, other than the grading, late assignments, makeup work and attendance policies, may be subject to change without advance notice, as deemed appropriate by the instructor.

Tentative schedule

All course due dates are in the Canvas course shell under the Canvas Syllabus Course Summary Section. Subject to change with prior notice

 

Schedule

Subject to change with prior notice

Week

Topics / Reading assignments

Assignments, Quizzes & Exams

Week 1

Syllabus

Quiz & Assignment 0

Week 2

PHP Crash Course

 Quiz & Assignment 1

Week 3

Storing and Retrieving Data

Quiz & Assignment 2

Week 4

Using Arrays

Quiz & Assignment 3

Week 5

String Manipulation and Regular Expressions

Quiz & Assignment 4

Week 6

Reusing Code and Writing Functions

Quiz & Assignment 5

Week 7

Midterm

 

Week 8

Designing & Creating your Web Database

Quiz & Assignment 6

Week 9

Working with your MySQL Database

Quiz & Assignment 7

Week 10

Accessing your MySQL Database from the Web with PHP

Quiz & Assignment 8

Week 11

Advanced MySQL Administration &Advanced MySQL Programming

Week 12

Web Application Security Risks & Building a secure Web Application

Quiz & Assignment 9

Week 13

Quiz & Assignment 10

Week 14

 Final Project

 

Week 15

Week 16

Final Project Due

 

Note: The page you are viewing
is not sanctioned by CSN.