PowerPoint Resources for Teachers

June 2nd, 2009 Tagged PowerPoint

Office | Comment (0)

Easy ways to expand your skills in Excel, PowerPoint, Word 2007

November 28th, 2008 Tagged tools, tutorial

If you’re looking for a place to find answers about “how to” do something with Word, Excel or PowerPoint, here are two resources that will help:

http://inpics.net/ This website shows you, a picture at a time, how do accomplish a task. Just click on the software (remember, we’re using the 2007 version), then click on your choice. There is also a search function, so you can search for specific tasks you are trying to accomplish.

http://www.woopid.com/. This website has short videos that show and tell you how to accomplish a task. Like Inpics, this website has a search function, but it also has a place to browse through the offerings (which go beyond Office 2007). Go to: http://www.woopid.com/channels.php, click on Windows, and you’ll see a list of Office sofware – Excel, PowerPoint, and so on. If you click on PowerPoint, for example, you’ll see a list of different videos available. You’ll see “login” and ”sign up now,” but you don’t have to register to use the website. Just find the video you want, and watch it!

These tools might be a good way to learn a few new tricks – and you don’t have to go to a class to do it! Enjoy.

Thanks to Richard Byrne, blogger of “Free Technology for Teachers” for these great resources. http://freetech4teachers.blogspot.com/2008/11/computer-tutorials-in-pictures-and.html.

Office | Comment (0)

Using the right click in Word

September 14th, 2008 Tagged right-click, word

Ever wonder why there are two (2) buttons on the mouse? This is so that you can do things you often want to do with text, but without having to find the right place on the ribbon and tabs. Each Office program offers different functions when you right-click, but these can save you a lot of time and trouble. In Word, when you right-click, you are given many options:

You can change formatting:

You’ll notice that there are options to change font and font size, change text to Bold or Italic, change text color, change text indent, bullet point (and you can even change the bullet).

You can even change the type Style (Title, Heading1, etc.) by clicking on either of Styles (down at the bottom) or the A with a pen next to it at the top.

Generally you need to click on the text you want to change, then right click. Sometimes, you’ll need to highlight the text you want to change.

You’ll also notice that there are drop-down arrows, which provide additional choices. 6For example, if you click on the Type Style’s drop down arrow, you’ll be given a menu of the type styles, right there.

If you’ve highlighted text, you can cut, copy or paste it, insert a hyperlink, change the formatting to bullets or numbering.

If you’ve clicked on a word, you can find synonyms, or even translate it into another language.

You can even look up information about a topic on-line, by right clicking on a word, and then selecting Look Up…

Don’t get disappointed if it doesn’t work the first time. It can take a little practice to click or highlight correctly, so Word knows what you want to do.

Office | Comment (0)

Adding a new document too cumbersome???

September 14th, 2008 Tagged office word excel powerpoint

Are you annoyed by the way you have to click several times in the new Word 2007, just to get a new document? First Office button, then New and then Blank Document. Want a short cut?

Ctrl + N (press the control key while you press the N key at the same time) will get you a new document if you’re in Word, a new spreadsheet if you’re in Excel, and a new presentation if you’re in PowerPoint. It takes a bit of a reach, but sure beats all that clicking around.

For similar useful information (from this year and last year), see www.franblo.edublogs.org where this message is also posted.

Office | Comment (0)

Using Excel to keep track of basic information

July 3rd, 2008 Tagged communications, Excel

Suppose you’d like to keep a list of contacts with parents about students so that you have documentation of these conversations or emails.

Open Excel. Create column headers such as those in the example. Bold the column headers. Adjust the column widths by clicking between the column letters and dragging to the right until you have the width you like.

A	B	C	D
Parent Contacts

Name	Date	Email/phone	Communications

Click on the column which is likely to have a lot of content, in this case Email/Phone Communications. Highlight the column by clicking on the column letter, in this case D, and then on Wrap Text (in the Home tab). This will allow you to have lots of content without having your spreadsheet be two feet wide. It will look something like this when the text wraps:

As you’re entering data, you’ll notice a couple of things. Dates: As you enter a date, Excel often changes the format. If you prefer a different format, highlight the column by clicking on the column letter, then click on General in the number area in the Home tab. You have many choices for date here (including More Number Formats at the bottom).

Names: if you enter a student’s name a second time, Excel will offer the entire name as you start to type it in. If this is the name you want, just press enter. If this is another student, just continue typing the different student’s name.

You could just use this as a way to keep notes. However, Excel has some handy features that will make this even more helpful. Suppose you want to see all the notes about one student together. You can sort your data. Here’s how:

First either highlight all your data, or click somewhere inside your spreadsheet data. Then click on the Data tab and then on Sort. Click on the down arrow next to Sort by and you will see a list of columns to sort by. You’ll notice that Excel has figured out that you have column headers and has entered them here. You can change what you want to Sort on and the Order if you wish as well. Click on OK to actually sort.

If you forgot to bold your column headers, Excel won’t know what you want, so you may need to click on the red X and correct this before you continue.

If you mess up, use the handy undo key.

Now you have a list sorted by student, so that all the information about one student is together, handy if you have to speak about this student to an administrator or parent.

Of course, you could also sort by any of the other headers. And since you have more than 2 columns, you can even do a multi-level sort. Simply click on Add level and determine how you want your data sorted.

To make your sheet even more useful, date stamp it. Click on the Insert Tab, then on Header/Footer, then on Current Date. It looks odd on the sheet, but this will give you the current date every time you print out this sheet, handy in seeing if this is the most recent one.

You have one more thing to do to make your spreadsheet useful. So that everything prints out on one page, change the page orientation, like this. Click on the Page Layout tab, then Orientation, then on Landscape. This changes the way your spreadsheet will print.

If this still doesn’t put it all together you’d like, click on the Page Layout tab, then on Size, then on More Paper Sizes (at the bottom of the choices). You’ll get this Page Setup dialog. Click on Fit to. If you think putting it all one one sheet will make it too tiny, then make it 1 page(s) wide by 2 (or more) page(s) tall. (You can also get to this dialog via Print Preview.)

To see what this will look like without wasting paper, click on Microsoft Office button (where the File button used to be), then Print, then Print preview. One of the options in the Print preview view is Page Setup so you can modify things until you’re happy with what you see.

Now you have a spreadsheet, sorted by student name, ready to use.

If you want the gridlines to show when you print (often gridlines makes the sheet easier to read), click on Gridlines to Print in the Page Layout tab.

There are many other tasks you can accomplish with Excel. This is just one example.

Office | Comment (0)

Lo and Behold

PowerPoint Resources for Teachers

Easy ways to expand your skills in Excel, PowerPoint, Word 2007

Using the right click in Word

You can change formatting:

Adding a new document too cumbersome???

Using Excel to keep track of basic information

Meta

Recent Posts

Tags

Categories

Recent Comments

Pages

Archives