Lesson 6/1/09

1. Complete handwritten notes for study guide. Answer all questions 1-26. Be thorough in your respones.
2. Complete the SQL create table section from Friday if you did not do it on Friday.
3. Pick up your binders and take home today, or they will be tossed today.
4. Exam will be on Wednesday, Periods 1 & 2. Bring a number two pencil PLEASE!.

Lesson 5/29/09

1. Second section in SQL online interpreter. Do create tables section pages, 4-5.
2. Final Exam Review worksheet. Notes must be handrwritten to receive a grade.

Lesson 5/28/09

1. Students who are finishing DB continue to make corrections.

2. SQL Review: Review the following webisite:

http://sqlcourse.com/intro.html

Do practice tutorial through http://sqlcourse.com/select.html , which is page three of the tutorial and stop.

Questions to answers:

1. What does the select statement do?
2. When extracting data from a table what must the strings be enclosed with?
3. What is the word from used for?
4. What clause specifies the criteria you will use to extract specific information?


From the following table, write SQL statements:

FRUIT TABLE

Item No: Fruit Price Quantity
1 Plums 1.00 100
2 Apples 2.00 200
3 Oranges 3.00 300
4 Grapes 1.00 300
5 Kiwi 7.00 100


a. List all fruit whose price is less than 3.00
b. List all fruit whose quantity is equal to 300 units.
c. List all fruit for whose price is not equal to 1.00
d. List all fruit where quanitity is leass than 300

Post answers in a comment to this post with your name.

Lesson 5/27/09

1. Query Practice: Using DB AC10, write the following;
a. Display all products of bread where the quanity in stock is greater than 50.
Save as qryproducts.

b. Display all products of bread where the quantiy is less than 50.
Save as qryproductsunder50

c.Display all customer names for customers who live in the city of San Francisco.
Save as qrySanFrancisco

d.Display all customers who live in Mill Valley or Larkspur.
Save as qryMillLarskspur

e. Display all customers names who currently receive a newsletter.
Save as qrynewsletter
2. Report: Create a report totalling the quantity of all bread products. Save the report as rptQuantity.

3. Review and make final corrections to DB.

Lesson 5/26/09

1. Compelte DB. Give DB to instructor on a CD for grade.
2. Final Access Lesson:

Creating a Report wtih a calculated field
Pg. 710-714. Do Ex. 26 pg. 713 and On Your Own Page. 714. SAVE ALL REPORTS, DO NOT PRINT.

Ex. 27: Formatting Reports with Labels. Pg. 717 & 718 On Your Own.
SAVE ALL FOUR REPORTS. DO NOT PRINT.

Lesson 5/22/09

1. Review of Switchboard. You will create a switchboard for your forms in your DB project. If you have not created your forms yet, you must do that before you create the switchboard.
2. Listent, watch and follow instructions.
3. Create your label for your CD.
4. Continue to finalize DB, let's shoot for completion on Monday.
5. Review your database with the assigned teacher as well and find out what information they would like extracted from the database that would be useful for them so you can write the queries and reports.

Lesson 5/20/09

1. Query Review
2. Continue working on your DB entire class period. You will not have a lot of time on Friday.
3. Follow requirements from yesterday's posting.
4. Students who I have noted will not working as a team will refelect in grade.

Lesson 5/19/09

1. See me with your flash drive, if I did not review it yesterday.
2. Database Project: Due on Friday, May 22, 2009.
Database must include the following:

