Putting EDW Information into PowerPoint

I often get asked about the best way to get information (such as the graph from PE405) from the Education Data Warehouse into PowerPoint or another document. Folks often want to share the data or graphs from reports in a presentation for district or school staff, school committees, and others (after the data becomes public and the embargo is lifted!)

There are several ways to go about this and it mostly depends on the technology you have available to you. I apologize that these are not the most formal "how-to" directions (they will vary slightly depending on your system) but I hope one of these options will work for you.

1) Screen Capture Software (puts the display in as an image)

If you have a screen capture software such as SnagIt or the Windows Snipping Tool, you can select/copy the part of your screen that you'd like to include, and then paste it into your document. However, SnagIt is not free (though there may be similar software that is free), and the Windows Snipping Tool is only included in Windows 7, 8, or Vista (look under "Accessories.") So these may not be options for many school users.

2) Screen Shot / Cropping Option (puts the display in as an image):

• Take a screen shot of the report by pressing the "Print Screen" button on your keyboard. This copies the screen image. (Alt-Print Screen will copy the active window only.)
• Then open your PowerPoint slide and choose Paste (Ctrl-V).
• Double-click the screen image you just pasted, look for a "Crop" option in the toolbar, and choose it.
• Use the "handles" that appear around the image to crop the image appropriately; hit the ESC key when you are done.
• To resize the image, click it and drag the corners (not the sides) to re-size.

3) Excel Option (puts the display in as an Excel object):

• At the top of the report page, look for the icon that looks like a little page with the globe on it (same place you go to convert to PDF)
• Click the icon and choose "View in Excel Options" and then "View in Excel 2007 Format"
• You will get a prompt asking if you want to open or save the file. Choose "Open."
• The report will open in Excel and you can copy and paste the graph, or any tables, from Excel to PowerPoint
• Note that this may not be straightforward on all computers. If it doesn't work for you the first time you try it, try choosing "Save" instead of "Open." Or choose Excel 2002 Format  instead of 2007. And if it still doesn't work, try holding down the Control key while opening/saving the report. Sometimes pop-up blockers get in the way.

I hope one of these options will work for you. If you have come up with a simpler/easier way to get information from EDW reports into PowerPoint, please let me know!