Bubble Map Maker
To access the Bubble Map Maker, hover over the upper right corner of the embedded Google Sheet below and click on the arrow in the gray box.
This will open a spreadsheet in Google Sheets that you can copy or download and then use with your own data*.
In order to fill out the green cells in the spreadsheet table, first code a video clip to mark the number of instances when each mode is used. Next add up the total number of instances for each mode and the total duration (in minutes) for each mode, and whether using the mode required high or low levels of attention by the participants. Each mode will have 3 numbers: frequency, duration, and attention.
For the data you enter, this interactive Bubble Map Maker will display a visualization that immediately shows the relationships among modes (i.e., modal density): which modes are more/less frequent, more/less sustained over time, and how much relative attention they require.
Enter your data only in the green cells. Do not alter the gray cells or the chart becasue the gray cells and the chart auto-fill from the data you enter.
You can leave blank any modes in the chart that are not important to your analysis. If you don't see a mode you need, you can add more modes at the bottom rows of the table. Next for each mode, type the number of clips (column B), level of attention (Column D), and number of minutes (Column F) directly into the green cells in the table below. When all your data are entered, scroll down and you'll see a bubble chart emerge as the Google spreadsheet auto-generates.
*For more details on using, customizing, and building your own bubble maps using Excel, go to the Comparing Modes video walkthrough here. For more background on comparing modes and analyzing activity through modal density and modal mapping, see chapter 5 in Literacies That Move and Matter.