Keeping+Track+of+Friends

=Keeping Track of Friends=

Lesson one allows students to work cooperatively, tapping into their interpersonal intelligence as they learn how to sort information in spreadsheets. Students learn to sort and organize data as they build an address book and learn how to import data for further analysis. In lesson one, they will build address books with spreadsheets. This will allow the students who follow logical/mathematical reasoning to use that intelligence.



** Objectives:   **
    **//Why am I doing this? <span style="FONT-FAMILY: Arial, Helvetica, sans-serif"><span style="FONT-FAMILY: Arial, Helvetica, sans-serif"><span style="FONT-FAMILY: Arial, Helvetica, sans-serif">  // **     <span style="FONT-FAMILY: Arial, Helvetica, sans-serif"><span style="FONT-FAMILY: Arial, Helvetica, sans-serif"> You are learning to use spreadsheets to help organize and analyze information. <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">**//What will I learn?//** <span style="FONT-FAMILY: Arial, Helvetica, sans-serif"> You will learn to use a spreadsheet to enter and organize data, in this case a phone list, so that it can be sorted and re-sorted for efficient use. <span style="FONT-FAMILY: Arial, Helvetica, sans-serif"><span style="FONT-FAMILY: Arial, Helvetica, sans-serif">// **<span style="FONT-FAMILY: Arial, Helvetica, sans-serif">What will I do? ** //<span style="FONT-FAMILY: Arial, Helvetica, sans-serif"> <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">You will create an address book with a spreadsheet application and use this spreadsheet to produce a printable phonebook and place it on a wiki.
 * <span style="FONT-FAMILY: Arial, Helvetica, sans-serif"><span style="FONT-FAMILY: Arial, Helvetica, sans-serif">Students will understand how to use spreadsheets to sort data.
 * <span style="FONT-FAMILY: Arial, Helvetica, sans-serif"><span style="FONT-FAMILY: Arial, Helvetica, sans-serif">Students will apply the sorting feature of spreadsheets to locate and group friends in useful categories.
 * <span style="FONT-FAMILY: Arial, Helvetica, sans-serif"><span style="FONT-FAMILY: Arial, Helvetica, sans-serif">Students will analyze sorted data to elicit productive and meaningful patterns.

__**Day 1**__ __**<span style="FONT-FAMILY: Arial, Helvetica, sans-serif">Day 2 **__ <span style="FONT-FAMILY: Arial, Helvetica, sans-serif"><span style="LINE-HEIGHT: 200%; FONT-FAMILY: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings">   //Students will be given the following// //steps://  <span style="FONT-FAMILY: Arial, Helvetica, sans-serif"> <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">**__Assessment__** Students will check their work against the checklist and revise as necessary .<span style="LINE-HEIGHT: 200%; FONT-FAMILY: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> <span style="FONT-FAMILY: Arial, Helvetica, sans-serif"> <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">Students will complete a self-evaluation rubric to assess their work.
 * Writing an address book requires pre-planning. When creating an address book we must consider what types of information will be needed about your contacts. You must also consider how you would like to be able to retrieve that information.
 * <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">  <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">  <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">Before you begin an address book you should consider the types of information you want and how you will want to access that information.
 * <span style="FONT-FAMILY: Arial, Helvetica, sans-serif"> <span style="COLOR: black; LINE-HEIGHT: 200%; FONT-FAMILY: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">     <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">Provide example data collection sheet with fields for last name, first name, home phone, cell phone, email, birthday, interests, and check boxes for friend/family/emergency, and then another extra field (to be specified by student).
 * Using data collected in class and as homework, students will create an address book of friends, family and emergency contacts which includes a list of interests and birthdates.
 * Open and name a spreadsheet document at your <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">workstatio <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">n
 * <span style="FONT-FAMILY: Arial, Helvetica, sans-serif"> Create column headers for each of the categories in your address book (remember to create separate columns for last and first name)
 * Enter the data from your worksheet.
 * <span style="LINE-HEIGHT: 200%; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'">   Format and put 3 address books utilizing three different sort orders on your wiki space.
 * On the [|"Day to Day Life with Excel"] blog, write one paragraph explaining the advantages and disadvantages of the sort order you selected.