AOIT Web Design

Thank you

2006-05-23T08:24:00.000-07:00

I hope you were introduced to HTML, PHP, and SQL. What took a long time at the beginning is now somewhat routine for you. My biggest regret is that the school did not provide you with copies of Dreamweaver for use at home. I also regret not opening up the port so you could access the AOIT server from home. But I think most of you have a pretty good idea what dynamic web programming is about. Maybe in the future some of you will continue with computer science courses or you'll practice on your own.

Take care!

Review

2006-05-22T08:49:00.000-07:00

Know the following:

MySQL:
Creating tables
Populating Tables
SQL SELECT statements

HTML:
Background color and images
Links
Tables
Inserting PHP and Javascript
Font color and size

PHP:
Variables
If statements
For loops
While loops
Understand the programs here.

Dreamweaver:
Basic usage

An example of AOIT work I found online

2006-05-22T08:07:00.000-07:00

When you type in AOIT, this school comes up first with Google. Look at their student work examples...I'd say you guys are ahead of most 10th graders.

Good review of functions and classes

2006-05-21T08:13:00.000-07:00

http://www.osnews.com/story.php?news_id=6788

AJAX

2006-05-18T20:55:00.000-07:00

http://ajax.solutoire.com/

Many of you will use this in your future web programming...

One of the more interesting explanations of MySpace

2006-05-17T19:05:00.000-07:00

It's an inverse relationship: as fear goes up, public outings go down. Public outings go down, myspace activity goes up.

Funny site

2006-05-16T20:38:00.000-07:00

http://www.rinkworks.com/dialect/

20% of your final

2006-05-16T09:03:00.000-07:00

You will create a web page for a Killian club (pick any) with the following requirements:

No templates from the Internet.
Use an example of PHP, Javascript, and HTML (obviously).
Due on the day of the final AT THE BEGINNING OF CLASS as a link on your blog!!

The three pages need to have links to each other. One page must have a table of some sorts. Use interesting colors and pictures (4 minimum).

Also you need to create a table with the student information: First Name, Last name, Homeroom. Use the PHP Connection script from February 6th 2006 to display the first names ONLY on a page.

Create an interesting logo and put it at the top!

I encourage code reuse from other projects obviously.

Grade breakdown:

30% pictures, color, and table
20% PHP connection
20% student table
10% Javascript example
10% logo
10% working links between three pages

PHP Scripts to study

2006-05-16T07:52:00.000-07:00

1. How to display the date on a web page.

2. Change the background color based on the day of the week. Uses logic (if statements)!

3. Calculate the averages.

4. A.) A php slot machine in action.

B. The code for above example.

5. A. Refresh this page a few times.

B. The code for the example. Notice the use of arrays.

Your assignment is to put each of these scripts on the server and comment each line.

Remember comments are with // or /* */

Class Exercise

2006-05-15T09:09:00.000-07:00

Write a for loop that counts out the minutes in an hour and displays every fifth minute, display the minute and the time left until the hour is through.

Today's exercise.

Yet another bot

2006-05-14T10:41:00.000-07:00

Try it if you want.

TO all the cosseted rap fans

2006-05-14T10:20:00.000-07:00

Read this.

More PHP Practice

2006-05-11T08:40:00.000-07:00

Today's practice PHP:

We are going to create a higher/lower game with PHP.

PHP Fun!

2006-05-11T08:19:00.000-07:00

We are still reviewing for the final. Yesterday I was going to attempt a PHP Blackjack game but the motivation was not there.

It seems the for loop review was necessary though...

For loop review

2006-05-10T09:03:00.000-07:00

Daily Assignment:

You have to make a for loop that goes by fives up to 500.

Start at 0 goes to 500.

Video games are fun...

2006-05-09T20:22:00.000-07:00

But do you really want to be like this?

Looks like the proxy server blocks it...I can always VNC home and upload the image...

2006-05-09T20:19:00.000-07:00

With a partner

2006-05-08T08:28:00.000-07:00

You are creating a payroll system with PHP.

The specifications:

Create an if statement with PHP concerning payroll. If the salary is more than 100,000 the tax rate is 35%. Between 80,000 and 100,000 the tax rate is 30%. Between 60,000 and 80,000 the tax rate is 25%. Between 40,000 and 60,000 the tax rate is 20%. Between 20,000 and 40,000 the tax rate is 15%. Between 0 and 20,000 the tax rate is 10%.

