Docstoc

Teacher Spreadsheets

Document Sample
Teacher Spreadsheets Powered By Docstoc
					RICHLAND SCHOOL DISTRICT ONE
      STANDARDS-BASED
ELEMENTARY REPORTING SYSTEM
       TEACHER’S MANUAL
                               Revised July 2004




          Standards-
          Standards-based Reporting System

                  Standards-based              Standards-based
                    Assignment               Standards-based
                                                 Assessments
                                               Assessments




        Standards-based                               Standards-based
           Instruction                                  Gradebooks




       Standards-based                                     Standards-based
          Planning                                           Report Card



                 South Carolina Curriculum Standards




       Dr. Ronald L. Epps, Superintendent




                                                                             1
               Richland School District One

ELEMENTARY REPORT CARD COMMITTEE

              Helen S. Jones, Area Superintendent
                         Chairperson
               Deborah Bishop, Teacher – JP Thomas
                    Mary Bostic, Area Specialist
                Christel Clark, Teacher – Mill Creek
               Angela Cooper, Teacher – E.E. Taylor
                   Linda Coulter, Area Specialist
                Patsy Dolder, Technology Specialist
         Elizabeth Eason, Director Curriculum & Standards
              Ida Fortuna, Teacher – Lewis Greenview
                Kathy Garrick, Parent – Meadowfield
     Verna Green, Consultant – State Department of Education
               Diane James, Principal – Carver-Lyon
         Chovan Jennings, Academic Intervention Specialist
               Courtney Johnson, Research Specialist
               Loraine Lambert, Teacher – AC Moore
               Thomas Marshall, Parent – Pine Grove
                   Lisa McClain, Area Specialist
     LeAnne McLemore, Instructional Technology Technician
            Richard Moniuszko, Deputy Superintendent
                   Evelyn Moore, Area Specialist
Jon Ostendorf, Executive Director Information Resource Management
                 Marsha Plummer, Teacher – Sandel
     Lane Quinn, Vice Chair, Board of School Commissioners
            Ginger Riddle, Early Childhood Coordinator
           Andrenna Smith, Principal – South Kilbourne
                   Fae Young, Principal - Sandel




                                                                2
                              INTRODUCTION
The Richland School District One Standard-based Elementary Reporting System
is a comprehensive record keeping and reporting system. It is designed to
assist teachers in keeping records of student progress toward mastery of
curriculum standards and to report the progress toward meeting grade level
standards to parents. Student progress is recorded and reported using
performance level indicators for each content strand.

The standards-based gradebook and the standards-based report card are the
final components necessary to complete the Richland District One Standards-
based Elementary Reporting System which is comprised of:
                         Standards-based planning
                         Standards-based instruction
                         Standards-based assignments
                         Standards-based assessments
                         Standards-based gradebooks
                         Standards-based report cards

The Richland County School District One Elementary Reporting System utilizes
two software programs, Integrade Pro and ReportWizard. These systems are
linked to provide teachers with an electronic gradebook for maintaining records of
student progress toward mastery of grade level standards and a computer
generated report card which gives parents clear, concise information that is also
standards based.




                                                                                3
INSTRUCTIONS FOR
  CORE SUBJECT
    TEACHERS
                      GRADES 1-5




      Standards-
      Standards-based Reporting System

              Standards-based         Standards-based
                Assignment          Standards-based
                                        Assessments
                                      Assessments




    Standards-based                          Standards-based
       Instruction                             Gradebooks




   Standards-based                                Standards-based
      Planning                                      Report Card



             South Carolina Curriculum Standards




                                                                    4
                                           TABLE OF CONTENTS

Part 1- Setting Up the Gradebook...................................................................... 6
Login ..................................................................................................................... 7
Creating a Gradebook........................................................................................... 7
Importing Class Rosters........................................................................................ 8
Setting Your Password ......................................................................................... 9
Attaching Type Sets to a Class ............................................................................. 9
Importing the ReportWizard Templates .............................................................. 10
Importing Teacher Spreadsheets........................................................................ 14
Verifying Classes and Type Set ........................................................................ 16
Verifying the Number of Spreadsheets... .....................……………………………17
Deleting Duplicate ReportWizard Templates ...................................................... 19
Verifying ReportWizard Import Into Classes ....................................................... 20
Correcting the ReportWizard Import ................................................................... 21
Verifying Integrade Pro Setup ............................................................................. 24

Part 2 – Using the Electronic Gradebook (Integrade Pro) ............................. 25
Opening Your Gradebook ................................................................................... 26
Classes and Spreadsheet Overview ................................................................... 27
Creating New Tasks............................................................................................ 28
Weighting An Assignment ................................................................................... 29
Entering Scores .................................................................................................. 30
Creating New Spreadsheet ................................................................................. 31
Copying Tasks .................................................................................................... 32
Standards-based Tasks ...................................................................................... 33
Examples of Task Types and Tasks .................................................................. 33

Part 3 – Preparing the Standards-based Report Card ................................... 36
Printing Type View Spreadsheets ....................................................................... 37
Copying Grades to the EndTerm Spreadsheet ................................................... 38
Entering Comments ............................................................................................ 40
Instructional Level ............................................................................................... 41
Performance Level.............................................................................................. 42
Effort ................................................................................................................... 43
Exporting Grades to the Office............................................................................ 44
Verifying Report Card Grades............................................................................. 44
Preparing Report Cards – Final Marking Period ................................................. 45

Instructions for Related Arts Teachers........................................................... 46
Appendix ........................................................................................................... 75
Making the Transition.......................................................................................... 76
Teacher Tasks for Each Marking Period............................................................. 77
Performance Level Indicators ............................................................................. 78
English Language Arts Strands........................................................................... 81
Interim Reports (Options 1,2).............................................................................. 82
Sample Report Cards ....................................................................................90-91
Report Card Comments ...................................................................................... 92

                                                                                                                           5
                             Part I

          SETTING UP THE GRADEBOOK

 CORE SUBJECT TEACHERS (GRADES 1-5)
The setup of the electronic gradebook, Integrade Pro, is a process
that helps teachers organize for standards-based recordkeeping. The
Richland School District One Standards-based Elementary Reporting
System includes a procedure that links the record keeping of
standards-based teacher assessments to the standards-based report
card.

Integrade Pro setup is done at the beginning of each new school
year. Once setup is complete, teachers do not repeat any of the
steps included in Part I unless changes occur in scheduling.

Teacher assignments and student schedules should be finalized
before gradebooks are created. Teachers will be notified when the
gradebook setup process can begin.




                                                                    6
                                           Login
Login as a Novell client. You will need to know your Novell password to
complete this process. Once you have successfully logged in, write the
password down for future reference.




NOTE: We will continue to use the 2004 Elementary Templates.


                                Creating a Gradebook
Teachers must create a new gradebook at the beginning of each school year.
This process is done only at the beginning of the year. Follow the step by step
instructions exactly as they are given. Your gradebook will be accessible from
your classroom computer.

   1.   Login to the Novell network using your Novell user name and password.

   2.   Enter IGPro by clicking on the igpro32.exe icon on your desktop.

   3.   Select Open a gradebook on your computer. Click OK.

   4.   Click on the arrow in the drop-down menu beside the words Look in:

   5.   Select NCSAPPS on (Your School’s Name) \Vol 1 (H:).

   6.   Double click IGPDATA.

   7.   Double click 2004 Elementary Template. (Note: the 2004 Elementary Templates will
        continue to be used).

   8.   Double click Default. A blank gradebook will open.




                                                                                           7
                            Importing Class Rosters
Class rosters and teacher schedules should be updated by the database
specialist before importing classes into the gradebook.

Teachers should never add or delete a student’s name in a gradebook.
Manually adding or deleting students breaks the link between your
gradebook and SASI which will cause your grades not to print. Once the
link is broken, the gradebook is corrupt and you will need to create a new
one.



   1.   On the menu bar, click on File.

   2. Select Import into gradebook. Click on Next.

   3. Click on the arrow in the drop-down menu beside the words Look in:

   4. Click on Ncsapps on (Your School Name)\Vol 1 (H:)

   5. Double click on IGPDATA.

   6. Double click on the folder that shows the School #.

   7. Double click folder that has your SASI Teacher #.

   8. Double click on the Clxxx.grd file (xxx is your teacher number).

   9. On the screen that appears, verify your name and SASI #.

   10. Click on Import. Your classes and students will import into your gradebook.

   11. Click on the arrow in the drop-down menu beside the word Class and verify the import of
       all classes that are currently assigned to you.

   12. On the File menu, click Save as.

   13. Type your first initial, last name, 2004. Do not use spaces.
          (Example: dsmith2004)

   14. Click Save.
                                                   DO NOT ADD or DELETE STUDENTS!
   15. Alphabetize each class roster:              All class roster changes must be done by
       Select the desired class.                   the database specialist.
       Right click on any student’s name.
       Select sort students by column.
       Repeat this process for each assigned class.

   16. Click on File, select Save Gradebook.




                                                                                              8
                               Setting Your Password
     1. On the menu bar, click on Setup.

     2. Select Password.

     3. Type the password you will use for your gradebook.
        Record your password and submit to the designated school personnel. Keep your
        password secure. It is very important that you memorize your password and also have it
        written down so that it can be easily retrieved. If you forget this password, your
        gradebook and all data will be lost. You will have to create a new gradebook.

     4. Click on Next.

     5. Type your password again to confirm it. Click on Next.

     6. Click on OK.

                         Attaching Type Sets To A Class
This process links the type set (subject) and the task types (strand) to each
class.
(Example: the ELA strands must be attached to the ELA class).
                                                                                      This is a critical step
1.    From the menu click on Setup.                                                   to ensure that
                                                                                      averages for each
                                                                                      strand are
2.    Select Classes.                                                                 computed
                                                                                              accurately
3.    When the window opens, click on the desired class from the list on the left.

4.   Click the arrow on the drop-down menu beside the words Task Type Set.

5.   Select the type set name that matches the class name.

6.   Repeat steps 3-5 for each class to ensure that grades are assigned to the proper category.
     It is not necessary to select a Current Grade Spreadsheet or Show Advanced Fields.

7. Click Close.




                                                                 Task Type Set
                                                                  matches the
                                                                  class name.




                                                                                                   9
                Importing The ReportWizard Templates

 The ReportWizard Templates are used to hold the instructional level,
 performance level indicators, and effort marks.

 Effort marks are given by the homeroom teacher only. Homeroom
 teachers should import the Effort ReportWizard Template into the
 homeroom class only.

 Teachers who teach English/Language Arts, mathematics, science, social
 studies or health should import the appropriate templates. Related arts teachers
 who teach a core subject will need to import ReportWizard templates for the core
 subject that they teach.

 Import ReportWizard Templates for each class you teach. If you teach more than
 one class of the same subject, the templates must be imported into each class.
 This process must be checked by another teacher to reduce the risk of errors
 when report cards are printed.


                              ATTENTION TEACHERS
                           PLEASE WORK CAREFULLY!!
The quality of your work during the ReportWizard import process will determine the
                         appearance of your report cards.
 Each ReportWizard Template that you import represents a set of grids on your report
 cards.

If you import the wrong templates into a class, the format of your report cards will be
wrong. (Example: math templates imported into the science class will format as math
strands in the science class.)

If you import two sets of ReportWizard templates into the same class, you will have two
sets of strands listed under the subject on your report cards.

If you have more than the five required ReportWizard template reporting periods in a
class, they will format as extra reporting periods on your report cards.

If you delete one of the necessary ReportWizard template reporting periods, you will
have too few grids on your report cards.

Report card formatting errors are usually corrected in the teacher’s gradebook whose
name appears beside the subject.

Work slowly, deliberately, and accurately as you import your ReportWizard templates.
You will be glad you did!




                                                                                10
1. In IGPro, click on Tasks on the menu bar. Select Import Tasks.

2. If prompted, click on Save Gradebook Now.

3. Click Next.

4. To find the Elementary folder in the IGPDATA folder:
   Click on the arrow in the drop-down menu beside the words Look in:
   Click on IGPData
   Double click on 2004 Elementary Template.

5. Double click on the ReportWizard Template.gbf for the desired class.
   (Example: ELA)




6. Click on Spreadsheets.




7. Click on Next.
                                                                          11
8. Click on All.




9. Click on the arrow in the drop-down menu beside the words To Class.

10. Select the class that will receive the ReportWizard spreadsheets.

