Student

User Tools

Site Tools

Trace: • Place (MSALGO) • Other functions and features: • Control by Student • Scheduling Transfer • Other functions and features: • scheduling_load_stu_w_unsched_prxies_body • Auto Assign Grades and Citizenship
gradereporting:utilities:importfromexternalgradebook

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
gradereporting:utilities:importfromexternalgradebook [2017/03/02 21:49] – jstanfordgradereporting:utilities:importfromexternalgradebook [2021/12/16 19:49] (current) – apape
Line 1: Line 1:
 +{{indexmenu_n>60}}
 ======Import From External Gradebook====== ======Import From External Gradebook======
  
Line 7: Line 8:
 <WRAP round intro>This utility imports and updates records created by third-party grade book software. Before running the utility, the following should be completed: <WRAP round intro>This utility imports and updates records created by third-party grade book software. Before running the utility, the following should be completed:
  
-  * Create the import file from the external grade book software. Click here to view the file layout (PDF format). +  * Create the import file from the external grade book software. [[https://help.ascendertx.com/interfaces/doku.php/student/external_gradebook_grades_import|Click here]] to view the interface. 
-Update the Maintenance > Tables > Campus Control Options > Ranges & Conversions and Posting tabs. Be sure to select Allow Credit on the Posting tab in order to post grade book files. +  * Update [[gradereporting:maintenance:tables:campuscontroloptions:rangesandconversions|Maintenance > Tables > Campus Control Options > Ranges & Conversions]] and [[gradereporting:maintenance:tables:campuscontroloptions:posting|Posting]]. Be sure to select **Allow Credit** on the Posting tab.\\  \\   
 +<WRAP box>**NOTE:** Any tracks that are imported as one-digit are zero-padded to two digits. For example, a value of 1 will be changed to 01 when importing the attendance record.</WRAP> 
 +\\   
 +<WRAP box>**IMPORTANT:**  This utility supports only four-character course numbers. If the import file contains longer course numbers, you can use TeacherPortal. Contact your regional education service center (ESC) for more information on using an external gradebook software that can accommodate course numbers with more than four characters. </WRAP>
  
 </WRAP> </WRAP>
  
 +++++ Edits|{{page>general:grade_reporting_utility_import_external_gb_edits&inline}}++++
  
 +====Import data:====
  
  
-Important:  This utility supports only four-character course numbers. If the import +^File Name|{{page>general:grade_reporting_utility_import_external_gb_file_name}}| 
-file contains course numbers that are longer than four characters, you can use txGradebook. +^Semester|{{page>general:grade_reporting_utility_import_external_gb_file_sem}}| 
-Please contact your education service center (ESC) for more information on using +^Cycle|{{page>general:grade_reporting_utility_import_external_gb_file_cyc}}| 
-an external gradebook software that can accommodate course numbers with more than +^Include in Error List|{{page>general:grade_reporting_utility_import_external_gb_include_in_error_lst}}| 
-four characters. +\\   
- +VCV Click **Import**. 
- +  * When the process is complete, a message is displayed indicating that the process is completed and the number of errors. 
-The utility implements the following edits: +  * The data is posted to the student grade-course record.
- +
- +
-Uses posting information from the Maintenance > Tables > Campus Control Options page +
-to determine which fields to update. +
- +
- +
-Uses the edits for the High Grade Allowed and Low Grade Allowed fields. If grades +
-are not in this range, they are not posted. +
- +
- +
-Does not post comments that do not exist in the campus comments table. +
- +
- +
-Does not overwrite an existing grade with a blank grade. +
- +
- +
-Note:  You can import exams that have an X for exempt grades for all grade levels, +
-if the campus has selected the Allow Exempt Exam field on the Maintenance > Tables +
-> Campus Control Options > Posting tab. +
- +
- +
-Import grade information from an external grade book: +
- +
- +
-Click Browse to select the file to import. A dialog box opens allowing you to locate +
-the file. +
- +
- +
-Click Browse to locate the file. The Choose File to Upload dialog box opens allowing +
-you to locate the file. +
- +
- +
-Select the file and click Open. The file name contains the county-district number, +
-campus ID, and date. +
- +
- +
-The path of the file is displayed in the field. +
- +
- +
-Click Submit. +
- +
- +
-The file name is displayed in the File Name field. +
- +
- +
-The Semester fields are displayed. +
- +
- +
-Under Semester, select the semester of the data you are importing. The Cycle fields +
-are displayed. +
- +
- +
-Under Cycle, select the cycle of the data you are importing. +
- +
- +
-Under Include in Error List, the Conduct Grade field is displayed. +
- +
- +
-Select Conduct Grade to include the conduct grade in the error list. +
- +
- +
-Click Import. +
  
-When the process is finished, a message is displayed indicating the number of errors.+----
  
 +^Preview Errors|++ Click to view the error list if errors are encountered.| {{page>general:print&inline}} ++|
  
-The data is posted to the student grade/course file. 
  
  
-If errors are encountered, the Preview Errors button is displayed. Click Preview 
-Errors to view the error report. Review, save, or print the report. 
gradereporting/utilities/importfromexternalgradebook.1488491369.txt.gz · Last modified: 2017/03/02 16:49 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.