You will see some formula samples below. Please think what they mean. If you have any questions related any of them, please write them in in the comments.

if(COUNTBLANK(\$A8:\$M8)=0,transpose(query(Directory!N\$2:N\$3)),"No")

QUERY(ImportRange("1qchEnmIzpT9zP82hTJCPEgKIADb-j2Obci7X-PUkLa4/edit#","Form Responses 1!A:N"), "Select Col13,Col4,Col5,Col6,Col7,Col9 where Col11='APPROVED' order by Col6 desc")

QUERY(Home_Visit!A:N, "select * where ( E='' or F='' or G='' or H='' ) and (I!='' or J!='' or K!='') and ( toDate(now() ) > E) ")

query(Main!1:1223,"select B, E, I, M, N, O where H contains '"&C3&"' and D contains '"&D3&"' and E contains '"&E3&"' order by B asc ",1)

QUERY('Lesson Plan'!A69:B215, "select * where A contains '"&C3&"' ")

AVERAGE(if(today()>\$D\$1,E3),if(today()>\$F\$1,G3),if(today()>\$H\$1,I3),if(today()>\$J\$1,K3),if(today()>\$L\$1,M3),if(today()>\$N\$1,O3))

ARRAYFORMULA( COUNTIFS(\$B\$2:B,G2, DAYS360(\$C\$2:C,\$D\$2:D)-2, ">0"))

IFERROR(SUM(FILTER(Tutoring_MS!H:H,Tutoring_MS!G:G=\$Z\$3,Tutoring_MS!B:B=B3)*\$AA\$3,FILTER(Tutoring_HS!H:H,Tutoring_HS!G:G=\$Z\$7,Tutoring_HS!B:B=B3)*\$AA\$8)/43,"0")

sort(unique(filter(Main!H2:H1223,Main!H2:H1223<>"",Main!G2:G1223=B3,Main!C2:C1223="2015-16")))

query(AddCourse!\$A:\$C,"select B where C matches """&F1&"""",0)