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.
Pages to are hidden for
"Elementary Report Cards Instructions"Please download to view full document