* Three Tables. Must include data all three tables.
* One or more relationships.
* A form for each table.
* Five queries that you create on your own.
* One report.
* An original logo for the organization you created the DB for.
* Password for DB. (Write it down somehere, use the organization's name, for example, hosa)
* Switchboard.
* Save all objects.

Burn your DB to a CD. Your must provide your on CD. Create a CD label with the organization name, student names and datE created. I have labels that I will give you.

2. Ex. 25 Reports: Read 702-705. Questions to comment on this post.
What is the purpose of using a report?
What are the varoius ways to create a report?
What information do you think your report will include from your project?
Do Ex. 25 Pg. 708 and Ex. 25 On your Own pg. 709: DO NOT PRINT REPORTS!!!
SAVE ON FLASH DRIVE!

Lesson 5/18/09

1. Quiz online.
2. Ex. 23 Critical Thinking. Creating queries. Review the criteria from last week page 691.
3. Print all queries, put your name on them, today's date, staple and turn in to me. Not your binder.
4. Review of reports.

Lesson 5/15/09

1. Ex. 25: Access Reports. pg. 702: Invidividual assignment:
Read and review 702 through 707. Do Ex. 25. pg. 708. DO NOT PRINT, SAVE YOUR REPORTS.
2. Quiz on Monday, review previous day lesson.
3. We will finalize your project DB on Mon and Tues next week.

Lesson 5/14/09

1. Work in your DB Project.
2. Insert on logo from your team to use in the forms.
3. DB should include 3 tables with data.
4. Forms for each table, join relationships by primary key and foreign key.
5. Tables can not have repeating data.
6. Revise forms so that it flows from left to right not top to bottom.
7. Ex. 13-21 Quiz on Monday on Vocabulary and concepts from those sections.
* You may use on page of HANDWRITTEN NOTES. No typed notes.

Lesson 5/13/09

1. Complete query lessons, if you have not done so, print our your query results, include your name and ex. number on the queries.
2. DB Project: Continue to add tables, should have at least 3.
3. Need a form form for each table, or include subdatasheets, through relationships.
4. Illustrator: Each person in team should design a new logo to go with DB, chooose the best one. Each student will receive credit for their logo.

Lesson 5/12/09

1. Reading and review. Counts as Kurl and EXTRA CREDIT today! Must be readable.
2. Creat a booklet of questions from the reading selection: 683-684, 688-691.
3. Follow instructor. Fold sheets of paper accordingly.
4. Create a title for the reading selection. Survey the reading selection, write 8 questions from the subheadings in the reading selection. Answser the questions and summarize.
Write your questions for items that are challenging to you. For example, what is Criteria in a Query?
5. Key Terms on pag 683 and 688 should be reviewed.
6. Criteria questions to be answered:
How would you display the following criteria when writing a query?
Show values in a field that is not empty?
Show dates that are between May 1, 2009 and May 22, 2009.
Show a list of cities called Weston, Southwest Ranches and Davie.
Show a city that that starts with the Wes.
Show any students who last name is Rodriquez or Smith.
Show all states that are not equal to FL.
Show all studetnts who are over the age of 16.
Show all fiels that are empty.
Show all ages that are greater than or equal to 18.
7. Complete Ex. 2o and Ex. 21 lessons from yesterday.

Lesson 5/11/09

Access Lessons, finding, sorting and replacing data.
1. Teacher review of finding data with wilcards.
2. Student needs to read and review terms on page 678.
2. Do ex. 19 pg. 681.
Ex. 20 pg. 686.
Save Databases.
3. Ex. 21 Pg. 692 and Ex. 21 Pg. 693. On Your Own, Save both DB and save queries.

Lesson 5/08/09

1. Review your tables, make sure there is no repeating data.
2. You should have at least 3 tables in your DB.
3. Develop a form for each table.
4. You are going to have to get data from your client to import into the DB. Ask your client to provide you with an excel spreadsheet or MS Word document so that you can bring the data over. Your job is not to do data entry just design.
5. Develop a logo to insert into your form, it needs to be an original use PS or Illustrator.

Lesson 5/06/09

1. Finish lessons from yesterday.
2. Complete your questionnairre to start building DB. If you have no client to interview, you must answer the questions as if you were the client.
3. Another job opening: law firm downtown Ft. Lauderdale. You would be building a website for a lawyer who immoblizes vehicles on DUI cases. Additionally, you would be doing other various office duties as needed with legal assistants and attorney. Email me your cover letter and resume. Revise objective. Cover letter should be addressed as follows:
Greg Ross, Esquire
311 SE 11th Court
Ft. Lauderdale, FL 33009.
4. Diagram your tables and fields for the DB that you are building for project. Identify a unique value for primary keys in the tables, the value can not be repeated by another record.

Less 5/05/09-5/06/09

1. Karolina's Team: Pick up pass from sub to see Ms. Waxman.
2. Andrea's Team: Pick up pass from sub to see Mr. Stember.
3. Pick up questions worksheet and get all questions answered in interview.
4. Complete ex. from yesterday, Print out screen shot showing the lookup fields from tables.
5. Ex. 14: Read 655-657. Do not do this ex.
6. Ex. 15: Read 661-663. Do Ex. 16 and On Your Own 16. Print out one copy of each form, place in binder.

Paul's Team: I have some info for you on password in forms. Will give to you when I return.

All students who RSVP will receive a pass to attend luncheon on Friday. If you did not RSVP like instructed, you will not be able to attend. I already placed the order. So do not show up if you do not get a pass on Thursday this week.

Another job oppurtunity, possibly working for a local web design company. If you have not emailed me your resume, please do so today as well. Don't worry about cover letter now. You really must be looking on your own at this point for a job this summer as severl of our business partners have backed out because of the economy. Please network with your families and see if they know any businesses that could hire a student for the summer.

Lesson 5/4

1. Interview your person that you are going to build a database, get as much information as possible.
2. Open up your EX. 11 to be graded.
3. Ex. 13: Creating a lookup field pg. 650-654.
4. Do Ex. 13 pg. 653 and On Your Own pg. 654. Print out the following:
Ex. 13 Datasheet View tblClass Offerings and tblClassEnrollement
On Your Own 13 Datasheet view of roster for baseball postions.

Friday: Team Work Day

1. Create your team. No more than 3 people. Submit your names and team leader to me.
2. Review worksheet and brainstorm who you are going to build a database for, either inside or outside school.
3. Pick team members wisely, points will be deducted each time a team member is not on task.
4. Open Relationships DB Window from Ex. 10.
5. Complete Ex. 11, show me your DB for a grade, this will be a quiz grade.
6. Students who did practice interviews: Submit a thank you letter to me via email. Address as follows. My email: mitzi.plunkett@browardschools.com

David W. McKenney
Regional Vice President - Claims
Healthcare Underwriters
1250 South Pine Island Road, Ste 300
Plantation, FL 33324

Lesson 4/29-4/30/09

1. Developing a Database. Part of your final exam this semester will be developing a database for a real group or person in need. You will need to break into teams do this assignment.
2. You will need to decide on business or entity either in school or outside school to create a database. Once you have identified your client, you will need to meet with your client to gather the data.
3. Use the worksheet to assist in gathering your data from your client.
4. Access Lessons: Review of Ex. 10 together.
5. Ex. 11 On Your Own. These are the skills covered so far and will be counted as test grade. You may work in teams and submit one database for Ex. 11.

Lesson 4/27-4/28/09

ALL INTERNS MUST DRESS IN BUSINESS ATTIRE ON WEDNESDAY FOR PRACTICE INTEVIEWS.

All students, must answer practice interview questions;
Go to the following website: http://www.quintcareers.com/interview_question_database/interview_questions.html

Choose 10 interview questions to answer. Type your questions and answers. Elaborate in your answers.

1. Read pages 626-629. Create a Powerpoint Presentation. Create a slide for each blue heading in the chapter.
2. Do Ex. 8, save DB on your flash drive.
3. Ex. 10, add slides to the previous PowerPoint with a slide for each blue heading in chapter. Summarize key points. Save files on your flash drive.
4. Answer the questions on the worksheet. Pretend that there are no online databases. You may work in teams. You need to elaborate in your answers, both students must have a worksheet completed.

When doing the PowerPoint summarize with pictures and bulleted lists, not paragraphs, do not rewrite the text.

Lesson 4/27-4/28/09

Lesson 4/24/09

All Students who applied for the internship with the Florida Department of Transportation, will be required to dress in business attire on Wednesday, April 29, 2009. You will be practicing for your interview skills during class with professionals from outside school. You will be graded on this.. this is not an option.

1. Read and review Ex. 10, 640-641.
2. Try AC10 Ex. on page 644.
We will discuss during class.
2. See me for grades.

Lessons for 4/20-4/23/09

Juniors doing interns this summer:

Redo your job application for the DOT, email Ryan Hendel at he is suppose to create a typed adobe form for everybody. Also, make any additional changes to resume and cover letter by Wednesday as well. Email me your completed job application, final resume and covber letter at mitzi.plunkett@browardschools.com.

Videogame Day: Thursday, April 23, 2008 at 12:30, come play Halo for $3.00 room 323. Pay at the door. We need volunteers to help for community service hours, also, extra credit if you bring in your XBox and Halo game that day to use. Please tell your friends.

All students must complete the following:

1. Use the Office 2007 Red/Blue book for all lessons. Save all lessons on your flash drive.
2. Complete the following:

Read pages: 610-614
Do Ex. ACO4 On Your Own pg. 615. Save database, and write down the password for the database. Do not remove the password. I will check file from disk.

Ex. 5 pg. 616-617. You will create a new dataqbase with two new tables. Use the illustration on page 617 to creat your fields. Save the database.

Complete the MC questions. Handout for substitute. The questions come from various chapters, reserach the answers using the glossary, index, etc. You may also use the internet.

Read pg. 620-623:
Define all terms and provide an example for each term.
Answer the following questions after reading?

What is the purpose of design view?
What does the field properties do?
How do you insert a new field in design view?
What is the field size?
Provide one example of date/time format using the date April 21, 2009.
What is a caption?
What is a default value?
How do you create an input mask?
What is a validation rule?
What is the purpose of using an index?

Ex. 6 pg. 624. Save the database on your flash drive.

Do your current event for the week if you complete all work by Wednesday.

Lesson 4/14/09

1. Review the web link from 4/14/09 and use the internet as well to search.
2. Create a step-by-step document on how to create the following:
Straight Through Cable
Crossover Cable
3. Explain in your document from start to finish how to create both cables, what they are used for and the color schemes.
4. Your document should be so detailed that a novice person would be able to read and follow your instructions on how to create the cables.
5. We will finish your cables on Wednesday when I return.

Be good Hendel, Singer and Vlad!!!

Lesson 4/14/09

DB 4/15/09

Dear Students:

Sorry to be out today again... the next few weeks will be challenging for all of us. Please follow the instructions that follow and turn in all work to the substitute. If I get a good report, there may be a reward at the end of the week. All assignments are to be done individually, NOT TEAM OR SHARING YOUR WORK.


1. Read and view the following video:
http://www.wired.com/entertainment/hollywood/magazine/16-09/ff_starwarscanon?currentPage=all

2. Answer the questions on the worksheet that the subsitute provides to you.

3. Search the internet and find online databases to find answers to the questions in the database scavenger hunt.

4. Turn in both worksheets to the subsitute.

Database Basics 4/14/09

1. Take online quiz at:
http://www.quia.com/quiz/1791635.html, you must use your login information provided to you.

2. Ex. 2. Page 597-600: Prepare a written document as follows:
A. Define all terms on page 597.
B. Provide an explanation for each of the following sub headings. You may use short response, bulleted lists or paragraphs for your answers. Must be handwritten.
* Explain how to enter records in the datasheet.
* Explain what the special data entry field types are.
*Explain how to copy data and entire record.
* Explain how to cut data?
* Explain how to enter records in a form.
* Explain how to edit records.
* Explain how to edit hyperlink fields.
*Explain how to select records.
*Explain how to delete records.
*Explain how to print datasheets and forms.
* Explain print preview.
3. Exercise 2: pg. 602. Make all changes from the instructions 1-19. Print only the last 6 records in item #17. Hole punch all work and place all documents in your binder.

March 31, 2009

1. Complete any work from Monday.
2. Print out work and turn in to sub.
3. Save all work as well.
4. We will review on Wednesday when I return.
5. Be good to the sub. Do current event for this week as well.

AOIT Programming Lesson 3/30-3/31/09

1. Students who are attending the field trip on March 31, you must meet in the bus loop by 7:00 on Tuesday. You must be dressed in business attire, YOU WILL NOT BE ALLOWED ON THE BUS IF YOU ARE NOT DRESSED APPROPRIATELY. No jeans, sneakers, etc. will be allowed. Dress shirt, pants and shoes, you may wear a tie as well. Dress for Success.

2. Students who did not get to print business cards, please pick up business cards from sub, use number 8371 to create your cards. Leave them with sub.

3. Database Development:

Use the Learning MS Office 2007 Textbook:

Read pages 586-588. Answer worksheets from sub.
Define all terms on page 586 and include and example.

Read pages 589-593.
Define all terms on page 589 and provide one example.

Do the practice exercise on page 595-596. Use CD in back of book, you may have to share, save the database on your flash drive, you maywill have to take the read only property off. Right click on the file go to properties and deslect the read only once you have saved it to your flash drive.

4. Visual Basic TextBook: Chapter 11: Read pages 658-660.

Answer the following questions:
A. What are some examples of databases that you are currently familiar with?
B. What is a field?
C. What is a table and what is stored in tables.
D. What is primary key and list three examples of what would constitute a primary key?
E. How are a primary key and foreign key related?

We will review when I get back on Wednesday. Try to get the correct answers.

Chapter 6 VB 3/16/2009

Chapter 6 VB Vocabulary & Syntax

Define each term, provide an example of the syntax, where applicable, or an example.
Let’s work in teams of two for the vocabulary and applications, and syntax review.
Additional Applications to Code for String Manipulation:

Mid Statement: Pg. 363-364 (Replace Area Code)
Pad Left/Pad Right: Pg. 367-368
SubString: Pg. 384-385
Radio Button: Pg. 397-398

Length Property
TrimStart, TrimEnd, Trim Method
Remove Method
Index
Replace Method
Mid Statement
Pad Left/Pad Right Method
Insert Method
Starts/EndsWith Method
Contains Method
IndexOf Method
Substring Method
String.Compare Method
Like Operator
Radio Button Tool
Check Box Tool

Summarize via Web Site Chapt. 5

We will review DW and HTML. You will create a summary page using links, tables and images. The following should be discussed in your page:

1. What is repetition structure and how is it represented in VB.
a. Provide an example For/Next Stmt.

2. What is the Financial.Pmt Method?
a. Provide examples of arguments.

3. What method is used to select existing text in a Textbox.
a. Provide the syntax that was used in the financial payment calculator.

4. What is the difference between a list box and combo box?
a. Provide an example of coding for a list box for your favorite food.
b. Provide an example of coding for a combobox for places you would like to visit.

5. What is the function of a do loop?
a. Provide an example of a do loop.

KURL Chap. 3 & 4

Chpt. 3:

Explain the process of naming a variable, declaring a variable, and assigning a variable.

Pg. 188-189

Chpt. 3: 1, 2, 3, 4, 5, 6, 9, 15

Chpt. 4: Pg. 260, 7, 8, 9, 13

Publish your URL in a comment. Put all students names in the post.

Review Questions Chapter #4

Review Questions Chapter 4:

Pages 256-258: Answer Questions on your blog, then post to a comment with your URL to this post.

Migrating to Windows 7

Post your comments opinon on the article.

KURL DAY IF/ELSE STATEMENTS

KURL DAY 2/18/2009
Objectives: Students should be able to understand how to write if/else statements, use comparision operators, and convert strings using upper and lowercase methods.

1. TEAM READING: PAGES 196- TOP OF 210: SPLIT THE PAGES. REVIEW CHARTS. PRACTICE WORKSHEET.

2. SUMMARIZE YOUR READING IN A DIAGRAM. POST IN A COMMENT. READ OTHER COMMENTS.

PRACTICE STATEMENT WRITING WORKSHEET: POST IN A COMMENT.

1. Write and if statement that displays the temperature if the temperature is greater than 75 degrees.
2. Write and If/Else statement that displays your GPA if it is greater than 2.5 otherwise, displays message “You Need to Improve your GPA”.

COMPARISION OPERATORS

1. Write a statement if statement show a true condition of two variables that are equal.
2. Write an if statement that show that a condition is not equal to the name “Smith” then display all other names.
3. Write an if statement that shows if the tax rate is great than 7% then provide a discount of 1% .

UPPER/LOWER METHODS

1. Write a statement to convert the name SMITH to all lower case.
2. Write a statement to convert the name “smith” to all upper case.

VB Scenario #8 Pg. 192

PERIOD 1: VB SCENARIO #8

1. TEAM WORK: COMPLETE REVIEW QUESTIONS 186-188: ONE DOCUMENT PER TEAM
2. READ SCENARIO #8: PG. 192
3. CREATE A VISUAL LAYOUT OF THE FORM USING WORD OR INSPIRATION OR PHOTOSHOP
4. DEVELOP A TASK, OBJECT, EVENT CHART NAMING CONTROLS AND TASKS. USE FORMAT FROM TEXTBOOK. See Page 77, Example.

5. DEVELOP A FLOWCHART CHARTING OUT YOUR STEPS FOR WRITING THE CODE. See Pg. 157: Use correct shapes and diagram based upon events.


6. Bottom of page 85/86 Look at Color Scheme.

7. WRITE THE APPLICATION IN VB.

Insert a header with team member names and date... Print out all documentation for grade. Due by Friday.

Chapter 3 Notes/Vocab

On your blog develop a vocabulary chart for the following terms. You must include definition and an example that supports the defintion. Answer the questions that follow after the terms.

Data Type
          
Floating Point
                
Unicode
Boolean Variables           Identifier                    DIM
String                      Literal Constant              Literal Type Character
Method                      TryParse Method               Line Continuation Character
Imports System.Globalization Convert Class                Precedence Numbers
Operators                   Scope                         Lifetime
Procedure Scope             Comments                      Module Scope
Block Scope                 Static Variable               Option Explicit
Option Strict               Pseudocode                    Empty String
Focus Method                Format Specifier

Questions to Answer

1. How do you name a variable and provide one example.
   
2. How do you declare a variable and provide one example.
   
3. What is the difference between DIM and Const?
   
4. How do you include a mathematical expression in assignment statements?
   
5. How do you clear the text property when application is running?
   
6. How do you format a number for output as a string?
   

Assignment 1/27/2009

1. Read and review chapter 1 in VBasic.
2. Complete crossword puzzle.
3. Pages 63-66 Review Questions. Type up your reponses and turn them in. You may work in teams, but each student has to turn a response sheet to receive credit.
4. Students who did not complete the State Capital Application on page 56-57, complete as well.
5. Make sure when you create a new project you change the path to the location on your flash drive.
6. Review the blog notes from Chris and review defintions for the terms listed on the blog. Extra credit to any team who puts up the info on their blog with terms.
7. You may also work on the homework assigned on Monday, it is due Friday, must be typed. Generate your ideas for a specific need country. Review website:

InventTeams Info

We will review all responses on Wednesday and I will post grades for your two completed applications.

Chapter 1 VB

Prepared by Chris 1/22/09. View his blog for notes.
Chapter 1 Terminology
Working as team blog about the following terms from Chapter 1. Incorporate pictures, text, video or hyperlinks to support your text responses. Share the link with other team members and the class.

Application Programmers	Instances	Assembly Language
Exposed	Machine Language	Base Class
Form	mnemonics	behaviors
High Level Languages	Object	Class
Object Oriented Programming	Compiler	Inheritance
Polymorphism	Program Programmers	Properties
Solution	System Programmers	Source File
IDE	Solution Explorer Window	Project

AOIT Programming Blog 2008/2009

1. You must blog about your current event each week. You should read an article that is at least 800 words in length. Current event must be related to business or technology and must answer the following. Copy and pasted the questions first and then respond. Your current event web address must be for current week and year. The blogs for each class period are listed as follows:
   Period 1: AOIT Prgm/Database http://www.aoitprogramming.blogspot.com/
   Period 2: AOIT Tech Support/PC Support 1 & 2 http://www.aoittech.blogspot.com/
   Period 4: Computing for College and Careers http://www.cpt4blog.blogspot.com1/.
   Items to Answer:
   

1. News story title and web address.

2. Write a summary statement based upon the author's point of view.
3. Write 4 facts that support the summary and point of view.
4. Formulate a prediction (reaching a conclusion; what will happen next) from the summary and facts and point of view.
5. Background information and supporting details.
6. What did you not understand from this story?
7. What is your opinion of this topic?
8. Write a specific question regarding this topic to generate class discussion.
Be detailed in your responses and elaborate. After posting your current event, you must respond to another student's specific question.
Be professional in your responses, use correct grammar and punctuation. No text messaging shortcuts are allowed.
Current events are 20% of your grade, no late postings will be accepted. YOU MUST POST YOUR CURRENT BY FRIDAY EACH WEEK BEFORE YOU COME TO CLASS. Not allowed to post in class, this homework outside of class