Spreadsheet: 62274d1263247046-pull-every-instance-index-match-criteria-into-consecutive-rows-directors-intervention-report-template
Sheet: Instructions

Note: If any incidents occur after this DIR has been submitted but before the [NAME]' Meeting happens, a second DIR is not needed. Run the Log Entry Summary object report and save/email as an addendum to the original DIR, noting the date of the original DIR in the title. (Example: Doe, [NAME] to 9-25 DIR-xx-xx-xx). To run a Log Entry Summary: Start Page>Special Functions> Search Log Entries>Same search criteria for the DIR (see below), submit> Print a report> Log Entry Summary
GENERAL DIR INFORMATION
Before you begin, make sure SAP information is updated in PowerSchool.
1) Log into PowerSchool, select the School then click on Grade (Wave)
2) Under the drop-down Select a Function for this Group of Students choose Select Students by hand
3) Hold down the ctrl button to select the students whom your running a DIR for>Functions> Export Using Template
4) Select Students > *Director's Intervention Report > Click button next to "The Selected ## Students" > Submit
5) Once the export opens in Excel, click on the number next to one student's name so their entire row is highlighted, then copy the info, ctrl c
6) Go to that student's template and paste, ctrl v, onto the Paste DIR tab in the red text box ABOVE the black line (Row 2).
DIR INCIDENT EXPORT
1) Log into PowerSchool: Start Page > Special Functions > Search Log Entries > Log Type: Intervention, Sub-type: Director's [NAME], copy and paste the student name into the Title field, enter the incident date in both Entered on or after this date and Entered on or before this date> Submit> Quick Export > Paste the field names below into the Export Log Entries Box > YOU MUST CLICK SURROUND FIELDS> Submit
Do not copy this first row- | DIR Export Fields
 | [01]lastfirst
 | [01]wave
 | Custom
 | discipline_reporter
 | Entry
 | Entry_Author
 | Entry_Date
2) If more than one entry appears, select the row of the entry you were looking for by clicking on the row # next to the student's name.
3) Copy the information (Ctrl c) and paste (Ctrl v) onto the Paste DIR tab in the red text box BELOW the black line (Row 8).
4) Go to the DIR tab to check page for overall accuracy.
5) Attach the following reports: Recent Day School Progress Report, Tutor Evaluations or Empowerment reports
6) Run the following reports, instructions below: Intervention Summary Report, Outreach Summary Report, Student Action Planning Report, Day School Transcript. (Note: if no [NAME] or other Intevention has been entered yet into PowerSchool those reports do not need to be run but the other two reports are still run. Make sure the student's goals are entered in PowerSchool before running the Student Action Planning report.)
Intervention Summary
1) Start page>Special Functions> Search Log Entries> choose Log Type: Intervention, copy and paste the student name into the Title field> Enter in AY start date into Entered on or after (6/15/09) > Submit> Quick Export > Paste the field names below into the Export Log Entries Box > YOU MUST CLICK SURROUND FIELDS> Submit
Do not copy this first row- | Intervention Summary Fields
 | [01]lastfirst
 | Discipline_Reporter
 | Subtype
 | Discipline_HearingOfficerFlag
 | Entry_date
 | Category
 | Discipline_DrugRelatedFlag
 | Custom
 | Entry
 | Discipline_SchoolRulesVioFlag
 | [01]schoolid
2) Copy the resulting spreadsheet (Ctrl a, Ctrl c) and paste (Ctrl v) on the Paste Intervention tab.
3) Sort the data by date by choosing Data > Sort A-Z
4) In the Intervention tab, select all (CTRL-A) and adjust the view (Home tab on top > Format > [NAME]).
5) After adjusting the view, set your print area (Page Layout tab at top > Print Area > Set Print Area). Check summary for overall accuracy.
Outreach Summary
1) Log into PowerSchool: Start Page > Special Functions > Search Log Entries > Log Type: Outreach, copy and paste the student name into the Title field> Enter "6/15/09" in Entered on or after field >Submit> Quick Export > Paste the field names below into the Export Log Entries Box > YOU MUST CLICK SURROUND FIELDS> Submit
Do not copy this first row- | Outreach Summary Fields
 | [01]lastfirst
 | Discipline_Reporter
 | [01]mw_outreach
 | Subtype
 | Entry_Date
 | Custom
 | Discipline_IncidentType
 | [NAME]
2) Copy the resulting spreadsheet (Ctrl a, Ctrl c) and paste (Ctrl v) on the Paste Outreach Summary tab
3) Sort the data by date by choosing Data > SORT A-Z
4) In the [NAME] tab, select all (CTRL-A) and adjust the view (Home tab on top > Format > [NAME]).
5) After adjusting the view, set your print area (Page Layout tab at top > Print Area > Set Print Area). Check summary for overall accuracy.
Student Action Planning Summary
1) Log into PowerSchool: Start Page > Special Functions > Search Log Entries > Log Type: Student Action Plans, copy and paste the student name into the Title field> Enter "6/15/09" into Entered on of after field > Submit> Quick Export > Paste the field names below into the Export Log Entries Box > YOU MUST CLICK SURROUND FIELDS> Submit
Do not copy this first row- | SAP Export Fields
 | [01]lastfirst
 | Discipline_Reporter
 | [01]mw_outreach
 | [01]wave
 | Subtype
 | Entry_author
 | Entry_Date
 | Custom
2) Copy the resulting spreadsheet (Ctrl a, Ctrl c) and paste (Ctrl v) on the Paste SAP tab
3) Sort the data by date by choosing Data > SORT A-Z
4) In the SAP tab, select all (CTRL-A) and adjust the view (Home tab on top > Format > [NAME]).
5) After adjusting the view, set your print area (Page Layout tab at top > Print Area > Set Print Area). Check summary for overall accuracy.
Day School Transcript
1) Start page>Select student>click Historical Grades link on the left
2) Place your cursor directly to the left of the grades chart and highlight the entire chart. Copy (Ctrl c) and paste (Ctrl v) on the Paste Day School Transcript tab
Note: If your students have grades from Middle School to be included as well. When you are on the Historical Grades page click on [NAME]. Copy and paste the same as you would for the other grades onto the Paste Day School Transcript tab. The formatting won't look as neat, but the information will display.
3) After adjusting the view, set your print area (Page Layout tab at top > Print Area > Set Print Area). Check summary for overall accuracy.
Once your DIR is complete:
1) Save your DIR to K or S:\Wave-Maker Intervention\ name of folder\’X’ Wave\Wave-Maker\ Name of report-xx-xx-xx
2) Email DIR to Wave, Coordinators, Directors
General [NAME]
1) My data is getting split onto different rows:
a) Was [NAME] clicked on the Quick Export page?
b) Were any " " entered in the log's Log Entry Text. For example, She said "Whoa!"
2) My data is too big:
a) Adjust row height
b) Make font size smaller (no smaller than 10)
3) My data is not showing up on the summary tab/My data is showing up on incorrect places on the summary tab
a. Was the data pasted onto the correct paste tab?
b. Were the correct set of fields selected to paste into the Quick Export box?
c. Was just one row of data copied to be pasted? (If so, you must paste into the field BELOW the red Paste Here)
4) My log search is not working/ I can't find the log I entered
a. Was the log entered in District Office? (you'll have to delete the log and do it over)
b. Was the log entry search done in District Office? (go to necessary school)