Here are some notes for your essay about Linux v. Microsoft

http://docs.google.com/Doc?id=dc65q8nz_92jvk592

1. http://blogs.zdnet.com/hardware/?p=420
   
   
2. http://seattlepi.nwsource.com/local/316618_youtube22.html
   
   
3. http://news.com.com/2100-1028_3-6185466.html
   
   
4. http://news.bbc.co.uk/2/hi/uk_news/education/6680457.stm
   
   
5. http://www.newscientisttech.com/article.ns?id=mg19426046.400&feedId=being-human_rss20

There will be questions based on these five articles on your final.

World's Hardest Logic Puzzle

Three gods A, B, and C are called, in some order, True, False, and Random. True always speaks truly, False always speaks falsely, but whether Random speaks truly or falsely is a completely random matter. Your task is to determine the identities of A, B, and C by asking three yes-no questions; each question must be put to exactly one god. The gods understand English, but will answer all questions in their own language, in which the words for yes and no are 'da' and 'ja', in some order. You do not know which word means which.

30 points of your final exam!
Essay question for PHP-MySQL group (10 points) 5 paragraphs.:

• You have been hired by a prominent young businessman to design a dynamic website, specifically a dating website. He wants users to be able to create profiles, upload pictures, play games, and write messages on a forum. How will you store the information? How will you display the information? How will you create the game? Obviously you aren't coding anything here, you are just describing technologies and how they relate in a coherent whole. Discuss how the technologies will interact with each other. Pretend you are writing for a nearly computer illiterate individual.
  

Essay question for the Module Crew (10 points) 5 paragraphs:

• You have been hired by the Module Company to design their newest Programming module. How will you improve it? What will you add? What will you remove? Will you offer games? Tests? How will students be graded? Be creative and design an amazing module.

Essay question for all (10 points):

• This essay will be comparing open source software with the dominant operating system Microsoft Windows in the desktop market and the server market. First give a definition of open source software and proprietary software. Next compare the desktop market. Do any Linux distributions offer an advantage in the desktop market? Why is Microsoft the clear winner?
  
  Finally compare the server market. Give statistics as to which OS is dominant and explain why.

Second essay question for all (there are three essays in total, 10 points):

In today's world it is important to specialize. Pick one area of information technology from something discussed in class and discuss how it could translated into a career. Find jobs available in that area on Monster.com or a similar job hunting website. Explain why you are interested in this particular field.

Answer must be posted on blog or Google Documents by 2:30pm on day of final May 29th for Second Period and May 24th for 5th period.

Head your Google Document or blog with the following:

FIRST NAME, LAST NAME
KILLIAN COMPUTERS

When is it okay to pirate software, if ever?

Is the author correct? Does piracy encourage people to BUY things?

What should movie companies do to stop piracy (if anything)?

Adsense and adwords

Check out this article about adsense arbitrage.

Flash based game

Let's see if this is blocked by X-Stop:

http://www.myminilife.com

It seems like a neat Flash game.

I've added the home I made to my web page for the class review. Check it out:

http://davidcfreer.com/~David/project%20for%20aoit.html

Why people don't switch to Linux...

Read this. It helps to explain why people don't switch to Linux.

2nd period only

Second period look at this:

Suggestion...

An astute student suggested printed out copies of the study guide!

So on Monday you will get a paper copy of the study guide.

It will be complete so you can study away from the computer.

Essay question for PHP-MySQL group (10 points) 5 paragraphs.:

• You have been hired by a prominent young businessman to design a dynamic website, specifically a dating website. He wants users to be able to create profiles, upload pictures, play games, and write messages on a forum. How will you store the information? How will you display the information? How will you create the game? Obviously you aren't coding anything here, you are just describing technologies and how they relate in a coherent whole. Discuss how the technologies will interact with each other. Pretend you are writing for a nearly computer illiterate individual.
  

Essay question for the Module Crew (10 points) 5 paragraphs:

• You have been hired by the Module Company to design their newest Programming module. How will you improve it? What will you add? What will you remove? Will you offer games? Tests? How will students be graded? Be creative and design an amazing module.

