Midterm Review

1
Midterm Review

• SI 539
• Fall 2004
• S. Bartlett

2
Topics

• Design of Complex Web Sites
• HTML
• CSS
• PHP
• MySql
• UNIX

3
Material Covered

• Homework reading
• Homework deliverables
• Lab handouts and exercises
• Lecture
• Can't cover all this in 2 hours

4
Study ApproachForeign Language

• Memorize vocabulary
• Memorize syntax
• Memorize simple "conversations" information or
  code that is used over and over again
• Translate from English to the technology
• Translate from the technology to English

5
Design of Complex Web Sites

• Lectures
• http//www.si.umich.edu/bartlett/WebsiteDesign.pp
  t
• http//www.si.umich.edu/bartlett/WebsiteDesign2.p
  pt
• http//www.si.umich.edu/bartlett/WebPageDesign.pp
  t
• http//www.webstyleguide.com/
• Homework readings
• Assignments
• Sep 14/15 site definition
• Sep 21/22 check site definition with site owner
• Sep 28/29 site prototype
• Oct 5/6 site design
• Lab
• Sep 14/16 description of site owners, group
  members, and site

6
Be sure to know

• Site development process each step and what it
  entails
• Issues in web site design and implementation
• Web page design issues

7
DISCLAIMER

• THIS IS NOT A GUARENTEE THAT THESE QUESTIONS OR
  THIS MATERIAL WILL APPEAR ON THE EXAM. THESE ARE
  JUST SAMPLE QUESTIONS ILLUSTRATING THE GENERAL
  LEVEL OF DETAIL AND THE QUESTION FORMAT.

8
Sample Questions

• What is a web site?
• List the steps in the site development process
  and explain each
• True/false your needs are not important in
  website design
• Which of the following is not an element of web
  page design?
• a) Alignment b) Proximity
• c) Contrast d) Comparison

9
HTML

• Homework readings
• Assignments
• Sep 14/15 site definition
• Sep 21/22 web page for database design
• Sep 28/29 site prototype
• Oct 5/6 site design
• Oct 12/13 - forms
• Lab
• Sep 7/9 HTML
• HTML lab handout
• Oct 12/14 make a form to get query info from
  the user
• Style
• http//www.si.umich.edu/bartlett/style.txt

10
Be sure to know

• All the tags and attributes on the HTML handout
  except POSTIONING, FRAMES, SCRIPTS AND JAVA
• everything after Citation in STRUCTURAL
  DEFINITION,
• everything after Font in PRESENTATION FORMATTING,
  
• everything after Images in LINKS etc.,
• everything after Ordered List in LISTS
• Know how to use them
• Style

11
DISCLAIMER

• THIS IS NOT A GUARENTEE THAT THESE QUESTIONS OR
  THIS MATERIAL WILL APPEAR ON THE EXAM. THESE ARE
  JUST SAMPLE QUESTIONS ILLUSTRATING THE GENERAL
  LEVEL OF DETAIL AND THE QUESTION FORMAT.

12
Sample Questions

• What is HTML?
• Write a web page that prints your name in large
  red letters and has a drop down list of your
  favorite foods.
• Given this HTML, draw what the page will look
  like.
• Why is it important to specify a maximum length
  for a text entry control in a form?
• True/False HTML is used to connect to a
  database.
• Tell what technology this code belongs to and
  what is it used for?
• lttablegt

13
CSS

• Lectures
• http//www.si.umich.edu/bartlett/CSS.ppt
• CSS Property Reference
• Homework readings
• Assignments
• Sep 28/29 prototype web pages

14
Be sure to know

• The 3 places to put CSS and how to do them
• Attributes
• Selectors - bodycolorred
• Selector classes p.fredcolorblue
• Class - .resources a font-size120

15
DISCLAIMER

• THIS IS NOT A GUARENTEE THAT THESE QUESTIONS OR
  THIS MATERIAL WILL APPEAR ON THE EXAM. THESE ARE
  JUST SAMPLE QUESTIONS ILLUSTRATING THE GENERAL
  LEVEL OF DETAIL AND THE QUESTION FORMAT.

16
Sample Questions

• Use internal CSS to make list items have a blue
  background.
• Given this CSS rule, show how it would be used in
  a ltdivgt and tell what effect it would have.
• List 10 selectors you could use in CSS.
• True/False CSS rules should be put between
  ltcssgtlt/cssgt tags.
• Tell what technology this code belongs to and
  what is it used for?
• body background-color black

17
PHP

• Lectures
• http//www.si.umich.edu/bartlett/PHP1.ppt
• http//www.si.umich.edu/bartlett/PHP2.ppt
• PHP Control Structures
• arrays - bottom of page
• Homework readings
• Lab
• Sep 21/23 doing math with PHP
• Oct 5/7 get data from the database and display
  it
