Friday, April 25th- 7th Grade- Spreadsheets- Tick Marks

Bellringer:
1. Get out of the crate your Chart Component Notes.
2. On page 380, type the paragraph that starts "To add, subtract, multiply..."

What are we learning?
4.0 Spreadsheet Basics and Formulas
4.1 Know the components of Spreadsheets
4.2 Creation and Formatting of Spreadsheets
4.3 Know spreadsheet operations

Guided Lesson:
@ Test next Thursday! You can practice the questions online at home or take home a pink study guide and/or the Review for Test Spreadsheet Vocabulary PowerPoint.
@ Open the 4.02 Chart Components 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

Exit Activity#1:
Click on the link Characteristics related to chart options   http://www.quia.com/mc/2016566.html
We have not discussed 2 terms:
Data series: A group of related information in a column or row of a worksheet that will be plotted on a chart
Chart Wizard: An on-screen guide that helps you prepare a chart

Exit Activity#2:
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

Exit Activity#3:
You need to get at least 50% correct. http://www.quia.com/quiz/2055803.html?AP_rand=106361813

Exit Activity#4:
http://www.purposegames.com/game/excel-chart-elements-quiz