ICU - A Plan that Works

Justin Zajic - Mitchell School District

The Power of ICU

Mandatory Tuesday - Thursday after school for kids on the list

Google Docs Form Directions

Concatenate Formula directions

I have our google docs set up so that everything is autofill including the emailer tab.

1.     The name column will be left blank and this is where I copy and paste all the names from the ICU list. The rest is auto fill

2.     I have set up our message column to Concatenate all of the information in the ICU list into a single cell or “the message cell”  It looks like this:

=CONCATENATE(IF('8th ICU-2nd Semester'!A2=0,"",'8th ICU-2nd Semester'!$A$1),'8th ICU-2nd Semester'!A2,IF('8th ICU-2nd Semester'!D2=0,"",'8th ICU-2nd Semester'!$D$1),'8th ICU-2nd Semester'!D2,IF('8th ICU-2nd Semester'!E2=0,"",'8th ICU-2nd Semester'!$E$1),'8th ICU-2nd Semester'!E2,IF('8th ICU-2nd Semester'!F2=0,"",'8th ICU-2nd Semester'!$F$1),'8th ICU-2nd Semester'!F2,IF('8th ICU-2nd Semester'!G2=0,"",'8th ICU-2nd Semester'!$G$1),'8th ICU-2nd Semester'!G2,IF('8th ICU-2nd Semester'!H2=0,"",'8th ICU-2nd Semester'!$H$1),'8th ICU-2nd Semester'!H2,IF('8th ICU-2nd Semester'!I2=0,"",'8th ICU-2nd Semester'!$I$1),'8th ICU-2nd Semester'!I2,IF('8th ICU-2nd Semester'!J2=0,"",'8th ICU-2nd Semester'!$J$1),'8th ICU-2nd Semester'!J2,IF('8th ICU-2nd Semester'!K2=0,"",'8th ICU-2nd Semester'!$K$1),'8th ICU-2nd Semester'!J2,IF('8th ICU-2nd Semester'!L2=0,"",'8th ICU-2nd Semester'!$L$1),'8th ICU-2nd Semester'!L2,IF('8th ICU-2nd Semester'!M2=0,"",'8th ICU-2nd Semester'!$M$1),'8th ICU-2nd Semester'!M2)

You can see that it pulls columns A or (Student name) and then D-M   and categorizes each assignment by subject so our message to the parents actually looks like this

Student Name Joe Cool  

Math :1/5 Qz8-2(abs), 1/6 Qz8-4(was abs), 1/9 Ws8-4, 1/12 Ws8-7, Qz8-7, 1/13 Ch8Rev, Ch8Test. 1/18 Ws9-1(was abs), 1/19 Qz9:1-2, 1/23 PH pg 105-106, 1/24 Ws9-3, 1/25 Ws9-4, Qz9-4(redo), PB

Science:   1/9 Ch. 4 & 5 Test and Review 1/13 Life has a history 1/24 Chapter 4 Quiz Redo AS   

Language Arts: 1/6 double journal entries; AR Test  1/13 Character analysis essay SBH"

In the email address or column A I have a simple formula that pulls the email address off of our database tab by referencing Column C.