Docstoc

Elementary Report Cards Instructions

Document Sample
Elementary Report Cards Instructions Powered By Docstoc
					Coweta County School System


    Elementary Report
               Cards


              Instructions


                       Table of Contents

Definitions

ESOL Information

Saving the Report Cards from the Intranet

Heading and Tabs

How to Rename a Sheet

Entering Grades

Grading Symbol Keys

Attendance

                                     1
              For additional information contact Sandra Waites.
Coweta County School System



Grade Modification

Grade Level for Next Year

Printing




                                    2
             For additional information contact Sandra Waites.
Coweta County School System

Definitions


Red Triangle                   The red triangle indicates that there is a
                               comment relating to that cell. Put your mouse
                               over the cell and the comment is visible.
                               These comments will not print on the report
                               cards.
Tabs                    1. To rename the active sheet, right click on the
The tabs are along         tab. Then click Rename.
the bottom of the       2. Type the new name over the current name.
worksheet. Each
tab represents one
student report
card. To move from
one report card to
another, click on
the tab.

                     If you don't see the tab you want, click the tab
                     scrolling buttons to display the tab, and then click the
                     tab.


Worksheet            The primary document that you use in Excel to store
                     and work with data. Also called a spreadsheet. A
                     worksheet consists of cells that are organized into
                     columns and rows; a worksheet is always stored in a
                     workbook.
Drop-Down Arrow                                   When you click into a cell
                                                  that should contain a
                                                  letter grade, an arrow
                                                  appears next to the cell.
                                                  Click the arrow to see the
                                                  available options for that
                                                  cell.




                                       3
                For additional information contact Sandra Waites.
Coweta County School System




                                        Elementary
                                       Report Cards
                                       Instructions


The ESOL Report Card is the same as the Report Card. The
only difference is there are no numerical grades on the ESOL
Report Card.

Saving the Report Cards from the Intranet
  1. Open the Elementary Curriculum page on the Intranet for your grade
     level.
  2. Right click the Report Card link.
  3. From the menu box that opens, select “Save Target As”.




  4. Select a location on your hard drive or U: drive on the server to save
     the file.
            NOTE: See your ETSS for information on saving to your server
            folder.
  5. Change the name in the File Name box:
        Example: Waites Report Cards 04-05
  6. Save.


                                       4
                For additional information contact Sandra Waites.
Coweta County School System




                                  5
           For additional information contact Sandra Waites.
Coweta County School System

Headings and Tabs
   1. Open the file from the U: drive or hard drive.
            NOTE: Use the saved file and not the file directly off of the
            Intranet.
   2. Make sure that Student 1 is the active sheet. To make it active, click
      on the Student 1 tab.
   3. Enter the student name in the Name box.
   4. Rename the sheet tab to the student name. You may want to use last
      name, first name on the tabs.
            Example: Smith, John

HOW    TO: Rename a Sheet
  1.   Right click on the tab that you want to rename.
  2.   Click RENAME.
  3.   Type the new name over the current name.
  4.   Enter.



   5. Enter the School, Teacher, and Principal names. These names will be
      automatically entered on Students 2 – 30 worksheets.

Entering Grades
The chart below shows the subjects for each grade that receives a numeric
grade. All other grades are AC, IP, NE for Kindergarten and S, N, U, \ for
first, second, third, fourth, and fifth grades.

           Grade              Subjects that Receive Numeric Grades
       Kindergarten           None
         1st Grade            Reading, Spelling, Math, Conduct
        2nd Grade             Reading, Spelling, Math, Conduct
         3rd Grade            Reading, Language Arts, Spelling, Science and
                              Health, Social Studies, Conduct, Math
        4th Grade             Reading, Language Arts. Spelling, Math,
                              Science/Health, Social Studies, Conduct
        5th Grade             Reading, Language Arts, Spelling, Math, Science,
                              Social Studies, Conduct



                                           6
                    For additional information contact Sandra Waites.
