Thursday, September 30, 2010

Excel Project

I just finished the Excel Project and in the end it was great to learn different skills that I had not been familiar with.  One that was extremely helpful was learning how to search for functions.  I simply typed in what I was looking for in the excel search for formulas and then excel helped me through the whole process.  Previously, before knowing about this, I would try to come up with functions and try to remember the parameters myself.  With the search process all you have to do is click on the function button to the left of the formula bar.  Once in the search box, you type in what you are trying to find and then excel comes up with different function possibilities.  Once you choose a function, excel then helps you type in the parameters.  The whole function process is no longer as scary as I had always thought.
Formatting the worksheet to be ready for printing also was a breeze with the helpful steps outlined in the project.  I had always spent much more time than needed when getting ready to print out an excel worksheet.  With the tools we learned in the lectures it was easy to go into page setup, set the page to landscape, and then decide on the number of pages wide for the worksheet to fit onto.  Adding a header and footer was a simple process as well.  I think being better acquainted with the ribbon bar across the top of excel is helpful, it was easy to utilize the page layout ribbon and choose how the worksheet should be printed.  Now knowing about the “print titles” tool on the page layout ribbon is a life saver as well.
While working through this project I would have to say the area I really did start from scratch in and learn the most was the pivot tables section.  I was a little intimidated at first, but after watching the lecture on pivot tables, I was able to navigate through step two without a problem.  Using a pivot table is a skill that will definitely come in handy.  Being able to analyze the data in such an organized fashion and quickly is great.  One small key to the pivot table which I found to be a bit hidden is how to summarize the data.  When I was coming up with the average increase in heart rate for the subjects, excel automatically summarized the data as a sum.  After a bit of searching and recalling the summarize data default discussed in class I was easily able to right click on the highlighted data and change the data to be summarized by average.   Hopefully I will be able to use this skill and all the others learned throughout the project in the near future!


Sunday, September 26, 2010

Week 5: Clear

After working with excel during my internship this past summer, I know firsthand that it is important to know how to work with Excel.  Knowing how to use Excel is a great asset and important in every field.  Out of the different sections reviewed in class, I have to say I have a special appreciation for the printing section.  This summer, I spent a considerable amount of time formatting spreadsheets before printing. 
In class we went over the steps it takes to automatically scale a spreadsheet to fit within a certain number of pages, either wide or long.  You simply go into the page setup, click on the page tab and fill in the number of desired pages you would like it to fit into, wide and/or long.
Not only is it important to fit within a certain width or length, but it is nice for the data to have appropriate spacing within the columns.  Thus, another skill that goes along with the printing set up is the width of the columns.  Often times the spreadsheet may have plenty of room in landscape mode (click here for directions to setup page orientation) for the columns; however, it may not look the nicest.  Sometimes the information is squished into tiny columns when it does not need to be.  This is when you can go back to the spreadsheet and double click the right side of the column.  Excel automatically adjusts the width to the needed width to display the data.  This was always an important trick when I was getting ready to print spreadsheets.  It makes the data look more presentable. 
Thus, not only is it important to know how to put together a great spreadsheet, but it is also important to know how to format it for printing in the best possible way.

Sunday, September 19, 2010

Week 4: Clear

This week I thought it was fascinating to learn about software licensing.  I have seen the EULA before and checked the box in agreement; however, really I was not too knowledgeable on the whole matter.  It’s important for the developer to have the EULA as a part of the installation because then the user is held up to those standards.  In the lecture it was also pointed out that EULAs have withstood many legal challenges.  It is the necessary way for software developers to be protected.
One interesting part of the licensing lecture was learning about commercial licenses.  I have been able to take part in a couple site license agreements and always wondered how they were possible.  I mean, I pay a good amount of money for a certain software application that is only an individual license.  I always wondered how it was possible for an organization to pay enough for an agreement to be able to have hundreds of installations. 
With the large organizations, they buy a site license and in the end it is a better value.  It covers all installations at that given site.  It’s only purchased when the organization/ business is quite large, because otherwise the organization would probably be better off with a per-seat license.  The site license software sometimes works to cover all installations at a given site, or sometimes it runs on an application server with users connecting over the internet. 
This past summer, the organization I worked for had an agreement with Microsoft Office that all the employees were able to download the software onto their laptops.  I specifically remember in the email the part of the agreement that stated the software must be removed when leaving the company.  I thought that it made sense, but did not think too much about it.  After the license lecture it was interesting to learn how important that is and odd to look back and remember how that piece of information stood out.  Now I have a understanding of the process behind it all.   

Sunday, September 12, 2010

Week 3: Clear

At the end of this week when I had gone through all the lectures, I turned to my roommate and said, “I feel like I have been a bad mother to my laptop.” Sure I have “taken care of” my laptop for the past three years; however, after learning more about it, I feel like I haven’t known much about it this whole time.


Now that I am learning how my laptop works, I feel like I have more responsibility to make sure it is running smoothly. These past three years I have treated it as something to only help me and to run smoothly all on its own; however, now I know there are steps I should be taking too to insure it’s proper health.

One simple step that I am excited to take is to defragment some of my drives on my computer. Since I have Windows, it’s important that I take the time to do this. Fragmentation happens as more items are saved onto a disk. The OS saves the files in a manner to utilize all available space. In order to do this, the files may be cut up and slid into different empty spaces. Eventually, after many deletions and new additions are made, there are many fragmented files. With a file being split up on the hard drive, the hard drive head has to move around more to find the information. The more work the hard drive head does, the longer it is going to take to retrieve information and the sooner hard drive failure could occur.

Thus, it is important to take the time, go into the computer and run a defragmentation of the different drives. Click here for steps on how to set up the defragmenter. After my antivirus software is finished scanning tonight I’m going to run a defragmentation for my drives. Hopefully with these new found steps to take care of my computer it will start to pick up the pace and feel a bit younger again!

P.S. It is important to note that Mac OS X does not need defragmentation. In fact, Apple discourages defragmentation. Defragmentation on a Mac can actually harm the performance by placing files on the “hot band” which is reserved for specific files to insure maximum performance.

Sunday, September 5, 2010

Week 2: Clear

Everything became clear after the confusion with downloading the course lectures.  I'm not the best when it comes to computers (I'm excited to learn a lot this semester) so figuring out how to watch the lectures and then getting the email concerning them took some time.

However, it's all clear now.  Something I enjoyed learning about was the memory of the computer.   Memory space is important as I am constantly saving documents on my computer, downloading pictures from my camera, and trying to access many different items in a short amount of time.


Thus, when looking to purchase or build a computer, the number of memory sockets on the mother board is an important issue.  The more sockets, the more memory you can add.  It is also important to buy the right type of memory for my system.  Memory functions together as a "team" and thus sometimes needs to be bought in twos or threes.  DDR2 and DDR3 are the two types mainly found in the market today.  DDR3 being the the newer of the two, is able to transfer data rapidly while using less energy.  As a business major with a focus in sustainability I am always looking for new ways to save energy.  I'll definitely remember about DDR3 memory when shopping for my next computer.