Monday, Dec. 1


Students will

  • compare products on various sites for sales - best deal!
  • define Cyber Monday and Black Friday.


Today is CYBER MONDAY!!



You are going shopping!  Find the best deals!

It can be from the black Friday ads or a Cyber Monday sale.

You will create a table to keep track how much money you are spending.

Column Headings:

Item, Website/Store, Price, Balance


Budget:  $1,000.


What I want for Christmas!

Create a collage of your items, and the price! My Christmas wish list!

Thursday, November 19

Create a post card. 
 The key – within the post card message, include at least 3 facts about the place!


Friday, November 7

Using Absolute References - Preserve

Write formulas containing absolute references.

Create a Pie Chart - add extra elements


Activity 59 - page 471

Activity 68 - page 481




Wednesday

Sort Columns
Add a Filter
Create a pie chart

Handouts - teacher led

Project 82 - page 495
Project 83 - page 496
Project 69 - page 482

Monday, November 3

10 minutes to finish Project 60 - on page 278

When finished work on homework, NO GAMES

Discuss page 281

DO NOT START ASSIGNMENT

Together - page 282 - 283
Steps 1-4

ASSIGNMENT 3


Project 61 - page 283 - 284

October 30 - Thursday

Today you will create a 

  • Create a column chart in Numbers
  • Multi Series Bar Chart - graphs more than one series. 
  • Stacked bar chart - (stacked column chart) Segments are stacked


Page 270 - review - create this chart in Numbers, we created it in Sheets.

Multi Series
Page 273-274 - complete together

ASSIGNMENT 1 & 2
Project 58 - page 275-276
Project 60 - Page 278 - 279 - class did not finish - will be given 10 minutes to finish and turn in on Showbie

Tuesday, Oct. 28

Create a blog post.  Discuss Sheets vs. Numbers.

Similar/Difference

Thoughts.

Finish Project 53 and 54


Friday, Oct. 23

Google Sheets - explored this with a partner.

Assignment:  Project 54

Wednesday, Oct. 22

Project 50 - page 235
  • Merge title across and center
  • Format cells to currency
  • Bold Title
  • Bold Column Headings
  • Refer to page 234 if having problems with formulas
  • Align columns as shown
Project 51 - page 241
  • Merge title across and center
  • Format cells to currency
  • Bold Title
  • Bold Column Headings
  • Align columns as shown
Project 53 - page 252

Monday, Oct. 20

Tell Mrs. James which Showbie Account you are using - so that I can delete duplicates.


Today you will:

OBJECTIVES

  • Add formulas to a Numbers Table
  • Calculate sales tax
  • Insert a function to calculate average
  • Center text in a column
  • Format cells to currency
  • Merge and center cells
  • Submit assignments on Showbie


Finish project 46 page 218 - if you have not done so.

Refer to page 217 if having troubles with formulas

ASSIGNMENT:

Project 47 - page 226

  • Merge title across and center
  • Format cells to currency
  • Bold Title
  • Bold Column Headings
Project 48 - page 228

  • Merge title across and center
  • Format cells to currency
  • Bold Title
  • Bold Column Headings

Tuesday, October 14

Today:
  • Type in a formula to multiply data within a cell.
  • Use the Fill Down Tool
  • Format cells to currency

ASSIGNMENTS

Project 44 - page 206 - 208 - Read directions

Remember to remove column and row headers

Merge title across columns
Bold column headings
Bold Title
Align text as shown in the book
Adjust column width

Project 45 - 215
Project 46 - 217





Fantastic - FRIDAY!!!, Oct. 10

SPREADSHEETS

TODAY's TOPIC:  Numbers

Identify the components of a spreadsheet
Type spreadsheet data
Type a formula using addition
Adjust column width
Identify the similarities and differences between a table in Pages and Numbers

ASSIGNMENT:

Page 206 Project 43


Wednesday, Oct. 8

Insert a SUM FUNCTION into a table in Pages.

Finish Project 32 - SHOW Mrs. James sum formula.

Assignment:

Page 168 - Invoice

Check grades on PowerSchool

Monday, Oct. 5

  • REVIEW
  • Insert a Table
    • Fill cells
    • Change font color
    • Add border style
    • Grid Options
    • Merge Cells
    • Adjust Column Width
    • NEW LEARNING-Formula to add up column

ASSIGNMENT 1
Project 30
Page 142

ASSIGNMENT 2
Project 31  - page 151
Table only

ASSIGNMENT 3
Project 32 - page 156
Table only

Thursday, Oct. 2

  • Insert a Table
    • Fill cells
    • Change font color
    • Add border style
    • Grid Options
    • Merge Cells
    • Adjust Column Width

ASSIGNMENT 3
Project 29
Table only
Page 137


Tuesday, September 30

Today you will everyone will utilize their iPad:

  • Draw shapes
    • Apply Styles
      • Style Options
        • Width
        • Color
        • Arrowheads
        • Line options
    • Arrange
    • Add 
    • Effects
      • Shadow
      • Reflection
    • Color - Fill
    • Border
  • Text

ASSIGNMENT 1 - Diagram ONLY
Project 27
Save as Project 27 with your name

ASSIGNMENT 2
Project 29
Page 137



Thursday, September 25


Today we will review parts of the personal business letter and the four tab stops.  We will also insert pictures that we found on the Internet/media library.  We will explore Text Wrap, Instant Alpha and masking a picture.
 
A personal business letter is composed by an individual and mailed to a business, school or government agency.  It is much formal than a note you would type to a friend or relative.

PAGE 80

  • Identify and review parts of a personal business letter
    1. Senders Address and Date (Return Address)
    2. Letter Address (Inside Address)
    3. Salutation (Dear Mr. Burton:)
    4. Paragraphs/Body
    5. Closing (Sincerely yours,)
    6. Sender's Name
  • Demonstrate four tab stops
    • Left, Center, Right, Decimal
  •  Insert pictures into Pages
    • Text Wrap
    • Instant Alpha
    • Mask
    • Applying Styles
    • Rotating
    • Flip Vertically/Horizontally
ASSIGNMENT 1
Project 17 - page 88 - 89
Turn in on Showbie

ASSIGNMENT 2
Project 26
Page 122-123
Turn in on Showbie






Tuesday, September 23

Today you will:

  • Identify parts of a business letter.
  • Key a business letter.
  • Connect ipad to wireless keyboard
  • Identify the four tabs - and the differences - DEMONSTRATE.

ASSIGNMENTS

Type the following letters exactly how they are in the textbook.  Turn into Showbie.

DUE FRIDAY, SEPTEMBER 26

Business letter page 80

Business letter page 82

Friday, September 19

On Wednesday you visited Google Doodles.  We will start by discussing what you found. What were your favorites.

ASSIGNMENT 1

Download the Showbie App

Join Mrs. James class.  See previous post for code.

Logon to your Tagomobile.ca to check how many scans your QR code has received.


ASSIGNMENT 2

Create a blog post stating how many scans.



ASSIGNMENT 3

Today we will revisit Google Hangouts!  Please wait for directions.
Create a blog post summarizing Google Hangouts. What are its features.  What makes is unique from another video chat service.




Monday, September 15

Join Showbie Class

Class Code:  37CL4