Excel Gradebook February 15, 2007
Posted by admin in : February 2007 Professional Development , trackbackI. Intro – What Can Excel do for me
II. Workbook – Header and Footer; Columns and Rows
III. Worksheets – Insert, delete, rename, copy
IV. Cell Reference – Naming procedure
V. Cell Formatting – Font, font size, color, bold, italic, underline, borders, alignment, wrap text, number, currency, text.
Battleship with cell formatting
VI. Column & Row Formatting – Resize width and height
VII. Setup a Gradebook Worksheet;
1. Cell A1 Enter text ‘Gradebook for 6th Grade Math – Trimester 1
2. Highlight Cells A1 through L1.
3. Select Merge and Center tool
4. Cell A2 enter ‘Student Name’
5. Cell B2 enter Quiz 1
6. Auto Fill Quiz 2 through 10
7. Enter at least 5 students names in the A column
8. Enter Quiz scores for each student in Quiz 1 Column B
9. For Quiz 2 write a formula using cell references to calculate Quiz 1 scores – 2
8. Calculate the total score for each student – Use Sum function
9. Calculate the average score for each Quiz – Use Average function
10. Create borders on cells
11. Window > Freeze and Unfreeze Panes
VIII. Edit > Move or Copy Sheet > Copy.
IX. Rename Worksheets: Trimester 1; Trimester 2; Trimester 3
Color Code Tabs
X. Inserting and Deleting Columns and Rows
XI. Page Setup (File menu) – portrait or landscape?
100% or fit to one page wide by 1 page tall?
Print area?
Columns to repeat at top?
Rows to repeat at left?
XII. File > New > Templates – Microsoft Office Online
Gradebook
Family Budget
XIII. Tutorials – Atomic Learning
http://www.atomiclearning.com/excel_2003_intro
Comments»
no comments yet - be the first?