Excel

Today we practiced our Excel skills by performing the same actions we've been learning by ourselves with a separate group of data. We learned to perform various functions: count, average, sum, and ttest. We also learned to sort data. **Beware, when sorting data more than one different way, any functions performed in the specified cell ranges may change. Reenter the numbers without the formula to ensure they stay the same. Also important to note, GoogleDocs Spreadsheet does not have the TTest. (I didn't even know about the ttest before this class). In order to keep your document exactly the same, keep it in its original format. This is my document.
This assignment fuflfills NETS Standards:

1. Facilitate and Inspire Student Learning and Creativity

b.	engage students in exploring real-world issues and solving authentic problems using digital tools and resources. We determined the average test scores by classification and gender and determined if they were statistically significant.

2. Design and Develop Digital-Age Learning Experiences and Assessments

a.	design or adapt relevant learning experiences that incorporate digital tools and resources to promote student learning and creativity.

This exercise teaches the students to use Excel.

Action Research

Using the data provided to us, we used Excel to count the number of students, the number of females, the number of males, and the numbers of traditional and non traditional students. We got both the number of each and the percentage of each. Next, we determined the average scores for each of the group.

We made a pie chart comparing the amount of girls to the amount of boys.
Next, we made graph comparing the average female score to the average male score.

Then, we made two similar charts for the traditional and non traditional students.

In Word, we created the Action Research Report, which states all the information we collected from the Excel pages. During this, we learned how to create a table without lines, common in the APA format we used for the report.

Photo Story

I found a powerpoint presentation on Greek mythology to use. I saved it to my desktop, opened it, clicked "save as", clicked "other formats", and selected the file type "jpg". This created pictures of all of my powerpoint slides. You can see the movie I created with Photo Story here.
If you would like to download the program, you can do so here.





This fulfills the NETS Standard:

3. Model Digital-Age Work and Learning;

c)_	communicate relevant information and ideas effectively to students, parents, and peers using a variety of digital-age media and formats.

How to Access My Stuff

This is the image I created with paint to show you where I store my stuff.

The good thing about storing things in a physical location is that even if the internet is down, or you are in a place without internet, you can still get to your stuff. The downside to storing things physically is that if you are away from your computer or have lost your jump drive, you do not have access to your stuff.
This upside about storing things virtually is you can access your stuff from anywhere that you have access to the internet. You cannot lose this or break it. It's there as long as you want it to be. However, if the internet is down or you are in an area where you do not have access, you cannot get to your stuff.

This assignment follows NETS Standard:

1) Facilitate Student Learning and Creativity
a) promote, support, and model creative and innovative thinking and inventiveness.

Jing Video Embed

This is the video I embedded using Jing. I went to screencast.com, opened my folder, viewed the video, clicked show details, clicked the share tab, copied the link, and pasted it into the Edit HTML tab of my blog post.

You Tube Video

Next we learned to embed a You Tube video.







This follows the NETS Standard: 
1) Facilitate and inspire student learning and creativity
b) engage students in exploring real-world issues and solving authentic problems using digital tools and resources

If you need to embed a video from YouTube on a presentation online, you can.

Jing Video How To

The video how to I made with Jing can be found here. It shows how to change the desktop background on your computer.

It fulfills the following NETS standard:

3. Model Digital-Age Work and Learning
c. communicate relevant information and ideas effectively to students, parents, and peers using a variety of digital-age media and formats.

This allows you to demonstrate how to do something. It would be useful for in class or at home if a student is having trouble or was absent from school.

Picassohead

You can find my Picassohead at this link.
Or.. on my desktop, via the Snipping Tool.

Jing

Today we learned about the program Jing. Below is the image I've created.

Here it is online. It's been saved "in the cloud" on screencast.

And here is the image I've saved to my desktop.

Make sure to update the program. None of this worked until I did.

This fits the NETS Standard:

1) Facilitate and Inspire Student Learning and Creativity
b) engage students in exploring real-world issues and solving authentic problems using digital tools and resources
For presentations, it would prove useful to be able to write and draw on images, as well as capture an image from anywhere on the screen.

Snipping Tool

Today we learned about a program in Windows Vista called the Snipping Tool.

It allows you to capture anything you want from the internet.

You can also capture screen shots from a video. The screen shot below is from the Harry Potter and the Deathly Hallows trailer, found on YouTube.

This fits NETS Standard 1b

1. Facilitate and Inspire Student Learning and Creativity
b. engage students in exploring real-world issues and solving authentic problems using digital tools and resources.

The problem is the messy aspects of screen capture. I want to capture a part of the screen for a presentation, but I do not want to do a screen capture and edit it in paint.