1 / 14

Sign into Welnet and select the Summary Report option

Sign into Welnet and select the Summary Report option. For a whole school report, make sure all classes have a check mark. Scroll to the bottom, include students, summarize all classes, include the phase and output to a spreadsheet. Click View Summary Report.

alexandra-zane
Download Presentation

Sign into Welnet and select the Summary Report option

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Sign into Welnet and select the Summary Report option

  2. For a whole school report, make sure all classes have a check mark. Scroll to the bottom, include students, summarize all classes, include the phase and output to a spreadsheet. Click View Summary Report.

  3. Welnet will run a report that looks like this. In this example student names have been blocked out.

  4. Delete ALL columns except the one you want to find the average of. To delete, click on the letter heading at the very top of each column, right click and select delete.

  5. Highlight Column A, Choose Sort & Filter, then Sort A-Z

  6. Now your numbers should be in order from lowest to highest, Delete everything that is not a number (some may be above the number, some may be below)

  7. Scroll down and locate and items that are not scores (including blank spaces). Highlight and delete them

  8. Highlight the first column by clicking on the ‘A’ at the top of it. Select the Data tab at the top of the screen, then click on Text to Columns

  9. Select the Delimited button and click Next

  10. Uncheck the Tab option, check Other and place a colon in the box. Then click Finish.

  11. Select the home tab at the top of the screen. Left click on the first cell in the ‘A’ column, drag and highlight until you reach the last score. Then click the autosum button in the upper right part of the toolbar.

  12. Repeat the same steps to create a sum for column B

  13. Do the math… • Take the total of column A and multiply it by 60 to convert to seconds. (3813x60=22,8780) • Add Column A total seconds to Column B (22,8780+8625=237405) • Divide total seconds by the total number of students (237405/311=763.36) • Divide that number by 60 to re-convert back to minutes (763.36/60=12.72 minutes which is equal to a 12:43 average mile time)

  14. Set your goal • By June of 2015, our school mile time average will decrease from 12:43 to 12:28 as measured by our mile run assessment.

More Related