I have included the MS Excel version and the Google Spreadsheets version. It seems that the functions are only viewable in Excel.
Microsoft Excel
http://www2.fairmontstate.edu//users/jarant/EDUC6305SS2Grades2.xls
Google Spreadsheets
http://spreadsheets.google.com/pub?key=pLpsg_-9TutTA1sQlNxgBKA
Tuesday, June 24, 2008
Wednesday, June 18, 2008
SS-1 Grades 1
Below is the link to my Google spreadsheet and an itemized list of answers to the questions. The questions were answered based on the data in the spreadsheet.
http://spreadsheets.google.com/pub?key=pLpsg_-9TutQ93Qv8GHQHOw
Q: What was the overall class average?
A: 85.9333333333334%
Q: Which student had the highest average?
A: Helen Ochallaghan (91.8333333333333%)
Q: Which student had the lowest average?
A: Freta Washington (73.1666666666667%)
Q: Sort the students by average descending with the highest average on top.
A: DONE
Q: Based upon the scores which assignment was the most difficult?
A: The assignment given on 9/19/2008 was probably the most difficult because it had the lowest average score.
Q: Create a visual aide (Chart) to show the averages and student names. Question: How do you graph labels and data in columns that are noncontiguous? As you probably know the ctrl key does this in Excel. Google requires a work around.
A: DONE
Q: Upload and publish your completed document into a sheet in your online spreadsheet. Rename the sheet Grades 1.
A: DONE
http://spreadsheets.google.com/pub?key=pLpsg_-9TutQ93Qv8GHQHOw
Q: What was the overall class average?
A: 85.9333333333334%
Q: Which student had the highest average?
A: Helen Ochallaghan (91.8333333333333%)
Q: Which student had the lowest average?
A: Freta Washington (73.1666666666667%)
Q: Sort the students by average descending with the highest average on top.
A: DONE
Q: Based upon the scores which assignment was the most difficult?
A: The assignment given on 9/19/2008 was probably the most difficult because it had the lowest average score.
Q: Create a visual aide (Chart) to show the averages and student names. Question: How do you graph labels and data in columns that are noncontiguous? As you probably know the ctrl key does this in Excel. Google requires a work around.
A: DONE
Q: Upload and publish your completed document into a sheet in your online spreadsheet. Rename the sheet Grades 1.
A: DONE
Sunday, June 15, 2008
Visual Literacy Reflections Assignment - ftp
http://www2.fairmontstate.edu//users/jarant/EDUC6305VisualLiteracyReflectionsAssignment.doc
This time, I tried saving it to my ftp account and putting the link here. Let's see how this works out for us.
This time, I tried saving it to my ftp account and putting the link here. Let's see how this works out for us.
Week Four Reflections
This week, I created a web page with three graphs and a spreadsheet available on it. One of the graphs showed WV math scale scores for the fourth grade compared to the national average. The two line graphs compared a state's per capita income to the number and proportion of total students with an IEP. I also included a Google spreadsheet with the information contained on the two line graphs. The big assignment this week has been the reflections assignment. In this document, I explain how our activities in the visual literacy module apply to the ISTE NETS T and INTASC standards as well as the six cognitive levels of Bloom's taxonomy. In addition, I explained some possible applications for these new technology uses in the classroom. I also reflected on their uses globally. I am excited about using these new things in my classroom next year.
Reflections Assignment - as a Google Doc
I do not know how to attach an MS Word document to blog, so I uploaded my assignment as a google doc because I'm not sure what else to do. Copy and paste would be an unbearable amount of text in the post. Here is the link to the google doc.
http://docs.google.com/Doc?id=dhcjqwjv_1458ndpk6k
http://docs.google.com/Doc?id=dhcjqwjv_1458ndpk6k
Monday, June 9, 2008
Online Graphic Tools Assignment
http://joshuaarant.googlepages.com/onlinegrapgictools-educ6305
I believe this is now a finished product. The web page linked here contains the components for the Online Graphic Tools assignment. Please let me know if you experience any problems. Enjoy!
I believe this is now a finished product. The web page linked here contains the components for the Online Graphic Tools assignment. Please let me know if you experience any problems. Enjoy!
Saturday, June 7, 2008
Image Formats Narrative - Full Text Copy and Paste
Joshua Arant
EDUC 6305
Image Formats – Narrative
I have searched for images online that speak to who I am as a person. I chose an image of the Grand Canyon and Mt. Everest because I love travel and hiking (although I am not crazy enough to try Everest), two photographs of space images because I am fascinated by the universe’s size and the many facets of astronomy (as I mentioned in my photo story), and one animated picture of the gang of peanuts characters (i.e. Charlie Brown and Snoopy) because I have always loved the program. I have been looking at the names, sizes, and type of files. Below is a link to a spreadsheet where I present the name, size, file type, and date modified for the five files I used for this assignment.
http://spreadsheets.google.com/pub?key=pLpsg_-9TutQ0QxIBne7FPQ
I have learned a great deal about how to navigate through the desktop to find images that I have downloaded from the internet. I can see that images and graphics vary greatly in the way they are formatted on the computer and that many different types of image formats exist. The same image can be converted to different file types, and this often changes the file size and the picture quality. Picasa seems to be a great program for organizing images, and I love that it is set up to automatically post any of your images to your blog. This program brings all of your image files to one location while maintaining your original organization of these files. This is fantastic because it turns an otherwise long and tedious process into a couple of clicks.
In my sample, jpg is the most common file type. The minimum file size in my sample is 38 KB and the maximum sample is 303 KB. The average size is 124.8 KB. I looked through many images other than the five that I selected for the assignment. Most of the images I saw were jpg files. However, most of the files that I looked through were photographic. I looked at some animated images and they were all gif files. I looked at many more photographic images than animated images, so my five are a pretty good representative sample of all the images I looked at with regard to file type. Based on my five images and all the images that I considered, I would conclude that most images on the internet are jpg files. Of course, this is not a valid conclusion because I have not looked at a diverse enough sample of images. However, I might reasonably conclude that photographic images are more likely to be jpg files than animated images and that animated images are more likely to be gif files.
I took the image of Mt. Everest (originally a jpg file), opened it in paint, and changed it to a bitmap. The icon changed from the Corel Photo icon (in jpg) to a Microsoft Paint icon (in bitmap). The bitmap version had much higher quality than the jpg version. This was increasingly evident as I zoomed in on both versions. The bitmap file is also roughly ten times the size of the jpg file. Based on this and my observations of many other jpg and gif files, it seems that the file size increases with picture quality. More importantly, the file size seems to increase much more with picture quality than with picture size. The animated files were all much smaller than the photographic files. Higher quality photographic files were much larger than lower quality photographic images.
In summary, many different types of images are available online for use and storage on your desktop. Various types of files are used to provide a variety of image types and qualities for people’s various needs and conditions. File type and file size seem to be very closely related to image quality. I have learned a great deal about online graphics and imaging, but I still have a great deal to learn.
EDUC 6305
Image Formats – Narrative
I have searched for images online that speak to who I am as a person. I chose an image of the Grand Canyon and Mt. Everest because I love travel and hiking (although I am not crazy enough to try Everest), two photographs of space images because I am fascinated by the universe’s size and the many facets of astronomy (as I mentioned in my photo story), and one animated picture of the gang of peanuts characters (i.e. Charlie Brown and Snoopy) because I have always loved the program. I have been looking at the names, sizes, and type of files. Below is a link to a spreadsheet where I present the name, size, file type, and date modified for the five files I used for this assignment.
http://spreadsheets.google.com/pub?key=pLpsg_-9TutQ0QxIBne7FPQ
I have learned a great deal about how to navigate through the desktop to find images that I have downloaded from the internet. I can see that images and graphics vary greatly in the way they are formatted on the computer and that many different types of image formats exist. The same image can be converted to different file types, and this often changes the file size and the picture quality. Picasa seems to be a great program for organizing images, and I love that it is set up to automatically post any of your images to your blog. This program brings all of your image files to one location while maintaining your original organization of these files. This is fantastic because it turns an otherwise long and tedious process into a couple of clicks.
In my sample, jpg is the most common file type. The minimum file size in my sample is 38 KB and the maximum sample is 303 KB. The average size is 124.8 KB. I looked through many images other than the five that I selected for the assignment. Most of the images I saw were jpg files. However, most of the files that I looked through were photographic. I looked at some animated images and they were all gif files. I looked at many more photographic images than animated images, so my five are a pretty good representative sample of all the images I looked at with regard to file type. Based on my five images and all the images that I considered, I would conclude that most images on the internet are jpg files. Of course, this is not a valid conclusion because I have not looked at a diverse enough sample of images. However, I might reasonably conclude that photographic images are more likely to be jpg files than animated images and that animated images are more likely to be gif files.
I took the image of Mt. Everest (originally a jpg file), opened it in paint, and changed it to a bitmap. The icon changed from the Corel Photo icon (in jpg) to a Microsoft Paint icon (in bitmap). The bitmap version had much higher quality than the jpg version. This was increasingly evident as I zoomed in on both versions. The bitmap file is also roughly ten times the size of the jpg file. Based on this and my observations of many other jpg and gif files, it seems that the file size increases with picture quality. More importantly, the file size seems to increase much more with picture quality than with picture size. The animated files were all much smaller than the photographic files. Higher quality photographic files were much larger than lower quality photographic images.
In summary, many different types of images are available online for use and storage on your desktop. Various types of files are used to provide a variety of image types and qualities for people’s various needs and conditions. File type and file size seem to be very closely related to image quality. I have learned a great deal about online graphics and imaging, but I still have a great deal to learn.
Image Formats - Narrative
My narrative for the Image Formats assignment is available at the following URL.
http://docs.google.com/Doc?id=dhcjqwjv_12crd2njfr
http://docs.google.com/Doc?id=dhcjqwjv_12crd2njfr
Image Formats - Spreadsheet
My spreadsheet for the image format assignment is available at the following URL.
http://spreadsheets.google.com/pub?key=pLpsg_-9TutQ0QxIBne7FPQ
http://spreadsheets.google.com/pub?key=pLpsg_-9TutQ0QxIBne7FPQ
Friday, June 6, 2008
Screen Grab - 2
I took advice from a fellow student that aided me in creating this screen grab of an actual window in Microsoft Internet Explorer. I like to visit the NASA website and keep up with the latest news in space exploration, so I though this would be a good example to use for a screen grab. Also, I think that this is more along the lines of what the assig
nment was trying to teach us. This is the official site for the National Aeronautics and Space Administration, and it is available at the following address.
http://www.nasa.gov
nment was trying to teach us. This is the official site for the National Aeronautics and Space Administration, and it is available at the following address.http://www.nasa.gov
Week Three Reflections
This week has been an incredible experience in creating visually attractive presentations. I feel like I have taken a great leap into the 21st century. I created a Microsoft Photostory Presentation on myself. As luck would have it, I bought a digital camera just last week. Anyway, the photostory turned out great. I am thinking about getting a digital camera to fit into the eyepiece of my telescope. If I do and get some good images, I'll be sure to put them in photostory and post it on my blog for viewing. I am now learning how to use various types of image files and present them in different ways. At this point, I am struggling with using Picasa to post screengrabs on my blog.
Screen Grab
This is a photograph of Saint Bartholomew
Episcopal Church located in Leetown, WV. This church is just another great historical landmark in our area. Below is a link that will tell you a little more about the history of Leetown, WV and St. Bart. Church.
http://en.wikipedia.org/wiki/Leetown,_West_Virginia
A few reflections and concerns:
I downloaded Picasa and it seems easy to post an image to the blog. However, I have not quite grasped the screen grab. This image was one that I took and saved in a file on my computer. It automatically saved in Picasa when I downloaded the program. I do not know how to grab a screen on the internet or on the computer, save it in Picasa, and then post it on the blog. I would appreciate any help in this regard. Thanks and enjoy!
Episcopal Church located in Leetown, WV. This church is just another great historical landmark in our area. Below is a link that will tell you a little more about the history of Leetown, WV and St. Bart. Church.http://en.wikipedia.org/wiki/Leetown,_West_Virginia
A few reflections and concerns:
I downloaded Picasa and it seems easy to post an image to the blog. However, I have not quite grasped the screen grab. This image was one that I took and saved in a file on my computer. It automatically saved in Picasa when I downloaded the program. I do not know how to grab a screen on the internet or on the computer, save it in Picasa, and then post it on the blog. I would appreciate any help in this regard. Thanks and enjoy!
Tuesday, June 3, 2008
Sunday, June 1, 2008
Graphic from Scratch
Subscribe to:
Posts (Atom)

