Hi , Please sign in. I love to say hi back!! 🎟 The passcode is hialice
but you may still need alpaca for some premium addons.🇵🇪 I am headed to Peru to work with teachers on implementing student-centered strategies. I will also be giving a presentation on Google Apps Script in Spanish in Bolivia, so I have been practicing my Spanish daily. 🍀 Wish me luck! 📎Here is a link to a table, from the Premium Website, of past Premium Newsletters.
Quick and easy to find with the 2 hamsters 🐹🐹. 🐹🐹Premium Newsletters🐹🐹 PLEASE SIGN IN! I respond
THE PASSCODE IS hialice☀️ What Is Up This Week-
🖊️SIGN IN with the passcode hialice
-
📅 Be added to the events calendar for the week. (do this every week!)
- 🔺 Premium Features Add-on: Install Audience Participator
- 💧 Drip Workshop: Collaborative Tasks (Online course at your own pace)
5..🟢Tip #1: Explore Google Earth with Carmen SanDiego Icon. 6. 🌟Tip #2: Summarize Date: Make Pivot Tables with Google sheets 7.☑️Check alicekeelermembership.com with passcode hialice for resources & events. 8.⏺️ Webinar Recording with Alice: Writing an Essay with ChatGPT 9.⏺️ Webinar Recording with Alice: Coding with ChatGPT Live Workshop 7-6-23 10.⏺️ Webinar Recording with Marcia MENTORS: Seating Chart Add-on by Alice Keeler 🌟🌟 PREMIUM EVENTS THIS WEEK🌟🌟 11.💻 Join Live Coding with ChatGPT with Alice (week 4) Thurs. 7/13 2-3:00pm PST 12.📅 Join Office Hours with Alice: Thursday 7/13 3:15-3:45pm PST 13.☕ Join Coffee with Alice: Sunday 7/16 7-7:30am PST 14.💻 Live Webinar with Alice: Basics of Google Sheets Monday 7/17 10-10:30am PST 15.💻 Webinar with Alice: Google Classroom: Using Reuse GC Mon 7/17 11:15-12:15pm PST  Learn Geography! Explore Google Earth🌎
🔎Explore the Carmen SanDiego icon on Google Earth. 🎊It's a fun way to learn about geography. 
 Make Pivot Tables with 📗Google Sheets
📊Summarize Data with Pivot Tables👉Pivot tables in Google Sheets summarize data. They are super useful for teachers and happily really simple! 💥The first thing you need is data in a spreadsheet where information repeats. 🟩One of the easiest ways for this to happen is to use Google Forms with multiple choice options to ensure that the data is all spelled exactly the same way. 🔷Sample Pivot Table✔️I used this Google Form to collect data that I want to summarize. 👀Notice in the image below I used a pivot table to count how many responses there were for each option.
🟥Updated Tables♻️The default option when you create a pivot table is to have it automatically update. ✅You can turn this off, but notice in the image below that the same pivot table now summarizes 9 responses instead of 7. 
🖊️Highlight Your Data🟨In the spreadsheet of data, highlight the columns that contain information that you want to summarize. 🔵Use the Data menu to choose “Pivot table.” A new tab will automatically be created for the pivot table. 
🎛️Pivot Table Editor✋On the right hand side of the new tab is the Pivot Table Editor. 👀Notice the AI (Artificial Intelligence) provides suggestions for ways to summarize your data. ➡️Simply click on one of the suggestions if it seems helpful. Using the AI suggestion is obviously the easiest way to create a pivot table.
📈Rows🟨Click on the “Add” button next to the word “Rows” in the sidebar to choose the column that you want to summarize. ➡️In the sidebar click on the “Add” button next to “Values” to choose what values you to summarize. Pay attention to “Summarize by.” 🆘The Google Sheets Pivot Table Editor will automatically guess how you want to summarize the values. Did you want to count or sum? Tip to double check. 
Activity Stream
| 
