Teen Payroll
This assignment was created in Microsoft Excel. For these assignments, we used formulas to calculate gross and net pay for employees at Teen U.S.A. By doing this assignment I learned how to calculate gross and net pay by using formulas. In this assignment I think that I did well with formatting the docment and using the formulas. To improve the assignment I think that I could've formatted the document better to make it more visually appealing.
Problem #22- Formula Features
This assignment was created in Microsoft Excel. For this assignment, we needed to create a gradebook. We had a number of exam grades to put in the document, and then with them, we found average grades using formulas. When we did this assignment we also formatted the document to look appealing and inserted a picture at the top. In the end, we answered quiestions on the bottom of the document with the results I got. By creating this assignment, I practiced my skills with formulas and formatting documents. To improve this assignment, I think that I could've used more skills in formatting it to make it look better.
Raises Spreadsheet
In this assignment, we created a chart in Microsoft Excel, to create a chart that calculated the pat of employees in the city of Fort Worth. In this chart, we found the raises that people would recieve in 2011 based on their years of service, at the bottom, we answered quiestions about out results. When we did this assignment, I learned how to use the IF function in Excel. I think that in this assignment, I did well with the formulas and answering quiestions. However, I think that this assignment could've been much better if I took more time to Format the document.
Conditional Formatting Group Project
In this assignment, we used the internet, and multiple Microsoft Office progams to create a group project on the tool Conditional Formatting in Microsoft Excel. We used Microsoft Excel to research the tools and research things that they could be useful for. We also used excel to create an assignment for the class to do, and to show the tools to the class when we presented the project. We used Microsoft Office Word to make the assignment that the class recieved, by inserting charts from Excel and writing directions. Then we used Microsoft Powerpoint to create a slideshow that we presented to the class that showed the tools we used and what they wouold be useful for. When we did this assignment I learned how to use conditional formatting in many ways and for many things, like to show the highest test score that a student got. I think that in this assignment, I did well with presenting to the class and creating the assignment for the class. However, I think that I could've done much better on the Power Point that we presented.