{"id":155,"date":"2020-03-08T00:13:45","date_gmt":"2020-03-08T00:13:45","guid":{"rendered":"https:\/\/integrations.pressbooks.network\/demobook\/chapter\/how-to-google-forms\/"},"modified":"2020-04-30T16:12:24","modified_gmt":"2020-04-30T16:12:24","slug":"how-to-google-forms","status":"publish","type":"chapter","link":"https:\/\/integrations.pressbooks.network\/demobook\/chapter\/how-to-google-forms\/","title":{"raw":"How-To Guide: Embed Google Poll and Results Into Pressbooks","rendered":"How-To Guide: Embed Google Poll and Results Into Pressbooks"},"content":{"raw":"

Part 0: Create a Spreadsheet To Store Your Google Form Data<\/h1>\n

Step 0.1: Update your Google forms \"Responses\" settings<\/strong><\/h2>\nWhen you're creating a Google Form, the top of the page will give you the chance to edit questions and set up how your responses will be recorded. Click on the \"responses\" tab to configure these options.\n\n\"Google<\/a>\n

Step 0.2: Send your form responses to a spreadsheet<\/strong><\/h2>\nClick \"Create Spreadsheet.\"\n\nYou'll be presented with a \"Select Response Destination\" option. Choose the approach that works best for you -- (either to create a new spreadsheet or send your answers to a spreadsheet you've already created).\n\n\"options<\/a>\n\n \n

Part 1: Embed a Google Form into your textbook (web-only)<\/h1>\n

Step 1.1: Navigate to the \"Send\" screen in Google Forms<\/strong><\/h2>\nWhen you're logged into the Google account for a form you created, you should see a \"Send\" button at the top of the screen. (This may take the form of a button labeled \"send\" or a small paper airplane icon.)\n\n \n\n\"Google<\/a>\n

Step 1.2<\/strong>: Find the \"Embed\" section of your \"Send Form\" popup<\/h2>\nClicking on \"Send Form\" will take you to a screen with different tabs you can use to send your form to someone. Your \"Send via\" options are email, link, or embed.\n\nClick on \"Embed.\"\n\n \n\n\"Google<\/a>\n

<\/h2>\n

Step 1.3<\/strong>: Copy the HTML embed code for your form<\/h2>\nOnce you've clicked \"embed,\" you'll have access to HTML iframe embed code. You can change the display width and height if you choose.\n\nNext, click \"copy.\"\n\n\"\"<\/a>\n

Step 1.4: Embed your form embed code into Pressbooks<\/h2>\nReturn to the editing page for the Pressbooks chapter where you want to embed your Google form.\n\nYou'll need to paste your iframe code into the HTML text editor rather than to the visual editor. (Click on the \"Text\" tab in the top right of your editing panel to see the HTML editor)\n

\"Pressbooks<\/a><\/p>\n\n

Part 2: Convert Google Form Results Into Live Poll Displays<\/h1>\n
You can explore the formatting of the spreadsheet we used for this example by clicking on this spreadsheet example link<\/strong><\/a>.[footnote]In the example spreadsheet provided, you'll see duplicate tables and chart displays. There are duplicate displays in this example because we were creating chart outputs of two different sizes--one for the annotation layer and one for the larger display. Unfortunately, Google doesn't let you send information from one table to two different charts.[\/footnote]<\/div>\n

Context<\/strong>:<\/h2>\nTo create live<\/em> form displays, you'll need to create charts in the Google Sheets form destination you've created.\n\nHere's an example of what you might see when you open up your Google Sheets responses form:<\/span><\/strong>\n<\/colgroup>\n\n\n\n\n
Timestamp<\/strong><\/td>\nWhich types of texts do you annotate?<\/strong><\/td>\nDo you write in library books?<\/strong><\/td>\nWhich media do you use?<\/strong><\/td>\n\n
\n
For what reasons do you write in books?<\/strong><\/div>\n<\/div><\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
5\/17\/2019 19:34:43<\/td>\nTextbooks, Novels, Ebooks, Nonfiction books<\/td>\nOnly in pencil.<\/td>\nPencil, Ink pens, Highlighter, Electronic type<\/td>\n\n
\n
Study\/notetaking, Decoration, Boredom, To focus, To mock, To express admiration, To argue, To make grocery lists, Other<\/div>\n<\/div><\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
5\/19\/2019 9:53:29<\/td>\nTextbooks, Ebooks, Nonfiction books, Magazines<\/td>\nNever!<\/td>\nPencil, Ink pens, Highlighter, Electronic type, Post its<\/td>\n\n
\n
Study\/notetaking, To focus, To mock, To express admiration, To argue, Other<\/div>\n<\/div><\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\nThe first column (above) logs each survey response's timestamp. The following columns detail what each respondent answered on different single-select or multiple-select questions.\n\nThe steps below will describe how to take this non-numerical information and turn it into something you can display as a graph.\n\n \n

Step 2.0: Identify each section you want to convert into a graph.<\/strong><\/h2>\nContext<\/strong>: Google Forms records information as a list within columns, but to customize charts to display information from your polls, you'll want to create tables that record numerical information. The examples below illustrate the difference between the kinds of formatting you'll have in your Google spreadsheet and the kind of table that will allow you to create a live, embeddable chart.\n

Single-Select Responses<\/h3>\n
\n\nThe formatting we have<\/em>:\u00a0<\/strong>\n\n\n\n\n\n\n\n\n\n\n\n
Response #<\/td>\nDo you write in library books?<\/strong><\/td>\n<\/tr>\n
1<\/td>\nOnly in pencil.<\/td>\n<\/tr>\n
2<\/td>\nNever!<\/td>\n<\/tr>\n
3<\/td>\nNever!<\/td>\n<\/tr>\n
4<\/td>\nNever!<\/td>\n<\/tr>\n
5<\/td>\nOnly in pencil.<\/td>\n<\/tr>\n
6<\/td>\nOnly in pencil.<\/td>\n<\/tr>\n
7<\/td>\nNever!<\/td>\n<\/tr>\n
8<\/td>\nNever!<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\nThe formatting we want instead<\/em>:<\/strong>\n\n\n\n\n\n\n
Do you write in library books? (Responses)<\/strong><\/td>\nTOTALS<\/strong><\/td>\n<\/tr>\n
Never!<\/td>\n5<\/td>\n<\/tr>\n
Only in pencil.<\/td>\n3<\/td>\n<\/tr>\n
Yes, in ink.<\/td>\n0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/h3>\n<\/div>\n \n\nMultiple-Select Responses<\/span>\n
\n\nThe formatting we have<\/em>:\u00a0<\/strong>\n\n\n\n\n\n\n\n\n\n\n\n
Response #<\/td>\nDo you write in library books?<\/strong><\/td>\n<\/tr>\n
1<\/td>\nStudy\/notetaking, Decoration, Boredom, To focus, To mock, To express admiration, To argue, To make grocery lists, Other<\/td>\n<\/tr>\n
2<\/td>\nStudy\/notetaking, To express admiration, To argue<\/td>\n<\/tr>\n
3<\/td>\nStudy\/notetaking, To focus<\/td>\n<\/tr>\n
4<\/td>\nStudy\/notetaking, To focus, To express admiration, To argue, Other<\/td>\n<\/tr>\n
5<\/td>\n\n
\n
Study\/notetaking, To focus, To mock, To express admiration, To argue, Other<\/div>\n<\/div><\/td>\n<\/tr>\n
6<\/td>\nOnly in pencil.<\/td>\n<\/tr>\n
7<\/td>\nNever!<\/td>\n<\/tr>\n
8<\/td>\nNever!<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\nThe formatting we want instead<\/em>:<\/strong>\n\n\n\n\n\n\n\n\n\n\n\n\n
For what reasons do you write in books?<\/strong><\/td>\nTOTALS<\/strong><\/td>\n<\/tr>\n
Study\/notetaking<\/td>\n8<\/td>\n<\/tr>\n
Decoration<\/td>\n1<\/td>\n<\/tr>\n
Boredom<\/td>\n1<\/td>\n<\/tr>\n
To focus<\/td>\n5<\/td>\n<\/tr>\n
To mock<\/td>\n5<\/td>\n<\/tr>\n
To express admiration<\/td>\n4<\/td>\n<\/tr>\n
To argue<\/td>\n7<\/td>\n<\/tr>\n
To make grocery lists<\/td>\n1<\/td>\n<\/tr>\n
Other<\/td>\n4<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\nStep 2.1: Create a table for each section you want to convert into a graph.<\/strong>\n\nTo move from the data arrangement you have<\/em> to the data arrangement you want<\/em>\u2014<\/em>and most importantly,\u00a0<\/em>to do so in a way that will automatically update when new responses come in\u2014<\/em>you can create a series of tables to the right of where Google Forms is populating your data.\n\nFor example, in the Google form spreadsheet<\/strong><\/a> I'm working on in this instance, form data is coming into Columns A, B, C, D, and E, so I don't want to add any text to those columns because that's where new form responses are going to be recorded. However, adding information to any columns past Column E (for instance, Column F, G, H, I, etc.) won't do any harm, so I'll use that space to add new information.\n\nIn the example below, I've added a series of new tables to Column J and Column K. In each table, I've made a row for each possible selection in my survey. (For example, \"Ebooks,\" \"Nonfiction Books,\" and \"Newspapers\" each gets its own row.)\n

\u00a0\"three<\/a><\/p>\n\n

Step 2.2: Use a \"COUNTIF\" function to populate each \"TOTALS\" value cell in your survey tables.<\/strong><\/h2>\nWhat isn't<\/em> apparent in the screenshot above is that I haven't counted up the examples in the TOTALS section by hand. Instead, I've used a Google Sheets function to ask the program to count each response for me and to keep this count up to date when new entries come in.\n\nSo, let's assume I want each of my new tables to count the number of responses recorded for each category of interest. (For example, in the \"Which media do you use?\" table, I want the \"Totals\" cell in the row marked \"pencil\" to log how many people said they use a pencil to write in books.)\n\nTo make this possible, I'll add a function string in each cell within the \"totals\" row. The textbox below includes the basic function I'm using for this. I've added the placeholders \"Starting Cell: Ending Cell\" and \"[Category to count]\" so you can adapt them to your own purposes.\n
\n
=<\/span>COUNTIF<\/span>(<\/span>[Starting Cell]<\/span>:<\/span>[Ending Cell]<\/span><\/em>,<\/span> CONCATENATE<\/span>(<\/span>\"*\"<\/span>,<\/span> \"[Category to count]<\/em><\/span>\"<\/span>,<\/span> \"*\"<\/span>)<\/span>)<\/span><\/div><\/blockquote>\nHere's what this looks like in practice:<\/strong>\n\n \n\n[caption id=\"attachment_1040\" align=\"aligncenter\" width=\"1100\"]\"Spreadsheet<\/a> To count the number of surveys that reported people writing in novels, I'll use the function \"=COUNTIF(B2:B1013<\/span>, CONCATENATE(\"*\", \"Novels<\/span>\", \"*\"))\"[\/caption]\n\n \n\n[caption id=\"attachment_1041\" align=\"aligncenter\" width=\"1310\"]\"Spreadsheet<\/a> To count the number of surveys that reported people writing in textbooks, I'll use the function \"=COUNTIF(B2:B1013<\/span>, CONCATENATE(\"*\", \"Textbooks<\/span>\", \"*\"))\"[\/caption]\n\n \n\nAn explanation of the starting\/ending cells in this example--(B2:B1013)<\/strong>\n\nIn my worksheet example, the information I want to record is being put into Column B.\n\nAs my \"Starting Cell,<\/span>\" I'll use the first cell where my information is being recorded. (In this case, B2<\/em>). As my \"Ending Cell<\/span>,\" I'll pick a cell far down the very same column. In this example, I've chosen to use cell B1013<\/em>. (This is a pretty arbitrary number in this case. I simply picked a number that seemed improbably high. I'd be delighted if 1,013 people responded to this survey, but it'd probably take a long time for this to happen, so it's a safe bet to use that as the cell where Google will stop counting up responses.)\n

Step 2.3: Use Table Data To Create Chart Displays<\/strong><\/h2>\nClick \"Insert\" > \"Chart\" and use each separate table as the basis for a display.\n

\"Google<\/a><\/h1>\nYou can customize what kind of chart you want to have and what should count as headers, labels, etc.\n

\"Google<\/a><\/p>\nThis is an example of the resulting chart:\n\n\"Screenshot<\/a>\n

Part 3: Embed Poll Displays Into H5P Activities<\/h1>\nStep 3.1<\/strong>: To display a version of this chart that will live-update in your book, you'll want to start by copying the Google Forms link to the responsive version of your chart.\n\nTo find this link, click on the three-dot menu icon at the corner of your chart.\n

\"Google<\/a><\/p>\nNext, click on the \"Publish Chart<\/strong>\" dropdown option.\n\nYou'll see a screen that allows you to choose how your link will act when users click on it. I like to make sure that my own charts are labeled \"interactive\" (to display additional information on mouseover) and to check the box marked \"Automatically republish when changes are made.\" Copy the resulting link.\u00a0<\/strong>\n\n\"the<\/a>\n\nStep 3.2<\/strong>: Create an H5P Iframe Embedder activity<\/a> and add the link you've copied to the \"Source\" textbox.\n\n\"H5P<\/a>\n\nStep 3.3<\/strong>: Add your H5P activity to your text.\n\nHere's an example of what we just made:\n\n[h5p id=\"32\"]","rendered":"

Part 0: Create a Spreadsheet To Store Your Google Form Data<\/h1>\n

Step 0.1: Update your Google forms “Responses” settings<\/strong><\/h2>\n

When you’re creating a Google Form, the top of the page will give you the chance to edit questions and set up how your responses will be recorded. Click on the “responses” tab to configure these options.<\/p>\n

\"Google<\/a><\/p>\n

Step 0.2: Send your form responses to a spreadsheet<\/strong><\/h2>\n

Click “Create Spreadsheet.”<\/p>\n

You’ll be presented with a “Select Response Destination” option. Choose the approach that works best for you — (either to create a new spreadsheet or send your answers to a spreadsheet you’ve already created).<\/p>\n

\"options<\/a><\/p>\n

 <\/p>\n

Part 1: Embed a Google Form into your textbook (web-only)<\/h1>\n

Step 1.1: Navigate to the “Send” screen in Google Forms<\/strong><\/h2>\n

When you’re logged into the Google account for a form you created, you should see a “Send” button at the top of the screen. (This may take the form of a button labeled “send” or a small paper airplane icon.)<\/p>\n

 <\/p>\n

\"Google<\/a><\/p>\n

Step 1.2<\/strong>: Find the “Embed” section of your “Send Form” popup<\/h2>\n

Clicking on “Send Form” will take you to a screen with different tabs you can use to send your form to someone. Your “Send via” options are email, link, or embed.<\/p>\n

Click on “Embed.”<\/p>\n

 <\/p>\n

\"Google<\/a><\/p>\n

<\/h2>\n

Step 1.3<\/strong>: Copy the HTML embed code for your form<\/h2>\n

Once you’ve clicked “embed,” you’ll have access to HTML iframe embed code. You can change the display width and height if you choose.<\/p>\n

Next, click “copy.”<\/p>\n

\"\"<\/a><\/p>\n

Step 1.4: Embed your form embed code into Pressbooks<\/h2>\n

Return to the editing page for the Pressbooks chapter where you want to embed your Google form.<\/p>\n

You’ll need to paste your iframe code into the HTML text editor rather than to the visual editor. (Click on the “Text” tab in the top right of your editing panel to see the HTML editor)<\/p>\n

\"Pressbooks<\/a><\/p>\n

Part 2: Convert Google Form Results Into Live Poll Displays<\/h1>\n
You can explore the formatting of the spreadsheet we used for this example by clicking on this spreadsheet example link<\/strong><\/a>.[1]<\/sup><\/a><\/div>\n

Context<\/strong>:<\/h2>\n

To create live<\/em> form displays, you’ll need to create charts in the Google Sheets form destination you’ve created.<\/p>\n

Here’s an example of what you might see when you open up your Google Sheets responses form:<\/span><\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n
Timestamp<\/strong><\/td>\nWhich types of texts do you annotate?<\/strong><\/td>\nDo you write in library books?<\/strong><\/td>\nWhich media do you use?<\/strong><\/td>\n\n
\n
For what reasons do you write in books?<\/strong><\/div>\n<\/div>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
5\/17\/2019 19:34:43<\/td>\nTextbooks, Novels, Ebooks, Nonfiction books<\/td>\nOnly in pencil.<\/td>\nPencil, Ink pens, Highlighter, Electronic type<\/td>\n\n
\n
Study\/notetaking, Decoration, Boredom, To focus, To mock, To express admiration, To argue, To make grocery lists, Other<\/div>\n<\/div>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
5\/19\/2019 9:53:29<\/td>\nTextbooks, Ebooks, Nonfiction books, Magazines<\/td>\nNever!<\/td>\nPencil, Ink pens, Highlighter, Electronic type, Post its<\/td>\n\n
\n
Study\/notetaking, To focus, To mock, To express admiration, To argue, Other<\/div>\n<\/div>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The first column (above) logs each survey response’s timestamp. The following columns detail what each respondent answered on different single-select or multiple-select questions.<\/p>\n

The steps below will describe how to take this non-numerical information and turn it into something you can display as a graph.<\/p>\n

 <\/p>\n

Step 2.0: Identify each section you want to convert into a graph.<\/strong><\/h2>\n

Context<\/strong>: Google Forms records information as a list within columns, but to customize charts to display information from your polls, you’ll want to create tables that record numerical information. The examples below illustrate the difference between the kinds of formatting you’ll have in your Google spreadsheet and the kind of table that will allow you to create a live, embeddable chart.<\/p>\n

Single-Select Responses<\/h3>\n
\n

The formatting we have<\/em>:\u00a0<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Response #<\/td>\nDo you write in library books?<\/strong><\/td>\n<\/tr>\n
1<\/td>\nOnly in pencil.<\/td>\n<\/tr>\n
2<\/td>\nNever!<\/td>\n<\/tr>\n
3<\/td>\nNever!<\/td>\n<\/tr>\n
4<\/td>\nNever!<\/td>\n<\/tr>\n
5<\/td>\nOnly in pencil.<\/td>\n<\/tr>\n
6<\/td>\nOnly in pencil.<\/td>\n<\/tr>\n
7<\/td>\nNever!<\/td>\n<\/tr>\n
8<\/td>\nNever!<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The formatting we want instead<\/em>:<\/strong><\/p>\n\n\n\n\n\n\n
Do you write in library books? (Responses)<\/strong><\/td>\nTOTALS<\/strong><\/td>\n<\/tr>\n
Never!<\/td>\n5<\/td>\n<\/tr>\n
Only in pencil.<\/td>\n3<\/td>\n<\/tr>\n
Yes, in ink.<\/td>\n0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/h3>\n<\/div>\n

 <\/p>\n

Multiple-Select Responses<\/span><\/p>\n

\n

The formatting we have<\/em>:\u00a0<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Response #<\/td>\nDo you write in library books?<\/strong><\/td>\n<\/tr>\n
1<\/td>\nStudy\/notetaking, Decoration, Boredom, To focus, To mock, To express admiration, To argue, To make grocery lists, Other<\/td>\n<\/tr>\n
2<\/td>\nStudy\/notetaking, To express admiration, To argue<\/td>\n<\/tr>\n
3<\/td>\nStudy\/notetaking, To focus<\/td>\n<\/tr>\n
4<\/td>\nStudy\/notetaking, To focus, To express admiration, To argue, Other<\/td>\n<\/tr>\n
5<\/td>\n\n
\n
Study\/notetaking, To focus, To mock, To express admiration, To argue, Other<\/div>\n<\/div>\n<\/td>\n<\/tr>\n
6<\/td>\nOnly in pencil.<\/td>\n<\/tr>\n
7<\/td>\nNever!<\/td>\n<\/tr>\n
8<\/td>\nNever!<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The formatting we want instead<\/em>:<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
For what reasons do you write in books?<\/strong><\/td>\nTOTALS<\/strong><\/td>\n<\/tr>\n
Study\/notetaking<\/td>\n8<\/td>\n<\/tr>\n
Decoration<\/td>\n1<\/td>\n<\/tr>\n
Boredom<\/td>\n1<\/td>\n<\/tr>\n
To focus<\/td>\n5<\/td>\n<\/tr>\n
To mock<\/td>\n5<\/td>\n<\/tr>\n
To express admiration<\/td>\n4<\/td>\n<\/tr>\n
To argue<\/td>\n7<\/td>\n<\/tr>\n
To make grocery lists<\/td>\n1<\/td>\n<\/tr>\n
Other<\/td>\n4<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Step 2.1: Create a table for each section you want to convert into a graph.<\/strong><\/p>\n

To move from the data arrangement you have<\/em> to the data arrangement you want<\/em>\u2014<\/em>and most importantly,\u00a0<\/em>to do so in a way that will automatically update when new responses come in\u2014<\/em>you can create a series of tables to the right of where Google Forms is populating your data.<\/p>\n

For example, in the Google form spreadsheet<\/strong><\/a> I’m working on in this instance, form data is coming into Columns A, B, C, D, and E, so I don’t want to add any text to those columns because that’s where new form responses are going to be recorded. However, adding information to any columns past Column E (for instance, Column F, G, H, I, etc.) won’t do any harm, so I’ll use that space to add new information.<\/p>\n

In the example below, I’ve added a series of new tables to Column J and Column K. In each table, I’ve made a row for each possible selection in my survey. (For example, “Ebooks,” “Nonfiction Books,” and “Newspapers” each gets its own row.)<\/p>\n

\u00a0\"three<\/a><\/p>\n

Step 2.2: Use a “COUNTIF” function to populate each “TOTALS” value cell in your survey tables.<\/strong><\/h2>\n

What isn’t<\/em> apparent in the screenshot above is that I haven’t counted up the examples in the TOTALS section by hand. Instead, I’ve used a Google Sheets function to ask the program to count each response for me and to keep this count up to date when new entries come in.<\/p>\n

So, let’s assume I want each of my new tables to count the number of responses recorded for each category of interest. (For example, in the “Which media do you use?” table, I want the “Totals” cell in the row marked “pencil” to log how many people said they use a pencil to write in books.)<\/p>\n

To make this possible, I’ll add a function string in each cell within the “totals” row. The textbox below includes the basic function I’m using for this. I’ve added the placeholders “Starting Cell: Ending Cell” and “[Category to count]” so you can adapt them to your own purposes.<\/p>\n

\n
=<\/span>COUNTIF<\/span>(<\/span>[Starting Cell]<\/span>:<\/span>[Ending Cell]<\/span><\/em>,<\/span> CONCATENATE<\/span>(<\/span>“*”<\/span>,<\/span> “[Category to count]<\/em><\/span>“<\/span>,<\/span> “*”<\/span>)<\/span>)<\/span><\/div>\n<\/blockquote>\n

Here’s what this looks like in practice:<\/strong><\/p>\n

 <\/p>\n

\"Spreadsheet<\/a>
To count the number of surveys that reported people writing in novels, I’ll use the function “=COUNTIF(B2:B1013<\/span>, CONCATENATE(“*”, “Novels<\/span>“, “*”))”<\/figcaption><\/figure>\n

 <\/p>\n

\"Spreadsheet<\/a>
To count the number of surveys that reported people writing in textbooks, I’ll use the function “=COUNTIF(B2:B1013<\/span>, CONCATENATE(“*”, “Textbooks<\/span>“, “*”))”<\/figcaption><\/figure>\n

 <\/p>\n

An explanation of the starting\/ending cells in this example–(B2:B1013)<\/strong><\/p>\n

In my worksheet example, the information I want to record is being put into Column B.<\/p>\n

As my “Starting Cell,<\/span>” I’ll use the first cell where my information is being recorded. (In this case, B2<\/em>). As my “Ending Cell<\/span>,” I’ll pick a cell far down the very same column. In this example, I’ve chosen to use cell B1013<\/em>. (This is a pretty arbitrary number in this case. I simply picked a number that seemed improbably high. I’d be delighted if 1,013 people responded to this survey, but it’d probably take a long time for this to happen, so it’s a safe bet to use that as the cell where Google will stop counting up responses.)<\/p>\n

Step 2.3: Use Table Data To Create Chart Displays<\/strong><\/h2>\n

Click “Insert” > “Chart” and use each separate table as the basis for a display.<\/p>\n

\"Google<\/a><\/h1>\n

You can customize what kind of chart you want to have and what should count as headers, labels, etc.<\/p>\n

\"Google<\/a><\/p>\n

This is an example of the resulting chart:<\/p>\n

\"Screenshot<\/a><\/p>\n

Part 3: Embed Poll Displays Into H5P Activities<\/h1>\n

Step 3.1<\/strong>: To display a version of this chart that will live-update in your book, you’ll want to start by copying the Google Forms link to the responsive version of your chart.<\/p>\n

To find this link, click on the three-dot menu icon at the corner of your chart.<\/p>\n

\"Google<\/a><\/p>\n

Next, click on the “Publish Chart<\/strong>” dropdown option.<\/p>\n

You’ll see a screen that allows you to choose how your link will act when users click on it. I like to make sure that my own charts are labeled “interactive” (to display additional information on mouseover) and to check the box marked “Automatically republish when changes are made.” Copy the resulting link.\u00a0<\/strong><\/p>\n

\"the<\/a><\/p>\n

Step 3.2<\/strong>: Create an H5P Iframe Embedder activity<\/a> and add the link you’ve copied to the “Source” textbox.<\/p>\n

\"H5P<\/a><\/p>\n

Step 3.3<\/strong>: Add your H5P activity to your text.<\/p>\n

Here’s an example of what we just made:<\/p>\n

\n
<\/div>\n<\/div>\n
  1. In the example spreadsheet provided, you'll see duplicate tables and chart displays. There are duplicate displays in this example because we were creating chart outputs of two different sizes--one for the annotation layer and one for the larger display. Unfortunately, Google doesn't let you send information from one table to two different charts. ↵<\/a><\/li><\/ol><\/div>","protected":false},"author":14,"menu_order":6,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":["naomi-salmon"],"pb_section_license":"cc-by"},"chapter-type":[],"contributor":[61],"license":[52],"class_list":["post-155","chapter","type-chapter","status-publish","hentry","contributor-naomi-salmon","license-cc-by"],"part":135,"_links":{"self":[{"href":"https:\/\/integrations.pressbooks.network\/demobook\/wp-json\/pressbooks\/v2\/chapters\/155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/integrations.pressbooks.network\/demobook\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/integrations.pressbooks.network\/demobook\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/integrations.pressbooks.network\/demobook\/wp-json\/wp\/v2\/users\/14"}],"version-history":[{"count":2,"href":"https:\/\/integrations.pressbooks.network\/demobook\/wp-json\/pressbooks\/v2\/chapters\/155\/revisions"}],"predecessor-version":[{"id":238,"href":"https:\/\/integrations.pressbooks.network\/demobook\/wp-json\/pressbooks\/v2\/chapters\/155\/revisions\/238"}],"part":[{"href":"https:\/\/integrations.pressbooks.network\/demobook\/wp-json\/pressbooks\/v2\/parts\/135"}],"metadata":[{"href":"https:\/\/integrations.pressbooks.network\/demobook\/wp-json\/pressbooks\/v2\/chapters\/155\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/integrations.pressbooks.network\/demobook\/wp-json\/wp\/v2\/media?parent=155"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/integrations.pressbooks.network\/demobook\/wp-json\/pressbooks\/v2\/chapter-type?post=155"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/integrations.pressbooks.network\/demobook\/wp-json\/wp\/v2\/contributor?post=155"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/integrations.pressbooks.network\/demobook\/wp-json\/wp\/v2\/license?post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}