Q4 Party Planner: Charts
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.
I Can Statement
- create a chart from spreadsheet data
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.
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". Direct Link.
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.
- 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
- Google Docs Help Inserting a Chart in a Spreadsheet
- Google Sheets About
- Google Sheets Help
- Working with Charts using Excel
Videos from outside sources
- Excel Basics YouTube video
- Google Slides: Inserting Charts from Google Sheets YouTube video
- Charts Intro video
21t4s Documents & Quizzes
- PDF of steps for Q4 Insert a chart with Google Sheet
- PDF of steps for Q4 Insert a chart with Excel
- Vocabulary Quizlet