11.            The From class and the To class should be the same.
                     ( Exception: FROM: Effort      TO: Homeroom )




12. Click on Import.

13. When you are notified the Import is complete, click on OK.

14. Repeat steps 1-13 for each class that you teach.




                                                                         12
When importing the templates for each
core subject, be sure the FROM class and
the TO class are the same.

Exception - FROM: Effort   TO: Homeroom




                                           13
                        Importing Teacher Spreadsheets
Teacher spreadsheets are used to hold the grades for daily assignments.
Import a set of teacher spreadsheets (1st nine weeks, 2nd nine weeks, 3rd nine
weeks, 4th nine weeks, teacher final) from the sample class to each class you
teach.
This will eliminate the need to create new teacher spreadsheets for each marking
period.

   1. From the menu bar, select Tasks.

   2. Click on Import Tasks.

   3. Click on Next.

   4. Click on the arrow in the drop-down menu beside the words Look in:

   5. Double click on Igpdata.

   6. Double click on 2004 Elementary Template.

   7. Double click on Teachers Spreadsheets.

   8. Select Spreadsheets. Click on Next.

   9. Select All.

   10. Click on the arrow in the drop-down menu beside the words To Class.

   11. Select the core subject to receive the teacher spreadsheets.

   12. Select Import. Click on OK.

   13. Repeat steps 1-12 for each class that you teach.

   14. Click on file.

   15. Select Save gradebook.




                                                                             Import a set of
                                                                                 teacher
                                                                              spreadsheets
                                                                                   into
                                                                               each class.




                                                                                  14
You Did It!
  You have completed the
  setup of your gradebook.



The remaining pages in Part 1 will help you to
 check the accuracy of your setup process.




                 Remember:
  The format of your report cards is greatly
 determined by the setup of your gradebook.




                                                 15
                           VERIFYING CLASS/TYPE SET

You can check to be sure that the type set is actually attached to the appropriate
class while viewing the IG Pro spreadsheet.


    1.   Click the arrow on the drop-down menu beside the word Class.

    2.   Select the desired class.

    3.   Select the Weighted Type (Numeric Weighted Type ) spreadsheet.

    4.   Click the arrow on the drop-down menu next to the word Show.

    5.   Select Tasks/Students.

    6.   Click the arrow on the drop-down menu next to the word View.

    7.   Select Type View.

    8.   The type names (strands) are shown at the top of the spreadsheet.

    9.   Verify that the type names (strands) shown actually belong with that class.

    10. Click the arrow on the drop-down menu beside the word Class to select the next class
.
    11. Verify the type names (strands) for each class you teach.
        If a class is not attached properly, refer to the instructions on page 4.

    12. Click the arrow on the drop-down menu beside the word View again to return to the
        Task View.

           Note: New tasks can be added only when you are in the task view.




                               Language Arts
                                  task names
                                match the class
                                    name.


                                                                                            16
                    Verifying The Number Of Spreadsheets


Each class must contain the following spreadsheets:
      Five EndTerm Spreadsheets (first, second, third, fourth and final quarters)
      Five Teacher Spreadsheets ( 1st, 2nd, 3rd, 4th and final nine weeks)
      Five ReportWizard Templates (Reporting period 1,2,3,4 and final)
      Each class will also contain two default spreadsheets: Weighted type and
      Skill.




                   Verifying Sets of Spreadsheets In Each Class

   1.   Click the arrow in the drop-down menu beside the word Class:

   2.   Select the first class listed.

   3.   View the spreadsheets for that class by clicking on the arrow on the drop-down menu
        beside the word Spreadsheet. Check to be sure there is a set of Endterm
        spreadsheets, teacher spreadsheets, and ReportWizard templates.

   4.   Click the arrow in the drop-down menu beside the word Class to select the next class.

   5.   Verify the import of spreadsheets for each class you teach.
        Each class should have sets of spreadsheets as shown below.
        The order of the sets of spreadsheets does not matter.




                                                                                                17
6.   If teacher spreadsheets are missing, follow the directions for importing given on page 9.

7.   If the ReportWizard Template Reporting Period spreadsheets are missing, follow the
     instructions for importing ReportWizard templates given on pages 5-8.

8.   If EndTerm spreadsheets are missing, your schedule must be verified with the database
     specialist. Your roster for that class must be imported again using the steps given on
     page 3.

9.   If you have more than the required number of ReportWizard templates, you must delete
     the duplicates using the directions given on page 14.




                                                                  Duplicate ReportWizard
                                                                  Template Spreadsheets




                                                                                            18
                  Deleting Duplicate ReportWizard Templates

1.         Click on the arrow in the drop-down menu beside the word Class.
             Select the class that contains the duplicate spreadsheets.

2. On the menu bar, click on Setup.

3.         Select Spreadsheets. You may need to scroll down to see all spreadsheets.

4. The duplicate ReportWizard Template Reporting Period will have two numbers after it.
   The second number will be a 2 (or a 3 or 4 if you have three or four copies of the Report
   Wizard template for each class).

          The duplicate ReportWizard Template Final will be listed last in a set of templates but
          may have only one number following it.




                                                             Delete all duplicate
                                                            Report Wizard
                                                            Template Spreadsheets




     5.        Click on the first ReportWizard Template Reporting Period that has two numbers.
          ( For example, ReportWizard Template Reporting Period 1 2. )

 6.          Since the complete name cannot be seen in the drop-down menu, verify that you are
            deleting the correct ReportWizard by checking the description that appears
          after the word Name:                     DO NOT CHEAT ON THIS STEP.

7. Click on the Delete button. Click Yes.

8. The next duplicate spreadsheet will be highlighted. Verify that the description appearing
   in the Name box is the ReportWizard Template you wish to delete. Click on Delete.
   Click Yes. Do this for each ReportWizard Template Reporting Period that is
   duplicated.

9. Use the same process to delete extra teacher spreadsheets. This process can be used
          to delete any spreadsheets that you create in error.

                                                                                                    19
               Verifying ReportWizard Import into Classes
The ReportWizard templates must be imported into the correct class. The
format of the report card is determined by the import of ReportWizard templates.
Incorrect import will result in incorrect report card format.

   1.   Click on the arrow in the drop-down menu beside the word Class.

   2. Select the desired Class.

   3. Click on the arrow in the drop-down menu beside the word Spreadsheets.
        Select the first ReportWizard spreadsheet listed for that class. The spreadsheet will
        open.

   4. Click on the arrow in the drop-down menu beside the word Show.
        Select Tasks/Students.

   5. If the ReportWizard spreadsheets were imported correctly, the appropriate task names
      (strands) for the selected class will appear above the student roster.

   6. Click on the drop-down menu beside the word Spreadsheet. You be able to see all
      spreadsheets and you will have a partial view of the task names (strands).

   7. Use the down arrow          on your keyboard to select ReportWizard Periods 2, 3, 4, and
      final. Verify that the partially visible task names (strands) associated with each period
      are appropriate for the class.

   8. Click on the arrow in the drop-down menu beside the word Class to select the next class.
      Check the ReportWizard import for each class.




                                  Appropriate Task Names
                                  for the selected class




If the wrong task names appear, the ReportWizard spreadsheets were not
imported correctly.
Use the steps given on the next page to correct the ReportWizard import.

                                                                                                20
                    Correcting The ReportWizard Import
If the correct ReportWizard Templates were not imported into each class, the
report cards will format incorrectly.




                                                          Inappropriate Task Names for the
                                                                    selected class.
                                                           (Science class with Mathematics
                                                                task names or strands.)


   Step 1- Delete All ReportWizard Templates from the Class
   1.   Click on the arrow in the drop-down menu beside the word Class.
          Select the class that contains the incorrect spreadsheets. (example: Science)
   2.   On the menu bar, click on Setup.
   3. Select Spreadsheets. You may need to scroll down to see all spreadsheets.
   4. Click on the first ReportWizard Reporting Template.
   5. Click on the Delete button at the located at the bottom of the list of spreadsheets.
   6. Repeat the process to delete each ReportWizard Template in the list of
        spreadsheets.




                                                  Delete all
                                                  ReportWizard
                                                  templates for the
                                                  selected class.




                                                                                             21
Step 2 –Delete the Incorrect Type

   1. On the menu bar, click on Setup.

   2. Select Grading Rules.

   3. Select Type Sets.

   4. When the window opens, scroll down to the bottom of the list on the left until you see
      class names. (English/Language Arts, Mathematics, Science, Social Studies, Health)

   5. Click on the zero that corresponds with the class that has the wrong ReportWizard
      templates. ( Example: Click on the zero beside science because it has math
      ReportWizard spreadsheets.)

   6. Using the buttons on the right of the screen, click on Delete Type.

   7. Click on Yes.

   8. Click on Close.

   9. Follow the directions on pages 5-8 to import the correct ReportWizard templates
      into the class.




                             Click on the “0” beside the
                            class that has inappropriate
                                 ReportWizard templates.

                                       Select “Delete
                        T      ”



                                                                                               22
10. When you have verified and made the necessary corrections for each class, save the
     gradebook. Click on File, Save Gradebook.

 11. Have your gradebook setup verified using the form on page 19.


12. To close the gradebook, click on File, Close Gradebook. When asked if you want to
    Save Gradebook, click on Yes. A blank screen appears. Click on the X in the top right-
    hand corner to close IGPro.




      The gradebook has been created for the entire school year.
                    Always save your gradebook.
     Frequently save your work when working in your gradebook.




                                                                                         23
                VERIFICATION OF INTEGRADE PRO SETUP
   A gradebook that has been carefully set up and is accurately maintained
   throughout the marking period will contribute to a stress free end of marking
   period experience. Use this verification form to ensure that no teacher errors
   will be encountered when your report cards are printed. Have a minimum of two
   colleagues verify the accuracy of your setup process by initialing in the space
   provided.

   Teacher’ s Name__________________________________               Grade ________


                                                                 Teacher 1           Teacher 2

                                                               List each class &    List each class &
                                                               initial to verify.   initial to verify.
Are the type sets attached to the correct class? (Page 4,11)
You must check each class.
    Click on:
      Setup
      Classes
      General




                                                                                        24
                                                                         List each class &    List each class &
                                                                         initial to verify.   initial to verify.
Does each class have the correct number of
spreadsheets?(Pages 12, 13)
You must check each class.
5 EndTerm
5 ReportWizard Template
5 Teacher spreadsheets
     Click on:
      Setup
      Spreadsheets
      Select each class from the drop-down menu


Are the correct Report Wizard Templates imported into                    List each class &    List each class &
                                                                         initial to verify    initial to verify
each class? (Pages 15-18)
You must check each ReportWizard template in each class.
      In the drop-down menu beside Show select Task/Students
      In the drop- down menu beside Class select each class
      In the drop-down menu beside Spreadsheet select ReportWizard
      Period 1.
       Are the correct tasks listed above the students’ names?

      Use the down arrow         on your keyboard to select and verify
      Periods 2,3, 4, and Final.




                                            Part 2

    USING THE ELECTRONIC GRADEBOOK

           CORE SUBJECT TEACHERS (Grades 1-5)
   In a standards-based system, assignments are linked directly to the standards.
   In the Richland School District One Standards-based Elementary Reporting
   System, task types are used to group assignments by strand. A numeric
   average can then be calculated for each strand. This facilitates the process of
   reporting student progress toward meeting standards.

   Student averages are kept current throughout the quarter and a record of
   progress is always available. At the end of the report period, grades are
   automatically calculated and easily transferred to the report card.
                                                                                                  25
The steps included in this part of the manual are used by teachers for their daily
record keeping. A spreadsheet is constructed to hold the grades for each
subject for an entire quarter. Assignments (tasks) and student grades are
entered periodically.




                                                                                 26
                           Opening Your Gradebook
The following instructions will enable you to access a gradebook you have
previously created in IGPro.


   1. Login into the Novell network using your Novell user name and password.

   2. Enter IGPro by clicking on the IGPro icon on your desktop.

   3. Select Open a gradebook on your computer. Click OK.

   4. Click on your gradebook.

        If it is not listed in the Open screen, click on the drop-down arrow at the end of
        the Look in box. Find the IGPData folder. Double-click on your school
         number folder. Double-click on your teacher number folder. Double-click on
         your gradebook (Ex. Pdolder.gbf).


        Open


    Teacher
    gradebook




   5. Enter your password and click OK.

      A message appears that “Auto-update from administration system complete”. This
      updates your class roster from SASIxp. Click OK.




                             Your Gradebook is opened!


                                 SAVE AS YOU WORK!




                                                                                             27
                  Classes and Spreadsheets Overview
