
Q4 Party Planner: Charts
Introduction
What if you want to see a simple visual of your party plans? The easiest way to visualize something quickly is to make a chart. This Quest will show you how simple it is to make a chart in either Google Sheets or Microsoft Excel.
(Link to PDF Directions) for Google.
PDF Directions for Excel
I Can Statement
- create a chart from spreadsheet data
Key Vocabulary
Chart: Charts are visual representations of worksheet data. Charts often make it easier to understand the data in a worksheet because users can easily pick out patterns and trends illustrated in the chart that are otherwise difficult to see.
Select: Select is the action where you use the mouse (or alternate) to click on a particular cell, image, or object on the screen.
Play the Vocabulary Game below to practice the Key Vocabulary.
Vocabulary Game
You can change the Quiz mode to Match, Test, Learn, Flash Cards, Spell using the selection list at the bottom right of the activity that says "Choose a Study Mode".
Steps
Using the directions above, complete the following:
Step 1 - Select the data you will include in your chart
Step 2 - Create and insert the chart as indicated in the PDF Directions provided.
Step 3 - Name the chart
Step 4 - Check with your teacher to see if you should turn it in yet or continue to the next section of Party Planning.
Note: There are many chart types to choose from.
Additional Resources
- Working with Charts Using Excel
- Excel Basics Video Tutorial
Check off this Quest on the 21t4s roadmap
Ready for Quest 5 Sharing Your Spreadsheet
Competencies & Standards
MITECS Michigan Integrated Technology Competencies for Students, and
3. Knowledge Constructor
c. Curate information from digital resources using a variety of tools and methods to create collections of artifacts that demonstrate meaningful connections or conclusions
5. Computational Thinker
b. Collect data or identify relevant data sets, use digital tools to analyze them, and represent data in various ways to facilitate problem-solving and decision making.
6. Creative Communicator
c. Communicate complex ideas clearly and effectively by creating or using a variety of digital objects such as visualizations, models or simulations
Websites and Documents
Websites
- Google Chart Help
- Google Docs Help Inserting a Chart in a Spreadsheet
- Google Sheets
- Google Sheets Help
- Working with Charts using Excel
21t4s Videos
21t4s Documents
Linked Videos from other sources