Join Aaron Quigley for an in-depth discussion in this video Freezing frames and cleaning up, part of Office for Educators.
We are getting very close to finalizing our grade book. The last few changes are going to make the grade book easier to use and make it look a little bit nicer. The first thing I would like to be able to do is as I have to enter grades all the way over on the right-hand side out in the 30th and 31st assignment area I want to make sure I still line them up to the proper student name. Furthermore, as I scroll down and I'm entering grades down here for Mike Warner and Scott Waldrip, I want to make sure that I'm putting them in the proper columns for the proper assignments. I can accomplish this using something called freeze panes.
The way freeze pens works is you tell Microsoft Excel exactly where you want it to scroll. For example, if I scroll up, maybe I want all these assignment titles to stay fixed on the page and to not scroll with the rest of the page. The same thing if I scroll right or left. Maybe I want the student names to stay fixed on the page and not scroll with the rest of the page. Whenever I decide to use freeze paints, the important things to remember are up and left. Wherever my cursor's at, everything above it and to the left of it is going to be frozen. So I'm going to go ahead and put my cursor right here, on the first assignment, the first grade, for the first student.
Under the View tab on the main navigation, I'm going to go ahead and select Freeze Panes. And then Freeze Panes again. What this has done is everything up has now been frozen. And everything left of that has now been frozen. So when I scroll down, I can see that the assignments, the assignment values, and the type of assignment is continuing to remain frozen on the page. Furthermore if I scroll left and right all of the student names and grades continue to remain frozen on the page. That way no matter where I'm at on my gradebook I can always line up the proper student name with the proper assignment as I enter grades.
The last thing we're going to do for this video is make one little stylistic change. If you remember back to the first video we made sure that every single border had a line to it so we knew the area that we were working with. However, now that we're getting close to finalizing our gradebook, we notice we have these two large lines over here between first name, last name and grade that probably don't need to be there. So we can go ahead and take those out so as we print our gradebook, it looks a little nicer. The easiest way to do this is just to highlight all of the sections we want to remove the borders from. Up in the top navigation, I'm going to click on Home.
I'm going to go to the border section, and I'm going to choose No Borders. Now it also remove the borders from a few things that I'd like the borders on. So to put those back, I'm simply going to highlight the boxes that we'd like to have borders on again. I'm going to choose all borders. I would like this first row to have borders as well, and I'll choose All Borders. And you can see that we've now removed some of the unneeded borders, made our grade-book look nice and formatted, and it will look great as we print it out
- Creating lesson plan templates
- Creating worksheets with math equations, charts, and graphs
- Grading papers
- Creating a gradebook in Excel
- Creating an animated presentation
- Setting up a school email account in Outlook
- Storing documents online with SkyDrive
- Creating a class website with SharePoint
Skill Level Intermediate
Q: This course was updated on 10/01/2014. What changed?
A: We added a brand new chapter on Office Mix, the PowerPoint plugin that allows educators to record interactive presentations and test students with quizzes.
Q: This course was updated on 10/15/2015. What changed?
A. We added videos for OneNote, OneDrive, and Office Online. OneDrive replaced SkyDrive as the cloud-based file service.