We were asked to create a form that is self grading. I also found a blog that gives you more directions in making a self- grading form: Self-grading multiple-choice tests with Google Docs I found this bloggers directions to be very helpful and easy to follow.
Here is my form: Math Quiz
Here is my spreadsheet: Math Quiz Spreadsheet/Grades
How neat is it that you can create a quiz that grades itself for you? I thought that making a survey was cool. I used Google Docs to create a Form that was self-grading. I made it a 5 question math quiz similar to what questions one would find on the ACT.
Just like when I made the survey, you are able to add themes to your self-grading quiz in order to make it more visibly appealing to those who are taking it. Help text is also an option to make it easier for your participants to answer your questions.
Once you have a form/quiz made, you can share it with the public or if you’d rather you could share it with your choice of people. I chose to share mine with the public. When I clicked Share on Google Docs I made it open to the public so that you didn’t have to be a Google Docs user or logged into your Google account to fill it out. I shared it with my Google circle, emailed it to a few students in my class, and posted the link on Facebook in order to get a good number of responses.
Here’s the cool part. Once a student submits their responses, you can write a formula in the spreadsheet that will grade their answers for you and even give you a percentage! See my spreadsheet (above) for grading examples.
I went above and beyond on this due to all of the excited participants who were eager to learn. You have the option of changing the message people receive after completing the quiz. Well, I made a Google Docs Presentation containing the answer and the work to get the answers, so that people can see how they did. This will be useful when I use this with my 7th & 8th grade classes that I am observing with because after they take the quiz we can go over it together as a class with a Slideshow presentation.
ISTE NETS T - Standard 1 & 2- Standard 1. During this activity, students are expected to complete an assignment using digital tools, technology system and media (Google Forms). Students are expected to be active in their own learning and understanding of the content. Digital communication aides in the advancement of resources and support. Standard 2. Design and Develop Digital-Age Learning Experiences and Assessments. This assignment was to design and develop an assessment digitally.
Tuesday, March 27, 2012
Monday, March 26, 2012
Google Forms
We were asked to make a Google form. I decided to make mine about math, since that is what I got my undergrad in. My form is about your math background. I made it to learn more about people’s math background and past math experiences.
Google forms is actually a pretty neat tool. You can create online quizzes, surveys, or any type of questionnaire you want. There are many different question types you can use that all send data straight into a useable spreadsheet. With these answers you could even do statistical analysis testing to determine various outcomes.
You are also able to add themes to your survey/questionnaire in order to make it more visibly appealing to those who are taking it. Help text is also an option to make it easier for your participants to answer your questions.
Once you have a form made, you can share it with the public or if you’d rather you could share it with your choice of people. I chose to chare mine with the public. When I clicked Share on Google Docs I made it open to the public so that you didn’t have to be a Google Docs user or logged into your Google account to fill it out. I shared it with my Google circle, emailed it to a few students in my class, and posted the link on Facebook in order to get a good number of people to take it.
Forms and surveys like this could be used in professional life. Being a teacher you could use this for qualitative and quantitative research data collecting. There are various types of questions and all give you various outputs of data that can be manipulated and used. You can view the form as embedded into another website or by clicking a hyperlink on a webpage or in an email. There are various views including; the Live Form, the spreadsheet, and the summary of the results. The form is basically a nice mask for the spreadsheet. You could ask people to fill in their answers on a spreadsheet to use later or you could give them a visually appealing and better explained Google Form so that it is easier on them and you end up with the data organized into a spreadsheet for you. Like I said earlier, there are many ways to share the survey. You can publish it to public on Google, you can email it to whomever you please, you can embed it into a website, or even hyperlink it into a website. The results can be viewed upon competition of the survey in a summary of the results or you can view them in spreadsheet format.
ISTE NETS T - Standard 1 & 2- Standard 1. During this activity, students are expected to complete an assignment using digital tools, technology system and media (Google Forms). Students are expected to be active in their own learning and understanding of the content. Digital communication aides in the advancement of resources and support. Standard 2. Design and Develop Digital-Age Learning Experiences and Assessments. This assignment was to design and develop an assessment/survey digitally.
Tuesday, March 20, 2012
APA Paper
Phew. Glad that one is over and handed in. The assignment was to write up a results section, in APA format, for various influences on quiz scores.
We were given the data in excel and had to manipulate it in order to determine if any of the following things had a significant influence on quiz scores: personality (introvert or extrovert), sex (male or female), teaching status (teaching or non-teaching), age and millennial score.
At first I struggled with setting up the second set of data,
that was needed to complete the second table, but it was
because I was comparing apples to oranges. Once I got
that straightened out, the rest of the data manipulation
and testing went fine.
Once the t-tests were complete and the p values were found for each section a paper could be formed. We were to write a "results" section of a paper containing the data that we manipulated earlier to demonstrate our abilities in spreadsheets, word processing, and APA formatting.
The most trying part of this assigment was formatting. Two
different websites were given to explain APA formatting.
One for APA formatting and one for journal formatting.
Having both websites as explanations was confusing as they
had conflicting advice. I posted a discussion question on
Blackboard: "Do we single space (journal website) or double
space (general apa guidelines) and do we change paper size
and such like journals?Also, page numbers top right (general
apa format) or bottom center (journal format)? Pierce
emailed us: double and topright, which are both basic
APA format and not journal format. Once I got that part
figured out I completed my paper and submitted.
The outcomes of this assigment were to understand APA formatting for numbers, tables, style, text, t-test findings, and references. Also, to be able to develop, test, and interpret results of a hypothesis using bivvariate analysis in spreadsheet form and to develop a narrative paper in APA style to write up the results. I believe that I accomplished all of these otucomes and have a better understanding of all of those things (that is before my paper has been graded). If I had to compelte this assigment again, after learning what I learned about formatting and statistical tests I believe that I could cut the amount of hours that I put into this paper at least in half if not more.
*** I did ok on the paper, not quite qhat I expected, but not bad. There were a couple of things that I needed to work on a little harder. I didnt have APA quite right for discussing the tables but upon reviewing more research papers I am learning a lot more. I do feel comfortable with organizing and manipulating data in excel and I am pretty confident in my formatting of tables APA in a sense that if I had to do this all over again I would do it much better and probably much quicker.
ISTE NETS T - Standard 3a,b,d: Model Digital - Teachers exhibit knowledge, skills, and work processes representative of an innovative professional in a global and digital society. Teachers: a)demonstrate fluency in technology systems and transfre of current knowledge to new technologies and situations. Ive never used t tests before this class. I have seen p values but didnt understand what they came from, so I could apply my knowledge from statistics classes to this assignment and I will be able to apply this assigment to future assigments. b)collaborate with peers using digital tools and resources to support student success and innovation. Me and a couple of the other students in this class collaborated over email, im, and in person. d) Model and facilitate effective use of current and emerging digital tools to locate, analyze, evaluate, and use information resources to support research and learning. I had to use excel to complete these t-tests and analyze the data given.
We were given the data in excel and had to manipulate it in order to determine if any of the following things had a significant influence on quiz scores: personality (introvert or extrovert), sex (male or female), teaching status (teaching or non-teaching), age and millennial score.
At first I struggled with setting up the second set of data,
that was needed to complete the second table, but it was
because I was comparing apples to oranges. Once I got
that straightened out, the rest of the data manipulation
and testing went fine.
Once the t-tests were complete and the p values were found for each section a paper could be formed. We were to write a "results" section of a paper containing the data that we manipulated earlier to demonstrate our abilities in spreadsheets, word processing, and APA formatting.
The most trying part of this assigment was formatting. Two
different websites were given to explain APA formatting.
One for APA formatting and one for journal formatting.
Having both websites as explanations was confusing as they
had conflicting advice. I posted a discussion question on
Blackboard: "Do we single space (journal website) or double
space (general apa guidelines) and do we change paper size
and such like journals?Also, page numbers top right (general
apa format) or bottom center (journal format)? Pierce
emailed us: double and topright, which are both basic
APA format and not journal format. Once I got that part
figured out I completed my paper and submitted.
The outcomes of this assigment were to understand APA formatting for numbers, tables, style, text, t-test findings, and references. Also, to be able to develop, test, and interpret results of a hypothesis using bivvariate analysis in spreadsheet form and to develop a narrative paper in APA style to write up the results. I believe that I accomplished all of these otucomes and have a better understanding of all of those things (that is before my paper has been graded). If I had to compelte this assigment again, after learning what I learned about formatting and statistical tests I believe that I could cut the amount of hours that I put into this paper at least in half if not more.
*** I did ok on the paper, not quite qhat I expected, but not bad. There were a couple of things that I needed to work on a little harder. I didnt have APA quite right for discussing the tables but upon reviewing more research papers I am learning a lot more. I do feel comfortable with organizing and manipulating data in excel and I am pretty confident in my formatting of tables APA in a sense that if I had to do this all over again I would do it much better and probably much quicker.
ISTE NETS T - Standard 3a,b,d: Model Digital - Teachers exhibit knowledge, skills, and work processes representative of an innovative professional in a global and digital society. Teachers: a)demonstrate fluency in technology systems and transfre of current knowledge to new technologies and situations. Ive never used t tests before this class. I have seen p values but didnt understand what they came from, so I could apply my knowledge from statistics classes to this assignment and I will be able to apply this assigment to future assigments. b)collaborate with peers using digital tools and resources to support student success and innovation. Me and a couple of the other students in this class collaborated over email, im, and in person. d) Model and facilitate effective use of current and emerging digital tools to locate, analyze, evaluate, and use information resources to support research and learning. I had to use excel to complete these t-tests and analyze the data given.
Subscribe to:
Posts (Atom)