Loading...

SAM Project Assignment 7

Open Posted By: surajrudrajnv33 Date: 22/02/2021 Graduate Report Writing

Please read the instructions. The assignment must be done in 1-2 hours!

Category: Mathematics & Physics Subjects: Algebra Deadline: 12 Hours Budget: $120 - $180 Pages: 2-3 Pages (Short Assignment)

Attachment 1

Documentation

New Perspectives Excel 2019 | Module 7: EOM Project 2
Content Shop
SUMMARIZING YOUR DATA WITH PIVOTTABLES
Author: Richard Feliz
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

Contract Writers

Content Shop Contract Writers
Contractor ID S-567 Years 0 1 2 3 4
Contractor Name Jose Saldana Rate per Word $0.25 $0.30 $0.35 $0.40 $0.50
Assignments
Contractor ID Name Years Rate per Word Avg Eval Avg Score Q&As Reviews Copywriting
A-701 Victor Alvarez 2.5 $0.35 7.50 7.50
B-022 Doug Bidinger 1.0 $0.30 5.00 6.00
B-216 Antoine Bossard 1.5 $0.30 6.75 7.25
C-147 Mary Kay Cavanaugh 4.0 $0.50 5.50 8.00
D-724 James Dargenio 3.0 $0.40 8.00 7.50
F-629 Pilar Flores 4.0 $0.50 8.00 8.50
F-975 Rachel Fuller 0.5 $0.25 7.50 10.00
H-108 Min Hong 3.5 $0.40 6.50 6.50
J-869 Katrina Jackson 2.0 $0.35 5.75 6.00
L-293 Jum Li 3.0 $0.40 8.00 8.00
L-452 Will Lucht 3.0 $0.40 7.75 7.50
O-443 Kerry O'Keefe 2.0 $0.35 5.25 6.00
P-508 Liz Payton 0.5 $0.25 6.25 6.25
P-692 Patrick Pfeiffer 3.0 $0.40 7.00 8.50
P-733 Calvin Purcell 4.0 $0.50 8.00 7.50
S-567 Jose Saldana 4.5 $0.50 8.50 9.00
S-752 Anthony Scalizzi 2.5 $0.35 7.00 7.50
S-939 Martin Schuster 4.0 $0.50 6.75 7.00
V-098 Maria Velazquez 2.0 $0.35 6.00 6.00
W-231 Latoya Wheeler 2.0 $0.35 7.00 6.75

Editing Projects

Projects
Group ID Level Specialty Jan Feb Mar Total Projects
A-2 Platinum Reviews 10 8 11 29
A-2 Silver Reviews 8 9 10 27
A-1 Silver Q&As 7 9 9 25
A-1 Platinum Q&As 7 8 9 24
B-2 Platinum Copywriting 10 7 7 24
C-2 Bronze Internal 6 8 10 24
C-2 Gold Reviews 7 7 9 23
C-3 Silver Reviews 8 7 8 23
C-2 Silver Q&As 8 7 8 23
B-1 Bronze Copywriting 7 8 8 23
C-1 Platinum Internal 7 6 9 22
B-2 Silver Q&As 6 8 8 22
B-2 Bronze Internal 5 7 10 22
B-3 Platinum Reviews 8 6 6 20
B-3 Silver Internal 5 7 9 21
C-3 Platinum Copywriting 7 7 6 20
C-1 Gold Q&As 6 7 7 20
A-3 Silver Copywriting 4 6 10 20
A-1 Bronze Reviews 8 6 6 20
C-1 Bronze Copywriting 8 8 4 20
A-3 Platinum Internal 5 7 8 20
B-1 Platinum Q&As 7 8 5 20
B-1 Gold Copywriting 6 7 6 19
C-1 Silver Reviews 5 5 9 19
C-2 Platinum Reviews 6 5 6 17
B-2 Gold Copywriting 3 7 8 18
A-2 Bronze Q&As 5 6 7 18
C-3 Bronze Reviews 5 5 8 18
A-3 Bronze Q&As 7 4 7 18
B-3 Gold Q&As 6 5 5 16
B-1 Silver Reviews 4 4 8 16
A-2 Gold Reviews 4 5 5 14
B-3 Bronze Reviews 5 5 3 13
C-3 Gold Copywriting 2 4 6 12
A-3 Gold Internal 5 2 5 12
A-1 Gold Internal 4 2 4 10

Editing PivotTable

Copywriting Internal Q&As Reviews Total Total Editing Projects Total Average of Total Projects
A-3 B-1 B-2 C-1 C-3 A-1 A-3 B-2 B-3 C-1 C-2 A-1 A-2 A-3 B-1 B-2 B-3 C-1 C-2 A-1 A-2 B-1 B-3 C-1 C-2 C-3
Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects Total Editing Projects Average of Total Projects
Bronze 23 23 20 20 22 22 24 24 18 18 18 18 20 20 13 13 18 18 176 19.5555555556
Gold 19 19 18 18 12 12 10 10 12 12 16 16 20 20 14 14 23 23 144 16
Platinum 24 24 20 20 20 20 22 22 24 24 20 20 29 29 20 20 17 17 196 21.7777777778
Silver 20 20 21 21 25 25 22 22 23 23 27 27 16 16 19 19 23 23 196 21.7777777778
Grand Total 20 20 42 21 42 21 20 20 32 16 10 10 32 16 22 22 21 21 22 22 24 24 49 24.5 18 18 18 18 20 20 22 22 16 16 20 20 23 23 20 20 70 23.3333333333 16 16 33 16.5 19 19 40 20 41 20.5 712 19.7777777778

Platinum Editing Groups

Editing Groups - Platinum Level
Projects
Group ID Level Specialty Project Type Jan Feb Mar Total Projects
A-2 Platinum Reviews New 10 8 11 29
A-1 Platinum Q&As Repeat 7 8 9 24
B-2 Platinum Copywriting Repeat 10 7 7 24
C-1 Platinum Internal New 7 6 9 22
B-3 Platinum Reviews Repeat 8 6 6 20
C-3 Platinum Copywriting Repeat 7 7 6 20
A-3 Platinum Internal New 5 7 7 19
B-1 Platinum Q&As Repeat 7 7 5 19
C-2 Platinum Reviews Repeat 6 6 6 18
Most projects:
Total reviews: