Wednesday, Oct 8th- 7th Grade- Spreadsheets- Chart Components

	Archdale-Trinity Middle School Lesson Plan
Date: 10-08-2014

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheets- Chart components
Standards:	SSB-1 Know the components of Spreadsheets

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can identify different chart components.	Students can identify different chart components

	Literacy/Vocabulary Strategies (Word Wall)
	The Y axis is vertical and on the left side of the graph. The X axis is horizontal and on the bottom of the graph. http://resumbrae.com/ub/dms423_f07/08/
	Bell-Ringer/Connecting Strategy
	On page 35, type lines 09 and 10. Remember to use your thumb for the space bar. We are using our right PINKY finger for the SLASH/DIAGONAL key
	Lesson-Instructional Strategies & Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)
	Guided Lesson: @ Students will open the Chart Components PowerPoint @ Students will start taking notes @ Excel tick marks and gridlines 2010   http://www.youtube.com/watch?v=m9fbZ0DEDbY Independent Exercise: @Students will complete the first page of the  CHART COMPONENTS NOTES worksheet               http://compappssh.wikispaces.com/file/view/Notes.pdf @ Open the Tick Marks file @ Highlight the data and choose a "format as table" option @ Highlight the data and create a line chart (choose the first choice) @ We will be right clicking on certain items @ Make minor tick marks on the vertical and horizontal axes @ Change the color of the tick marks to red @ Change gridlines to green @ Change the plot area to light aqua @ Change the chart area to any color other than light aqua @ Go to the Chart Tools Tab and then the Layout tab and add the title "ATMS" @ On the Layout Tab add data labels @ In the Tick Marks file what is one of the data series? 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 different chart components?
	Student Technology/Differentiation
	Students will use Excel to understand chart components.
	Closure Strategy
	Exit Activity #8: Simple Matching http://www.quia.com/mc/1799176.html Exit Activity #9: Choose home row and easy. Turn off sound. http://www.typingweb.com/tutor/games/play/game/23 Exit Activity#10: Working in pairs and using the PINK Study Guide answer the questions. These will be the next test questions.   http://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1

Tuesday, October 7th Short Cut Links

If you are a 7th Grade student click here http://wclassroom.blogspot.com/2014/10/tuesday-oct-7th-7th-grade-using.html
 

If you are a 8th Grade student click here http://wclassroom.blogspot.com/2014/10/tuesday-oct-7th-8th-grade-databases-nsa.html

Tuesday, Oct 7th- 8th Grade- Databases- NSA Glog Project

	Archdale-Trinity Middle School Lesson Plan
Date: 10-07-2014

Teacher:	Witkowski
Lesson/Unit Topic:	Databases- NSA- world’s largest database
Standards:	DB-1 Know the use and purpose of a database

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can understand how a database works. I can bring back signed Interim Reports on Wednesday for a 90.	Students can explain the parts of a database.

Literacy/Vocabulary Strategies (Word Wall)

The NSA has the largest database in the world. A Database is a is a tool used to organize, store, retrieve, and communicate  (report on) groups of data or related information. http://en.wikipedia.org/wiki/PRISM_(surveillance_program)

Bell-Ringer/Connecting Strategy

On page 34, type lines 05 and 6. Remember to use your thumb for the space bar. We are using our left PINKY finger for the  Q key

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

Guided Practice: @ A visual look at how the NSA works https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3kwqiZTH2k3EGcDmSQPJ3_MWfoPtivy-1kGMdNpZXU9b4nLUTnj5-koertbf3kR2aHrbOAukY_uUN181z7IkuiJ0AqbmIIMNxfXlA6fC8eG-HLGmvqllduMx587aqZpUWGGBm91C2Vc_u/s1600/Google.png @ Miss W will review the NSA glogster rubric @ Miss W will pass back NSA worksheets and show correct answers. Independent Activity: @ Students will create a Glogster about the NSA A sample of a finished project http://misswitkowski.edu.glogster.com/nsa-miss-w-6753   NSA Glogster Rubric Criteria Items that need to be on Glogster Points Grade Your Name 5 Spelling and Grammar 15 Design Principles followed contrast, alignment, repetition, white space, proximity, and balance 10 NSA National Security Agency definition 10 Definition of either Counterterrorism OR counterproliferation OR cybersecurity 10 5 different items that NSA can track you by. You  must have picture and item’s name. 50 Final Grade   Go to http://edu.glogster.com/   In the upper right corner click the  log in box. 8th grade LOG-INS: students first initial and last name followed by atms13.   PASSWORDS: student birthdays in the mddyyyy format. EXAMPLE:  uid:  tmoseratms13  pw:  1011999 for a birthday of Jan 1, 1999   When you are finished (Make sure your LAST NAME is NOT on Glog) you will post your NSA Glog web address to edmodo. and write one positive thing about the NSA and one area of concern.   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 the parts of a database fit together?

Student Technology/Differentiation

Students will do research to create a glogster of the NSA.

Closure Strategy

Exit Activity #10: CIA code breaking https://www.cia.gov/kids-page/games/break-the-code Click on Code 1 Code breaking game http://www.sheppardsoftware.com/braingames/codebreaking/codebreaking.htm Exit Activity #11: Choose home row and easy. Turn off sound. http://www.typingweb.com/tutor/games/play/game/23 Exit Activity #12: Database terms http://www.quia.com/jg/1412062.html Exit Activity #13: Database terms http://quizlet.com/18461807/database-terms-flash-cards/