Technology to help each student and teacher to achieve personal excellence
Feb 16, 2016
Google Docs & Rubric Options | Orange Slice/Doc Appender
Jan 8, 2016
YouTube for Students: Instructional Ideas
Oct 9, 2015
New Sharing Options in Drive: Part 1 - How To
Teachers and students now have more freedom with their sharing options when working in Google Drive. Sharing options now exist that allow files to be shared with the public. Additionally, certain files can be “published” to the web, turning them into auto-updating websites based on the Google doc/slide/sheet. Let’s take at how to enable these new features in part 1 of this four part blog post series.
Sharing with the “public”
When sharing a file in Drive, you now have the additional choices seen below.
On - Public on the web. This option allows anyone on the web to find the document through internet search. This is NOT recommended or any of our educational applications.
On - Anyone with the link. This option allows anyone to view/edit/comment (your choice) if they are provided with the link to the document. This has a variety of educational applications that will be discussed in part 2 of this blog post.
[caption id="attachment_2764" align="aligncenter" width="300"]
Additionally, it is now important to note a few owner settings that are available. You can prevent people with editing rights to your file from changing who has access to the file, as well as prevent people with “commenting” or “viewing” rights from downloading, printing, or making a copy of the file. This is good for you and your students to understand if they want to really lock down their content and only allow others to view it, and nothing else.
[caption id="attachment_2765" align="aligncenter" width="300"]
Publishing to the web
With the option above, the owner is giving out a link to the original file that is stored in Google Drive. With the “Publish to the web” option, you are instead creating a webpage that is dedicated to that Google doc, sheet, or slide. One distinct advantage of this method is that you can then embed that doc/slide/sheet into another website (like schoolwires, CMS, etc…). Even better; this published document auto-updates when the original Google file is updated! More applications for this are discussed in part three of this blog post, but here is a quick example.
Watch the published Google Sheet of responses update automatically below (Forms are currently experiencing issues, so if this does not display for you, check back later)!
Follow these simple steps to publish a Google file to the web.
Click <File>
<Publish to the web>
Choose <link> or <embed>
Click <Publish>
You can choose additional options by clicking <Published content and settings>
This animation will play on a loop. You can also click on it to start it from the beginning in a new window.
Now that you know how to turn on these features, let’s take a look at how to leverage them for awesome educational experiences for students and increased communication with the community!
Part 2 - Public Link Sharing Ideas
Part 4 - Being Safe While Being Public
Sean Mullins | District Instructional Technology Coach
Sep 18, 2015
Instant Peer Feedback with Google Forms
Overview
With this feedback method, students will be filling out a Google Form to provide feedback to their peers. The feedback will then instantly appear in a Google Doc that the the original student can see and reflect upon. This system allows for anonymity and instant feedback, two things that are vitally important for students. But as the teacher, you can always see who provided what feedback so that you can manage anyone who is critical without reason. Here's how it works...
Setting Up the Google Doc Template
First, we need a file that will belong to each student and collect their feedback. We will create one in Google Docs and then push it out to all of our students via Google Classroom. Here is a sample of what this template can look like...
In this example, the template includes a prompt and space for the student to reflect on the feedback that they receive.
Feedback Form
docAppender Add-on
Create a new Google Form. Navigate to the top of the form where you will see a menu that is called Add-ons (Note: currently [9.18.15] the new version of Forms does not have the ability to use Add-ons. Revert to the old version if needed.). Open the Add-ons menu and choose Get New Add-ons. Search for the docAppender Add-on and add it by clicking on the +Free button. Finally, make sure that the Add-on sidebar is running. You may need to go back to the Add-ons menu > docAppender > Open Sidebar. In the end, your form should look like this.
Creating the Form
With the sidebar open, we can now finish creating our form. First, we need to add a question that will allow students to choose the person to whom they are providing feedback. That question is typically best as the "Choose from list" question type (see Question 1 in the image above). Second, we create feedback questions for the rest of our form. These typically follow a rubric that you have previously provided to students. Lastly, we follow the steps outlined in the docAppender sidebar.
- Choose the folder which holds all of the Google doc templates that your students have opened through Classroom. This will be the assignment folder for the assignment that you created in Classroom to push out the template to your students.
- Choose the question that determines which document the feedback is appended to. This is the "Choose from list" question that we created earlier. When you click "Save and populate selected question", docAppender creates an answer option to choose any of the docs that are present in the folder that you identified in Step 1.
- Choose the questions on your form that you want to be appended as feedback for the students. This allows you to, for example, require that every student provide their own name when giving feedback, but not push that name out to the presenter who is receiving the feedback. This way students can be anonymous to their classmates. But because you require everyone to provide their name on the form, the name will be displayed to you in the spreadsheet attached to this form. That way, you can allow for anonymity and still track responses if anything inappropriate occurs.
- Choose how the feedback will be displayed to students. I recommend "Rows in a single horizontal table".
Now you can make the form available to your students by putting the live form link on your CMS, Google Classroom, or web page. Below is an example of what the finalized feedback document would look like for a student.
This is an extremely valuable and flexible feedback system that has been universally praised by every teacher who I have worked with. If you are interested in trying it out, I highly recommend contacting your instructional technology coach to help walk through the process and provide support.
Sean Mullins | Instructional Technology Coach
Mar 16, 2015
Technology PDA Reflections
We appreciated being treated as professionals.
Working with coworkers. Exploration time. Help from instructor one-on-one. Everything was great.
Getting one-on-one help with specific questions is so much better than just being presented to.
The ability to determine the path/content of the PDA was refreshing, as was time to work and collaborate.
This was so personalized, since I got to choose what all to work on and go at my own pace.
For the fourth time I was privileged to serve as a PDA instructor for Using Technology to Engage and Inspire Your Students this spring; this time as an "advanced" section. The quotes above, which came from our feedback activities through CMS, epitomize what this PDA offers to our staff members. Technology should enable individualization, collaboration, and more time for one-on-one feedback. I am happy to report that this year's offering was a rousing success!
I thoroughly enjoyed my four weeks working with these 18 dedicated individuals. Their hard work and willingness to explore, ask questions, implement, fail, and implement again, led to dozens of success stories for their students. Here are a few examples of such successes...
Formative Assessments Through Kahoot!
Advanced Quiz Techniques and Course Streamlining in CMS
Padlet for Classroom Conversations
Exploring Google Classroom
Google Forms and Flubaroo for Automatically Graded Surveys and Formative Assessments
I am blown away every day with the passion and dedication that I see in our classrooms. Opportunities like these PDA's do not come around as often as I would like, so if you are interested in anything that you have seen here, make sure to sign up for our next PDA! Additionally, if you would like to hear about the details of these, or any other technology related classroom instructional techniques, please contact your district instructional technology coach today!
Sean Mullins | District Instructional Technology Coach
Oct 28, 2014
Google Forms: New Add-Ons Expand Functionality
Google has just announced that developers can start creating Add-Ons to Google Forms to further increase their flexibility and functionality. For instance, one of the first Add-Ons is called g(Math), and it can be used to embed mathematical expressions, graphs, or statistical models into a Google Form.
If you're a math teacher who has wanted to use Google Forms but found the lack of an equation editor a sticking point, this is the Add-On for you! More information about g(Math) can be found here.
formLimiter is another simple Add-On that performs a useful function that was previously missing from Google Forms. With this tool, you have the ability to limit the date and time that the form is available, as well as the number of responses that the form will accept. A good example of how this can be used is if you want to have a sign up for an activity, but can only allow 45 individuals to attend. formLimiter will close down your form once that limit has been reached. More information about formLimiter can be found here.
docAppender is an intriguing Add-On that allow you to take selected answers from your Google Form and append them to the bottom of Google Documents. Using an example is the best way to illustrate how this could be useful.
Let's say that you want to provide feedback to your students on a project that they are working on. You can share a Google Doc with them (perhaps it has the project rubric on it as well), use a Google Form in class as you observe their work to record your thoughts and observations, and when you submit the Google Form, the answers to your Form questions will be appended automatically to the bottom of the Google Doc that is shared with the kids. And what is great about this method is that you can choose which questions from your form get appended to the Google Doc. That means that you have have questions whose answers remain private to you, only showing up in the responses spreadsheet. Administrators could use this method with walkthroughs. Special Education teachers could use this method to collect data on their students by having each teacher fill in the form and then sharing the resulting Google Document when those who need it (possibly even the student).
Google Forms are incredibly powerful and the addition of Add-Ons will only expand their functionality and range of uses. There are other very exciting Add-Ons that will be discussed in future Teacher's Corner posts. For more details, you can view the official Google post here.
Sep 18, 2013
Google Forms Makes P.E. Teachers Ecstatic
Problem:
At the beginning of each semester, Physical Education teachers at the Junior High level have their students fill out a Rules and Regulations form. This makes the students and their parents aware of the expectations of P.E. The teachers then file hundreds of documents away in case the student/parent signature ever needs to be referenced. This becomes an organizational nightmare very quickly, not to mention all of the paper that is used!
Solution:
Using Google Forms, a virtual version of this form can be created so that all of the information is stored digitally and no paper is used!
How We Did It:
First, we had to create the form (visible here). This involved sitting down and deciding on the best way to take a paper form, which asked for check marks next to items to show agreement, and make it digital. Parents needed to check each box as they progressed through the form to indicate that they understood the expectation, and then type their name at the end of the form.
[caption id="attachment_1772" align="alignnone" width="150"]
The resulting data is stored in a Google Spreadsheet that can be filtered and sorted by P.E. teacher and class period. No more filing cabinet full of forms to sift through when an issue arises! Also, because the P.E. department will see nearly every student in the building during the course of the year, this process alone saved nearly two reams of paper.
~ Thank you to the P.E. department at EJHS for allowing me to work with you, and especially to Dana Curby, the brainchild of this wonderful process!