Classes are exported by your database specialist from SASIxp into IGPro and
are updated periodically. You should never add, delete, or edit a student’s name
in your gradebook. Advise your data base specialist of any changes that must
be made. New students will appear at the bottom of the class list.

All of your classes should be included in the Class list. Click on the drop-down
menu beside the word class to view your complete class list. Each class will
contain several spreadsheets. Teachers will create tasks for each teacher
spreadsheet. Tasks are those assignments for which students receive grades.

Your gradebook has been set up with EndTerm spreadsheets, ReportWizard
templates and teacher spreadsheets for each class.
      The EndTerm spreadsheet will hold the FINAL grades for that grading
      period.
      The ReportWizard template will hold the instructional level, the performance
      level, and the effort marks for that reporting period.
      The teacher spreadsheets are labeled for each nine week period. These
      are used to hold the marks for daily assignments that will be counted as
      part of the quarterly grade.

Your gradebook opens to a randomly selected class spreadsheet. You will need
to select the desired class and the desired spreadsheet before entering any data.

   1. To find a specific class, click the arrow in the drop-down menu beside the word
      Class.




   2. To find a specific spreadsheet for that class, click the arrow in the drop-down
      menu beside the word Spreadsheet.



   3. Change the Show window to Tasks/Students.



                                 You should never add,
                                 delete, or edit a student’s
                                 name in your gradebook.




                                                                                        28
                            Creating New Tasks
A task is any assignment for which you want to record a grade. Tasks are
entered on the teacher spreadsheets that are labeled for each nine week
period. (Example: 1st nine weeks)

 A task type is the category or strand. It is very important to link each task
to a task type. This will facilitate the process of determining performance
levels for each strand.

1. Select the desired CLASS. (Example: English Language Arts)

2. Select the desired SPREADSHEET. (Example: 1st nine weeks)

3. Click the arrow in the drop-down menu beside the word View.

4. Select Task View.

5. From the Menu bar, click on Tasks, New Task.

6. Click on Next.

7. Enter the name of the task. (Example: Main Idea quiz)
     The date assigned and due date are optional.

8. Click on the arrow in the drop-down menu beside the word Type.

9. Select the appropriate strand or category. (Example:Reading)

10. Enter 100 in the Out of (Raw) box, 1.0 in the Scale Factor box, and 100 in the Out of
    Scale box. It is not necessary to fill in the Maximum Allowed Score box.

11. Click on Create. Grades can now be entered for the task. (See page 25)

12. Repeat for each task (assignment) needed for this spreadsheet.

13. Click on File, Save gradebook.




                                                                                        29
                         Weighting An Assignment

1. Select the desired Class.

2. Select the desired Spreadsheet. (Example: 1st nine week)

3. On the menu bar, click on Tasks.

4. Select New Task.

5. Type in the Task Name for the assignment. Include the different weight as part of the
   task name as a reminder that the calculation for that assignment is different.

6. In the drop-down menu beside the word Type, select the appropriate task type (strand).

7. Type 100 in the Out of (Raw ) box.

8. Type the desired weight in the Scale Factor box. (Example: 2 for double credit or .5 for
   half credit)

9. Click in the Out of (Scaled) box.

10. Click on Create.




                    Correcting The Task Type For An Assignment
1.  Select Tasks.
2. Click on Edit Tasks.
3. Select the task to be edited from the list on the left.
4. Select the Points tab.
5. Select the correct Task Type.
6. Enter 100 in the Out of (Raw) box, 1.0 in the Scale Factor box, and 100 in the Out of
   Scale box. It is not necessary to fill in the Maximum Allowed Score box.
7. Close.




                                                                                           30
                                     Entering Scores

Numeric scores are entered for assignments that are to be included in the
student’s quarterly average. Gradebooks should be updated regularly so that
information regarding student progress is always current and available.

Primary and related arts teachers are not required to report numeric or letter
grades. These teachers may convert the scores on each assignment to
performance levels (1-4) and enter the performance level as the grade. The
performance level will automatically calculate for each category or strand.



   1.   Select the desired CLASS (Example: English Language Arts)

   2.   Select the desired SPREADSHEET (Example: 1st nine weeks)

   3.   Click the arrow in the drop-down menu beside the word View.

   4.   Select Task View.

   5.   Select the student’s name.

   6.   Click in the appropriate task column. (Example: Main idea quiz)

   7.   For grades 3-5, enter the student’s numeric grade (5-100).

   8.   For grades 1,2, and related arts, the performance level indicator (1,2,3,4) are entered as
        the grade.

   9.   The student’s average and the corresponding letter grade will calculate automatically as
        scores are entered.


   10. Click on File, Save gradebook.




                               For grades 1, 2, and related
                               arts, the performance level
                               indicator (1,2,3,4 ) are
                               entered as the grade.




                                                                                                31
                          Creating New Spreadsheets
Additional spreadsheets may be created by the teacher .
       Teachers who have both primary (grades 1,2) and elementary (grades
       3-5) students in the same class must create a different spreadsheet for
       each level.
       Teachers who have several grades in a class may keep a separate
       spreadsheet for each grade.
       A homework spreadsheet can be used to calculate the homework
       average separately in the selected subject.

   1. Select the desired class. (Example: Math)

   2. From the menu bar, click on Setup.

   3. Select Spreadsheets.

   4. Click on New at the bottom left corner of the form. This is a very important step. You
      must select New to create a new spreadsheet. If you type a name on the Name line
      without selecting New, you could rename one of the default spreadsheets, which will
      cause the exporting of grades to fail.

   5. Select Create a Numeric Spreadsheet.

   6. Click on Next.

   7. Name the new spreadsheet.

   8. Click on Next.

   9. Select Total Points.

   10. Click on Create. You may move the spreadsheet to the top of the list by holding down the
       CTRL key while selecting the spreadsheet name and dragging it to the desired location.

   11. Click on Close.

   12. Click on File, Save gradebook.




                                                                                               32
                                    Copying Tasks

If you have more than one class of the same subject, you can copy the tasks
from one spreadsheet to another. The spreadsheet you will copy to must
already be created. Tasks must be copied before any grades are entered,
otherwise, the grades will copy to the new spreadsheet.

   1. You must have the Class and Spreadsheet you wish to copy TO, appearing on your
      screen.

   2. From the Menu bar, click on Tasks, Copy Tasks.

   3. Click on the drop-down list after Class to select the class you are going to copy FROM.

   4. Click on the spreadsheet you will copy FROM.

   5. Click Next.

   6. Select the tasks (assignments) to copy. (Scroll down to see items at the bottom of the
      list.)

   7. Click on Next.

   8. Select Percentage.

   9. Click on Next.

   10. Click on OK.




                                                                                               33
                                 Standards-based Tasks
Tasks are assignments that students are given. All assignments that are used to
determine student progress and assign grades should be standards-based. The
label used to identify assignments in the gradebook should also relate to the
standards. At a glance, the gradebook should reveal some of the standards that
have been taught.

     Traditional Assignment Label                              Standards-Based Label

Chapter 1 Test                                        Place Value Test
Math test                                             Estimation Quiz
Spelling – Unit 1                                     Silent e Pattern
Pgs. 5-7                                              Double consonants
Homework-P.24                                         Symmetry Hmwk -P24
Worksheet 2                                           Electricity Wksheet
SS Project                                            SC Landforms project




                       Examples Of Task Types And Tasks
It is helpful to indicate in the label the strand to which the assignment is linked.
   (Example: R=Reading).

                                  CLASS: English-Language Arts

                  TASK TYPE                                     Examples of TASKS
The category or strand into which each                 Assignments for which students receive
assignment falls.                                     grades.

Reading                                               R-Main Idea
                                                      R-Story Elements Quiz
                                                      R-Synonyms P.28
Writing                                               W-Editing Prac Sheet
                                                      W-VCV spelling Test
                                                      W-Handwriting Sample 1
                                                      W-Capital Letters Worksheet

Communication                                         C-Oral Book Report (Speaking)
                                                      C-Note Taking (Listening)
                                                      C-Compare/Contrast Sounder video
Research                                              Rs-Selecting Key Words
                                                      Rs-Using “Kidspiration”
                                                      Rs-Black History Project




                                                                                                34
                                    CLASS: Mathematics

                  TASK TYPE                                  Examples of TASKS
The category or strand into which each           Assignments for which students receive
assignment falls.                                grades.
Numbers and Operations                           N-Place Value Test
                                                 N-Estimation Quiz
                                                 N-Chap. Review /Rounding
Algebra                                          A-Numeric Patterns
                                                 A-Equations Test
                                                 A-Function Rules/ wkbk p 6
Geometry                                         G-Symmetry (P24)
                                                 G-Two Dimensional Shapes Activity
                                                 G-Geometric Motion
Measurement                                      M-Area textbk p57
                                                 M-Angles Worksheet
                                                 M-Elapsed time
Data Analysis & Probability                      D-Graphs Assignment
                                                 D-Mean, Mode, Median Quiz
                                                 D-Data Collection Project



                                         CLASS: Science

                TASK TYPE                                   Examples of TASKS
    The category or strand into which each       Assignments for which students receive
              assignment falls.                  grades.
.

Concepts                                         C-Machines p 25 (Physical Science)
                                                 C- Food Chains (Life Science)
                                                 C-Planets Project (Earth Science)
Process Skills                                   P- Classifying Plants
                                                 P- Science Fair Project
                                                 P- Making Predictions wkbk p 5



                                   CLASS: Social Studies

                TASK TYPE                                   Examples of TASKS
    The category or strand into which each       Assignments for which students receive
              assignment falls.                  grades.

Content                                          C-SC Indians (History)
                                                 C-City Leaders (Political Science)
                                                 C- Continents (Geography)
Process Skills                                   P-Timeline page 37
                                                 P- Map Skills worksheet P-Historical
                                                 Analysis Project

.




                                                                                          35
                                       CLASS: Health

                 TASK TYPE                                Examples of TASKS
     The category or strand into which each    Assignments for which students receive
               assignment falls.               grades

Content                                        C- Food Groups (Nutritional Choices)
                                               C- Smokeless Tobacco (Alcohol,
                                                         Tobacco, and Other Drugs)
                                               C- Health Agencies (Mental Health)
Application Skills                             A-Predicting Consequences
                                               A-Handling Conflict
                                               A-Making Food Choices




                                                                                        36
                                  Part 3


            PREPARING THE
             REPORT CARD
       CORE SUBJECT TEACHERS (Grades 1-5)
In the Richland School District One Standards-based Elementary Reporting
System, performance level designations are used as indicators of progress
toward mastery of grade level standards. Progress is measured and reported to
parents by strand to provide more detailed information regarding areas of
strength and weakness. Teachers then use this information to plan differentiated
and focused instruction for students based on identified needs.



The Instructional Level, Performance Level marks and Effort marks are recorded
on the Report Wizard Template for each reporting period.




                                                                              37
                      Printing Type View Spreadsheets


The type view allows you to see the average for assignments that are grouped by
categories or strands. Teachers should use this information along with their
professional judgment and their knowledge of each individual student's progress
to assign performance level indicators.

This process will give teachers a hardcopy summary of student performance on
classroom assignments as a reference while entering performance levels on the
ReportWizard spreadsheet.


   1. Select the desired class. (Example: English/Language Arts)

   2. Select the desired spreadsheet. (Example: 1st nine weeks)

   2. Click the arrow in the drop-down menu beside the word VIEW.

   3. Select Type View.

     3. From the menu, select Reports.

    4. Select SPREADSHEET.
        A new window will open.

    5. Select All Students.

    6. Select All Types.

    7. Summary 1 – Select Percentage.

    8. Summary 2 - Select Letter Grade.

    9. Print Score As – Select Percentage.
         It is not necessary to make any selection under Notes.

  10. Click Next.

  11. Click Print.


Print a hardcopy of the TYPE VIEW spreadsheet for each subject or class
you teach.




                                                                            38
              Copying Grades To The Endterm Spreadsheet

                                      GRADES 3,4 and 5
            (1st & 2nd grade teachers go to page 34 “ENTERING COMMENTS”)

You will copy numeric and alpha Core Subject grades FROM a class and
spreadsheet in your gradebook TO the current EndTerm spreadsheet for the
same class.
(Example: You will copy ELA grades from your gradebook spreadsheet to the ELA EndTerm spreadsheet.)

