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 - 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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
Creating a gradebook1m 3s
-
Understanding cells2m 50s
-
Creating the gradebook layout3m 29s
-
Creating a dropdown list of assignment types3m 36s
-
Writing the grade calculation functions5m 44s
-
Using conditional formats5m 45s
-
Setting the print area3m 17s
-
Adding headers and footers2m 28s
-
Adding list sorting2m 38s
-
Freezing frames and cleaning up2m 43s
-
Replicating sheets2m
-
Challenge: Write a conditional format58s
-
Solution: Write a conditional format4m 20s
-
-
-
-
-
-
-
-
-