Entering End of Unit Math Assessment Student Scores

Students' scores on each end of unit math assessment, in grades kindergarten through eighth grade, will be entered into myMCPS web-based portal. To enter End of Unit Math Assessment Student Scores:

1. Double-click on the myMCPS icon in the Staff Applications folder and log into myMCPS by using your Outlook user name and password.

2. Navigate to the Classroom Center tab, click on the drop down arrow, and select Assessments. You are now in the Assessment page of the Assessment Center and should see a spreadsheet with the following headings:

• Action - There are 2 possible actions, ES (Enter Scores) and RT (Re-Test).
• Export - The assessment spreadsheet can be exported to Excel to allow teachers to enter scores or view current scores if any have been posted and saved.
• Assessment - Names the different assessments available.
• School - At the Principal, School Admin, and Teacher level, you can only see the school of assignment. At the District Admin level, you can see every school.
• Teacher - Lists the teachers' names for each assessment.
• Subject Area- Mathematics, etc.
• Status - There are four choices, All, Assigned, In Process, or Complete.
• Class - Identifies the class section.
• Unit - Identifies the assessment unit number.
• Assessment Type - Math AP, GT, LAS, etc.
• Due Date - Shows date by when assignment is due.

Located under the headings are the different filters available in order to locate an assessment. These have to be used in order to locate an assessment, There is no right or wrong order by which you are required to apply these filters. Some have a drop down menu to make a selection, while others have a field in which you have to enter information to be filtered. Next to this field is an icon of a funnel that you will have to select to display a condition by which to filter.

3. Navigate to the Teacher filter and enter the desired teacher's last name. Click on the funnel next to the teacher's name and select Contains. The application will then display a message that says Loading.

4. Continue selecting and applying the different filters in order to locate the desired assessment.

5. Once the desired assessment is listed on the page, select it by clicking on the assessment name; for example, Math AP Grade 6 Unit 1. The assessment for the selected teacher will now display in the Assessment Center under the Score Entry page. The names of the students in the selected assessment will be displayed under the Student column on the left hand side of the page. There is a column for each assessment item, displayed in red if it is a required item, in addition to the maximum possible value for each item. There is a scroll bar that moves from left to right on the lower portion of the page in order to view all of the assessment items, including the above grade level items displayed in blue. The page will only display ten students at a time. Therefore, if the selected assessment has more than ten students, you will see the available pages in the lower portion of the page.

6. Place your cursor in the first field next to the student's name, and enter the desired score. Click on the Tab key in the keyboard, to navigate to the next field. The field will only allow you to enter a number from 0 to the maximum possible indicated value under each item. If a number higher than the indicated maximum possible value is entered, the number will disappear, the field will turn pink, and display an exclamation mark momentarily.

7. Continue entering scores in this manner. It is recommended to save often to avoid losing data. To save scores click on the Save button on the lower left hand corner.

8. The assessment can be marked complete after all of the required items for students in the spreadsheet have been entered. Click on the Mark Complete button on the lower left hand corner next to Save to mark the assessment complete. Once the assessment has been marked complete, data can no longer be entered or changed in the selected marked complete assessment. Instead, the only action available for this assessment marked complete is to enter Re-Test (RT) scores. Only mark an assessment complete when you are absolutely sure no changes need to be made.

9. To enter scores for a different assessment, you can change the filters on the Score Entry page, one at a time, or navigate back to the Assessment Center by clicking on the Assessment link on the left hand side of the page, and change the filters there.

Entering Re-Test Scores

In order to enter Re-Test Scores, the class must have been Marked Complete.
To enter Re-Test student scores

1. Login to myMCPS using your Outlook user name and password.

2. Navigate to the Classroom Center tab, click on the drop down arrow, and select Assessment. Use the filter icon in the Status column to filter out all of the assessments that have been marked complete. This will display all of the assessments that are available for entering Re-Test scores. Continue applying the filters until you obtain the desired assessment.

3. Click on the RT icon under the Action column next to the name of the desired assessment. The Re-Enter scores page will display with the students' previous scores.

4. Enter the Re-Test scores as done before. Place your cursor in the field where you want to enter a score. Continue to navigate from field to field by clicking on the Tab key on the keyboard. The field will only allow you to enter a number from 0 to the maximum possible indicated value under each item. If a number higher than the indicated maximum possible value is entered, the number will
disappear, the field will turn pink, and display an exclamation mark momentarily.

