Activity 37 Stocks
In this activity we were required to make an exell spreadsheet showing different stock companies profit over a year. We also had to answer questions about the data to finish the assignment. The technology tools needed to do this assignment were all in Excell. The new tools we leraned were new ways to format numbers, such as negative numbers and using the fill color tool on certain cells. While doing this assingment I learned that the way to format negative numbers when doing acounting is to put them in parentheses. In this assignment something I did well was answering the questions correctly and completely. If I was to do this assignment again I would format it differently.
Excel Activity #22
In this activity we were required to set up a gradebook in excell. We had to also answer questions regarding the data that we got using different equations. The technology tools needed to do this assignment were all in Microsoft Excel. The new tools used in this assignment were different formulas that we hadn't used before. These included the max, min, count, and average formulas. While doing this assignment I learned how and when to use the count function. In this assignment something I did well was using the new formulas in the correct way. If I was to do this assignment again I would format it.
Excel Activity #45
In this assignment we were required to create a column chart from the data we entered into excel. The technology tools needed to use this assignment were all from Microsoft Excel. The new tools that were introduced during this assignment were how to create a chart and the different formating techniques used for charts. While doing this assignment I learned that you could format different portions of the graph rather than the chart being all one color and rotate the words on the x-axis. If I was to do this activity again I would take the liberty to change the colors of the formating to make the chart more visually appealing.
Excel Group Project- Area Charts
This assignment was a colabrotive group project. Each group was required to research one type of chart that is available in Excel. My group had to research area charts. We were required to make a power point explaining the type of chart, a demonstration to show the class how to create it, and an Excel activity to have the class practice the skill. For this project we were required to use various technology tools. We first used the internet to research about area charts, we used powerpoint to create a presentation to teach the class, we used excel to create an excel activity and sample to teach the class, and lastly we used microsoft office to create a handout to explain the activity to the class. While doing this assignment I learned various things. I learned through our group research how to succesfully create an area chart in Excel. Through working with a group I also learned how to collobrate with many different opinions on one completed project. It taught me how to delegate work to succesfully complete the project in the allotted amount of time. If I was to do this project again I would change one thing. In order to make a more succesful presentation I would split the information onto more slides in order to make the information easier to read.
Excel #50- Yacht Mortgage
In this assignment we were required to create a spreadsheet that showed what monthy payments would be on a mortgage, dependent on the principal. The technology tools needed in this assignment were all in Microsoft Excel. In this assignment we learned one new tool. That tool was a new formula, PMT, it calulates what your payment per month would be on a loan depending on the Percentage rate and principal. While doing this assignment I learned where in excel you can find the various formulas and also how to find them using the help menu. If I was to do this assignment again I would expand it by using diffrent formatting tools rather than just following the basic instructions given to us.