Friday, January 24, 2020

How to enter Q2 and Midterm Grades in Aspen

How to Enter Quarter 2 and MidTerm Grades in Aspen

I've updated the posting for Q2 and Midterm Grades by adding this video to show the steps to posting your Q2 grades. Here is a direct link to the video.




The steps to entering your Quarter 2 grades is similar to Quarter 1, but you have the additional step of also adding your MidTerm Exam grades.

To Post your Q2 grades in Aspen Gradebook,
  1. Go to the Scores page in your Gradebook
  2. In the Grade Columns drop down box, select Post Columns.  Also, set the Term to Q2.  
    (see yellow in image right)
  3. The Aspen Posting columns will appear.  These are
    • Q2Grd - Quarter 2 Grade
    • S1Exam - Semester 1 Exam
    • MidGrade - MidYear Grade
    • Q2ClsAbs - Quarter 1 Class Absences
    • Q2Com1 and Q2Com2 - Quarter 1 Comment 1 and Comment 2 fields
    • Q2 - The grade from your gradebook for quarter 2
Q2PostColumns-a.png
  1. Click the Update Post Columns button -OR-
    Select Options -> Update Post Columns
  2. This will take you through the Update Post Columns wizard.  (see images below)

  • Step 1. Select the Grade Term (Q2) and the Grades to update (all students).

Q2PostColumns2.png
  • Step 2. Select
  • Quarter 2 Grade = Average:Q2  
  • Mid Term Exam = (Do Not Update)
  • Mid Term Grade = District Calculation
  • Q2 Class Absence= Class Absence Total

Q2PostColumns3.png

Alternatively, you may add an assignment for the midterm grade and then automatically upload that grade by selecting it here.  
Your exam will be part of a category and will be part of the Q2 average AND the MidYear grade.  Thus, being factored twice.
Q2PostColumns3a.png
  • Step 3. Confirms the choices made in Step 1 and Step 2.
Q2PostColumns4.png

  1. Click Finish.
  2. You should notice that the Q2Grd and Q2ClsAbs fields will now be populated.
    ** S1Exam The field is now blank.  You will add your MidTerm exam grades into this column on the Post Columns - Term page.
    ** MidGrade The grade is equal to the Q2Grd because you have not yet added your midTerm grade. Q2PostColumns5.png
  3. After you have added your MidTerm exam grade, click the Update button in the  MidGrade column.   ** If the student(s) did not take a midterm exam, leave this field blank.  Aspen will ignore empty scores.
    Q2PostColumns6.png
Aspen will calculate the MidYear grade for you.  If you give Pass/Fail grades for your class, please enter P or F in the MidGrade field.
       Q2PostColumns7.png
  1. Add comment codes (see WHS Comment Codes)

Verifying your Grades
  1. Verify your grade in Q2Grd against the grade from your Gradebook which is labeled Q2.
Q2PostColumns8.png
  1. If you would like to change the grade, simply click on the grade in the Q2Grd field and change it. Grades that you have modified will be indicated by a red, crossed-out circle.  PostGrades7.png


Applying the N-Rule (5 or more absences)
  1. In Aspen, you will apply the N-Rule using the comment fields
    • 100 N-Rule: May lose credit for course due to to attendance issues. Contact school administration.
    • 101 N-Rule: Loss of credit, due to attendance issues, under consideration. Contact school administration

black-pushpin.png

What does the pushpin mean?  
  • If the pushpin is black ,
    you can enter grades for this column, but you cannot post them to transcripts yet.
  • If the pushpin is green with a triangle ,
    you can enter and post grades for this column.
  • If the pushpin is red with a square ,
    you already posted the information to transcripts. If you need to change a grade, you will be able to repost your grade for 5 days after the report cards are distributed.  After that, you will need to complete the grade change form (see Guidance department).



POSTING Grades
Once you have verified the grades, added comments, and applied the N-Rule if necessary, you can Post your grades. Posting your grades sends a copy of the grades in the field Q2Grd, S1Exam, and MidGrade (and comments) to the report card / student transcript.
    Q2PostColumns9.png

  1. Once the posting period has opened, the pushpin will turn from black to green.  The green signifies that you can post your grades.
  2. To Post your grades,  click the Post Grades button -OR- click Option -> Post Grades
  3. The Post Grades pop-up will appear.
    Fill in
    • Grade Term = Q2
    • Grades to post = Term Grades for all Students.
  4. Click Ok
  5. Once your grades are posted, your push pin will change from green to red.
  6. You must Post Grades for each class individually.


FAQs

    There will be no printed verification sheets.  Instead, you can verify your grades on the Post Columns page of your gradebook (see steps 10 and 11).
  • You may re-post your grades as many times as you please until the posting period ends.
  • Want a printable copy of this verification page?  
    • Select Reports -> Gradebook Sheet
    • The Gradebook Sheet will appear.  
    • Click Run.
    • The printable version of your Post Columns page of your gradebook will pop-up
    • Select Printer icon at the top of the Gradebook Sheet page.
  • If you planning on using the same comment field for most of the students in your class, you can quickly add the comment to all students by using Options -> Fill Down Values.  Then just change those students who need different comments.

Sunday, November 17, 2019

Google Classroom Quiz Assignment vs. Assignment with a Quiz

Have you ever wondered what is the difference between a Quiz Assignment in Google Classroom and an Assignment with a quiz (created on a Google form)? The actual quiz is the same, but if you want to easily transfer grades between Google Classroom and Aspen, then a Quiz Assignment is the best choice. Below is explained the difference between the two, and a third option that allows you to take a previously made quiz and turn it into a Quiz Assignment.