The program needs to output the taxes due based on the salary and rate.

Funny about Disney

2006-05-06T07:12:00.000-07:00

Check it out.

the groups<3

2006-05-03T08:43:00.000-07:00

The groups so far:
Amanda
Kim
Stephanie

Hans
Horus
Carlos

Mark
Jason
Jacob
Kristie

Nathalie
Estefania
Luis
Andres

David
Mason
Brandon
Bjorn

Review of Year

2006-05-03T08:36:00.000-07:00

Gruop Review
-groups of three
1-Review of HTML,PHP,MYSQL on website. Be concise!
(all the points have to link to everything)
2-Podcast about php
3-Oral presentation about MYSQL, JAVASCRIPT,OR Video (Put online) e.c. one grade
4-Powerpoint review about open source technology (20 slides min.)
This project is worth 8 GRADES!!!

Either find a Killian club...

2006-05-02T19:45:00.000-07:00

Either find a Killian club to make a web page for the essay portion of the final or I'll assign you one. You have until Friday to tell me which club. By next Monday you'll turn in a plan for the web page (remember we drew up a design at the beginning?).

The Heat are winning now...

Found another free book online

2006-05-02T19:42:00.000-07:00

This PHP book is free. Looks more legit.

Interesting article about MySpace

2006-04-27T05:15:00.000-07:00

Read it if you want.

Keep working on your site

2006-04-27T04:09:00.000-07:00

Keep working on your site...here's an interesting article for you to read if you are finished.

Also you can review the questions about PHP from the e-book.

Why didn't I think of that?

2006-04-25T19:35:00.000-07:00

Oh, yeah. Way over my head.

Too funny: wikipedia satire

2006-04-25T18:01:00.000-07:00

Check it out.

Site of your own!

2006-04-25T09:02:00.000-07:00

You pick the topic. Only requirement is to have one aspect of Javascript, PHP, and of course HTML. You can use templates if you want.

Due Friday.

Download this book

2006-04-23T23:19:00.000-07:00

Download this book.

Read chapter 2 and 3. As you read answer these questions on your blog:

From Chapter 2:
1. What is a multidimensional array?
2. What does list() do?
3. What do 'conversions' have to do with data types?
4. What do 'increment' and 'decrement' operators do?
5. What does casting do with data types?
6. Are brackets required for if statements?
7. How is a switch statement like an if statement?
8. Re-write the squared program to actually CUBE a number.
9. What does strlen() function do?
10. What is the difference between calling functions by reference and by value?
11. What is a static variable for?

Post your answers on your blog today!! Graded tomorrow.

Read these...post your top five

2006-04-23T19:52:00.000-07:00

http://www.technicat.com/writing/programming.html

Write your own top five tips for programmers.

Our good friend Fibonacci

2006-04-23T19:50:00.000-07:00

Read it.

Write a one page summary of this

2006-04-23T08:20:00.000-07:00

This is for a grade.

Read this.

Write a reaction piece.

Thank you

2006-04-20T21:13:00.000-07:00

Class,

I really have a good feeling about the effort shown toward getting your business sites connected with their respective databases. Going around the room I've noticed a willingness to ask questions and mostly a determined effort. This isn't universal but that's obviously expected.

So I hope we can continue the energy with this next assignment.

This fits nicely with what we've been doing because dynamically created tables are great for formatting info gleaned form the tables.

Final touches for your site

2006-04-20T07:45:00.000-07:00

Okay by now most of you have good pages with information. Most of you still need to add some PHP-MySQL connectivity. Hopefully you have created the MySQL table for your business.

To connect to the site is not really that hard. First go to February 6th on the blog and copy the code into a page that save with the extension .php.

There will be two students to help you.

In case you were interested in linux...

2006-04-18T09:09:00.000-07:00

http://fedora.redhat.com

http://www.ubuntu.com

http://www.debian.org

Try them out!!!!!!!!

Thanks Steph

2006-04-17T09:17:00.000-07:00

Read this.

A podcast

2006-04-17T01:54:00.000-07:00

Make a podcast of your explanation for PHP and MySQL newcomers and get EXTRA CREDIT (2 grades!).

Steps:

GOTO: Google

Type in: create podcast

I'm feeling lucky.

Inform me when finished.

Business site

2006-04-17T00:18:00.000-07:00