Essay question for all (10 points):

• This essay will be comparing open source software with the dominant operating system Microsoft Windows in the desktop market and the server market. First give a definition of open source software and proprietary software. Next compare the desktop market. Do any Linux distributions offer an advantage in the desktop market? Why is Microsoft the clear winner?
  
  Finally compare the server market. Give statistics as to which OS is dominant and explain why.
  

Answer must be posted on blog or Google Documents by 2:30pm on day of final May 29th for Second Period and May 24th for 5th period.

Final Exam Questions:

# Who edits Wikipedia?
# What is Web 2.0?
# What is a social network?
# Which corporation owns Myspace.com?
# How do Digg.com and Reddit.com work?
# Why do people visit Monster.com?
# What does FTP stand for?
# What does HTTP mean?
# What is the file extension for Flash media that is available to see online?
# What is the file extension for Microsoft Word files?
# What is the file extension for Microsoft Excel files?
# What is the difference between Excel and Word?
# What is the file extension for Microsoft PowerPoint?
# How is Google Documents different from Microsoft Word and Excel?
# What is Linux?
# How does Linux differ from Microsoft Windows?
# What is Adwords?
# How would one profit from Adsense?
# What are Internet cookies?
# What are packets?
# What route do packets take over the Internet?
# What is a 404 error on the web?
# What is 'e-commerce'?
# What is the difference between ebay and craigslist?
# What is SSL?
# What are the two major ways for home users to connect to the Internet via a high speed connection?
# What is a T-1 line?

Jobs

Many jobs posted here are specific to the technologies we worked with this year:

check it out.

Final exam review

It's important to be able to summarize difficult text. Wikipedia is an important site: probably more important for computers than for history. I've imagined there should be different wikipedias for different levels of reading ability and intelligence but that's probably an elitist consideration unworthy for the public schools. Nevertheless, for those of you who are still reading on, try reading the following text on wikipedia and summarizing it in your own words. Following that are some questions taken directly from the final.

1. http://en.wikipedia.org/wiki/Ethernet -what is ethernet? ...especially:
Dealing with multiple users

CSMA/CD shared medium Ethernet
2. http://en.wikipedia.org/wiki/Image:Ethernet_frame.svg know this!
3. Summarize what a web server is:
http://en.wikipedia.org/wiki/Web_server
4. What is the difference between:
Static vs. Dynamic content for websites.
5. Summarize the following:
http://en.wikipedia.org/wiki/IP_address
6. Summarize the following:
http://en.wikipedia.org/wiki/TCP/IP_model know them all!
7. Review the sql statements on www.SQLCOURSE.com
8. What does 127.0.0.1 do when entered into a browser?
9. What happens if you press the Control key and T at the same time while using Firefox 2.0?
10. What does the Control key + Z do?
11. Why would someone ping a remote server?
12. What is the Google Page Rank Algorithm? (be detailed!)
13. What is an algorithm?
14. How do PHP and MySQL work together?

This is too funny...

Post your reaction on your blog

First read this article.


Were you surprised free software runs so many corporations?
What six corporations set up the Open Invention Network?
What is happening with Second Life?
What agreement did Windows and Red Hat work out?
What is Microsoft's biggest nightmare, according to the article on page 3?
Does Microsoft have a case?

One hour and 20 minutes. One Digg break. One phone call.

Here's your example Syed:
http://davidcfreer.com/~David/project%20for%20aoit.html

It's not an A. But I wasn't an A student...

A tutorial for uploading files

Click here!

What I think about learning

I believe this web site summarizes my feelings about education and how to learn:
Learn by doing.

6 grade Assignment due Monday, May 14th

This is a retrospective assignment looking back at the work done this year.

First you will create a logo for "Introduction to Computers, Miami Killian Room 319" and create an HTML page with a brief introduction about yourself. Also on this page will links to the following pages (each page will be named the topic PLUS .html). On each page include at least one picture.

Javascript (named Javascript.html) :

* What is it used for?
* How would one design a "Rock, Paper, Scissor" game?
* Put two examples of Javascript code inside this page and explain what the code does.

