Wednesday, April 3, 2013

Spreadsheet on Excel

I cannot believe the amount of problems I had with this assignment. I remember using Excel in middle school, and it is safe to say that it did not stick with me. I was only able to accomplish the first steps of copy and paste before I had to call in reinforcements. Thanks Meghan! Through reinforcements and trial and error I was able to create my spreadsheet.

In the beginning the concept of "Insert/Function" was completely lost to me. However, once it was explained to me I realized what a great tool this was. There were so many possibilities  Dates, times, sums, products, sin, tan. ect. I could not believe that there were so many shortcuts. I do not think I was taught this in middle school! Math is can be easily messed up just by the simple mistake of hitting a wrong button or using a wrong number. "Insert/Function" takes away many of the variables that can cause a mistake. Everything you type is clearly in front of you and when using big numbers, it is a significantly faster to use this shortcut.

I had to draw back on my middle school memory to remember how to make a chart. This process entailed me looking up a YouTube video. Once I saw the first steps in the video I quickly remembered the process.

I used the inquiry based approach by attempting to draw back on my prior knowledge of Excel. Once I got the hang of the program I started to wonder how the different functions worked. I began experimenting and found that if I did not put in the function right an error would occur. In order to use the functions you have to know what you are doing. This is good because it helps insure that your information is right.

Inquiry Questions:
Plan your dream vacation, and create a budget

What will your expenses be?
Create a chart to represent your data, which chart would be the best?
In what ways would creating a budget on Excel be helpful?

No comments:

Post a Comment