Description:
Total Possible Score: 6.00
Distinguished - Correctly selects, calculates, and displays results for all three statistics, and uses displayed location or formulas for all values.
Proficient - Minor inaccuracies exist in the selection, calculation, and/or display of the results for the statistics.
Basic - Two of the variable statistical results are not accurate or correctly displayed.
Below Expectations - Attempts to select, calculate, and display results for all three statistics exist; however, three or more elements contain significant inaccuracies.
Non-Performance - There is either no response to Problem Two, or it does not provide correct statistical outcomes as asked for.
Distinguished - Value is correctly identified and the Excel function is used and shown.
Proficient - Value is correctly identified but the Excel function is not shown.
Basic - Shows the correct Excel function, but has selected the incorrect data and, as a result, has an incorrect value.
Below Expectations - Has an incorrect value and the Excel function used generate the answer is not shown.
Non-Performance - There is either no response to the problem, or it does not provide the value asked for.
Distinguished - Selects the correct data and performs and displays all Excel functions to correctly provide asked for values.
Proficient - Has an error in no more than one of the following elements: selects accurate data necessary for computations, displays the required Excel functions in the answer cells, and produces accurate results.
Basic - Has an error in no more than two of the following elements: selects accurate data necessary for computations, displays the required Excel functions in the answer cells, and produces accurate results.
Below Expectations - as an error in no more than three of the following elements: selects accurate data necessary for computations, displays the required Excel functions in the answer cells, and produces accurate results.
Non-Performance - There is either no response to the problem, or it does not provide probability values as asked for.
Distinguished - Selects the correct data and performs and displays all Excel functions to correctly provide asked for values.
Proficient - Has an error in no more than one of the following elements: selects accurate data necessary for computations, displays the required Excel functions in the answer cells, and produces accurate results.
Basic - Has an error in no more than two of the following elements: selects accurate data necessary for computations, displays the required Excel functions in the answer cells, and produces accurate results.
Below Expectations - Has an error in no more than three of the following elements: selects accurate data necessary for computations, displays the required Excel functions in the answer cells, and produces accurate results.
Non-Performance - There is either no response to the problem, or it does not provide probability values as asked for.
Distinguished - Provides thorough conclusions about the relationship between the data sets and the equal pay for work question, and identifies results that appear inconsistent and addresses why.
Proficient - Provides weak conclusions about one of the following issues: male and female inequality or consistency of the findings.
Basic - Provides weak conclusions about both of the following issues: male and female inequality and consistency of the findings.
Below Expectations - One of the following conclusions is not present: male and female inequality or consistency of the findings.
Non-Performance - There is either no response to Problem Five, or it does not address the issue of equal pay for equal work statistical results to date.