A | B | D | E | F | G | H | I | J | |
---|---|---|---|---|---|---|---|---|---|
1 | Accomplishing Great Feats With Google Sheets! - 3 experience points. | ||||||||
2 | Below you will find several topics and tasks of varying levels. Each topic has a corresponding support page that will walk you through the topic as well as a task to complete. Feel free to use the "practice" sheet to complete your tasks. Once you have reviewed the topic and completed the task put an "X" in column "A." | ||||||||
3 | Check Off with an X | Topic # | Difficulty Level | XP | Title | Description | Badge Check Off | Support Page | Task Details |
4 | x | 1 | ★ | 1 | Create a Google Sheet! | Starting from ground 0....learn how to create a new sheet. | #REF! | Support Page | Task Details |
5 | 2 | ★★ | 4 | What's in a Name? | Brush up on some common terms associated with Google Sheets. | Support Page | Task Details | ||
6 | x | 3 | ★★★ | 2 | I Want It My Way | Discover how to format data you've added to a spreadsheet. | #REF! | Support Page | Task Details |
7 | 4 | ★★★★★ | 5 | Average, Sum, Count, & If, What's Your Function? | Use Formula and Functions including Sum, Average, Unique, Count, If | Support Page | Task Details | ||
8 | 5 | ★★★ | 3 | I Want It My Way (Part 2) | Arrange your data just the way you'd like with the sorting feature. | Support Page | Task Details | ||
9 | 6 | ★★★ | 3 | Chart How Awesome You Are With a Chart | Analyze the Data in a Google Sheet by inserting Charts and Graphs | Support Page | Task Details | ||
10 | 7 | ★★★ | 4 | How to be Trendy | Add a trendline to your data to recognize patterns. | Support Page | Task Details | ||
11 | 8 | ★★★★ | 4 | Add a chart, graph, or table to Google Docs | Discover how to insert a chart, graph, or table from Google Sheets into a Doc or Presentation. | Support Page | Task Details | ||
12 | 9 | ★★★ | 2 | It's Official! | Publish Results from a Google Sheet | Support Page | Task Details | ||
13 | 10 | ★★ | 2 | Why Work Alone? | Share your data with others to keep them informed. | Support Page | Task Details | ||
14 | 11 | ★★★★ | 4 | Hands Off! | Protect sheets and ranges in your datasheet to ensure your data does not get deleted or changed. | Support Page | Task Details | ||
15 | 12 | ★★★ | 3 | Label a Range | Learn how to label a range of cells in a datasheet. | Support Page | Task Details | ||
16 | 13 | ★★★★ | 4 | Too Much Data! | Use filters and filter views to see only the data you need. | Support Page | Task Details | ||
17 | 14 | ★★★★ | 4 | Sparklines: SparkNotes Version | Use Sparklines to show trand data in your spreadsheets. | Support Page | Task Details | ||
18 | 15 | ★★★ | 3 | Flubaroo Your Quiz! | Use Flubaroo to grade the responses to a Google Form | Support Page | Task Details | ||
19 | 16 | ★★★★ | 4 | Ooh! Pretty Colors! | Learn to take advantage of conditional formatting to draw attention to your data. | Support Page | Task Details | ||
20 | 17 | ★★★★★ | 5 | Pivot Your Stance on Pivot Tables | Use a pivot table to view a complex set of data quickly | Support Page | Task Details |