OneDriveCredits: 4
| Instructor | |
| Name: | Brent Presley |
| (see Brent's Schedule) | |
| Office: | Stevens Point Campus, Faculty Offices |
| Phone: | 295-1272 |
| E-Mail: | brent.presley@mstc.edu |
| Textbook | |
| Title: | PHP and MySQL 2nd Edition |
| Author: | Murach & Associates |
| Publisher: | Murach & Associates |
| Year/Edition: | 2nd Edition |
| ISBN: | 9781890774790 |
| Prerequisites | |
| Course & Course Number | Alternative |
|---|---|
| 152-150 Web Programming | |
| Required Student Materials | ||
| Item | Quantity | Approximate Cost |
|---|---|---|
| USB Storage Drive | 1 | Optional - Price varies with capacity |
Course Description
Using various tools the student will create and demonstrate data connectivity to the web. Tools may include elements of the following languages: HTML, C#, Java, JavaScript, ASP, JSP, and PHP. Students will retrieve data for display to the web browser and capture data for storage from a web-based form.
Course Competencies
- Describe the history and nature of the Internet, the World Wide Web, browsers, servers, URLs, MIME types and HTTP.
- Program HTML documents that contain images, links, lists, tables, forms and Cascade Style Sheets.
- Create a server side program to present an interactive Web document
- Use a server side Web language to access a relational database.
- Program an XML document to use data type definitions, namespaces and schemas.
Course Outline
- Web Client / Server Concepts
- PHP Decisions and Loops
- Accessing MySQL Databases Using PHP
- PHP Functions
- Secure Web Sites
- XML
Student Assignments
- Read textbook
- Participate in lecture/discussion
- Complete homework assignments
Course Grading
I will assign a letter grade for the course based on the following overall percentages:
| A | 95 - 100% |
| A- | 93 - 94% |
| B+ | 90 - 92% |
| B | 88 - 89% |
| B- | 86 - 87% |
| C+ | 83 - 85% |
| C | 80 - 82% |
| D | 70 - 79% |
| F | Below 70% |
Note: This course may be a prerequisite for other courses at MSTC. MSTC policy (see the handbook) states you must earn at least a C in a prerequisite course to enroll in the subsequent courses.
Employability Skills
In addition to the material required in this course, the course will also further develop your skills in the following MSTC Core Abilities:
- Act with integrity
- Communicate effectively
- Demonstrate effective critical and creative thinking
- Demonstrate global and social awareness
- Use Appropriate Technology
Academic Integrity Policy
The Mid-State Technical College Board, administration, faculty, and staff believe that academic honesty and integrity are fundamental to the mission of higher education. All students are expected to maintain and promote the highest standards of personal honesty and professional integrity. These standards apply to all examinations, assigned work, and projects. Therefore, a student who is found to have been dishonest, fraudulent, or deceptive in the completion of work or willing to help others to be so or who is found to have plagiarized (presented the work of others as his or her own) is subject to disciplinary action up to and including suspension.
Brent's clarification of the above:
Homework assignments for this course are completed entirely on disks which unfortunately are easy to copy. If I determine that two assignments are identical, I will interview both students in an attempt to determine who did the copying. If I can determine who copied, I will give that student a zero on the assignment and let other instructors know of the infraction. If I determine a student has copied a second time, I will immediately fail (fail, not withdraw) that student in this course.
Course Expectations
I will take attendance only for record keeping purposes--your grade is not affected by your attendance. On the other hand, I will not repeat a lecture for someone who misses a class. It is your responsibility to make up the work you missed. Get to know your classmates and ask them to help you catch up. If you miss a lecture, come to class early the next day and get a copy of the examples done in class either from a fellow student or the instructor so you will be prepared for the next lecture. Review the notes on the web site.
If you decide you no longer wish to attend this class, it is your responsibility to drop the class. I will not drop students who are no longer attending. If you don’t drop the course, you will receive a grade of “F”.
Classroom Environment
I attempt to create a classroom environment that is comfortable for learning. If I inadvertently say or do something that offends or hurts you, please tell me (preferably after class) so I can correct the problem. If another student offends you, tell that student how you feel as well. If that doesn't solve the problem, tell me. In order for our labs to be comfortable, productive environments, please do not use the computer to view inappropriate material that might be offensive to others. If you see others abusing their lab computer privileges, report them to your instructor or any other MSTC staff member.
Learning can be difficult enough as it is. Help me ensure the classroom and lab is an untroubled place to learn.
Recording Lectures
I record all my lectures and post them to my Web site (usually the same day). If you wish, you may make your own recording of my lecture, following these terms:
You must complete the Recording Audio/Video Agreement Form BEFORE audio/video recording a lecture.
With prior approval, students may be allowed to audio/video record lectures to enhance their
understanding of the topics presented. Audio/video recordings are not substitutes for attending class.
If you choose to record lectures, you must sign an agreement which lists the following terms:
- Recordings are not to be distributed without the permission of the instructor. This includes sharing via the Internet, peer to peer file sharing, or other methods.
- Recordings are not to be shared with other classmates unless they are to be used in collaborative assignments, or if the instructor approves sharing for other reasons.
- You will turn off recorders at the request of instructor.
Non-compliance with these terms violates an instructor's intellectual property rights. Students violating this agreement will be subject to disciplinary actions under the Student Code of Conduct.
Special Needs
If you know you have a recognized disability, or suspect that you might have one, it is your responsibility to identify yourself as soon as possible to the Disability Services staff in Student Affairs. Course standards will not be lowered but various kinds of accommodations are available to you. Adequate and reasonable time will be required to develop and provide appropriate accommodations, so contact Disability Services as soon as possible. It is MSTC's goal to assist you in your individual educational plan.
If you have an illness (e.g. epilepsy, diabetes) or allergy you feel I should know about, please let me know.
If you have other circumstances (family, job, etc) that might affect your performance in this class, please let me know. We might be able to make accommodations to help ensure your success.
Biographical Information
I have been involved in the technology field for 20 years as a user and then a provider of technology. I have worked in numerous roles during my career including the following: Software Engineer, Automated Tester, Manager, and Consultant. I have been fortunate to be able to work with both large organizations with significant specialization of roles and small organizations where an employee wears many hats. I believe that nothing should stand still... particularly someone's personal development. I've been a life-long student and expect to always be one going forward. I encourage you to do the same because that is the type of person who will excel in the technology field.
Teaching Philosophy
My Teaching Philosophy can be summarized with a few points:
- Ensure students understand why it's important
- Make the learning process enjoyable
- Help students learn how to utilize the tools necessary for learning
- Help students to realize that self-evaluation is as important as external evaluation.
Employability Skills
In addition to specific job-related training, Mid-State has identified a set of employability skills that are transferable and go beyond the content of a specific course. The college supports the following skills for all graduates of Mid-State:
- Act with Integrity
- Communicate Effectively
- Demonstrate Effective Critical and Creative Thinking
- Demonstrate Global Social Awareness
Learner Expectations
The Commitment I Require from You
Attendance
If this is a face-to-face course, attendance is required – either from one of the MSTC campuses, or a remote location via Blackboard Collaborate. Please notify me in advance of any absence or anticipated late arrival. Lectures are recorded using Collaborate. If you need to miss a class, you will be expected to watch the lecture and complete all related lab activities before the next class period.
No Show/Drop Policy
If you have unexcused absences for 25% of the overall course (four weeks) or more, you will receive a grade of F unless you withdraw from the course before it is 80% complete. Please refer to the Student Guidelines for information on how to withdraw from the course.
Late Work
A critical component of success in the IT is the ability to meet deadlines. Therefore, we will model this component in this course. Missing/late work will incur the following penalties:
- 20% will be deducted if work is submitted up to two weeks late.
- 50% may be deducted if work is submitted up to two weeks late and the solution is first presented/discussed in class.
- Work submitted more than two weeks late will not receive any credit.
- Late work during the last two weeks of class will not receive any credit.
- No late quizzes will be accepted.
- No late tests will be accepted except in extreme circumstances or having made prior arrangements.
- Tests which do not initially receive a passing grade must be retaken until a passing grade is achieved. Retake scores are multiplied by 0.7, yielding a maximum score of 70%.
Dedication
It is expected that you have both the willingness and the time available to study and complete required assignments.Completing IT courses requires dedication and commitment. Be prepared to spend 2-3 hours per credit, per week – in addition to class time – on learning and assessment activities for this course.
Quality
Being successful in IT requires great deal of attention to detail and care in completing tasks.Points may be taken off of assignment grades for sloppy/careless work.
Professionalism
It is the goal of this class to emulate – as far as possible – a workplace environment and one that is conducive to learning and teamwork. It is my expectation that you will comport yourself in a professional and respectful manner, both toward me and your fellow students.
Any obscene language, rudeness, talking over me or other students, computer/mobile phone use other than that relating to the material being covered, etc. will not be accepted in the classroom. Repeat violations of this policy may negatively impact your final course grade by up to two grade letters e.g. A to B; etc.
My Commitment to You
It is my goal to be responsive and supportive to aid you in your learning. Throughout the course, I will attempt to clearly define my expectations of you, respond in a timely manner with all communications (generally within 24 hours) and grade assignments turned in on time within one week of their due date.
Attendance and Participation
Consistent attendance and participation in this course is essential for your success. Demonstrating these behaviors will help you meet MSTC's Soft Skills and will help prepare you for future employment.
Learner Role and Responsibilities
You are an adult learner and as such you are responsible for you own
learning. No one else can be a "stand in" for you in the learning process. You will be held accountable for all
assigned activities. You matter and what you do does make a difference. You will have an opportunity to share your
unique ideas and experiences with your student peers and myself. The form and content of your participation will
determine the level of achievement, satisfaction, and enjoyment that you experience. Because others are depending on
you to keep the course moving, you have an obligation to met deadlines for completing assignments and postings.
Class Format
Distance Learning takes place any time a student is learning outside of the immediate proximity of the instructor. At Mid-State distance learning includes online, hybrid, TelePresence, computer conferencing, and independent study courses. Blackboard is used by most distance education courses. Many face to face courses at Mid-State also use Blackboard to provide a single place for the students to go for content, resources, turning in assignments, and more.
Contact Response
It is my goal to make myself available to you to aid in your learning, not only in this course, but also as you continue on your educational journey. Always feel free to come to me with any questions or problems you may have. My preferred means of contact is via Slack. My goal is to respond to all correspondence within 24 hours on business days; on weekends, a response may be a bit slower. I also welcome private messages via Slack or emails. If you need to meet with me, the best time is during my office hours. If you need to meet with me at any other time, feel free to contact me, and I will be happy to make alternate arrangements with you.
Student Input
I will have formal check-in's with you each semester to give you a chance to provide feedback on how the class is going. At that time we'll discuss your grades, progress, and any suggestions you have to improve the course. I welcome feedback at any time, but will make a specific point of reaching out to you a couple of times during the semester to obtain feedback.
