Example Assignments of Term 3
Teen Payroll Spreadsheet
In this assignment we had to use formulas to calculate gross and net pay and copy those formulas down each column it applied to. Afterwards we were supposed to apply a shading to one of the columns. I did not have a problem with this activity.
Formula Functions Spreadsheet
In this assignment we had to create a grade book, which we had to format on our own with the different formating skills we had learned so far and then calculate the students grades using the count, average, minimum and maximum formula. This was the first time we used the minimum, maximum and the count function, so what I learned in this exercise was how to use those properly. The next time I would use more formatting for my spreadsheet and I would not choose the color pink for the outline of my table with questions again.
Raise spreadsheet Activity
This exercise required us to use the IF, count and the IFcount function to calculate which employees would get a raise and which wouldn't, depending on the years they've worked for the company. From this assignment I learned how I can and when I should use the IF function. I can't tell what I could have done better in this assigment because I fulfilled all requirements.
Powerpoint presentation - Conditional Formatting
In this partner project we had to create 3 different excel worksheets with examples of the use of conditional formatting, which we then had to present in a powerpoint presentation. In addition we were required to create an assignment in excel for our classmates to practice and understand conditional formatting. The powerpoint presentation should have had more screenshots of our examples and maybe some animation to draw attention to important details. I think our color and our font size choice were appropriate.