Your business site needs to have PHP-MySQL connectivity. Due on Friday.

Today I want you to create a tutorial for a complete newbie to the world of PHP programming. You need to give four examples for for loops, if statements, and functions.

Next you will create a tutorial for creating tables with MySQL. Also cover the basics of queries, searching and updating.

Famous hackers

2006-04-16T02:23:00.000-07:00

Check it out.

Cool article about the future of information

2006-04-16T00:15:00.000-07:00

DANIEL C. DENNETT
Philosopher; University Professor, Co-Director, Center for Cognitive Studies, Tufts University; Author, Darwin's Dangerous Idea

There aren't enough minds to house the population explosion of memes

Ideas can be dangerous. Darwin had one, for instance. We hold all sorts of inventors and other innovators responsible for assaying, in advance, the environmental impact of their creations, and since ideas can have huge environmental impacts, I see no reason to exempt us thinkers from the responsibility of quarantining any deadly ideas we may happen to come across. So if I found what I took to be such a dangerous idea, I would button my lip until I could find some way of preparing the ground for its safe expression. I expect that others who are replying to this year's Edge question have engaged in similar reflections and arrived at the same policy. If so, then some people may be pulling their punches with their replies. The really dangerous ideas they are keeping to themselves.

But here is an unsettling idea that is bound to be true in one version or another, and so far as I can see, it won't hurt to publicize it more. It might well help.

The human population is still growing, but at nowhere near the rate that the population of memes is growing. There is competition for the limited space in human brains for memes, and something has to give. Thanks to our incessant and often technically brilliant efforts, and our apparently insatiable appetites for novelty, we have created an explosively growing flood of information, in all media, on all topics, in every genre. Now either (1) we will drown in this flood of information, or (2) we won't drown in it. Both alternatives are deeply disturbing. What do I mean by drowning? I mean that we will become psychologically overwhelmed, unable to cope, victimized by the glut and unable to make life-enhancing decisions in the face of an unimaginable surfeit. (I recall the brilliant scene in the film of Evelyn Waugh's dark comedy The Loved One in which embalmer Mr. Joyboy's gluttonous mother is found sprawled on the kitchen floor, helplessly wallowing in the bounty that has spilled from a capsized refrigerator.) We will be lost in the maze, preyed upon by whatever clever forces find ways of pumping money–or simply further memetic replications–out of our situation. (In The War of the Worlds, H. G. Wells sees that it might well be our germs, not our high-tech military contraptions, that subdue our alien invaders. Similarly, might our own minds succumb not to the devious manipulations of evil brainwashers and propagandists, but to nothing more than a swarm of irresistible ditties, Noφs nibbled to death by slogans and one-liners?)

If we don't drown, how will we cope? If we somehow learn to swim in the rising tide of the infosphere, that will entail that we–that is to say, our grandchildren and their grandchildren–become very very different from our recent ancestors. What will "we" be like? (Some years ago, Doug Hofstadter wrote a wonderful piece, " In 2093, Just Who Will Be We?" in which he imagines robots being created to have "human" values, robots that gradually take over the social roles of our biological descendants, who become stupider and less concerned with the things we value. If we could secure the welfare of just one of these groups, our children or our brainchildren, which group would we care about the most, with which group would we identify?)

Whether "we" are mammals or robots in the not so distant future, what will we know and what will we have forgotten forever, as our previously shared intentional objects recede in the churning wake of the great ship that floats on this sea and charges into the future propelled by jets of newly packaged information? What will happen to our cultural landmarks? Presumably our descendants will all still recognize a few reference points (the pyramids of Egypt, arithmetic, the Bible, Paris, Shakespeare, Einstein, Bach . . . ) but as wave after wave of novelty passes over them, what will they lose sight of? The Beatles are truly wonderful, but if their cultural immortality is to be purchased by the loss of such minor 20th century figures as Billie Holiday, Igor Stravinsky, and Georges Brassens [who he?], what will remain of our shared understanding?

The intergenerational mismatches that we all experience in macroscopic versions (great-grandpa's joke falls on deaf ears, because nobody else in the room knows that Nixon's wife was named "Pat") will presumably be multiplied to the point where much of the raw information that we have piled in our digital storehouses is simply incomprehensible to everyone–except that we will have created phalanxes of "smart" Rosetta-stones of one sort or another that can "translate" the alien material into something we (think maybe we) understand. I suspect we hugely underestimate the importance (to our sense of cognitive security) of our regular participation in the four-dimensional human fabric of mutual understanding, with its reassuring moments of shared–and seen to be shared, and seen to be seen to be shared–comprehension.

