Spreadsheet: 46761d1245703419-sumproduct-using-2-different-date-ranges-annual-student-report-report-template-06-22-09-fs
Sheet: Instructions

[NAME]
1) Log into PowerSchool and select the "School" the WM is attending.
2) Locate WM and select Export Using Template from from drop-down menu.
3) Select Students> *Annual Student Report > Submit
4) Copy the resulting spreadsheet (Ctrl a, Ctrl c) and paste (Ctrl v) on the Paste Cover Page tab.
Intervention Summary
1) Start page>Special Functions> Search Log Entries> choose Log Type: Intervention, copy and paste the student name into the Title 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- | Intervention Summary Fields
 | [01]lastfirst
 | Discipline_Reporter
 | Subtype
 | Discipline_HearingOfficerFlag
 | Entry_date
 | Category
 | Discipline_DrugRelatedFlag
 | Custom
 | Entry
 | Discipline_SchoolRulesVioFlag
2) Type in the name of WM exactly as it appears in PS into the "Title contains this text" text box. Enter the first date of the AY in "Entered on or after this date" > Submit
2) Copy the resulting spreadsheet (Ctrl a, Ctrl c) and paste (Ctrl v) on the Paste Intervention Summary tab.
3) Sort the data by date by choosing Data>Sort>sort by Entry Date DESCENDING>OK
4) Go to the Intervention Summary tab and 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> 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
 | 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>sort by Entry Date DESCENDING>OK
4) Go to the Outreach Summary tab and 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> 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
 | 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>sort by Entry Date DESCENDING>OK
4) Go to the SAP Summary tab and 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) Go to the Day School Transcript tab and 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)