Sunday, March 15, 2015

Excel Gradebook Lesson #1

http://www.youtube.com/watch?v=Id30wy2JmQ0

Compose a Gradebook of at least:
10 Students- Last name, First name
3 Categories- HW, Quiz, Test
At least 5 HW, 3 Quizzes, 3 Tests

Quizzes 30%
Homework 30%
Tests 40%

Remember-
All Grades should be formatted to 2 decimal places.
Names must be realistic.
Grades  MUST BE VARIOUS REALISTIC RANGES- no more than 2 students may make 100 in any given category. No more than 2 students can make the same grade in any given catagory. There should be no more than two 0's in the entire grade book.  Shoot for target final grades evenly ranging between 65 and 98.
Titles must be justified center as shown in the video.
Names must be alphabetized using the filter tool as shown in video.


No comments:

Post a Comment