What will happen to common knowledge in the future? I do think our ancestors had it easy: aside from all the juicy bits of unshared gossip and some proprietary trade secrets and the like, people all knew pretty much the same things, and knew that they knew the same things. There just wasn't that much to know. Won't people be able to create and exploit illusions of common knowledge in the future, virtual worlds in which people only think they are in touch with their cyber-neighbors?

I see small-scale projects that might protect us to some degree, if they are done wisely. Think of all the work published in academic journals before, say, 1990 that is in danger of becoming practically invisible to later researchers because it can't be found on-line with a good search engine. Just scanning it all and hence making it "available" is not the solution. There is too much of it. But we could start projects in which (virtual) communities of retired researchers who still have their wits about them and who know particular literatures well could brainstorm amongst themselves, using their pooled experience to elevate the forgotten gems, rendering them accessible to the next generation of researchers. This sort of activity has in the past been seen to be a stodgy sort of scholarship, fine for classicists and historians, but not fit work for cutting-edge scientists and the like. I think we should try to shift this imagery and help people recognize the importance of providing for each other this sort of pathfinding through the forests of information. It's a drop in the bucket, but perhaps if we all start thinking about conservation of valuable mind-space, we can save ourselves (our descendants) from informational collapse.

Crazy or genius...

2006-04-15T12:09:00.000-07:00

One word answer to this post.

Ruby on Rails

2006-04-09T09:14:00.000-07:00

This is quite a popular programming language! Here's a good free tutorialhere

PHP CODE

2006-04-07T08:56:00.000-07:00

You have a chance to make up the PHP quiz if you didn't do as well as expected.

Print out the code with your name commented.

Progress on web pages is good....

2006-04-05T08:47:00.000-07:00

Get the PHP code from February 6th 2006 and add it to your page!

DF

Answers to loop questions

2006-04-04T09:15:00.000-07:00

Loops:
for($i=10000; $i >= 100; $i = $i - 10)
{
//echo $i;
//echo "
";

}
//while loop goes HERE!:
//Written by :
$i = 3;
while($i < 333)
{ $i=$i+3;
echo $i;
echo "
";
}
//second while loop
$i=0;
while($i <= 100)
{
$i = i+2;
echo $i;
}
?>

Quiz on loops tomorrow

2006-04-04T09:07:00.000-07:00

Study the looping code I wrote in class today. You will have very similar questions on a quiz tomorrow. YOu will only have 10 minutes and will not be able to use the Internet during the quiz.

Loop Practice

2006-04-04T08:27:00.000-07:00

1. Write a for loop that starts at 10000 and decrements by 10 to number 100.

2. Write a while loop that starts at 3 and ends at 333 and goes by 3.

3. Write a while loop that prints out all even numbers up to 100.

For those of you who like pranks...

2006-04-03T01:24:00.000-07:00

This is from MS.

Joke of the day...

2006-04-02T21:13:00.000-07:00

The truth hurts.

Great tips for searching with google...

2006-04-02T21:04:00.000-07:00

http://blog.outer-court.com/archive/2005-09-29-n85.html

Turning your business page into a DYNAMIC site

2006-04-02T19:59:00.000-07:00

By now most of you are nearing completion of your main page. The pictures are good, the layouts are reasonably done...but now we have to add some dynamic capabilities. Refer back to our lessons on MySQL and create a table using phpMyAdmin that will keep track of customers. You will add a screen to add information about a customer (Name, Address, Credit Card Number). Refer back to the PHP code to connect to the database.

Five Important Algorithms

2006-04-02T19:57:00.000-07:00

Read this...we will have a quiz on algorithms later this week.

At noon

2006-03-30T08:22:00.000-08:00

There are 18 students in the class...each student will present for one minute. We will go in alphabetical order...

Starts at noon!!

Answers to quiz questions

2006-03-28T09:00:00.000-08:00

1.
$numtoloop = 5;
$num = 0;
while($numtoloop > 0){
$num = $num + $numtoloop;
$numtoloop--;
}echo $num;
?>

2.

function programmer compliment(){
echo "You are a logical programmer!";
}

3.