Modules:

* Pick two modules you worked on this year (see me if you forget...how sad if that's the case).
* Write a summary of what the modules taught.
* What was the best thing about the modules in general?

Networking:

* What is a server?
* How does the Internet work?
* What is the TCP/IP model?
* What is ethernet?
* What is 802.11n?

PHP & MySQL:

* Why would someone need PHP?
* What is MySQL used for?
* Give a summary of http://www.sqlcourse.com Did you enjoy the course?
* Link to three pages using PHP. Bonus if you made the pages!

Flash:

* Upload your favorite two Flashes created this year and upload them to a remote server.
* Embed the two Flashes inside an HTML document (Flash.html).

Design:

* Link to your Google Sketch Up work.
* What do you think of Google Sketch Up?
* Did actually designing products and houses using Google Sketch Up give you a better feel for how designers work?
* What is Blender? Are there any other open source 3-d design products out there?

Your passwords for the class server are here.

Posted grades online

I added the grades for the model of the hotel and the cell phone. When you finish yours make sure to leave the link on your blog (IN THE FORM OF A LINK) and then let me know.

Put your sketch up online

After you upload your sketch up copy and paste your link here.

Upload your sketch up by using "File"-> "3d Warehouse" -> Share model.

Then click on Link to this model!

Leave your comment here.

Is this fair? Why do you think this is?

Design Competition

All computer students are to design a hotel for downtown Miami and a new design for a cell phone! Upload your work when you are finished using 'File'-> '3d Warehouse'-> Share. Put a link on your blog when finished. This will be worth a grade.

If you have time after you finish you can continue working on your PHP, Flash, HTML and MySQL.

Tomorrow we will have a contest for the best hotel and best new cell phone in each class!

Code to insert using PHP

http://www.davidcfreer.com/~David/inserting.txt

Inserting PHP!

Log in with PHP!

Try it out here:

http://killianstudent1.phpnet.us/login.html

On the log in page there is a link with important code.

The password is 'lovePHP'.

Here is a link to a tutorial with PHP and MySQL:

http://www.tizag.com/mysqlTutorial/mysqltables.php


Remember we are using mysqli connections. Always use Google for problems and, of course, ask me.
Here is the code:
http://www.davidcfreer.com/~David/login.txt

The future...

The future is now...

Leave a link here...

To your google sketchup work!

Two person groups...

What is expected for the second dynamic web pages, HTML, Flash, and business plan:

The first project was done about a car dealership. These projects will be for scooter stores, Pac Sun, a watch store, a video game store, a flower shop, and a web hosting company.

First you must have three HTML pages minimum. You may choose a template online but you must customize it for your own business. Honestly the simplicity of doing it without a template is quite appealing to me.

The database needs two tables (Inventory and Employee) with at least 5 pieces of information in each.

Now on to the dynamic aspect of your web pages! You need a link to show ALL the Inventory table and ALL of the Employee table much like the previous assignment with Braman Motors. Additionally now you need a dynamic drop-down box with the name of the Employee or the item in inventory. This way users can quickly find out information about the item specifically without having to wade through superfluous data! Also there needs to be a way to add new records into the table, a way to update data, and a way to delete unnecessary information.

A new addition is that you need to add javascript that will add to the functionality of your page. There is a great deal of code out there which is freely available! Google is your friend!

Fun quiz

I was sad I missed any...
but I didn't use Google for any questions!

Mingle2.com - Free Online Dating

Making a dynamic drop-down list

More code:
Dynamically creating a drop-down list using a database!

Here it is in action:
Pretty cool.

Is there a market for this?

What do you think of this idea?

Check out Masterful!

This is awesome work!

Passing variables using either text boxes or drop down...

Here's the example:
http://killianstudent1.phpnet.us/Plants.htm

Here's the code:
http://www.davidcfreer.com/~David/code%20to%20make%20php%20variables%20pass.txt

Inserting information

http://www.freewebmasterhelp.com/tutorials/phpmysql/4

Look at how expensive!!

FREE iPod Shuffle Offer: MySQL for Database Administrators Training Course in Ft. Lauderdale, FL
(June 25 - 29, 2007)

Questions to ask yourself:

• Is your MySQL database secure? Do your users have the correct privileges and access rights?
• Is your MySQL database operating at optimal efficiency? Do you want to increase the performance of your database and make sure it scales?
• Do you want to save time using features like Stored Procedures, Triggers and Views?

..then attending the June 25-29th MySQL 5.0 for Database Administrators is exactly what you need! ($2495) Register by Wednesday April 22th, and receive a FREE iPod Shuffle!

An Authorized MySQL instructor will teach you how to properly install MySQL, create and execute Backup Strategies, secure user privileges, create secure Stored Procedures & Triggers to update and access data, set resource limitations, access controls, and more! More class details can be found at: http://www.mysql.com/training/workshops/mysql_dba.html

Deadline for Registration and to qualify for the iPod Shuffle is Monday, April 23rd

To register for the workshop, simply reply to this email, aalwin@mysql.com,
or call me at 303-990-1382.

We get great feedback from those that attend, so don’t miss out on this great training class with excellent savings - it is filling up fast. Also, join thousands of organizations that cost-effectively scaled-out their infrastructure with MySQL.

Sincerely,

Alexandra Alwin
US Training Representative
MySQL Inc.
Office: 303.990.1382
aalwin@mysql.com

New Groups

JP & Michael - Sports shop
Jorge & Luis- Video game store
Yogan & Kalpesh- Flower shop
Derek & Ian- Hosting company

We will add much more to this
project and it will be spectacular!

Leave a comment here

Leave a comment with your main Braman business page here. On the page you need to have links to the three tables with all the data displayed. Have a link to the letter to Mr. Braman and make sure the Flash ad is online and is easy to access.

Next we will select new groups and new businesses to work with!

Code to insert car tables

$db = new mysqli('sql4.phpnet.us', 'pn_461233', 'student1','pn_461233_test');

/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

$Name = 'Mahogany';
$Size = '25g';
$Cost = 90;
$Quantity = 12;

//if ($mysqli->query("INSERT into myCity (Name) VALUES ('$city')")) {
// printf("%d Row inserted.\n", $mysqli->affected_rows);

if (mysqli_query($db, "INSERT into plants (Name, Size, Cost, Quantity) VALUES ('Mahogony', 'Size', 23, 22)")) {
printf("%d Row inserted.\n", mysqli_affected_rows($db));
}

$result = mysqli_query($db, 'SELECT * FROM plants');
while ($row = mysqli_fetch_object($result)) {
printf(
htmlspecialchars($row->Name)
);
}
mysqli_close($db);

Differences with computer science

http://compsci.ca/blog/6-degrees-of-computer-science/

The Birth of Linux

Reviews for blog

On your blog, I want you to evaluate the following ideas:

• What do you think of the idea behind: http://www.meetwithapproval.com/?
• Write a post of at least 100 words. Will this site get very popular?
  
• Read this about competition for Wikipedia.
• Write a post examining the pros and cons of this new idea. Also answer the following question: If you were a teacher, would you allow students to use wikipedia as a reference source?

Due today.

What Yahoo is looking for...

Is the same as anyone is looking for:
http://blog.pipes.yahoo.com/pipes-is-hiring#backend

People who are not afraid of problems. People who can solve things and people who know how to think. This class will help you get practice thinking but it won't do anything for you if you fight the process. You have to be willing to actually WRITE the review.

cool site

http://upcoming.yahoo.com/

Please register for the forum...

I finally got the phpBB forum up and running! Please register here:

www.davidcfreer.com

I don't have a way to email passwords (Bellsouth disables port 25), so there will be an error message...but do not despair. Simply go to Login and use the user name and password you just created. Extra credit if you leave a message in one of the forums I created.

Leave your comment here.

250 word review of desktoptwo.com due April 20th 2007 @ 10pm. Leave your comment here.

You may compare it to goowy.com. Do you like the site? Is it useful? What's good? What's bad?

Web OS Assignment

Check this out:
http://desktoptwo.com/

• Write a 250 word review of the service on your blog for a grade.
  
• This is a great overview of the hacking associated with Myspace.com. Check out his hypocrisy at the end of the article.
• Check out the PHP scripts on this page: http://www.hotscripts.com/PHP/Scripts_and_Programs/index.html
• Look at what CSS can do:

Peer-to-peer is quite slow!

Great video! He invented the web.

http://www.brainbell.com/tutorials/php/Retrieving_Results_Of_A_Query_To_MySQL.htm

Try this...

Try typing killiancomputers into Google. Cool.

Here's the PHP code for mysqli

This works:

if ($db = @mysqli_connect('sql4.phpnet.us', 'pn_461233',
'student1')) {
mysqli_select_db($db, 'pn_461233_test');
$result = mysqli_query($db, 'SELECT * FROM
table1');
while ($row = mysqli_fetch_object($result)) {
printf(
htmlspecialchars($row->name)
);
}
mysqli_close($db);
} else {
echo "Connection failed";
}

Google (meaning you) are your best teacher. Don't wait for me to find mysqli connection strings. Oh well.

Newer connection string

This connection string worked for me:

/* Connect to a MySQL server */
$link = mysqli_connect(
'sql4.phpnet.us', /* The host to connect to */
'pn_461233', /* The user to connect as */
'student1', /* The password to use */
'pn_461233_test'); /* The default database to query */

if (!$link) {
printf("Can't connect to MySQL Server. Errorcode: %s\n", mysqli_connect_error());
exit;
}

/* Send a query to the server */
if ($result = mysqli_query($link, 'SELECT * FROM table1')) {

print("Very large cities are:\n");

/* Fetch the results of the query */
while( $row = mysqli_fetch_assoc($result) ){
printf("%s (%s)\n", $row['name']);
}

/* Destroy the result set and free the memory used for it */
mysqli_free_result($result);
}

/* Close the connection */
mysqli_close($link);

No more mysql_...we are in 2007 now!

Learn for the sake of learning!

If you don't learn to love learning and exploring....

Don't ever let a boss talk to you like this:

BEAVER COMPUTER!

http://www.engadget.com/2007/04/13/compubeaver-case-mod-the-pc-stuffed-beaver/

Connect to a database

http://aoitweb.blogspot.com/2006/02/homework-assignment.html

Free software and how much the paid alternative costs

Really interesting.

If anyone wants to try video game programming with C++ over the break, click here.

You'll be surpassing me...I've never done C++ video game programming! Let me know how it goes.

http://sqlcourse.com/select.html

SQL Course

SQL Course

Code for area

$iloveshapes = $_POST['shape'];
echo $iloveshapes;
if($iloveshapes=="circle")
{
//formula for area of square
echo (($_POST['length']*$_POST['length'])*3.1416);

}
else
{
//we need the radius of the circle
echo "Does this work?";
echo $_POST['length']* $_POST['length'];
//pi*r to the second power

Assignment

http://www.davidcfreer.com/~David/shapes.htm

Find the perimeter or circumference of square or circle.

When finished post a link to your blog.

$name = $_GET["name"];
$pass = $_GET["pass"];

if($name == "AOIT")
if($pass == "ilovecomputers")
{
echo "What took you so long?";
echo "
";
echo "
HREF='http://www.google.com'>google.com";
}
else
echo "Who do you think you are?";

Today's assignment

Students are to create a PHP ordering page. On the first page students will offer a drop down box with three items: iPods, Treos, and Laptops. Students will have the quantity entered next to the selection. A PHP page entitled "process.php" will receive the information and repeat it to the customer. Also there will be a picture of the item selected.

http://www.davidcfreer.com/~David/Order.htm

Sign up for this message board.

http://www.davidcfreer.com/~David/

First PHP Program

Ask a user to enter their name and password. The welcome screen will be titled Welcome.html. It must include a picture of a flower. The PHP page receiving the username and password must be saved as usernameandpassword.php. If the username or password is wrong, the user will get the message "Who do you think you are??? We are too smart for you." If the username is "AOIT" and the password is "ilovecomputers" (without the quotes) the message will be, "What took you so long?" and a link to google.com.

PHP Programming

Your program will ask a user for a percentage they received on a recent grade. Then you will calculate what their letter grade is and return it to them.

Input: Percentage as an integer 0-100.
Output: Either A, B, C, D, F.

Your processing will consist of an if statement and following else if statements.

Today's assignment

You are to create a PHP page with your name as a variable and your age as the value. Output the PHP variable using echo. Put this on your web host and your URL on your blog of the file.

• First create a PHP variable (use $).
• Next give the variable a value (use =).
• Next you use echo $variable name.

Post online and put URL on blog.

No more Internet at night for you!

http://news.bbc.co.uk/2/hi/south_asia/6459295.stm

You must have a hosting plan with PHP by tomorrow..

Tomorrow is a grade for having a PHP hosting plan.

Looking ahead

1. Of all the things we've done this year, which are the most useful and important up to this point?
2. What do you want to learn about computers?
   

If you don't have a hosting plan with PHP...

Sign up for this site IMMEDIATELY.

Here are lots more to try.

Read this article

Read this article. Write a summary and write your point of view on your blog.

Last assignment of the third nine weeks...

1. A picture of a future job using Paint. See my example below. Yours will look much better.
2. A Flash movie of the last movie you saw.

There is a time constraint to this assignment. Work quickly but do your best work!

Site to review about PHP.

Good site for Game Programming

Found it through SU.

Cool site.

Funny stumble

The way to write a review...

20 must have extensions for Firefox.

Terms to define with Google Documents

Web 2.0, hosting, Adsense, Adwords, FTP, templates, Internet backbone, Wifi, VOIP, blog, RSS.

• You may not copy and paste.
• Include URLs of where you found the information.
• Put the definitions in your own words!!
• Minimum of three sentences for each term.
  

Amazing what Google can come up with!

You won't believe it!

Sign up for hosting

Even if you have an email address, you need to sign up for hosting.

Here are five possible free companies with everything we will need:

http://www.ifastnet.com/

http://www.hostultra.com/

http://prophp.org/

http://www.0moola.com/

http://www.orgfree.com

Pick one or pick all five, it doesn't matter which one. But it is IMPERATIVE you get signed up with a hosting plan. Some people like to complain about free hosting? Ask your parents to sponsor you and go to http://1and1.com. That's who I use for my hosting needs!

Pigs

Only pigs would piggyback?

Most likely they don't know HOW to secure their network...it's still mooching to piggyback.

FireFTP is awesome!

Click here for FireFTP.

OSWD

First get a hosting account.

Second get a web template.

Third, make a personal class web page. Post all your Flash files, javascript, Word, Excel, Access online.

Showing the brain = the CPU

Is what gave this project the A!

5th period leave a comment

What is one way...

Schools can be more focused on learning?

How I see YouTube sometimes....

People make silly comments.

Look at how many people have played "Cool Balls"

Click here.

Thanks to the webmaster Syed.

2nd period has an extension

Because of all the people helping set up computers and the size limitations on 50megs.com. I will collect the PowerPoint presentations through the NETWORK in class. We can view all the PowerPoints and Flash assignments in class on Monday.

Perhaps search will be limited...

What a fascinating article!

3d printers for google earth

Neato.

Do you have a facebook?

Kinda spooky.

Due Dates

Deadlines really do focus attention. So the questions are due before midnight on Friday (using Google Documents and adding me as a collaborator).

The PowerPoint or Flash is to be put online before midnight also. Send me a link to david.freer@gmail.com.

Photoshop online

Look at this article.

Good site on CPU design

Read some of the considerations.

Assignment due Friday

New Assignment Due Tomorrow:

You are going to make a Flash animation or a PowerPoint presentation to explain to a 4th grader what a CPU is and how it interacts with RAM and a hard drive.

Minimum 12 slides or 40 seconds of Flash animation.

After you finish you will place your Flash online at http://50megs.com

You will upload it with your web browser and place a link to your .swf file on your blog.

DF