com sci simnet.com excel project

profileKelly111
Xiaotong.Chen-EX2016-FixIt-5-6.xlsx
Home>Computer Science homework help>com sci simnet.com excel project

Faculty Data

First Name Last Name Dept Rank Salary
Damon Iheduru Math Assoc $60,000
Maria Cesario Chemistry Assoc $60,000
Sarah Paul Art Instr $44,000
Jerome Moody History Instr $54,000
R. Douglas Kraay French Assoc $60,000
Angelita Usman Literature Assoc $60,000
Igor Berkovich Math Prof $90,000
Royal Singletary Chemistry Prof $90,000
J. Tim Scheb Art Prof $80,000
John MacMillan History Instr $44,000
Achi Ronen Math Instr $64,000
Rosalie Saulnier Chemistry Assoc $60,000
Lester Janovicek Art Instr $54,000
David Rosencraft History Prof $90,000
Walter Rose III French Assoc $60,000
Uriel Brandt Literature Prof $80,000
Warren Fernandez Literature Prof $85,000
Catherine Fitzgerald-Cramer Math Assoc $60,000
Patricia Presley-Dixon Chemistry Prof $90,000

Faculty Pivot

French Sum of Salary
Art $ 178,000
Chemistry $ 300,000
French $ 120,000
History $ 188,000
Literature $ 225,000
Math $ 274,000
Grand Total $ 1,285,000

Salary Total by Department

Total Art Chemistry French History Literature Math 178000 300000 120000 188000 225000 274000

Student Test Data

Month Subject Student Score
February Art Lisa 83
February Art Mary 59
February Art Mark 85
February Art John 77
February Art James 86
February Literature Mary 68
February Literature Lisa 51
February Literature Mark 53
February Literature John 45
February Literature James 85
February French Lisa 57
February French Mary 93
February French Mark 59
February French John 51
February French James 75
February History Lisa 84
February History Mary 61
February History Mark 86
February History John 78
February History James 87
February Math Lisa 72
February Math Mary 54
February Math Mark 74
February Math John 66
February Math James 75
February Chemistry Lisa 89
February Chemistry Mary 56
February Chemistry Mark 89
February Chemistry John 77
February Chemistry James 86
January Art Lisa 89
January Art Mary 61
January Art Mark 91
January Art John 83
January Art James 92
January Engish Mary 87
January Literature Lisa 87
January Literature Mark 89
January Literature John 81
January Literature James 90
January French Lisa 62
January French Mary 92
January French Mark 64
January French John 56
January French James 65
January History Lisa 81
January History Mary 58
January History Mark 83
January History John 75
January History James 84
January Math Lisa 65
January Math Mary 53
January Math Mark 67
January Math John 59
January Math James 68
January Chemistry Lisa 58
January Chemistry Mary 35
January Chemistry Mark 60
January Chemistry John 59
January Chemistry James 68
March Art Lisa 92
March Art Mary 48
March Art Mark 94
March Art John 86
March Art James 95
January History John 75
January History James 84
January Math Lisa 65
January Math Mary 53
January Math Mark 67
January Math John 59
January Math James 68
January Chemistry Lisa 58
January Chemistry Mary 35
January Chemistry Mark 60
January Chemistry John 59
January Chemistry James 68
March Art Lisa 92
March Art Mary 48
March Art Mark 94
March Art John 86
March Art James 95
March Engish Mary 41
March Literature Lisa 41
March Literature Mark 45
March Literature John 57
March Literature James 86
March French Lisa 56
March French Mary 90
March French Mark 58
March French John 50
March French James 79
March History Lisa 91
March History Mary 67
March History Mark 93
March History John 85
March History James 94
March Math Lisa 71
March Math Mary 35
March Math Mark 73
March Math Lisa 71
March Math Mary 35
March Math Mark 73
March Math John 65
March Math James 74
March Chemistry Lisa 41
March Chemistry Mary 41
March Chemistry Mark 43
March Chemistry John 55
March Chemistry James 84

Student Pivot

Column Labels
Art Art Total Chemistry Chemistry Total Engish Engish Total French French Total History History Total Literature Literature Total Math Math Total Grand Total
Row Labels 48 59 61 77 83 85 86 89 91 92 94 95 35 41 43 55 56 58 59 60 68 77 84 86 89 41 87 50 51 56 57 58 59 62 64 65 75 79 90 92 93 58 61 67 75 78 81 83 84 85 86 87 91 93 94 41 45 51 53 57 68 81 85 86 87 89 90 35 53 54 59 65 66 67 68 71 72 73 74 75
James
January
February
March
John
January
February
March
Lisa
January
February
March
Mark
January
February
March
Mary
January
February
March
Grand Total

Data Table

Amount Donated/Invested $20,000.00
Number of Years 12
APR 6%
Rate Value
$40,244
0.50% $0
1.00% $0
1.50% $0
2.00% $0
2.50% $0
3.00% $0
3.50% $0
4.00% $0
4.50% $0
5.00% $0
5.50% $0
6.00% $0
6.50% $0
7.00% $0
7.50% $0
8.00% $0
8.50% $0
9.00% $0
9.50% $0
10.00% $0
10.50% $0
11.00% $0
11.50% $0
12.00% $0