function milespergallon($miles, $gallon){
$mpg = $miles / $gallon;
return $mpg;
}

Comment on your blog

2006-03-27T20:29:00.000-08:00

Read this. Comment on your blog.

Project ideas

2006-03-27T09:21:00.000-08:00

Think of an online business (different from your first group project).

Your idea has to be up here by the end of the period. Start working on your HTML page after thinking of you thought of your idea.

1. Sell used golf balls- David A.
2. Youth Group...Selling items - Jacob G.
3. Sell computer software for cheaper prices than retail - Mark O.
4. Magazines - Bjorn F
5. Custom apparel- Kristie P.
6. Antique and rare books- Erik A.
7. Bass Guitars - Kim A.
8. Candy - Steph P.
9. Bathing suits - Nathalie I.
10. Shoes and bags- Estefania M.
11. Vintage clothing - Amanda M.
12. Sports stuff- Brandon G.
13. Guitars-Hans V.
14. Music cds - Carlos C.
15. Cars - Mason N.
16. Used mp3 players - Luis M.

Quiz....finally

2006-03-27T09:02:00.000-08:00

You have the code for the questions put on the blog. You need to memorize the code...we are going to have a quiz based on the questions tomorrow. The computers will be off, so it must be from memory.

After it is done you have to finish the HTML page for your business idea.

In case you were interested in creating games...

2006-03-26T18:51:00.000-08:00

Check this out.

Interested in the X-Box 360?

2006-03-26T08:58:00.000-08:00

Check this out.

Study this for your quiz

2006-03-24T08:29:00.000-08:00

1. Loop to determine sum of numbers to 0 example 5+4+3+2+1
give it 5
get back 15

2. Make a simple function to return text.

3. Function to calculate miles per gallon.

You have to watch this!

2006-03-23T23:01:00.000-08:00

Check this out!

Ajax write!

code..turn this into a working code

2006-03-23T09:07:00.000-08:00

//Class lizard
class Lizard
{
public $length;
//must be capitalized!
public $weight_in_grams;
private $name;
private $sex;
private $willingness_to_mate;
private $laziness;
public $num_roaches_consumed;

//here we define functions

public function numlikelytoconsumeweekly($weight_in_grams, $laziness)
{
//400 gram lizard
//if the lizard is lazy at 400 grams it will eat 5 roaches
//if it is energetic 10
//at 600 grams it will eat 15 if lazy and 20 if not lazy
if ($weight_in_grams) {

} elseif ($weight_in_grams) {

} else {

}
}
}

On your blog

2006-03-22T22:05:00.000-08:00

What is web 2.0?

Quiz on while loops and recursion on Friday

2006-03-22T09:25:00.000-08:00

While loops and recursion...know the concepts.

We are working on a program to add all the numbers to zero starting from a certain point.

Example = 4+3+2+1=???

Congrats to our first winner!

2006-03-20T11:54:00.000-08:00

Kudos to Mark O. who figured out the first code to display Fibonacci's numbers. He used an iterative design...that means we are still waiting for someone to write a recursive function in PHP!

Here's his output:

0
1
1
2
3
5
8
13
21
34
55
89
144
233
377
610
987
1597
2584
4181
6765
10946
17711
28657
46368
75025
121393
196418
317811
514229
832040
1346269
2178309
3524578
5702887
9227465
14930352
24157817
39088169
63245986
102334155
165580141
267914296
433494437
701408733
1134903170
1836311903
2971215073
4807526976
7778742049
12586269025
20365011074
32951280099
53316291173
86267571272
139583862445
225851433717
365435296162
591286729879
956722026041
1548008755920
2504730781961
4052739537881
6557470319842
10610209857723
17167680177565
27777890035288
44945570212853
72723460248141
1.1766903046099E+14
1.9039249070914E+14
3.0806152117013E+14
4.9845401187926E+14
8.0651553304939E+14
1.3049695449287E+15
2.111485077978E+15
3.4164546229067E+15
5.5279397008848E+15
8.9443943237915E+15
1.4472334024676E+16
2.3416728348468E+16
3.7889062373144E+16
6.1305790721612E+16
9.9194853094755E+16
1.6050064381637E+17
...

Way to go!!

What a great discovery

2006-03-19T21:53:00.000-08:00

Check this out!

Open Laszlo!

Recursion...extremely important for computer science

2006-03-19T21:05:00.000-08:00

