Friday, May 23rd- 7th Grade- Validated List and VLookup

Bellringer:
1. On page 22, type the first sentence and the first two bullets.
2. Students will open the Data validation file.
3. If your name is on the board, finish your study guide questions and answers.

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: 

@ Miss W will explain List, Validated and Non-validated functions
@ 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

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

Independent Exercise:
In pairs, one student will open the VLookup file and one student will click on
the instruction link. 
@ Open up the VLookup file. 
@ Open up this instruction link http://static.timeatlas.com/screensteps/vlookup-excel2010.pdf
@ Students will complete a VLookup function as the teacher demonstrates the process.
@ Student will write the definitions for Lookup and VLookup

Exit Activity
1. http://www.quia.com/rr/402638.html?AP_rand=21103945
                          You need to win a million dollars