Copying Numeric Grades

    1.   Select the desired Class. This is the class you will copy TO. (Ex: LANG ARTS)

    2.   Select the Quarter EndTerm spreadsheet you will copy TO. (Ex: First Quarter
         EndTerm)

    3.   From the Menu bar, click on Tasks.

    4.   Select Copy Tasks.

    5.   Using the drop-down menu, select the class you are copying FROM: (Example: LANG
         ARTS) Select the gradebook spreadsheet you are copying FROM: (Example: 1st
         Nine Weeks)

    6.   Click Next.

    7.   Select the item to copy by clicking on the spreadsheet name. (Example: 1st Nine
         Weeks). This should be the same spreadsheet that was selected in # 5.

    8.   Click Next.

    9.   Select the 1st, 2nd, 3rd, 4th, or final quarter numeric grade. (Example: 1st QtrN Grade)

    10. Click Next.

    11. Select Percentage.

    12. Click Next.

    13. Check the Hot Link Grades box.

    14. Click OK.
    If you receive a message that some scores are invalid, it indicates that a grade is missing for
    a     student. Go back to the gradebook spreadsheet selected in #5 and enter the missing
    grades. You must redo the entire copy grade process beginning with # 1.

              Perform the above steps for each of the core subjects.
                                      English/Language Arts
                                             Science
                                              Health
                                               Math
                                          Social Studies




                                                                                                    39
Copying Alpha Grades

   1.   Select the desired Class. This is the class you will copy TO. (Example: LANG ARTS)

   2.   Select the Quarter EndTerm spreadsheet you will copy TO. (Example: First Quarter
        EndTerm)

   3.   From the Menu bar, click on Tasks.

   4.   Select Copy Tasks.

   5.   Using the drop-down menu, select the class you are copying FROM: (Ex: LANG ARTS)
        Select the gradebook spreadsheet you are copying FROM: (Example: 1st Nine
        Weeks)

   6.   Click Next.

   7.   Select the item to copy by clicking on the spreadsheet name. (Example: 1st Nine
        Weeks) This should be the same spreadsheet that was selected in # 5.

   8.   Click Next.

   9.   Select the 1st, 2nd, 3rd, 4th, or final quarter alpha grade. ( Example:1st QtrA Grade)

   10. Click Next.

   11. Select Letter Grade.

   12. Click Next.

   13. Check the Hot Link Grades box.

   14. Click OK.

   If you receive a message that some scores are invalid, it indicates that a grade is missing for
   a     student. Go back to the gradebook spreadsheet selected in #5 and enter the missing
   grades. You must redo the entire copy grade process beginning with # 1.

             Perform the above steps for each of the core subjects.
                                              English/Language Arts
                                                  Science
                                                  Health
                                                 Math
                                       Social Studies




                                                                                                 40
                                 Entering Comments

You may enter a maximum of two comments per subject for each student. Once
you have entered the comments, you are finished with this spreadsheet.
DO NOT FILL IN ANY OTHER COLUMNS.
   1.   Select the desired class. (Example: Social Studies)

   2.   Select the “EndTerm” spreadsheet for the current marking period. (Example: First
        Quarter EndTerm). If the grades were previously copied to the EndTerm spreadsheet,
        the grade will appear in the appropriate column.

   3.   Select the desired student.

   4.   Right-click in the cell below the first Comment column to see the comment list.

   5.   Click on the desired comment.

   6.   If you want to make a second comment for a student, click in the second comment
        column, then select the comment.

   7.   If you know the comment number, you can key it in.

   8.   Click File, Save gradebook.

        You can use the Fill Column command to key in the same comment for all students.


Fill Column Directions:
     1. Right-click in the cell below the Comment column heading.

   2.   Find the number of the desired comment. Do not click on it.

   3.   Click on the Fill Column option above the comment list.

   4.   In the New Score box, type in the comment number.

   5.   Click on Fill.

   6.   Click on Yes.

   7.   If you need to change this comment for a few students, right-click in the comment cell for
        the desired student and select another comment.

   8.   Click on File, Save gradebook.

                      Repeat this process for each class.
           English/Language Arts, Math, Science, Social Studies, Health




                                                                                               41
                                        Instructional Level
The Instructional Level is the grade level of the student. Some AAP students
and some special education students are the only students who will have an
instructional level that is different from the grade level.
    1.   Select the desired class. (Example: LANG ARTS)

    2.   Select the spreadsheet CLICK ON: ReportWizard Template Reporting Period 1, 2,
         3 or 4 (skill).

    3.   Click the arrow in the drop-down menu beside the word Show and select
         Tasks/Students.

    4.   Click on the instructional level line under Task Name. The corresponding column will
         be highlighted. The instructional level should be the first task listed. You may need to
         scroll up to see it.

    5.   Type the word to indicate the student’s instructional level. The instructional level must be
         spelled out. You may use the Fill Column feature to enter the same Instructional Level
         for all students.
                                                      Instructional Level
                                                                        The
                                                      1st Grade = One
                                                        nd              instructional
                                                      2 Grade = Two level must be
                                                      rd
                                                     3 Grade = Three
                                                     4th Grade = Four
                                                     5th Grade = Five
                                                     6th Grade=Six


    6.   Click on File, Save gradebook.
.

Fill Column Directions:
1. Right-click in the cell below the Instructional Level column heading.

2. Select the Fill Column option.

3. In the New Score box, type in the Instructional Level, which must be spelled out.

4. Click on Fill.

5. Click on Yes.

6. Click on File, Save gradebook.

If you need to change the Instructional Level for a few students, click in the Instructional Level cell for the
desired student and type in the correct level. All students are instructed on grade level with the exception of
some AAP students and some special education students.




                                                                                                             42
                                      Performance Level
