• Youworkforacompanythatdoeseducationalconsulting.YourbossknowsthatyouareageniuswhenitcomestoExcelanddecidestoimposeuponyoualittleheassignsyouaprojecttocreateanExcelspreadsheetthatwillbeateacherscompanion.Ithastohaveaninputareaforthegrades,rankthem,splitthemintodifferentquartiles,createrelevantcharts,giveallthesummarystatisticsthatarerelevant,colorcodegradesthatneedtobelookedinto,haveaconditionalformathighlightingwhenastudentdoesbetterorworsethanpreviousexams,showrelevantlookupvaluesforgradesaccordingtonumberandletter,haverelevantpivottables,etc.Thegoalisthatitisastand-alonetoolforteacherstousetoassesseverythingpossibleaboutastudent.

I started some of it already under the teachergradebookproject.xlsm

but i need to make sure I include everything in the project rubric.xlsm

include relative absolute and mixed cell reference

use all the summary statistics (sum, average, min, max, count, etc.)

use at least three different instances of date and time functions

use at least three different formats such as number, date, custom etc.

use at least three different instances of nested if functions

use vlookup and index/match functions

create and use range names and use them in formulas

have a chart with axis names, chart title, etc. describing the data

use data bars

use at least three instancs of conditional formatting, one of which needs to be custom formatted

design a table

sort the table at two levels or more

use the subtotal function

have grouped data

have at least three relevant pivot tables with at least two calculated fields

have a slicer available for the pivot table

create a one variable data table

create a two variable data table

use scenario manager or solver (with saved and summarized scenarios)

use advanced filters

use the database functions

use the sumif(s), countif(s), averageif(s) functions

use rank, percentrank, quartile, frequency, stdev, and correl functions

create a histrogram

at least three different formulas using arrays

at least two cases of data validation

include relative absolute and mixed cell reference

use all the summary statistics (sum, average, min, max, count, etc.)

use at least three different instances of date and time functions

use at least three different formats such as number, date, custom etc.

use at least three different instances of nested if functions

use vlookup and index/match functions

create and use range names and use them in formulas

have a chart with axis names, chart title, etc. describing the data

use data bars

use at least three instancs of conditional formatting, one of which needs to be custom formatted

design a table

sort the table at two levels or more

use the subtotal function

have grouped data

have at least three relevant pivot tables with at least two calculated fields

have a slicer available for the pivot table

create a one variable data table

create a two variable data table

use scenario manager or solver (with saved and summarized scenarios)

use advanced filters

use the database functions

use the sumif(s), countif(s), averageif(s) functions

use rank, percentrank, quartile, frequency, stdev, and correl functions

create a histrogram

at least three different formulas using arrays

at least two cases of data validation