Quiz Assignment - The quiz is created in a Google form that is provided within the assignment.

  1. Create a quiz with the form provided.
  2. In the assignment window, select Grade Importing.
  3. When the quiz is done, go to Student Work and select Import Grades.
  4. The grades will go next to the student’s name just like grades that you manually enter in a regular assignment. You don’t need to go to the responses.
  5. If you use Grade Transferer Chrome extension, you can transfer the grades to Aspen.


Assignment (with a Google form quiz [made in Drive] attached as a link)
To obtain the grades:

  1. Open either the Responses or generate a Google Sheet to see the student’s grades.
  2. Have to manually transfer the grades to Aspen. 

Option #3 - You have a pre-made Google form quiz in Drive, but you would like to be able to use Quiz Assignment to import grades easily:

In Classwork, select Create, Quiz Assignment.

  1. Select Drive.
  2. Navigate to your quiz.
  3. Delete the Blank Quiz.
  4. Switch on Grade Importing.
  5. Assign.
  6. When the quiz is done, follow the directions above from Quiz Assignment to obtain the grades.



Wednesday, October 30, 2019

How to Post Q1 Grades

How to Enter Quarter Grades in Aspen

Your Aspen gradebook is similar to the paper gradebook that we all used to use.   It’s a private document that only you can see. At the end of each quarter, your student grades and comments must be posted to make them visible to the school and district.

At the beginning of the school year, you should have set up your gradebook details.  The Details page allows you to create your average mode, set up categories, and link classes. To learn more about setting up your gradebook details, see my blog entry Setting up your gradebook in Aspen.

To Post your grades in Aspen Gradebook,


  1. Select your first class in your gradebook. Click on the Grade Columns dropdown and select Post Columns - Terms.
  2. The Aspen Posting columns will appear. These are
    • Q1Grd - Quarter 1 Grade
    • Q1ClsAbs - Quarter 1 Class Absences
    • Q1Com1 and Q1Com2 - Quarter Comment 1 and Comment 2 field
  3. Select Options -> Update Post Columns
PostGrades2.png

  1. This will take you through the Update Post Columns wizard.
    • PostGrades3.pngStep 1. Select the Grade Term (Q1) and the Grades to update (all students).
    • Click Next



  • PostGrades4.png
    Step 2. Select
  • Quarter 1 Grade = Average:Q1
  • Q1 Class Absence= Class Absence Total
  • Click Next

    PostGrades5.png
  • Step 3. Confirms the choices made in Step 1 and Step 2.
  • Click Finish
   
  1. The Q1Grd (Q1 grade) and Q1ClsAbs (Q1 Class Absense) fields should now be populated. The Q1 total field from your gradebook has been copied to the Q1Grd field.

  2. Add comment codes (see WHS Comment Codes).


Verifying your Grades
  1. Verify your grade in Q1Grd against the grade from your Gradebook which is labeled Q1.
  2. If you would like to change the grade, simply click on the grade in the Q1Grd field and change it. Grades that you have modified will be indicated by a red, crossed-out circle.
  3. PASS/FAIL Courses If your class is being taken as a Pass/Field, you should change the Q1Grd field from a number to a P or a F. To change the entire column at once, add the P in the first students Q1Grd field and then click CTRL-D. Note the red, crossed-out circle next to the grade. This simply indicates that a modification to the grade was made by the teacher.

Applying the N-Rule (5 or more absences)
  1. Determine if N-Rule applies. See N-Rule from Handbook
  2. In Aspen, apply the N-Rule using the comment fields
    • 100 N-Rule: May lose credit for course due to to attendance issues. Contact school administration.
    • 101 N-Rule: Loss of credit, due to attendance issues, under consideration. Contact school administration




black-pushpin.pngWhat does the pushpin mean?
  • If the pushpin is black ,
    you can enter grades for this column, but you cannot post them to transcripts yet.
  • If the pushpin is green with a triangle ,
    you can enter and post grades for this column.
  • If the pushpin is red with a square ,
    you already posted the information to transcripts. If you need to change a grade, you will be able to repost your grade for 5 days after the report cards are distributed.  After that, you will need to complete the grade change form (see Guidance department).

PostGrades8.png

POSTING Grades
Once you have verified the grades, added comments, and applied the N-Rule if necessary, you can Post your grades. Posting your grades sends a copy of the
grades in the field Q1Grd (and comments) to the report card / student transcript.
  1. Once the posting period has opened, the pushpin will turn from black to green.  The green signifies that you can post your grades.
  2. To Post your grades,  click Option -> Post Grades
  3. PostGrades9.png
    The Post Grades pop-up will appear.
    Fill in
    • Grade Term = Q1
    • Grades to post = Term Grades for all Students.
  4. Click Ok
  5. Once your grades are posted, your push pin will change from green to red.
  6. **IMPORTANT ** You must Post Grades for each class individually.



FAQs

  • You may re-post your grades as many times as you please until the posting period ends.
  • There will be no printed verification sheets.  Instead, you can verify your grades on the Post Columns page of your gradebook (see steps 9 and 10).
  • Want a printable copy of this verification page?  
  1. Select Reports -> Gradebook Sheet
  2. The Gradebook Sheet will appear.  
  3. Click Run.
  4. The printable version of your Post Columns page of your gradebook will pop-up
  5. Select Printer icon at the top of the Gradebook Sheet page.

  • If you planning on using the same comment field for most of the students in your class, you can quickly add the comment to all students by using Options -> Fill Down Values or CTRL-D.  Then just change those students who need different comments.