Procedure for Managing Interviews in Spreadsheet

Interviews.

The initial questions are set up in the first worksheet (with the teacher's name and the interview title in A1) and are typed entirely in column "A." This way, the "A" can be clicked to select the entire column when changing font. After the "preview" button is once used, page breaks will be visible by a dotted line. Children can alter row heights manually to spread out the text vertically by placing their mouse over the border between numbers on the left. When exactly over a line, their mouse should changed from a fat cross to a skinny one, and they can click down and drag the heights bigger. They should be taught to use "preview" to perfect the spacing.

To create a record of interviews with individual teachers (or other students), the tabs at the bottom, usually labeled "Sheet1," should be clicked in and changed to the teacher's name.

The worksheet is ready to be printed and used during the interview.

When the results are ready to be typed, all answers should be typed in column "B", and the column width manually adjusted to that of the answer. It may help to set the text to wrap in column "B." To do this, click the "B", which selects the whole column, click "Format" "Format cells" to get a dialog box. Click "Alignment" and click "wrap text."

When a second teacher is ready to be interviewed, the student clicks "A", "Edit," "Copy," then clicks "Sheet2," "Edit" "Paste." The spacing will not copy, so the child will need to manually readjust the verticle spacing. The tab "Sheet2" will need to be changed to the new teacher's name as well as the worksheet heading in cell A1.

When more than three worksheets are needed, the student clicks "Insert" "Worksheet."