ࡱ>  T8@\pKeith Krosinsky (Temp) Ba==#U8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Calibri1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1$Arial1Calibri1,>Calibri1>Calibri1>Calibri1'Arial1>Calibri14Calibri1<Calibri1?Calibri1h>Cambria1Calibri1 Calibri1Calibri1Calibri1 Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                                                                      ff + ) , *      P  P         `             a   h@ @ "x  h )x@ @  x )x )x@ @ . )x@ @ . )x@ @ / )x@ @ / x / x / x / x . x . )x@ @ + x + )x@ @ + x +  h@ @ / x / x / xa @ $ xa@ @ $ )x@ @ , x , )x@ @ , x ,  )x@ @ , )x@ / x@ @  x @  ||aE#}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef [$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L [$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A}  00_)23[$ -}A}! 00_)23 [$ -}A}" 00_)[$ -}A}# 00_)[$ -}A}$ 00_)[$ -}A}% 00_)[$ -}A}& 00_)[$ -}A}' 00_) [$ -}A}( 00_)[$ -}}) }00_)[$ -##0.  }}* 00_)[$ -???##0.??? ??? ???}-}/ 00_)}(}0  00_)}A}1 a00_)[$ -}A}2 00_)[$ -}A}3 00_)?[$ -}A}4 00_)23[$ -}-}5 00_)}(}6  00_)}}7 ??v00_)̙[$ -##0.  }A}8 }00_)[$ -}A}9 e00_)[$ -}-}: 00_)}x};00_)[$##  }}< ???00_)[$???## ???  ??? ???}-}> 00_)}U}? 00_)[$## }-}@ 00_)}}D}}E}}F}-}Gf_)}-}Hf_)}-}If_)}-}Jf_)}-}Kf_)}-}Lf_)}-}Mf_)}-}Nf_)}-}Of_)}-}P_)}-}Q_)}-}R_)}-}S_)}-}Tf_)}A}U f_)f[$}-}Vf_)}A}W f_)[$}<}X f_)[$}-}YL_)}-}ZL_)}-}[L_)}-}\L_)}(}]LL_)}-}^f_)}(}_ f_)}-}` f_) 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 F Followed Hyperlink   1Good;Good  a%2 Heading 1G Heading 1 I}%O3 Heading 2G Heading 2 I}%?4 Heading 3G Heading 3 I}%235 Heading 49 Heading 4 I}%64 Hyperlink   7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%"Normal :Normal 27Normal 2 % ;Noteb Note   <OutputwOutput  ???%????????? ???=$Percent >Title1Title I}% ?TotalMTotal %OO@ Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight168dq:F3ffff̙̙3f3fff3f3f33333f33333\`YSheet1S``FebruaryMarchAprilMayAugustJuneNovember SeptemberJulyJanuaryDecember-Send verification worksheets to FA applicantsnWork out dates for academic years for all class years and disbursement dates for federal and institutional aid*Revise materials accompanying award letter@Meet with Rising M4s about interviewing expenses and aid options:Package and send out award notices for continuing studentsContinue to monitor summer aidDMonitor funds and make necessary corrections to maximize utilizationContinue donor relationsJanuary = PLANNING March = MATCHApril = PACKAGEJuly = ORIENTATION August = MEETSeptember = REPORT DATA Review cyclesFebruary = UPDATEVPlan financial literacy program for the year, set dates, contact potential presenters <Complete DHHS Annual Operating Report in EHB: due mid-AugustEPlan and conduct entrance counseling/orientation for new matriculants-Begin exit interviews for graduating students5Encourage/promote/initiate reminder for GQ completion#Update office supplies for new yearOngoing throughout yearJanuary to May]Remind continuing students to complete FAFSA and financial aid applications for upcoming yearVDetermine possible changes to award procedures if allocations for upcoming year differ May = EXITEPlan and conduct entrance interviews/orientation for new matriculantsOReview financial website and other materials/resources used throughout the yearOctoberPrep debt lettersOctober = EDUCATENovember = SURVEYDecember = DISBURSE!Update/download/test new softwaredSend email to continuing students to complete FAFSA and financial aid applications for upcoming year+Train staff on packaging rules if necessary@Track and begin processing of aid applications for upcoming year)Complete checklists for aid disbursements.Hold additional MED- FA sessions if applicable@Review and revise handouts for perspective student interview day}Monitor disbursement of funds for students, ensure timely receipt of funding and resolve potential problems, update schedulesOngoing throughout termFReturning student analysis and packaging medical students awards cycleNBegin AAMC's LCME Part 1-B survey; gather prior year medical students aid data9Revise Student Budget Survey and disseminate as necessaryUAttend Federal Student Aid (FSA) conference if possible (either November or December)IUpdate National Health Service Corps contact information on their websiteZBe sure Constitution Day information is posted on website and be sure requirements are met7NIH-LRP deadline is typically in October for applicants$Review and update website statistics XReview student guides, update Policy and procedures manuals, make revisions as necessary2Prepare and finalize cost-of-attendance componentsKUpdate websites with new info, i.e., cost-of-attendance, packages, policiesqDetermine and disburse any final awards for current academic year to ensure appropriate spending of available aid`For schools offering PCL: send potentially eligible students notice re: PCL & re-awarding of PCLDReceive admit list from admissions and begin new student award cycleEReceive merit scholarship list from admissions and award as necessary%Accepted students' second-look eventsEFinancial literacy month - may have speakers and events to coordinateJune = PREPARERMake sure continuing students' aid is complete; ready for summer/fall disbursementICalculate entering students prematriculation debt July through SeptemberAnnual Operating Report (AOR) is made available - log in to the EHB to ensure access and begin work; ensure receipt of the GME Track * Primary Care Loan Report from AAMC6Complete AAMC's tuition and student fees questionnaire=Begin one-on-one counseling sessions with first-year studentsPrepare FISAP data: medical school aid recipients who receive FWS, Perkins - coordinate with university financial aid office if necessarySend communications to students regarding disbursement dates, refund process, office hours, and other important processing information]Award endowed funds as necessary; track thank you letters on behalf of scholarship recipientsVSend and track certification of finances (CFFs) for international admission applicantsBBegin med admission information sessions and end in early FebruaryHCreation of debt-profiles, access & print NSLDS reports from the website2Send sibling college enrollment verification formsPlanning review/award cycle: director will discuss any changes, enhancements, policies, timelines, create award policy, review need analysis policies, and review procedures for the cycletIdentify SDS awardees as environmentally or economically disadvantaged in student administration system if necessary/Supply data for U.S. News & World Report Survey+Send spring budgeting email to all studentsUpdate scholarship applicationManage scholarship funds: update scholarship budgets for next year, reconcile accounts, report updates to development, re-assign funds due to aid revisionsReturn to Campus: send communications to students regarding disbursement dates, refund process, office hours, and other important processing information.$Continue perspective MED-FA sessionsLMonitor fund balances and award scholarships if possible for spring semesterMonitor spring disbursementFinancial Aid Officer CalendarMOffice retreat: time to review the just completed tracking and awarding cyclebq6 6T#89:#9<N=e? A4 Ci RGJcc PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭VMԯNDJ++2a,/$nECA6٥D-ʵ? dXiJF8,nx (MKoP(\HbWϿ})zg'8yV#x'˯?oOz3?^?O?~B,z_=yǿ~xPiL$M>7Ck9I#L nꎊ)f>\<|HL|3.ŅzI2O.&e>Ƈ8qBۙ5toG1sD1IB? }J^wi(#SKID ݠ1eBp{8yC]$f94^c>Y[XE>#{Sq c8 >;-&~ ..R(zy s^Fvԇ$*cߓqrB3' }'g7t4Kf"߇ފAV_] 2H7Hk;hIf;ZX_Fڲe}NM;SIvưõ[H5Dt(?]oQ|fNL{d׀O&kNa4%d8?L_H-Ak1h fx-jWBxlB -6j>},khxd׺rXg([x?eޓϲكkS1'|^=aѱnRvPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 0_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!0ktheme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK]  T8@ lc[bfinrvz~ƎΒ֖ޚ&.6>FNV^fnv~6  dMbP?_*+%,&?'?(?)?"FXX??&U} DD} I'E} m C} m AColumn Blk@ @,X@,X,, , , X , ,XXX,,,X,,,,,,,,,,, X^2WBBBBBBBBBBBBBBBBBBBBB4_`BBBBBBBBBBBBBBBBBBBBB ^ K0BBBBBBBBBBBBBBBBBBBBB J> L! J-M J L" J.M J M J M P Q0 BBBBBBBBBBBBBBBBBBBBB R? S R$ S R/ S R S R#S R@S RAS R0S Y Z0BBBBBBBBBBBBBBBBBBBBB [ \ [B\ [C\ [D\ G N0BBBBBBBBBBBBBBBBBBBBB H6 O5 HEO HFO I K%0BBBBBBBBBBBBBBBBBBBBB J1M JM JM JMDlD8PPPPP ,!X"X#,$,%X&'X(X),*X+,,,-,.,/X0X1,2X3,4,5X6X7,8,9,:X;,<,=,>,? P QG0 BBBBBBBBBBBBBBBBBBBBB !RH!S "R_"S #Y #Z0#BBBBBBBBBBBBBBBBBBBBB $[&$\ %[I%\ &[J&\ '['\ ([4(\ )[K)\ *['*\ +I +K0+BBBBBBBBBBBBBBBBBBBBB ,J,T -J-M .JL.M /JM/M 0J70M 1J31M 2JN2U 3J:23MBBBBBBBBBBBBBBBBBBBBB 4P 4Q 5RO5S 6RP6S 7R87S 8R=8S 9RQ9S :R;:S ;Y( ;Z* <[<<\ =[R =\) >]S>\ ?[T?\D`lPPPD@XA,B,C,D,EXF,GXH,I,J,KL/@M,NXO,P,Q,R,S,T,U,V,W,X,Y,Z,[,\,],^,_, @[U@\ A[2A\ B[ B\ C[C\ DG DN+ EH EO FHVFO GH9GO HHWHO IHXIO JI JK, KJYKM LJZ2LUBBBBBBBBBBBBBBBBBBBBB MJ[MM NJ\NM OJ]OVPFQFRFSFTFUFVFWFXFYFZF[F\F]F^F_FDlD `,a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,{,|,},~,,`FaFbFcFdFeFfFgFhFiFjFkFlFmFnFoFpFqFrFsFtFuFvFwFxFyFzF{F|F}F~FFDl ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDl ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDl ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDl ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDl ,,,,,,,,, , , , , ,,,,,,,,,,,,,,,,,,,FFFFFFFFF F F F F FFFFFFFFFFFFFFFFFFFDl  ,!,",#,$,%,&,',(,),*,+,,,-,.,/,0,1,2,3,4,5,6,7,8,9,:,;,<,=,>,?, F!F"F#F$F%F&F'F(F)F*F+F,F-F.F/F0F1F2F3F4F5F6F7F8F9F:F;F<F=F>F?FDl @,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,[,\,],^,_,@FAFBFCFDFEFFFGFHFIFJFKFLFMFNFOFPFQFRFSFTFUFVFWFXFYFZF[F\F]F^F_FDl `,a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,{,|,},~,,`FaFbFcFdFeFfFgFhFiFjFkFlFmFnFoFpFqFrFsFtFuFvFwFxFyFzF{F|F}F~FFDl ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDl ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDl ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDl ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDl ,,,,,,,,, , , , , ,,,,,,,,,,,,,,,,,,,FFFFFFFFF F F F F FFFFFFFFFFFFFFFFFFFDl  ,!,",#,$,%,&,',(,),*,+,,,-,.,/,0,1,2,3,4,5,6,7,8,9,:,;,<,=,>,?, F!F"F#F$F%F&F'F(F)F*F+F,F-F.F/F0F1F2F3F4F5F6F7F8F9F:F;F<F=F>F?FDl @,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,[,\,],^,_,@FAFBFCFDFEFFFGFHFIFJFKFLFMFNFOFPFQFRFSFTFUFVFWFXFYFZF[F\F]F^F_FDl `,a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,{,|,},~,,`FaFbFcFdFeFfFgFhFiFjFkFlFmFnFoFpFqFrFsFtFuFvFwFxFyFzF{F|F}F~FFDl ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDl ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDl ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDl ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDl ,,,,,,,,, , , , , ,,,,,,,,,,,,,,,,,,,FFFFFFFFF F F F F FFFFFFFFFFFFFFFFFFFDl  ,!,",#,$,%,&,',(,),*,+,,,-,.,/,0,1,2,3,4,5,6,7,8,9,:,;,<,=,>,?, F!F"F#F$F%F&F'F(F)F*F+F,F-F.F/F0F1F2F3F4F5F6F7F8F9F:F;F<F=F>F?FDl @,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,[,\,],^,_,@FAFBFCFDFEFFFGFHFIFJFKFLFMFNFOFPFQFRFSFTFUFVFWFXFYFZF[F\F]F^F_FDl `,a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,{,|,},~,,`FaFbFcFdFeFfFgFhFiFjFkFlFmFnFoFpFqFrFsFtFuFvFwFxFyFzF{F|F}F~FFDl ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDl ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDl ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDl ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDl ,,,,,,,,, , , , , ,,,,,,,,,,,,,,,,,,,FFFFFFFFF F F F F FFFFFFFFFFFFFFFFFFFDl  ,!,",#,$,%,&,',(,),*,+,,,-,.,/,0,1,2,3,4,5,6,7,8,9,:,;,<,=,>,?, F!F"F#F$F%F&F'F(F)F*F+F,F-F.F/F0F1F2F3F4F5F6F7F8F9F:F;F<F=F>F?FDl @,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,[,\,],^,_,@FAFBFCFDFEFFFGFHFIFJFKFLFMFNFOFPFQFRFSFTFUFVFWFXFYFZF[F\F]F^F_FDl `,a,b,c,d,e,f,g,h,i,j,k,`FaFbFcFdFeFfFgFhFiFjFkFh >@CBA """m 7ggD@ Oh+'0HP (Office of Admissions & Financial AidKeith Krosinsky (Temp)Microsoft Macintosh Excel@ˌ@3Rp6@u՜.+,0 PXx  Brown Medical School Sheet1  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxz{|}~Root Entry FWorkbookSummaryInformation(yDocumentSummaryInformation8