Wednesday, March 26, 2014

Thursday, March 27th- 7th Grade- Review for Spreadsheet Test

Bellringer:
@ We are NOT using the typing book for several days.
We are learning the number keypad. 

The daily bellringers will now be practicing the number pad
http://www.typeonline.co.uk/number_pad_lesson1.html
Choose exercise 2 and then click on the word "start."
Time will not start until you put your cursor
 in the white rectangle and start typing.
Record you typing speed and accuracy in your typing file.

IF YOU DO NOT MAKE 98, 99 OR 100% ACCURACY, CLICK ON REPEAT!

TEST ON FRIDAY- you can practice exit activity at home.
Bring a book or homework on Friday to read after the test.

What are we learning?
4.00 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 REVIEW BY TEACHER
@ TEST REVIEW BY STUDENT
@ Open up the Spreadsheet Vocabulary PowerPoint file
     slides 37 and 38 Understanding Functions (Shortcuts)
***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.
@Sign into Edmodo and add Miss W's Computer Group.
See board for Edmodo group number.
@Complete Exit Activity by yourself without any help.



Exit Activity:http://www.quia.com/rr/363962.html
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.

http://edu.glogster.com/ 
Do NOT create a new id if you can not log in! We have a list with ids on it.  
 

No comments:

Post a Comment