In this article, we'll learn how to add scores to the Gradebook from activities that students completed outside of Writer's Help 2.0. Such activities might include: in-class quizzes/exams, class participation points, informal writing, or peer review.
First, we will show how to add an HTML Page (which is needed to incorporate any of the above activities) to Writer's Help. Then we will show how to export and import your scores/grades for that activity.
Click HTML Page.
If you do not see the Edit button or Basic Info tab right away, you may need to click Add to course at the top right of the screen.
Add item to course
Then, click Options > Edit on the HTML Page in your course to edit it.
Create HTML Page
Enter a Title, Subtitle (if desired), and Directions for your assignment. The Directions will become the body of your assignment, so enter any desired text, images, or links here. Then, click Save.
Click "Done Editing"
Click Done Editing in the upper left corner of the screen. You will see a preview of the HTML page you created.
Click Home to return to your course home page.
Your HTML Page appears in the Table of Contents under the first chapter. If you wish, you can move it to another location in the Table of Contents. The next steps will go over that procedure.
From the Table of Contents, move your activity
Open the chapter in the Table of Contents where you would like the new HTML Page to be. Drag and drop the yellow bar (representing the HTML Page) to the desired location.
From the Table of Contents, assign your activity
Hover your cursor over HTML Page in the Table of Contents, then click on the Options tab.
From the "Manage Assignment" screen
- From the drop-down menu, select an assignment unit for your assignment. You can also create a new assignment unit by clicking Create New. For more information on this, please see the help article How do I create assignments?.
- Set a Due Date and time, if you wish.
- By default, your assignment will be visible to students. Uncheck the box Visible to students if you want the assignment to be hidden. You will be able to make it visible again later.
- Enter the number of Points for this assignment in the Gradebook section.
- Click Assign.
From your home page, click "Gradebook"
When you’re ready to enter grades for this assignment, you can do so in two ways:
Whichever way you choose, you can do this from your Gradebook.
In your Gradebook, you should now have a column for the assignment. If you want to enter the grades manually, you can click on the grade column next to each student and enter in the correct point value. The cursor will automatically move from student to student down the list in the gradebook.
If you have grades recorded outside of Writer's Help (for example, in an Excel document), you can import them into your Writer's Help Gradebook. Here are the steps at a glance:
- Export your Writer's Help Gradebook into a .csv file.
- Add your scores to this file.
- Import the .csv file into your Writer's Help Gradebook.
Export your Writer's Help Gradebook
The Export Scores window will open and will display several pieces of information that you have the option of exporting from your Writer's Help Gradebook into a .csv file. We'll walk through each section of the Export Scores window and highlight the selections most of our instructors make. Click Export Scores.
Select Student Information, Item Information, and Item Data
To quickly import scores you're currently keeping outside your Writer's Help Gradebook, select only the items you need. For example:
- To identify your students, under Student Information, select First Name, Last Name, Grade, and any other information you would like.
- To identify one or more offline assignments or activities for which you wish to import grades – under Item Information, select Title.
- To dictate whether assignment scores should display as number of points or a percentage, under Item Data tick Points or Percent, respectively.
- To export your entire Gradebook, tick ALL under Items Selection. Click the + next to the All folder to view and select or de-select categories you wish to include or exclude. Click the + next to a category folder to expand it and select or de-select individual assignments you wish to include or exclude.
- Your File name will be "Grades" by default. You can change it to whatever you like. Again, by default, your grades will be exported into a .csv file, but you can drop the File type menu down to select Tab-separated file (.txt).
Select what program you would like to open the csv file with (for example: Excel, Open Office, or Google Docs). Then click OK.
Copy and paste scores into the .csv file
You now have an exported Gradebook. Simply copy the grades from each of your offline assignments or activities and paste them into the appropriate grade column.
Save your .csv file changes from Excel or similar program
Click File > Save As to select the type of file (if different from .csv).
Navigate to the folder location where you wish to store your offline/activity grades. Name your file. Then, click Save.
Save your changes in your .csv file
When you save the changes you made to the Gradebook, you may get a message that looks similar to the screen shot below. Click Yes to save in CSV format.
Return to your Writer's Help Gradebook and click "Import Scores"
To import the new grades into Writer's Help, return to your Gradebook and click Import Scores at the top of the page.
Choose the file to import
Click Choose File and select the Gradebook .csv file you exported and edited. If your file included a header, such as one or more assignment titles, make sure to check the box next to Header Row. When you are ready, click Continue.
Select csv file
Navigate to where your offline/activity grades are located. Select the file and click Open.
On the screen that appears, verify the information you are uploading is correct. When you are ready, click Continue.
Green check marks will appear in the OK column, verifying that the information was successfully imported. Click Close.