Business

Unit 7    [IT153: Spreadsheet Applications]   

GEL Assignment and Assignment 7 Details and Rubrics

There are two Assignments due in Unit 7.

1. GEL 2.3 Assignment 2. Assignment 7

Note: you will be turning in two assignments for this unit; the regular Assignment 7, plus the GEL-2.3 Assignment.

Unit 7 GEL 2.3 Assignment Outcomes addressed in this activity: Course outcome(s): GEL-2.3: Solve real-world problems using mathematical skills. Instructions Sandy worked overtime this past week and would like to know what her Gross and Net Pay would be. Please help Sandy calculate this using the following given data. The policy of her workplace is that she will earn time and a half for any hours worked over 40.

Pay Rate Hours Worked

$10 / Hour 50

Federal Tax Rate State Tax Rate FICA

20% 10% 5%

Using the Excel Application or a Calculator calculate Sandy’s Gross Pay and Net Pay. Show all detail, formulas and steps you used to arrive at your answer. Submit your GEL 2.3 Assignment to the GEL 2.3 Dropbox by the end of the unit.

Unit 7    [IT153: Spreadsheet Applications]   

The rubric assesses your ability to solve real-world problems using mathematical skills. All deliverables should be professionally formatted and should be free of spelling errors. Points deducted from the grade for each error are at your instructor’s discretion. Unit 7 GEL 2.3 rubric – 30 points

Not Assessed

No work was received by the instructor.

No Progress

Student work demonstrates no understanding or progress towards achievement of this outcome.

Introductory

Student work demonstrates no ability to solve real-world problems using mathematical skills.

Emergent

Student work demonstrates minimal ability to solve real-world problems using mathematical skills.

Practiced

Student work demonstrates adequate ability to solve real-world problems using mathematical skills.

Proficient

Student work demonstrates proficient ability to solve...