BTT1O - SmartPhone Theft in Toronto

Minds On

• YouTube video link: www.youtube.com/watch?v=XbPvky4Ejxc

In-Class Activity

1. Using the EBSCO database (see instructions below), find an article titled "Cellphone thefts soar over past decade" by Patty Winsa in the Toronto Star
2. What is the article about (3 to 5 key points)?
3. Using EBSCO, find another article about SmartPhone Safety in Toronto.
4. List some important advice that your friends could use to stay safe while using their phones.
5. Visit Cite This For Me and create a works cited list.

BTT1O - Research - EBSCO Database

Introduction

• You can visit the EBSCO Online Database to access additional articles. This may be useful for your Excel Research Report or other courses.
• The address is search.ebscohost.com and I will write the username and passwords on the board during the class.

Steps to Follow

1. Visit search.ebscohost.com and login.
2. Select a database like EBSCO Educational Database.
3. Check all of the databases that are relevant to your search.
4. Enter your search terms (start generally and drill down as you progress).

BTT1O - ESL - Make a Business Card

It is easy to create your own business cards in publisher to print yourself at home or at a store such as Staples or Kinko’s.

Create a business card that features a job that you would like to have. When you finish the card, you will present it to the class and explain how you designed it.

Business Card Essentials

Always include:

• Company Name
• Your Name
• Job Title
• Contact Information
• Use clear fonts that are easy to read

Don’t put too much information on the card.

Instructions

Create a business card with:

• Your name, job title and company name
• A picture or clip art
• A background
• Fonts and colours

Click here for an example.

BTT1O - ESL - Microsoft Publisher Poster

Introduction

• Microsoft Publisher is used by students for school newspapers, businesses to create posters and business cards and community groups to create newsletters.
• It is similar to Word but used for projects with more graphics and images.
• You can insert pictures, text, tables, borders and backgrounds.
• Example: Golf Tournament Flyer

Getting Started

• When you open Microsoft Publisher, you see a screen that allows you to select what you will work on:

1. Select Quick Publications
2. Choose the style that you want
3. Customize your publication
4. Click on Create

• Once the publication is open, you can add objects by clicking on the bar on the left hand side:

• Double-click on parts of your project to change the colour and other features.

Your Task

1. Open Microsoft Publisher and create a New Publication.
2. Under the Task Pane, select Quick Publications.
3. Select one of the Design Templates to create your design.
4. Create a poster for an event at Kipling C.I. or in your neighbourhood.
5. Each poster must include:
   • A Design Template
   • A Picture
   • Clip Art
   • Word Art
   • A Text Box
   • A Table
6. Customize the poster as you wish.
7. Use the sample (“Golf Tournament Poster”) to help get started.

BTT1O - ESL - MS Word - Links

Here is the information that you need in one place:

1. My Favourite Website
2. Website Review
3. Rubric (Marking Scheme)

BTT1O - ESL - Don't Trust Every Website

This video of a wolf in the Athlete's Village at the Sochi Olympics caused a commotion*.

Is this reliable?

* excitement or confusion. "The video caused a commotion since everyone was excited because they thought that a wild animal was inside the building."

BTT1O - Google Tips

In class, we will discuss some search tips to help get the information that you need when you are researching. Here are some graphic organizers to help remind you.

BTT1O - Microsoft Excel Research Assignment

Assessment of Learning

1) Learning Goals

• Use Google and Internet search techniques to research a topic
• Display the information coherently using Microsoft Excel
• Make informed statements about the data, supported by online research

2) Success Criteria

I will know that I am successful when:

• I research a topic of my choice and find interesting facts and figures
• I display the data in Excel in a way that highlights key points
• I summarize my findings in writing
• I include complete formatting (M.S. Excel and Works Cited List)

3) Expectations

Students will demonstrate the following expectations during the assessment:

• Productivity Software
  • use spreadsheet software to perform a variety of tasks
• Digital Literacy
  • apply effective techniques when conducting electronic research

4) Components

Each assignment will include the following components:

• A table of data (5x10)
• A line chart showing changes over time
• Two charts showing a snapshot of data at a specific time
• A paragraph summarizing the data and its significance
• A list of citations

5) Deadline

Submit in the Drop-Off Box by Wednesday March 5th

6) Supporting Documents

• Instructions
• Example Assignment
• Rubric

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 - ESL - Microsoft Word Assessment

Deadline

Please submit all three Micrsoft Word documents to the drop-off box by Friday February 27th.

Rubric

Click here for the rubric.

Checklist

You will be evaluated on these three items:

1. Internet Safety Terms Tables
2. “My Favourite Website”
3. Review of Website Reliability

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 - ESL - Website Review (Is this website reliable?)

Purpose

