Excel 2

                                       This is a example of my t-test

This assignment was to create a second Excel using the data from the previous Excel. I have to admit that I  am still confused of how I created this Excel using the t-test. I followed the demonstration provided in the instructions. I am currently taken the course 6301, which we have to write a Research Action Proposal. I am not sure if I will have to use the t-test in the future but I would prefer not too! LOL

The independent variable is gender male/female. The continuous dependent variable is NAEP  2011 4th grade state reading averages. The research question is does student's gender impact 4 th grade reading performance? The data shows that the female scores are higher than males scores. The answer is to reject null difference, because the gender is a factor in the 4thgrade reading performance.

My research topic is Does Ipads apps a more effective learning tool vs. hands- on activities? The independent variables will be the apps and hands-on activities. The continuous variable will be my Pre-k students.  My hypothesis is that the hands-on activities are more effective learning tool in a Pre-k classroom. The null hypothesis is that there is no difference between Ipad apps or hands-on activities.

ISTE-NETS- T Standard Model Digital Age Work and Learning 3d. This is a digital tool that can support research and learning. A student can apply a t-test to their data that they have collected to analysis it.

Excel 1 Basic Skills

I have never used Excel before. I usually made a spreadsheet or table in windows. I had to use my old computer bcause my Mac won't allow me to Data Analysis Tool Pack. Th e assignment was to create a spreadsheet using the NAEP State Comparisons of the 4th grade reading level and compare it to the state we live in. How is the state of  West Virginia compared to other states: West Virginia is ranked 43 out of 52 (50 states and the District of Columbia & National Average). There are 34 states above West Virginia and 9 states below. According, to the chart West Virginia is below the National Average.

ISTE-NETS-T Standard: Facilitate and Inspire Student Learning and Creativity 1c. Excel is a tool that can provide a visual aide to learning.

Rubrics

Rubistar is a great website to create rubrics! I wish I had this tool last Spring when I was teaching Health & Safety. I had to create my own and was completely confused. I had no idea that there was too to help you create one. This is definitely a tool I will use in the future and will pass on to my fellow teachers. I decided to create a rubric to help my grade my end of semester group presentation.






ISTE-NETS T  Standards: Design and Develop Digital Age Learning Experiences and Assessments 2d. This digital tool provides teachers with a resource  to assess student progress.
Engage in Professional Growth and Leadership 5c. I feel this tool fits into this categories because a teacher can use this tool to evaluate student's work and well as a director or administrator could use this tool to evaluate a teacher's performance on emerging digital tools into the classroom.

Google Earth

The assignment was to install Goggle Earth and type in my address. I found the street I live on my I didn't see the my actual house, but I still think it was in high resolution. I think that it was in high resolution because you could see the road and other landmarks.

The other part of the assignment was to use a KML file, but I still have no idea what this means. I did use the the link for KML and e-mailed it to myself and to took a snap shoot with Jing.
                     
                                                   My House



You can import a map from Google Maps  to Google Earth by adding the address you are searching for and switching in between Satellite and Earth view. It feature can give you a more detailed view of the address or place you are searching for. This a great tool to search for places that your class is learning about or just to show the children where they are at. There is also a feature to show the view from moon, stars, etc.. I wish I knew about this tool last Spring when my preschoolers were interested in studying the Solar System. The would have loved to see the satellite view of their classroom.

Goggle Earth for Educators is a great website to get lessons or add lesson plan to for our teachers to use.  I  found a lesson plan on Solar System, but it designed for a 5th grade class. I could use part of the lesson or adjust it to a preschool school level.

ISTE-NETS-A  Standard: Digital Age Learning Culture 2a. This is a digital tool that can improve continuous learning by giving students and teachers a tool to enhance learning of maps.

ISTE-NETS-T  Standard: Model Digital Age Work and Learning 3c. This is a great tool to encourage students to show their knowledge of skills to their peers using a digital tool. This digital tool can help students look up locations or places that they might be exploring in the classroom or that they  could use for a classroom presentation.

Goggle Maps

The assignment was to chose a city and a topic and create a map. I chose New York City! One of my preschoolers visited New York City, last Spring with his family on Spring Break. When he came back he he shared all his experiences with his classmates. He explored several skyscrapers, bridges, train stations and the Statue of Liberty. Before, he left for his trip the class was exploring skyscrappers, buildings and talking about construction workers, tools and their machines. The class was so excited to hear and see all his photos from Face book. Our project about Skyscrapers/Buildings turned into a project about trains and train stations.

As a preschool teacher, the first thing I did to complete this assignment was to create a web of ideas, about New York City!

The assignment also asked to pick a topic but my topic is New York City.  I could just pick skyscrapers, trains, zoo, Islands , or bridges, but New York City is a topic in it's self. No one goes to New York to just tour one topic! New York City is one of the most popular cities in the United States!  

Since, it is a preschool class if we were to take a real field trip there, the parents would have to accompany the children. The children would love a virtual tour of New York, cause when you click on an area on the map it shows the Satellite and Earth image (actual picture).

Map of New York City

I will use this tool in my classroom, help enhance my student's learning.

ISTE-NETS-T
Facilitate and Inspire Student Learning and Creativity-1b- because it is a digital tool, that can allow teachers and students to use a digital tool to take a virtual tour of a city, without leaving the classroom.

Model Digital Age Work and Learning- 3b- students, peers, parents and community members can use this digital tool to support student success by creating a virtual tour of a city that they might be focusing on in the classroom or at a after-school community project. Any one could use this tool to create a virtual tour of a city to become more familiar with if and to learn what how to use maps.

Self-Grading Form

I was so confused at first! I thought that I could use the previous Goggle Form to make my self-grading form, but the form was a parent survey and not a test or quiz. So, I developed a Health & Safety Quiz for the Early Childhood course that I will be teaching in the fall. I created a spreadsheet with the responses. I watched the YouTube video to help to create my spreadsheet, but the formula still didn't work for me I used it like 20 times. I was able to get all the columns graded but I had to figure out the average by myself ( I am sure I did something wrong).

I mostly likely will use Google Forms to create most of my quizzes and test in my Health & Safety class. I like the idea that it will grade your quizzes and test for you. Once, I figure that part of I will love it. I would prefer not to have to grade 25 tests by hand. 

ISTE.NETS-T 2. Design and Develop Digital Age Learning Experiences and Assessments.

Standard d. Using Goggle Forms and creating a spreadsheet is a great way to assess student learning.

5. Engage in Professional Growth and Leadership

Standard c. The Self-grading form is a new digital tool, that can help teachers to develop professional growth. My goal is to use it to digital to promote my professional growth!