EXCEL for the Classroom

1
EXCEL for the Classroom

Fundamentals for Getting Started Using Excel
for Recording Grades Attendance
2
Opening Closing Files
Click

• File Open, New, or Close
  (same as WORD PowerPoint)
• Save Save as (same as WORD
  PowerPoint)

3
Cell Names (address)

• Columns are lettered A, B, C ..ZZ

• Rows are numbered 1, 2, 3,4 ...)

For Cell name, Call letter 1st then the number
as in E4
4
Getting Around in Excel

• Move cursor by using
• 1. Mouse Click on any cell
• 2. TAB Key Moves to right
• 3. Arrow Keys scroll
  any direction

5
Types of Cells

• Numeric - when a number is used as its numeric
  value (22) or (D1D2)
• Alphanumeric- letters, symbols, numbers which
  have no numeric value (Jane Doe) (410-60-9900)

Every cell is one or the other, but not both
6
Entering Formulas
Type formula in cell using an in front
(2 3)
Click the green check ?, or press Enter
Using the green check ? will leave the cursor
in the same cell important for filling
formulas
7
To Select or Hi-Lite Cells

• Mouse Click Drag to hi-lite
• Press F8 and use arrow keys to extend hi-lite
  (same as WORD)
• Column - click mouse in the gray area by column
  letter

• Row - click mouse in the gray area by Row
  number

8
Column Format (width of cell)
Click

• Format Column

Choose from Menu Width Autofit Selection
Hide Unhide Standard Width
9
Row Format (height of cell)
Click

• Format Row

Choose from Menu Width Autofit Selection
Hide Unhide
10
Formulas (symbols)

• (plus)
• - (minus)
• (multiply)
• / (divide)
• (power) 23 is 2 to the third power
• (D4D8) is the range of values
  including cells D4 thru D8

11
Formulas (in use)
Type Formula into cell

• SUM(D4D12) - adds all numbers in
  cells D4 thru D12
• AVERAGE(D4T4) - averages all values
  in cells D4 thru T4
• D3 - when placed in another cell calls
  the value from cell D3
• V5.5W5.25X5.25multiplies V5 by 50, W5 by
  25, X5 by 25, and adds them togetherNote the
  underline is for emphasis only!

12
Attendance with Accumulation for Semester

• Setup your grading period with each attendance
  day
• Use a number 1 for each absence
• Use SUM(range) to sum the absences for each
  student
• Setup each grading period separately on a sheet
  call the absences for that grading period for
  each student to the master recap sheet
• Formula in Cell AH4 is SUM(D4AG4) is
  filled-down thru AH13
• Formula in Cell AO4 is AH4 which calls the total
  for accumulation

13
Weighted Grades with drop scores
Formulas
Formulas are filled-down to prevent entering
them so many times click in lower right corner
of the cell, then drag drop..
14
To Print on One Page Landscape
ClickFile Page Setup
Box appears ----gt
1. Landscape
2. Fit to 1 page wide x 1 tall
3. OK
15
To Create Header
Click File Page Setup
Box appears -----------gt
Header/Footer
Custom Header
Box appears -----gt
Tab twice to Right
Type Header
OK
Grades
OK on Page Setup
16
Showing All Formulas

• Click

Tools
Options
Click Formulas On
OK
Formulas is an on/off switch