• Oct 12/14 get input from the user to query the
  database
• Style
• http//www.si.umich.edu/bartlett/style.txt

18
Be sure to know

• All keywords and operators covered in class, what
  they do, and how to use them
• Functions used in the lab, what they do, and how
  to use them
• Variables, types, type conversion and how to use
  them
• Style

19
DISCLAIMER

• THIS IS NOT A GUARENTEE THAT THESE QUESTIONS OR
  THIS MATERIAL WILL APPEAR ON THE EXAM. THESE ARE
  JUST SAMPLE QUESTIONS ILLUSTRATING THE GENERAL
  LEVEL OF DETAIL AND THE QUESTION FORMAT.

20
Sample Questions

• Write all the PHP code needed to send a query to
  your database. (Use any query you want.)
• List all the style errors in this PHP code.
• Correct all the syntax errors in this PHP code.
• Which of these is a PHP loop keyword? A)loop
  B)doOver C)foreach D)if
• True/False "A" is true.
• Tell what technology this code belongs to and
  what is it used for?
• fred 16
• Practice exercises for PHP http//www.si.umich.edu
  /bartlett/PHP_Practice.ppt

21
MySql

• Lectures
• http//www.si.umich.edu/bartlett/database1.ppt
• http//www.si.umich.edu/bartlett/database2.ppt
• Lab preview
• Homework readings
• Assignments
• Sep 21/22 design the database
• Oct 5/6 site design database prototype
• Lab
• Sep 28/30 make a database
• Oct 5/7 accessing the database in PHP
• Oct 12/14 creating queries with user input
• Style http//www.si.umich.edu/bartlett/style.txt

22
Be sure to know

• All the keywords covered in class and how to use
  them
• Design issues
• Relationship cardinality and how to represent it
  in a database
• Style

23
DISCLAIMER

• THIS IS NOT A GUARENTEE THAT THESE QUESTIONS OR
  THIS MATERIAL WILL APPEAR ON THE EXAM. THESE ARE
  JUST SAMPLE QUESTIONS ILLUSTRATING THE GENERAL
  LEVEL OF DETAIL AND THE QUESTION FORMAT.

24
Sample Questions

• What is MySql?
• There are Students with names and ID numbers and
  Courses with names and designations (like SI539).
  Students can take many courses and each course
  has many students. Design a database for this
  data.
• Describe the attributes of a primary key.
• Given a database description, design a query that
  will return all the information specified.
• List 2 ways to interact with your database and
  describe in detail how to do each.
• Tell what technology this code belongs to and
  what is it used for?
• SELECT name, age, pet FROM people, petType
  WHERE people.pet petType.petTypeID

25
UNIX

• Assignments
• Oct 5/6 site design prototype your database
• Lab
• Sep 28/30 UNIX and database handout
• Oct 5/7 create a database

26
Be sure to know

• The commands on the lab handout, what they do,
  and how to use them
• How to connect to the projects computer

27
DISCLAIMER

• THIS IS NOT A GUARENTEE THAT THESE QUESTIONS OR
  THIS MATERIAL WILL APPEAR ON THE EXAM. THESE ARE
  JUST SAMPLE QUESTIONS ILLUSTRATING THE GENERAL
  LEVEL OF DETAIL AND THE QUESTION FORMAT.

28
Sample Questions

• What is UNIX?
• Name and describe how to use a UNIX editor
• Which of the following commands will list files
  and subdirectories? A)dir B)list C)select D)ls
  E)for
• How would you rename a file in UNIX?
• Tell what technology this code belongs to and
  what is it used for?
• cd HTML

29
Putting It all Together

• What UNIX command lets you interact with MySql?
  Write it out and explain what each part is.
• How do you write HTML and PHP files in UNIX?
• How do you query a database in PHP?
• How do you write HTML with PHP?
• How do you embed PHP in an HTML document?
• How do you get data from a form to a database?
• How do you get data from a database into a web
  page?
• Where can you put CSS code in HTML?
• Why would you use each of these technologies in a
  web site?
• What other technologies can you use in web sites?

30
Study Suggestions

• Make flash cards to learn vocabulary Flash each
  other!
• Redo your labs without looking at what you did
• Work on the CSS, HTML, PHP, and MySql for your
  project
• Experiment with the interactive tutorials
• Study examples on the web in the readings or
  actual web pages
• Read and take notes on the assigned readings
• Memorize the Power Point slides
• Come to office hours with questions

31
Good Luck!!!
Good Luck!
Good Luck!
Good Luck!
Good Luck!
Good Luck!