INFO 246-10
Information Technology Tools and Applications - Advanced
Topic: Introduction to PHP/MySQL
Fall 2018 Syllabus

Steve Perry
E-mail

This class does not use Canvas! The class Web site is found at http://profperry.com/sjsu

The first day of instruction is August 21, 2018.

Course Description

This course is an introduction to using PHP to build dynamic Web pages, that is, web pages that automatically change according to a user's input or information on a database. We will be reading from the required text and doing programming exercises. The assignments will be problems that you will solve by coding PHP pages that exercise the concepts learned to date. Additionally, you will learn the fundamentals of MySQL.

Course Requirements

Important Dates
INFO 246 - PHP MySQL - Syllabus

Semester: Fall 2018 (2018-08-21 through 2018-12-10)

The FINAL DATE of this class is 2018-12-10
No assignments or exams will be accepted after that date!

Attendance Requirements
You must actively use the class Web site at least once per each week to considered in attendance that week. The activities that show attendance are: logging into to this site, clicking on a link to read a lesson/assignment, or submitting an assignment.

Any student who fails to log in to the class Web site for 14 consecutive days during the semester will be dropped from the class and receive the grade of 'W' if dropped before the Official Withdrawal date posted on the college's Web site.

Participation Requirements
Participation is required in the class Discussion Area and will count as 10% (10 points) of your grade.

To receive participation credit for that week you must make at least one substantial posting to the discussion area. This can be a thoughtful question to the class, reply to another student's question, or an answer to one of the questions I pose in "Instructor Questions" discussion area.

Again, your answers must be substantial (not merely "I agree!", etc.) and not a slightly reworked answer from someone else.

You will receive a maximum of 1 point per week for participation credit no matter how many posts you make that week. No more than 10 weeks participation will be counted. That is, 1 point per week for 10 weeks will get you the full 10 points participation credit.

Prerequisites
There is an inferred prerequisite for this class...You must know some native HTML.

Please read the link below to determine whether or not you have the proper HTML background to take this class:

HTML Prerequisites (link opens in new window)
http://profperry.com/Classes20/prehtml.htm

Assignment Due Dates
The due dates for all assignments are listed in the "Lessons and Assignments" area. They are also listed in each assignment.

There is a 7-day grace period on all assignments! This means you can turn in an assignment up to 7 days past the due date with no penalty. (As long as it is not past the last day of the semester.)

Assignments turned in more than 7 days past their due date will receive zero points and you will not be allowed to submit the assignment unless we have a specific agreement specifying otherwise.

If you contact me before the grace period is passed, I may extend an assignment due date for you, if need be. The important thing is to contact me BEFORE time runs out!

ANOTHER NOTE: It is wise to aim to submit the assignment by the actual posted due date. That way, if you need extra help from me, you have the time to get it.

Assignments

Required Reading
It is necessary to read all of the Web pages that I have posted in each Lesson and Assignments and view all of the video presentations posted as well.

There is no book used for this class.

top

Course Workload Expectations

Success in this course is based on the expectation that students will spend, for each unit of credit, a minimum of forty-five hours over the length of the course (normally 3 hours per unit per week with 1 of the hours used for lecture) for instruction or preparation/studying or course related activities including but not limited to internships, labs, clinical practica. Other course structures will have equivalent workload expectations as described in the syllabus.

Instructional time may include but is not limited to:
Working on posted modules or lessons prepared by the instructor; discussion forum interactions with the instructor and/or other students; making presentations and getting feedback from the instructor; attending office hours or other synchronous sessions with the instructor.

Student time outside of class:
In any seven-day period, a student is expected to be academically engaged through submitting an academic assignment; taking an exam or an interactive tutorial, or computer-assisted instruction; building websites, blogs, databases, social media presentations; attending a study group;contributing to an academic online discussion; writing papers; reading articles; conducting research; engaging in small group work.

Course Prerequisites

INFO 246 has no prequisite requirements.

Course Learning Outcomes

Upon successful completion of the course, students will be able to:

1. Define the basic syntax of coding PHP programs.
2. Use HTML forms with PHP.
3. Use standard PHP functions and be able to write their own custom functions.
4. Demonstrate a basic understanding of MySQL and be able to use it in a PHP program.
5. Build and maintain a small Web application.

Core Competencies (Program Learning Outcomes)

INFO 246 supports the following core competencies:

top

Textbooks

No Textbooks For This Course.

top

Grading Scale

The standard SJSU School of Information Grading Scale is utilized for all iSchool courses:

In order to provide consistent guidelines for assessment for graduate level work in the School, these terms are applied to letter grades:

• C represents Adequate work; a grade of "C" counts for credit for the course;
• B represents Good work; a grade of "B" clearly meets the standards for graduate level work or undergraduate (for BS-ISDA);
  For core courses in the MLIS program (not MARA, Informatics, BS-ISDA) — INFO 200, INFO 202, INFO 204 — the iSchool requires that students earn a B in the course. If the grade is less than B (B- or lower) after the first attempt you will be placed on administrative probation. You must repeat the class if you wish to stay in the program. If - on the second attempt - you do not pass the class with a grade of B or better (not B- but B) you will be disqualified.
  
• A represents Exceptional work; a grade of "A" will be assigned for outstanding work only.

Graduate Students are advised that it is their responsibility to maintain a 3.0 Grade Point Average (GPA). Undergraduates must maintain a 2.0 Grade Point Average (GPA).

University Policies

Per University Policy S16-9, university-wide policy information relevant to all courses, such as academic integrity, accommodations, etc. will be available on Office of Graduate and Undergraduate Programs' Syllabus Information web page at: https://www.sjsu.edu/curriculum/courses/syllabus-info.php. Make sure to visit this page, review and be familiar with these university policies and resources.

In order to request an accommodation in a class please contact the Accessible Education Center and register via the MyAEC portal.

Download Adobe Acrobat Reader to access PDF files.

More accessibility resources.