YL-GFSD3 - Data Analysis (Year Long)

GOOGLE GOODIES
>
YL-GFSD3 - Data Analysis (Year Long)

YL-GFSD3 - Data Analysis (Year Long)

SKU: gfs-ylda-2018

$1,000,000.00

$0.00

Unavailable

per item

Qty

Description

By using the YL-GFSD3 | Data Analysis Program in conjunction with GFSD3, teachers can now track each students assessments throughout the entire year. With just a few simple tricks, and a few simple clicks, student data for the year is within your grasp. Oh, and it also can project each of your students success in EOY Assessments with great accuracy.

MAKE A COPY OF YL-GFSD3 HERE

NOTE: This program only works in conjunction with GFSD3.

Buy Now

YL-GFSD 3.0 - Data Analysis Program (Year Long)

Use GFSD3 and "Link" specific data from each assessment to this program to have a running record of the student data.

'MASTER TEST ROSTER' SETUP

A Google Form will need to be completed by all students that will take the GFSD3 assessments. This form will just consist of the following information:

Email Address
Student First & Last Name
Teacher Name & Class Period

This Google Form will be used to link emails (emails in each assessment for each student must be the same for each student - really only works if the students have a REAL email used for each assessment) of each student from this eventual spreadsheet to all of the other GFSD3 assessments. Think of it like a unique identifier - so that each student's scores can be correctly linked throughout this program. Once completed, and you have the students information collected within this form, there is an opportunity to identify up to four subgroups for each student. These four subgroups are up to you, and optional - but think of possible EOY subject and grade level needs - not to mention school CCRPI (Georgia) flags.

SUBGROUP SETUP

After the 'Student Test Rosters' Google Form has been completed by your students, send all information to a NEW Google Spreadsheet. The Following columns will be used:

Column A : Timestamp
Column B : Email Address
Column C : Student First & Last Name
Column D : Teacher Name & Class Period

You will now have the opportunity to identify four subgroups in this spreadsheet to help with your EOY needs. 'Column E' through 'Column H' is where you will identify the student subgroup.

IMPORTANT AND MUST OCCUR:

If a student falls into a specific subgroup, to identify that student in the subgroup, a " Y " must be placed in the cell of that column to mark that student in the subgroup. So, columns E through H must be marked with a " Y " to place that student in that subgroup. Once this occurs, all info in the MASTER Test Roster will be sent to the YL-GFSD3 program.

START SHEET of YL-GFSD3

The purpose of this program is to pull multiple assessments from GFSD3 into one place to analyze data over time. With that, we can also categorize our assessments and place weights for each category. For example 8th grade GA Studies has four categories: Geography, History, Gov/Civics, and Economics. By using your EOY weights, this program can make projections for each student on how they will perform on the EOY assessment. Simply complete the purple cells in Columns G-I, and the data will then be calculated throughout the program.

NOTE: If you give multiple benchmarks, this could also be one category name. To just calculate the benchmark data, mark the weight for the benchmarks at 100%.

THE GFSD3 SPREADSHEET KEYS

The first step is to link the 'MASTER Test Roster' spreadsheet to this YL-GFSD3 program spreadsheet. You will need the GFSD3 spreadsheet key for all of your other assessments so just so you know what it is, check out this picture below:

Once you copied the 'Master Test Roster' spreadsheet key, paste it in the yellow cell (D11) to link the Master Test Roster spreadsheet to this YL-GFSD3 spreadsheet.

NOTE: On ALL spreadsheet keys, you will also need to include quotation marks at the beginning and ending of the spreadsheet key. It will look something like this:

"0Ap-gnKfDH3FMdExBSjh4NXVIUmh1SkxSajlTTGJ0RWc"

This process will continue for EACH GFSD3 assessment that will be linked into this program. Start with your first GFSD3 assessment in Cell C12 and give it a very short test identifier (H1). Then complete the spreadsheet key requirement. Finally, choose The Category Number for the assessment. There is one more thing to do, which is completed on the "ALLOW ACCESS" sheet.

ALLOW ACCESS SHEET of YL-GFSD3

For all of the data to be transferred over from each GFSD3 assessment, and after the spreadsheet key is entered into the START sheet, you will need to finalize this process on the ALLOW ACCESS sheet. Simply find the PINK cells (C6, L6, T6, AB6, and so on...) and select the cell. When you do, you will see the image below, and all you have to do next is to just click the blue button with the words "Allow access." This will complete the process of takign the student data from the GFSD3 assessments and bring them over to the YL-GFSD3 program.

