FastFacts Feature Presentation

1. We are using audio during this session, so please dial in to our conference line… • Phone number: 877-468-2134 • Participant code: 182500 FastFactsFeature Presentation December 8, 2009

2. Today’s Topic • We’ll be taking a look at… • The new database tool developed to gather data for Recovery Act reporting requirements.

3. Today’s Presenter • Paul Gasior, Director of Sponsored Projects Shared Services, in the JHU Controller’s Office

4. Session Segments • Presentation • Paul will provide an overview of ARRA reporting and demo the new database. • During Paul’s presentation, your phone will be muted. • Q&A • After the presentation, we’ll hold a Q&A session. • We’ll open up the phone lines, and you’ll be able to ask questions. • Paul will answer as many of your questions as time allows.

5. Contact Us • If you would like to submit a question during the presentation or if you’re having technical difficulties, you can email us at: fastfacts@jhu.edu • You can also send us an instant message! • GoogleTalk – HopkinsFastFacts@gmail.com • AOL Instant Messenger – HopkinsFastFacts • MSN – FastFacts@jhu.edu

6. Survey • Survey • At the end of this FastFacts session, we’ll ask you to complete a short survey. • Your honest comments will help us to enhance and improve future FastFacts sessions.

7. ARRA Reporting Database

8. What is ARRA? • Funding from the American Recovery and Reinvestment Act (ARRA) • Extensive reporting requirements • Unprecedented level of transparency • Implementing guidance was outlined in Section 1512 of the ARRA • http://www.whitehouse.gov/omb/assets/memoranda_fy2009/m09-21.pdf • Data submitted by JHU is available to the public at www.recovery.gov

9. Reporting Overview • Reports are due quarterly for the periods ending 3/31, 7/31, 9/30, and 12/31. Reports must be submitted no later than the 10th day after the end of each quarter. • Reporting is cumulative. • Sponsored Projects Shared Services (SPSS) is responsible for gathering data from BW and department users, formatting reports and report submission. • A database tool was developed to streamline the data collection process for JHU.

10. Using the Database • Login to the database at: • http://ssc.jhu.edu/sponsoredprojects/arra.html • Authenticate using a JHED ID and password. • Users have broad access to the data, no security is required at the cost center level.

11. Search Options • Wildcard feature for grant, cost center, and award ID searches. • ARRA Status: • All – All awards in the database • Pre-Review – Initialization status • Pending Review – Database entry has been saved but not submitted • Reviewed – All required fields have an entry and entry has been submitted

12. Search Results • Search results include: • Grant Master Data • Inception to Date (ITD) expenses, updated nightly from a BW feed • ARRA status • Principal Investigator & Administrator • Updated by field • 3 fields for updates and review by department users

13. Department Data Requirements • Project Status: • Not Started • Less than 50% • More than 50% • Fully Completed • Award Description – 4000 character maximum. • Project Description – 2000 character maximum. • Fields will be pre-populated with data from the prior quarter. • For initial reporting on new grants, project status will default as not started and descriptions will be blank.

14. Live Demo

15. Conclusion • Database entries are due by the end of the calendar quarter: 12/31, 3/31, 6/30, and 9/30. • If no changes to department fields are required, users must still click on “Submit” to update the ARRA status to “Reviewed.” • Have questions? • http://ssc.jhu.edu/sponsoredprojects/arra.html • Email sponsoredprojectsqc@jhu.edu

16. Q&A • We’re going to open the phone lines now! • There will be a slight pause, and then a recorded voice will provide instructions on how to ask questions over this conference call line. • We’ll be answering questions in the order that we receive them. • We’ll also be answering the questions that were emailed to us during the presentation. • If there’s a question that we can’t answer, we’ll do some research after this session, and then email the answer to all participants.

17. Thank You! • Thank you for participating! • We would love to hear from you. • Are there certain topics that you would like us to cover in future FastFacts sessions? • Would you like to be a FastFacts presenter? • Please email us at: fastfacts@jhu.edu

18. Survey • Before we close, please take the time to complete a short survey. • Your feedback will help us as we plan future FastFacts sessions. • Click this link to access the survey… http://connect.johnshopkins.edu/fastfactssurvey/ Thanks again!