Spreadsheet: 48566d1247780594-indirect-mod-row-skipping-a-lot-of-rows-test-f-ms-annual-student-report-template-07-16-09-fs
Sheet: Instructions

 | [NAME] |  |  | CONTRACT For Success |  |  | Action VLOOKUP |  |  | Attendance lookup
1) Log into PowerSchool and select the "School" and Grade Level of WM in Wave. . |  |  |  |  |  |  |  | No |  | 0 | Please Select
2) Select Export Using Template from the drop-down menu. |  |  |  | 09-Cont. For Success |  |  | 0 | No |  | 1 | Absences ARE NOT affecting student's performance
3) Select Students > *Annual Student Report > Click button next to "The Selected ## Students" > Submit |  |  |  |  |  |  | 1 | Please Select |  | 2 | Absences ARE affecting student's performance
4) Once the export opens in Excel, click on Data on the top toolbar and select [NAME]. |  |  |  | IPP |  |  | 2 | Yes --- Pending |  | 3 | Tardies ARE NOT affecting student's performance
5) Click on the filter button that appears in the A1 Cell ([01]lastfirst) and filter to select only the student whose report you are making. |  |  |  |  |  |  | 3 | Yes --- Active |  | 4 | Tardies ARE affecting student's performance
6) Copy the resulting information (Ctrl a, Ctrl c) and paste (Ctrl v) on the Paste Cover Page tab. |  |  |  | 10-IPP |  |  | 4 | Yes --- Complete
7) On the Cover Page tab, enter your name in "Submitted by:"
 | Intervention Summary
1) Start page > Special Functions > Search Log Entries > choose Log Type: Intervention > Enter the first date of the AY in "Entered on or after this date" > Submit |  |  |  | Probationary Contract
2) Select Quick Export > Paste the field names below into the Export Log Entries Box > YOU MUST CLICK SURROUND FIELDS > Submit
 |  |  |  | 14-Probat. Contract
 | Intervention Summary Fields | << Do not copy this first row
 | [01]lastfirst
 | Discipline_Reporter |  |  | SAP
 | Subtype
 | Discipline_HearingOfficerFlag |  |  | 08-Wave/Stu. Goals
 | Entry_date
 | Category
 | Discipline_DrugRelatedFlag
 | Custom
 | Entry |  |  | HIDE THESE ROWS (E-N)!!!
 | Discipline_SchoolRulesVioFlag
3) Once the export opens in Excel, click on Data on the top toolbar and select [NAME].
4) Click on the filter button that appears in the A1 Cell ([01]lastfirst) and filter to show only the student whose report you are making. |  |  |  |  |  |  |  | sub subtype lookup |  | status lookup |  | Level Lookup
5) Sort the data by date by choosing Data > Sort > sort by Entry Date DESCENDING > OK |  |  |  |  |  | 2 | 0 | 0 | None | 0 |  | 0 | N/A
6) Copy the selection (Ctrl a, Ctrl c) and paste (Ctrl v) on the Paste Intervention Summary tab. |  |  |  |  |  | 3 | 1 | 1 | Detention: Assignment Log | 1 | Please Select | 2 | 0
7) In the [NAME], click on Format & |  |  |  |  |  | 4 | 2 | 2 | Detention: Behavioral | 2 | Pending | 3 | 1
7) 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. |  |  |  | 0 | n/a | 6 | 4 | 3 | Detention: Organization | 3 | Active | 4 | 2
 |  |  |  | 1 | n/a | 7 | 5 | 5 | Make-Up: Consequence |  |  | 6 | 4
 |  |  |  | 2 | Pending |  |  | 6 | Make-Up: Supplemental |  |  | 7 | 5
 |  |  |  | 3 | Active |  |  | 7 | Academics
 |  |  |  | 4 | Complete |  |  | 8 | Attendance
 |  |  |  |  |  |  |  | 9 | Behavior
 |  |  |  | outreach sch |  |  |  | 10 | Family
 |  |  |  | 0 | n/a |  |  | 11 | Student Snapshot: Academic Strength
 |  |  |  | 1 | n/a |  |  | 12 | Student Snapshot: Academic Need
 |  |  |  | 2 | Completed |  |  | 13 | Student Snapshot: Performance Strength
 |  |  |  | 3 | Rescheduled |  |  | 14 | Student Snapshot: Performance Need
 |  |  |  | 4 | Cancelled |  |  | 15 | Student Snapshot: Tutoring Strategies
 | Outreach Summary |  |  |  |  |  |  | 16 | Student Snapshot: Other
1) Start page > Special Functions > Search Log Entries > choose Log Type: Outreach > Enter the first date of the AY in "Entered on or after this date" > Submit |  |  |  | Review Status |  |  |  | 17 | Scholarship: Reduce
2) Select Quick Export > Paste the field names below into the Export Log Entries Box > YOU MUST CLICK SURROUND FIELDS > Submit |  |  |  | 0 | n/a |  |  | 18 | Scholarship: Termination
 |  |  |  | 1 | Pending |  |  | 19 | Scholarship: Reinstatement
 | Outreach Summary Fields | << Do not copy this first row |  | 2 | Successfully Completed |  |  | 20 | [NAME]
 | [01]lastfirst |  |  | 3 | Didn't [NAME] |  |  | 21 | Dismissal Voluntary: [NAME]
 | Discipline_Reporter |  |  | 4 | Progress made, but incomplete |  |  | 22 | Dismissal Voluntary: Not [NAME]
 | [01]mw_outreach |  |  | 5 | Agreements Revised
 | Subtype
 | Entry_Date
 | Custom
 | Discipline_IncidentType
 | [NAME]
3) Once the export opens in Excel, click on Data on the top toolbar and select [NAME].
4) Click on the filter button that appears in the A1 Cell ([01]lastfirst) and filter to show only the student whose report you are making.
5) Sort the data by date by choosing Data > Sort > sort by Entry Date DESCENDING > OK
6) Copy the selection (Ctrl a, Ctrl c) and paste (Ctrl v) on the Paste Outreach Summary tab.
7) 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) Start page >Special Functions > Search Log Entries > choose Log Type: Student Action Plans > Enter the first date of the AY in "Entered on or after this date" > Submit
2) Select Quick Export > Paste the field names below into the Export Log Entries Box > YOU MUST CLICK SURROUND FIELDS > Submit
 | SAP Export Fields | << Do not copy this first row
 | [01]lastfirst
 | Discipline_Reporter
 | [01]mw_outreach
 | [01]wave
 | Subtype
 | Entry_author
 | Entry_Date
 | Custom
3) Once the export opens in Excel, click on Data on the top toolbar and select [NAME].
4) Click on the filter button that appears in the A1 Cell ([01]lastfirst) and filter to show only the student whose report you are making.
5) Sort the data by date by choosing Data > Sort > sort by Entry Date DESCENDING > OK
6) Copy the selection (Ctrl a, Ctrl c) and paste (Ctrl v) on the Paste SAP Summary tab.
7) 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.
 | 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)