SC07 Membership and Attendance Worksheet
Contents
Introduction
This report supports the Membership and Attendance Report and contains running membership totals along with counts of new and dropped students and attendance counts by EFA classification code for each day in a specified date range.
Note: Due to the calculations involved in processing this report, it may take up to a couple of hours to run this report.
Selection Criteria
Selection criteria determine which database records are used in the report. For the SC07-Membership and Attendance Worksheet, student records are selected. Refer to selection criteria for analysis when the report does not return the correct records.
Student Selection
A student record is selected if it meets the following criteria:
- This student is enrolled, or has been enrolled with a funded enrollment code (that is, an enrollment code other than “xxi”) during the report period.
- The Include in State Reporting field is set to Yes for that student record.
- The student was enrolled in a user-selected grade level during the report period.
A student record is excluded if it meets the following criteria:
- The student was enrolled with only an xxi enrollment code during the report period.
- The student had an enrollment entry with the enter date and the exit date as the same date (no shows) in the selected school year, and the grade is not 99, and the school ID is not the Graduated Students School (999999). The SCDE has guidelines for how schools should adjust the student’s enrollment in PowerSchool for this scenario.
- The Include in State Reporting field is set to No for that student record.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Processing Options | Use the pop-up menu to select a processing option. Use the options to indicate when you want the report to generate.
The option to override may not be available on some reports. |
Specific Date/Time | If “On Specific Time” is chosen for the Processing Options, enter the date and time you want the system to generate the report. |
Date | If a date is specified, the report uses it as the end date of the report period. The first in-session day of school is the start date of the report period. It also looks up the school day number in the school calendar corresponding to that date. |
Day Number | If a day is entered, the report looks in the school calendar for the in-session date for that day number. For example, if the user enters the number 5 and the 5th in-session day of school is August 25, the report end date will be August 25th. |
Grade | Enter two grade levels to identify the grade level range for the report. You can select any two grade levels that are valid for the selected school. Leave both Grade fields blank to include all students in your school on the report. |
Self Contained | Choose Yes if you want to include only self-contained students. Choose No to include all students that meet the selection criteria for the report. The default option is No. |
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Position | Field | Description | [Table]Field name |
1 | Date | The date the report was processed. | N/A |
2 | BEDS Code | This field is calculated by combining the district number and school code. The district number is extracted from the Edit District page, Start Page > District Setup > District Information. The school code is extracted from the Edit School page, Start Page > District Setup > Schools/School Info > Edit School. | [Prefs]Name=districtnumber [Schools]School_Number |
3 | Name | This field contains the name of your school. This value is extracted from the Edit School page, Start Page > District Setup > Schools/School Info > Edit School. | [Schools]School_Name |
4 | 999 Day Data as of 99/99/9999 | This field contains the date or day number entered on the report interface page. | N/A |
5 | Self-Contained | This will show No when the Self-contained option is set to No. When set to Yes, Yes will show next to Self-contained only. | N/A |
6 | Grade Range | This field contains the grade level range selected on the report interface page. If no grade levels were selected for the report, the grade levels do not print. | N/A |
7 | District Name | This field contains the name of your school district. This value is extracted from the Edit District page, Start Page > District Setup > District Information. | [Prefs]Name=districtname |
8 | Grade | This is the current grade level of the students on the current page. | N/A |
9 | Page | This displays the page number. | N/A |
10 | Number | This column contains the identification number for each student. This is extracted from the General Demographics page, Start Page > Student Selection > General Demographics. | [Students]Student_Number |
11 | Date | This column contains the date for the line in the format mm-dd. | N/A |
12 | Day Num | This column contains the school day number corresponding to the in-session school date. | N/A |
13 | New | This column contains the number of students newly enrolled on that date. | N/A |
14 | Dropped | This column contains the number of students withdrawn from school. The withdrawal date is not a membership day for a student. | N/A |
15 | Cumulative | This column is calculated from the New and Drp columns. | N/A |
16 | Membership By EFA Classification | These headings reflect the EFA Classifications required by the state. The numbers under each of these headings reflect the total number of students at each grade level that are coded with that particular EFA code. | N/A |
17 | Total | This shows the total from columns left to right. | N/A |
18 | Absent | This shows the total days absent. | N/A |
19 | Present | This shows the total days present. | N/A |
20 | Total | This shows the total absences and presents. | N/A |
21 | Period Total | This shows the totals for each column for the particular period range the report was run for. | N/A |
22 | Cumulative Total | This shows the totals for each column for the year-to-date range. (Balance Forward + values for each date in the period). | N/A |
23 | Average Daily Membership This Page | This contains the value on the Per. Total line in the EFA Membership Total Column / Number of days on the current page. This counts the number of values in the Num column excluding the Bal. Fwd., the Per. Total, and the Cum. Total lines. | N/A |
24 | Cumulative | This is the ADM cumulative on this page. This is the value in the Cum. Total line in the EFA Membership Total Column / Day number on the last line before the Per. Total line. | N/A |
25 | Average Daily Attendance This Page | This contains the Value in the Per. Total line in the attendance Present Column / Number of days on the current page. Count the number of values in the Num column excluding the Bal. Fwd., the Per. Total, and the Cum. Total lines. | N/A |
26 | Cumulative | This is the ADA cumulative on this page. This is the value in the Cum. Total line in the attendance Present Column / Day number on the last line before the Per. Total line. | N/A |