Sign into Welnet and select the
This presentation is the property of its rightful owner.
Sponsored Links
1 / 14

Sign into Welnet and select the Summary Report option PowerPoint PPT Presentation


  • 74 Views
  • Uploaded on
  • Presentation posted in: General

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 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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Sign into welnet and select the summary report option

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.


Sign into welnet and select the summary report option

Welnet will run a report that looks like this. In this example

student names have been blocked out.


Sign into welnet and select the summary report option

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.


Sign into welnet and select the summary report option

Highlight Column A, Choose Sort &

Filter, then Sort A-Z


Sign into welnet and select the summary report option

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)


Sign into welnet and select the summary report option

Scroll down and locate and items that

are not scores (including blank spaces).

Highlight and delete them


Sign into welnet and select the summary report option

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


Sign into welnet and select the summary report option

Select the Delimited button and click

Next


Sign into welnet and select the summary report option

Uncheck the Tab option, check Other and

place a colon in the box. Then click Finish.


Sign into welnet and select the summary report option

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.


Sign into welnet and select the summary report option

Repeat the same steps to create a sum

for column B


Sign into welnet and select the summary report option

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)


Sign into welnet and select the summary report option

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.


  • Login