Creating Your Scholarship Target List

1 teachers like this lesson
Print Lesson


SWBAT complete a Google Form for the purpose of organizing their scholarship application requirement and prioritizing their own course work.

Big Idea

... it's time to find some college money - the goal is one semester's worth of "book money" ...

Introduction and Context

10 minutes

At the beginning of this lesson, I spend a few minutes, quickly reviewing the steps students have completed thus far, and I state that during today's lesson we will "get down to brass tacks" -- that is each student will commit to their final merit application choices.

At this point students have a rich data set for their potential scholarship applications: (1) they have identified their target schools; (2) they have identified university-based aid applications (as need be); (3) they have established profiles; (4) they have employed the profile search tool in order to identify several, possible merit scholarships.

Now, students need to commit to one or more actual application(s) -- for their own financial and personal reasons as well as for my course assessment.

Before proceeding to the next phase of this lesson, I ask students, after logging in, to open their accounts in a new tab in Chrome ...

Identifying Your Final Scholarship Choices

25 minutes

Once students have their profiles ready in a tab, I have them "tab back over" to my quarterly Slides presentation of daily activities and locate the link to this Google Form.  After loading the form in another new tab, I ask them to fill it out carefully.  This takes several minutes, as it is fairly detailed, and I circulate to assist as I can.

I have enabled "form editing" on my end, so students are able to edit this form whenever they may want to as long as they "bookmark" the form submission confirmation page.  (Unfortunately, the nature of our school domain structure does not allow teachers to create Google Forms that auto log student email/user names, and Forms will not generate an email confirmation for students to use or view.)

However, if students choose to save their form data after submitting it, they may do so by following the link to form edits (from the auto-generated confirmation page) and taking a screenshot of the resulting window.  (As a caveat, I do not generally allow the Forms I use with students to be editable by them after the fact, but, in this instance, I am not too too concerned about the "purity" of this data, as, really, logging this information is as much for them as it is for me ...)

Once each student has completed Scholarship Form #2 then it is time to share with me the working list ...

Sharing Your Final Working List

10 minutes

This final section of today's lesson is admittedly "overkill" as the data you will now collect has mostly been collected in Scholarship Form #2; however, I have found it useful to have a .pdf copy of the FULL target list available for student conferences, which is part of the final stage in this multi-stage application process.

For this final step, students will finalize their "target list" of scholarships at, and they will share this list (as a screenshot) with me via Google sharing.

Here are the steps to accomplish this, and the attached video is a screencast of this procedure.

Assuming you use Chrome and in order, then:

  1. after logging in to, students click on the "Scholarships" top tab
  2. then click on the "My Scholarship Matches" folder tab and expand (button at bottom of left hand column) to view the full list of matches
  3. students review their matches list and select 5 - 10 scholarships that they "Might Apply" for by changing the designation drop-down, found to the right of each match
  4. once students have sufficiently reviewed their full match list and have selected a few as "Might Apply" then students click on the "My Scholarship List" folder tab
  5. in this view students will see all of the scholarships they have just designated as "Might Apply" in one handy list
  6. with this new, shorter, target list showing in a browser window, students should launch the "print" command (from the toolbar drop-down or simply by right clicking on the page)
  7. in the browser's print dialogue window, students should choose the print destination "Save to Google Drive" and click save
  8. students should tab back or open to their Drive file list, find the newly uploaded screen shot and change the file name of this file to "First Name, Last Name, Period, ' target list'" 
  9. as the final step, students will share via Google Drive with me

After receiving 20 - 26 shared files per class period, I generally organize all of these into a folder for future reference.  When I conference with students (which is part of the process in the next lesson), I will use the new folder of student target lists (in .pdf) for handy reference.