Sunday, February 27, 2011

Personality: #2

The results of my personality test scored me as being more of a "Guardian" than "Idealist". In my previous post, I guessed that my personality reflected more of the "idealist personality". I was not far off from my educated guess because I had chosen the "guardian personality" to be the second closest to my own personality. The knowledge of my personality type would assist me in leading a class of students, a group of teachers, or a cadre of principles because I have the personality to do a job that needs to be done. Such as teaching a class full of students, I know they need to learn the information that I have, and I make sure that it happens for them! I LOVE the fact that the "guardian personality" talks about believing in law and order and the fact that a sense of right and wrong is being lost. That fits my personality very well! I used the Jing tool to capture some of the characteristics of the Guardian Personality...just click on the picture to read it in full view!



The "Personality Assignment" reflects the ISTE.NETS STANDARD:

2b. Design and Develop Digital-Age Learning Experiences and Assessments:
develop technology-enriched learning environments that enable all students to pursue their individual curiosities and become active participants in setting their own educational goals, managing their own learning, and assessing their own progress.

Personality: #1

I have never experienced a personality test, the "personality test" for this assignment will be my first. An educated guess about which personality type fits me best, in order of most like me to least like me, would have to be:

1. Idealist
2. Guardian
3. Artisan
4. Rational

I feel that the "idealist" personality fits me pretty well. As an educator, I love to help others and do what I can to get them to achieve their goals. I am enthusiastic and trust my intuition, as well as, loving and giving. I am a nurturing and wonderful parent, and I hope that I am an inspirational leader to some! The "guardian" personality also fits me pretty well. I am a very dependable, helpful, and hard working person. I take pride in being a responsible parent and teacher. I also feel that traditions are important in my family life and working/social life. The "artisan" personality had a few traits that described me, but was not a personality that I would say "fits" me. I feel that I am fun loving, realistic, bold, and playful, as well as, a creative parent. The "rational" personality also had a couple of traits that fit me, such as being strong willed and yearning for achievement.

Spreadsheet 3: AR Spreadsheet

You can all now view my AR Spreadsheet in Google Docs! It has taken me quite a while to complete this assignment! I was very confused and finally asked a collaborative teacher I work with to give me some assistance with creating functions. I did complete the assignment in MS Excel, and I feel that it is better late than never! I did learn so many new things from completing this assignment. I learned how to create and use new functions that I had not previously known about or ever used, that I can remember!

After uploading the assignment to Google Docs, I noticed that the "averageif" formula does not transfer to Google, as well as, the charts and graphs I spent so much time completing! So, I uploaded my document and I am going to show some clips of my results in this blog post so that everyone can see that I did work hard to complete/use the functions and charts/graphs!





Research Questions:
1. I did not see where gender (male/female) scores impacted initial grade averages. The averages were very close for the pretest and post test scores. They were only a few points off from one another.

2. Classification (traditional/non traditional) impacted initial grade averages just a bit. The traditional pretest scores were somewhat higher than the non traditional (14 points), but the post test scores were only 3 points apart for each of the classifications.

3. The action research intervention did improve student learning. The post test scores were significantly higher than the pretest scores, for the gender and classification groups. The scores jumped 50 points or more for each of the groups.

I created six charts/graphs to go along with the AR Spreadsheet. Each of the charts relates to a specific criteria. The first 2 charts/graphs I completed were for the differences between gender distribution and class distribution. I had a hard time completing the charts/graphs until the first one was finished. Once I figured out how to get all the information I needed into the chart/graph, it was a breeze! The second 2 charts/graphs I created were the differences between the male/female pretest and post test scores, as well as, the differences between the traditional/non traditional pretest and post test scores. I tried to use a variety of charts/graphs to complete the assignment. The last 2 charts I completed were the gain/loss or difference between the pretest and post test scores for every student.

I did find that you can copy and past formulas and/or functions and you can use the little black handle at the bottom of the cell once you have completed a formula/function to carry it on to the next cell, eliminating you having to put the formula/function 213 times!

The Spreadsheet 3: AR Spreadsheet assignment closely relates to the ISTE.NETS Standard 3: Model Digital-Age Work and Learning because as educator's we are modeling and using current and emerging digital tools to better our technological abilities. By learning how to efficiently work through MS Excel, I will have the knowledge to pass these skills on to my students and co-workers.

Friday, February 25, 2011

Spreadsheet 2: Grades 2

For the Grades 2 Assignment, I used the Excel Spreadsheet to understand and use the numerous function tools available in MS Excel. I created final grades using functions that involved the specific assignments, tests, and projects, as well as, the specific weight or amount each item was worth, such as assignments, 25% of the grade, project, 25% of the grade, and tests, 50% of the student's grade. I then had to develop a formula to calculate the student percentages. I once again used the cell handle to drag and copy the formula from student 1 to the remaining students in the class. After the percentages for each student were calculated, I used the IF function to calculate letter grades to match the percentages. The assignment also required that I learn to use the average, max, min, and range functions to calculate each of these areas. The letter grades were then counted and placed beside the corresponding grade, such as 3 A's. The last part of the assignment allowed me to use the formatting, or fun part of Excel to add color to the background of the worksheet, as well as, border each of the cell's located in the worksheet.

I uploaded my final copy of the Grades 2 Excel Worksheet into my Google Docs. Check it out!

The Spreadsheet 2: Grades 2 Assignment closely relates to the ISTE.NETS STANDARDS:

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

Spreadsheet 1: Grades 1--Do the Numbers

For the Grades 1--Do the Numbers assignment, I used the Excel spreadsheet provided on the assignment page to average student grades, as well as, create a new page with term averages for each student. This assignment allowed me to use the average function (multiple ways), the handle tool (to copy the function from cell to cell), the copy and paste tool, and creating and naming new sheets.

I published my Excel Spreadsheet as a web document within my Google Docs.

The "Grades 1-Do the Numbers assignment relates to the ISTE.NETS STANDARD 3d because of the ability to model and facilitate effective use of current and emerging digital tools to locate, analyze, evaluate, and use information resources to support research and learning.

Google Forms

You can now take my Cell Phone Survey!



View the web published spreadsheet now!

I used the Google Edit Forms Page to create my cell phone survey.

The Google Forms assignment closely relates to the ISTE.NETS STANDARD 5a because it is modeling continuous improvement of demonstration of effective use of digital tools and resources to participate in local and global learning communities to explore create applications of technology to improve student learning.

Monday, February 14, 2011

Zoomerang

Check out my Zoomerang Survey ...or you can complete the same survey below!



The Zoomerang site was really cool because you can make up survey's or polls about anything you need information on. I think this technology tool would be excellent for the senior projects at our high school. Many of the seniors need students to complete surveys for the project part and this would be a great way to "kill 2 birds with one stone", incorporate technology in the classroom, as well as, helping seniors with their projects!

The Zoomerang assignment closely relates to the ISTE.NETS STANDARDS 1c and 2b. This assignment promotes student reflection using collaborative tools to reveal and clarify students' conceptual understanding and thinking, planning, and creative processes (1c), as well as, developing technology-enriched learning environments that enable all students to pursue their individual curiosities and become active participants in setting their own educational goals, managing their own learning, and assessing their own progress (2b).