Gradebook Quiz

If the table for looking up course letter grades and quality points was restructured to correspond to the required format for VLOOKUP, course letter grades and quality points for students with scores below 70 would show: Question options: 1) the right values 2) values that are too high 3) values that are too low 4) an error condition

1) the right values

Intending to create a pivot table on the course averages, a user selected Insert, PivotTable, New Worksheet, and OK, which resulted in a PivotTable Field List with only one entry: "Gradebook data" in the "Choose fields to add to report:" panel. The user's error was: Question options: 1) Failing to have the cursor in the right sheet 2) Failing to select the right data range 3) Sending the pivot table to a new sheet 4) Selecting too many attributes for the pivot table

2) Failing to select the right data range

Suppose one of your colleagues who is not a skilled spreadsheet user will use the gradebook spreadsheet occasionally for classes of 100 students or less. The approach you would recommend for replacing missing quiz scores with zeroes while coloring those cells yellow is to: Question options: 1) Create a macro that loops through the quiz score range while setting missing values to zero and coloring the cells yellow 2) Use the Go To Special function on the quiz score range to color the cells with missing values to yellow and set them to zeroes 3) Highlight adjacent cells with missing values, manually color the cells yellow, and then change the missing values to zeroes 4) Color the range of the quiz scores yellow, enter zeroes in all the cells for which the quiz score is missing, and reverse the color for cells with zeroes

2) Use the Go To Special function on the quiz score range to color the cells with missing values to yellow and set them to zeroes

To tidy up the spreadsheet, a user copied the information on the parameters2 sheet to the scores2 sheet in columns to the right of the student data columns. This approach is: Question options: 1) desirable because all the information is in a single sheet 2) undesirable because of the risk of introducing errors 3) desirable because it reduces the complexity of the sheets 4) undesirable because it makes the parameters hard to see on small screens

2) undesirable because of the risk of introducing errors

One approach to weighting the components of the course average is to insert enough columns after each component to put the weight in a column followed by a column containing the product of the weight and the component score. Suppose the weight for exam 1, i.e., .15, was entered in one column and the formula for applying that weight to the score was entered in the next column. Then these two formulas were copied into the rows for all the students. This approach is: Question options: 1) efficient and makes the computations visible for easy verification 2) inefficient because all the calculations are performed in one column 3) likely to lead to errors when the component weights are changed 4) unlikely to give correct results for students missing one of the exams

3) likely to lead to errors when the component weights are changed

Suppose a user developed the following macro and wanted to create a new macro to sort students by team. The easiest approach is to: Sub MacroSortAverage() ' ' MacroSortAverage Macro ' Sort students by course average ' ' Keyboard Shortcut: Ctrl+v ' Range("A7:BK135").Select ActiveWorkbook.Worksheets("macro sorts").Sort.SortFields.Clear ActiveWorkbook.Worksheets("macro sorts").Sort.SortFields.Add Key:=Range( _ "BI8:BI135"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _ xlSortNormal With ActiveWorkbook.Worksheets("macro sorts").Sort .SetRange Range("A7:BK135") .Header = xlYes .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With End Sub Question options: 1) edit the existing macro 2) copy and edit the macro 3) record a new macro 4) copy the macro to a new sheet

3) record a new macro

For all questions, assume that copies of the scores and parameters sheets have been made, named scores2 and parameters2. The questions are independent of each other and are based on the scores2 and parameters2 sheets as copied. The best formula for combining the two parts for exam 1 and awarding adjustment points to the first student is: 1) = (S8+T8)/2+parameters2!H16,"") 2) = (S8+T8)/2+parameters2!$H$16,"") 3) = IF(S8+T8>0,(S8+T8)/2+parameters2!H16,"") 4) = IF(S8+T8>0,(S8+T8)/2+parameters2!$H$16,"")

4) = IF(S8+T8>0,(S8+T8)/2+parameters2!$H$16,"")

Suppose formulas have been entered in the cells just above the component score heading row (scores2 sheet) that reproduce the course weightings from the parameters2 sheet. Performing the operations listed below will give course averages for students that: 1 Develop formulas that combine each exam's parts into a score out of 100 and adds the adjustment points 2 Create a formula that averages the first student's scores by referencing absolutely the weights above the columns 3 Copy the formulas for the first student into the rows for other students Question options: 1) Show error conditions for the averages 2) Are higher than the correct averages 3) Are equal to the correct averages 4) Are lower than the correct averages

4) Are lower than the correct averages

For the purpose of using VLOOKUP to show the letter grade corresponding to the course average, the existing range with Grade, Range, and Quality Points on sheet parameters2: Question options: 1) Is usable as it is 2) Must be resorted 3) Must have its columns reordered 4) Must be resorted and have its columns reordered

4) Must be resorted and have its columns reordered

If quizzes are weighted equally regardless of how many points each one has and blank quiz scores have been replaced with zeroes, the following formula for determining the quiz score average out of 100 points: =(SUM(D8:R8)-SMALL(D8:R8,1)-SMALL(D8:R8,2))/(COUNT(D8:R8)-2)*10 Question options: 1) Gives the correct quiz value 2) Understates the quiz value 3) Overstates the quiz value 4) Understates or overstates the quiz value

4) Understates or overstates the quiz value