From the course: Office for Educators

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Creating the gradebook layout

Creating the gradebook layout - Microsoft Office Tutorial

From the course: Office for Educators

Creating the gradebook layout

Before we get started adding content and functionality to our grade book, we need to go ahead and give it some structure. In order to see the grade book a little easier, the first thing I'm going to do is go ahead and change my view down to about 75%. Clicking on the Zoom tab, I can come over here and make sure I'm at 75 and click OK. I can now see a little bit more of the space I have to work with. Now my grade book needs to have a place for a students' first name, last name, grade and a spot for the assignment name. Which means that my first assignment isn't actually going to start until I get to column E. If I'd like space for 30 assignments, that means that my grade book needs to be at least 34 columns wide. Furthermore, because there's three spaces that'll be taken up in the header and I would like to have room for 30 students, I need to end up with a grid that's going to be 34 wide by 33 tall. I'm going to go ahead and place my cursor in the first cell and just start dragging…

Contents