Importing an Ordered NWEA Report into Microsoft Excel



Importing an Ordered NWEA Report into Microsoft Excel

1. Go to and click on the Log in to the Reports Site link

[pic]

2. Type in user id and password and click Login

[pic]

3. Click on Order Reports link

[pic]

4. Order the report using the Wizard. Make sure the Order Reports radio button is checked. Also make sure the “Check this box if you want email notification of report completion” is unchecked.

[pic]

[pic]

5. Click the Submit Order button

6. After clicking on the Submit Order button a separate Report Order Confirmation window will appear. Click the X in the upper right hand corner to close this window

[pic]

7. Closing the Report Order Confirmation window will return you to the report wizard window. Click the Retrieve Reports link.

[pic]

8. This will take you to the Report Status and Retrieval screen. Your report may take a few minutes to process (READY will display under the Order Status column when the report is available, Press the refresh button on your browser to see if your report is ready). To view the report in Excel, click on the READY link

[pic]

9. Clicking on “Ready” will bring up the File Download window. Click on the Open button.

[pic]

10. The file will open via WinZip. Single left click on the “I Agree” button.

[pic]

11. Single left click on the text file containing your schools name, to highlight, and then click the Extract button.

[pic]

12. The Extract window will appear. Scroll to and single left click on the My Documents folder. Then click the Extract button

[pic]

13. The text file is now extracted (saved) to your My Documents folder. Close all open windows and start Microsoft Excel. In Excel click File then click Open

[pic]

14. In the Open window make sure “Look in:” shows My Documents. Change Files of type to “Text Files”. Single click on the text file you saved to highlight, and then click the Open button.

[pic]

15. This will bring up the Text Import Wizard. Accepting defaults click the Next button.

[pic]

16. Accepting defaults click Next

[pic]

17. Accepting defaults click Finish

[pic]

18. Your data will now appear in an Excel spread sheet. Click File, and then click Save As

[pic]

19. On the Save As screen make sure “Save in:” is set to My Documents and “Save as type:” is set to Microsoft Excel Workbook. Click the Save button to save the file as an Excel Workbook.

[pic]

You can now work with this data in Microsoft Excel as you would with any other Excel file.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download