Note: Every time the original GFSD3 assessment is updated (another test submission occurs), the new data from that file will automatically be send here.

ONCE ALLOW ACCESS HAS OCCURRED

AT A GLANCE - Sheet (No Clicks Needed)
Way too much to list here, but nothing for you to do. Go to this sheet for a whole ton of data broken down by teacher, all the way down to student subgroups.

GRAPHS - Sheet (No Clicks Needed)
Three graphs are here:

TEST AVERAGES (OVERALL)
ASSESSMENT SECTION SCORES
Z-SCORE AVERAGES FOR EACH ASSESSMENT

SUBGROUPS - Sheet
IF IF IF you completed on the "Master Test Roster" the subgroup section, this sheet is for you! Identify how many subgroup students you have and what their overall Z-Score average is AND the Overall Rank. This can be complete on other sheets, but on this sheet you have complete filter-ability.

TEST SCORES - Sheet
This sheet has test scores from all linked GFSD3 assessments. You are able to filter to find exactly what you are looking for. Also, please take note of Column B, where you will be able to filter and identify the number of subgroups each student belongs to. You will also be able to filter by each specific subgroup.

SECTIONS - Sheet
This sheet has all of the "sections" from the test scores of all linked GFSD3 assessments. You are able to filter to find exactly what you are looking for. Also, please take note of Column B, where you will be able to filter and identify the number of subgroups each student belongs to. You will also be able to filter by each specific subgroup.

Z-SCORES - Sheet
This sheet has Z-Scores from all linked GFSD3 assessments. Since the scores are color-coded, you will be able to easily identify which students regularly score above the median of all test scores, or not! You can also identify the average z-score for each subgroup.

LEVELS - Sheet
This sheet is where the EOY projections are! You can learn the number of each student and percentage for each Level for the EOY assessment. Not only that, you can break it down by subgroup, and a few more goodies:

Strength of Projection - The more assessments a student completes, the greater the projection. If a student has completed all of the linked GFSD3 assessments, then that student's strength of projection is at 100%.
Projected EOY Level - This is where each student's projected level on the EOY assessment will be.
Projected Bubble Levels - If a student is currently projected at an EOY Level of 3, but is listed as a Bubble Level of 4, this program is projecting that this student may be able to reach and achieve a Level 4 on the EOY. If this student has a Bubble Level of 2, then this student may fall down a Level on the EOY.
NOTE: If the student has the same Projected Level and Bubble Level, that means this student is at the lower end of that level, and could possibly fall one level on the EOY.

CLASS SECTIONS - Sheet (No Clicks Needed)
Each Teacher & Class Period's averages on each section are identified here - along with the averages per section for all teachers. The color coding is based on each teacher - so you will be able to easily identify a teacher's weakest section for all linked GFSD3 assessments.

CLASS RANKS - Sheet (No Clicks Needed)
Based on the scores of all sections of all linked GFSD3 assessments, each Teacher is assigned an overall score and is ranked. You can easily identify a class period who may need more assistance. "Green Yellow or Orange" colors means that class period is in the top 3 of that section and the more of the colors, the better performing the class is.

CLASS AVERAGES - Sheet (No Clicks Needed)
Simply put, you can easily identify based on color coding and data the overall average of each assessment per class. The color coding is based on each class period.

STUDENT NAMES - Sheet
All you have to do is select a Teacher & Class Period. Once that happens, student names will appear in the following ways:

Overall Projection
Overall Bubble Students
Level for each specific category listed on the START sheet.

END OF YEAR - TO DO

EOY RESULTS - Sheet
Again, all is filterable. This is the same sheet as the LEVELS sheet, except for a few things that you have the option of completing.

When you receive the results of your state given EOY assessment, and you want to know if this whole YL-GFSD3 process was worth it (IT IS), complete Column Q "ACTUAL EOY LEVELS." You will need to select the correct level for each student. Once that is completed, the last column to complete is Column CG "REASON FOR NO." If the "ACCURATE EOY PROJECTION was "NO", this is where you identify why. It was either "Higher" or "Lower" - just select the correct reason.

EOY FINAL - Sheet (No Clicks Needed)
Since all data has been entered, and collected, this sheet has it all broken down for you when it comes to overall numbers. Nothing to do, everything to see.

AUTOCRAT - Sheet
It is NOT ready yet. But...

Wouldn't it be nice to be able to send a student a detailed report of all the assessments for the year, including EOY data, all in one Google Doc? Yeah, I think so too. Sadly, it is not completed yet, but it will be. There is nothing I can do about it now, but know this is what I am working on now.