BTT1O - Selecting Data for Charts

Introduction

• Charts make data easier to understand. So firstly, charts should be neat and clear, well-labelled (series, axis, title) and readable (colours/size).
• But charts should also make people think about the data. Therefore, the charts should highlight something important, insightful or unusual.
• Charts should make people think. When you show what is happening with a professional chart and explain why it happened with thorough research, you have made a thoughtful project.

Chart Comparison

Which one of these charts highlights better information? Which one clearly shows changes that are happening in Canada?

or

Click here for a downloaded file of these charts. 

Discussion

• I think that the second one offers more choices for discussion:
• What is happening in Nova Scotia? https://www.google.ca/search?q=nova+scotia+population+change+2009..2013&oq=nova+scotia+population+change+2009..2013&aqs=chrome..69i57j0l3.13248j0j4&sourceid=chrome&espv=210&es_sm=119&ie=UTF-8
• Why is Alberta growing so much? https://www.google.ca/search?q=alberta+growth&cr=countryCA&espv=210&es_sm=119&biw=1271&bih=517&sa=X&ei=TtKvUuiBBsm62AXm-YC4CQ&ved=0CB4QpwUoBg&source=lnt&tbs=ctr%3AcountryCA%2Ccdr%3A1%2Ccd_min%3A2000%2
• What about Saskatchewan? https://www.google.ca/?gws_rd=cr&ei=2KOwUtKGDqrJygG9hoDgBw#q=saskatchewan+population&tbm=nws
  
• Saying something like "Saskatchewan is experiencing a surprising growth rate because it has the highest job vacancy rate in Canada" is informative and shares useful information with the reader. Remember to prove a citation from http://www.citethisforme.com.

BTT1O - Tuesday's Class

Typing

Print out your progress reports

MS Excel

Demonstration

Individual Work

1. Tables
2. Charts
3. Formulas: Click here for help with data entry

BTT1O - Excel Formulas

Today's Class

1. Typing in Ultra Key
2. Formulas Demonstration
3. Work on Excel

Formulas Example

Click here for the formulas spreadsheet for the demonstration.

BTT1O - Excel Charts

Sample Chart

Here is the chart for today's in-class demonstration.

Reminder

• Drop your table off (with your name) by Friday.
• We will finish the Chart activity on Monday

BTT1O - Introduction to Microsoft Excel

This page will introduce M.S. Excel and show you what a Grade 9 Assignment will look like (in terms of rubrics, learning goals, instructions and exemplars).

What is Microsoft Excel

• Microsoft Excel is a piece of software designed to organize data.

• Users can build tables, calculate formulas, and create charts to organize their information

• Excel shares many attributes with M.S. Word, such as the Menu Bar and Toolbars.
• The rest of the information is point and click.
• Information is written in Cells and Worksheets, instead of lines and paragraphs.
• Excel formulas perform calculations to save time and link cells from one worksheet to another for large spreadsheets.
• The correct extension for M.S. Excel is *.xls or *.xlsx
• Information in charts and tables is often better organized and easier to understand than a long paragraph of text.

Learning Goals

This is an Assessment as Learning activity. The objective of these three tasks is to:

• Apply M.S. Excel skills to display data in a clear and easy to understand format; and
• Utilize a variety of M.S. Excel formatting techniques to enhance the appearance of the information.

Success Criteria

I will know I am successful when:

• Information is entered accurately in M.S. Excel;
• It is easy to understand the data because it is properly displayed in tables and charts;
• Formulas are used to calculate values; and
• The fonts, colours, borders and shading are interesting but do not become excessive, overwhelming or hard to read.

Instructions

1. We will be working on M.S. Excel throughout the week. I will cover one topic each class on the board and there will be individual work time to practice.
2. Read the instructions in each file and complete each task individually:
   • Part 1: Tables (started on Wednesday February 19th)
   • Part 2: Charts (we'll start on Friday)
   • Part 3: Formulas
3. You can look at these spreadsheets by previous students to get an idea of what others have done.
4. Review the rubric to see how you will be evaluated.
5. Save your work early and often.
6. Drop-off each Excel task as you complete it.
7. The due date will be given as everyone progresses.

Drop-Off Box

For the ESL BTT1O class, use the drop-off box for Mr. Bourgase.

1. Open the Kipling CI folder on your desktop
2. Open the Drop-Off folder
3. Open the folder named Bourgase
4. Drag and drop your finished work into the folder named BTT1O Afternoon

Always put your full name and the name of the project in the file name and in the document that you are submitting