Data SGP (Student Growth & Learning Panel) is the collection of aggregated student achievement and learning data collected over time to aid educators and parents in understanding the student progress through education. This data includes individual-level measures like test scores and growth percentiles as well as school/district level measures such as class size, attendance rates, graduation rates and aggregated measures related to demographics (grade level, gender, ethnicity & socioeconomic status etc) used at group-level for larger studies or research efforts.
Growth percentiles measure how far an assessment student has improved relative to academic peers who took similar assessments with similar prior test scores. Although growth percentile calculations can be complex, these charts offer useful information that teachers and parents can use when tailoring classroom practices or evaluating school/district performance.
Spreadsheets are one of the most frequently employed methods for collecting longitudinal data. Excel data sets created using this format typically feature rows representing students and columns representing variables associated with them at different points in time; additionally, these spreadsheets include a summary column which calculates mean and median.
This allows you to spot trends within a data set, as well as compare groups of students within a class (subgroups within). Furthermore, the spreadsheet enables you to sort results and display them in various ways; you may filter data pertaining to specific groups or grade levels – for instance you could view performance across individual courses by filtering.
Additionally, the spreadsheet can be used to calculate student growth projections. These projections are calculated based on historical growth trajectories of Star examinees and can be customized by choosing either previous or current school years in the “Timeframe” drop-down menu. Once calculated, these projections can help teachers make instructional decisions more accurately.
Installing SGP also installs an example WIDE panel dataset named sgpData that emulates the data set that is used for studentGrowthPercentiles and studentGrowthProjections. This sample data set allows you to test out various functions before creating your own panel data set. If you choose a data set in LONG format, additional columns will need to be added in your spreadsheet in order to store student-level variables associated with every assessment occurrence. Before using the sgpData function, it is advisable to read both its documentation and examples thoroughly. These provide detailed instructions and examples on how to format LONG data correctly – this will ensure accurate results. Furthermore, care must be taken to avoid accidentally overwriting any original values found within your spreadsheet – this could cause irreparable damage and it may no longer be possible to recover them later.