# Excel in the K-12 Classroom

January 25, 2006

Most teachers have computers in their classroom, but don’t know how to utilize Excel. In this segment, we’ll take a look at 3 classroom uses for Excel:

1. Create customized math exercise sheets
3. Track Attendance

## Customized Math Exercise Sheets

Say that your first graders need to work on adding digits 1 to 9 where the sum does not exceed 10.

• Tools - Add-Ins - Make sure Analysis Toolpack is turned on
• For the top addend, use `=RANDBETWEEN(1,8)`
• The second addend needs to be a number between 0 and (9-top number). Use a formula of `=RANDBETWEEN(0,(9-B2))`

• Apply formatting, copy the formulas to create multiple problems.

Every time that you type the F9 key, you will produce a new worksheet.

## Track Attendance

• Enter the student names down column A, starting in row 2.
• Enter the date for the first day of school in C1.
• Move the cellpointer to C1. In the lower right corner, there is a square dot. This is the fill handle. Right-click the fill handle and drag to the right. Drag out for 180 columns. When you release the fill handle, choose Fill Weekdays.
• To use the chart, enter an "X" for any day the student is absent.
• The formula in B2 is `=COUNTIF(C2:IV2,"X")`

• The formula in B4 is `=VLOOKUP(\$A4,\$A\$34:\$I\$56,2,FALSE)`. This will return the test result from column B for this student.