Monday, November 2, 2015

Tuesday, November 3rd- 7th Grade- Spreadsheets- Chart Components



Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 11-03-2015



Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheets- Finish Chart Components Voki Project

Standards:
SSB-1 Know the components of Spreadsheets



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can explain different features of Excel charts.
Test on Friday.
Students know the correct answers during today's presentations.


Literacy/Vocabulary Strategies (Word Wall)

Gridlines- you can hide or  show these on screen or print, they help you see the data better.
A gridline is a horizontal or vertical line that extends across the plot area.
File:Giant Allosaurid Gridlines.jpg

Bell-Ringer/Connecting Strategy

Bellringer:
1. Get out of the crate your Chart Component Notes.
2. Open 4.01 Chart Components PowerPoint
3. You need a pen or pencil

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



Guided Practice:
@ Students will critique PowerPoint presentations

@ Test Friday! You can practice the questions online at home or take home a pink study guide and/or the Review for Test Spreadsheet Vocabulary PowerPoint.
@ Excel tick marks and gridlines 2010   http://www.youtube.com/watch?v=m9fbZ0DEDbY
    until 2:20
@ 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?

Independent Exercise:
@ Students will take notes about Chart Components from 7. Tick Mark to 11 Axis Titles. http://compappssh.wikispaces.com/file/view/Notes.pdf



Higher Order Thinking Questions

What are the different chart definitions involved with spreadsheets?

Student Technology/Differentiation

Students will use Voki software to understand chart components.

Closure Strategy

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

 
Exit Activity#11:


 





No comments:

Post a Comment