Adding an audio file in your Power Point slide

Microsoft Power Point provides a very simple and easy way to add audio files in your slides.
Learn how !

1. Open a blank power point presentation slide.

2. On the top menu, click on "Insert".

3. Go to "Media Clips" and click on "Sound".

4. Click on "Sound from File".

5. Browse and open the media file that you wish to insert. Here, we will be inserting sample audio windows media files present by default under My Music folder.

6. Select the audio file that you want to put on your presentation slide and click Ok. You will see a dialog box as follows.

7. If you choose "Automatically", you would be able to hear the sound as soon as you come to this slide. but, if you choose "When Clicked", the music will be played only when you click on the icon(speaker icon).
let us choose, "When Clicked"

 8.You can see an icon which is like a small speaker.

9. Now do a slide show or press F5 for slide show and see if this works.
When you reach the page where you have placed the sound file, click on the speaker icon and you can hear the sound.

Creating flyer in Microsoft Publisher

Microsoft Publisher can be used to make various kinds of publication documents.
Creating a new document in Microsoft Publisher 2007:

1. On the top menu bar, click File -> New

2. Click on "Flyer" to create a flyer.

3. Scroll down to Event and double-click the "Party2" flyer icon.

4. You can see the Party2 flyer template as shown below.

5. To edit the information on the flyer, click "Edit" -> "Business information".

6. After clicking on "Business Information", the following window appears.

7. Edit the information so that the changes are updated automatically on the flyer.

8. Click on "Save." the following window should appear.

8. Click on "Update Publication."

9. Some information is edited. To edit more information, click on each of the component to type in your information.

10. After the editing the components, the flyer looks like this.

11. To see a preview of the flyer and print it out, click on File -> Print Preview

Inserting Comments in Word Documents

Comments are used to insert information in Microsoft Word 2007 without overwriting the original text. You can use comments to ask the write of the document, questions or indicate an area that is unclear to you.

To insert a comment"
1. Click on "Review" tab.

2. Select the part of text in your word document where you want to insert a comment.

3. Click on "New Comment" icon under the "Review" tab.

4. You will be able to see a comment box in red color for the part of the text you highlighted.

5. Insert the comment you wish to put in the red comment box.

Goal Seek Tool in Excel

Goal Seek Tool can perform what-if analysis in excel. In Excel 2007, we have goal seek tool under Data -> What-If analysis.

First , write two variable variable1 and variable 2 and calculate their product in cell B10. Cell B10 has the required formula to perform the calculation.

Let us say we wanted the product of variable1 and variable2 to be 165 keeping variable1 constant.

Excel can automatically calculate the other value. We will show you how. This was just a simple calculation exmaple. One can perform complex calculations using goal seek tool.

Go to Goal Seek Tool.

Click Ok.

Click Ok again.



As you can see, variable2 is modified to give you the desired answer. To get a product of 165, cell B8 is modified to 11.

VLOOKUP function in Excel 2007

VLOOKUP also called as vertical lookup is an excel function that can help you find specific information in large data tables and select the appropriate data based on given conditions.
Here is an example that demonstrates how to use VLOOKUP function.
Let us say we have percentage grades and want excel to automatically fill in the letter grades as shown below by looking up a mapping table.

Below is our mapping table.

Lets begin.

1. Create two tables.

The table on the left contains two columns namely, percentage grades and letter grades. You want excel to automatically lookup the table on the right and decide the letter grades. So, a percentage grade of 75% should have a grade of A-

Make sure:
1. The contents of percentage grade are in percentage format. By default this value is text. To change it to percentage format, select the cells before entering the value and go to Home tab -> Number -> click on % icon.
2. Similarly, change the first column in mapping table so that the values are in percentages and not in text format. Notice that in the mapping tables, the values are in ascending order.

2. Select cell B2 and type the following:

=vlookup(

what do you see?
Can you see a tool tip showing vlookup formula? Yes, this is the format for vlookup

=vlookup(lookup_value, table_array,col_index_num,[range_lookup])

In our case, lookup_value is the cell A2 which contains the percentage value, table_array is the table on the right of the mapping table. To select the table_array just select the entire table and reference absolutely the cells by pressing F4 button on keyboard. When you look at the second table, the percentages are in the first column and the letter grades which I want to display are in the second column. so, the col_index_num is 2 in this case.

So,
start typing out the formula.
Select cell B2. type

=VLOOKUP(A2,$G$2:$H$8,2) and hit enter.

A2 is the cell we need to lookup in the mapping table.

G2:H8 is the second table array. Just select the entire table to get G2:H8 and hit F4 button to get the $ signs for absolute referencing. 2 refers to the second column in the second table which we want to display.

After hitting enter.

Can you see A- as letter grade?

Drag and autofill the remaining cells to reflect the letter grades.

Welcome to our Blog!

Graduate Multimedia development Center(GMDC), located in the Learning Resource Center computer lab,  offers technical support to graduate students interested in using multimedia applications. This service is co-sponsored by Middle Tennessee State University's College of Graduate studies and the Instructional Technology Support Center. GMDC works with students in developing advanced presentations for classes at MTSU, graduate seminars, as well as local and national meetings and conferences. We have several workshops per semester offered for free to help graduate students with new applications. For additional information about workshops, feel free to visit our official webpage at

http://itsc3.fsa.mtsu.edu/itsc/content/graduate-workshops.aspx

This blog will post useful information about various applications in the form of how-to articles, tips and tricks for these applications. Bookmark/Subscribe to this blog and keep visiting to enrich your knowledge.

Hope you have a wonderful stay at our blog.

Thanks.

Team @ MTSU GMDC