If you are a 7th Grade student click here http://wclassroom.blogspot.com/2014/09/wednesday-oct-1st-7th-grade.html
If you are a 8th Grade student click here http://wclassroom.blogspot.com/2014/09/wednesday-oct-1st-8th-grade-databases.html
Tuesday, September 30, 2014
Wednesday, Oct 1st- 8th Grade- Databases- Sorting and Connectors And & Or
 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 10-01-2014
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Databases- Sorting and Connectors And & Or
| |
Standards:
|
DB-2 Know the data types associated with a database
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can gather data for a database.
TEST ON FRIDAY
School Guests on Thursday |
Students can collect information for a database.
|
Literacy/Vocabulary Strategies (Word Wall)
|
Filter/Query- looks for items with a specific criteria (item you are looking for)
It filters out (takes out) what you are not looking for.
http://en.wikipedia.org/wiki/Neutral_density_filter
|
Bell-Ringer/Connecting Strategy
|
On page 25, type lines 13 and 14.
Remember to use your thumb for the space bar.
We are using our left INDEX finger for the G 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:
@ Miss W will review sorting definitions- ascending and descending
@ Students will participate in the connector AND and OR activity
@ Students will open up the 1 Database Test 1 PowerPoint
@ Students will finish typing in all 8 records in their Airplane database CATCH UP: If your name is on the board, you need to finish the work. 8th grade Glogster log-ins: http://edu.glogster.com/ Do NOT create a new id if you can not log in! students first initial and last nameatms13 passwords are student birthdays
@ Students will practice exit activity number 11 individually for Friday’s test
@ Students will practice exit activity number 9 for Friday’s typing contest.
@ If time: Students will practice sorting with their flight database
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 I know which data goes into which field?
|
Student Technology/Differentiation
|
Students will use expedia.com to gather information for 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.
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
|
Wednesday, Oct. 1st- 7th Grade- Spreadsheets- Formatting Data
 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 10-01-2014
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets- Formatting a Table
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
|
“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)
|
Descending Order- the people on the right are going down. They are descending.
Ascending Order- the people on the left are going up. They are ascending.
 |
Bell-Ringer/Connecting Strategy
|
On page 25, type lines 13 and 14.
Remember to use your thumb for the space bar.
We are using our left INDEX finger for the G 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:
On your car lot spreadsheet complete the following formatting:
Open car lot file and add the following items to your file:
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.
Sorting
Make sure you have chosen a "Format as Table" style.
Click on the sort arrow by the price.
We are going to sort the most expensive car.
We are going to sort for the least expensive car.
Click on the sort arrow by the miles.
We are going to sort the car with the most miles.
We are going to sort the car with the least miles.
Chart creation and formatting
Open the Spreadsheet Vocabulary file
Slides 31 through 34 (formatting and formulas)
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
|
How do I format a spreadsheet?
|
Student Technology/Differentiation
|
Students will use Excel to format a spreadsheet.
|
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)