Monday, March 26, 2012

Excel Workshop

There are many ways in which Excel could be used by students within your classroom.

1. Stocks- Students will pick a company out of the newspaper to track during the whole school year. Students will make an excel worksheet with their company's name & the stocks price for that day. Down the A column students will record the date for all 180 days of school. Down the B column students will record the stock for each day. At the end of the week students will find the average of the stock prices. Also students will create a line graph at the end of each week that represents the changing in stock prices. At the end of the year students will compare the graphs and data and determine the average of all the prices.

Standards: 3. Research and Information Fluency Students apply digital tools to gather, evaluate, and use information. a. Plan strategies to guide inquiry b. Locate, organize, analyze, evaluate, synthesize, and ethically use information from a variety of sources and media c. Evaluate and select information sources and digital tools based on the appropriateness to specific tasks d. Process data and report results. 4. Critical Thinking, Problem Solving, and Decision Making Students use critical thinking skills to plan and conduct research, manage projects, solve problems, and make informed decisions using appropriate digital tools and resources. a. Identify and define authentic problems and significant questions for investigation b. Plan and manage activities to develop a solution or complete a project c. Collect and analyze data to identify solutions and/or make informed decisions d. Use multiple processes and diverse perspectives to explore alternative solutions. 6. Technology Operations and Concepts Students demonstrate a sound understanding of technology concepts, systems, and operations. a. Understand and use technology systems b. Select and use applications effectively and productively c. Troubleshoot systems and applications d. Transfer current knowledge to learning of new technologies.

2. Weather- Students will pick any location in the world to track during the whole school year. Students will make an excel worksheet with their location and the changes in weather. Down Column A students will record every Fridays date of the school year. Down Column B students will record the high and the low for each Friday. At the end of each month the students will create a bar graph which displays the highs and lows on the same chart. Students will do this for every month. Based on the data collected and graphed, students will be able to determine the weather pattern and climate zone of their specific location.

Standards: 3. Research and Information Fluency Students apply digital tools to gather, evaluate, and use information. a. Plan strategies to guide inquiry b. Locate, organize, analyze, evaluate, synthesize, and ethically use information from a variety of sources and media c. Evaluate and select information sources and digital tools based on the appropriateness to specific tasks d. Process data and report results.4. Critical Thinking, Problem Solving, and Decision Making Students use critical thinking skills to plan and conduct research, manage projects, solve problems, and make informed decisions using appropriate digital tools and resources. a. Identify and define authentic problems and significant questions for investigation b. Plan and manage activities to develop a solution or complete a project c. Collect and analyze data to identify solutions and/or make informed decisions d. Use multiple processes and diverse perspectives to explore alternative solutions.6. Technology Operations and Concepts Students demonstrate a sound understanding of technology concepts, systems, and operations. a. Understand and use technology systems b. Select and use applications effectively and productively c. Troubleshoot systems and applications d. Transfer current knowledge to learning of new technologies.

3. Fractions- Students will be able to practice making fractions. Students will be able to write the fractions within excel and see how it is converted into a decimal. Along with fractions students can make each fraction into a pie chart so that they can see how the fraction is broken up in a visual representation.

Standards: 4. Critical Thinking, Problem Solving, and Decision Making Students use critical thinking skills to plan and conduct research, manage projects, solve problems, and make informed decisions using appropriate digital tools and resources. a. Identify and define authentic problems and significant questions for investigation b. Plan and manage activities to develop a solution or complete a project c. Collect and analyze data to identify solutions and/or make informed decisions d. Use multiple processes and diverse perspectives to explore alternative solutions.

4. Budget- Students can think of something that they really want to save their own money for. Students will write the item in A1. Students will also research different stores at which this item is sold out as well as the prices. Students will then think of a business in which they would do to earn money for this item, such as raking leaves, mowing grass, babysitting, etc. Students will also include how much they would charge for that service. Students will then figure out how much they would need to save each week, as well as how many many weeks they will need to save for the item that they want. By doing this students will be able to to figure out which store is the cheapest and which job will help them save the most money. Students could graph this as well.

