Week 10: muddy-clear-wow

This week we explored Microsoft Access.
I had never heard of this let alone used it. As Mr. Olson began to show us how this tool is used, I was unsure. It seemed similar to Excel at first, but then it was a whole world of computing!
My favorite part of this week was learning how to import the Excel spreadsheet and then making a report and or query about it.
Since, I'm a huge excel fan- I make an excel sheet for everything- this aspect was so exciting!
After being shown, the use of Access seems easy and fun!
Once you open Access you begin to make a new table or you can import the data from Excel.
After you have data, you can start a query under the create tab.
You can also make reports that can show specific desired information.
These tools can be helpful, not only to a teacher as in the example, to a business that wants to keep track of invoices, sales, employees, times, orders, and more!

Made by me! =]

Week 9: Clear

This week we learned about Moore's Law. This is an important concept in the computing world because it encourages growth. Growth, specifically at  doubling at every 18 months. Moore's theory was "faster, cheaper" computing.
A website that clearly defines this idea, visually is the Intel website.
http://www.intel.com/content/www/us/en/silicon-innovations/moores-law-technology.html

Excel Project

This week we were able to learn more about Excel and varies functions that can be performed.  Simple functions of Excel are the varies formats for each cell. For example, when you type in 15% the cell automatically formats to percentage. The user can adjust the decimal point and how the percent will be used in the sheet.
As I worked through the project I reinforced the skills of adjusting the column and row width, inserting new columns, and formatting cells to reflect the correct data. A new aspect of Excel that I had been unaware before this lesson/project was the pivot tables. The pivot tables allow a user to compare data, find percentages throughout the data, and summarize by a sum, a count, an average and more.
An example of a pivot table would  be:

Here, my boss would be able to see the selected demographics- by age grouped into decades. Then she would be able to see that the average percent increase was almost ninety-one percent in females ages 20-29.
This can be useful in a business that would want to see average sales, or average time of work per worker, etc.
As you can see, the user can also make the table appealing by adding colors and fonts.

Extra Credit: Avatar

My avatar




I have created an avatar of myself with the Doppelme website. It was easy to use and was very quick. The experience was very cool. You register with your email address and then they send you a password. Once you are logged on you can access more features than just being on the site. That had many colors and accesories to choose from. I didn't use the accesories because I wanted my avatar to look business ready. So I put her in a colared shirt, with my favorite color of course. I would have liked to be able to change the shape of the face- like you can when you creat a Mii on the Wii.
I picked doppelme because it looked simple and the avatar didn't look to complicated.