Week+10+Lab

=AI Meeting Agenda= 1. Lecture Overview 2. Lab Overview 3. TTL Question: Do you know who might be the best GA to assist with converting a video on a dvd to a format that can be used with moviemaker? - If no one else, I can --Chip (M 10; R 2:30-4:00) 4. Unit Test 2 5. Unit Test 3 & Final - A combination? 6. Final Exam Format & TTL hours during final exam week - TAL program has portfolios due that week. 7. Final Exam grading meeting 8. Improvements for next semester meeting 9. Next semester, AI contracts - arrive one week before classes begin. We will have a meeting that week. 10. TTL hours for AECT week: Please let Chip also know who is covering what hours in the TTL. --Chip Minjing Duan will sub-teach for Susie on Friday and Clare's TTL on Thursday from 9:00 to 10:00 AM. Andrew will sub-teach Nilufer's Wednesday and Friday labs. Ja-Ok will cover Nilufer's lab hour on Wedneday 11:00-2:00. = =

=Week 10 Lecture= = = [|PowerPoint]

=Week 10 Lab: Data Collection and Analysis= [|Data Collection Cases]

[|Data Collection Cases Revised]

[|PPT]

Modeling: M&M activity **Facts about M&M colors - [|Attached pdf]
 * Activity Outline:

=
http://www.atozteacherstuff.com/pages/231.shtml We will get Peanut, mini, and regular. We will graph and compare number of each and then figure out the approx area of each and how they would fit into similar size bags.======

=List of Tools=

– Microsoft Excel – Google spreadsheets – OpenOffice.org Calc – Num Sum – Edit Grid

=**Workout**= Google Form: Survey • Doug’s class develops a survey about what students’ concerns are for using technology in their future classrooms – It will include some numerical data and some open ended questions • Students will enter information with each new lab  •  Students will analyze the data collected – review their peers concerns and analyze whether or not their concerns are similar – how females or elementary teachers may vary from others – how all the subject areas all have similar concerns Option 2: Gradebook You are a teacher and an at the end of semester techer-parent conference is approaching. You want to show each individual student's progress to their parents at the conference. You want the parents understant how their child did compared to the class. You think showing the parents graphs will be helpful.

• Open the [|Gradebook.xls] • Calculate sum, average, min, and max points in data – Copy formula • Sort by Total points • Enter course grades • Format the spreadsheet for printing • Create a chart showing a student’s grades compared to class average for all assignments **Want to know more? Check out these sites:** __ [|Google Lesson Plans Spreadsheet] __ __ http://www.tcet.unt.edu/START/instruct/lp_tech.htm __ __ http://volweb.utk.edu/school/tdalton/lesson2.html __ __ http://lessonplans.btskinner.com/computer.html __ __ [|http://www.successlink.org] __ __ [|http://www.4teachers.org] __ __ http://sunsite.univie.ac.at/Spreadsite/ __ __ http://www.education-world.com/ __ __ http://www.microsoft.com/education/content/MSEducation.asp?T=Y __ __ http://www.tamu-commerce.edu/coe/shed/espinoza/s/tschoerner-h-lp.1.html __ __ http://volweb.utk.edu/school/tdalton/lesson2.html __ __ [|http://pages.nyu.edu/~dse7916/Lesson1.html] __ http://teachers.net/cgi-bin/search.pl?index=index26.swish-e&metaName=Keywords&yes=details&0=start&query=database http://manassas.k12.va.us/round/ClassWeb/Volz/dblessplan.htm

Microsoft Excel Tutorials: http://www.datapigtechnologies.com/ExcelMain.htm
 * 1. **[|**http://www.baycongroup.com/el0.htm**]
 * 2. **[|**http://www.usd.edu/trio/tut/excel/**]<span style="font-size: 12pt; font-family: 'Arial','sans-serif'">
 * <span style="font-size: 12pt; font-family: 'Arial','sans-serif'">3.<span style="font-family: 'Times New Roman'; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal"> **[|**http://www.fgcu.edu/support/office2007/Excel/index.asp**]<span style="font-size: 12pt; font-family: 'Arial','sans-serif'">
 * <span style="font-size: 12pt; font-family: 'Arial','sans-serif'">4.<span style="font-family: 'Times New Roman'; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal"> **[|**http://www.vertex42.com/Excel2007/excel-tutorial.htm**]<span style="font-size: 12pt; font-family: 'Arial','sans-serif'">

<span style="font-size: 12pt; font-family: 'Arial','sans-serif'">
 * <span style="font-size: 12pt; font-family: 'Arial','sans-serif'">Google spreadsheets Tutorial: **
 * <span style="font-size: 12pt; font-family: 'Arial','sans-serif'">1.<span style="font-family: 'Times New Roman'; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal"> **[|**http://computerworld.com/action/article.do?command=printArticleBasic&articleId=9001087**]<span style="font-size: 12pt; font-family: 'Arial','sans-serif'">