PLUG IN YOUR GRADEBOOK ALTERNATES



Plug in Your Gradebook Alternates

THERE IS OFTEN MORE THAN ONE WAY TO "SKIN A CAT" IN EXCEL, SO HERE ARE SOME ALTERNATE STEPS FOR SOME PROCEDURES. "PAGES" REFER TO THE PAGE NUMBER IN YOUR MAIN HANDOUT.

A. Insert a Blank Column or Row

Windows

i. To insert a blank column,

• Highlight a column

• Right click on your mouse to open a menu

• Select Insert

• The new column will appear to the left of the original

ii. To insert a blank row,

• Highlight a row

• Right click on your mouse to open a menu

• Select Insert

• The new row will appear to the above of the original

Macintosh

i. To insert a blank column,

• Highlight a column.

• Press Command+I (= OpenApple+I) or go to Insert >> Columns.

• The new column will appear to the left of the original.

ii. To insert a blank row,

• Highlight a row

• Press Command+I (= OpenApple+I) or go to Insert >> Rows.

• The new row will appear to the above of the original.

B. Creating a SS# Last 4 digits column (page 3)

Assume the SS# (Student Number) is in column B.

1. First insert a blank column after column B. This new blank column should now be column C.

2. In Cell C2, type in the following formula: =RIGHT(B2,4), then hit Enter (Win) or Return (Mac).

You should now see the last four digits of the first Student Number.

3. To copy the formula in the rest of the column:

a. Highlight Cells C2 to C16.

b. Select Edit >> Fill >> Down.

The last four digits of the other Student Numbers should now be filled in.

4. To change the formula to plain numbers

a. Highlight column C.

b. Select Edit >> Copy

c. Now select Edit >> Paste Special to open an options window. Choose Values under the top set of Paste options. Click OK.

Column C should now contain plain numbers.

C. Calculating Class Percentage (page 4)

Assume that the total points earned by each student is listed in Column W.

1. Type in "Percent Total" as a column header in Cell X1.

2. The total number of possible points for this course is 490.

3. In Cell X2, type in the following formula: =W2/490. Hit Enter (Win) or Return (Mac). You should see a number (we will reformat it shortly).

4. Fill down the formula for the rest of the column.

5. Format as percentage following original instructions (Windows only, see below for Mac).

D. Format as Percentage (page 5)

Works for both Windows and Macintosh.

1. Highlight the cells you want to format as a percentage.

2. Select Format >> Cells.

3. Make sure the Number tab is selected.

4. Select Percentage in the left menu.

5. Fill in the appropriate number of Decimal Places. Click OK. The numbers should be in percentage format.

E. Calculating the frequency of a distribution of scores (page 6)

Assume that letter grades are in Column Y from Cell Y2 to Cell Y16.

1. In Cell AA1, type in "Grade".

2. In Cell AA2, type in "A". Type "B" in Cell AA3, "C" in Cell AA4, "D" in Cell AA5 and "F" in Cell AA6.

3. In Cell AB1, type in "Frequency".

4. Type in the following formula in Cell AB2: =COUNTIF($Y$2:$Y$16,AA2). Hit Enter (Win) or Return (Mac).

(I'll explain the "$" shortly)

5. You should now see how many "A's" were earned.

6. Fill down the formula for the rest of the column. The "$" will mean that the same range Y2-Y16 is selected in each version of the formula.

7. You should see how many of each grade was earned.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download