Navigating the Consolidated Application to Leverage Resources Across Programs

1. Navigating the Consolidated Application to Leverage Resources Across Programs 11th Annual Title Programs Conference June 19-20, 2013

2. Presenter Robyn Planchard Georgia Department of Education Title I Education Program Specialist Area 1 Academic Achievement Awards Reward Districts and Reward Schools National Title I Distinguished Schools Consolidated Application Coordinator Committee of Practitioners rplanchard@doe.k12.ga.us (404) 463-3467

3. Purpose • The purpose of the LEA consolidated application (ConApp) overall is to leverage resources across programs to ensure that all children have an opportunity to meet state academic achievement standards. • By consolidating the planning and program requirements across all programs participating in the LEA Consolidated Application process, the need for LEAs to submit multiple plans is eliminated. • This makes the application process more efficient for applicants.

4. LEA Consolidated Application In 1999, Georgia began participating in the federal consolidated application. • The signing of No Child Left Behind (NCLB) in 2001 led to some modifications in the application process for FY2002. • NCLB reverted back to the Elementary and Secondary Education Act of 1965 (ESEA) in FY10 which led to additional modifications with the inception of the American Recovery and Reinvestment Act of 2009 (ARRA).

5. LEA Con App The current programs that utilize the local educational agency (LEA) consolidated application Web site, as well as, several additional programs that have come online in the last few years, single-handedly dispense over $1 billion dollars to school systems in Georgia.

6. Agenda • In the LEA consolidated application, we will: • Identify the roles within the LEA consolidated application • Review the LEA consolidated application Web site • Log into the MyGADOE Portal • Explore the general parts of the consolidated application • Perform Queries • Run Reports • Investigate the Transferability of Funds Function • Examine how to use the Manage Schools Function

7. Reviewing Roles within the Consolidated Application • Five distinct roles are available within the LEA consolidated application. • LEA Consolidated Application Coordinator, • Superintendent, • State Consolidated Application Coordinator, • State Program Manager, • State Plan Approver, and • State Grants Accounting.

8. Roles within the Consolidated Application

9. Logging into the LEA Consolidated Application Web site Within a Web browser, logon to the following site: http://www.gadoe.org

10. Within the LEA Consolidated Application Web site, enter your username and password to log into the MyGaDOE portal. Logging into the MyGaDOE Portal

11. Once you are logged into the MyGaDOE portal, select Consolidated Application in the left-hand organization bar.

12. Then select Application.

13. Then select Title Programs.

14. CLIP Enhancements • With each new fiscal year, the Consolidated Application opens and the prior CLIP entries are auto-populated into the new FY’s CLIP (i.e., FY13 CLIP text will be displayed within FY14’s CLIP) • All formats from the prior fiscal year will be displayed • The LEA will remove all highlights from text and will delete text containing a strikethrough from each CLIP Descriptor. • The text clean-up process is performed by selecting the icon.

15. CLIP Process per Descriptor • Select applicable Descriptor Edit Icon to make edits • Select Clean-Up Icon ( ) • Select Update button • Select revised Descriptor • (Same Descriptor from Step 1)

16. Clean-Up Icon Clean-Up Icon

17. CLIP Process per Descriptor • Add new text entries and edit prior FY text entries • Highlight new text entries using the BOLD • Remove text that will not apply for the new year’s Descriptors • Do not select the Clean-Up Icon because this will remove any new changes from text.

18. Deadlines in FY14 • June • June 21, 2013—CLIP Plan and FLP Plan opens. • July • July 1, 2013—First Day for LEAs to submit their CLIP Plan and FLP Plan to GaDOE • July 31, 2013—CLIP Plan and FLP Plan is due to GaDOE • October • October 1, 2013—Deadline for sign-off on original Title I, Part A and Title II, Part A budgets

19. Yearly Changes • Each Program has specific requirements the LEA must meet with the descriptors in the CLIP. • Title I, Part A has revised descriptors to reflect the language of Georgia’s approved ESEA Flexibility waiver. • Title I, Part A requires FLP Plans to be revised.

20. LEA Implementation Plans • Performance Goals from the previous year’s application will be displayed. • Uploaded files to the Attachment Tab are allowed and do not have to be added within the online application.

21. Implementation Plans Click the Implementation Plans tab.

22. Implementation Plans • Select the goal from the drop-down menu to update individual goals. • Select the checkbox for “Are Implementation Plan Descriptions Revised?” and the Update button to save changes.

23. Prayer Certification • In order to receive funds under the ESEA, a local educational agency (LEA) must certify in writing to the Georgia Department of Education (GaDOE) that no policy of the LEA prevents, or otherwise denies participation in constitutionally protected prayer in public elementary and secondary schools as set forth in this guidance. • An LEA must provide this certification to the GaDOE by October 1 of each subsequent year during which the LEA participates in an ESEA program. • LEAs must provide certification on Constitutionally Protected Prayer through the LEA consolidated application.

