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.
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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Summary Report option
mark. Scroll to the bottom, include students, summarize all
classes, include the phase and output to a spreadsheet. Click
View Summary Report.
student names have been blocked out.
of. To delete, click on the letter heading at the very top of each
column, right click and select delete.
Filter, then Sort A-Z
Delete everything that is not a number (some may be above the
number, some may be below)
are not scores (including blank spaces).
Highlight and delete them
top of it. Select the Data tab at the top of the screen,
then click on Text to Columns
Select the Delimited button and click
Uncheck the Tab option, check Other and
place a colon in the box. Then click Finish.
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
in the upper right part of the toolbar.
for column B
• 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
• Divide total seconds by the total number of
• 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)
• By June of 2015, our school mile time average
will decrease from 12:43 to 12:28 as
measured by our mile run assessment.