Difference between revisions of "Export Transcript Comma Delimited"

From EDgearWiki
Jump to navigationJump to search
 
(27 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
__NOTOC__
 
__NOTOC__
−
'''Program to Export Comma Delimited Transcript File.'''
+
'''This program provides the user a way to export courses with grades in a Comma Delimited formatted file. Be sure that a [[Grades Closeout EOY]] has previously been done for current year courses. '''
  
 
==Menu Location==
 
==Menu Location==
  
−
[[File:exporttransmenu.png]]
+
'''Transcripts''' > '''Interfaces''' > '''Export Transcript Comma Delimited'''
−
 
 
−
 
 
−
On the left navigation panel, select '''Transcripts''' > '''Interfaces''' > '''Export Transcript Comma Delimited'''.
 
  
 
==Setup Options==
 
==Setup Options==
Line 15: Line 12:
 
'''Year''' - Defaults to the current year. A prior year may be accessed by clicking in the field and making the appropriate selection from the drop down list.
 
'''Year''' - Defaults to the current year. A prior year may be accessed by clicking in the field and making the appropriate selection from the drop down list.
  
−
'''District''' - Default value is based on your security settings. You will be limited to your district only.
+
'''District''' - Default value is based on the user's security settings. It will be limited to their district only.
 +
 
 +
'''School''' - Default value is based on the user's security settings. If the user is assigned to a school, the school default value will be their school site code.
 +
 
 +
'''Grade''' -  Leave blank or select all to include all grade levels.  Otherwise, choose the desired grade.
 +
 
 +
'''Transcript Year''' - Click to select a specific transcript year.
 +
 
 +
'''Students''' - Click to select specific students. It is sorted alphabetically.
 +
 
 +
'''Homeroom''' - Leave blank or select all to include all homerooms.  Otherwise, choose the desired homeroom.
 +
 
 +
'''Course Name''' - Click to select specific courses.
 +
 
 +
'''Active Only''' - This choice will list only those students who are actively enrolled as of the date selected in the date field.
 +
 
 +
'''As of Date''' - This choice will list only those students who are actively enrolled as of the date selected in the date field.
 +
 
 +
'''Order By''' - Select the way in which the report is to be displayed. 
 +
 
 +
'''Special Ed'''
 +
*'''All''' - Select to view all students.
 +
*'''Sped Only''' - Select to view only Sped students.
 +
*'''Non Sped''' - Select to view only non Sped students.
 +
 
 +
'''504'''
 +
*'''All''' - Select to view all students.
 +
*'''504 Only''' - Select to view only 504 students.
 +
*'''Non 504''' - Select to view only non 504 students.
 +
 
 +
'''LEP'''
 +
*'''All''' - Select to view all students.
 +
*'''LEP Only''' - Select to view only LEP students.
 +
*'''Non LEP''' - Select to view only non LEP students.
 +
 
 +
'''OK''' - Click to continue
 +
 
 +
If you need instructions for setup values to be used, follow the link for [[Standard Setup Options]].
 +
 
 +
==Main==
 +
 
 +
[[File:exporttranscriptmain.png]]
 +
 
 +
===Column Headers===
 +
 
 +
'''Student Name''' - Student Name
 +
 
 +
'''SIDNO''' - Student ID Number
 +
 
 +
'''Grade''' - Student Grade
 +
 
 +
'''Year''' - Year the course was taken
 +
 
 +
'''Cohort Year''' - Projected year the student is grouped with to graduate
 +
 
 +
'''Course''' - Name of the course
 +
 
 +
'''Teacher''' - Teacher name
 +
 
 +
'''S1N''' - Semester 1 Numeric Grade
 +
 
 +
'''S1A''' - Semester 1 Alpha Grade
 +
 
 +
'''R1''' - Replaced Course --Indicates that the grade record is to be replaced by a second instance of the course.
 +
 
 +
'''S2N''' - Semester 2 Numeric Grade
 +
 
 +
'''S2A''' - Semester 2 Alpha Grade
 +
 
 +
'''R2''' - Replaced Course --Indicates that the grade record is to be replaced by a second instance of the course.
 +
 
 +
'''F1N''' - Final 1 Numeric Grade
 +
 
 +
'''F1A''' - Final 1 Alpha Grade
 +
 
 +
'''R3''' - Replace Course --Indicates that the grade record is to be replaced by a second instance of the course.
 +
 
 +
'''Credits Pursued''' - Carnegie Unit credit pursued
 +
 
 +
'''Credits Earned''' - Carnegie Unit credit earned
 +
 
 +
'''State Code''' - State code
 +
 
 +
'''Grade Source''' - The 6 digit state site code and site name where student earned the grade.
 +
 
 +
'''Site Code''' - Site code
 +
 
 +
'''Honors''' - Honor codes for this course.
 +
 
 +
To find definitions of commonly used column headers, follow this link: [[Common Column Headers]].
 +
 
 +
==Bottom==
 +
 
 +
[[File:comdelbottom.png]]
  
−
'''School''' - Default value is based on your security settings. If you are assigned to a school, the school default value will be your school site code. You will not be able to change this value. If you are a supervisor or other district office employee with access to the Student Information System, you will be able to run programs for one school, a small group of schools, or all schools in your district.
+
'''Setup''' - Click to go back to the Setup box.
  
−
'''Grade''' - Grade level of students whose records need to be edited or whose names are to be included on a report. Leave the field blank if all grade levels are to be included. Otherwise, click in the field to the right of Grade(s) to select the desired grade level(s) to be included.
+
'''Export''' - Click to export the report. Right click the preview and select '''Save As'''. Navigate to the location where you want to save these files. There will be a file name in the popup.
 +
 +
'''Help''' - Click to view written instructions and/or videos.

Latest revision as of 09:39, 31 July 2023

This program provides the user a way to export courses with grades in a Comma Delimited formatted file. Be sure that a Grades Closeout EOY has previously been done for current year courses.

Menu Location

Transcripts > Interfaces > Export Transcript Comma Delimited

Setup Options

Exptransset.png

Year - Defaults to the current year. A prior year may be accessed by clicking in the field and making the appropriate selection from the drop down list.

District - Default value is based on the user's security settings. It will be limited to their district only.

School - Default value is based on the user's security settings. If the user is assigned to a school, the school default value will be their school site code.

Grade - Leave blank or select all to include all grade levels. Otherwise, choose the desired grade.

Transcript Year - Click to select a specific transcript year.

Students - Click to select specific students. It is sorted alphabetically.

Homeroom - Leave blank or select all to include all homerooms. Otherwise, choose the desired homeroom.

Course Name - Click to select specific courses.

Active Only - This choice will list only those students who are actively enrolled as of the date selected in the date field.

As of Date - This choice will list only those students who are actively enrolled as of the date selected in the date field.

Order By - Select the way in which the report is to be displayed.

Special Ed

  • All - Select to view all students.
  • Sped Only - Select to view only Sped students.
  • Non Sped - Select to view only non Sped students.

504

  • All - Select to view all students.
  • 504 Only - Select to view only 504 students.
  • Non 504 - Select to view only non 504 students.

LEP

  • All - Select to view all students.
  • LEP Only - Select to view only LEP students.
  • Non LEP - Select to view only non LEP students.

OK - Click to continue

If you need instructions for setup values to be used, follow the link for Standard Setup Options.

Main

Exporttranscriptmain.png

Column Headers

Student Name - Student Name

SIDNO - Student ID Number

Grade - Student Grade

Year - Year the course was taken

Cohort Year - Projected year the student is grouped with to graduate

Course - Name of the course

Teacher - Teacher name

S1N - Semester 1 Numeric Grade

S1A - Semester 1 Alpha Grade

R1 - Replaced Course --Indicates that the grade record is to be replaced by a second instance of the course.

S2N - Semester 2 Numeric Grade

S2A - Semester 2 Alpha Grade

R2 - Replaced Course --Indicates that the grade record is to be replaced by a second instance of the course.

F1N - Final 1 Numeric Grade

F1A - Final 1 Alpha Grade

R3 - Replace Course --Indicates that the grade record is to be replaced by a second instance of the course.

Credits Pursued - Carnegie Unit credit pursued

Credits Earned - Carnegie Unit credit earned

State Code - State code

Grade Source - The 6 digit state site code and site name where student earned the grade.

Site Code - Site code

Honors - Honor codes for this course.

To find definitions of commonly used column headers, follow this link: Common Column Headers.

Bottom

Comdelbottom.png

Setup - Click to go back to the Setup box.

Export - Click to export the report. Right click the preview and select Save As. Navigate to the location where you want to save these files. There will be a file name in the popup.

Help - Click to view written instructions and/or videos.

Retrieved from EDgear Wiki