Tuesday, May 20th- 7th Grade- Test Review and Validated Data

Bellringer:
1. 1. On page 5, type the top paragraph that begins
  "The Enter key moves the insertion point..."  
2. Get out of the crate your Advance Functions Notes papers.
3. You need a pencil or pen. 

TEST this Wednesday: 20 test questions from previous tests
                                       and 5 new questions. 

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:
@ Microsoft Excel 2010 Data Validation
@ Open the Data validation file
@ The Green class tab has the name of classes
@ The Yellow period tab has the daily periods listed
@ On the Yellow tab we are going to where A1 is and we are going to call it Periods.
@ On the Green tab we are going to highlight B1:B7
@ Go to the Data Ribbon Tab
@ Click on Data Validation
@ Click the drop down arrow and choose List
@ Where it says source type =Periods
@ Click OK
@ Choose different periods for your classes
@ Write the function definition, use and examples of
List, Validated and Non-validated on your worksheet

http://www.youtube.com/watch?v=qfLirkaWnCY

Independent Exercise:
@ Students will be encouraged to use a flash drive to save Lesson Points
@ Miss W will review items the three items that will be on Wednesday's test,
     Keyboarding techniques, Publisher concepts and Database concepts.
@ Students will preview and answer the 25 questions that will be on the test.
Exit Activity 1. http://www.quia.com/rr/402638.html?AP_rand=21103945
                          You need to win a million dollars.