Tutorial 2: Video Compression

One concept I found particularly interesting was the idea of inter-frame compression. The idea behind this type of compression is that you don't want to transmit pixels that aren't changing from frame to frame because that would be a waste of bandwidth. I realize though that those are a lot of words/ideas some of you may not be familiar with so let's take it from the top.

Pixels

Every image is made up of several tiny colored dots that will form that image to what you and I see. The more pixels the image has, the more realistic it will look. 

Take for example the two images above. The one on the right has a much higher pixel density meaning it has more pixels per inch. Obviously the quality on the image on the right is far superior.

Motion Pictures

I bring up the idea of motion pictures because I mentioned the process of frame to frame compression. That's all motion pictures really are. They are separate frames of one image per frame that, when compiled together at extremely fast speeds, look as though there is motion. 

Inter-Frame Compression

This brings me to the idea of Inter-Frame Compression. The first thing to know is that a key frame will be identified. This is the first frame in the series that acts as the base point for comparison. It is the initial frame. In the image below, the first image all the way to the left is the key frame. The I Frames are the next frames in the series of images.

So let's say this is a small sample of frames in a video that you want to compress. You could compress each of these images individually but this is an unnecessary use of bandwidth. This does not take advantage of the capabilities of video compression. You'll notice that, from frame to frame, some of the images do not change. These pixels then will not be transmitted when compressing the video. Think of a lecture that you've seen where the teacher is hardly moving around the classroom. So many of the pixels are identical from frame to frame, so why waste space transmitting those identical pixels. There is just a command that will copy that part of the identical pixels. For example, in the image I created above, The second image is identical, so instead of the second frame being transmitted, it will simply be copied. Moving on to the third frame, once again the identical pixels will be copied, and the new pixels that make up the red line will be transmitted.

Drawback

1) Data Corruption - If the first frame is corrupted then the corruption will carry on until a new key frame is established. 

Acknowledgments: http://www.gadgetell.com/tech/author/Gregadeaux/      © 2011 Gadgetell LLC. See our Privacy Policy.

Second Image produced and copyrighted by Leandro Gutierrez 2011

Excel Project

       I found this Excel project to be extremely helpful. Excel will undoubtedly be an important asset when we enter the business environment. In fact, it has proved to be extremely helpful even now with school projects and various internships I have participated in. This particular project didn't necessarily demand a wealth of knowledge concerning Excel and its attributes, but it covered many of the basic tools and shortcuts that virtually everyone needs when completing tasks in Excel. The project started off simple enough, requiring me to rename certain worksheets and center some information. Quickly however it required us to utilize some of the other functions in Excel, such as the "Help" function. Of course, we could have just as easily googled how to "Freeze Panes" but that would have been just as helpful, requiring that we put to use our searching skills previously learned in this course.
       What I liked about this project is that it did require us to put into practice everything that we've learned. Last week we watched several tutorial videos on how to properly and efficiently use Excel, but it's one thing to learn, and another thing to practice. For example, it's quite helpful to have a visual of someone utilizing absolute and relative cell addressing, but it takes it to an entirely different level when you are asked to create formulas that can involve both times of addressing, like this project demanded. It really helps you understand the concepts behind the formulas. This project asked that we do MAX functions and IF logical tests. The concepts seemed easy enough when I was listening to them being explained in the comfort of my room, but the knowledge really stuck when I had to make these formulas on my own.
       At my last internship over the summer, I used Excel almost on a daily basis. Any knowledge or skills I had came from my middle and high school memories of learning the system. I was no master by any means, and I certainly didn't think I could ever make a pivot table, let alone really even know what one was. This project really helped me understand how to properly use one. I actually felt it was necessary to go back and watch both Pivot Table videos over again which really helped solidify everything I had learned.