Importing results from Excel to the highlighted results column

You can import student results from Excel into Student Results Maintenance. You are restricted to importing a column at a time.

To import results from Excel to the highlighted results column:

1. Start Microsoft Excel.
2. Open the spreadsheet containing the student results.
   
   Note: Column A must contain the Synergetic IDs of the students.
   Tip: To easily get the Synergetic IDs and students for the class, first export the blank results to Excel. For a similar example, see Exporting results to Microsoft Excel for a class.
3. Highlight the cells containing the results that you want to import.
   
4. Switch to Synergetic.
5. Open the All Students tab of Student Results Maintenance for the class you are updating the results for. See Student Results Maintenance - All Students tab.
   
6. Highlight the column that you want to import results for.
   
   Tip: Click the heading to highlight the column.
7. Right click.
   The menu is displayed.
8. Select Import Results for Highlighted Column from Excel.
   
   The following dialog window is displayed.
   
9. Click .
   The student results are imported and values updated for each corresponding student.
   
10. Repeat steps 2 through 9 for each additional column that needs importing.

Attachments (15)

worddav92ae4fd156461a86c504c804e8486608.png
2.93 KB

worddav144541725e2148c323840c0208628b04.png
1.85 KB

worddav7f8e228c8b0823a4a93d9c82edce4cac.png
8.24 KB

worddav18f16f9609854cb83bcf3ce801b51530.png
3.33 KB

worddav39f314661b8df67be5f0763fdadc8790.png
1.35 KB

worddav96abe8558f64c20ebbb2e67680ef5009.png
2.79 KB

worddav50b6c65fd28b900ec45e0e0e65776fbc.png
2.46 KB

69e1d864ce1d6.Microsoft_Excel_-_German_A_class_results_import.gif
3.64 KB

69e1d864ce1d8.Microsoft_Excel_-_German_A_class_results_import_(highlighted_column).gif
4.16 KB

69e1d864ce1d9.Student_Results_Maintenance_-_All_Students_tab_(import_from_Excel_1).gif
5.04 KB

69e1d864ce1da.Student_Results_Maintenance_-_All_Students_tab_(highlighted_column).gif
1.78 KB

69e1d864ce1db.Student_Results_Maintenance_-_All_Students_tab_(highlighted_column_right_click_....gif
2.42 KB

69e1d864ce1dc.confirm_-_about_to_attempt_to_import_from_Microsoft_Excel_(Student_Results_Maint).gif
10.5 KB

69e1d864ce1dd.bn_yes.png
1.03 KB

69e1d864ce1de.Student_Results_Maintenance_-_All_Students_tab_(import_from_Excel_2).gif
3.97 KB