Week Three Spreadsheets and Tools

CEdO515 Week 3 In Class In Class Join me in our WiZ iQ room -the room opens at 7:50 pm. Activity Estimated Time Resources Review of last week Search Engines Word Processing Chapter 3 -Supporting Student Communication Chapter 4 -Supporting Student Critical Thinking Questions 15 min Search Engines Wolfmail Google Doc & Spreadsheets Discussion of Chapter 3 -Companion Website Discussion of Chapter 4 Questions Lecture on Spreadsheets 15 min Brief History of Spreadsheets NetTrekker introduction 10 min How to use NetTrekker d.i. to find information. Evaluating Software 15 min How is software purchased for your school or district? How is good software found? How do you evaluate it? Individual Activity Estimated Time Assignment Play With a 15 min A Numeric Magic Square must consist of a series of numbersSpreadsheet arranged in a square in such a manner that the sum of each row, each column and of both the corner diagonals adds up to the same amount, which is called the "Magic Total". Your instructor will share the Magic Square Spreadsheet with you. Complete it so that all of the cells in a row added together equal 15, and all of the cells in a column equal 15. Create a Spreadsheet 90 min Learn about Google Docs: Spreadsheet How to Use Google Documents: How to use Spreadsheets in Google DocsHow to Use Goggle Docs -Rows and Columns How to Use Google Spreadsheets -FormulaCreate a spreadsheet involving a recipe. An example is the Spring Soup recipe. It should be made in such a way that when the number of servings is changed all of the ingredient amounts change. When you have finished make sure that the instructor is a collaborator. Spreadsheets in your curricular area 30 min Use the Stritch Library website Log into NetTrekker -Search for a lesson that incorporates spreadsheets into your curricular area -Post the web site URL as well as a description of the resource in the Ning forum for Curricular Spreadsheets. Resources: netTrekker d.i.: So Much More than Search Using netTrekker Searching in netTrekker d.i. Reflections on Spreadsheets 30 min Create a Google Doc -call it CEdO515 Spreadsheets Your Name Describe your experience using the spreadsheet portion of Google docs include Features you explored (ex: cell/font colors; row/column sizing; formula; cell merge; charting; etc.) Describe how spreadsheets could be used by your class -how could it be integrated into the curriculum Read Text -Chapter 5: Supporting 60 min Enter your information in the Profile -for me enter Louis Loeffler, ljloeffler@stritch.edu and I prefer HTML Complete the following:Student Creativity True/False Short Answer Essay Read Text -Chapter 6 -Supporting Student Problem Solving 60 min Work with Study Team Reflect on Spreadsheet Assignment 10 min In your Weblog -create an entry describing this weeks activities. Include any observations you have regarding spreadsheets, software evaluations and other ideas which can be used in your teaching. Please do this by Saturday. Comment on others blogs by Monday. Connect with the Instructor 15 min Have a conversation about the use of the tools we have been looking at so far and how the course is going. Take a look at possible times -schedule early! When scheduling please do not choose a time another has chosen. First come first serve. If none of these times work for you please let me know as soon as possible. Schedule Now! Study Team Activity Estimated Time Assignment Review each others Weblog entry 10 min Discuss each entry and how spreadsheets can be incorporated into your classrooms. What benefits are there and what road blocks. When appropriate, use this time to comment on each others Weblog. Discussion 15 min Discuss Chapter 6 -Create a Google Doc and share with each other -Contribute answers to the following: -Chap 6 Questions -Make sure you share with me too.Chapter 6 Case Study Review 15 min As a group complete the case study review and send it to me -make sure you have set up the profile. Lesson Analysis 20 min Choose a lesson from the Educators Reference Desk use the Lesson Analysis and Adoption Worksheet to consider the lesson in the context of communication. Discuss how you would need to change a lesson to adopt it to technology use. Extensions: (not required -only if you want) Take a look at another online Spreadsheet, create an account in Zoho Sheet . After trying their online spreadsheet application write a one page paper in Google Docs that compares and contrasts Google Docs and Zoho Sheet. Share this document with me. Last updated by Louis Loeffler 3 hours ago. Louis Loeffler Sign Out Inbox Alerts Friends – Invite Settings Quick Add…