This spreadsheet was a little more difficult to create. One of the important educational techniques we learned in this assignment was how to use your resources available to find a necessary answer. Using the help menu we had to know how to search for the specific formula that we were looking for. Once you find the formula it is easy to place into your worksheet.
This spreadsheet had a great deal to do with embedding formulas inside of other formulas by the use of parentheses. This is a more advanced area of excel, which I believe takes understanding how to read a formula. The parentheses have the same effect in excel as they do in Mathematical Operations. Whatever is inside the parentheses takes place first then you move outwards.
While this was a more difficult spreadsheet I do not feel that it was impossible to do, it just took more effort then basic calculations in Microsoft Excel.
To view my Spreadsheet Click the Link Below:
Spreadsheet 2 - Grades
ISTE-NETS-T STANDARDS
2. Design and Develop Digital-Age Learning Experiences and Assessments
Student are creating spreadsheet which are created in Microsoft Excel - this is a use of 21st Century Learning Skills as well as math skills. Student are learning calculations and different ways of determine values of data. Students are also placing that data into a visual representation - a graph. All of these tasks are done in Microsoft Excel. This standards is met by creating the spreadsheet and performing the tasks.
3. Model Digital-Age Work and Learning
This be published to google docs and placed on a blog meets this standard.
Wednesday, February 23, 2011
Thursday, February 17, 2011
Spreadsheet 1 - Grades
Microsoft Excel is a great program to use for grades and other documents in which you want to perform a calculation. In my content area I teach students how to complete these formulas and functions.
Google Documents is a great feature from google. You can upload a document onto there. Once a document is on google documents you can continue to make edits and access the document anywhere you get Internet access.
Below you will find a link to the spreadsheet I created in excel. I uploaded this spreadsheet onto google docs and published it as a web page so that you may view it at the link below.
Spreadsheet 1 - Grade Averages
ISTE-NETS-T STANDARDS
2. Design and Develop Digital-Age Learning Experiences and Assessments
Student are creating spreadsheet which are created in Microsoft Excel - this is a use of 21st Century Learning Skills as well as math skills. Student are learning calculations and different ways of determine values of data. Students are also placing that data into a visual representation - a graph. All of these tasks are done in Microsoft Excel. This standards is met by creating the spreadsheet and performing the tasks.
3. Model Digital-Age Work and Learning
This be published to google docs and placed on a blog meets this standard.
Google Documents is a great feature from google. You can upload a document onto there. Once a document is on google documents you can continue to make edits and access the document anywhere you get Internet access.
Below you will find a link to the spreadsheet I created in excel. I uploaded this spreadsheet onto google docs and published it as a web page so that you may view it at the link below.
Spreadsheet 1 - Grade Averages
ISTE-NETS-T STANDARDS
2. Design and Develop Digital-Age Learning Experiences and Assessments
Student are creating spreadsheet which are created in Microsoft Excel - this is a use of 21st Century Learning Skills as well as math skills. Student are learning calculations and different ways of determine values of data. Students are also placing that data into a visual representation - a graph. All of these tasks are done in Microsoft Excel. This standards is met by creating the spreadsheet and performing the tasks.
3. Model Digital-Age Work and Learning
This be published to google docs and placed on a blog meets this standard.
Survey - Zoomerang
In this assignment we were asked to create a survey in Zoomerang. In Zoomerang you can create free surveys in which you can choose a variety of options for your questions. I choose to do my survey on event planning. In a high school setting Student Council or the Senior Class officers will need to create an event for seniors to participate in. A good way for these students to find out what type of event their classmates would like; would be to create a survey. I created an example survey based on this idea. In this survey students are asked a variety of questions related to a senior activity or event.
I think this is a great idea to find out information about students in either your class or in the school. It can be beneficial in the educational setting in many ways. You could even ask parents to participate in a survey to help you better understand your students.
Click here to try my survey!
ISTE-NETS-T STANDARDS
1. Facilitate and Inspire Student Learning and Creativity
The creation of a survey can prove to be very beneficial in a class. It can help you to obtain student interest or even modalities of learning based on the class. It is a great way to use technology while discover important aspects about your students. Through the creative design you are making learning fun.
2. Design and Develop Digital-Age Learning Experiences and Assessments
As stated above the design of this and the availability of it being on the Internet makes this a digital age work and learning experience. A survey requires you to answer questions and could even be used as formative assessments through a lesson.
I think this is a great idea to find out information about students in either your class or in the school. It can be beneficial in the educational setting in many ways. You could even ask parents to participate in a survey to help you better understand your students.
Click here to try my survey!
ISTE-NETS-T STANDARDS
1. Facilitate and Inspire Student Learning and Creativity
The creation of a survey can prove to be very beneficial in a class. It can help you to obtain student interest or even modalities of learning based on the class. It is a great way to use technology while discover important aspects about your students. Through the creative design you are making learning fun.
2. Design and Develop Digital-Age Learning Experiences and Assessments
As stated above the design of this and the availability of it being on the Internet makes this a digital age work and learning experience. A survey requires you to answer questions and could even be used as formative assessments through a lesson.
Wednesday, February 16, 2011
Google Form
We were asked to create a form. At first I was going to choose an educational item to do a form on, then I decided to do a survey on something a little more fun. I choose to do a survey on Pets. This could be used for personal use or use in the classroom as an ice breaker on the first day. There are many other additional topics that you could use as a survey for the purpose of an ice breaker. Google even gives you the option of creating a summary of the data. If you are to use quantitative data you will be able to represent your results in a graph and use that as a class discussion, if you do not want to single out students. This is a neat tool that can really aid in classroom instruction.
Below you will find my survey. Try it!
ISTE-NETS-T STANDARDS
2. Design and Develop Digital-Age Learning Experiences and Assessments
This standard is met by the creation of a form. A form that is on the Internet and students can enter information into, then that information is transferred to a spreadsheet. There are a variety of features that can be used with the data such as the creation of graphs and charts that represent the data.
Below you will find my survey. Try it!
ISTE-NETS-T STANDARDS
2. Design and Develop Digital-Age Learning Experiences and Assessments
This standard is met by the creation of a form. A form that is on the Internet and students can enter information into, then that information is transferred to a spreadsheet. There are a variety of features that can be used with the data such as the creation of graphs and charts that represent the data.
Tuesday, February 8, 2011
Online Graphing Tool
Online Graphing Tool
There are a variety of ways that one can create a graph, using a graphing program, Microsoft excel or word, or using an online resource. In this activity we used Kid's Zone - Create a Graph, to create our graph. This is a very simple program to use in which you simply choose the design of your graph and enter the necessary data, the site will produce the graph for you to be saved in a variety of file formats or even e-mailed to you. This is a great tool, that could be used in many classrooms at all levels. It will serve as a great visual aid tool in classrooms, to help the visual learners.
Document 1 - Proposal for Funding to aid in Math Scores
Document 2 - Defense of West Virginia Scores Compared to National Average
Graph 1
To visit the site which provided me with the necessary data for chart 1, please click the link below:
National Center for Education Statistics - 4th Grade Mathematical Stats for West Virginia
Graph 2
To visit the site which provided me with the necessary data for chart 2, please click the link below:
National Center for Education Statistics - 8th Grade Reading Stats for West Virginia
ISTE-NETS-T STANDARDS
2. Design and Develop Digital-Age Learning Experiences and Assessments
This standard is met by the creation of the graph online. This can be used to demonstrate, or produce class results in a visual format. The students could also use this to produce results of an experiment or other work in a digital/visual format.
3. Model Digital-Age Work and Learning
As mentioned above students can produce a digital/visual representation of data.
There are a variety of ways that one can create a graph, using a graphing program, Microsoft excel or word, or using an online resource. In this activity we used Kid's Zone - Create a Graph, to create our graph. This is a very simple program to use in which you simply choose the design of your graph and enter the necessary data, the site will produce the graph for you to be saved in a variety of file formats or even e-mailed to you. This is a great tool, that could be used in many classrooms at all levels. It will serve as a great visual aid tool in classrooms, to help the visual learners.
Document 1 - Proposal for Funding to aid in Math Scores
Document 2 - Defense of West Virginia Scores Compared to National Average
Graph 1
To visit the site which provided me with the necessary data for chart 1, please click the link below:
National Center for Education Statistics - 4th Grade Mathematical Stats for West Virginia
Graph 2
To visit the site which provided me with the necessary data for chart 2, please click the link below:
National Center for Education Statistics - 8th Grade Reading Stats for West Virginia
ISTE-NETS-T STANDARDS
2. Design and Develop Digital-Age Learning Experiences and Assessments
This standard is met by the creation of the graph online. This can be used to demonstrate, or produce class results in a visual format. The students could also use this to produce results of an experiment or other work in a digital/visual format.
3. Model Digital-Age Work and Learning
As mentioned above students can produce a digital/visual representation of data.
Monday, February 7, 2011
Jing Screencast
As an educator Jing is a great tool. Especially if you are planning on being out of the classroom and need to explain something to your students that a substitute might not be able to, Jing will work wonders. It is a great tool to use wether you are in the classroom, or out of the classroom. If you have a website for your class, you could add the link onto your website as an instructional/study aid to your students. There are a variety of ways that Jing could be useful to an educator.
I chose to do my Jing Screencast on Microsoft 2008 on a MAC computer. As the school I did my student teaching in had Mac computers and the students were using Microsoft 2008, this would be a great instructional tool. In this short video I describe and show some of the options in Microsoft 2008 and compare those options to Microsoft Word used on a windows operating system.
Jing screencast
ISTE-NETS-T STANDARDS
This meets the following standards because you are creating a video that can be used for instruction purposes. The video is a use of 21st Century Learning skills or a production of Digital Age Work. By the use of the video you are encourgaing learning and participation, while demonstrating and teaching new skills.
1. Facilitate and Inspire Student Learning and Creativity
2. Design and Develop Digital-Age Learning Experiences and Assessments
3. Model Digital-Age Work and Learning
I chose to do my Jing Screencast on Microsoft 2008 on a MAC computer. As the school I did my student teaching in had Mac computers and the students were using Microsoft 2008, this would be a great instructional tool. In this short video I describe and show some of the options in Microsoft 2008 and compare those options to Microsoft Word used on a windows operating system.
Jing screencast
ISTE-NETS-T STANDARDS
This meets the following standards because you are creating a video that can be used for instruction purposes. The video is a use of 21st Century Learning skills or a production of Digital Age Work. By the use of the video you are encourgaing learning and participation, while demonstrating and teaching new skills.
1. Facilitate and Inspire Student Learning and Creativity
2. Design and Develop Digital-Age Learning Experiences and Assessments
3. Model Digital-Age Work and Learning
Jing Graphic
Using Jing you can create many educational aids for the classroom. Below you will see an example of an educational aid I would use in a classroom when explaining how to insert a new slide into PowerPoint. I could also place blanks where the text is and use this as a formative assessment.
ISTE-NETS-T STANDARDS
1. Facilitate and Inspire Student Learning and Creativity
This standard is met through the creation of a image that can aid in the visual learners learning. It can help to demonstrate and emphasize what is being taught. The creativity is that it is a snap shot of work actually done by the instructor, rahter than a text book produced image.
2. Design and Develop Digital-Age Learning Experiences and Assessments
The creation of the image and the implmentation of it meets this standard. A jing graphic could also be used on a test for labeling or explaing what is happening.
3. Model Digital-Age Work and Learning
The use of Jing is technology and digital age work, by using this you are creating encourgament of 21st Century Learning skills and the use of those skills in work.
ISTE-NETS-T STANDARDS
1. Facilitate and Inspire Student Learning and Creativity
This standard is met through the creation of a image that can aid in the visual learners learning. It can help to demonstrate and emphasize what is being taught. The creativity is that it is a snap shot of work actually done by the instructor, rahter than a text book produced image.
2. Design and Develop Digital-Age Learning Experiences and Assessments
The creation of the image and the implmentation of it meets this standard. A jing graphic could also be used on a test for labeling or explaing what is happening.
3. Model Digital-Age Work and Learning
The use of Jing is technology and digital age work, by using this you are creating encourgament of 21st Century Learning skills and the use of those skills in work.
Wordle
I chose to do my wordle on Technology and the Economy. As a Business Education Teacher the economy and the way technology affects our daily lives are daily topics. It would be a great introductory lesson for a Introduction to Business class as you study technology and the economy specifically and the how they impact each other. This tool could come in very handy in the classroom.
Technology and the Economy Wordle.
ISTE-NETS-T STANDARDS
1. Facilitate and Inspire Student Learning and Creativity
This standard is met by inquiring information or words or content and creating an digital image that emphasizes the important parts of the concept being learned. This is a great way to show main points or emphasize parts of content.
2. Design and Develop Digital-Age Learning Experiences and Assessments
As a class or as an individual a wordle can be created to digital represent ideas and emphasize parts of an idea.
Technology and the Economy Wordle.
ISTE-NETS-T STANDARDS
1. Facilitate and Inspire Student Learning and Creativity
This standard is met by inquiring information or words or content and creating an digital image that emphasizes the important parts of the concept being learned. This is a great way to show main points or emphasize parts of content.
2. Design and Develop Digital-Age Learning Experiences and Assessments
As a class or as an individual a wordle can be created to digital represent ideas and emphasize parts of an idea.
Thursday, February 3, 2011
Batchgeo - Map It
Batchgeo is a program in which you can provide information about locations and create a map. This is a great tool and the best part is that it's FREE!
Education is ever changing by the advances in education, with each new day we are able to incorporate technology into our lessons. Technology helps grasp the attention of our students and improve their learning expereince. As educators we need to be prepared for daily changes in the world of technology and be prepared to adapt to those changes.
This activity is great in aiding 21st Century Skills as an educator. This cool activity could be used in classrooms ranging from the elementary schools up to the high schools. It would be a great activity for geography classes or sciences classes wishes to represent a map with locations. In a classroom setting you could use the student's addresses, addresses of differnt businesses, or addresses of various important locations. This is a great tool to use in many different lessons and classes. It applies to the different modalities of learning and aids the students who are visual learners!
Below you will see the map I created using the information provided by my classmates in the shared google document.
To view my map at a diffent Location Click Here.
ISTE-NETS-T STANDARDS
2. Design and Develop Digital-Age Learning Experiences and Assessments
This standard is met by the use of technology and content togehter to create an image. The students are actulay inputing the information and then creating a map or an image of a map from their inputs. This allows the student to create a digital image and could be used as an assesment in a geography or science class when studying locations.
3. Model Digital-Age Work and Learning
The student are producing the map, so they are creating a digital image that is presentable to be modeled. The teacher could demonstrate this concept before hand to meet this standard as well.
4. Promote and Model Digital Citizenship and Responsibility
I decided to put this standard down because you are creating a map based on locations, so you could discuss issues such as citizenship.
Education is ever changing by the advances in education, with each new day we are able to incorporate technology into our lessons. Technology helps grasp the attention of our students and improve their learning expereince. As educators we need to be prepared for daily changes in the world of technology and be prepared to adapt to those changes.
This activity is great in aiding 21st Century Skills as an educator. This cool activity could be used in classrooms ranging from the elementary schools up to the high schools. It would be a great activity for geography classes or sciences classes wishes to represent a map with locations. In a classroom setting you could use the student's addresses, addresses of differnt businesses, or addresses of various important locations. This is a great tool to use in many different lessons and classes. It applies to the different modalities of learning and aids the students who are visual learners!
Below you will see the map I created using the information provided by my classmates in the shared google document.
View Map of Students in EDUC 6305 in a full screen map
To view my map at a diffent Location Click Here.
ISTE-NETS-T STANDARDS
2. Design and Develop Digital-Age Learning Experiences and Assessments
This standard is met by the use of technology and content togehter to create an image. The students are actulay inputing the information and then creating a map or an image of a map from their inputs. This allows the student to create a digital image and could be used as an assesment in a geography or science class when studying locations.
3. Model Digital-Age Work and Learning
The student are producing the map, so they are creating a digital image that is presentable to be modeled. The teacher could demonstrate this concept before hand to meet this standard as well.
4. Promote and Model Digital Citizenship and Responsibility
I decided to put this standard down because you are creating a map based on locations, so you could discuss issues such as citizenship.
Tuesday, February 1, 2011
Self- Portrait
Using Picassohead was very interesting to say the least. At first I was frustrated that I couldn't get my self portrait to look the way I wanted it too; however after messing with the features I found that you could overlap the options to make the appearance of the Picassohead appear the way you wanted. I think this was a very easy program to use.
This could be used in the classroom when talking about technology and the representation of yourself. In a high school setting this could be used in both Technology Courses and Psychology Course very easy, with the students explaining why the represented their self in the way they did, and how technology helped them create this representation.
I used the the Picassohead Website to create my image.
Below you will see the image I created.
Self-Portrait by Sarah: "Picassohead"
ISTE-NETS-T STANDARDS
1. Facilitate and Inspire Student Learning and Creativity
This standard is met by the use of 21st Century Learning skills and they ability for students to use their creativity and imagination to create images. This could be used to intertwine creativity and content to provide a meaningful learning experience for the student.
2. Design and Develop Digital-Age Learning Experiences and Assessments
The actual design of the portrait or the image meets this standards criteria.
3. Model Digital-Age Work and Learning
Since this can easily be saved to a computer or published, the availability and possibilities of displaying this work are endless. It would be easy for both the student and the teacher to demonstrated Digital Age Work.
This could be used in the classroom when talking about technology and the representation of yourself. In a high school setting this could be used in both Technology Courses and Psychology Course very easy, with the students explaining why the represented their self in the way they did, and how technology helped them create this representation.
I used the the Picassohead Website to create my image.
Below you will see the image I created.
Self-Portrait by Sarah: "Picassohead"
ISTE-NETS-T STANDARDS
1. Facilitate and Inspire Student Learning and Creativity
This standard is met by the use of 21st Century Learning skills and they ability for students to use their creativity and imagination to create images. This could be used to intertwine creativity and content to provide a meaningful learning experience for the student.
2. Design and Develop Digital-Age Learning Experiences and Assessments
The actual design of the portrait or the image meets this standards criteria.
3. Model Digital-Age Work and Learning
Since this can easily be saved to a computer or published, the availability and possibilities of displaying this work are endless. It would be easy for both the student and the teacher to demonstrated Digital Age Work.
Snipping Tool
The Snipping Tool is a tool that is used on a Microsoft Operating System to capture a part of the screen and saved that capture in a picture format for later use. This is a great tool, and while I was aware of the screen shot option, I was unaware of the Snipping Tool. I have a Macbook and in the Linux Operating System it is called the Grab Tool and is used in a very similar way, with similar results. For this project I had to use a computer with a Microsoft Operating System, so I could complete the necessary steps.
Below you will find the image I captured using the Snipping Tool.
I created this document, and used the Snipping Tool to demonstrate how the use of the Snipping Tool would be beneficial to me. I could use this image in a Business Computer Application Course when we are concentrating on Excel Instruction. Using the specific Image I could show what the SUM Function looks like, and how it should be correctly typed. This will prove to be very beneficial in a classroom setting.
ISTE-NETS-T STANDARDS
2. Design and Develop Digital-Age Learning Experiences and Assessments
By using the snipping tool to take basically a snap or screen shot of a document or a web page or basically anything that could be used for educational purposes meets the criteria of this assignment. We are using technology and then taking a snap of that technology to explain and teach our students with.
3. Model Digital-Age Work and Learning
By presenting this document weather it be used in the classroom or just being placed on our blog, we are demonstrating our use of technology and how it can aid in classroom instruction. As well it will help our students to understand that we are technology savy as well!
Below you will find the image I captured using the Snipping Tool.
I created this document, and used the Snipping Tool to demonstrate how the use of the Snipping Tool would be beneficial to me. I could use this image in a Business Computer Application Course when we are concentrating on Excel Instruction. Using the specific Image I could show what the SUM Function looks like, and how it should be correctly typed. This will prove to be very beneficial in a classroom setting.
ISTE-NETS-T STANDARDS
2. Design and Develop Digital-Age Learning Experiences and Assessments
By using the snipping tool to take basically a snap or screen shot of a document or a web page or basically anything that could be used for educational purposes meets the criteria of this assignment. We are using technology and then taking a snap of that technology to explain and teach our students with.
3. Model Digital-Age Work and Learning
By presenting this document weather it be used in the classroom or just being placed on our blog, we are demonstrating our use of technology and how it can aid in classroom instruction. As well it will help our students to understand that we are technology savy as well!
Subscribe to:
Comments (Atom)