Teen Payroll
To complete Teen Payroll, we had to use formulas to calculate gross and net pay. To do this, we had to use a formula to calculate a salary of how much money each person makes. I learned how to use the formula function to calculate more complex equations instead of simple equations. I feel that I used the total net and gross pay functions well. If I had to improve the assignment, I would have made the formula for the pension, state tax, medical tax, social security tax, and federal tax easier to enter and solve for.
Formula Functions
In Formula Functions, we had to create a grade book to calculate student grades. To complete the assignment, we had to make a group of exam grades and find the average using formulas. I learned how to use a function to find the high and low average out of all six exams. I feel like I did the formula for the high and low average well, but I could have improved on the final exam average function.
Raises
In the Raises Spreadsheet, we had to use the IF function to calculate employee pay raises. To do this, we had to use the IF function to make an equation for pay raises if a person had at least 4 years of experience. I learned how to use the IF function in the assignment to use one equation if something is true, but a different equation if another thing is true. I did the formatting of the assignment well because I followed all the directions that it told me to do for the formatting. If I could improve it, I would work on the IF function more because my equations were entered correctly, but I had issues with differenciating between which equation went with each factor.