The essence of computer science.

Now we begin on object oriented programming

2006-03-17T19:33:00.000-08:00

Actually wikipedia has a decent intro to the subject. Read this, especially the section on object oriented programming.

Before you program...

2006-03-17T08:46:00.000-08:00

We are going to discuss the preliminaries before coding...We will use this page.

Study the first chapter of the networking...you will need it for a quiz on Monday.

Create a seven question javascript quiz...

2006-03-16T08:38:00.000-08:00

Create a seven question quiz using this page.

Follow the instructions and put your quiz on the server. Leave a link to it on your blog.

Assignment for today

2006-03-16T08:07:00.000-08:00

Finish reading all of chapter 1 here.

Answer these questions. Due tomorrow.

Final Extension

2006-03-15T13:03:00.000-08:00

Code or comments on code due tomorrow March 16th 2006. Email me for the zipped code before midnight.

Alternative Assignment

2006-03-14T08:13:00.000-08:00

I have decided to make an alternative assignment. You will choose which one to do. I answered every question and tested the code. If you would rather write a comment for each line of code (instead of writing the code yourself) you have that option. I will forward you a zipped up copy of the code. You must print it out with your comments following each line. Comments use two forward slashes //

Still due tomorrow.

Square area

2006-03-14T06:00:00.000-08:00

Clicking above will not work...blogger does not offer PHP support (that I know of) but you may use this PHP code as an example for your area coding question below.

To make the text box and submit button simply put this code in brackets <>:

INPUT TYPE = "TEXT" VALUE = "side" NAME = "side"
INPUT TYPE = "SUBMIT" VALUE = "CLICK HERE"

A Free Host For PHP

2006-03-13T12:15:00.000-08:00

www.perfectfreewebhosting.com has lots of good features.

Classwork/ Homework

2006-03-12T22:26:00.000-08:00

No talking in class.

Include relevant comments with the programs. You are to select three of the following five.

1. Write a PHP program that compares the length of two words and returns which word is longer. strlen($string) is the most efficient and effective way to do this. Look at the code here.

2. Write a PHP program that compares a random number generated by the computer

srand(time());
$random = (rand()%9);
?>
between one and nine with a number entered from a user. The program must request the user to enter the number again and again until the user enters the same number as the program found. There are many ways to accomplish this.

3. Write a program that uses a for loop to display the first nine numbers that are divisible by three. Think about how many times this loop will need to run...

4. Write a program that asks the user for the radius of a circle and the length of a square. Your program will return the area of both and then a message telling the user by how much the larger of the two is than the smaller. use the squarearea.php program we wrote in class.

5. Write a program that requires the user to enter any word they desire. Store the word in a variable and if any letter in the word is 't' or 'v', return the string "INVALID WORD!"

You can request help via email but you may not discuss this work with other students. This is not a collaborative assignment. I will not waste class time by TALKING about such work. I've done too much it seems.

Due Wednesday.

Title your paper:

Last name, First name
Individual Fourth Nine Weeks PHP Assignment Number 1
Today's date

Before your code include the question. Only code that works will get full credit.

A quiz of your design...with PHP!

2006-03-10T06:13:00.001-08:00

Follow the instructions here how to make a quiz with PHP. Individually you need to create a quiz about whatever you want...but make it something different from the Javascript quiz you made. Put it on the server in your folder and I will grade it next week. Keep it at 10 questions.

When you are finished make sure you work on your group's "PHP Store". You need to be able to at least view all the customers and items up to this point. I noticed many of you are struggling with this. Just take it one step at a time. First use the code from the blog in early February to connect with the tables you made with PHPMyAdmin. Then select what information you want using SQL. Then figure out how to format it. Use the code from the blog to go through the $result variable. Don't worry about updating information at this point...just display what's in the tables!

Have fun working on this and good luck on the FCAT. I'm sure you will all do great!

A quiz of your design...with PHP!

2006-03-10T06:13:00.000-08:00

First of all look at what google bought!

2006-03-10T05:49:00.000-08:00

Remember 'Writely' from class yesterday?? Google must've thought it was a good idea...

Google Space Online

2006-03-09T10:17:00.000-08:00

Read this.

Are you a nerd?

2006-03-09T09:07:00.000-08:00

Take this test.

Read and evaluate each of these articles

2006-03-09T05:11:00.000-08:00

