Sunday, March 28, 2010

Week 11: Muddy Data

Well, I barely passed the weekly quiz, scoring a 70%. This indicates I did not absorb enough of the teaching from the PDF's and lectures. There was a lot of information about data and relationships I did not remember. I'm thinking those details will be important to study before the final.
The April 4th due date is coming up and with it the deadline for eight assignments. Oh boy! Luckily, I am completely caught up in Business Law and have been working hard to keep up in Managerial Economics. I'm hoping to complete a few extra credit assignments and maybe get an A or A- in this class. It will be worth the effort!

Sunday, March 21, 2010

Week 10: Clear Assignments

So far, this class seems to be moving along well. Now, on the horizon, I see a ton of assignments coming up and a few look to be fairly complicated. I need to work to set aside time after my test this Wednesday to start a few projects and do some extra credit. There are so many extra credit opportunities in this class, I would be an idiot to not try and take advantage of them.
I have enjoyed keeping up with the latest submissions to the IT Current Events Discussion. The topics have been the most relevant and interesting of any discussion board I've had to participate in for school.

Excel Project

Working with Excel to complete the project was relatively simple. The scavenger hunt and video tutorials made following the instructions much easier. I have only used Excel in college classes and have no real world experience with the program. I can imagine that many working, online students would find the project even easier.
In the past, I have used Excel functions in finance, math and computer classes. I've mainly used the basic functions like sum, divide and multiply. I had used various pages of data and made charts. In this project, I learned and applied the fixed cell function by utilizing the dollar sign before each letter and number. I was surprised I hadn't learned that before.
It was interesting to see how easy it was to apply data to a pivot table. I used two pivot tables for the assignment and the work went quickly. I wasn't sure if there was a better way to do a screen capture and using Excels help had no real help, so... here it is.

Sunday, March 7, 2010

Week 9: Clearly I Need To Keep Up With Assignments

It is time to submit my Excel Scavenger Hunt Assignment and I have been unable to until just now. I actually started this post after I was unable to access the online webCT. I have not seen the website down due to high volume before. The most I had seen it before was at Medium usage.
The Excel Scavenger Hunt was interesting. I had taken computer classes before and used many of the features, but had never used group before. Unfortunately, I'm not using Office 2007, so the video tutorials didn't apply to my Excel toolbar. I was able to figure it out using the Excel search field.
I actually have Office 2008 on the Mac, but I do all of my web surfing and schoolwork on my laptop and I only have an old copy of Office 2003 on this computer. My wife and I use the Mac primarily for our photography business and I hardly use it at all. I need to get a copy of 2007 someday, but right now I can't even spare the $60 it costs to download and register the student version here...
http://www.microsoft.com/student/discounts/theultimatesteal-us/default.aspx