spreadsheetlesson

Introduction: Students will interview classmates in target language about likes and dislikes and record data. Students will then take that information and input it into a spreadsheet to see how many students expressed similar likes and dislikes. As a class, we will then address what if our data had changed and then compare to other classes information. Students will then take their individual survey sheet and compile a spreadsheet using the template (if necessary). Students will be assessed by their interview handout and participation, spreadsheet and on the vocabulary quiz. Students will use the data acquired in the interview to create a chart in excel and record their data. Their columns should be labeled “Lo que gusto” and their rows should be charted as “si and no.” Students will acquire the abilities to customize their graphs and select graphs that fit their information’s needs.

Learner Description:
Lesson made for high school second year Spanish students, but could be adapted for elementary students in a more simplified fashion and in their native language or for native speakers by using more intense interview questions and more difficult spreadsheet techniques.

Objectives:

 * 1) Speak target language.
 * 2) Acquire spreadsheet skills as a class and individually.
 * 3) Organize information from oral interviews and research.
 * 4) Assimilate food vocabulary into language set.

ACTFL Standards COMMUNICATION Communicate in Languages Other Than English
 * Standard 1.1: Students engage in conversations, provide and obtain information, express feelings and emotions, and exchange opinions
 * Standard 1.2: Students understand and interpret written and spoken language on a variety of topics

CONNECTIONS Connect with Other Disciplines and Acquire Information
 * <span style="background-color: transparent; color: #000000; font-family: Verdana; font-size: 13.3333px; text-decoration: none; vertical-align: baseline;">Standard 3.1: Students reinforce and further their knowledge of other disciplines through the foreign language

<span style="background-color: transparent; color: #000000; font-family: Verdana; font-size: 13.3333px; text-decoration: none; vertical-align: baseline;">COMMUNITIES <span style="background-color: transparent; color: #000000; font-family: Verdana; font-size: 13.3333px; text-decoration: none; vertical-align: baseline;">Participate in Multilingual Communities at Home & Around the World
 * <span style="background-color: transparent; color: #000000; font-family: Verdana; font-size: 13.3333px; text-decoration: none; vertical-align: baseline;">Standard 5.1: Students use the language both within and beyond the school setting

<span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 24px; text-decoration: none; vertical-align: baseline;">Activity Sequence: <span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">This is intended to be a one to day and a half activity, but should really only last one day. If I wanted to turn it into a longer sequence of activities, I would add an element of comparing our responses to a typical Guatemalan student or Spanish student. <span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">Day 1: To begin class, students will journal in their penzu to answer the question “Que te gusta comer?” What do you like to eat? This will begin to activate thinking about food and what they like. After about 6-8 minutes, we will move on. <span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">I will explain the scope of the lesson and the end product and show an example (completed template). Then I will pass out the interview handout and give about ten to fifteen minutes for students to speak only Spanish to obtain the information. <span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">Wrapping up the interview time, students will collaborate to create a spreadsheet using the template (if necessary) and my interview information to practice. Students should not use template if they have been exposed to excel at all. It simply exists for a form of scaffolding and adapting to diversity. Students will tally their yes/no count and categorize each food into groups. Then they will input these numbers into the template to create a graph.

<span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 24px; text-decoration: none; vertical-align: baseline;">Materials:

 * <span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">Interview handout
 * <span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">Student template spreadsheet
 * <span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">Spreadsheet examples
 * <span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">Computers (each student has their own laptop)
 * <span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">Eno board

<span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 24px; text-decoration: none; vertical-align: baseline;">Grouping Strategies:

 * <span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">Students will work to interview as many students as possible in a scramble (we frequently just let students group up and regroup as they finish).
 * <span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">Students will work as a class to complete a template with my interview information.
 * <span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">Students will individually complete template to create their own and share through their portfolio.

<span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 24px; text-decoration: none; vertical-align: baseline;">Learning Activities:

 * <span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">Students will journal for the day regarding their likes and dislikes in food, looking up vocabulary words they may not know.
 * <span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">Students will then work on their language skills by interviewing as many classmates as possible in the time allotted.
 * <span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;"> Then, students will use my interview page to create a collaborative spreadsheet as a class on the eno board as a form of guided practice.
 * <span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">Students will take what they just learned, and students will create their own spreadsheet from template and add it to their portfolio.

<span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 24px; text-decoration: none; vertical-align: baseline;">Diversity:
<span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">Hearing and visually impaired students can use the ease of access button to be able to be better use their computer. ELL classes will be in groups to make sure that I can be helpful to as many students as possible. Also, if necessary, I will ask for a technology integration specialist to be present to help in explaining to the maximum number of students.

<span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 24px; text-decoration: none; vertical-align: baseline;">Assessment:
<span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 14.6667px; text-decoration: none; vertical-align: baseline;">Students will be assessed by the instructor based on participation in the target language (whether or not they spoke Spanish), their spreadsheet embedded in their portfolio and then will be assessed (summative) on the test.

<span style="background-color: transparent; color: #000000; font-family: Arial; font-size: 24px; text-decoration: none; vertical-align: baseline;">References:
<span style="background-color: transparent; color: #000099; font-family: Arial; font-size: 14.6667px; vertical-align: baseline;">[|__http://www.vhlcentral.com/__] <span style="background-color: transparent; color: #000099; font-family: Arial; font-size: 14.6667px; vertical-align: baseline;">[|__http://quizlet.com/5402708/vistas-spanish-ch-8-flash-cards/__] <span style="background-color: transparent; color: #000099; font-family: Arial; font-size: 14.6667px; vertical-align: baseline;">[|__http://penzu.com/__]

Attachment: Spreadsheet Link