Wiki Page, BLT Sem 2: Lesson 12 - Creating Charts

Wiki Page
2023-01-19T11:15:22-07:00

Essential Questions:

How are charts and graphics helpful in displaying data in Excel?

How do you determine which type of chart (bar, line, pie, etc.) to use to display your data to its best advantage?

Lesson Skill Matrix

Skills | Exam Objective | Objective No.
Building Charts | Create a new chart. | 5.1.1
Formatting the Parts of a Chart Manually | Add and modify chart elements. | 5.2.2
Modifying a Chart | Add additional data series | 5.1.2
| Switch between rows and columns in source data. | 5.1.3
| Move charts to a chart sheet. | 5.2.4
| Resize charts. | 5.2.1
| Apply chart layouts and styles. | 5.2.3
Using Quick Analysis Tools | Insert sparklines. | 2.3.1
| Analyze data by using Quick Analysis. | 5.1.4

Resources:

Lesson 12 eBook: Excel Lesson 12.pdf

Lesson 12 PPT: ExcelCore2016lesson12.pptx

GCF Video/Charts: https://youtu.be/_Wu7jYTr1Pk

Guided or Independent Practice:

We will review the tools and skills needed to complete the twenty-two (22) step-by-steps. You may then choose to work independently from the eBook or to follow instructions on the overhead screen at the front of the room.

You will find the necessary student data files in the Lesson 12 Step-by-step assignment. Submit the revised documents (any document with the word "Solution" in the title) through the Assignments page when you have completed all step-by-steps practice activities.

Complete Projects 1 and 2 found on page 245-246 of the eBook independently; refer to the eBook step-by-steps for details on how to accomplish each task, if needed. The data files you need can be found on the Lesson 9 Projects assignment page. Submit them through the Assignments link to the left.

Vocabulary: Describe each key word in the Lesson 12 Vocab assignment in your own words using the text entry box in the assignment window. Definitions copied from the eBook will not be accepted.

Quiz: Click the "Quizzes" link to the left to begin the multiple choice quiz for Lesson 12 when instructed to do so. All students complete quizzes at the same time.