Final Exam
Week of 05-26-2010
Week of 02-05-2010
>> GWT Project #1: Project Proposal
Week of 01-25-2010
>> Assignment #2: Quadratic Equation -- RPC fun ... in pairs (10 points)
- Write an RPC based application that will take a,b,c coefficients and return the two
solutions to the user.
- Requirements:
- it must use RPC, doing the calculation on the server side and returning the result
- you must style the page via CSS. Make things BIG
- I'll time you ... All features included
< 60 minutes - 10 points
< 65 minutes - 8 points
< 70 minutes - 6 points
< 75 minutes - 4 points
< 80 minutes - 2 points
>> Assignment #1: (10 points) CorrelatorRPCBroken ... fix it
Week of 01-18-2010
>> Final Review
... Part I : You will be given a GWT web application that is using RPC, Databases and
GUI logic.
... a) It will be broken in a number of places and you will be asked to fix it.
... b) You'll be ask to add functionality to the application.
... Part II: How does the Internet work... first weeks
Notes:
-- It is open-notes and computer but by yourself
-- you will not be tested on RPC -- this will not be broken in the test
Topics:
-- Databases: Retrieving and saving data
-- GUI Logic : Events
-- Java: classes, etc
Week of 11-30-2009
... Project #4: HTML part 2: Create your own page using a header and 2 or 3
column layout. Be sure to incorporate everything we have learned
with CSS, coloring etc.
>> Task #2: HW #10: Make this --hw-10.jpg
>> Task #3: PhotoShop day with Zheng ... HW #11 : PhotoShop Banner ScreenShot
Week of 11-16 & 11-23-2009
>> Task #1: HTML : Part 1
... An Overview: The browser
... HTML and CSS : What does it mean? What does it do?
... A HMTL-CSS Simple tutorial <-- Due Friday
>> Task #2: On a piece of paper, looking at the CSS and HTML what are
your questions so far? <-- be prepared to turn this in
>> Quiz #5: GUI Practical - Friday
.. Make a simple calculator that only adds -- two text boxes, label to write the
answer, and a button to generate the answer.
>> Task #3: Working with div to organize your layout
... Complete HTML -- CSS Reference : With Samples
... Video : CSS and column layouts - 9 minutes
... Project #4: HTML part 2: Create your own page using a header and 2 or 3
column layout. Be sure to incorporate everything we have learned
with CSS, coloring etc.
>> Task #4: HW #9: HTML Notes:
... Organize all your thoughts and information related to creating HTML
pages.
.... Major categories should include but may not be limited too:
I. The Internet and Browsers: How HTML gets intertpreted
II. HTML - CSS: What is it? How do connect CSS to HTML elements?
Examples.
III. Header and Column Layouts: Using Div tags with examples of header and
2 and 3 column layouts
Week of 11-2-2009
>> Task #1: Project #2: GUI and HMD
... get countries filled
... get years filled
... radio button working
... submit working
>> Task #2: Quiz #5 : GUI Apps: A practical
Week of 10-26-2009
... commit() inside a loop?
... Using SQL to test for existance
... why transactions?
>> Task #2: Screen shot of death data in database
>> Task #3: Everyone should have all the data in their databases
... If I add a country or two or three will your code work?
>> Task #4: GUI development --
... Basic GUI layouts
>> Task #5: Start Project #2: The HMD in a GUI
Week of 10-19-2009
>> Task #1: InsertBirths
... File Object: File Structure browsing
... Scanner Object : Parsing a text file
... Doing the Insert
>> Task #2: InsertDeaths
>> Task #3: Quiz #4: Scanners, File Objects, Transactions, Prepared Statements
Week of 10-13-2009
>> Task #1: Finish up HMD Database Insert
... !!! Project 1 : Step 3 - 5 points : Test classes
... !!! Project 1 : Step 3 - 10 points : Implement Insert of all data into DB
>> Task #2: Prepared Statements - Avoiding concatenation: Example
>> Task #3: Prepared Statements and SQL transactions : Read and Example
Week of 10-5-2009
>> Task #1: Quiz #3 follow-up and corrections - recoup Quiz points
>> Task #2: Step 1 - 4 completed
Project #1: HMD Project
- Project Description: Project-1-HMD
- Data: file:hmd-data.zip
... On own : download project data
... Analyze the <COUNTRY>births.txt file
... On paper, develop schema you would use
... Bring it back to group
... Modify and create the Workbench Schema
... !!! Project 1 : Step 1 - 10 points : Turn in Schema
... !!! Project 1 : Step 2 - 5 points : Screen shot of mysql tables
... !!! Project 1 : Step 3 - 5 points : UML Object Diagram for DTS
... !!! Project 1 : Step 3 - 10 points : Implement Insert into DB
Week of 9-28-2009
>> Task #1: Finish notes DELETE/UPDATE
>> Task #2: HW #7 : Due Wednesday - Database notes -- detailed
>> Task #3: HW #8 : Worksheet on Databases - Due Friday file:web-dev-hw-8.doc
>> Task #4: Quiz #3: Databases - Friday Quiz
>> Task #5: Step 1 and 2 completed
Project #1: HMD Project
- Project Description: Project-1-HMD
- Data: file:hmd-data.zip
... On own : download project data
... Analyze the <COUNTRY>births.txt file
... On paper, develop schema you would use
... Bring it back to group
... Modify and create the Workbench Schema
... !!! Project 1 : Step 1 - 10 points : Turn in Schema
... !!! Project 1 : Step 2 - 5 points : Screen shot of mysql tables
Week of 9-20-2009
>> Wednesday : HW #7: Reading on Connecting to DB via Java -- summarize what we know
>> Task #1: Quiz from last week --> Joins
>> Task #2: Connect to the database via JAVA: Me, then you
>> Task #3: Select a set of records and write to console: Me, then you
>> Task #4: Insert records into table : Me, then you
>> Task #5: How do you make an Update? Delete - be careful!
9-18-2009
Today:
>> HW #6: Turn in - SELECT statements from Wednesday
>> Quiz #2 file:quiz-2-web-dev.pdf
>> HW #7 : Research connecting and returning resultsets via Java
... Driver Information: MySQL Docuementation: Java-MySQL
... Connecting to DB via Java: Sample
... Overview : JDBC
.... Querying the DB example: Example
>> Bring it Back ...
.... Questions? What terms do we need to know? Where are we stuck?
.... Still struggling ... spend some time this weekend reading more, email me
9-14-2009
Today -- still recovering but almost there folks. Roll on this piece
today:
>> HW #5: Databases
9-11-2009
Throw it down:
... Goals: 1) INSERT and SELECT data into tables
>> 15 min : BIUFAS it -- What do we know about databases so far? What do you still need to
figure out?
>> 10 min : Working with PHPMyAdmin : Video
- Questions : Jot down questions as we go ...
- Clarifications : ?
>> 20 min: Work on manual inserts into tables.
- Create users table from social networking(Or already created table)
- Use PhpMyAdmin : Insert tab to INSERT data
- Use PhpMyAdmin : SQL tab to Insert data - construct the INSERT statement yourself
- Get about 20 records into database some with last name the same, some with gender the
same
>> 30 min : Getting data out --> SELECT: w3schools (Everything on SELECT - 5 pages)
- 15 min: HW #4 for Monday:
- Questions as you read the information
- Summarrize everything you learned on SELECT statements
- Write down what needs clarification
- 15 min: Bring it Back:
- What are the major pieces --> Everyone be prepared to add a piece
- Questions?
- Demonstrate Selects ... PhpMyAdmin, MySQL Query
>> HW #4:
- Part 1: From In-class : w3schools (Everything on SELECT - 5 pages)
-- we did this in class but clean it up and add whatever other questions you have
so I can help you.
- Part 2: Review INSERT INTO : w3schools - 1 page
9-9-2009
Throw it down:
... Goals: 1) Ensure we get how to add tables to database
2) Move towards working with databases
>> 5 min Everyone write down process for putting schema from Workbench in MySQL
>> 10 min US: Build WIki instructions together (Databases)
>> 20 min : Re-turn in Social Networking Quiz Schema - Here's what I want ...
>> Join problems ...
>> Abstractions Problems ...
... Step 1: 5 min -- Draw the schema below again on paper
... Step 2: 5 min -- Show you mine
... Step 3: 10 min -- Questions/Clarifications
>> Project-1-HMD: HMD - Human Mortality Database:
The Berkeley demography department has compiled census data from over 50 countries. It
currently stores this data in a flat text file database; it needs it moved to a relational
database. Your task is to analyze the current files, develop and clearly articulate why your
ERM will efficiently hold the data, create the database itself and move the data into the
tables.
Step #1: Develop the schema and argue its validity
Step #2: Create the tables in MySQL
Step #3: Move the data into the tables.
... Grab text files from share.
... Analyze and write down schema on paper
.., Come back and lets talk
9-3-2009
Throw it down:
>> I am out today folks.
> Part 1 Quiz: Grab a machine, do the quiz by yourself
and send it to me
> Part 2 Quiz: With help if needed but still on your own, implement
the schema in Workbench.
> Get the tables into your database
> Send me email with a screenshot when you get it
done
> HW #3 is below.
Have fun, mm
... Goals: 1) Given a problem develop and implement a db schema on paper, in workbench
and then enter into a database.
>> Quiz #1 ... 1 question
1) A consortium of social networking sites are collaborating to develop an open source use
user profile that can be used on any site that buys into the standards. (eg. One profile
available in Twitter, Facebook, Plaxo, MySpace, etc) Develop a proposal for what data
you might store for a user and how the database would be set up to hold this data.
>> Implement the DB schema from the quiz in MySQL workbench, and move the tables into
your database. For credit, someone volunteer to enter the process into the Databases
wiki.
>> HW #3: Implement the same schema from today or another you develop into your local
database at home. Send a screen shot from MySQL Administrator - Catalogs -
click your database. See example : file:db-Example.jpg
9-1-2009
Throw it down:
... Goals: 1) Implement a reasonable database schema to model a set of data
2) Move this model into an actual database
>> Databases Videos: Clarifications ...
>> The problem continued:
You have a large collection of mp3's that you would like to develop database
to store and organize your collection. Develop a Database Schema.
Step 1: Pair it out : What do we need to consider storing?
Step 2: Discuss out with group
Step 3: Pair it Out: How would you organize this into tables/fields?
Step 4: Discuss it out
Step 5: Lets do it ...
>> The Workbench: Tools to develop schema
>> Move the schema into a database
>> Download MySQL tools/workbench on machines in room or use PHPMyAdmin -
Databases wiki
>> Tonight:
- A consortium of social networking sites are collaborating to develop an open source user
profile that can be used on any site that buys into the standards. (eg. One profile available
in Twitter, Facebook, Plaxo, MySpace, etc) Develop a proposal for what data you might
store for a user and how the database would be set up to hold this data.
- Use MySQl Workbench to work up a proposal, print and bring it to class Friday.
8-31-2009
Throw it down:
>> Databases Videos: Question/Summarize/
... #1: What is a database?
... #2: Database Schema? Primary Keys? Foriegn Keys? ERM?
>> The Problem:
You have a large collection of mp3's that you would like to develop database
to store and organize your collection. Develop a Database Schema.
Step 1: Pair it out : What do we need to consider storing?
Step 2: Discuss out with group
Step 3: Pair it Out: How would you organize this into tables/fields?
Step 4: Discuss it out
Step 5: Lets do it ...
>> Tonight:
Set up the database, tables and fields on your own.
HW #2: Bring Back : Screen shot of result
8-28-2009
Throw it down:
>> 20 min: The Internet continued ... DNS - 8 min
Top-Level Domain Name Servers - 4 min
WebDev Notebook -->
A. DNS
Questions: ...
Summarize: ...
>> The internet : What do we know .. terms, etc
>> Quiz #0 ... 1) Explain how the internet works. Be sure to use relevant vocabulary
2) Draw a pictorial representation a communication between a client and server
over the internet.
>> Database Video's:
... Questions:
... Summarize what you know about DB so far
>> Mysql Workbench and admin tools
>> Tonight:
... screen shot of mysql and tools running on home machine
8-27-2009
Throw it down:
>> 20 min: The Internet continued ... http://www.vimeo.com/2696386
WebDev Notebook -->
A. History of the Internet - Vimeo
Questions: ...
Summarize: ....
Clarification: ....
>> 15 minutes : Compare these two sites:
WebDev Notebook -->
B. mortality.org vs. http://www.gapminder.org/
>> What is implied goal of the creators of each site?
>> What site strikes you as more interesting? Why? What elements make it more
interesting?
>> Are we all on Assembla?
>> Policy and donation sheets?
>> Trouble with database? Download MySQL Workbench, MySQL Tools
--> lets run tests on our databases
>> Tonight:
--> download and install mysql workbench and mysql tools
--> test database as we did in class - does it work? Problems? Questions?
--> Watch: Databases Wiki
Web Dev notebook:
Questions: ....
Summarize: ....
8-26-2009
Today
>> Sign up for Assembla
... email address: smorris@albany.k12.ca.us
... Subject: Web Development
>> What to expect:
... Dynamic, data-driven software for the web and more...
... What do you need to know/expect to get
- learn how to create and use a database
- learn how to build basic user interfaces in java
- learn how to build basic user interfaces in gwt
- learn how transfer data back and forth between client/server
- learn basic html/css skills
- learn how basic software development techniques -- code repositories, etc
... all in three days FTW -- just kidding but I do plan to teach all this in the first 9 - 12
weeks
>> Google IO !!!! --> in May
>> Begin Data Base discussion
>> Tonight :
- Policy and donation request
- Download and install mysql database
- respond to invitation from assembla and get signed up
Resources
>>RPC GWT Tutorial: RPC Tutorial
>>RPC Morris Lesson: Slides
>> Basic GWT tutorials: Basics
>>Course Documents, SVN Instructions, etc: Schoolschloop
>> assembla url: http://svn.assembla.com/svn/ahsweb
>> Drop Box App: getDropBox Get it so that you will never again have to email yourself a file.
>> Everything You Need To Know (almost) : Resources For Web Design
The Cougar(It is a cougar)
......................._,,-~'''¯¯¯''~-,,
....................,-‘' ; ; ;_,,---,,_ ; ;''-,..................................._,,,---,,__-;.
...................,' ; ; ;,-‘ , , , , , ‘-, ; ;'-,,,,---~~''''''~--,,,_.....,,-~'' ; ; ; ;__;'-,
...................| ; ; ;,' , , , _,,-~'' ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ¯''~'-,,_ ,,-~'' , , ‘, ;',
...................', ; ; ‘-, ,-~'' ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;''-, , , , , ,' ; |
.....................', ; ;,'' ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;'-, , ,-‘ ;,-‘
......................,'-‘ ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;''-‘ ;,,-‘
....................,' ; ; ; ; ; ; ; ; ; ; ; ;__ ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ‘-,'
..................,-‘ ; ; ; ; ; ; ; ; ; ;,-‘'¯: : ''-, ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; _ ; ; ; ; ;',
.................,' ; ; ; ; ; ; ; ; ; ; ;| : : : : : ; ; ; ; ; ; ; ; ; ; ; ; ,-‘'¯: ¯''-, ; ; ;',
................,' ; ; ; ; ; ; ; ; ; ; ; ‘-,_: : _,-‘ ; ; ; ; ; ; ; ; ; ; ; ; | : : : : : ; ; ; |
...............,' ; ; ; ; ; ; ; ; ; ; ; ; ; ; ¯¯ ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;'-,,_ : :,-‘ ; ; ; ;|
..............,-‘ ; ; ; ; ; ; ; ; ; ; ; ; ; ; ,,-~'' , , , , ,,,-~~-, , , , _ ; ; ;¯¯ ; ; ; ; ;|
..............,-‘ ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;,' , , , , , , ,( : : : : , , , ,''-, ; ; ; ; ; ; ; ;|
..........,-‘ ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;', , , , , , , , ,'~---~'' , , , , , ,' ; ; ; ; ; ; ; ;',
.......,-‘' ; _, ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ‘'~-,,,,--~~'''¯'''~-,,_ , ,_,-‘ ; ; ; ; ; ; ; ; ; ‘,
....,-‘'-~'',-‘ ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; | ; ; | . . . . . . ,'; ,''¯ ; ; ; ; ; ; ; ; ; ,_ ; ‘-,
..........,' ; ;,-, ; ;, ; ; ;, ; ; ; ; ; ; ; ; ; ; ‘, ; ;', . . . . .,' ;,' ; ; ; ;, ; ; ;,'-, ; ;,' ‘'~--‘''
.........,'-~' ,-‘-~'' ‘, ,-‘ ‘, ,,- ; ; ; ; ; ; ; ; ‘, ; ; ‘~-,,,-‘' ; ,' ; ; ; ; ‘, ;,-‘' ; ‘, ,-‘,
..........,-‘' ; ; ; ; ; ‘' ; ; ;'' ; ; ; ; ; ; ; ; ; ; ‘'-,,_ ; ; ; _,-‘ ; ; ; ; ; ;'-‘' ; ; ; ‘' ; ;'-,
........,-‘ ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;¯¯''¯ ; ; ; ; ; ; ; ; , ; ; ; ; ; ; ; ; ;''-,
......,-‘ ; ; ; ; ; ; ; ,, ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; |, ; ; ; ; ; ; ; ; ; ; ‘-,
.....,' ; ; ; ; ; ; ; ;,' ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;|..'-,_ ; ; ; , ; ; ; ; ; ‘,
....,' ; ; ; ; ; ; ; ; | ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;,'.......''',-~' ; ; ; ; ; ,'
...,' ; ; ; ; ; ; ; ; ;'~-,,,,,--~~''''''~-,, ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;,'.....,-~'' ; ; ; ; ; ; ,-
...| ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ‘, ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;,'...,-‘ ; ; ; ; ; ; ; ;,-‘
...', ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ,-‘ ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ,'....', ; ; ; ; _,,-‘'
....', ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ,-‘' ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;,'.......''~~''¯
.....''-, ; ; ; ; ; ; ; ; ; ; ; ; ; ;_,,-‘' ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ,-‘
.........''~-,,_ ; ; ; ; _,,,-~'' ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;,-‘
...........| ; ; ;¯¯''''¯ ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;,,-‘
...........', ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;,-‘
............| ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;|
............', ; ; ; ; ; ; ; ; ; ~-,,___ ; ; ; ; ; ; ; ; ; ; ; ; ; ;',
.............', ; ; ; ; ; ; ; ; ; ; ;,-‘....''-, ; ; ; ; ; ; ; ; ; ; ; ; ‘,
...........,' ‘- ; ; ; ; ; ; ; ; ;,-‘'..........'-, ; ; ; ; ; ; ; ; ; ; ; ‘,
..........,' ; ;' ; ; ; ; ; ; ,,-‘................', ; ; ; ; ; ; ; ; ; ; ;',
.........,' ; ; ; ; ; ; ; ;,-‘'.....................''-, ; ; ; ; ; ; ; ; ; |
........,' ; ; ; ; ; ; ;,,-‘...........................'', ; ; ; ; ; ; ; ; |
........| ; ; ; ; ; ; ;,'..............................,' ; ; ; ; ; ; ; ;,'
........| ; ; ; ; ; ; ,'.............................,-‘ ; ; ; ; ; ; ; ,''
........| ; ; ; ; ; ;,'............................,-‘ ; ; ; ; ; ; ; ,-‘
........',_ , ; , ;,'............................,' ; ; ; ; ; ; ; ,-‘
.........',,',¯,',''|............................| ; ; ; ; ; ; ; ; ‘--,,
.............¯...''.............................'-, ; ; ; ; ; ; ; ; ; ;''~,,
...................................................''-,, ; ; ; ; ; ; ; ; ; ;''~-,,
........................................................''-, ; ; ; ; ; ,,_ ; ;'-,''-,
...........................................................', ; ; ; ; ; ; ‘-,__,--.|
............................................................'-, ; ; ;,,-~''' , ,|, |
...............................................................''~-‘'_ , , ,,',_/--‘