Lesson Plans

These directions will enable you to create your lesson plans via the computer.
Directions:

1. Double click on MS Word.
2. Type in a Title.
3. Click on Table.
4. Click on insert.
5. Click Table.
6. See Insert Table window.
7. Select the number of columns and rows.
8. Click OK.
9. See Table.
10. Adjust table size to the size needed by placing your arrow over the lines; click and drag the lines to where you need them. See table sheet if needed.
11. Click File.
12. Click Save as.
13. Name the file, Lesson Plan.
14. Click on the arrow in the save as type.
15. Select document template.
16. Click Save.
17. Click File and Close.
*Note- You have now save the file as a template. When you want to create a new lesson plan adhere to the following directions.

Directions:
1. Double click on MS Word.
2. Click File.
3. Click New.
4. Find the name of the lesson plan template in the general tab.
5. Double click on the template.
6. See Lesson plan template.
7. Click in the table and insert the information for daily lesson plans.

Creating a Grade Book using Microsoft Excel

Directions:
1. Double click on Microsoft Excel icon.
2. See Spreadsheets

Important Excel Information

• Excel files are save as workbooks. A workbook can contain several worksheets.
  
• Each worksheet has a sheet tab at the bottom to identify the contents of that sheet.
  
• The worksheet is divided into cells by gridlines. The currently selected cell has a black border around it.
  
• A cell reference consists of a column letter and a row number. The cell reference of a selected cell will appear in the name box located immediately above the worksheet on the left.
  
• The letters at the top of the columns are called column heading and the numbers beside the rows are called row headings.
  
• Magnification- to enlarge or reduce the visible workspace or your worksheet by clicking on the zoom button on the toolbar.

Navigating around the worksheet

Use the vertical scroll bars on the right to move up or down.
Use the horizontal scroll bars on the bottom to move side to side.
Tab- moves to the next cell to the right.
Enter- moves to the next cell down.
Ctrl+end- moves to the last intersection of the last row and column that contains data.
Ctrl+home- moves to the first cell in a worksheet.
Ctrl+ arrow- moves to the last cell in the direction of the arrow.

Highlighting cells

To select an entire row, click on the row heading.
To select a column, click on the column heading.
To select an entire worksheet, use Ctrl+A.
Click and drag to select several cells.

Entering data

To enter data in a cell, click the cell and start typing.
As you type use the delete key to correct errors to the right of the cursor or backspace key to correct errors to the left of the cursor.
To modify data in a cell, double click in the cell.
If you make a mistake use the undo button on the tool. bar.

3. Click in the first cell in the first row and column.
4. This row is going to be our field row. Name the fields as shown, make sure you bold and underline the words.
5. Enter the student information to in each cell.
6. Put rest pointer on sheet 1 then right click.
7. Click rename.
8. Type and rename sheet as master sheet then click in a cell.
9. Put rest pointer on Master sheet then right click.
10. Click Move or Copy.
11. Click Master sheet and place a check in the box for create a copy.
12. Click Ok
13. See in new sheet inserted in Book
14. Put rest pointer on Master sheet (2) then right click.
15. Rename this sheet grade book.
16. Create the following fields and enter data as shown below.
17. Click in cell G2.
18. Click the paste function key on the toolbar.
19. See paste function screen.
20. Click average in the function name section.
21. Click OK.
22. See the average screen.
23. Click Ok
24. In cell G2 will display the students average.
25. Continue to average each student's scores (step 18-24.)
26. To add a column for a new test or quiz, click on column heading G.
27. Right click.
28. Click insert.
29. See a new column and enter the necessary data.
30. After entering data for test or quiz score, press the enter key. Excel will automatically update the average.