lesson+plan

Type in the content of your page here. **MSET 365 Agenda for Week 14 April 28 2010 **   Example spreadsheets  Example lessons § //By Golly By Gum // by AIMS Education Foundation- file on webct  § see sample gradebook + bar graph: file on webct   §  [|Poodwaddle world clock] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 16.0pt; mso-fareast-font-family: Arial; msobidifontsize: 16.0pt; msofareastfontfamily: Arial; msolist: Ignore;">. <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 16.0pt; mso-fareast-font-family: Arial; msobidifontsize: 16.0pt; msofareastfontfamily: Arial; msolist: Ignore;">. **<span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;"> Working with Existing Data Sets **<span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt; msobidifontsize: 12.0pt; msotabcount: 2;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times; mso-bidi-font-size: 12.0pt;"> <span style="font-family: Wingdings; font-size: 11pt; mso-bidi-font-family: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings; msobidifontfamily: Wingdings; msobidifontsize: 12.0pt; msofareastfontfamily: Wingdings; msolist: Ignore;">§ <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">Resources about Classroom Economies <span style="color: #0016e7; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">[|Example Excel Spreadsheet] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> for a Classroom Economy (bank account) <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times; mso-bidi-font-size: 12.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;"> <span style="font: 7pt 'Times New Roman'; mso-bidi-font-size: 16.0pt; mso-fareast-font-family: Arial; msobidifontsize: 16.0pt; msofareastfontfamily: Arial; msolist: Ignore;"> <span style="color: #0000f0; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;">[|BayCon Group Microsoft Excel Tutorial] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;"> (older version) <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;"> <span style="font: 7pt 'Times New Roman'; mso-bidi-font-size: 16.0pt; mso-fareast-font-family: Arial; msobidifontsize: 16.0pt; msofareastfontfamily: Arial; msolist: Ignore;"> <span style="color: #0000f0; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;">[|Excel Tips] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;"> (Sign up for weekly newsletter of tips and tricks) <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;"> <span style="font: 7pt 'Times New Roman'; mso-bidi-font-size: 16.0pt; mso-fareast-font-family: Arial; msobidifontsize: 16.0pt; msofareastfontfamily: Arial; msolist: Ignore;"> <span style="color: #0000f0; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;">[|Ask Mr. Excel] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;"> <span style="font: 7pt 'Times New Roman'; mso-bidi-font-size: 16.0pt; mso-fareast-font-family: Arial; msobidifontsize: 16.0pt; msofareastfontfamily: Arial; msolist: Ignore;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times; mso-bidi-font-size: 12.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">Types of Graphs <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times; mso-bidi-font-size: 12.0pt;"> <span style="font-family: Wingdings; font-size: 11pt; mso-bidi-font-family: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings; msobidifontfamily: Wingdings; msobidifontsize: 12.0pt; msofareastfontfamily: Wingdings; msolist: Ignore;">§ <span style="color: #0016e7; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">[|Practice] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> making charts and graphs <span style="color: #0016e7; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">[|Creating a pictograph] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> - Microsoft <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times; mso-bidi-font-size: 12.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times; mso-bidi-font-size: 12.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> [|Almost everything you need for using spreadsheets in the classroom] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">9**. In-class Activity** <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">Complete ONE of the following activities: <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">- create a sample grade book <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">- complete one of the Candy is Dandy lessons (M&Ms are provided) <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">- Try out the Kids Zone create a graph program Kid’s Zone – [|create a graph] – examples, templates for making graphs (e.g. bar, pie, area, etc.) <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">1. There are no assigned readings for this week <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">2. Come to class prepared to share your electronic portfolios and your videos <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">
 * 1. Spreadsheets in the Classroom**
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">What is a spreadsheet?
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">What are the components of a spreadsheet?
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">Why use a spreadsheet?
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> [|How many hours]
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> [|Movie soundtrack CD prices]
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> [|Most Wanted Toys]
 * <span style="color: #0016e7; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">[|Shoe Graph] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> activity
 * <span style="color: #0000f0; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;">[|Shoe Graph] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;"> activity (It's a Shoe In! - Math + Science: A Solution) <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times; mso-bidi-font-size: 12.0pt;">
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt;">[|Fast Food Fun]- lesson, rubric, spreadsheet example
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;">2. ****<span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;">Create an alphabetized class list and enter grades **
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;">3. Sources for stats **
 * <span style="color: #0000f0; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;">[|Supermarkets] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;">
 * <span style="color: #0000f0; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;">[|State Population & Electoral Apportionment] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;"> - Wikipedia <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;">
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;">Google "crime statistics" - FBI <span style="color: #0000f0; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;">[|Uniform Crime Reports] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;">
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;">4. Resources for using spreadsheets in the classroom **<span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times; mso-bidi-font-size: 12.0pt;">
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt; mso-bidi-font-weight: bold;">Other Resources on Classroom Economies <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times; mso-bidi-font-size: 12.0pt;">
 * <span style="color: #0016e7; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">[|Mini Economy Banking Program] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> - downloadable classroom economy software - Indiana Council for Economic Education <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times; mso-bidi-font-size: 12.0pt;">
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;">5. Excel Tutorials / Help / How To **<span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;">
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;">6. Integrating Excel (spreadsheets) **<span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;">
 * <span style="color: #0000f0; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;">[|Spreadsheet Magic] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;"> (ISTE Learning & Leading with Technology book) <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;">
 * <span style="color: #0000f0; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;">[|Integrating Spreadsheets in the Classroom] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;"> <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;">
 * <span style="color: #0000f0; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;">[|The Next Generation of Teaching and Learning] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;"> - Indiana Buddy2 <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">
 * <span style="color: #0000f0; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ComicSansMS; mso-bidi-font-size: 18.0pt;">[|Learning to Use Excel in the Classroom Handout]
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt;">[|PBS Kids Democracy Project] <span style="font-family: 'Arial','sans-serif'; mso-bidi-font-family: 'Times New Roman';"> includes game, govt stats (census), rubric, copy of US Constitution <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt;">
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times; mso-bidi-font-size: 12.0pt;">7. Graphing Data **
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">Line graph
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">Pie chart
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">Column chart
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">Area graph
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">How to decide [|which type of graph] to choose
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> [|Graphing with spreadsheets] : a complete unit <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times; mso-bidi-font-size: 12.0pt;">
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times; mso-bidi-font-size: 12.0pt;"> [|Classrooms that Excel] resources
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times; mso-bidi-font-size: 12.0pt;"> [|Spreadsheet tools for schools]
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times; mso-bidi-font-size: 12.0pt;"> [|Spreadsheet resources]
 * <span style="color: #0016e7; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">[|Creating an Excel Scatterplot] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;"> (Office 2007) <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times-Roman; mso-bidi-font-size: 16.0pt;">
 * <span style="color: #0000f0; font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;">[|Creating an Excel Scatterplot] <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: ArialMT; mso-bidi-font-size: 13.0pt;">
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-family: Times; mso-bidi-font-size: 12.0pt;">8. Additional Information on using spreadsheets for teaching and learning **
 * <span style="font-family: 'Arial','sans-serif'; font-size: 11pt; mso-bidi-font-size: 12.0pt;">Homework for next week: **