grades - Wiki

You are here: start » grades
This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

<p>
<a href="/avenue/doku.php?id=start" class="media" title="start"><img src="/avenue/lib/exe/fetch.php?w=200&h=50&tok=6543e1&media=avenuewiki:avenue.jpg" class="media" title="Wiki Homepage" alt="Wiki Homepage" width="200" height="50" /></a>
</p>

<h1>Grades</h1>
<div class="level1">

</div>

<h2>Vendor Documentation</h2>
<div class="level2">

<p>
How do I setup my grade book in Avenue to Learn? <a href="https://documentation.desire2learn.com/en/Grades" class="urlextern" title="https://documentation.desire2learn.com/en/Grades"  rel="nofollow">https://documentation.desire2learn.com/en/Grades</a>
</p>

</div>

<h2>Avenue Specifics</h2>
<div class="level2">

</div>

<h3>Loading grades into Mosaic - pulling grades directly from Avenue</h3>
<div class="level3">

<p>
Here are some considerations if you choose to load your grades from Avenue directly into Mosaic. The rest of the instructions for how to upload your grades in Mosaic can be found here: <a href="http://mcmaster.ca/mosaic/faculty/online-grade-user-guide.pdf" class="urlextern" title="http://mcmaster.ca/mosaic/faculty/online-grade-user-guide.pdf"  rel="nofollow">http://mcmaster.ca/mosaic/faculty/online-grade-user-guide.pdf</a>
</p>

<p>
1. In your Grades tool, <b>under Settings</b> (right hand side of the screen), go to the <b>Org Unit Display Options</b> 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.
</p>

<p>
2. Still in the <b>Settings</b> area, under the <b>Calculation Options</b> 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 selected under Settings, but you have not been using that grade item, Mosaic will not pull any grades, as it is looking in that field in Avenue. In this case, you will need to have the Final Calculated Grades checked in this area of the Settings. The default setting until now has been the Final Adjusted Grade. For all new courses starting in the spring 2016, the default will be the <b>Final Calculated Grade</b>.
</p>

<p>
3. Final grades <b>must</b> be rounded, with <b>no decimals</b> 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 <b>Settings</b>, then into the <b>Org Unit Display Options</b> 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.
</p>
<hr />

</div>

<h3>Loading grades into Mosaic - using a spreadsheet</h3>
<div class="level3">

<p>
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.
</p>

<p>
From within the course in Avenue that you want to collect grades for export, choose <b>Assessments</b> and in the drop down menu select <b>Grades</b>.
</p>

<p>
<img src="/avenue/lib/exe/fetch.php?w=356&h=229&tok=dbf5b1&media=grades1.png" class="media" alt="" width="356" height="229" />
</p>

<p>
Make sure you are in the<b>Enter</b><b>Grades</b> menu and select <b>Export</b>.
</p>

<p>
<img src="/avenue/lib/exe/fetch.php?w=323&h=115&tok=0c7c3b&media=grades2.png" class="media" alt="" width="323" height="115" />
</p>

<p>
On the Export Grades page, you will want to consider your options when exporting key fields. You will want Both<b>Org</b><b>Defined</b><b>ID</b> and <b>Username</b> exported. For most students, the Org Defined ID is their student number (in specific cases, some students may have their MacID as their Org Defined ID). The Username is always the student’s MacID. Under User Details, you may want to add the First Name and the Last Name to the export as well. This will help you differentiate similar MacIDs, but the names are not needed for the Import process.
</p>

<p>
When you are choosing which grades to select for exporting, the only one you will need is either the <b>Final Calculated Grade</b> or the <b>Final Adjusted Grade</b>. Select whichever one you have been using in Avenue for your grades.
</p>

<p>
<img src="/avenue/lib/exe/fetch.php?w=400&h=809&tok=9e71a9&media=grades3.png" class="media" alt="" width="400" height="809" />
</p>

<p>
When you are satisfied with the information you are exporting, then click Export to CSV or Export to Excel. A pop-up window will appear, and begin to process the CSV (a file that has Comma Separated Values) or Excel file. Once the process is complete you will see a link that contains the CSV or Excel file. Click on the link to open it, or right click to save the file to your computer.
</p>

<p>
<img src="/avenue/lib/exe/fetch.php?w=500&h=283&tok=273473&media=grades4.png" class="media" alt="" width="500" height="283" />
</p>

<p>
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.
</p>

<p>
<a href="/avenue/lib/exe/detail.php?id=grades&media=grades_export.png" class="media" title="grades_export.png"><img src="/avenue/lib/exe/fetch.php?media=grades_export.png" class="media" alt="" /></a>
</p>

<p>
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.
</p>

<p>
When complete, it should resemble this:
</p>

<p>
<a href="/avenue/lib/exe/detail.php?id=grades&media=grades_mosaic.png" class="media" title="grades_mosaic.png"><img src="/avenue/lib/exe/fetch.php?media=grades_mosaic.png" class="media" alt="" /></a>
</p>

<p>
Now you can save your spreadsheet by going to <b>Save As, Other Formats, CSV</b>.
</p>

<p>
<b>Note</b>: For MAC users, please make sure you save as <b>MS-DOS Comma Separated (csv)</b>.
</p>

<p>
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: <a href="http://mcmaster.ca/mosaic/faculty/online-grade-user-guide.pdf" class="urlextern" title="http://mcmaster.ca/mosaic/faculty/online-grade-user-guide.pdf"  rel="nofollow">http://mcmaster.ca/mosaic/faculty/online-grade-user-guide.pdf</a>
</p>

</div>

<h2>Effective Pedagogical Practices</h2>
<div class="level2">

<p>
Please let us know if you have any pedagogical input for this tool.
</p>
<hr />

<p>
<em>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.</em>
</p>

</div>
Print/export

Printable version
Search

Navigation

Print/export

Tools

QR Code
