Attendance: Transfer Attendance Scores to Grades Tool

The TCU Online Attendance tool is not connected to the Grades tool. If you would like to transfer the attendance average to the grades tool, please follow the steps below. Note: The steps below should only be followed once your Attendance Scheme and Register is setup, and sessions have been marked.

  1. From within your course, select the People menu from the Navigation bar, then select Attendance.
    People Attendance
  2. Select your Register from the list. In this example, we will select the PHH Attendance register.PHH Attendance Register
  3. At the top of the attendance register, select Export All Data.
    Attendance - Export All Data
  4. On the window that opens, select the blue link to download your file.   Note: you will then need to locate where your browser’s download folder is.  Once located, open the file to view in Excel.
    File is ready for download
  5. At this point, you can keep open the CSV file you exported in Excel.  Make any adjustments to the Attendance final score as needed.  Be sure to Sort your Spreadsheet by Last name to keep the list alphabetized to allow for easy grade transfer.  Keep the file open and then go back to your browser. We will return to this document soon.
  6. From within your course, select the Grades tool from the Navigation menu.
    Grades Navigation
  7. From this point of the steps, we assume that you already have a Grade Item called Attendance or similar setup. If you do not, you will need to Create an Item before proceeding. Once your Grade item is setup, Select Enter Grades, then click Export.
    Export Grades
  8. Make sure that “points grade” is checked in the Grades Values section and that all of your grade items are checked. (The file will not work if only Attendance (or similar) grade item is checked) Then select Export to CSV.
    Note: your page will look slightly different depending on what Grade Items you have setup in your course.
    Select Export to CSV
  9. On the window that opens, select the blue link to download your file.   Note: you will then need to locate where your browser’s download folder is.  Once located, open the file to view in Excel.
    Download Grade Export
  10. Sort your Grades Export spreadsheet by Last name to keep the list alphabetized to allow for easy grade transfer.
  11. Return to your Attendance Export spreadsheet and locate the % Attendance column.  Select all of the student grades, then Copy the content (Edit>Copy).
  12. On the Grades Export spreadsheet, locate in your Grades Export the Attendance (or similar) Grade column. It should say something like “Attendance Points Grade <Numeric MaxPoints:100>”  (The item title and MaxPoints might be different depending your preference/setup). Paste the grades from the Attendance Export into the Attendance Points Grade column.
  13. Compare both spreadsheets side-by-side to make sure the correct student grades from the Attendance Export are aligned in the Grades Export.
  14. Once the grades are confirmed.  SAVE the Grades Export spreadsheet as a CSV.   An alert might pop up (since it is a CSV file). Click OK.
  15. Go back to your course and select Grades on the Navigation bar.  Then select Enter Grades and click Import.
  16. On the page that follows, choose the file to Import from your computer, then select Continue.
  17. Preview the grade import, then click Import.

TCU-specific Documentation Tags

acceptable access accessibility accessible accommodations activate activate course activities ada additional additional time adjusted final grade android annotations announcements anonymous app apple apps assignment grader assignments athlete attachment attendance audio auditor banner best practice best practices binder blind marking bonus bookmark bookmarks calendar cancelled course categories category chat class engagement classlist class progress combined combined shell completion tracking content content statistics content tool copy copy course course access course admin course home course offering course shell course snapshot course title crash course data dates design disability discussion discussions document storage draft dropbox e-rater email email all classes email groups embed end date engagement english enroll enrollment enrollments event log event logs exam exams exclude exempt exempt grade exemptions export export grades extend access extension extra credit extra time Facebook faq far feedback file file extensions files file size file types final adjusted grades final calculated grades final grade final grades force locale french GA gardes google drive gradebook grade item grade items grademark grades grade scheme grading grading system group chat groups guest hide history homepage homepages hours tracking html html editor html template html templates hyperlink import import grades inactive individual insert stuff instructor instructor presence instructors intelligent agents iOS item items journal journals kanopy language library database limit link locale lockdown browser locker Log In login bookmark LOR manage dates master courses math missing class modules monitor mytcu name new faculty notifications offset offset dates originality overview pass/fail password pedagogical points peoplesoft permissions personalize photo platform requirements points post practice run preferences preview grades professor published pulse question library question pool questions quick link quicklinks quiz quiz import quizzes random sections record video release conditions release grades replace strings reply-to report request request bookmark reset reset quiz respondus restore restricted restrictions roles role switch rubrics scantron schedule scorm section change sections selectbox self-enroll self assessments set dates settings setup wizard shared shared shell shell shuffle snapshot solution spotlight sos spanish special access special class start date statistics student student grades students study abroad submission folder submission view submission views surveys TA table of contents teaching assistant technical requirements template test text text grade item time tips tool access trademark turnitin twitter update profile updates upload content user profile user progress verify enrollments video video note view as student viewer virtual classroom visibility visibility web conferencing weighted widget widgets