Google News (http://news.google.ca) allows you to search the most recent news items about a topic. However, you still need to ensure that the source is reliable.

Task

1. Search for a topic in Google News
2. Write down the important information about the article (title, author, address, source, date)
3. Write a short summary of the article
4. Rate the website according to reliability, objectivity and accuracy and explain why
5. Use a table to create a 4 row, 3 column table that has terms (reliable, objective, accurate), synonyms (words with similar meanings) and definitions (word meanings).

M.S. Word Formatting

Include this formatting in your document.

• A table with borders and shading
• Single line spacing
• A title and headings, with fonts

Example

Click here for a sample document.

Additional Resources

Create a Table

Table Borders and Shading

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 - ESL - My Favourite Website (MS Word Document)

Agenda

1. Continue typing with UltraKey at the start of the period. This will lead to a typing assessment.
2. Finish your M.S. Word table with Internet Safety terms.
3. Create another Word document. Review a website that you enjoy visiting.
   1. What is the website about?
   2. How often do you visit the website?
   3. What do you like about the site? (use a list/numbers for this)
   4. Include these items:
   1. bold/underline/italic/different fonts/colours to make a title and headings
   2. a list of at least three terms
   3. a picture
   4. check spelling and typing
   5. change line spacing to Double Line Spacing
4. Drop off the assignment in the class box.

Example

Click here for an example of the task.

Resources

How to Make a List

Insert a Picture

Check Spelling

Change Line Spacing

BTT1O - M.S. Excel Table

Sample Table

Here is a table for today's in-class demonstration.

Reminder

Drop your table off (with your name) by Friday.

BTT1O - ESL - Example of MS Word Table

So far we have

• talked about online safety terms and how to protect yourself
• created a table in MS Word
• created a banner using WordArt

Example Table

Click here for a sample table.

To hand in

When you have finished your own table of terms, save it with your name in the file name and drop it off on Thursday or Friday. Thanks.

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

BTT1O, ESL - Table of Online Safety Terminology (Part 2)

Learning Goals

The objective of this task is to:

• Demonstrate an understanding of internet safety terms and how to protect yourself online; and
• Format a table and WordArt in M.S. Word.

Success Criteria

I will know I am successful when:

• The definitions and safety tips are detailed and complete;
• The phrases have been written in my own words and typed correctly; and
• The Word document is easy to understand and contains interesting designs.

Instructions

1. Open the M.S. Word document that we worked on in Tuesday's class about online safety terms and online habits
2. Complete the table based on information from class discussion
3. Format a table in M.S. Word with borders and shading
4. Use WordArt feature to create a title (we will cover this in class)
5. Save your work and drop off the assignment in the drop-off box.

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 ESL First Period

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

BTT1O: Online Presence

If Someone Looked You Up, What Would they Find?

Introduction

A digital tattoo is the remains of your online activities that remain years after they have taken place. For example, posts on message boards, photos and other information may be stored on a server and appear when others search for you.

Since employers may search a person's name or their previous experience (schools, jobs, etc.) it is important to balance having fun online with maintaining your reputation. "Digital Footprint" is another name for all the information that you leave as a result of your computer use.

Even web sites, blogs and tweets can be recovered - even if the original is deleted - since they are stored on the Internet Archive's WayBack Machine (http://archive.org/web/).

1) Google Yourself

• does anything come up? (try quotation marks around your name, your name and Toronto and your name 2010..2013 to limit results)
• are you happy or displeased about the information?
• what does it say about you?

You can set up a Google Alert (http://www.google.ca/alerts) to send you an email when your name appears in a search result.
Online Article: "Google Me" Link: http://digitaltattoo.ubc.ca/2013/11/07/google-me/

2) Assess Your Own Habits

• how would you evaluate your habits? (on a scale of 1 to 10)
  • privacy (limiting personal information posted online)
  • professionalism (avoiding embarrassing pictures and posts)
  • Personality (being positive, talking about your own accomplishments and those of others)
• list three good tips that would help you and your friends stay safe and private online.

Today's Task

Answer the questions in a well-formatted M.S. Word document that demonstrates your skills with that software. Save the document in a folder in your BTT1O folder.

Other Resources

• "Protect Yourself" (http://digitaltattoo.ubc.ca/protect)
• "Common Sense" (http://www.commonsensemedia.org/advice-for-parents/internet-safety-tips-high-school-kids)
• "12 Most Critical Reasons Students Need a Clean Online Presence" (http://12most.com/2012/04/12/reasons-students-need-clean-online-presence)

Closing Thought

BTT1O ESL: Online Habits (Terminology)

Minds On

Would you be Facebook friends with this person?

Vocabulary

Keep a list of vocabulary words in your home drive in a folder labelled "BTT1O" with a clear file name.

Term	Definition	How can you protect yourself?
Phishing
Flaming
Viruses
Cyber-Bullying
Sexting
Trolling
Spam

Today's Task

• To test your Microsoft Word Skills, recreate the table above in M.S. Word and save it on your home drive.
• I will post the document we have been showing on the screen during our discussions after it is completed to be an example.