Tuesday, October 7, 2014

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



Interlocking AT.jpg
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.
+Y up, +Z out of screen

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:

Exit Activity #9:
Choose home row and easy. Turn off sound.

Exit Activity#10:
Working in pairs and using the PINK Study Guide answer the questions.
These will be the next test questions.  



 



No comments:

Post a Comment