Standards:3. Research and Information Fluency Students apply digital tools to gather, evaluate, and use information. a. Plan strategies to guide inquiry b. Locate, organize, analyze, evaluate, synthesize, and ethically use information from a variety of sources and media c. Evaluate and select information sources and digital tools based on the appropriateness to specific tasks d. Process data and report results.4. Critical Thinking, Problem Solving, and Decision Making Students use critical thinking skills to plan and conduct research, manage projects, solve problems, and make informed decisions using appropriate digital tools and resources. a. Identify and define authentic problems and significant questions for investigation b. Plan and manage activities to develop a solution or complete a project c. Collect and analyze data to identify solutions and/or make informed decisions d. Use multiple processes and diverse perspectives to explore alternative solutions.6. Technology Operations and Concepts Students demonstrate a sound understanding of technology concepts, systems, and operations. a. Understand and use technology systems b. Select and use applications effectively and productively c. Troubleshoot systems and applications d. Transfer current knowledge to learning of new technologies.

5.Plants-Students will work in teams that will plant the same seeds and place them in different locations. Students will then give the plants different amounts of water each day. Students will then measure the changes in plants each day. Students will record this data in Excel. After each week students will graph the results which will show the differences in each plant. After a few weeks students will graph their overall results as a whole. Students will be able to determine which location is the best for plants to grow and what amount of water is the best for the plants.

Standards: 2. Communication and Collaboration Students use digital media and environments to communicate and work collaboratively, including at a distance, to support individual learning and contribute to the learning of others. a. Interact, collaborate, and publish with peers, experts, or others employing a variety of digital environments and media b. Communicate information and ideas effectively to multiple audiences using a variety of media formats c. Develop cultural understanding and global awareness by engaging with learners of other cultures d. Contribute to project teams to produce original works or solve problems 3. Research and Information Fluency Students apply digital tools to gather, evaluate, and use information. a. Plan strategies to guide inquiry b. Locate, organize, analyze, evaluate, synthesize, and ethically use information from a variety of sources and media c. Evaluate and select information sources and digital tools based on the appropriateness to specific tasks d. Process data and report results.4. Critical Thinking, Problem Solving, and Decision Making Students use critical thinking skills to plan and conduct research, manage projects, solve problems, and make informed decisions using appropriate digital tools and resources. a. Identify and define authentic problems and significant questions for investigation b. Plan and manage activities to develop a solution or complete a project c. Collect and analyze data to identify solutions and/or make informed decisions d. Use multiple processes and diverse perspectives to explore alternative solutions.6. Technology Operations and Concepts Students demonstrate a sound understanding of technology concepts, systems, and operations. a. Understand and use technology systems b. Select and use applications effectively and productively c. Troubleshoot systems and applications d. Transfer current knowledge to learning of new technologies.

Sunday, March 18, 2012

Copyright for Teachers

As a teacher it is important to be awhere of how to use copyright items within a classroom. Although many teachers probally don't think that they are doing anything unlawful when adding a picture here an there, making copies of certain writings, etc. but teachers should know and follow the copyright laws for teachers. These laws cover everything from showing a picture, making copies, showing videos, sharing music, computer software, etc.

Before reading about copyright I honestly didn't think that there were guidelines for teachers copying materials. I was really surprised that teachers can only show 10% of a video to a class or 3 minutes, whichever is shorter.

In my past classes I know that many teachers did not follow the copyright laws of printing copies to give to the class. Also I know some teachers have showed videos, music clips etc. longer then the 10% or 3 mins allowed by copyright laws. Outside of the classroom I see copyright laws being broken, just by walking down the street. Such as those t-shirt stands in the mall.

I think it is important to teach students about copyright laws. I would do this by having a display of all the laws within a classroom hanging somewhere where students can see. Also I would lead by example and follow the rules myself. I will even point out when I had to use the copyright laws.