Google Forms to Quiz
So I tried to create a form today and was asked if I wanted to change it to a quiz... So I investigated.
The fact that the gear in the upper right was highlighted told me to click it. Here is what I found.
What?! There are 2 new tabs in here... Presentation and Quizzes. Like Alice, I traveled deeper down the rabbit hole.
This appeared to be just like the old new forms. Thought it was something about google slides. Apparently, it is the presentation of the form. How is it presented to the person filling it out.
Dreams = crushed.
Hoping for better, I lurched my mouse to the quizzes tab. That was where the magic happened.
There are options for emailing respondents their quiz scores or releasing scores after teacher review. This means that there must be a way to assign points to each response... There are also options for what students get after they submit their scores.
I wait with bated breath. What secrets lie ahead.
That is right, I wrote a question. Check it out.
I filled out the Form. The question has the point value next to it. See!
When I was done I got my confirmation page. I had the setting checked to give feedback immediately. Here is what it said.
What happens when you click that?
Notice that the things shown correspond to the options that I checked for this quiz. Guessing that this changes based on what you have checked with your quiz.
What is the moral of the story?
Click that Dang Button!
To figure out what the other things do, go and create your own. Change the settings and figure out what it does. Not that I am trying to be a jerk, but clicking the button is fun.
via Blogger http://ift.tt/29dHQsC
June 30, 2016 at 02:09PM
Number formatting in Google Sheets
There are plenty of number formatting types in google sheets (and you can always copy them from excel and add more custom ones if needed), but that is not my issue.
The issue here is that these formatting options go away when a sheet is copied. Unless the cell is not blank.
So if you highlight a cell and make a specific number format, you can later go into the cell and add a number, it will fit that format.
But that only works if you have not made a copy of the sheet.
Why would you make a copy of the sheet? What if I am giving out the sheet to a group of students or collaborating on a document that always has the same start point (you know, a template).
Put a number in the cell, in the template!
The trick is to have a number in the cell, in the template. Just add zero, or 1, 2, 3, or 4. Then when you make a copy of the sheet, because the cell is not empty, it will keep the number formatting.
And you can fill them in with the correct numbers on the new copy of the template.
The more you know.
via Blogger http://ift.tt/29bfIEJ
June 30, 2016 at 09:59AM
Onetab - a must have for Twitter chats
I love Twitter chats. As innovative educators we can get complacent with being seen as innovative in a small group, on a school campus, or in a school district. In reality, how are we beyond our campus, district, or particular situation. The members of my PLN (professional learning network) inspire, challenge, and motivate me to try new things and apply what I have done in other ways. They also teach me through our conversations. Truly amazing people who exemplify growth mindset, entrepreneurial spirit, and collaborative learning. In 1 hour, I learn more than I could articulate in 40 hours of work. Here are my favorites.
There are so many more, but I have a family and moderation is key to sustaining that.
So where does OneTab fit in?
How to... with OneTab
Go to the chrome webstore and download the extension to google chrome. Here is the link for it. Onetab takes all your open tabs and turns it into a single tab (onetab) with all the links to the resources that are currently open in your web browser.
This will save on this chrome account on your computer (will not be on another computer). The next time you open chrome on the computer, it is there.
I name the set of tabs and click Share as Webpage. This will turn the set of tabs into a webpage with a shareable link. I create a calendar event for later in the week, when I have time to look at these and I paste the link into the notes of the calendar event as well as reminder test to let me know the topic of the chat. This ensures that I revisit my train of thought and that the PD I have in my chat is not lost and gone.
via Blogger http://ift.tt/1ZYxnAG
June 18, 2016 at 08:22AM
Making Templates in Google Sheets
I was asked to create a google sheet template that every person in a department could edit. In speaking with the group, one of the major concerns was formatting. Different columns required different things:
The major issue with the spreadsheet was that the formatting was an issue. These documents are created every 2 weeks by a group of 15 people and they are made public record. Formatting and professional look is important. Here are some things that I was able to do to make their life easier in creating this.
In google sheets, if you highlight a group of cells and select underline, bold, italics, etc. it will apply that feature to current text. What if there is no text yet? The setting does not stay with the cell. This is where conditional formatting comes in.
I have used this for changing the cells colors when a certain condition is met. For this, the condition was "cell not empty."
Highlight the cells that you wish the formatting to apply and click Format > Conditional Formatting.
In the box on the right, select the green box near the bottom that says default and change to custom.
You can customize the color of the cell and font, the look of the font (Bold, Underline, Italic, Strike-through).
Not something for this example, but change the condition (Format cells if ...) to something else. You can do some pretty cool stuff with it.
Highlight the group of cells that you wish to apply a standard number format. Select the number format option .
For me the format was a date, MM/DD/YYYY. The option to the right doe not quite work. So I chose "More Formats" at the bottom. From here you can customize the date to have a leading zeroes on the month and day. This works for me.
Now that I have applied that to the cells, the format will stick. Type in:
I applied the same principal to monetary values as well.
Making Date Ranges
Dates are amazing, but you cannot concatenate (combine them as text with other dates to have pretty date ranges. Maybe not the biggest deal to some, but I am slightly AR when it comes to that stuff.
First - changing a date to text. You can do this with the text formula (yeah, I know, go figure). If the date is in A1, then the formula would look like this =text(A1, "MM/DD/YYYY") or whatever format you would like the date to be. Just make sure it is in the quotes.
Second - to concatenate (combine things in different cells) you use the "&" sign.
Putting it together - you can see in the picture above that I have the text formula 2 times. After the first one you see & which means I am joining that with something else. The quotes and dash ("-") is there because I want a dash between the 2 dates. The second & is because I then would like to add the second date to the cell. Here is the final product.
If I change the dates in cell A2 or B2, then the date range will change as well.
One other suggestion I have for you is to protect sheets or ranges. If there is a range that you would like to protect, highlight the cells and find Protected sheets and ranges in the Data menu. Protecting a range or a sheet means that it is uneditable.
Not everybody understands spreadsheets. Usually because there is so much that you can do with them and people are afraid of them. Save yourself the frustration and lock the cells that you would like others to leave alone.
I know there are so many things that you can do and I am just scratching the surface. The conditional formatting was not the first thing that I tried to format text in the template, so I figured I would share that.
For more comprehensive educational uses of Spreadsheets in education, I would consult Alice Keeler's Blog. For more information on Spreadsheets in general, try GCFLearnfree or Mr. Excel.
via Blogger http://ift.tt/268sCs5
June 17, 2016 at 04:40PM