If you are a 7th Grade student click here http://wclassroom.blogspot.com/2014/09/tuesday-sept-30th-7th-grade.html
If you are a 8th Grade student click here http://wclassroom.blogspot.com/2014/09/tuesday-sept-30th-8th-grade-databases.html
Monday, September 29, 2014
Tuesday, Sept 30th- 8th Grade- Databases- Creating a Database
 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 09-30-2014
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Databases- Creating a Database
| |
Standards:
|
DB-2 Know the data types associated with a database
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can create a database.
TEST ON FRIDAY
|
Students create a database.
|
Literacy/Vocabulary Strategies (Word Wall)
|
Which Field types should you use for each of the FIELD NAMES below?
Fields are categories of information.
Text, Date/Time, Yes/No, Text, Currency
The RECORDS would be each Farmer Code. Records are a complete set of field entries.
|
Bell-Ringer/Connecting Strategy
|
On page 25, type lines 9 and 10.
Remember to use your thumb for the space bar.
We are using our right MIDDLE finger for the , (comma) key.
Make sure you use the shift keys to capitalize the words!
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Practice:
@ 7th period only: Students will decide the right field types needed for the vacation
database. Look on slide 18 on 1 Fundamentals of Databases PowerPoint.
@ Miss W will walk through how to create a vacation database
by right clicking on the database name to the left and using the Design view.
Independent Exercise:
@ Students will enter their vacation information into their vacation database.
@ If it does not let you type in the data, it means you have the field type wrong.
@ Practice test questions with exit activity 11.
Homework- Extra Credit for 3rd test:
Ask your parents if they have a business card or
have one in their wallets from a business or
have a friend with a business card or the next
time you go into a business or they go into a
business see if they have a business card or
at home go to Google and then images and type
"business card" then print a business card.
If you give Miss W a business card sometime
this week you will get 5 points extra credit on
the second test. MUST be appropriate for school-
no alcohol, guns or bad words on cards.
MUST BE IN BY MONDAY
|
Higher Order Thinking Questions
|
How do create a database?
|
Student Technology/Differentiation
|
Students will use Access to create a database.
|
Closure Strategy
|
Exit Activity #9:
Typing Adventure http://www.learninggamesforkids.com/keyboarding_games/keyboarding_games_typing_adventure1.html
Exit Activity #10:
Choose home row and easy. Turn off sound.
Exit Activity #11: Database Test Questions
The first database test will be on these questions.
There are some questions we have not covered yet.
To put data in a particular order is to sort.
Ascending is small to large, A-Z order.
Descending is large to small, Z-A order.
Two examples of connector words are OR and AND.
A feature that displays records that meet one or more specific
criteria is a filter/query.
Exit Activity #12: Database terms
Exit Activity #13: Database terms
|
Tuesday, Sept 30th- 7th Grade- Spreadsheets- Order of Operations
 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 09-30-2014
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets- Order of Operations
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
SSB-3 Know spreadsheet operations
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can find and use different features of Excel. TEST ON FRIDAY
|
Students use different features of Excel.
|
Literacy/Vocabulary Strategies (Word Wall)
|
Format table- to give the data in a spreadsheet color and design
 |
Bell-Ringer/Connecting Strategy
|
On page 25, type lines 9 and 10.
Remember to use your thumb for the space bar.
We are using our right MIDDLE finger for the , (comma) key.
Make sure you use the shift keys to capitalize the words!
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
1. Open the Spreadsheet Vocabulary file
Slides 25 through 30 (PEMDAS)
@Do the PEMDAS activity- Slide 26 (order of operations in a spreadsheet formula)
2. Open the SS Flash Card folder file
SS Flash cards file
Open 7 Format Table (format as table button)
SS Flash cards file (conditional formatting button)
Open 13 Data Bars
SS Flash cards file (border button and percent button)
Open 31 Formatting Cells
3.Car lot formatting exercise- students will format their data table, change the color of the tabs, create a border around their favorite car, fill in that cell and change data format to currency.
Independent Activity:
Open car lot file and add the following items to your file:
On your car lot spreadsheet complete the following formatting:
1. choose a "format as table" style,
Skill 7- format table any color, (Home tab- format as table arrow)
2. change the color of the 3 tabs,
Skill 23- change color of tabs,
(Right click on tab, click on change color, choose color)
3. create a "thick box" border (any color) around your favorite car,
Skill 31 formatting cells- (highlight car, choose border button)
4. fill in that cell with any color (choose paint bucket)
5. and change the data format in the price column to currency.
Skill 31 formatting cells- change price column to currency
(highlight prices, then click on number format arrow)
6. create data bars of any color in your price field
Skill 13- data bars on price column any color,
(Home tab- Conditional Formatting button)
7. hide the row of the car you like the least
Right click on number of car you do not like and choose hide.
For 2nd period only
Cell Reference and Range Activity
Follow instructions to make a picture.
Make cell C5 to C8 yellow
Make D5 to D8 yellow
Make cell F5 to F8 yellow
Make cell G5 to G8 yellow
Now click on C6 make it black
Then F6 and make it black
Cell E11 green
Cell B12 B13 red
Cell I11 I12 red
Cell C14 red
Cell D15 red
Cell E16 red
Cell F15 red
Cell G14 red
Cell H13 red
Homework:
Students need to decide for which ACADEMIC topic
(Typing Posture/Technique, Language Arts, Science,
Social Studies, or Math) they will create a
PowerPoint presentation soon. We will be using the
PowerPoint you create to learn different old and new
features of PowerPoint 2010.
|
Higher Order Thinking Questions
|
What are the order of operation for a spreadsheet formula?
|
Student Technology/Differentiation
|
Students will use Excel to understand a formula’s order of operation.
|
Closure Strategy
|
Exit Activity #7:
Typing Adventure http://www.learninggamesforkids.com/keyboarding_games/keyboarding_games_typing_adventure1.html
Exit Activity #8:
Choose home row and easy. Turn off sound.
Exit Activity #9: Ribbon Vocabulary words
We have not covered one question yet.
Built in calculations are called functions.
Horizontal is like laying down flat on the ground.
Vertical is up and down
You may use the Spreadsheet Vocabulary PowerPoint.
Play until you have won a million dollars
|
Subscribe to:
Posts (Atom)