A1-Exploring Database-driven Web Sites

On This Page Overview Specifications Web Page Requirements Extra Credit Grading Criteria (20) What to Turn In Overview During this assignment, you will: Have an excuse to surf the Web and call it education! Become familiar with the capabilities of database-driven Web sites that use PHP Gather ideas for your database-driven Web site project Provide the instructor with contact information. Tell the instructor about your interests and skills. This information enables the instructor to make course adjustments to meet student needs. Decide if you have the necessary preparation to successfully complete this course. Note: if you do not complete this assignment on time, you might be dropped from the course. However, do not rely on the instructor to drop you because he may not. You are entirely responsible for dropping any course. ^ top Specifications This assignment has several parts and you must complete all of them for full credit: First make sure you have completed the exercises from lesson 1 and have saved the files using the specified names exactly. Using the specified file names makes for easier grading. Complete the Readiness Assessment quiz in Blackboard. Note that this is an ungraded quiz and you are taking it only to help you determine if you have the necessary knowledge and skills to do well in this course. However, you will be graded on whether or not you take the quiz. Copy the following information headings into an email, fill in the information, and send it to the instructor at the email address posted on his Web page with CIS-165 in the subject line: Full name: Email address: Phone number: Grading Option: Default, letter grade or pass/no-pass College major (or goal if undeclared): Do you understand that you must attend the final exam in person? Yes or No Score received on the Readiness Assessment: Do you meet the following recommended course requisites? DM-60A or equivalent? (Yes or No): Math 154? (Yes or No): Eligibility for ENGL 100? (Yes or No): Eligibility for READ 100? (Yes or No): Do you meet the following required course requisites? CIS-132, CS-11 or CS-12J or equivalent? (Explain): Do you have the necessary knowledge and skills to do well in this course? Yes or No What do you think you need to do, if anything, to get ready to take this course? Description of any physical or learning disabilities that I should be aware of: What you hope to gain from taking this course: Occasionally, the instructor is contacted about jobs for students. Do you want your name and email address given to such inquiries? I suggest you copy ("CC") yourself on the email to ensure it is sent correctly. Upload a photo, from which I can easily recognize you, to the Roster in Blackboard. Note: you must make your name and photo public for credit. Take some time to visit several Web sites that use PHP. Try to determine which pages store information that is later used in the same or another page. Find at least three (3) different examples of data storage and retrieval for Web sites that use PHP. Describe how you determined the pages used PHP. You can tell which pages use PHP because the page ends with the file extension .php. You can tell if a database is used because on one page you enter data into a form and another page displays or uses the data you entered. For example, you may need to register so that you can view certain areas of a web site. The registration data is usually stored in a database like MySQL. Then your registration data is looked up in a database when you login again to verify your password and, perhaps, display your name. Create an HTML Web page following the requirements listed below that includes the result of your investigation. Create a text file named README.txt with the information required for, and following the format shown, in the instructions for submitting assignments. Zip your files and submit the zipped archive file to Blackboard as explained in the section of this document: What to Turn In. Remember to complete Quiz 1 before the due date shown in Blackboard. Also, remember to read the assigned chapters of the textbook and post a new graded discussion topic and a response to the topic of another student. ^ top Web Page Requirements Create a single Web page that displays an image of yourself on the page using an image tag. Use relative links for the image tag and any other files that are part of your main page. Also, make certain your web page uses the same case as the file name of the photo. Upper and lower case matters for file names on Blackboard, unlike on Windows. Include any other personal information you would like. Note that all students in the course will be able to view this page so only include information you want viewed! Add to the Web page a report on the results of your investigation of PHP pages that store information. Include the following information for each of the 3 sites: A labeled hyperlink to where information is collected for storage Another labeled hyperlink to where the collected data is used Note: a hyperlink in not a URL. A hyperlink includes anchor tags and clicking the link must move the browser to the correct page. Your Web page file must end with an extension of either .html or .htm. For an example Web page: see here. If you need help with the HTML, see the Links page for tutorials and other suggestions. Also, you can start with my example page and modify it based on your research. ^ top Extra Credit The following are worth extra credit points: Install Apache, PHP, MySQL and phpMyAdmin on a computer system other than the computer in the classroom. (2 points) Describe what operating system(s) you installed the tools on, the steps you went through and your results in the README.txt file you submit. Include a description of how you tested the installation. If you do not describe your installation adequately, you will not receive the extra credit. ^ top Grading Criteria The instructor will evaluate your assignment using the following criteria. Each criteria represents a specific achievement of your assignment and has a scoring guide. The scoring guide explains the possible scores you can receive. Some scoring guides have a list of indicators. These indicators are a sign of meeting, or a symptom of not meeting, the specific criterion. Note that a single indicator may not always be reliable or appropriate in a given context. However, as a group, they show the condition of meeting the criterion. For information on grading policies, including interpretation of scores, see the course information page. Lesson Exercises 2: All lesson exercises attempted and turned in 1: Some lesson exercises completed and turned in 0: No lesson exercises completed or turned in Readiness Assessment Quiz 2: Readiness Assessment quiz completed 0: Readiness Assessment quiz not completed Student Information Email 2: All the student information was provided 1: Some student information was not included 0: No email sent Identifying Information 2: Web page completed with an image showing 1: No image file provided or no image tag in the Web page 0: No image file and no image tag in the Web page Database-Driven Web Site Report 10: Three (3) different data storage and retrieval Web-page examples reported with all the required information and no spelling or grammatical errors 8: Some missing information about data storage and retrieval Web-page examples or may have 1-2 spelling or grammatical errors 6: Missing an example Web site or has more than 2 spelling or grammatical errors 4: Missing more than one Web-page example of data storage and retrieval 2: Almost no information provided but the report was turned in 0: Web page was not turned in REAME.txt File 2: README.txt file submitted with specified information included 1: README.txt submitted but some information was not included, or no ZIP file submitted 0: No README.txt submitted Maximum Score: 20, plus extra credit (0 if you do not submit any files to the assignment area of Blackboard). ^ top What to Turn In Submit your assignment following the instructions for homework. Create a single zip file with the following: README.txt file All the exercise files from Lesson 1 Your single HTML Web page Your image file Set the starting page to your single HTML page. You must submit all the files needed for your assignment to work properly and your assignment must work as submitted. Remember to take Quiz 1 after you complete the assignment. ^ top Home | Blackboard | Syllabus | Expectations | Schedule Project | Help | FAQ's | HowTo's | Links Last Updated: February 26 2010 @17:46:25