Performance levels are indicators of a student’s progress toward meeting grade
level standards. Performance level marks must be given for each strand or
category within each subject.
                           Performance Level marks are as follows:
                          4 = Exceeding Standard
                          3 = Meeting Standard
                          2 = Making Progress Toward Standard
                          1 = Lacking Adequate Progress Toward Standards


 1.    Select the class. (Example: LANG ARTS)

 2.    Select the spreadsheet. ( ReportWizard Template Reporting Period 1, 2, 3, or 4 (skill)

       Click the arrow in the drop-down menu beside the word Show and select Tasks/Students.

 3. Click on the selected category or strand under Task Name . The corresponding column will
be
     highlighted.

 4. Key in the performance marks for each student. Do not fill in the column labeled Raw Score.

 5. Repeat this process for each performance level designation.

 6. Click on File, Save gradebook.

      You may use the Fill Column feature to enter the same Performance Level for all students.




Fill Column Directions:

1. Right-click in the cell below the Performance Level column heading.

2. Select the Fill Column option.

3. In the New Score box, type in the Performance Level.

4. Click on Fill.

5. Click on Yes.

6. Click on File, Save gradebook.


If you need to change the Performance Level for a few students, click in the Performance Level cell for the
desired student and type in the correct level.




                                                                                                          43
                                                   Effort

The effort students make regarding work habits is reported using an effort code.
Effort is addressed as Skills and Behaviors that Support Learning.
                           Effort marks are as follows:
                                  + Satisfactory
                                   - Needs Improvement



    1. Select the HOMEROOM CLASS.

    2. Select the ReportWizard Template Reporting Period 1, 2, 3 or 4 (skill) Spreadsheet.

    3. Click the arrow in the drop-down menu beside the word Show and select
       Tasks/Students.

    4. Click on the selected effort statement. The corresponding column will be highlighted.

    5. Key in the effort marks for each student.
            Do not fill in the column labeled Raw Score.

    6. Repeat this process for each effort statement.

    7. Click on File, Save gradebook.

You may use the Fill Column feature to enter the same Effort mark for all students.




Fill Column Directions:

1. Right-click in the cell below the Effort column heading.

2. Select the Fill Column option.

3. In the New Score box, type in the Effort Mark.

4. Click on Fill.

5. Click on Yes.

6. Save.

If you need to change the Effort mark for a few students, click in the Effort cell for the desired student and
type in the correct effort mark.




                                                                                                                 44
                         Exporting Grades to the Office


   1. From the Menu bar, select File, Export from Gradebook.

   2. A new window will open. Select the current (First, Second, Third or Fourth) reporting
      period.

   3. Click on Next.

   4. You may receive a message that some data is missing. Double check to be absolutely
      sure that all grades you are responsible for are recorded. If you have entered all marks,
      select Continue with the export anyway.

   5. Click on Next.

   6. Click on Export.

   7. Select your Teacher Number folder. Click OK.

   8. You may get an error message if any grades are blank on your EndTerm spreadsheets.
      You can view this log by clicking on Yes. This message does not affect your export.




                         Verifying Report Card Grades
The database specialist will print a draft copy of the report cards for verification. If
any corrections are made to a student’s grade, they must be made in IGPro and
all grades must be exported again.




                                                                                              45
                       PREPARING REPORT CARDS
                         FINAL MARKING PERIOD

1. Enter marks on the Fourth Quarter EndTerm spreadsheet for each subject
using the same process that has been used for the first three marking periods.
(p. 33,34)

2. Enter marks on the ReportWizard Template Reporting Period 4
spreadsheet for each subject using the same process that has been used for the
first three marking periods. (p. 36,37,38)

3. Enter final performance level indicators on the ReportWizard Reporting Period
Final spreadsheet for each subject.

4. Be sure to enter the end of year promotion/retention comment for each
student.

       Select the homeroom class.
       Select the fourth quarter endterm spreadsheet.
       Select the desired student.
       Right click on the cell below the first comment column to see the
       comment list.

5. Click on the desired comment:     Promoted - 011,         Retained - 012

6. IGPro does NOT automatically average, SASI will do the average, if the
database specialist runs a specific process (Update Grades).


7. If a student changed classes during the school year, the teacher will need to
ensure that a grade has been entered on the EndTerm spreadsheet for each
quarter. (Check with the previous teacher.) An empty EndTerm cell for any
quarter during the school year will calculate as a zero.

8. Export grades to the office. (p.39)


A copy of the final report card must be filed in the permanent record folder.




                                                                                 46
INSTRUCTIONS FOR RELATED ARTS TEACHERS




INSTRUCTIONS FOR

      RELATED ARTS
        TEACHERS
Related Arts teachers who teach one of the core subjects should refer to
         the instructions for core subject teachers as needed.




                  Standards-
                  Standards-based Reporting System

                          Standards-based         Standards-based
                            Assignment          Standards-based
                                                    Assessments
                                                  Assessments




                Standards-based                          Standards-based
                   Instruction                             Gradebooks




               Standards-based                                Standards-based
                  Planning                                      Report Card



                         South Carolina Curriculum Standards




                                                                                47
                                           TABLE OF CONTENTS


Instructions for Core Subject Teachers…………………………………………..6

Part 1- Setting Up the Gradebook.................................................................... 48
Login ................................................................................................................... 49
Creating a Gradebook......................................................................................... 49
Importing Class Rosters...................................................................................... 50
Identifying Class Sections ................................................................................... 51
Setting Your Password ....................................................................................... 52
Attaching Type Sets to a Class ........................................................................... 52
Importing Teacher Spreadsheets........................................................................ 53
Verifying Class/Type Sets................................................................................... 55
Verifying the Number of Spreadsheets ............................................................... 56
Verifying Integrade Pro Setup ............................................................................. 57


Part 2 – Using the Electronic Gradebook (Integrade Pro) ............................. 59
Opening Your Gradebook ................................................................................... 60
Classes and Spreadsheets Overview ................................................................. 61
Creating New Tasks............................................................................................ 62
Weighting an Assignment ................................................................................... 63
Entering Scores .................................................................................................. 64
Creating New Spreadsheets ............................................................................... 65
Copying Tasks .................................................................................................... 66
Standards-based Tasks ...................................................................................... 67


Part 3 – Preparing the Standards-based Report Card ................................... 68
Printing Type View Spreadsheet......................................................................... 69
Copying Grades to the EndTerm Spreadsheet ................................................... 70
Entering Grades Directly on the EndTerm Spreadsheet ..................................... 71
Entering Comments ............................................................................................ 72
Exporting Grades to the Office............................................................................ 74
Verifying Report Card Grades............................................................................. 74


Instructions for Related Arts Teachers........................................................... 46
Appendix ........................................................................................................... 75
Making the Transition.......................................................................................... 76
Teacher Tasks for Each Marking Period............................................................. 77
Performance Level Indicators ............................................................................. 78
English Language Arts Strands........................................................................... 81
Interim Reports (Options 1,2).............................................................................. 82
Sample Report Cards ....................................................................................90-91
Report Card Comments ...................................................................................... 92



                                                                                                                        48
                          Part I
     SETTING UP THE GRADEBOOK
                      RELATED ARTS

The setup of the electronic gradebook, Integrade Pro, is a process
that helps teachers organize for standards-based recordkeeping. The
Richland School District One Standards-based Elementary Reporting
System includes a procedure that links the record keeping of
standards-based teacher assessments to the standards-based report
card.



Integrade Pro setup is done at the beginning of each new school
year. Once setup is complete, teachers do not repeat any of the
steps included in Part I unless changes occur in scheduling.

Teacher assignments and student schedules should be finalized
before gradebooks are created. Teaches will be notified when the
gradebook setup process can begin.




                                                                   49
                                          Login
Login as a Novell client. You will need to know your Novell password to
complete this process. Once you have successfully logged in, write the
password down for future reference.




                              Creating a Gradebook
Teachers must create a new gradebook at the beginning of each school year.
This process is done only at the beginning of the year. Follow the step by step
instructions exactly as they are given. Your gradebook will be accessible from
your classroom computer.

   1. Login to the Novell network using your Novell user name and password.

   2. Enter IGPro by clicking on the igpro32.exe icon on your desktop.

   3. Select Open a gradebook on your computer. Click OK.

   4. Click on the arrow in the drop-down menu beside the words Look in:

   5. Select Nscapps on(Your School’s Name) \Vol 1 (H:).

   6. Double click IGPDATA.

   7. Double click 2004 Elementary Template.

   8. Double click Default. A blank gradebook will open.




                                                                              50
                            Importing Class Rosters
Class rosters and teacher schedules should be updated by the database
specialist before importing classes into the gradebook.

Teachers should never add or delete a student’s name in a gradebook.
Manually adding or deleting students breaks the link between your
gradebook and SASI which will cause your grades not to print. Once the
link is broken, the gradebook is corrupt and you will need to create a new
one.



   1. On the menu bar, click on File.

   2. Select Import into gradebook. Click on Next.

   3. Click on the arrow in the drop-down menu beside the words Look in:

   4. Click on Ncsaaps on (Your School Name)\Vol 1 (H:)

   5. Double click on IGPDATA.

   6. Double click on the folder that shows the School #.

   7. Double click folder that has your SASI Teacher #.

   8. Double click on the Clxxx.grd file (xxx is your teacher number).

   9. On the screen that appears, verify your name and SASI #.

   10. Click on Import. Your classes and students will import into your gradebook.

   11. Click on the arrow in the drop-down menu beside the word Class and verify the import of
       all classes that are currently assigned to you.

   12. On the File menu, click Save as.

   13. Type your first initial, last name, 2004. Do not use spaces.
         (Example: dsmith2004)

   14. Click Save.
                                                   DO NOT ADD or DELETE STUDENTS!
   15. Alphabetize each class roster:              All class roster changes must be done by
       Select the desired class.                   the database specialist.
       Right click on any student’s name.
       Select sort students by column.
       Repeat this process for each assigned class.

   16. Click on , select Save Gradebook.




                                                                                              51
                             Identifying Class Sections
All related arts classes for a subject are listed with the same SASI information.
Teachers may identify each section by homeroom teacher, section number or
any other identifying label.

   1. On the menu bar, select Setup.

   2. Select classes. When the window opens, a list of assigned classes is displayed on the
      left.

   3. Select the first class listed by clicking on the name.

   4. Click on the students tab to see the list of students, then return to the general tab.

   5. In the field labeled Class Name, locate the cursor after the set of parenthesis and click.

   6. Type the homeroom teacher’s name, section number, or an identifying label for the class.

   7. From the list on the left, select the next class and repeat the process until all classes are
      identified.




                                                                                               Type the
                                                                                               homeroom
                                      Select                                                   teacher’s
                                      each                                                     name.
                                      class.




                                                                                                 52
                                Setting Your Password
     1. On the menu bar, click on Setup.

     2. Select Password.

   3. Type the password you will use for your gradebook.
         Record your password and submit to the designated school personnel. Keep your
         password secure. It is very important that you memorize your password and also
have it
         written down so it can be easily retrieved. If you forget this password, your gradebook
         and all data will be lost. You will have to create a new gradebook.

     4. Click on Next.

     5. Type your password again to confirm it. Click on Next.

     6. Click on OK.

                         Attaching Type Sets To A Class
This process links the type set (subject) and the task types (strand) to each
class.
(Example: the Art strands must be attached to each Art class.)        This is a critical step
                                                                                 to ensure that
1.    From the menu click on Setup.                                              averages for each
                                                                                 strand are
                                                                                 computed
2.    Select Classes.

3.    When the window opens, click on the desired class from the list on the left.

4.   Click the arrow on the drop-down menu beside the words Task Type Set.

5.   Select the type set name that matches the class name.

6.    Repeat steps 3-5 for each class to ensure that grades are assigned to the proper category.
      It is not necessary to select a Current Grade Spreadsheet or Show Advanced Fields.
     Click Close.




                                                                                            The class
                                                                                            name and
                                                                                            the task type
                                                                                            set should be
                                                                                            the same.




                                                                                                53
                        Importing Teacher Spreadsheets
Teacher spreadsheets are used to hold the grades for daily assignments.
Import a set of teacher spreadsheets ( 1st nine weeks, 2nd nine weeks, 3rd nine
weeks, teacher final) from the sample class to each class you teach. This will
eliminate the need to create new teacher spreadsheets for each marking period.

   1. From the menu bar, select Tasks.

   2. Click on Import Tasks.

   3. Click on Next.

   4. Click on the arrow in the drop-down menu beside the words Look in:

   5. Double click on Igpdata.

   6. Double click on 2004 Elementary Template.

   7. Double click on Teachers Spreadsheets.

   8. Select Spreadsheets. Click on Next.

   9. Select All.

   10. Click on the arrow in the drop-down menu beside the words To Class.

   11. Select the class to receive the teacher spreadsheets.

   12. Select Import. Click on OK.

   13. Repeat steps 1-12 for each class that you teach.

   14. Save teacher gradebook.

   15. Click on File.

   16. Select Save gradebook.




                                                                             Import a set
                                                                             of teacher
                                                                             spreadsheets
                                                                             into each
                                                                             class.




                                                                                  54
You Did It!
  You have completed the
  setup of your gradebook.


The remaining pages in Part 1 will help you to
 check the accuracy of your setup process.




                 Remember:
  The format of your report cards is greatly
 determined by the setup of your gradebook.




                                                 55
                             Verifying Class/Type Set

You can check to be sure that the type set is actually attached to the appropriate
class while viewing the IG Pro spreadsheet.


   1. Click the arrow on the drop- down menu beside the word Class.

   2. Select the desired class.

   3. Select the Weighted Type (Numeric Weighted Type ) spreadsheet.

   4. Click the arrow on the drop-down menu next to the word Show.

   5. Select Tasks/Students.

   6. Click the arrow on the drop-down menu next to the word View.

   7. Select Type View.

   8. The type names (strands) are shown at the top of the spreadsheet.

   9. Verify that the type names (strands) shown actually belong with that class.

   10. Click the arrow on the drop- down menu beside the word Class to select the next class.

   11. Verify the type names (strands) for each class you teach. If a class has not been
       attached properly, refer to the instructions given on page 46.

   12. Click the arrow on the drop-down menu beside the word View again to return to the Task
       View.

         Note: New tasks can be added only when you are in the task view.




                                                Art task names
                                                match the class
                                                     name.




                                                                                            56
                   Verifying The Number Of Spreadsheets


Each class must contain the following spreadsheets:
      Five EndTerm Spreadsheets (first, second, third, fourth and final quarters)
      Five Teacher Spreadsheets ( 1st, 2nd, 3rd, 4th and final nine weeks)
      Each class will also contain two default spreadsheets: Weighted Type and
      Skill.



                  Verifying Sets of Spreadsheets In Each Class

   1.   Click the arrow in the drop-down menu beside the word Class:

   2. Select the first class listed.

   3. View the spreadsheets for that class by clicking on the arrow on the drop-down menu
      beside the word Spreadsheet. Check to be sure there is a set of Endterm
      spreadsheets and teacher spreadsheets. Related Arts teachers who teach one of
      the core subjects should also have ReportWizard templates for the core subject
      only.

   4. Click the arrow in the drop-down menu beside the word Class to select the next class.

   5. Verify the import of spreadsheets for each class you teach.
      Each class should have sets of spreadsheets as shown below.
      The order of the sets of spreadsheets does not matter.




                                                                                              57
                  VERIFICATION OF INTEGRADE PRO SETUP
    A gradebook that has been carefully set up and is accurately maintained
    throughout the marking period will contribute to a stress free end of marking
    period experience. Use this verification form to ensure that no teacher errors
    will be encountered when your report cards are printed. Have a minimum of two
    colleagues verify the accuracy of your set-up process by initialing in the space
    provided.

    Teacher’ s Name__________________________________              Grade ________


                                                                  Teacher 1             Teacher 2

Is each class labeled with the homeroom’s teacher’s name         List each class &     List each class &
                                                                  initial to verify.    initial to verify.
or some other identifying label? (Page 45)
You must check each class.
Click on:
        Setup
        Classes




                                                                 List each class &     List each class &
                                                                 initial to verify.    initial to verify.
Are the type sets attached to the correct class?
 (Page 46)
You must check each class.
     Click on:
       Setup
       Classes
       General




                                                                 List each class &     List each class &
                                                                 initial to verify.    initial to verify.
Does each class have the correct number of spreadsheets?
(Page 50)
You must check each class.
5 EndTerm
5 Teacher spreadsheets
      Click on:
       Setup
       Spreadsheets
       Select each class from the drop-down menu




                                                                                           58
59
                                   Part 2


    USING THE ELECTRONIC GRADEBOOK

                          RELATED ARTS
In a standards-based system, assignments are linked directly to the standards.
In the Richland School District One Standards-based Elementary Reporting
System, task types are used to group assignments by strand. A numeric
average can then be calculated for each strand. This facilitates the process of
reporting student progress toward meeting standards.

Student averages are kept current throughout the quarter and a record of
progress is always available. At the end of the report period, grades are
automatically calculated and easily transferred to the report card.

The steps included in this part of the manual are used by teachers for their daily
record keeping. A spreadsheet is constructed to hold the grades for each
subject for an entire quarter. Assignments (tasks) and student grades are
entered periodically.




                                                                                  60
                           Opening Your Gradebook
The following instructions will enable you to access a gradebook you have
previously created in IGPro.


   1. Login into the Novell network using your Novell user name and password.

   2. Enter IGPro by clicking on the IGPro icon on your desktop.

   3. Select Open a gradebook on your computer. Click OK.

   4. Click on your gradebook.

        If it is not listed in the Open screen, click on the drop-down arrow at the end of
        the Look in box. Find the IGPData folder. Double-click on your school
         number folder. Double-click on your teacher number folder. Double-click on
         your gradebook (Ex. Pdolder.gbf).


        Open


    Teacher
    gradebook




   5. Enter your password and click OK.

      A message appears that “Auto-update from administration system complete”. This
      updates your class roster from SASIxp. Click OK.




                             Your Gradebook is opened!


                                 SAVE AS YOU WORK!




                                                                                             61
                  Classes And Spreadsheets Overview

Classes are exported by your database specialist from SASIxp into IGPro and
are updated periodically. You should never add, delete, or edit a student’s name
in your gradebook. Advise your data base specialist of any changes that must
be made. New students will appear at the bottom of the class list.

All of your classes should be included in the Class list. Click on the drop down
menu beside the word class to view your complete class list. Each class will
contain several spreadsheets. Teachers will create tasks for each teacher
spreadsheet. Tasks are those assignments for which students receive grades.

Your gradebook has been set up with EndTerm spreadsheets and teacher
spreadsheets for each class.
      The EndTerm spreadsheet will hold the FINAL grades for that grading
      period.
      The teacher spreadsheets are labeled for each nine week period. These
      are used to hold the marks for daily assignments that will be counted as
      part of the quarterly grade.

Your gradebook opens to a randomly selected class spreadsheet. You will need
to select the desired class and the desired spreadsheet before entering any data.

   1. To find a specific class, click the arrow in the drop-down menu beside the word
      Class:




   2. To find a specific spreadsheet for that class, click the arrow in the drop-down
   menu beside the word Spreadsheet.



   3. Change the Show: window to Tasks/Students.



                                 You should never add,
                                 delete, or edit a student’s
                                 name in your gradebook.




                                                                                        62
                             Creating New Tasks
A task is any assignment for which you want to record a grade. Tasks are
entered on the teacher spreadsheets that are labeled for each nine week
period. (Example: 1st nine weeks)

 A task type is the category or strand. It is very important to link each task
to a task type. This will facilitate the process of determining performance
levels for each strand.

1. Select the desired CLASS. (Example: Art (09 - YR) Ms. Columbia )

2. Select the desired SPREADSHEET. (Example: 1st nine weeks)

3. Click the arrow in the drop-down menu beside the word View.

4. Select Task View.

5. From the Menu bar, click on Tasks, New Task.

6. Click on Next.

7. Enter the name of the task. (Example: Primary Colors)
     The date assigned and due date are optional.

8. Click on the arrow in the drop-down menu beside the word Type.

9. Select the appropriate strand or category.

10. Enter 100 in the Out of (Raw) box, 1.0 in the Scale Factor box, and 100 in the Out of
    Scale box. It is not necessary to fill in the Maximum Allowed Score box.

11. Click on Create. Grades can now be entered for the tasks. (See page 56)

12. Repeat for each task (assignment) needed for this spreadsheet.




                                                                                        63
                         Weighting An Assignment

1. Select the desired Class.

2. Select the desired Spreadsheet. (Example: 1st nine weeks).

3. On the menu bar, click on Tasks.

4. Select New Task.

5. Type in the Task Name for the assignment. Include the different weight as part of the
   task name as a reminder that the calculation for that assignment is different.

6. In the drop-down menu beside the word Type, select the appropriate task type (strand).

7. Type 100 in the Out of (Raw ) box.

8. Type the desired weight in the Scale Factor box. (Example: 2 for double credit or .5 for
   half credit)

9. Click in the Out of (Scaled) box.

10. Click on Create.




                   Correcting The Task Type For An Assignment

1.  Select Tasks.
4. Click on Edit Tasks.
5. Select the task to be edited from the list on the left.
7. Select the Points tab.
8. Select the correct Task Type.
9. Enter 100 in the Out of (Raw) box, 1.0 in the Scale Factor box, and 100 in the Out of
   Scale box. It is not necessary to fill in the Maximum Allowed Score box.
7. Close.




                                                                                           64
                                    Entering Scores

Numeric scores are entered for assignments that are to be included in the
student’s quarterly average. Gradebooks should be updated regularly so that
information regarding student progress is always current and available.

Primary and related arts teachers are not required to report numeric or letter
grades. These teachers may convert the scores on each assignment to
performance levels (1-4) and enter the performance level as the grade. The
performance level will automatically calculate for each category or strand.



   1.   Select the desired CLASS. (Example: Art (09 - YR) Ms. Columbia)

   2. Select the desired SPREADSHEET. (Example: 1st nine weeks)

   3. Click the arrow in the drop-down menu beside the word View.

   4. Select Task View.

   5. Select the student’s name.

   6. Click in the appropriate task column. (Example: Primary colors).

   7. For grades 1,2, and related arts, the performance level indicator (1,2,3,4) are entered as
      the grade.

   8. The student’s average and the corresponding letter grade will calculate automatically as
      scores are entered.

   9. Click on File, Save gradebook.




                              For grades 1, 2, and related
                              arts, the performance level
                              indicator (1,2,3,4 ) are
                              entered as the grade.




                                                                                              65
                          Creating New Spreadsheets
Additional spreadsheets may be created if the teacher desires.
       Teachers who have both primary (grades 1,2) and elementary (grades 3-
       5) students in the same class must create a different spreadsheet for
       each level.
       Teachers who have several grade levels in a class may keep a separate
       spreadsheet for each grade level.
       A homework spreadsheet can be used to calculate the homework
       average separately in the selected subject.


   1. Select the desired class. (Example: Art (09 - YR) Ms. Columbia )

   2. From the menu bar, click on Setup.

   3. Select Spreadsheets.

   4. Click on New at the bottom left corner of the form. This is a very important step. You
      must select New to create a new spreadsheet. If you type a name on the Name line
      without selecting New, you could rename one of the default spreadsheets, which will
      cause the exporting of grades to fail.

   5. Select Create a Numeric Spreadsheet.

   6. Click on Next.

   7. Name the new spreadsheet.

   8. Click on Next.

   9. Select Total Points.

   10. Click on Create. You may move the spreadsheet to the top of the list by holding down the
       CTRL key while selecting the spreadsheet name and dragging it to the desired location.

   11. Click on Close.

   12. Click on File, Save gradebook.




                                                                                               66
                                    Copying Tasks

If you have more than one class of the same subject, you can copy the tasks
from one spreadsheet to another. The spreadsheet you will copy to must
already be created. Tasks must be copied before any grades are entered,
otherwise, the grades will copy to the new spreadsheet.

   1. You must have the Class and Spreadsheet you wish to copy TO, appearing on your
      screen.

   2. From the Menu bar, click on Tasks, Copy Tasks.

   3. Click on the drop-down list after Class to select the class you are going to copy FROM.


   4. Click on the spreadsheet you will copy FROM.


   5. Click Next.


   6. Select the tasks (assignments) to copy. (Scroll down to see items at the bottom of the
      list.)


   7. Click on Next.


   8. Select Percentage.


   9. Click on Next.


   10. Click on OK.




                                                                                               67
                               Standards-based Tasks
Tasks are assignments that students are given. All assignments that are used to
determine student progress and assign grades should be standards-based. The
label used to identify assignments in the gradebook should also relate to the
standards. At a glance, the gradebook should reveal some of the standards that
have been taught.


                                     RELATED ARTS

                        CLASS: Art, Music, Physical Education Or
                                  Foreign Language

                TASK TYPE                               Examples of TASKS
    The category or strand into which each   Assignments for which students receive
              assignment falls.              grades.


Art Concepts                                 Mixing Colors
Art Application                              Self Portrait



Music Concepts                               Note Reading
Music Application                             Rhythm



PE Concepts                                   Volleyball rules quiz
PE Application                                Dribbling skills



Foreign Language Concepts                    Listening
Foreign Language Application                 Speaking




                                                                                      68
                                   Part 3

          PREPARING THE REPORT CARD

                         RELATED ARTS
In the Richland School District One Standards-based Elementary Reporting
System, performance level designations are used as indicators of progress
toward mastery of grade level standards. Progress is measured and reported to
parents by each strand to provide more detailed information regarding areas of
strength and weakness. Teachers then use this information to plan differentiated
and focused instruction for students based on identified needs.




                                                                              69
                      Printing Type View Spreadsheets

The type view allows you to see the average for assignments that are grouped by
categories or strands. Teachers should use this information along with their
professional judgment and their knowledge of each individual student's progress
to assign performance level indicators.

This process will allow you to have a hardcopy summary of the students'
performance on classroom assignments to view as you enter performance levels
on the ReportWizard spreadsheet.
   1. Select the desired class. (Example: Art (09 - YR) Ms. Columbia )

   2. Select the desired spreadsheet. (Example: 1st nine weks)

   3. Click the arrow in the drop-down menu beside the word VIEW.

   4. Select Type View.

   5. From the menu, select Reports.

   6. Select SPREADSHEET.

   7. A new window will open.

   8. Select All Students.

   9. Select All Types.

   10. Summary 1 – Select Percentage.

   11. Summary 2 - Select Letter Grade.

   12. Print Score As – Select Percentage.
       It is not necessary to make any selection under Notes.

   13. Click Next.

   14. Click Print.

Print a hardcopy of the TYPE VIEW spreadsheet for each subject or class
you teach.

Related Arts Teachers may either copy grades from the teacher spreadsheet to
the EndTerm spreadsheet (option 1) or enter grades directly on the Endterm
spreadsheet (option 2).




                                                                            70
                                Option 1
               Copying Grades To The Endterm Spreadsheet

You will copy numeric grades FROM a class and spreadsheet in your gradebook
TO the current EndTerm spreadsheet for the same class.
(Example: You will copy Art grades from your gradebook spreadsheet to the Art EndTerm spreadsheet)

Copying Numeric Grades

    1. Select the desired Class. This is the class you will copy TO (Example: Art (09 - YR) Ms.
       Columbia).

    2. Select the Quarter EndTerm spreadsheet you will copy TO. (Ex: First Quarter EndTerm)

    3. From the Menu bar, click on Tasks.

    4. Select Copy Tasks.
       Using the drop-down menu, select the class you are copying FROM: (Example: Art (09 –
        YR) Ms. Columbia )

    5. Select the gradebook spreadsheet you are copying FROM: (Example 1st Nine Weeks)

    6. Click Next.

    7. Select the item to copy by clicking on the spreadsheet name.          (Ex: 1st Nine Weeks).
       This should be the same spreadsheet that was selected in # 5.

    8. Click Next.

    9. Select the 1st, 2nd, 3rd, 4th, or final quarter numeric grade (Example: 1st QtrN Grade).

    10. Click Next.

    11. Select Percentage.

    12. Click Next.

    13. Check the Hot Link Grades box.

    14. Click OK.


    If you receive a message that some scores are invalid, it indicates that a grade is missing for
    a     student. Go back to the gradebook spreadsheet selected in #5 and enter the missing
    grades. You must redo the entire copy grade process beginning with # 1.

                      Repeat steps 1-15 for each class you teach.




                                                                                                     71
                            Option 2
       Entering Grades Directly on the EndTerm Spreadsheet

                                Performance Level
Performance levels are indicators of a student’s progress toward meeting grade
level standards. Performance level indicators are used to report student progress
in art, music, physical education, and foreign language.
                             Performance Level marks are as follows:
                            4 = Exceeding Standard
                            3 = Meeting Standard
                            2 = Making Progress Toward Standard
                            1 = Lacking Adequate Progress Toward Standards
    1. Select the class. (Example: Art (09 - YR) Ms. Columbia)

    2. Select the current Quarter EndTerm Spreadsheet. (Example: First Quarter Endterm)

    3. Click the arrow in the drop-down menu, beside the word Show and select Tasks/
       Students.

    4. Click in the column labeled QtrNGrade.(quarter numeric grade). The current quarter will
       be given. The entire column will be highlighted.

    5. Click in the cell beside the student’s name.

    6. Key in the performance mark for each student. Do not fill in the column labeled QtrA
       Grade.

    7. Repeat this process for each student.

    8. Click on File, Save gradebook.

 You may use the Fill Column feature to enter the same Performance Level for all students.

Fill Column Directions:

1. Right-click in the cell below the Performance Level column heading.

2. Select the Fill Column option.

3. In the New Score box, type in the Performance Level.

4. Click on Fill.

5. Click on Yes.

6. Click on File, Save gradebook.

If you need to change the Performance Level for a few students, click in the Performance Level
cell for the desired student and type in the correct level.




                                                                                              72
                                 Entering Comments

You may enter a maximum of two comments per subject for each student. Once
you have entered the comments, you are finished with this spreadsheet.
DO NOT FILL IN ANY OTHER COLUMNS.
   1.   Select the desired class. (Example: Social Studies)

   2.   Select the “EndTerm” spreadsheet for the current marking period. (Example: First
        Quarter EndTerm).

   3.   Select the desired student.

   4.   Right-click in the cell below the first Comment column to see the comment list.

   5.   Click on the desired comment.

   6.   If you want to make a second comment for a student, right click in the second comment
        column, then select the comment.

   7.   If you know the comment number, you can key it in.

   8.   Click File, Save gradebook.

        You can use the Fill Column command to key in the same comment for all students.


Fill Column Directions:
     1. Right-click in the cell below the Comment column heading.

   2.   Find the number of the desired comment. Do not click on it.

   3.   Click on the Fill Column option above the comment list.

   4.   In the New Score box, type in the comment number.

   5.   Click on Fill.

   6.   Click on Yes.

   7.   If you need to change this comment for a few students, click in the comment cell for the
        desired student and select another comment.

   8.   Click on File, Save gradebook.




                                                                                               73
Entering Comments on EndTerm Spreadsheet




                    Select
                                             Comments
    Select Class    Spreadsheet




                       Do not enter
                       grades in these
                       columns.




                Entering
    Performance Levels and Comments
              Related Arts


                                               Show



                      Select
                   Spreadsheet             Comments



        Select
        Class                              Performance
                                              Marks




                                                74
                             Exporting Grades to Office


    1.   From the Menu bar, select File, Export from Gradebook.

    2.   A new window will open. Select the current (First, Second, Third or Fourth) reporting
         period.

    3.   Click on Next.

    4.   You may receive a message that some data is missing. Double check to be absolutely
         sure that all grades you are responsible for are recorded. If you have entered all marks,
         select Continue with the export anyway.

    5.   Click on Next.

    6.   Click on Export.

    7.   Select your Teacher Number folder. Click OK.

    8.   You may get an error message if any grades are blank on your EndTerm spreadsheets.
         You can view this log by clicking on Yes. This message does not affect your export.




                                     Verifying Grades
Before exporting grades, related arts teachers may verify the grades for each student by
following the steps below.

    1.   Select the Class.

    2.   Select EndTerm spreadsheet for the current quarter.

    3.   On the Menu bar, click on Reports.

    4.   Click on Spreadsheet.

    5.   Click on ALL so that all students are selected.

    6.   Click Next.

    7.   Repeat these steps for each class you teach.




                                                                                                75
                              APENDIX




     APPENDIX

        Standards-
        Standards-based Reporting System

                Standards-based         Standards-based
                  Assignment          Standards-based
                                          Assessments
                                        Assessments




      Standards-based                          Standards-based
         Instruction                             Gradebooks




     Standards-based                                Standards-based
        Planning                                      Report Card



               South Carolina Curriculum Standards




76
                                       Making the Transition
                       from a Traditional Gradebook to Integrade Pro

Use this chart as a reference to help you see the relevance of the steps included in IG
Pro. As you work through each step, try to connect the IG Pro tasks to similar
tasks that teachers complete in a traditional gradebook.



     TRADITIONAL GRADEBOOK                                                     IG PRO

Receive a new gradebook to begin the current year.     Open IG Pro and select “Create A New
                                                       Gradebook”.

Personalize the gradebook with your name, room         Locate your school folder and teacher folder and
number, etc.                                           remember the folder numbers.


Write, tape, or clip important information such as     Set the grading rule.
the grading scale in front of the gradebook for easy
reference.


Write all of your students’ names in the gradebook     Names are already listed in each class. IG Pro will
in alphabetical order (or some other order).           alphabetize or sort them for you.


Decide which pages of the gradebook will be used       A spreadsheet is provided for each subject.
for each subject. Label the pages.                     Click on the desired spreadsheet.


Divide the columns on each page for better             Define type sets (subjects).
management. Designate columns for classwork,           Define task types (strands or categories).
tests, homework, etc.


As assignments are given, label each column to         As assignments are given, follow the steps for
show the date and name of the assignment.              “Create New Task”.


Record each student’s score for each assignment        Enter each student’s score for each task that is
that is given.                                         given.


At the end of the marking period, average all grades   The computer will keep student averages current as
for each subject to determine a report card grade.     each score is entered.

Enter grades on the report card using a computer.      Enter grades on the report card using a computer.




77
               ELEMENTARY REPORT CARD TEACHER TASKS
Teachers should refer to the Elementary Reporting System Teacher’s Manual as
each step is completed.

Select the teacher spreadsheet for the current marking period for each subject.
Never use a spreadsheet that is labeled “ReportWizard Template of Quarter EndTerm for your daily assignments.
• Never delete or change a ReportWizard or Quarter EndTerm spreadsheet.

Create new tasks. (p. 22)
•    A task is any assignment for which you want to record a grade.
•    Attach each task to a strand; not the subject.

Enter scores for student tasks. (p. 24)
•    Gradebooks should be updated regularly so that information regarding student progress is always current and
     available.

Print a type view spreadsheet. (p. 31)
•    The type view allows you to see the average for assignments that are grouped together by category or strand.
•    use as teacher information when completing progress reports.

Copy grades to the EndTerm spreadsheet. (p. 32
•    Numbers are copied to the numeric column.
•    Letter grades are copied to the alpha column.
•    Grades must be copied for each subject you teach.

Enter comments. (p. 34)
•    If you are reading from a hard copy, use the comment code, not the line number to select appropriate comments.


Enter the instructional level for each student. (p. 35)
•    The instructional level must be spelled out. (One, Two, Three, Four, Five)

Enter the performance levels for each student. (p. 36)

Enter the Effort codes. (p. 37)
•    There are eleven behaviors that must be marked.
•    Scroll over to the end of the screen to mark the last four behaviors.
•    Use the minus sign, not the underscore), to indicate “needs improvement”.

Export grades to the office. (p. 38)
•    Verifications should not be printed until all teachers have exported grades.


Verify report card grades. ( p. 39)
•    If any corrections are made to a student’s grade, they must be made in IGPro.
        The grades for that class must be copied to the EndTerm spreadsheet again and hotlinked.
        All grades must be exported again.
                             PERFORMANCE LEVEL INDICATORS


78
     Performance level indicators describe how a student demonstrates
knowledge and skills related to the standards. They are based upon the
student’s performance on daily assignments, tests, informal assessments,
projects, presentations and participation.

It is important not to equate the district’s grading scale with performance level
indicators. There are five letter grades and only four performance levels. There
is not a direct one to one correspondence between the performance level
indicators and the range of scores for a letter grade. A numeric average of 93-
100 does not automatically translate to the performance level indicator 4.

Once teachers have reviewed the explanation of performance level indicators, it
is important that teacher teams and entire staffs take the time to come to a
common understanding on specific requirements and quality of work expected for
each performance level listed below.



                            4 - Exceeding Standards
This level denotes demonstration of superior academic performance evidenced
by achievement which exceeds the goal for all students in the class. Students
who receive a 4 are those who consistently meet the challenge of a rigorous
curriculum.
Examples of student behavior:
       The student consistently meets and usually exceeds the expectation for
       assignments.
       The student consistently demonstrates an exceptional level of
       understanding.
       The student incorporates and transfers advanced skills and complex
       thinking into the grade level standards.
       The student is self-directed and independently extends the learning
       process.
       The student consistently performs above the expectation for grade level
       standards.

                              3 - Meeting Standards

This level denotes demonstration of solid academic performance on challenging
content matter included in grade level standards. This includes subjects matter
knowledge, application of such knowledge to real world situations, and content-
relevant analytical skills. Students who perform at this level have learned
essential content and skills that will support their success as they move on to
other learning experiences. They are well prepared to begin work on related
standards at the next grade level. Attainment of at least this level is the goal for
all students.



79
Examples of student behavior:
     The student consistently meets assignment requirements.
     The student regularly applies thinking skills and learning strategies.
     The student successfully achieves the expectations for grade level
     standards.



                    2 - Making Progress Toward Standards

Students who receive a 2 are showing consistent progress toward meeting
academic expectations. This level denotes partial understanding of the
knowledge and emerging ability to apply the skills that are included in the
grade level standards.
Examples of student behavior:
       The student meets requirements for some assignments.
       The student is beginning to grasp or shows partial grasp of central
       concepts.
       The student is showing progress in applying thinking skills and learning
       strategies.
       The student is performing near expectations on grade level standards.
       With support, the student experiences success on grade level standards.




              1 - Lacking Adequate Progress Toward Standards

This level denotes insufficient evidence of the prerequisite skills required to meet
the standards. Students who perform at this level have serious gaps in
knowledge and skills. The students require a considerable amount of
additional work and remediation in the skills that are prerequisite to do the
challenging work that is expected at the current grade level.
Examples of student behavior:
       The student struggles with meeting grade level expectations.
       The student does not meet assignment requirements.
       The student performs significantly below grade level expectations for
       meeting the standards.
       The student shows little evidence of applying thinking skills and learning
       strategies.
       The student shows little interest or effort, which limits progress.


Additional Notes:
It will not be unusual for a large number of students to receive 2’s and 3’s
      especially for the first marking period.



80
    Teacher must routinely build the expectations for a 4 into instruction and
assessment strategies.

Clear expectations and academic rigor are essential if students are to meet and
exceed standards.

Students are evaluated on progress toward meeting the standards that have
been taught through the current marking period. Refer to the district’s pacing
guides for specific listings of standards.




81
                ENGLISH LANGUAGE ARTS STRANDS
The ELA grade is determined by assessing student progress in the following
strands. Each strand is subdivided into topics.


Reading
• Reading Process and Comprehension - The student will integrate various
      cues and strategies, comprehend what he or she reads.
• Analysis of Text - The student will use a knowledge of the purposes,
  structures, and elements of writing to analyze and interpret various types of
  texts.
• Phonics and word study - The student will use a knowledge of graphophonics
  and word analysis to read and determine the meaning of unfamiliar words.

Writing
• Writing Process - The student will use a process approach to writing.
   (Includes editing for conventions such as spelling, capitalization, punctuation,
   and word usage)
• Writing Purposes - The student will write for a variety of purposes.
• Responding to Text - The student will respond to text written by others.
• Legibility - The student will create legible text.

Communication
• Speaking - The student will use speaking skills to participate in large and
  small groups in both formal and informal situations.
• Listening - The student will use listening skills to comprehend and analyze
  information he or she receives in both formal and informal situations.
• Viewing - The student will comprehend and analyze information he or she
  receives from nonprint sources.

Research
• Selecting a Topic - The student will select a topic for exploration.
• Gathering Information and Refining a Topic - The student will gather
  information from a variety of sources.
• Preparing and Presenting Information - The student will use a variety of
  strategies to prepare and select information.




82
                                   INTERIM REPORTS
Two interim report formats are available to teachers: a computer generated form
or a handwritten four-part form. The midterm average for each subject will be
readily available for teachers to complete the interim reports if grades are
frequently entered in the gradebook. The decision regarding which form to use
is made by each school’s instructional leadership team.


                                   Option 1
                        Computer Generated Interim
The computer generated interim must be printed by each core subject teacher.
The form is printed from the core subject teacher’s computer and given to the
homeroom teacher. A student will receive an interim from each teacher.

     1.    From the menu bar, select Reports.

     1. Select Multi-class.

     2. Two lists are available on the left side of the window.

     3. Select All students.

     4. Select All classes… then click on Homeroom to remove homeroom from the interim
        report list.

     5. The recommended information to include on the interim is selected in the example given
         below.




83
84
                                   Option 1
     A student receives an interim report from each core subject teacher.




85
                                     Option 2
                           Handwritten Four-Part Interim
Grades for the handwritten interims must be entered by each core subject
teacher. The four-part paper allows the teacher to keep a continuous record of
each interim report.
                                 Primary Teachers
Report the student’s performance level for each core subject. The performance
level for the strands within each subject are not reported at the interim.

     1. Select the desired class.
     2. Select the spreadsheet on which you have entered grades for the current
        marking period.
     3. On each student’s interim form, record the performance level average that is
        given in the % column.




                              Elementary Teachers
Report the student’s numeric average for each core subject.
The performance level for the strands within each subject are not reported at the
interim.


     1. Select the desired class.
     2. Select the spreadsheet on which you have entered grades for the current
        marking period.
     3. On each student’s interim form, record the numeric average that is given in the %
        column.




86
                         RICHLAND COUNTY SCHOOL DISTRICT ONE
                                              PRIMARY INTERIM REPORT
                                                          GRADES 1 and 2



             STUDENT______________________________TEACHER_____________________

             SCHOOL_______________________________                                           GRADE
             _________

                                               Current Performance Level
                                                                     1ST             2ND        3RD          4TH
            SUBJECT                                               INTERIM         INTERIM    INTERIM      INTERIM
            English Language Arts

            Mathematics

            Science

            Social Studies

            Health

                                               4                             3
             2                                                1
                                           Exceeding                      Meeting                    Making
                                         Progress                    LackiAdequateProgress
                                         Standards                    Standards                  Toward
             Standards                         Toward Standards




                ___________________________________                 COMMENTS
__________________________
               1st Interim
       3rd Interim
              ___ Conference Requested
       ___ Conference Requested




        ________________________________________________________________
        2nd Interim
        4thInterim
        ___Conference Requested
        __ Conference Requested




             87
- - - - - - - - - - - - - - - -             Return this portion to your child’s teacher   - - - - - -
- - - - -
                          __1st   __2nd   __3rd   __ 4th    Interim

I have read the interim for_________________________________________________________
                                                                                            Student’s
Name

Parent’s Signature _____________________________________________
Date____________

Parent’s Comments:




88
                            RICHLAND COUNTY SCHOOL DISTRICT ONE
                                        ELEMENTARY INTERIM REPORT
                                                          GRADES 3, 4, 5



      STUDENT      ____________________________TEACHER_______________________

      SCHOOL_______________________________                                                                         GRADE
      _________


                                                      Current Numeric Average
                                                                           1ST                   2ND               3RD         4TH
     SUBJECT                                                            INTERIM               INTERIM           INTERIM     INTERIM
     English Language Arts

     Mathematics

     Science

     Social Studies

     Health


        A     93-100              B   85-92                 C     77-84                   D     70-76              F   Below 70


                                  ___________________________________                             COMMENTS
                                  ______________________________
        1st Interim
3rd Interim
       ___ Conference Requested
___ Conference Requested




      ___________________________________________________________________________________________

 2nd Interim
 4TH Interim
 ___Conference Requested
 ___ Conference Requested




    - - - - - - - - - - - - - - -                               Return this portion to your child’s teacher   - - - - - - -
   - - - - -
                                              __1st     __2nd    __3rd     __ 4th     Interim

      I have read the interim for                     __________________________________________



      89
                                        SSAass
Student’s Name
Parent’s Signature____________________________________________Date______________




90
Parent’s Comments:

91
92
               ELEMENTARY REPORT CARD COMMENTS

001GENERAL COMMENTS
002In Alternative Program
003ESL provided during this class
004Principal's Honor Roll
005A/B Honor Roll
006Tardies affecting progress
007Absences affecting grade
008Call for a conference
009Possible retention
010Summer school required
012Retained in the same grade
013Good Progress/Acad Plan
014No Progress/Academic Plan
016Incomplete assignments
017Homework not returned
018Great job on homework
019Excellent performance
020Good performance
021Is capable of better work
022Shows improvement
023Puts forth good effort
024Actively participates
025Needs to participate
026Conscientious student
027Enthusiastic learner
028Pays attention in class
029Needs to be more attentive
030Does not work well alone
031Works well independently
032Works well in groups
033Does not work well in groups
034Follows directions well
035Does not follow directions
036Cooperates
037Needs to cooperate
038Takes pride in work
039Easily frustrated
040Needs to proof-read work
041Needs to put forth more effort
042Does well on tests
043Needs to study for tests
044Study guides provided
045Uses time wisely
046Needs to use time wisely



93
047Needs class materials
048Difficulty using technology
049Uses technology appropriately
011Promoted to the next grade
050Placed in the next grade

051ENGLISH LANGUAGE ARTS COMMENTS
052Currently enrolled in ESOL
053ELA resource grades included
054Uses correct English
055Reads independently
056Weak concepts of print
057AAP reading instruction
058Is in a focused reading group
059Encourage daily reading
060Weak word analysis skills
061Difficulty w/vocabulary
062Weak comprehension skills
063Good comprehension skills
064Uses comprehension strategies
065Analyzes text
066Does not analyze text
067Interprets various text
068Does not interpret text
069Uses cues to understand text
070Does not use textual clues
071Uses reading strategies
072Responds to literature
073Difficulty responding to lit
074Selects own text appropriately
075Writes legibly and neatly
076Needs to improve handwriting
077Handwriting is improving
078Does not like to write
079Enthusiastic writer
080Engages in sustained writing
081Encourage daily writing
082Learning to write stories
083Uses writing strategies
084Uses technology in writing
085Edits work accurately
086Errors in grammar
087Errors in capitalization
088Errors in punctuation
089Errors in spelling
    090Review spelling words



94
    091Difficulty sharing ideas
    092Weak oral communication skills
093Effective communication skills
094Listens appropriately
095Does not listen attentively
096Selects research topics
097Difficulty with research topic
098Accesses info from print
099Gathers info as needed
100Able to do reports
101Presents research well
102Difficulty presenting research
103Difficulty recording research
104Uses research tools
105------------------------------

107HEALTH COMMENTS
108Does not understand concepts
109Conveys concepts w/few errors
110Does not transfer skills
111Uses skills in other areas
112Needs help promoting health
113Comprehends health promotion
114Comprehends disease prevention
115Accesses valid health info
116Uses technology or resources
117Needs skills to enhance health
118Uses skills to enhance health
119Practices goal setting skills
120Sets short term goals
121Uses goal setting skills
122Makes appropriate decisions
123Needs to advocate for self
124Advocates for self and others
125Needs to advocate for others
126Makes poor nutritional choices
127Guided selection in cafeteria
128Makes good nutritional choices
129Self-Selection in cafeteria
130Unaware of effects of drugs
132Comprehends effects of drugs
133Comprehends healthy practices
134Needs to practice safety rules
135Practices safety rules

136ART COMENTS



95
137Does not describe works of art
138Study art vocabulary
139Describes works of art
140Shows similarities in the arts
141Encourage museum visits
142Needs to use art tools safety
143Needs to use art elements
144Uses material appropriately
145Uses art elements skillfully
146Uses improper media techniques
147Needs to use art principles
148Uses proper media techniques
149Uses art principles skillfully
150Creates original art work
151Communicates artistic ideas
152Needs to identify works of art
153Recognizes artist's culture
154Recognizes artistic style
155Identifies works of art
156Ineffectively analyzes art
157Review elements of art
158Analyzes art work effectively
160Misinterprets purposes of art
161Reviews principles of design
162Interprets purposes of art
163Judges art work with criteria
164Describes elements of art
165Describes principles of design
166Identifies art careers
167------------------------------

169MUSIC COMMENTS
170Sings independently
171Practice using singing voice
172Encourage singing
173Does not sing from memory
174Uses expressive voices
175Does not use expressive voices
176Sings from memory
177Difficulty with beat awareness
178Performs using instruments
179Plays instruments correctly
180Uses instruments with care
181Practice improvising patterns
182Good improvisation skills
   183Improvises simple patterns



96
    184Composes with difficulty
    185Practice musical patterns
186Composes short songs
187Difficulty with music symbols
188Practice music symbols
189Identifies music symbols
190Does not read music notation
191Reads music notation
192Does not identify instruments
193Practice music vocabulary
194Identifies music forms
195Encourage concert attendance
196Does not identify music forms
197Develop listening skills
198Describes elements of music
199Demonstrates listening skills
200Identifies instruments
201Develop music terminology
202Identifies musical elements
203Describes music preferences
204Misinterprets purpose of music
205Relates music to daily life
206Interprets purposes of music
207Knows similarities in the arts
208Does not identify music styles
209Identifies music styles
210------------------------------

212FOREIGN LANGUAGE COMMENTS
213Inconsistent participation
214Excellent participation
215Good participation
216Needs to be more attentive
217Excellent listening skills
218Is engaged in TPR activities
219Appropriate software used
220Good listening skills
221Engages in hands-on activities
222Seldom uses Spanish
223Needs work in pronunciation
224Engages in speaking activities
225Uses Spanish often
226Excellent pronunciation
227Good pronunciation
228Appreciates cultures studied
229Excellent reading skills



97
230Engages in reading activities
231Good reading skills
232Excellent writing skills
233Engages in writing
234Good writing skills
235Completes assignments
236Incentives are provided
237Currently enrolled in ESOL
238Limited proficiency in English
239No longer enrolled in ESOL
240Seldom uses French
241Uses French often

242SOCIAL STUDIES COMMENTS
243Understands time and history
244Poor concept of time/history
245Uses historical visual data
246Uses historical chronology
247Weak in cause of past events
248Explains cause of past events
249Needs to learn history facts
250Knows historical facts
251Doesn't explain past influence
252Explains past influences
253Identifies problem of the past
254Doesn't know workings of gov't
255Knows governmental functions
256Compares governmental systems
257Unclear of event significance
258Interprets significant events
259Understands political concepts
260Can interpret a simple map
261Can create a simple map
262Learn geographic terms
263Knows geographic terms
264Understands economic concepts
265Analyzes economic situations
266Weak in research skills
267Needs to use multiple sources
268Researches assignments fully
269Uses multiple sources
270Project quality is poor
271Needs more effort on projects
272Projects meet high standards
273Needs to contribute to group
    274Needs to concentrate on topics



98
     275Participates in discussions
     276------------------------------

278PHYSICAL EDUCATION COMMENTS
279Needs to put forth more effort
280Practices good sportsmanship
281Should show good sportsmanship
282Needs to cooperate
283Cooperates well
284Needs to follow directions
285Needs to follow safety rules
286Follows safety rules
287Demonstrates improvement
288Achieves fitness standards
289Meets fitness standards
290Practice fitness standards
291Standards need improvement
292Practice tossing skills
293Demonstrates tossing skills
294Practice traveling skills
295Demonstrates traveling skills
296Practice throwing skills
297Demonstrates throwing skills
298Demonstrates catching skills
299Practice for accuracy
300Performs dances
301Presents to class
302Practice basic game skills
303Practice gymnastics movements
304Performs gymnastics movements
305Creates gymnastics routine
306Does not work well in groups
307Works well in groups
308Knows benefits of activity
309Shows respect for others
310Shows responsible behavior
311Incomplete assignments
312Projects turned in late
313-----------------------------

315SCIENCE COMMENTS
316Needs help observing
317Makes good observations
318Needs help classifying
319Communicates science concepts
321Good classifying skills



99
322Uses technology in science
323Needs help using technology
324Investigates independently
325Investigates with assistance
326Can apply prior knowledge
327Difficulty making predictions
328Can make predictions
329Plans/conducts investigations
330Weak making reasonable guesses
331Can make reasonable guesses
332Can define variables
333Difficulty defining variables
334Knows inquiry process
335Difficulty w/ inquiry process
336Uses research skills
337Difficulty w/research skills
338Identifies characteristics
339Describes characteristics
340Explains characteristics
341Needs help w/science concept
342Shows improvement in science
343Understands science concepts
344Exceeds expectation in science
345Needs help with life science
346Knows life science concepts
347Shows interest in science
348Needs help with earth science
349Knows earth science concepts
351Difficulty w/physical science
352Knows physical science
353Engages in hands-on activities
354Extends ideas to other areas
355Shows ability in science
356Uses evidence to support ideas
357Incomplete science log
358Keep a detailed science log
359Uses equipment appropriately
360Misuses equipment
361-------------------------

363NUMBERS AND OPERATIONS
364Understands whole numbers
365Difficulty with whole numbers
366Understands addition
367Difficulty with addition
   368Recalls addition facts



100
    369Understands subtraction
    370Difficulty with subtraction
371Recalls subtraction facts
372Understands multip. concepts
373Difficulty w/ multip. concepts
374Recalls multiplication facts
375Understands place value
376Difficulty with place value
377Understands decimals
378Difficulty with decimals
379Recognizes equivalents
380Difficulty with equivalents
381Understands fractions
382Difficulty with fractions
383Understands percents
384Difficulty with percents
385------------------------------

387ALGEBRA
388Understands patterns
389Difficulty with patterns
390Understands algebraic symbols
391Difficulty w/algebraic symbols
392Models number relationships
393Problems w/number relationship
394Understands tables/graphs
395Difficulty w/tables and graphs
396Utilizes equations
397Difficulty with equations
398Recognizes quantitative change
400Understands algebraic concepts
401Difficulty w/algebraic concept
402------------------------------

404GEOMETRY
405Classifies objects/shapes
406Difficulty w/ sorting objects
407Specifies object locations
408Difficulty w/object locations
409Identifies geometric shapes
410Applies reasoning skills
411Applies geometry skills
412Difficulty w/geometry
413---------------------------

415MEASUREMENT



101
416Tells and records time
417Difficulty with telling time
418Compares and orders objects
419Applies measurements skills
420Difficulty with measurement
421Applies estimation skills
422Understands metric system
423Difficulty with metric system
424Understands unit conversions
425Difficulty w/unit conversions
426Uses measuring tools
427Difficulty w/measuring tools
428Uses problem solving skills
429----------------------------

431DATA ANALYSIS AND PROBABILITY
432Collects & organizes data
433Difficulty w/ data collection
434Uses graphs/charts/tables
435Understands types of graphs
436Difficulty interpreting graphs
437Analyzes data
438Difficulty data analysis
439Develops inferences
440Develops predictions
441Difficulty with probability
442Understands probability
443Applies probability concepts
444Explains mean, median, mode
445Difficulty w/ mean/median/mode
446Evaluates predictions
447Justifies conclusions




102

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:18
posted:8/13/2011
language:English
pages:102
Description: Teacher Spreadsheets document sample