Viewers: in countries Watching now:
Teachers, your time is valuable. Learn to reduce your workload, streamline grading and lesson planning, and share resources with students and other teachers with Microsoft Office. Aaron Quigley teaches you how to use Word's templates to create lessons and worksheets more efficiently, use Track Changes to digitally grade papers, build gradebooks in Excel, give presentations from PowerPoint, collaborate over SkyDrive, and connect using Outlook and SharePoint. These lessons are explored using sample lessons, homework, and tests like you'd find at a real-world school. And at the end of each section, Aaron invites you to test what you've learned in a video challenge.
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 that grid out. I'm going to go ahead and drag all the way to the right until I reach 34. Right next to my cursor, I can see a little indicator that I am now at 34, that's column and I'm going to go ahead and drag straight down until I reach 33.
There it is. I've now outlined the basics of my grade book. To make sure I can continue to see the workable space, I'm going to add some borders to this. I'm going to go ahead and go back to Home. I'm going to go to the Border icon and select All Borders. There we are. So far, we've got the basic layout done. Now we said that we need to have a place for the students' First name, Last name, Grade, as well as the Assignment name. And then underneath the Assignment name, we probably want to have space for Total Points and the Type of Assignment.
Right away, you can see that First, Last, and Grade are at the top of the grade book. I need to make sure that those end up directly down here right above where the name is going to be entered. To do this, I'm going to merge those cells by clicking and highlighting those three cells, I can then click on merge in center and it will automatically center those titles and drop them down to the appropriate places. Now, right where it says Assignment Name, it would be really hard to type in these tiny little boxes all the assignments we're going to do for this course. So what I'm going to do is I'm going to go ahead and grab between the one and two rows and I'm just going to drag this down to about, let's say, 100 pixels.
Looks good. There we go. Now unfortunately, look at Assignment Name, it still overlaps into the second cell. To change this, we're actually going to change the orientation of the text. I'm going to go ahead and click in the first assignment cell and drag all the way to the end of our grade book which should be There it is. I'm going to come up to Format Cells, and I'm going to go all the way down and click on the Format Cells icon. Here, I'm going to click on the Alignment tab. And I'm going to go ahead and change this alignment all the way up to a 75-degree angle and click OK.
You'll now notice that our grade book looks somewhat similar to those charts you can buy and hang in your classroom for tracking student data. What you'll also notice is that unfortunately, only the first cell shows angled. That's because the rest of these cells don't have any content yet. Doing something as simple as putting a period will actually give that cell some content where all of a sudden, it will show up angled as well. Now, while some of you won't mind your cells not being angled until you type the assignment in, if for some of you, you find it frustrating they don't look the correct way right away. You can just copy that period you placed in the first cell, pace it across to the rest of these cells.
And right away, our grade book starts to take shape with the angled section for the assignment name, a points column, a type column, a place for the student grade to go, a place for their first name, and their last name to show up. At this point, our grade book has some basic structure to it and it's time to start adding some functionality.
Find answers to the most frequently asked questions about Office for Educators .
Here are the FAQs that matched your search "" :
Sorry, there are no matches for your search "" —to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.