Tuesday, Jan 6th- 8th Grade- Review DB Relationships and Create Vocabulary Word Presentations

	Archdale-Trinity Middle School Lesson Plan
Date: 1-06-2015

Teacher:	Witkowski
Lesson/Unit Topic:	Review DB Relationships and create vocabulary word presentations
Standards:	DB-1  Know the Use and Purpose of a Database DB-2  Know Data Types associated with a Database DB-3  Demonstrate the Management of a Database

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can be creative on my review project and explain the items I missed. Test on Database Relationships on Thursday.	Students will be creative on their review projects and explain the items they missed.

Literacy/Vocabulary Strategies (Word Wall)

Junction table – a table used to join primary key field from multiple tables. Which table is the Junction table? ( Users, UserPermissions, or Permissions) http://commons.wikimedia.org/wiki/File:Junction_Table.svg

Bell-Ringer/Connecting Strategy

On page 423, type the 1st two sentences that start  “If you were searching”.

Guided Lesson: Pet example- review of all database relationships https://docs.oracle.com/html/E38269_01/Content/Data%20model/Define_a_relationship.htm Many-to-Many – when multiple records from both (or more) tables are linked.  A Many-to-many relationship is actually two one-to-many tables that are connected by a junction table. Car example- many to many database relationship https://599cd.com/site/courselist/access/access309/ Review Database Tables, Primary Keys, Foreign Keys, and Relationships https://www.youtube.com/watch?v=FCtGbrou5DM 0:00 Database Tables 1:36 Primary key- Candy Questions- What are the other 4 primary keys? 6:33 Foreign key- Candy Questions- What is the other foreign key in the Order table?                                                               What is the foreign key in the Order LINE table? Candy Questions In the Product table, is Product Id a primary or foreign key? What are the lines between the databases called? One customer can have many orders. What type of database relationship is it? If one customer was only allowed one order what type of database relationship would it be? If Coke deletes Customer 23 (they want Pepsi now) and all of Customer 23’s data is deleted from the database, it is a good example of what item is working? Begins with a “R.” If Time: @ Miss W will review the review presentation rubric for database relationship word projects. @ Students will have 10 minutes to work together. Rubric: 50% accuracy (definition is correct) 50% creativity (time, effort, originality) ` Independent Exercise: @ Students will create a clue worksheet and trade with a partner. @ Students will create a query to solve Robbery 3. If time: @ Students will start and present their database relationship word projects.

Higher Order Thinking Questions

How can you make your topic interesting to other students?

Student Technology/Differentiation

Students use various software programs to create their review project.

Closure Strategy

Exit Activity #14: Database relationships http://www.quia.com/rr/475949.html?AP_rand=1592723462 Exit Activity #15: Typing Symbols http://www.quia.com/rr/142292.html

Tuesday, Jan. 6th- 7th Grade- Spreadsheet Review

	Archdale-Trinity Middle School Lesson Plan
Date: 1-06-2015

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheet- Review
Standards:	SSB-1 Know the components of Spreadsheets SSB-2 Creation and Formatting of Spreadsheets SSB-3 Know spreadsheet operations

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can do well on the spreadsheet review. Review Test on Thursday.	Students do well on the spreadsheet review.

Literacy/Vocabulary Strategies (Word Wall)
What if the tax rate was .08, would you need to type the formula again? What do all formulas begin with?  What does the * do? Is “cost of car” a label or a value?  Name a value? B6 has a dark border around the cell. What is B6 called?   What do rows have in front of them? Are columns vertical or horizontal? What is B4 called?  Begins with a “c” http://spreadsheets.about.com/od/exceltips/qt/what_if_tip.htm
Bell-Ringer/Connecting Strategy
On page 363, type sentence 3 and 4 in the top paragraph. Today’s typing is a general review using all of the alphabetic key strokes we have learned this semester.
Lesson-Instructional Strategies & Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Lesson: Spreadsheet Review: Review the following files in the 7th Grade Review folder to answer the questions or fill in the blanks: Independent Exercise: Look at the Review for Test Spreadsheet Vocabulary PowerPoint to fill in the blanks. Descending order- is ____________ to __________ sort order or 100 to 1 order. Relative cell referencing- _____________ formulas and automatically ____________ to correct cell range.   In contrast, an __________________ cell reference does not change when its formula is copied and pasted to other cells. Which symbol is used for absolute cell references? ______________ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ ___Go to Types of Charts PowerPoint and look on slide 3 to fill in the blanks. _____________________Chart- comparisons Stacked Bar Chart - charts each group’s ________________________________to the whole. Line Charts show ________________________ or changes in data over time. XY Scatter Charts are used to indicate the __________________________ of  two or more sets of data. Pie Charts answers the question “What is the ________________________of each part to the whole?” Exploded Pie Chart is an ___________________________ pie chart. @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ ___Look at the 4.01 Advanced Functions document to answer the questions and fill in blanks. Which function allows the computer to insert dates according to your instructions? ___________ VLOOKUP- Looks for a value in the ___________________________ column of a table, and then gives you a value in the ________________________row from the column specified. Which function counts the number of cells within a range when given specific conditions? To create a list: Type and highlight the __________________ you want to use. Next you will ________________________ the list in the name box (beside the ____________________Bar) then ___________________________ the cell that you want the drop-down list to appear in. Then do to _____________, Validation, Allow: List, and then source: ____(the name of your list) Which function helps you control the kind of info that is entered into a worksheet? A drop-down list would be an example because you could only choose information that was entered into the list.   ___________________________________ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ ___Look at the Excel if statements explained PowerPoint Write the IF statement for IF A2 is equal to “Feline”, write “Cat” in B2, otherwise, write “Amphibian” ___________________________________________________________________________ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Play the SCATTER GAMES on the quizlet sites ____SCATTER http://quizlet.com/4256873/spreadsheet-vocabulary-flash-cards/ ____SCATTER http://quizlet.com/5002039/spreadsheet-terms-flash-cards/ ____SCATTER http://quizlet.com/834955/cai-401-ss-components-flash-cards/ ____Get 100% _http://www.teach-ict.com/gcse_new/spreadsheets/spreadsheets/miniweb/pg3.htm ____SCATTER http://quizlet.com/3972846/ms-wrights-bct-obj-5-flash-cards/ _____ Hangman game get 22 out of 25 correct  http://www.quia.com/hm/174125.html   ____SCATTER http://quizlet.com/10716938/cai-obj-401-business-spreadsheets-flash-cards/ ___ match words to definitions http://www.quia.com/mc/1799176.html?AP_rand=23603320 ___ match words to definitions for the link below _http://www.quia.com/mc/2016566.html?AP_rand=1926551694 ___ You can use notes. You must get 100% for the link below. http://www.quia.com/quiz/2055803.html?AP_rand=1395669365 ___WIN a million dollars http://www.quia.com/rr/363962.html
Higher Order Thinking Questions
Explain why sometimes absolute cell referencing is needed.
Student Technology/Differentiation
Students will use online sites to review spreadsheet concepts.
Closure Strategy
Exit Activity 12: 10 Steps of a Presentation Do NOT look at the PowerPoint http://www.quia.com/pp/279397.html?AP_rand=520216192

Monday, January 5th Short Cut Links

If you are a 7th Grade student click here http://wclassroom.blogspot.com/2015/01/monday-jan-5th-7th-grade-powerpoint.html?_sm_au_=iVVLq7kQSjb6qPFq


If you are a 8th Grade student click here http://wclassroom.blogspot.com/2015/01/monday-jan-5th-8th-grade-database-many.html?_sm_au_=iVVLq7kQSjb6qPFq