http://ask.slashdot.org/article.pl?sid=06/02/17/2355231

Looking for work?

2006-03-05T19:05:00.000-08:00

Check here.

Free word processing online

2006-03-04T19:13:00.000-08:00

This is the direction computing is going...Apps online.

We are going to start learning Object Oriented Programming

2006-03-04T18:43:00.000-08:00

Read this. It will be very important.

Open source software is secure

2006-03-04T18:41:00.000-08:00

Read this.

slashdot

2006-03-03T09:06:00.000-08:00

slashdot

Login to PHPMyAdmin

2006-03-02T08:30:00.000-08:00

Login to http://aoit/phpMyAdmin/

Login name: Your first name
Password: Your last name

I want you to make a table of all your favorite musicians and their recent releases.

You can mail forms to yourself!

2006-03-01T23:11:00.000-08:00

How cool...I never knew that at all!

Myspace backlash?

2006-02-27T18:52:00.000-08:00

Are parents overreacting?

SQL Course

2006-02-27T09:24:00.000-08:00

http://www.sqlcourse.com

Build a web page

2006-02-24T08:22:00.000-08:00

http://pages.google.com/

Test SQL

2006-02-24T08:10:00.000-08:00

SQL TEST. 3 Grades total. ALL SQL MUST WORK FOR FULL CREDIT!

SQL Problems (#1-#20 5 points each; two grades)
Use the following table named CITY_TEMPS for the next five questions:

City State High Low
Phoenix Arizona 92 69
Tucson Arizona 92 60
Flagstaff Arizona 90 72
San Diego California 90 65
Albuquerque New Mexico 105 67

1. Write an SQL statement that searches for the cities where the high temperature was above 88 degrees.

2. Find all the unique cities in Arizona.

3. Find all the cities that had a low below 70 degrees.

4. Find all the cities that have the letters “an”.

5. Find the average High temperature.

Creating tables:
6. Create a table STUDENT_RECORDS with five columns, while using proper SQL, which will contain the following information: test grade, behavior, first period, second period, third period, fourth period, fifth period, sixth period.

7. Create a table PRODUCT with four columns, using proper SQL, which will contain the following information: product, price, weight, quantity.

Inserting information:
8. Insert your own information into STUDENT_RECORDS using proper SQL.

9. Insert the following information into PRODUCT:
a. Nintendo, $100, 2 lbs, 4

b. Hula Hoop, $3, .5 lbs, 5

c. Computer, $200, 7 lbs, 2

Updating information:
10. Update PRODUCT so that the price of the Nintendo is $145.

11. Update the table so that STUDENT_RECORDS has a column for a seventh period.

Deleting information:
12. Delete all products from PRODUCT that cost less than $75.

13. The STUDENT_RECORDS table has become useless. Delete it completely from the database.

Modeling Information:
14. You have been hired to create a database for the computers in this room. What are four vital pieces of information will you need to keep track of?

15. Pretend the database has already been created and is known as COMPUTER. What SQL code is needed to create your table?

Inserting Information:
16. Populate the table (you choose the name) with FOUR pieces of information.

Searching Information:
17. (Easiest question on the test) Display everything in the table.

SQL Functions:
18. Refer to the CITY_TEMP table on page 1. You need to find the city with the lowest low temperature. What SQL code do you need?

:
19. Refer to the CITY_TEMP table on page 1. How many cities are in the table?

20. Refer to the CITY_TEMP table on page 1. Select all the cities from New Mexico.

ESSAY 50 points each (1 grade):
21. Describe the steps in creating a database, tables, and columns. What are the steps in populating the table?

22. How do PHP and MySQL work together?

Read this and comment

2006-02-24T08:09:00.000-08:00

Read this!

Your assignment

2006-02-23T08:28:00.000-08:00

You are to use Access to make each table and query from the SQL test. Print out all tables and queries. Due today.

Might help with your extra credit

2006-02-22T20:08:00.000-08:00

www.hotwired.com/webmonkey/06/08/index2a.html

cool stuff...

What I was saying in class...

2006-02-20T03:33:00.000-08:00

Literacy.

Write your opinion on this article after your test

2006-02-16T16:58:00.000-08:00

After your test, read this article and evaluate it.

Study this for hw

2006-02-14T09:24:00.000-08:00

Do these examples.

AJAX

2006-02-13T20:48:00.000-08:00

Read this article.