Thursday, March 5th- 7th Grade- Spreadsheets- Different types of charts

	Archdale-Trinity Middle School Lesson Plan
Date: 03-05-2015

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheets
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 next Wednesday.	Students use different features of Excel.

Literacy/Vocabulary Strategies (Word Wall)

Worksheet, Bar graph, Line graph, Pie graph http://commons.wikimedia.org/wiki/File:US-autism-6-17-1996-2007.png

Bell-Ringer/Connecting Strategy

On page 21, type lines 13 and 14. Remember to use your thumb for the space bar. We are using our right RING finger for the . (PERIOD) 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: @* Open Spreadsheet Vocabulary PowerPoint and go to slide 13       Students will learn about bar, line and pie graphs, labels and values (slides 13-20) @ Students will finish Spreadsheet Ribbon Worksheet Independent Activity: Car lot exercise-   1*Students will gather data to create a spreadsheet of dream cars that they would have in their own car lot business. 2*Students will go to http://www.carmax.com and find cars and write the information (year, make(brand), model(name), miles, and price) on their worksheet. 3*Open the "car lot" file found in the student docs, Witkowski folder, Spreadsheet folder and save to your lunch number 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 type of graphs are best for different situations?

Student Technology/Differentiation

Students will use a spreadsheet and learn about its different features

Closure Strategy

Exit Activity #6: Frog Game Home Row Keys http://www.freetypinggame.net/play3.asp Exit Activity #7: Choose home row and easy. Turn off sound. http://www.typingweb.com/tutor/games/play/game/23

Wednesday, March 4th Short Cut Links

If you are a 7th Grade Student, click here: http://wclassroom.blogspot.com/2015/03/wednesday-mar-4th-7th-grade.html


If you are a 8th Grade Student, click here: http://wclassroom.blogspot.com/2015/03/wednesday-mar-4th-8th-grade-databases.html

Wednesday, Mar 4th- 8th Grade- Databases- Gathering Vacation Data

	Archdale-Trinity Middle School Lesson Plan
Date: 03-04-2015

Teacher:	Witkowski
Lesson/Unit Topic:	Databases- Gathering Data for a Database
Standards:	DB-1 Know the use and purpose of a database

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can gather data for a database.	Students can collect information for a database.

Literacy/Vocabulary Strategies (Word Wall)

Field types: Date/Time, Yes/No, Text, Currency, The Number field type is used when you are going to do math with the numbers. http://en.wikipedia.org/wiki/Sun

Bell-Ringer/Connecting Strategy

On page 21, type lines 9 and 10. Remember to use your thumb for the space bar. We are using our RIGHT PINKY finger for the RIGHT SHIFT  key.

Lesson-Instructional Strategies & Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)

Guided Practice: @ Access 2010: Introduction to Databases http://www.youtube.com/watch?v=eXiCza050ug @ Students will open in the DATABASE folder     the 1 Database Fundamentals PowerPoint @ Class will practice identifying tables and records, fields, and entries. @ Class will discuss the difference between text and number data field types. @ Finish the Review of Database Tables worksheet. Independent Lesson: @ Students will start on airline database worksheet. @ Miss W will walk through how to gather data for the first example. @  Expedia TV ad http://www.youtube.com/watch?v=-B5hcH8Kr4U @ Go to http://www.expedia.com/     GSO- Greensboro     RDU- Raleigh     CLT- Charlotte       Flight # Airline Departure City Arrival City Departure Time Arrival Time Length of Flight Date Leaving # of Stopovers Cost of Trip Independent Activity: Students will complete vacation spots on the airline database worksheet. 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 #5: Practice on the beginner level (#1 home row keys) at http://www.freetypinggame.net/play11.asp Choose beginner if you are in the beginner category Choose intermediate if you are in the average category Click to turn off the sound. Exit Activity #8: Frog Game Home Row Keys http://www.freetypinggame.net/play3.asp 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. http://www.typingweb.com/tutor/games/play/game/23 Exit Activity #11: Database terms http://www.quia.com/jg/1412062.html Exit Activity #12: Database terms http://quizlet.com/18461807/database-terms-flash-cards/