How to run and format reports for your Local Board of Health 2011 (v11.0)

1. Massachusetts Department of Public HealthBureau of Infectious Disease Prevention, Response and Services Office of Integrated Surveillance and Informatics Services How to run and format reports for your Local Board of Health 2011 (v11.0)

2. Useful MAVEN icons to know Push Pin (last 30 events) Create Contacts Print out information LBOH Reports Searches Edit Personal Information (Email Notification) Workflows (Gears=Work)

3. MAVEN Reports Once you click on the report icon a new reporting window opens Click on the down arrow button to preview all available reports

4. Seven reports available to LBOH

5. LBOH Basic Line List • Click on Run Report or Export Report • Allows you to view or save

6. Result from clicking on the run report or export button * First three lines must be deleted so you can sort your report

7. LBOH count by received date report Shows user all events where you have selected yes for Step 1 (LBOH notified)

8. LBOH count by EventDate report Shows user all events specified in the date range for events with a event date count

9. LBOH extract for disease events

11. LBOH extract in csv format (comma separate values) • Click on Open or Save (you choose) Notice the problem with formatting – you can’t see the variable fields – not a problem with a few tricks

12. Formatting your spreadsheet • Place cursor in the square above the number 1 and to the left of the A and click once – document will be highlighted

13. Formatting By placing cursor in between the two columns (A & B) and then double click all columns will open up to the correct size

14. How to sort your spreadsheet • Highlight the column you want sorted (ie Disease) and then click on the • Data then Sort is another way to sort

15. LBOH events by time period • This report gives you a snapshot of your town for specific periods

16. Events by time period • Current Month, Previous Month, Year to Date, Last Year, and Last Year to Date by Status

17. LBOH events by event by week date • You can select single diseases or groups • Need to select a status

18. LBOH incomplete case report forms • Line list of all case report forms that Have not been submitted • Reminder to print in landscape • Call ISIS with any questions

19. LBOH incomplete case report forms

20. Excel Basics • Edit Copy or Edit Paste (Ctrl-C, Ctrl-V) • Cut (Ctrl-X) • Sorting • Formatting • Borders, centering, orientation, header, footer • Undo something (Ctrl-Z)

21. How to cut and paste from a report to an excel spreadsheet • Highlight all rows you want to cut and paste from MAVEN report to an excel spreadsheet

22. Pasting the document from the web to excel • Ctrl-V pastes the document into the spreadsheet for you to view and print

23. Pasting into a document • Once highlighted then hold down the Ctrl key while selecting the X key (this cuts the doc) • Open Excel and place cursor in Column A (first cell) • Either Select Edit from the task menu or hit the Ctrl key while selecting V (this pastes)

24. Formatting your document • Highlight cells you want to be formatted

25. Borders • Clicking on the Border Icon you can select the type of border you want to print your report out with

26. Page Setup controls a few things • File-Page Setup (orientation, scaling, margins, header, footer, columns headers to print on every sheet)

27. Deleting columns you don’t need • Highlight the column you don’t need • Right click on the column and select delete • Column to the right will automatically move to the left

28. Centering column data • Highlight column then click on the center icon

29. Any Questions regarding setup and saving should be directed to the isishelp@state.ma.us email account or contact the ISIS help desk at 617-983-6801 during normal business hours.