Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
grades [2015/04/24 16:58] olteanlo |
grades [2020/06/19 10:24] (current) hartzde |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| [[:start|{{:avenuewiki:avenue.jpg?nolink&200x50}}]] | [[:start|{{:avenuewiki:avenue.jpg?nolink&200x50}}]] | ||
| + | <html><h1><b>***UPDATES: PLEASE USE THE FOLLOWING WEBSITE FOR THE LATEST INFORMATION ABOUT AVENUE TO LEARN:***</br></br> <a href="https://avenuehelp.mcmaster.ca">https://avenuehelp.mcmaster.ca</a></b></h1></br></br></br> </html> | ||
| ====== Grades ====== | ====== Grades ====== | ||
| Line 8: | Line 8: | ||
| - | How do I setup my grade book in Avenue to Learn? [[https://documentation.desire2learn.com/en/Grades|https://documentation.desire2learn.com/en/Grades]] | + | How do I setup my grade book in Avenue to Learn? [[https://documentation.brightspace.com/EN/semester_start/-/instructor/faq_grades.htm|https://documentation.brightspace.com/EN/semester_start/-/instructor/faq_grades.htm]] |
| + | |||
| + | Understanding the Grades Tool: | ||
| + | |||
| + | {{youtube>_3pckzsJeJ4?large}} | ||
| + | |||
| + | <html><br /></html> | ||
| + | |||
| + | How to create a Grade Item: | ||
| + | |||
| + | {{youtube>RfupITmDqCA?large}} | ||
| + | |||
| + | <html><br /></html> | ||
| + | |||
| + | How to Create a Grade Book Category: | ||
| + | |||
| + | {{youtube>VgaHhHzZ4mA?large}} | ||
| + | |||
| + | <html><br /></html> | ||
| + | |||
| + | How to Enter Grades: | ||
| + | |||
| + | {{youtube>hThRRADR478?large}} | ||
| + | |||
| + | <html><br /></html> | ||
| + | |||
| + | How to Create Grade Exemptions: | ||
| + | |||
| + | {{youtube>GRDXyS529pU?large}} | ||
| + | |||
| + | <html><br /></html> | ||
| Line 14: | Line 44: | ||
| - | ==== How do I export my grade book on Avenue for submission to Mosaic? ==== | + | ==== Loading Grades into Mosaic - Directly from Avenue ==== |
| - | **Note**: If you choose to load the grades from Avenue directly into Mosaic, here are some considerations: | + | Here are some considerations if you choose to load your grades from Avenue directly into Mosaic. This is a quick sheet for loading grades into Mosaic: http://mcmaster.ca/mosaic/faculty/load-grades-from-A2L.pdf . The full instructions for Mosaic can be found here: http://mcmaster.ca/mosaic/faculty/online-grade-user-guide.pdf |
| - | 1. In your Grades tool, **under Settings** (right hand side of the screen), go to the **Org Unit Display Options** tab. Under the Final Grades Calculation, ensure that the "Display how final grade was calculated to users" is checked off. This will ensure that students do not see their final grades in Avenue. | + | 1. Please ensure your course is **active**. If you have deactivated your course at the end of the term, please activate it so that Mosaic can pull the grades from your Avenue course directly (only active courses will appear). Here are instructions on how to activate your course: http://avenue.mcmaster.ca/help/docs/activate_a_course.pdf |
| - | 2. Still in the **Settings** area, under the **Calculation Options** tab, ensure that the final grade released is the grade item you are actually using for calculating your final grades. (ie. if you have been using the Final Adjusted grade, make sure that this is selected in this area of the Settings) - this is the setting by which Mosaic will go when it pulls grades from Avenue. If you have the Adjusted final grade released (remember, if you do not have the "Display how final grade was calculated to users" checked, students will NOT be able to see the grades in Avenue so do not worry about the word "release") but you have not been using that grade item, Mosaic will not pull any grades. In this case, you will need to have the Final Calculated Grades checked in this area of the Settings. | + | |
| + | 2. Please ensure your grading scheme is set to the default Percentage scheme. You can check this by going to **Schemes** in your Grades tool. | ||
| - | At the end of the semester you will want to export your grades from your course on Avenue and prepare it for submission to the Registrar as your final grades. This document will guide you through the process of preparing this CSV file as it is exported from Avenue to what Mosaic wants. | + | 3. In your Grades tool, **under Settings** (right hand side of the screen), go to the **Org Unit Display Options** tab. Under the Final Grades Calculation, ensure that the "Display final grade to users" is not checked. This will ensure that students do not see their final grades in Avenue. |
| + | |||
| + | 4. Still in the **Settings** area, under the **Calculation Options** tab, ensure that the final grade released is the grade item you are actually using for calculating your final grades (ie. if you have been using the Adjusted Final Grade, make sure that this is selected in this area of the Settings) - this is the setting by which Mosaic will pull grades from Avenue. The default setting is the **Calculated Final Grade**. | ||
| + | |||
| + | {{:finalgradereleased.png}} | ||
| + | |||
| + | 5. Final grades **must** be rounded, with **no decimals** before being uploaded into Mosaic. The easiest way is to do this directly in Avenue before uploading to Mosaic. You can do this by going into **Settings**, then into the **Org Unit Display Options** tab. There, change the two decimal places boxes to 0 under the Managing View and Student View Display Options. This will change the gradebook to display round numbers with no decimal places. | ||
| + | |||
| + | {{:decimalplaces.png}} | ||
| + | |||
| + | |||
| + | ----- | ||
| + | ==== Loading Grades into Mosaic - Spreadsheet ==== | ||
| + | |||
| + | <note warning>We strongly recommend that if you use Avenue for your grades, you choose the first method outlined above of pulling the grades from Avenue straight into Mosaic.</note> | ||
| + | |||
| + | We strongly recommend that if you use Avenue for your grades, you choose the first method outlined above of pulling the grades from Avenue straight into Mosaic. It is the easiest, fastest and most accurate method of submitting your final grades. However, if you choose to use a spreadsheet file to import your grades into Mosaic, here's how to export your grades from Avenue and import them into Mosaic in a csv format. | ||
| Line 52: | Line 98: | ||
| - | The next few steps will take place in Microsoft Excel 2007. The process will be similar for Microsoft Excel 2003 and Open Office Calc. If you saved the file to a location on your computer in the previous step, open the file now; if you opened the file in the previous step, save the file to a location on your computer now. Now is a good time to double check that the correct student has the correct mark. If there is an issue, you can make changes now to the number in column E. | + | The next few steps will take place in Microsoft Excel 2007. The process will be similar for Microsoft Excel 2003 and Open Office Calc. If you saved the file to a location on your computer in the previous step, open the file now; if you opened the file in the previous step, save the file to a location on your computer now. Now is a good time to double check that the correct student has the correct mark. If there is an issue, you can make changes now to the number in column E. You will notice that some grades might have decimal places. Mosaic will not accept decimal places so you will need to get rid of them. To do that, right click on the name of the column and go to Format Cells. Go to Numbers and change the decimal places to 0. |
| - | {{:grades5.png?nolink&769x314}} | + | {{:grades_export.png}} |
| - | The first thing we need to do is to change the column headings to conform to what the Online Grade submission expects. The column headings are found in row 1 of the Excel spreadsheet and are highlighted in the picture above. The system will accept OrgDefinedId and Username but needs to have **Calculated Final Grade Numerator** renamed to **FinalGrade** (be sure to rename this with no space between Final and Grade). To do this highlight Calculated Final Grade Numerator, and type FinalGrade. You can also select the Last Name, First Name, Calculated Final Grade Denominator and End-of-Line Indicator and delete them. | + | The first thing you need to do is to remove the column headings to conform to what the Online Grade submission expects. The column headings are found in row 1 of the Excel spreadsheet above. Then, you can remove the columns that are not necessary, and add the class number column. Your final spreadsheet should have the class number, student number, and the final grade. |
| Line 64: | Line 110: | ||
| - | {{:grades6.png?nolink&294x286}} | + | {{:grades_mosaic.png}} |
| + | Now you can save your spreadsheet by going to **Save As, Other Formats, CSV**. | ||
| - | Click the Windows menu, and **Save As, Other Formats, CSV**. | + | **Note**: For MAC users, please make sure you save as **Windows Comma Separated (csv)**. |
| - | **Note**: For MAC users, please make sure you save as **MS-DOS Comma Separated (csv)**. | ||
| - | + | The CSV is now ready for uploading to Mosaic. The rest of the instructions for how to upload your grades in Mosaic can be found here: http://mcmaster.ca/mosaic/faculty/online-grade-user-guide.pdf | |
| - | The CSV is now ready for uploading to Mosaic. | + | |
| Line 81: | Line 126: | ||
| + | <html><br /></html> | ||
| ---- | ---- | ||
| - | + | //For questions or concerns, Avenue support is available from Monday to Friday, 8:30 AM to 4:30 PM at (905) 525-9140 ext. 23757 or by completing the intake form located at http://avenue.mcmaster.ca/support/ // | |
| - | //For questions or concerns, Avenue support is available from Monday to Friday, 8:30 AM to 4:30 PM at (905) 525-9140 ext. 22911 or email support.avenue@cll.mcmaster.ca.// | + | |