Project Grading Rubric You will be graded on the inclusion of the below ideas (but you should certainly include more). You will also be g on the clarity, neatness, compactness, and overall presentation of the project. You will earn a better grade by d something that utilizes multiple functions, shows your mastery of the tools at hand, and presents the picture unifying and non-cluttered way.Remember, you have more than a month to do it, so I will be expecting somet professional. 1 include relative absolute and mixed cell reference 2 use all the summary statistics (sum, average, min, max, count, etc.) 3 use at least three different instances of date and time functions 4 use at least three different formats such as number, date, custom etc. 5 use at least three different instances of nested if functions 6 use vlookup and index/match functions 7 create and use range names and use them in formulas 8 have a chart with axis names, chart title, etc. describing the data 9 use data bars 10 use at least three instancs of conditional formatting, one of which needs to be custom formatted 11 design a table 12 sort the table at two levels or more 13 use the subtotal function 14 have grouped data 15 have at least three relevant pivot tables with at least two calculated fields 16 have a slicer available for the pivot table 17 create a one variable data table 18 create a two variable data table 19 use scenario manager or solver (with saved and summarized scenarios) 20 use advanced filters 21 use the database functions 22 use the sumif(s), countif(s), averageif(s) functions 23 use rank, percentrank, quartile, frequency, stdev, and correl functions 24 create a histrogram 25 at least three different formulas using arrays 26 at least two cases of data validation more). You will also be graded earn a better grade by doing nd presents the picture in a will be expecting something CSCI 48 Angelina Greco Assignment Date 6/18/2016 10 Total Possible Points Err:508 8/8/2016 Student Name Abbasova, Ramilya Adedjouman, Iskandar Bauman, Brian Blau, Gavriel Chil-Gevorkian, Narek Durham, Deven Glatzer, Joseph Guan, Uling Heisler, Marc Hsiu, Kevin Kaur, Navdeep Khairy, Sara Li, Zhen Zhu Lin, Eric Morari, Antonina Muhammad, Wali Newton, Travis Poltorzycki, Alexander Summers, Chaim Average Grade/Scores Performance Err:508 Grade Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 % Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Total Points Earned Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Page 1 of 10 6/25/2016 7/1/2016 6/20/2016 6/29/2016 7/4/2016 7/15/2016 10 10 30 30 30 50 Test 1 29 20 23 19 22 20 26 28 29 30 18 25 27 26 26 27 13 20 29 Test 2 30 30 28 26 25 25 28 25 22 26 23 23 21 20 29 26 26 21 27 Test 3 27 26 27 22 26 19 30 28 25 24 23 26 28 29 21 20 18 23 24 Final Exam 44 42 33 28 36 46 22 25 39 39 39 35 45 32 46 30 20 26 43 Err:508 Err:508 Err:508 Err:508 Homework Homework Homework Assignment Assignment Assignmen 1 2 t3 10 10 9 8 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 9 10 10 10 10 8 10 8 10 7 10 10 10 10 9 10 10 10 10 10 0 10 10 9 10 10 10 10 10 10 10 9 9 10 10 10 9 10 Err:508 Err:508 Err:508 CUNY QUEENS COLLEGE Print All Angelina Greco CSCI 48 Progress to date 8/8/2016 Student Name: Durham, Deven Student Rank Err:508 Letter Grade Percentage Student Points Total Points GPA B- 82% 140 170 2.67 Student Progress 60 46 50 40 30 25 20 20 10 10 10 10 0 Total Points Student Points 19 Data Grade Sum - % Err:508 Sum - Total Points Earned Err:508 Total Sum - % Total Sum - Total Points Earned Student Name % Abbasova, Ramilya Abbasova, Ramilya Result Err:508 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Adedjouman, Iskandar Adedjouman, IskanBauman, Brian Bauman, Brian ReBlau, Gavriel Blau, Gavriel Result Err:508 Err:508 Err:508 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Chil-Gevorkian, Nar Durham, Deven Durham, Deven ResGlatzer, Joseph Guan, Uling Heisler, Marc Heisler, Marc R Err:508 Err:508 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Hsiu, Kevin Hsiu, Kevin Result Kaur, Navdeep Kaur, Navdeep RKhairy, Sara Khairy, Sara ResuLi, Zhen Zhu Err:508 Err:508 Err:508 Err:508 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Li, Zhen Zhu ReLin, Eric Lin, Eric Result Morari, Antonina Morari, Antonina ResuMuhammad, Wali Err:508 Err:508 Err:508 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Muhammad, Wali RNewton, Travis Newton, Travis Result Poltorzycki, Alexander Poltorzycki, Alexande Err:508 Err:508 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Summers, Chaim Summers, Chaim Total Result Err:508 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Calculate Letter Grade GRADE & GPA Table Score 0% 60% 63% 67% 70% 73% 77% 80% 83% 87% 90% 93% 97% Letter Grade Achieved F DD D+ CC C+ BB B+ AA A+ GPA 0.00 0.67 1.00 1.33 1.67 2.00 2.33 2.67 3.00 3.33 3.67 4.00 4.00