The F&P Classroom Reading Data Entry Dashboards (embedded below) brings together the power of Google Forms, Google Sheets, and Google Data Studio (GDS) Reports into one place for our classroom teachers and our Title I teachers.
The first page of the GDS Report provides teachers with an updated list of students with Google Form pre-fill links for each student. After the pre-filled Google Form is submitted for each student, an Edit URL and entered F&P level will populate the row will turn green. It may take as long as 15 minutes for the dashboard to update after scores are entered into Google Forms. Teachers can revisit the form they completed for the student by using the student's edit URL link listed on the report pages to make changes. To AVOID MAKING DUPLICATE RECORDS, only use the Pre-filled Google Form link one time per student, and USE THE EDIT URL FOR MAKING CHANGES.
The best way to fill out the Google Forms for each student is to filter the first page of the dashboard by School and Grade Level and export the student data to a Google Sheet. Users can do this by clicking on the kabab menu (three vertical dots) in the upper right-hand corner of the student list chart and then selecting Export and Google Sheets (see the example video to the left). Grade-level teacher teams can use the Google Sheet they exported to track their progress in filling out the forms with color highlights or strike-through formatting or by adding a column and using "X's" or checkboxes. This method also helps us avoid entering duplicate entries.
The second page displays the F&P Data that our classroom reading teachers have entered for each child for each benchmark (Fall, Winter, and Spring). We will add new pages and Google Forms for each benchmark as we progress through the school year.
Please remember that it can take up to 15 minutes for data to show up on Page 2 of the F&P Reading Data Dashboard after Google Forms are submitted and to submit only one Google Form per student to avoid the creation of duplicate records.