Sunday, March 28, 2010
Sunday, March 21, 2010
Week Ten: Clear LAN and WAN
LAN and WAN. It sounds like a progressive band name. While they were progressive in their time, LAN and WAN is not a band name but area networks of connected computers. Nearly everyone who has interacted with a computer has accessed a LAN, and most people have encountered a WAN without even realizing it.
A LAN is a local area network and connects network devices over a relatively short distance. They can typically be found in office buildings, schools, and homes. As the term implies, a wide area network or WAN spans a large physical distance. The Internet is the largest WAN, spanning the Earth. A common interaction with WAN's is through bank ATM's.
Excel Project
Working on this Excel project truly was a pleasurable experience. I have always enjoyed working with Excel but have never learned to work with pivot tables. I think that having this skill in my bag of tricks will help me out immensely in the long run.
The project required me to manipulate and analyze data from a study of men and woman's heart rates while exercising. I added rows, created formulas, edited fonts and sizes, and created two pivot tables. As I mentioned before, I am new to pivot tables so I spent the grand majority of my time understanding the utilities of this tool and finessing the results shown in my tables.
Screen capture of a pivot table
This past summer, I did a lot of work in Excel with data of a research study conducted. I spent hours crafting complex functions to get specific results out of the information. If I had know pivot tables existed, I would have saved myself hours of racking my brain! With pivot tables, nevermore will I struggle with data analysis!
Subscribe to:
Posts (Atom)