24. Prayer Certification Tab • Click the Prayer Certification tab. • The Superintendent is the only user that can select both checkboxes. Once this has been accomplished (by the Superintendent), select Save.

25. Flexible Learning Program (FLP) Plan The Flexible Learning Program (FLP) Plan tab is located in the Consolidated Application on the Planning tab.

26. FLP 1: Set Aside Tab: List all Priority, Focus, and Title I Alert schools being served.

27. FLP 2: Budget Projection Tab: List all Priority, Focus, and Title I Alert Schools being served with their projected budgets.

28. FLP 3: Priority Schools: List only priority schools and required professional learning on this page. Describe Professional learning in the text box.

29. FLP 4: FLP Components: Complete plan for each Priority, Focus, and Title I Alert school being served.

30. Performing Queries • Three queries are available within the Consolidated Application • Consolidated Application Status Queries, • Title I-A School Allocation Queries, and • Budget Comparison Queries.

31. Application Status Query • Click Reports >Queries on the far left-hand of the screen. • Select the Application Status Queries. • Select the appropriate options from the drop-down menus and select the Query button.

32. Title I-A School Allocation Query • Click Queries on the far right-hand of the screen. • Select Title I-A School Allocation Queries. • Select the appropriate options from the drop-down menus and select the Run Query button.

33. Budget Comparison Query • Click Queries on the far right-hand of the screen. • Select Budget Comparison Queries. • Select the appropriate options from the drop-down menus and select the Compare button.

34. Running Reports • Five reports are available within the LEA Consolidated Application • Application Summary, • Program Summary, • Budget Summary, • Budget Transferability, and • Unbudgeted Funds.

35. Application Summary Report • Click Reports on the far left-hand of the screen. • A list of the reports appears inside the Reports screen.

36. Application Summary Report con’t. • Select Application Summary. • Click the Run Report link.

37. Program Summary Report • Select Program Summary from the list on the Reports screen. • Select the appropriate options from the drop-down menus and click the Run Report link.

38. Budget Summary Report • Select Budget Summary from the list on the Reports screen. • Select the appropriate options from the drop-down menus and select the Run Report button.

39. Budget Transferability Report • Select Budget Transferability from the list on the Reports screen. • Select the appropriate options from the drop-down menus and select the Run Report button.

40. Unbudgeted Funds Report • Select Unbudgeted Funds from the list on the Reports screen. • Select the appropriate options from the drop-down menus and select the Run Report button.

41. Technical Questions • If you experience problems within the application, please contact Robyn Planchard at rplanchard@doe.k12.ga.us or 404-463-3467. • For problems within the application, you may also contact the helpdesk at dticket@doe.k12.ga.us.

42. Program-Specific Questions • Program-Specific names, phone numbers, and e-mail addresses can also be found at the following link: http://www.gadoe.org/School-Improvement/Federal-Programs/Pages/LEA-Consolidated-Application.aspx by selecting Guidance & Contact List.

43. Transferability of Funds • The funds you transfer into Title I become Title I funds subject to all rules and regulations for Title I. • Districts should think about how the transfer of funds will impact any of their required set-asides. The transferred funds may impact the required set-asides including those for parental involvement and private schools.  • The Title II, Part A consultant/specialist who works with the district must be notified in writing (email) about the district’s intent to transfer Title II, Part A funds to Title I prior to submitting the Title II, Part A budget for approval.

44. Transferability of Funds • The district must notify in writing (email) GaDOE’s Grants Accounting Department about the district’s intent to transfer Title II, Part A funds to Title I, Part A prior to the transfer.  The emails should be directed to Regina Hailey (RHailey@doe.k12.ga.us) and Darlene Leslie (DLeslie@doe.k12.ga.us) in Grants Accounting. • The district superintendent must write a letter to Margo DeLaune, Title Programs Director at GaDOE, stating the district’s intent to transfer Title II, Part A funds into Title I, Part A, sign the letter, scan the letter to a pdf file, and • Attach the letter to the Attachment Tab in the consolidated application prior to signing off on the Title I, Part A budget. (The letter is not mailed…just attached.)

45. Transferability of Funds • In the Title II, Part A Budget: • From Program Title II, Part A • To Program Title I, Part A • Function 5000 • Object 930 • Amount

46. Manage Public Schools Function

47. Manage Public Schools • Go to Consolidated Application and then Go to Manage Public Schools • Select Your System and then choose Program Category is Title Programs • Click Load and Now you can Add/Remove Schools by selecting from the Add/Remove Drop Down box, choosing the school and giving a reason • You cannot add a school that is not in the GaDOE Facility Data Base

48. Manage Public Schools • Once you remove a school, it removes the school from the list populated in the consolidated application budget pages and the embedded School Allocations and Eligible Attendance Area Tabs. • Title I Directors can do this before doing their budget. • Very helpful if a school in the district has closed; if there are two facility codes for a school, or if school has a new number.

49. Manage Public Schools

50. Title I-A does not send any budgeted item to a Sub-grant.