Wednesday, March 11, 2015

Thursday, March 12th- 7th Grade- Spreadsheets- Formulas

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 03-12-2015
Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheets- functions (short cuts)

Standards:
SSB-1 Know the components of Spreadsheets
SSA-2 Create Charts and Graphs used in Business
“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can format a chart.
I understand why a function is a short cut.
TEST ON FRIDAY
Signed Interim reports due by Today
Students format their car charts correctly.
Students understand why a function is a short cut.


Literacy/Vocabulary Strategies (Word Wall)
Functions- are short cuts. The computer types most of the  formulas for you.
This is what the function button looks like.
Matemáticas, Función, Símbolo
Bell-Ringer/Connecting Strategy
On page 32, type lines 13 and 14.
Remember to use your thumb for the space bar.
We are using our left PINKY finger for the LEFT SHIFT key.
Remember to capitalize the names and cities.
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Lesson:  

Open the Spreadsheet Vocabulary file
Slides 25 through 30   (PEMDAS)  
Do the PEMDAS activity- Slide 26 (order of operations in a spreadsheet formula)

Slides 31 through 34 (formatting and formulas)

@ Chart creation and formatting
  • hide the "miles" column
  • highlight your car lot data- model and price
  • Insert a column chart
  • click on the chart and the Chart Tools Tab will appear
  • We are going to look at the Design Tab.
  • Choose a chart style color.
  • We are going to  look at the Layout tab.
  • insert the chart title "My Car Lot". It will explain the chart's purpose.
  • insert horizontal axis title "model"
  • insert vertical axis title "price"
  • click on data labels and click on show
  • click on data table and click on show
  • change chart wall, go to more options and pick a fill color
  • change chart floor, go to more options and pick a different color
  • make sure you have gridlines they will make the plot area easier to read.
@ Open up the Spreadsheet Vocabulary PowerPoint file
slides 37 and 38 Understanding Functions (Shortcuts)
@ Function as a shortcut example
@ Miss W will review the Function handout
@Depending on time several functions examples will be completed.
***Students will open the payroll file and by using functions
        find the following information:
        the maximum hourly rate
        the minimum hourly rate
        the sum of the hourly rates
        the average of the hourly rates
@ Spreadsheet flashcard 32 calculates averages
@ Additional function practice as needed.

Independent Activity:
@ Complete the function practice worksheet.
@Complete Exit Activity by yourself without any help.

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
How do I format a chart?
How are functions short cuts?
Student Technology/Differentiation
Students will use Excel to understand functions.
Closure Strategy

Exit Activity #7:

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

Exit Activity #9:  Ribbon Vocabulary words
review words and definitions here http://quizlet.com/3089570/flashcards
then play activity here http://quizlet.com/3089570/scatter

We have not covered one question yet.
Built in calculations are called functions.
Horizontal is like laying down flat on the ground.
Vertical is up and down
You may use the Spreadsheet Vocabulary PowerPoint.
Play until you have won a million dollars





Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)