Using+Excel

To generate a self scoring test –


 * 1) Open the excel program
 * 2) Type the test.
 * 3) Insert a column to record the correct answer or an “X” for an incorrect answer. Insert column A.
 * 4) Type the following formula in column A to check if the correct answer has been provided. =IF(B7=”exasperate”,1,”X”)

A. The = sign indicates the beginning of a formula. B. IF – begins an IF condition exists then do something. C. B7 – is the cell that will be checked for the condition.
 * 1)  “exasperate” – letters and word answers must be enclosed in quotation marks. Numeral answers do not require quotation marks.
 * 2)  1 – represents one point to be used to calculate the test percentage. You are able to weight questions by assigning a different numeral. If cell B7 contains the word exasperate, then a point will be awarded for the correct answer. Students must spell the word exactly as the condition you establish to be checked. The most common error in students recording their answer is that the put a space after the typed response. It will be marked wrong.
 * 3)  X – An X will be recorded in the cell in which the formula has been typed if the condition in B7 is does not match. It must be typed in quotation marks, as it is a letter. Note: The answer in B7 does not have to be a word. It can be a letter for multiple choice or a numeral.


 * 1) Insert a row at top of the test or use an empty cell to generate the test score.
 * 2) Type the following formula - =Sum(A1:A50)/25


 * 1) = indicates the start of a formula.
 * 2) Sum – means to add the numerals for the range of cells identified.
 * 3) A1 – first cell that a score could be recorded followed by a colon.
 * 4) A50 – is the last cell that a score could be recorded. The range must be enclosed in parenthesis.
 * 5) / indicates divided by.
 * 6) 25 is the total possible points on this test.


 * 1) Change the grade to a percentage.

A. Click on the cell containing the formula to calculate the grade.
 * 1) Select FORMAT on the Menu.
 * 2) Select CELLS
 * 3) The Numeral tab should be open. If not, click on the Numeral tab.
 * 4) Click on percentage.
 * 5) Indicate the number of decimal places desired by clicking on the arrows.
 * 6) Click OK.
 * 7) If ###### appears, widen the cell to display the percentage.

Hiding Rows and Columns –

You do not want students to see Column a identifying the correct answer or the Row indicating the percentage correct.
 * 1) To hide them, click on the column to be hidden, Row A.
 * 2) Select FORMAT from the Menu toolbar.
 * 3) Select COLUMN, HIDE.

Click on the row to be hidden.
 * 1) Select FORMAT from the Menu toolbar.
 * 2) Select ROW, HIDE.

MACROS –

Macros are a means of completing simple or complex tasks that are repetitive in nature.

Click on the blue square to stop recording. Your macro has been recorded and will be invoked when the button is clicked. If you need to move or change the macro, right click on the button and make the changes requir
 * 1) On the menu bar, click on VIEW, TOOLBARS, FORMS.
 * 2) On the FORMS TOOLBAR, click on the fourth button. Move the cursor onto your worksheet and a cross hair will appear. Click on the spot where you want the button to be placed. A button will appear.
 * 3) If you click on the button, you can type finished.
 * 4) Click off the button anywhere on the worksheet.
 * 5) Move the cursor over the new button and right click.
 * 6) Click on assign macro.
 * 7) You are ready to record a macro.
 * 8) Click on RECORD.
 * 9) Click on the GREY BLANK SPACE between the column indicator 1 and row indicator A. The entire spreadsheet should become highlighted.
 * 10) Click on FORMAT, COLUMN, UNHIDE
 * 11) Click on FORMAT, ROW, UNHIDE
 * 12) Click on FILE, PRINT, OK.
 * 13) Click on the column to be hidden again. Click FORMAT, COLUMN, HIDE.
 * 14) Click on the row to be hidden again. Click FORMAT, ROW, HIDE.