Coweta County School System

             NOTE: The ESOL Report Card has no numerical grades.

Grading Symbol Key for 1st, 2nd, 3rd, 4th, and 5th Grades

GRADING SYMBOL KEY
A        90 - 100                S      Satisfactory
B        80 - 89                 N      Needs improvement
C         71 - 79                U      Unsatisfactory
D         70                     \      Not Assessed during
F         Below 70                      grading period


Grading Symbol Key for Kindergarten

GRADING SYMBOL KEY
AC--Accomplished
IP--In Progress
NE--Not Evident


             NOTES: Some cells are locked and can not be edited. Only the
             type of grade required can be entered into the cell.

The numerical grades are calculated for you. When you enter the first and
second nine weeks grade, the first semester average is calculated for you.
When you enter the third and fourth nine weeks grades, the second
semester average is calculated. At that time the Yearly average will also be
calculated.

Completing Non-Numerical Grades

When you click in a cell that requires a letter grade, an arrow appears. When
you click the arrow, the choices for that cell appear. Click on the appropriate
grade, and that letter appears in the cell. To make a change, click in the cell
again, the arrow appears and then you can choose the correct grade.




                                           7
                    For additional information contact Sandra Waites.
Coweta County School System

If you get the following message, you have entered a non-valid grade for
that cell. The cells are restricted so that an incorrect value can not be
placed in the cell. Click Retry and enter the correct value.

Error Message:

The value you entered is not valid.
A user has restricted values that can be entered into this cell.



Attendance

The Days Present shows 45 days. This information can not be edited. When
you enter the Days Absent and Days Off Roll, the Days Present will be
calculated. The Semester totals and Yearly totals will also be calculated.

Example:

ATTENDANCE                     1       2       SEM    3       4       SEM   YEAR
DAYS PRESENT                   42     45       87    45      45       90    177
DAYS ABSENT                    3               3                      0      3
DAYS OFF ROLL                  0               0                      0      0
TIMES TARDY                    2               2                      0      2


Grade Modification

If the grade that you entered reflects a modification or accommodation,
enter the subject name in the box per nine weeks. The space is limited so
you may have to abbreviate the subjects.

Example:


      Grades based on         1st    Lang. Arts, Science, Math, Reading
     modification and/or      2nd
 accommodation if indicated   3rd
           in box.
                              4th




                                           8
                  For additional information contact Sandra Waites.
Coweta County School System

Grade Level for Next Year

Enter the grade level for the next school year.

Example:



Grade Assignment Next Year           1st

Teacher Comments

The teacher comments are limited by characters. The comments tell you the
character limits. You will not be able to type over that limit.




                                        9
                 For additional information contact Sandra Waites.
Coweta County School System

Printing

When you complete the report cards, you have three options for printing. All
report cards print on an 8.5 x 11 sheet of paper. There is no special paper
required to print report cards.

   Option 1: Only the
   active report card will
   print.

   1. Select the tab of the
      report card that you
      want to print.
   2. Click File > Print
   3. In the Print window,
      the Print Range should
      be ALL.
   4. In the Print What
      window, choose Active                            Option 1
      Sheet.
   5. Click OK.

   Option 2: All report
   cards for students 1-30
   will print.

   1. Any report card can
      be active.
   2. Click File > Print.
   3. In the Print window,
      the Print Range should
      be ALL and the Print
      What should be Entire
      Workbook.
                                                       Option 2
   4. Click OK.




                                       10
                 For additional information contact Sandra Waites.
Coweta County School System

  Option 3: Only the
  report cards that you
  choose will print.

  1. Any report card can
     be active.
  2. Click File > Print.
  3. The Print Range will be
     Pages 1 - ?. Each
     student report card
     prints as a page. If you
     have 23 student
     report cards, put 23 in
     the last page box.                               Option 3
  4. The Print What should
     be Entire Workbook.




                                      11
                For additional information contact Sandra Waites.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:15
posted:9/5/2011
language:English
pages:11