Term 3 Work
1/12-4/10
Teen Payroll
Teen Payroll, in this assigment, we had to take the information given, enter it, and use calculations to fill in the rest of the chart. The skills used were the use of Excel, formulas and color coding. What I learned in this assigment, was the use of formulas, and color coding the cells. What I believe that I did was reinfocing my use of setting up the table, and the use of new formulas. What I would do differently is to not have to type out all the names, and their numbers. Other than that, it was not bad at all.
p5perryj11212teenusa.xlsx | |
File Size: | 16 kb |
File Type: | xlsx |
Grade Book
Grade book assigment, With this, we entered the students names, and their grades, and used formulas to computer averages, mins and max's. To complete the assigment, we had to use excel, formulas, and sorting. Something new that I learned was how to properly use the sorting tool. I think what I did well in this assigment was the use of the formulas and now finally knowing how to use the sort tool correctly. To improve on this assigment, I would have allowed for the use of shading and some form of template to help this look a little more apealing.
p5perryj1912quizscores.xlsx | |
File Size: | 14 kb |
File Type: | xlsx |
Raises
The Raises Activity. This activity by far was one of the ones I dislike the most. With this activity, we had to type in all the data into the sheet and use multiple formulas to compute pays, gross salary, and taxes. What I disliked most from this was having to deal with the large numbers and having to constantly fix formulas. After we finished the formulas in the assigment, we had to answer a few small questions on the data we gathered, this was the easiest part of all. The skills in this activity included the use of excel, more formulas, sorting and answering questions based on the data. One thing I would do differently is to knock out half of the typing by starting out the activity with a template with just the formulas to fill in, also it would be nice to have had some room in this for some shading, and better use of the page.
p5perryj05012012raise.xlsx | |
File Size: | 17 kb |
File Type: | xlsx |