5. Click on Save when you are done entering scores. You will get a confirmation message stating "Re-Test scores saved successfully." To continue entering Re-Test scores, navigate back to the Assessment Center by clicking on the Assessment link on the left hand side of the navigation menu.

Uploading Student Scores Using an Excel Spreadsheet

Student scores can be entered directly in the Assessment Center of myMCPS or scores can be uploaded using a previously downloaded Excel spreadsheet that teachers can use to record their scores. To Upload Student Scores using an Excel spreadsheet:

1. Log into myMCPS using your Outlook user name and password.

2. Navigate to the Classroom Center tab, click on the drop down arrow, and select Assessments.

3. Navigate to the Teacher column and enter the desired teacher's last name into the blank field. Click on the funnel next to the teacher's name and select Contains. The application will then display a message that says Loading.

4. Continue selecting and applying the different filters in order to locate the desired assessment.

5. Once the desired assessment is listed on the page, select the Excel icon shown next to the assessment's name, under the Export column, to begin downloading a spreadsheet for this assessment. A File Download dialogue box will appear asking the following: "Do you want to open or save this file?"

6. Click on Save. A Save As dialogue box will appear allowing users to choose a location where to save the file and to name it. It is recommended to save the file using the teacher's last name, grade, unit, and class section. For example, smith_gr2__u3_3016_07_01. Use underscores to separate words in the name of the file if needed.

7. Select the location where you want the file to reside, and click on Save.
You will have to follow this procedure in order to download all of the assessments needed for each teacher if you would like them to enter the scores themselves using the downloaded Excel spreadsheet. Once you have downloaded and saved the files, they can be emailed. Teachers will have to open the Excel files in order to enter scores. They must save them using the 2003 Excel format extension .xls without changing the file name. They have to be careful to enter the correct value for each item, since Excel won't prevent them from entering a value higher than the maximum allowed for each item. Teachers should save the updated files and email them back to you once they have finished entering scores.

8. To upload the Excel spreadsheet that teachers updated, saved, and emailed to you to the Assessment Center in myMCPS, you must first use the filters in the Assessment Center to locate the desired assessment.

9. Select the assessment by clicking on its name, for example, Math AP Grade 6 Unit 1.

10. Once the desired assessment is displayed in the Score Entry page, click on Browse in the upper left hand side of the page.

11. Navigate to the location where you have saved the updated Excel file, and double-click on it. You should now see it in the Browse field.

12. Click on Upload Scores. Your scores for this assessment will now display in the score fields of the assessment below. You will see a confirmation message acknowledging that the scores have been uploaded successfully.

13. Click on Save.

14. To upload scores for a different assessment, you can change the filters on the Score Entry page, one at a time, or navigate back to the Assessment Center by clicking on the Assessment link on the left hand side of the page and change the filters there. Once you have the desired assessment opened, follow the same procedure as before to upload scores.

Generating a Math Unit Assessment Report

The Assessment Report section of the Assessment Center allows you to run Math Unit Assessment reports. These reports are different from the ones in the Report Center. To generate a Math Unit Assessment Report

1. Log into myMCPS using your Outlook user name and password.

2. Navigate to the Classroom Center tab, click on the drop down arrow, and select Assessments.

3. Click on Assessment Reports on the left hand side of the page. You will be able to see two reports, the End of Year Report and the End of Unit Report.

4. Click on the link for the desired report to launch the Report Explorer.
You will see a series of filters that will need to be applied before a report can be
generated. The filters are School, School Year, Teacher, Assessment or Course, depending on the report, and Students. At the District Admin level, you will have access to all schools, and at the Principal, School Admin, and Teachers level you will only have access to the school of assignment. You will have to set each filter one at a time from left to right and allow for each request to be processed.

5. Set the filters as needed in order to generate a desired report.

6. After all of the filters have been set, click on View Report and your report will generate. In the upper left hand side of the page, you will see the number of pages in your report. You can navigate from page to page by using the arrows next to the page number. You can print your report by clicking on the print icon on the upper right side of the page. You can also export your report in different formats, for example PDF, CVS, etc. You can generate other reports by re-setting the filters and clicking on View Report. Make sure you clear your
previous settings before making new selections.

Updated July 13, 2009 | Maintained by John Scott