OCVTS 2006 - Computer Science

Marking Period 3

Click for Instructions

Click on the date to open the details.
Click date again to close the details.

Random (Mostly) Web Design Web Sites:

Day

Date

Discussion

01/29/07

Monday - SNOW EMERGENCY - SCHOOL CLOSED

Classroom Discussion -
1. School Rules Review - a Microsoft PowerPoint Presentation by Mr. Clarke
2. Math - Banking Services - from practicalMoneySkills.com
3. Microsoft Excel - Tutorial - fgcu.edu
  - Spreadsheet Basics
  - Modifying A Worksheet
  - Formulas and Functions
  - Charts
  - Keyboard Shortcuts
Lab Assignment -
1. Microsoft Excel I - Create a spreadsheet to determine what price car you can afford. Some reference pages from Internet 4 Classrooms Excel
  1. Start Excel, open a new, blank Microsoft Excel spreadsheet, save the spreadsheet as "dreamCar.xls" to your "My Documents" folder
  2. Cells across the top row: Add the text: "Car Model", "Sale Price", "Down Payment", "Amount Financed", "Years", "Rate", "3-Year Payment", "Years", "Rate", "4-Year Payment", "Years", "Rate", "5-Year Payment"
  3. Highlight the top row and format the cells for alignment wrap text and horizontal center
  4. Cell A2: Put "Ford Focus" (the name of our first "dream car")
  5. Cell B2: Put in the sale price of $13635.00 (MSRP from Kelly Blue Book)
  6. Cell C2: Put in a down payment of $2500.00 (to lower the financed amount)
  7. Cell D2: Put in a formula that will calculate the difference between the Sale Price (cell B2) and Down Payment (cell C2) ("=B2-C2")
  8. Cell E2: Put in the number "3"
  9. Cell H2: Put in the number "4"
  10. Cell K2: Put in the number "5" (years)
  11. Cells F2, I2, & L2: Format the interest rates as percentage
  12. Cells F2, I2, & L2: Put in interest Rates of 3 years 5.00%, 4 years 5.25%, and 5 years 5.50% (From MONOC Credit Union)
  13. Cell G2: Put in the payment formula "=PMT(F2/12,E2*12,-$D2)"
  14. Copy cell G2 into cell J2 and cell M2 (Monthly payment)
  15. Your payments should be:
    - Cell G2 = $333.73
    - Cell J2 = $257.69
    - Cell M2 = $212.69
  16. Did you get these numbers? (If not, fix it before you continue)
  17. Is this car affordable?
  18. Cell A3: Search the internet for a car of your choosing and put in the name
  19. Cell B3: Search the internet for the MSRP and put in the sale price
  20. Cells E3, G3, & I3: Search the internet for MONOC Credit Union automobile 3, 4, and 5 year loan rates and place the appropriate rates (MONOC Credit Union)
  21. Copy cells E2 through M2 into cells E3 through M3.
  22. What are your payments for the car you want to purchase?
  23. Repeat steps m through q for a total of 5 cars.
  24. Highlight all cells and "Data", "Sort" by the 3 year payment column. Be sure that "Ascending" and "Header Row" are selected before you click "Okay" (places your cheapest car payment at the top)
  25. Use "File", "Print Preview" to make sure your document looks good; if not, make it look good
    (Here's what mine looks like)
  26. Do you need to make it "Landscape" in order to fit everything on one page? "File", "Page Setup"
  27. Save the document
  28. Put your name in one of the cells, print it, hand it in
  29. Exit Excel
2. Microsoft Excel II - Modify your existing "dreamCar.xls" spreadsheet to add a chart as a visual effect. Some reference pages from Florida Gulf Coast University
  
  Start Excel, open your Microsoft Excel spreadsheet "carPayments.xls" and Save As "carPaymentsChart.xls" to your "My Documents" folder
  Use the Florida Gulf Coast Universitypage as a reference to create a chart of how much each car would cost for each loan term
  Highlight the "Car Model", "3-Year Payment","4-Year Payment", "5-Year Payment" columns (Column header and 5 rows of data) (highlight the first column then press and hold [CTRL] to highlight the other columns also but not the data in between)
  Select "Insert", "Chart" or click the "Chart Wizard" button
  Under "Chart Wizard, Step 1 - Chart Type", I selected "Chart Type Column" and "Chart Sub-Type 3-D Column" and click "Next"
  Under "Chart Wizard, Step 2 - Chart Source Data", I left the "Data Range" as highlighted and selected "Series In Rows" and click "Next"
  Under "Chart Wizard, Step 3 - Chart Options", I experimented with putting data in the boxes but realized that it takes up lots of spaces so I left them all blank and click "Next"
  Under "Chart Wizard, Step 4 - Chart Location", I selected "As Object In" my current worksheet and click "Next"
  When the chart displays, move it around and resize it (always use the corner resizing "handles" in order to maintain proper proportionality)
  (Here's what mine looks like)
  Use "File", "Print Preview" to make sure your document looks good and will print everything on 1 page; if not, make it look good
  Save the document
  Make sure your name is legible, print it, hand it in
  Exit Excel
3. Work any unfinished Macromedia Flash labs

01/30/07

Tuesday - Science & Microsoft Access

Classroom Discussion -
1. Safety Review - a Microsoft PowerPoint Presentation by Mr. Clarke
2. Eye Safety - a Microsoft PowerPoint Presentation from ufl.edu
3. Science - How Gasoline Works - howStuffWorks.com
4. Science - How Ethanol Works - howStuffWorks.com
5. Microsoft Access - Tutorial - fgcu.edu:
  - Getting Started
  - Screen Layouts
  - Creating Tables using the Wizard
  - Datasheet Records
Lab Assignment -
1. Create a Microsoft Access database "petStore": a relational database of inventory, customers, & sales:
  - Create the database
  - Use wizard to add a table "employees" with fields & data types:
    - employeeID, autonumber, key field
    - firstName, text
    - lastName, text
    - address, text
    - city, text
    - state, text, 2 characters
    - zip, text, choose an input mask
    - phone, text, choose an input mask
    - socialSecurityNumber, text, choose an input mask
    - hireDate, date, choose an input mask
    - salary, currency
  - Enter some phony data
2. Work any unfinished Macromedia Flash labs

01/31/07

Wednesday - Career & Microsoft Access

Classroom Discussion -
1. Cover Letter Review - a Microsoft PowerPoint Presentation by Mr. Clarke
2. Cover Letter Do's & Don'ts - quintCareers.com
3. Microsoft Access - Tutorial - fgcu.edu
  - Creating Tables using Design
  - Creating Tables using by Entering Data
  - Sorting and Filtering
  - Table Relationships
Lab Assignment -
1. Modify the Microsoft Access database "petStore": a relational database of inventory, customers, & sales:
  - Use design to add a table "customers" with fields & data types:
    - customerID, autonumber, key field
    - firstName, text
    - lastName, text
    - address, text
    - city, text
    - state, text, 2 characters
    - zip, text, choose an input mask
    - phone, text, choose an input mask
    - lastPurchaseDate, date, choose an input mask
  - Enter some phony data
  - Use data entry to add a table "salesHeader" with fields & data types:
    - salesID, autonumber, key field
    - employeeID, number
    - customerID, number
    - salesDate, date, choose an input mask
  - Enter some phony data
  - Practice sorting & filtering
  - Create a relationship between tables "employees" & "customers" using the table "salesHeader" as a connector
2. Work any unfinished Macromedia Flash labs

02/01/07

Thursday - English & Microsoft Word

Classroom Discussion -
1. English - Typing a Cover Letter with Ms. Gerick
2. Microsoft Word - Tutorial - fgcu.edu
  - Getting Started
  - Working With Files
  - Working With Text
  - Spelling and Grammar
  - Page Formatting
  - Keyboard shortcuts
Lab Assignment -
1. Create a Microsoft Word document "coverLetter" to respond to an entry-level web design job advertisement:
  - Click Here for the job advertisement
2. Work any unfinished Macromedia Flash labs

02/02/07

Friday - SkillsUSA & Microsoft Access

Classroom Discussion -
1. SkillsUSA -
2. Microsoft Access - Tutorial - fgcu.edu
  - Forms
  - Queries
  - Reports
  - Keyboard Shortcuts
Lab Assignment -
1. Modify the Microsoft Access database "petStore": a relational database of inventory, customers, & sales:
  - Use data entry to add a table "products" with fields & data types:
    - productID, autonumber, key field
    - name, text
    - quantity, number
    - price, currency
  - Enter some phony data
  - Use data entry to add a table "salesDetail" with fields & data types:
    - salesDetailID, autonumber, key field
    - salesID, number
    - productID, number
    - quantity, number
    - price, currency
  - Enter some phony data
  - Create a form named "sales" to make it easier for an employee to enter a sale
  - Create a query to ask which employees sold to which customers
  - Create a report to show which employees sold to which customers
2. Work any unfinished Macromedia Flash labs

02/03/07

Saturday - SkillsUSA Competition & Demonstration - OCVTS Brick Center - Poster - 8am to 2pm

02/05/07

Monday - Vocabulary & SQL

Classroom Discussion -
1. Vocabulary:
  - Database Vocabulary - ncWiseOwl.org
  - Database Vocabulary - from ucps.k12.nc.us
  - SQL - from w3schools.com
2. SQL - Default - w3schools.com
3. SQL - Intro - w3schools.com
4. SQL - SELECT - w3schools.com
5. SQL - WHERE - w3schools.com
Lab Assignment -
1. Use Microsoft Access database "petStore" to practice SQL commands
2. Work any unfinished Macromedia Flash labs

02/06/07

Tuesday - Science & SQL

Classroom Discussion -
1. Science - Relational Database - howStuffWorks.com
2. SQL - INSERT - w3schools.com
3. SQL - UPDATE - w3schools.com
4. SQL - DELETE - w3schools.com
Lab Assignment -
1. Use Microsoft Access database "petStore" to practice SQL commands
2. Work any unfinished Macromedia Flash labs

02/07/07

Wednesday - Career & SQL

Classroom Discussion -
1. Career - Dynamic Cover Letters - a Microsoft PowerPoint Presentation by Mr. Clarke
2. SQL - ORDER BY - w3schools.com
3. SQL - AND and OR - w3schools.com
Lab Assignment -
1. Use Microsoft Access database "petStore" to practice SQL commands
2. Work any unfinished Macromedia Flash labs

02/08/07

Thursday - Math & SQL

Classroom Discussion -
1. Math - Boolean Logic with Ms. Verde
2. SQL - IN - w3schools.com
3. SQL - BETWEEN - w3schools.com
Lab Assignment -
1. Use Microsoft Access database "petStore" to practice SQL commands
2. Work any unfinished Macromedia Flash labs

02/08/07

Thursday - Open House - All OCVTS Centers - Poster - 7pm to 8:30pm

02/09/07

Friday - SkillsUSA & SQL

Classroom Discussion -
1. Results of Saturday's web design completition & last evening's open house
2. SQL Review
Lab Assignment -
1. SQL Practice
2. SQL Quiz 1 - Print for your records (in case the database fails)

02/12/07

Monday - Math & SQL & JavaScript

Classroom Discussion -

Math - practicalMoneySkills.com - Banking Services
SQL - Functions - w3schools.com
SQL - SQLCourse.com - anothertutorial
SQL - SQLCourse2.com - anothertutorial

HTML & JavaScript & Database Tables: In order to use JavaScript on an HTML web page, you need to set up a couple of connections:

An active data object database connection
The exact path to your database file (skip this if the file is in the same folder)
The exact tablename
A connect string
Open the connection to the database
A syntactically correct SQL statement
Execute the SQL statement
An active data object database result set
Open the result set that the SQL statement returned
Use JavaScript to display the SQL fields as HTML

For example:

<script type="text/javascript">
<!--
var objConnect = new ActiveXObject("ADODB.Connection");	// database object connection
var objRecord = new ActiveXObject("ADODB.Recordset");	// result set
var provider = "Provider=Microsoft.Jet.OLEDB.4.0;";		// provider
var dataSource = "Data Source=i:\\access\\";			// data source
var fileName = "petStore.mdb;";					// file name
var tableName = "customers";					// table name
var recordCount = 0;						// how many records in result set
var fieldCount = 0;							// how many fields in result set
var fieldName = "";							// name of field
var sql = "SELECT * FROM " + tableName + ";";		// sql statement
//alert(sql);
objConnect.open (provider + dataSource + fileName);		// open the database object connection
objConnect.execute(sql);						// execute the SQL statement
objRecord.Open(sql,objConnect)					// open the result set
fieldCount = objRecord.Fields.count;				// count how many fields
document.write("<table border='1'>");				// draw a table for the record rows & field columns
document.write("<tr><th colspan='" + fieldCount + "'>File Name: <i>" + fileName + "</i></th></tr>");
document.write("<tr><th colspan='" + fieldCount + "'>Table Name: <i>" + tableName + "</i></th></tr>");
document.write("<tr>");						// row for field name column header
for(i=0;i<fieldCount;i++)						// loop for how many fields
{
	fieldName = objRecord.Fields(i).Name;			// get the field name
	document.write("<th>" + fieldName + "</th>");	// write the field name
}
document.write("</tr>");						// end the row for field name column header
while(!objRecord.EOF)						// loop for all records until end of file (eof)
{
	document.write("<tr>");					// start a new record row
	for(i=0;i<fieldCount;i++)					// loop for how many fields
	{
		document.write("<td>" + objRecord.Fields(i).Value + "</td>");
	}
	objRecord.MoveNext();					// move to the next record in the result set
	recordCount++;						// count how many records
	document.write("</tr>");					// end the record row
}
document.write("<tfoot>");					// footer for displaying how many records
document.write("<tr><th colspan='" + fieldCount + "'>Total of <i>" + recordCount + "</i> records found</th>");
document.write("<tr><th colspan='" + fieldCount + "' align='center'>End of File</th></tr>");
document.write("</tfoot>");
document.write("</table>");
-->
</script>

Lab Assignment -
1. On screen SQL practice
2. Create a web page "customersDisplay.htm" using the code from above
3. Create a web page "employeesDisplay.htm" modifying the code from above
4. Create a web page "productssDisplay.htm" modifying the code from above
5. Work any unfinished Macromedia Flash labs

02/13/07

Tuesday - Science & SQL & JavaScript

Classroom Discussion -

Science - Wages - howStuffWorks.com
SQL - GROUP BY - w3schools.com
SQL - SQLCourse.com - anothertutorial
SQL - SQLCourse2.com - anothertutorial
When using fields from more than 1 table, remember to:
- Specify which fields come from which tables
- SELECT employees.firstName,customers.lastName ...
- List all tables
- ... FROM employees, customers ...
- Match up ID fields
- ... WHERE employees.employeeID = salesHeader.employeeID ...
- Number of ID matches = (Number of tables - 1)

Some important code hints:

var tableName = "salesHeader,salesDetail,employees,customers,products";	// table names

var sql = "";	 // sql statement
sql += " SELECT *"; // append fields to sql statement
sql += " FROM " + tableName; // append table names to sql statement
sql += " WHERE salesHeader.salesID = salesDetail.salesID"; // append decision to sql statement
sql += " AND customers.customerID = salesHeader.customerID"; // append to decision sql statement
sql += " AND employees.employeeID = salesHeader.employeeID"; // append to decision sql statement
sql += " AND products.productID = salesDetail.productID;"; // append to decision sql statement

Lab Assignment -
1. On screen SQL practice
2. Create a web page "salesDisplay.htm" copying "customersDisplay.htm" & using the code from above
3. Modify web page "salesDisplay.htm" to display only the customer firstName & lastName, product name & quantity & price, & multiply the product quantity & price
4. Work any unfinished Macromedia Flash labs

02/14/07

Wednesday - Career & SQL & JavaScript

SNOW EMERGENCY == 90-minute Delayed Opening
Possible No Morning Home School Bussing
Check With Home School
Drive Carefully
Happy Valentine's Day

Classroom Discussion -
1. Career - Dynamic Cover Letters - a Microsoft PowerPoint Presentation by Mr. Clarke
2. Career - The Résumé - aciNet.org
3. SQL - aliases - w3schools.com
4. SQL - CREATE - w3schools.com
5. SQL - ALTER - w3schools.com
6. SQL - DROP - w3schools.com
7. SQL - SQLCourse.com - anothertutorial
8. SQL - SQLCourse2.com - anothertutorial
Lab Assignment -
1. On screen SQL practice - use SQL with the sqlSource database to answer these questions:
  - How many customers are there?
  - How many customers are from which states?
  - Which customers live in Arizona?
  - How many customers live in Arizona?
  - How many customers share the same last name?
  - What items did the customers in Arizona buy?
  - Which customers in which states bought flashlights or lanterns?
  - Which customers in which states bought items starting with the letter "S"?
  - What items did customers first names of "John" buy?
  - What items did customers last names of "Howell" buy?
  - What items did customers from Arizona buy?
  - Customers from which state bought the most items?
  - Customers from which state bought the most expensive (total price) items?
  - Which items sold the most often?
  - Which items cost the most?
  - Which items brought the most income to the company? ($ * # sold)
  - Which items were the most expensive to stock? ($ * # in stock)
  - Which customers first & last names start with the same initial?
2. Work any unfinished Macromedia Flash labs

02/15/07

Thursday - English & SQL & JavaScript

Classroom Discussion -
1. English - Résumé Samples - quintCareers.com
2. SQL - SQLCourse.com - anothertutorial
3. SQL - SQLCourse2.com - anothertutorial
Lab Assignment -
1. On screen SQL practice
2. Work any unfinished Macromedia Flash labs

02/16/05

Friday - OCVTS School Closed - Presidents' Day Holiday

02/19/05

Monday - OCVTS School Closed - Presidents' Day Holiday

02/20/07

Tuesday - Science & SQL Web & NJIT Web Design Contest

Class Discussion -

How Noise Canceling Headphones work
Review NJIT Web Design Contest Rules

Teams:

AM Team 1 Category 2	PM Team 4 Category 1	PM Team 6
Clancy, Carlos M Gery, Jonathan E Sackman, Justin VanArsdale, Andrew E	Brocklebank, Alex R Castrovinci, Michael Urena, Yashael Hopper, David M Kulpa, Kyle E	DeMattia, Nicolas Ponticiello, Aaron B Rodriguez, Oscar N Freudeman, Michael J Zelaya, Michael P
AM Team 2 Category 1	PM Team 5 Category 2	PM Team 7
Brennan, Matthew E O'Brien, Michael T Skrzypek, Grzegorz Wolff, Shana N	Cochran, Cody D Maytidu III, Richard M Miller, Brian H Polo, Kyle P Starmer, Christopher J	Freda, John E Hale, Joshua D Shanley, Gannon J Steimle, Michael D Wagner, Stephanie
AM Team 3
Ajam, George S Bradley, Kyle Buchko, Thomas A Fleming, James A

Lab Assignment -
1. NJIT Web Design Contest -- Category 1 -- Web Site Prototype -- planning:
  - Everyone will participate
  - Form into teams as listed above
  - Negotiate & select one team member to function as a team captain
  - The team captain's main function is to link all team member pages together
  - Re-read the contest rules
  - Brainstorm to discover ideas what to create a web site about
  - Arrive at a concensus
  - State your web site plan in a one-paragraph or one-page Word document to be handed-in & graded
  - The web site plan will have a team name, names of all team members, a title, a concept statement, & supporting statements
  - I must approve your web site plan before you advance to the next step
2. NJIT Web Design Contest -- Category 1 -- Web Site Prototype -- design:
  - Create & hand-in to be graded a storyboard sketch of the main pages in the web site
  - Each student should create & hand-in to be graded a storyboard sketch of his/her subject area -- try to keep them similar
  - I must approve your storyboards before you advance to the next step
3. NJIT Web Design Contest -- Category 1 -- Web Site Prototype -- content:
  - What colors & fonts will best support your choice of subjects?
  - What graphics, pictures, sound, video, animation, etc will you use?
  - Will you create your own images in Fireworks & animation in Flash?
  - Will you search the web for appropriate images & animation?
  - Any images or animation should be relevant & add to the subject
4. NJIT Web Design Contest -- Category 1 -- Web Site Prototype -- process:
  - Work will be saved onto "H:/toBeGraded/" in a folder named "NJIT-css##", use your own number
  - I will create & run a process to copy folders from each team member's "H:" drives to the team captain's
  - The process will be automatic -- it is up to each of you to make sure the correct data is on the "H:" drive
5. NJIT Web Design Contest -- Category 1 -- Web Site Prototype -- go:

02/21/07

Wednesday - Career & SQL Web & NJIT Web Design Contest

Classroom Discussion -
1. Career - The Résumé - aciNet.org
2. Review NJIT Web Design Contest Rules
Lab Assignment -
1. NJIT Web Design Contest -- Category 1 -- Web Site Prototype -- storyboard:
  - Create a storyboard showing the layout of your web site
  - Intro page with a short description of the site
  - Index page with links to the subchapters
  - Subchapters with 4-6 pages each
  - The subchapter index page will have a title, student's name & css##, & links to the other pages in the subchapter
  - If each subchapter is similar, draw only one subchapter out
  - If each subchapter is different, draw each out fully
2. NJIT Web Design Contest -- Category 1 -- Web Site Prototype -- continue:

02/22/07

Thursday - Math & SQL Web & NJIT Web Design Contest

Class Discussion -
1. A simple real-time comment page using JavaScript to read & write a text file:
  - Copy the HTML page "simpleComments.htm" on "Q:\webDesign"
  - Copy the file "text.txt" if you want existing comments
  - If you want to start fresh, don't copy the .txt file, the program will create a file if it doesn't exist
  - Open the HTML page to view the source code -- look to see how it works
2. Ms. Verde will be in to discuss Boolean math
3. Review NJIT Web Design Contest Rules
Lab Assignment -
1. NJIT Web Design Contest -- Category 1 -- Web Site Prototype -- files & folders:
  - Every team captain has a folder "H:\NJIT\"
  - Each team member has a folder "H:\NJIT-css##\"
  - Save all your work into a folder named "My Documents\NJIT-css##\"
  - Copy your work to your folder "H:\NJIT-css##\"
  - I will run a program each day to copy all of your work to the team captain's folder "H:\NJIT\"
2. NJIT Web Design Contest -- Category 1 -- Web Site Prototype -- continue:
  - Start gathering data
  - Start sketching out pages
  - Start filling in details
  - Start any Fireworks images or Flash movies

02/25/07

Friday - SkillsUSA & SQL Web & NJIT Web Design Contest

Classroom Discussion -
1. SkillsUSA - something from the blue PDP book
2. Review NJIT Web Design Contest Rules
Lab Assignment -
1. NJIT Web Design Contest -- Category 1 -- Web Site Prototype -- continue:

02/26/07

Monday - Math & NJIT Web Design Contest

Classroom Discussion -

Review the Computer Contract "Don't"

Math - Randomize images:

Pre-load images in the head section:

<script language="JavaScript">
<!--
img1 = new Image ();
img1.src = "tree.jpg";
// repeat for 9 images
</script>

Create a function to determine which image (1 - 9) will be displayed:

function slideshow() {
	num=num+1;
	if (num>=9) {num=1};
	document.mypic.src=eval("img"+num+".src");
	timer = setTimeout("slideshow()",2000);
}

Start the function in the body tag "onLoad":
```
<body onLoad="slideshow()"&gr;
```

To display random images, get a random number (1 - 9) instead:

function slideshow() {
	num = Math.round(Math.random() * (9 - 1) + 1);
	document.mypic.src=eval("img"+num+".src");
	timer = setTimeout("slideshow()",2000);
}

Review NJIT Web Design Contest Rules

Share folders on "Q:" share drive -- I've created an "NJIT" folder on the "Q:" drive with subfolders for you to share files related to the NJIT project:

folder name	css05	css10	css15	css23	css07	css01	css02
team members	css05	css10	css03	css21	css06	css01	css02
	css18	css17	css11	css23	css07	css09	css08
	css30	css32	css15	css24	css29	css12	css26
	css41	css39	css19	css31	css35	css16	css36
				css33	css40	css22	css49

Lab Assignment -
1. NJIT Web Design Contest -- Category 1 -- Web Site Prototype -- continue:

02/27/07

Tuesday - Science & NJIT Web Design Contest

Classroom Discussion -
1. Science - printers:
  - Science - How Printers Work - miMech.com
  - Science - Printers - webopedia.com
  - Science - Printer Types - jegsWorks.com
  - Science - How Laser Printers Work - howStuffWorks.com
  - Science - How Inkjet Printers Work - howStuffWorks.com
  - Science - How Thermal Printers Work - wikipedia.org
2. Review NJIT Web Design Contest Rules
Lab Assignment -
1. NJIT Web Design Contest -- Category 1 -- Web Site Prototype -- continue:

02/28/07

Wednesday - Career & NJIT Web Design Contest

Class Discussion -
1. Career - Problems with Résumés
  - Résumés from Hell - css.com
  - Top 5 Résumé Problems - setonHill.edu
  - Acronyms Cause Problems in Résumés - nbcActionNews.com
  - Résumé Bloopers - resumania.com
  - Solving Common Resume Problems - wetFeet.com
  - Problem Resumes - carAndDriver.com
2. Review NJIT Web Design Contest Rules
Lab Assignment -
1. NJIT Web Design Contest -- Category 1 -- Web Site Prototype -- continue:

03/01/07

Thursday - English & NJIT Web Design Contest

Class Discussion -
1. English - Ms. Gerick & us will type résumés into Microsoft Word
2. Review NJIT Web Design Contest Rules
3. We will begin reviewing the NJIT projects from a judge's viewpoint & offer positive critisms
4. Take the positives & revise your NJIT projects
Lab Assignment -
1. NJIT Web Design Contest -- Category 1 -- Web Site Prototype -- continue:

03/02/07

Friday - SkillsUSA & NJIT Web Design Contest Final Day

Class Discussion -
1. SkillsUSA - something from the blue PDP book
2. Review NJIT Web Design Contest Rules
3. We will continue reviewing the NJIT projects from a judge's viewpoint & offer positive critisms
4. Take the positives & revise your NJIT projects
Lab Assignment -
1. NJIT Web Design Contest -- Category 1 -- Web Site Prototype -- continue:

03/05/07

Monday - HSPA Testing for Juniors & Decimal to Binary Web Page & NJIT Programming Contest Practice

Classroom Discussion -
1. English - Computer Acronyms - acronyms.ch
Lab Assignment -
1. Useful Web Pages - Create a web page "binary.htm" that uses JavaScript to convert decimal numbers to binary numbers:
  - A decimal number variable is number data type but a binary number variable must be a character string data type
  - Add an input type text for input
  - Add an input type text for output
  - Add a command button for Decimal to Binary
  - Add a command button for Binary to Decimal
  - Write the JavaScript function for Decimal to Binary:
    - Create a variable for the input number
    - Create a variable for the output binary text string starting with a null string represented by two double quotes together with no space between
    - Make sure the input field is not empty
    - Parse the input field to a number variable
    - Make sure the input number is really a number
    - Add a 0 or 1 to the beginning of the output binary text string using the remainder of divide by 2 using the modulus
    - Change the number using math floor of divide by 2
    - Loop until the number is 0
    - Display the output binary text string
  - Test
  - Save to your "toBeGraded" folder

03/06/07

Tuesday - HSPA Testing for Juniors & Binary to Decimal Web Page & NJIT Programming Contest Practice

Classroom Discussion -
1. Science - How Acoustic Levitation Works - howStuffWorks.com
Lab Assignment -
1. Useful Web Pages - Modify web page "binary.htm" that uses JavaScript to convert binary numbers to decimal numbers:
  - A decimal number variable is number data type but a binary number variable must be a character string data type
  - Write the JavaScript function for Binary to Decimal:
    - Create a variable for the input binary text string
    - Create a variable for the output number starting at 0
    - Create a variable for powers of 2 starting at 1 (2¹)
    - Make sure the input field is not empty
    - Assign the input field to the input binary text string
    - Get the length of the input binary text string
    - Make sure every character in the input binary text string is only a 0 or 1
    - Move from right to left (least significant to most significant) through the input binary text string
    - Multiply each position in the input binary text string by a power of 2
    - Add the result to the output number variable
    - Increase the power of 2 variable multiply by 2
    - Loop until you've processed each position in the input binary text string
    - Display the output binary text string
  - Test
  - Save to your "toBeGraded" folder

03/07/07

Wednesday - HSPA Testing for Juniors & Decimal to Roman Web Page & NJIT Programming Contest Practice

Classroom Discussion -
1. Career - Irresistible Resume - jobBankUSA.com
Lab Assignment -
1. Useful Web Pages - Create a web page "roman.htm" that uses JavaScript to convert decimal numbers to Roman numbers:
  - A decimal number variable is number data type but a Roman number variable must be a character string data type
  - Add an input type text for input
  - Add an input type text for output
  - Add a command button for Decimal to Roman
  - Add a command button for Roman to Decimal
  - Write the JavaScript function for Decimal to Roman:
    - Create a variable num for the input number
    - Check & alert the user if the input field is blank
    - Check & alert the user if the input field is not a number
    - Create numeric variables for the Roman symbols M, D, C, L, X, V, I, give them all a starting value of zero
    - Create a text string variable ans for the answer, start at ""
    - Set M equal to math floor of num divided by 1000, set num equal to M times 1000
    - Set D equal to math floor of num divided by 500, set num equal to D times 500
    - Set C equal to math floor of num divided by 100, set num equal to C times 100
    - Set L equal to math floor of num divided by 50, set num equal to L times 50
    - Set X equal to math floor of num divided by 10, set num equal to X times 10
    - Set V equal to math floor of num divided by 5, set num equal to V times 5
    - Set I equal to math floor of num divided by 1, set num equal to I times 1
    - Append to ans the number of M's
    - If D is 1 and C is 4, append "CM" to ans, set D to 0, set C to 0
    - If D is 1, append "D" to ans, set D to 0
    - If C is 4, append "CL" to ans, set C to 0
    - Append to ans the number of C's
    - If I is 1 and X is 4, append "XC" to ans, set L to 0, set X to 0
    - If L is 1, append "L" to ans, set L to 0
    - If X is 4, append "XL" to ans, set X to 0
    - Append to ans the number of X's
    - If V is 1 and I is 4, append "IX" to ans, set V to 0, set I to 0
    - If V is 1, append "V" to ans, set V to 0
    - If I is 4, append "IV" to ans, set I to 0
    - Append to ans the number of I's
  - Test
  - Save to your "toBeGraded" folder

03/08/07

Thursday - HSPA Testing for Juniors & Roman to Decimal Web Page & NJIT Programming Contest Practice

Classroom Discussion -
1. Math - Ms. Verde - Ratios & Percentages
2. Ratios & Percentages - 321Know.com
Lab Assignment -
1. Useful Web Pages - Modify the web page "roman.htm" that uses JavaScript to convert decimal numbers to Roman numbers:
  - A decimal number variable is number data type but a Roman number variable must be a character string data type
  - Write the JavaScript function for Roman to Decimal:
    - Add a numeric variable "ans" for the answer, assign initial value of zero
    - Create a string variable "s" to hold one character
    - Create a string variable "s2" to hold another character
    - Check & alert the user if the input field is blank
    - Check & alert the user if the input field is not a Roman number, use a loop to check that only valid Roman number letters are used
    - Check each character, one at a time in a loop, & add the correct value to "ans"
    - Sometimes you have to check double characters:
      - if "s" is "M" add 1000 to "ans"
      - if "s" is "D" add 500 to "ans"
      - if "s" is "C" check the second character:
        if "s" is "M" add 900 to "ans" & increment the loop sentinel variable
        
        else if "s" is "D" add 400 to "ans" & increment the loop sentinel variable
        
        else add 100 to "ans"
      - if "s" is "L" add 50 to "ans"
      - if "s" is "X" check the second character:
        if "s" is "C" add 90 to "ans" & increment the loop sentinel variable
        
        else if "s" is "L" add 40 to "ans" & increment the loop sentinel variable
        
        else add 10 to "ans"
      - if "s" is "V" add 50 to "ans"
      - if "s" is "I" check the second character:
        if "s" is "X" add 90 to "ans" & increment the loop sentinel variable
        
        else if "s" is "V" add 40 to "ans" & increment the loop sentinel variable
        
        else add 1 to "ans"
  - Test
  - Save to your "toBeGraded" folder

03/09/07

Friday - Human Multitasking & Square Root Web Page

Classroom Discussion -
1. Human Multitasking - joelOnSoftware.com - Human Task Switches Considered Harmful
2. Human Multitasking - scienceDaily.com - Multitasking Is No Problem, But Double Talk Overwhelms Us
3. Human Multitasking - nasa.gov - Enabling Efficient Human Multi-Tasking
4. Human Multitasking - applesForHealth.com - Multitasking Creates Health Problems
5. Human Multitasking - typePad.com - Your Brain on Multitasking
6. SkillsUSA - PDP Starter Kit - Level 9 - Potential Volunteer Activities
Lab Assignment -
1. Create a web page "sqrt" that will figure the square root of a user-input number:
  - Use JavaScript & the "Guess, Divide, Average" route described on mathForum.org web page
  - Create & save the page
  - Add a form
  - Add a table
  - Add an input text field "input"
  - Add a go button "onClick='calc()'"
  - Add an output textarea "output"
  - Add instructions to tell the user what to do -- remember: users are
  - Label all text fields
  - Write the JavaScript function calc():
    - Add a number variable "y" parse the input field to integer
    - Add a number variable "x" for the guess, start the same as "y"
    - Add a string variable "ans"
    - Loop 7 times:
      - Guess at half the user number, set "x" equal to half of "y"
      - Divide "y" by "x"
      - Average "y" & "x"
      - Use this formula: "x = 0.5 * ((y / x) + x);"
      - Add the loop number & the current value of "x" to the "ans" output, be sure to CRLF using "\n"
  - The last value of "x" should be close to the real square root
  - Display "ans" to the output textarea
  - Test
  - Save to "toBeGraded"

03/11/07

Sunday - Job Fair

Place	Jenkinson’s, Pt. Pleasant Beach
Address	The Pavilion Restaurant on the boardwalk
Time	12 noon – 4pm
Available	part time & full time (starting weekends until summer)
Positions	cooks, servers, game operators, ride operators, fast food, arcade workers, beach maintenance, beach badge checkers, parking lot attendants, cashiers, etc.

03/12/07

Monday - Math & Membership Web Site

Classroom Discussion -
1. Math - practicalMoneySkills - about credit
2. Design a "membership" database:
  - What information is required?
  - How many tables?
  - What fields?
  - What data types?
Lab Assignment -
1. Create the "member" database using Microsoft Access, save in your access folder:
  - Create the database
  - Create a table "member"
  - Add fields for:
    - key, autonumber, set as primary key
    - id, text, for the userid
    - pw, text, for a password
    - fName, text, for the user first name
    - lName, text, for the user last name
    - eMail, text, for the user e-mail address
  - Add about 5 or so records of data
  - Export to "toBeGraded" as a comma-separated-variable file named "member-css##.txt" (use your css number)
  - I will merge these all together into one huge file with many records & we'll all have the same data to work with
2. Create a "memberDisplay.htm" web page to display all existing members:
  - Copy the "customerDisplay.htm", rename to "memberDisplay.htm"
  - Edit the page & change the filename & table name
  - Test it
3. Work on any unfinished Flash labs

03/13/07

Tuesday - Science & Membership Web Site

Classroom Discussion -
1. Science - howStuffWorks.com - 300
2. Review - webPagesThatSuck.com - learn good web design by looking at bad web design
3. Review - NJIT teaching web sites from two weeks ago
Lab Assignment -
1. Fix a broken web site
2. Work on any unfinished Flash labs

03/14/07

Wednesday - NJIT Web Design Competition
Substitute Teacher & WebQuest

Classroom Discussion -
1. Career - ACM.org - The Top 10 Reasons to Major in Computing
Lab Assignment -
1. Create either a web site or a Microsoft PowerPoint presentation about "Magnetic Levitation" & it's possible uses:
  - Some internet resources:
    - ic.sunysb.edu - MagLev Moving Into the Future
    - glencoe.com - Mag Lev Trains: Floating Locomotives
    - virtualScienceFair.org - Magnetically Levitated Train
    - google.com - 495 Google Results for maglev webquest
  - Test frequently
  - Save to your "H:/toBeGraded" folder
    - "maglev.htm" or
    - "maglev.ppt"
2. Microsoft - PowerPoint tutorial - Florida Gulf Coast University
3. Work on any unfinished Flash labs

03/15/07

Thursday - English & Membership Web Site

Classroom Discussion -
1. English - Job interview discussion with Ms. Gerick in the conference room
2. Review of yesterday's web design competition - develop comments & suggestions for next year
3. Demonstration of member pages so far:
  - index page
  - display all members' data
  - get id & pw for one member
  - display one member's data
Lab Assignment -
1. Be sure your version of "member.txt" is copied out to your "toBeGraded" folder for me to merge into the master database
2. Work on any unfinished Flash labs

03/16/07

Friday - SkillsUSA & Membership Web Site

Classroom Discussion -

SkillsUSA - PDP Starter Kit - Level 10 - Professional Development Traits
Review of member database:
- key autonumber keyfield the computer updates this field, not the programmer, not the user
- id text holds the user id name
- pw text holds the user password
- fName text holds the user furst name
- lName text holds the user last name
- eMail text holds the user e-mail address

Review of using JavaScript to connect to a database:

var objConnect = new ActiveXObject("ADODB.Connection");	// database object connection
var objRecord = new ActiveXObject("ADODB.Recordset");	// result set
var provider = "Provider=Microsoft.Jet.OLEDB.4.0;";		// provider
var dataSource = "Data Source=" + pathName3;			// data source
var fileName = "member.mdb;";					// file name
var tableName = "member";						// table name
recordCount = 0;							// how many records in result set
var fieldCount = 0;							// how many fields in result set
var fieldName = "";							// name of field
var sql = "SELECT * FROM " + tableName + ";";		// sql statement
alert(sql);								// view the sql statement during testing, remove or comment out for production
objConnect.open (provider + dataSource + fileName);		// open the database object connection
objConnect.execute(sql);						// execute the SQL statement
objRecord.Open(sql,objConnect)					// open the result set
fieldCount = objRecord.Fields.count;				// count how many fields

Review of the main SQL commands:
- SELECT fieldNames FROM tableNames;
- SELECT fieldNames FROM tableNames WHERE fieldName LIKE value;
- INSERT INTO tableName (fieldName1, fieldName2, ...) VALUES (value1, value2, ...);
- UPDATE tableName SET fieldName = newValue WHERE keyFieldName = keyValue;
- DELETE FROM tableName WHERE keyFieldName = keyValue;
- Resources - sqlCourse.com & w3schools.com/sql/ - for syntax & examples
Copy my member pages ("htm" "css" "js" "mdb") files from "Q:/access/member/" folder to your "member" folder

Lab Assignment -
1. Create new pages to add/insert a new member:
  - Create "memberInsert.htm" from "memberSearch.htm"
  - Create "memberInsert2.htm" from "memberSearch2.htm"
  - Design page 1 to allow the user to enter id, pw, fName, lName, eMail data
  - Check that all fields are filled before you submit the data to page 2
  - Design page 2 to insert into the database
  - Don't worry about checking for an existing member id, we'll do that next week
  - Test by adding a couple of users
  - Copy to your toBeGraded folder
2. Work on any unfinished Flash labs

03/19/07

Monday - Computer Vocabulary & Membership Web Site & Student Visitation Week & Morning Announcements

Classroom Discussion -
1. Computer Vocabulary - tds.net - Humorous Computer Acronyms
2. Computer Help - pChell.com - tips, hints, and troubleshooting remedies
3. Member search, find out if a user exists:
  - Open the database connection
  - Create a variable SQL & search for userid & password
  - Execute the connection SQL
  - Execute the record SQL
  - If the record is at end of file, it means the record does not exist, tell the user:
```
if(objRecord.EOF) {
	document.write("UserID and/or Password not found<br>");
	document.write("Click here to <a href='memberInsert.htm'>Create New User</a>");
}
```
  - Otherwise, the record exists, display it:
```
else {
...
}
```
Lab Assignment -
1. Modify the member search 2 page so that:
  - Display a "member not found" message
  - Display a link to the search member page to login again
  - Display a link to the create member page to add a new member
  - Test thoroughly
  - Copy to "toBeGraded"
2. Work on any unfinished Flash labs

03/20/07

Tuesday - Science & Membership Web Site & Student Visitation Week & Morning Announcements

Classroom Discussion -

Science - howStuffWorks.com - Advergaming

Member insert, find out if a user exists:

Open the database connection
Create a variable SQL & search for userid
Execute the connection SQL
Execute the record SQL

If the record is NOT at end of file, it means a record already exists, tell the user:

if(!objRecord.EOF) {
	document.write("UserID already exists<br>");
	document.write("Click here to <a href='memberSearch.htm'>Login with This UserID</a><br>");
	document.write("Click here to <a href='memberInsert.htm'>Pick Another UserID</a><br>");
}

Otherwise, the record does NOT exist, go ahead & insert the new user:
```
else {
...
}
```

Compare the lines above & below - which set makes more sense & why???

if(!objRecord.EOF) {
	document.write("UserID already exists<br>");
	document.write("Click here to <a href='memberSearch.htm'>Login with This UserID</a><br>");
	var filler = pathName3 + "memberInsert.htm";
	document.write("Click here to <a onClick='history.back()' style='text-decoration:underline;cursor:hand;' onMouseOver='window.status=" + '"' + filler + '"' + "' onMouseOut='window.status=" + '""' + "'>Create New User</a>");
}

Lab Assignment -
1. Modify the member insert 2 page so that:
  - Display a "userid already exists, cannot add new member" message
  - Display a link to the search member page to login again
  - Display a link to the create member page to add a new member with a different id
  - Test thoroughly
  - Copy to "toBeGraded"
  - Work on any unfinished Flash labs

03/21/07

Wednesday - Career & Membership Web Site & Student Visitation Week & Morning Announcements

Classroom Discussion -
1. Career - oedb.org - Online Education Database - How to Ace Your Job Interview: 88 Surefire Tips and Tricks
2. Career - yahoo.com - Nine Steps to Acing a Job Interview
3. Member update, find out if a user exists & display information to be changed:
  - The index page will link to the update 1 page
  - The update 1 page will allow the user to enter an ID & password
  - The update 2 page will search for a match on the ID & password
  - If not found (objRecord.EOF), tell the user "ID not found" & allow the user to choose another ID
  - If found (else), use JavaScript to display the user record in a table using input text fields
  - The user is allowed to modify any field except the ID field -- why???
  - The user will click a button to update
  - The update button will use the form onSubmit to run an update() function & then action submit the page to reload itself
  - When upate 2 page reloads, it will research for an ID & password match & redisplay the data found in the text fields & allow the user to see the changed data & make any corrections

Lab Assignment -

Duplicate member search 1 & 2, rename to member update 1 & 2, modify:

Modify update 1 & 2 to say "update"
Modify update 1 & 2 form tag action to link to update 2
Add an onSubmit function update() to update 2 form tag

Create the function update():

Modify the SQL variable for an UPDATE command

sql = "UPDATE " + tableName;
sql += " SET ";
sql += " pw = '" + d.pw.value + "',";
sql += " fName = '" + d.fName.value + "',";
sql += " lName = '" + d.lName.value + "',";
sql += " eMail = '" + d.eMail.value + "'";
sql += " WHERE id = '" + id + "';";

Execute the objConnect with the SQL variable

objConnect.execute(sql);						// execute the SQL statement

Instead of looping through all the fields and displaying them as text, load the data into input text fields, give them same names, for example:

document.write("<td><input type='text' name='id'" + i + " value = '" + objRecord.Fields(1).Value + "' class='c' readonly></td>");
document.write("<td><input type='text' name='pw'" + i + " value = '" + objRecord.Fields(2).Value + "' class='c'></td>");
document.write("<td><input type='text' name='fName'" + i + " value = '" + objRecord.Fields(3).Value + "' class='c'></td>");
document.write("<td><input type='text' name='lName'" + i + " value = '" + objRecord.Fields(4).Value + "' class='c'></td>");
document.write("<td><input type='text' name='eMail'" + i + " value = '" + objRecord.Fields(5).Value + "' class='c'></td>");

Why is the id field "readonly"?
Create an input type submit button - this will also run the function update() because of the onSubmit in the form tag
Test thoroughly
Copy to "toBeGraded"

Work on any unfinished Flash labs

03/22/07

Thursday - Math & Membership Web Site & Student Visitation Week & Morning Announcements

Classroom Discussion -
1. Math - hofstra.edu - Linear Programming Grapher
2. Math - uregina.ca - Math Beyond School - Linear Programming
3. Member report, letting the user decide which fields to display & how to sort the result:
  - Ask the user which fields to display
  - Ask the user which field on which to sort, if any
  - Display the correctly sorted fields
Lab Assignment -
1. Duplicate member search 1 & 2, rename to member report 1 & 2, modify:
  - Modify report 1 & 2 to say "report"
  - Modify report 1 form tag action to link to report 2
  - Edit report 1:
    - Use checkboxes to allow the user to choose which fields are to be displayed in the report:
```
<input name="id" type="checkbox" id="id" value="true">User ID<br>
```
    - If checked by the user, "id=true" will be passed to the report 2 page
    - Any checkbox not checked by the user will not be passed to the report 2 page
    - Copy & change for the other fields
    - Don't include any fields that should not be displayed (key or password)
    - Edit report 1 to use a radio button group to allow the user to choose which field on which to sort the report
```
<input type="radio" name="sortOn" value="id">User ID<br>
```
    - Whichever radio button is checked, sortOn will equal the value on the button & will be passed to the report 2 page
    - Copy & change for the other fields
    - Add a radio button for "not sorted" & make this the default
    - Don't include any fields that should not be displayed (key or password)
    - Use a checkbox to allow the user to decide to sort the sort field in reverse order
```
<input type="checkbox" name="desc" value="desc">Reversed<br>
```
    - If checked by the user, "desc=true" will be passed to the report 2 page
    - Change the submit button to say produce report
  - Edit report 2:
    - Get all of your variables:
```
var id = queryString("id");
```
    - Copy & change for the other variables being passed
    - Build the SQL statement one line at a time, based on which checkboxes are checked
    - If you have more than one checkbox checked, remember to place a comma between the fields to select
    - If no checkboxes have been checked, select all fields (except key & password)
    - Determine whether to sort or not based on which radio button is checked
    - Decide if you need to sort in reverse order
    - The rest of the JavaScript program works as copied - do yo now see the power of loops & variables???
  - Test thoroughly
  - Copy to "toBeGraded"
2. Work on any unfinished Flash labs

03/23/07

Friday - SkillsUSA & Membership Web Site & Student Visitation Week & Morning Announcements

Classroom Discussion -
1. SkillsUSA - PDP Starter Kit - Level 10 - Professional Development Traits
2. Member report, part II, re-sort the records by clicking in the column headers:
  - First click on any column header field name will sort ascending
  - Second click on the same column header field name will sort descending
Lab Assignment -
1. Modify report 2 to give the user greater control sorting records:
2. Member report, part II, re-sort the records by clicking in the column headers:
  - Browse to mingyi.org - Mingyi's Javascript for sorting HTML tables:
    - Find "Version 1.26", right-click & save the file to your member folder
    - Alternatively, I'll put a copy in the "Q:/access/member/" folder for you to copy
    - Find "How to use this script" & follow the two instructions"
      1. Put <script src="sorttable.js"></script> in your html page <head> section
      2. Add class "sortable" to the table you want sorted
  - Test thoroughly
  - Copy to "toBeGraded"
3. Work on any unfinished Flash labs

03/26/07

Monday - Math & JavaScript Tricks

Classroom Discussion -
1. Math - Credit Cards - from PracticalMoneySkills.com
2. JavaScript Tricks - builder.com.com - Stupid Web Tricks
3. JavaScript Tricks - Colored Scroll Bar:
  - builder.com.com - Tropical Colors
  - htmlGoodies.com - Colored Scrollbar & Effects
  - scriptMania.com - Color Scrollbar Generator
  - msdn.microsoft.com - MSDN Demo Page
  - w3schools.com - Scrollbar Properties
4. JavaScript Tricks - Pop-Up Windows:
  - builder.com.com - Scrolling Popup
  - javaScript-coder.com - Popup Using Window.Open()
  - internet.com - Popup Window Generator
  - msdn.microsoft.com - Exciting Uses of Popup
  - w3schools.com - window.createPopup()
5. JavaScript Tricks - Back & Forward Buttons:
  - psaCake.com - Simple Back
  - crowderAssoc.com - More Details
  - pageResource.com - Forward & Back
  - msdn.microsoft.com - history.back()
  - msdn.microsoft.com - history.forward()
  - msdn.microsoft.com - history.go()
  - w3schools.com - History Method
Lab Assignment -
1. Create a web page "prime" to tell the user if a number is prime:
  - A positive integer other than 1 is called prime if its only two divisors are 1 & itself
  - The user will enter a positive integer
  - Design the page input & output & event
  - Write the process to determine if a number is prime
  - Display an appropriate message to the user
  - Test thoroughly
  - Copy to "toBeGraded"
2. Work on any unfinished Flash labs

03/27/07

Tuesday - Science & JavaScript Tricks

Classroom Discussion -
1. howStuffWorks.com - Airbus 380
2. JavaScript Tricks - onMouseOver & onMouseOut:
  - bigNoseBird.com - Image Flip
  - codeBeach.com - Rollover Effects
  - affiliated-business.com - Image Rollovers
  - w3schools.com - usage
  - w3schools.com - usage
3. JavaScript Tricks - MouseOver Images:
  - QuirksMode
  - WebMonkey
  - VicNet
  - WhatRain
4. Lab Assignment -
  1. Create a web page "superb" to tell the user if a number is superb:
    - A positive integer is superb if the sum of all its divisors (excluding the number) is greater than the number
    - The user will enter a positive integer
    - Design the page input & output & event
    - Write the process to determine if a number is superb
    - Display an appropriate message to the user
    - Test thoroughly
    - Copy to "toBeGraded"
  2. Work on any unfinished Flash labs

03/28/07

Wednesday - Career & JavaScript Tricks

Classroom Discussion -
1. Career - ACM.org - The Top 10 Reasons to Major in Computing
2. Career - Sample Interview Questions & Answers
3. Career - Website Planning Websites:
4. JavaScript Tricks - Background Color:
  - yaldex.com - Select Background Color
  - cssCreator.com - User Preference Scipt
  - cornell.edu - Changing Background Color
  - planetSourceCode.com - Choose Background Color
5. JavaScript Tricks - Page Fade In:
  - yaldex.com - Fade In
  - javascript-page.com - Fade In
  - permadi.com - Page Background Fade Effect
6. JavaScript Tricks - Image Slide Show:
  - javascriptkit.com - Building a Slideshow
  - internet.com - Image Slideshow
  - dynamicdrive.com - 18 Slideshow Examples
Lab Assignment -
1. Create a web page "racetrack" to tell the user the paved area of a race track:
  - A race track consists of two rectangles, one inside the other
  - The paved area is the space inside the larger rectangle that is not the inside rectangle
  - The user will enter the width & length of both rectangles
  - The width & length of the inner rectangle must be smaller than the width & legnth of the outer rectangle, respectively
  - Design the page input & output & event
  - Write the process to determine the paved area of the race track
  - Display an appropriate message to the user
  - Test thoroughly
  - Copy to "toBeGraded"
2. Work on any unfinished Flash labs

03/29/07

Thursday - English & JavaScript Tricks

Classroom Discussion -
1. English - Ms Gerick & Thank-You Letters
2. JavaScript Tricks - Last Modified Date:
  - chami.com -
  - iceHouse.net -
  - quirksMode.org -
  - cgiScript.net -
Lab Assignment -
1. Create a web page for the computer to write a Haiku poem:
  - According to wikipedia.org, Haiku is a mode of Japanese poetry
  - Japanese haiku is a 17-syllable verse form consisting of three metrical units of 5, 7, and 5 syllables, for example:
```
Three things are certain: (5 syllables)
Death, taxes, and lost data. (7 syllables)
Guess which has occurred. (5 syllables)
```
  - We're going to use complete words instead of syllables
  - Display a header
  - Display a definition of what haiku poetry is
  - Display the computer-haiku poem when the page opens
  - Copy the file "words.txt" from the "Q:" drive, which contains the 5000 most common English words
  - Copy the files "findPath.js" & openTextFile.js" from teh "Q:" drive, they do what they say they do
  - Add statements to link to the JavaScript files:
```
<script src="findPath.js"></script>
<script src="openTextFile.js"></script>
```
  - Add a string variable that we can use to "lowercase" all the words
  - Add a new array variable to hold the words
  - Add a variable to hold a random number
  - In a loop from 0 to 5001:
    - Read all lines in the "inFile" into the string variable
    - Lowercase the string variable into one of the word array variables
  - In another loop from 1 to 17:
    - Get a random number between 0 & 5000
    - Write word array variable for the random number to the document
    - If the loop number is 5 OR 13, write a <br> to the document
  - Close the "inFile"
  - Test thoroughly
  - Copy to "toBeGraded"
2. EXTRA, EXTRA: Create a web page "hangman" to play the game:
  - The game hangman consists of trying to guess a word by guessing one letter at a time knowing only how many letters there are in the word
  - The computer will choose a random word but will not display it to the user
  - The computer will display underlines to represent each letter in the word
  - The computer will display a list of 26 not used letters
  - The user will enter guesses by pressing on a letter key:
    - Every letter guessed correctly will change from an underline to the letter, showing more of the word to be guessed
    - Every letter guessed incorrectly will add a piece to the hanging man
    - In order to win the game, the user must correctly guess all letters in the word before the hanging man is complete
  - The computer will judge letters:
    - If the letter guessed is in the word, replace every underline where the letter is with the letter
    - If the letter guessed is not in the word, say so & draw a part of the hanging man
    - Remove the letter from the not used list of letters
  - The user gets 10 chances (10 letters incorrect) to guess the entire word:
    1. Base
    2. Post
    3. Top Beam
    4. Rope
    5. Head
    6. Body
    7. Arm 1
    8. Arm 2
    9. Leg 1
    10. Leg 2
  - Design the page input & output & event
  - Write the process to determine the paved area of the race track
  - Display an appropriate message to the user
  - Test thoroughly
  - Copy to "toBeGraded"
3. Work on any unfinished Flash labs

03/30/07

Friday - WebQuest & NJIT High School Programming Contest
LAST DAY OF MARKING PERIOD 3

Grades are almost complete
KROW NI NRUT OT YAD TSAL EHT SI YADOT TODAY IS THE LAST DAY TO TURN IN WORK
The following student MUST hand in more work:

AM		PM
css11	More Flash Labs	css01	More Flash Labs
css50	More Flash Labs	css09	More Flash Labs
css15	More Flash Labs	css21	More Flash Labs
css18	More Flash Labs	css31	More Flash Labs
css17	More Flash Labs	css07	More Flash Labs
css39	More Flash Labs	css35	More Flash Labs
		css22	More Flash Labs
		css16	More Flash Labs
		css36	More Flash Labs
		css12	More Flash Labs

Classroom Discussion - None
Lab Assignment -
1. Create either a web site or a Microsoft PowerPoint presentation about "Building Bridges" & it's possible uses:
  - Some internet resources:
    - utk.edu - An Internet WebQuest on The Study of Bridges
    - ashland.k12.ky.us - The Wonderful World of Bridges
    - plainfield.k12.in.us - Building Bridges
    - kennesaw.edu - 59 Links
  - Test frequently
  - Save to your "H:/toBeGraded" folder --> "bridges.htm" and/or "bridges.ppt"
2. Microsoft - PowerPoint tutorial - Florida Gulf Coast University
3. Work on any unfinished Flash labs