Computer Essentials 2b

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

Halloween Fun

Halloween Games - FUN!!!
Carve a pumpkin!
Halloween Music
Halloween Hangman
Pumpkin Dressup
Halloween Dressup
Word Search
Extreme Pumpkin Carving
Pumpkin Carver
Zombie Pumpkin
Zombie Letters
Add photos and words to a jack o lantern - Animated
Carve a pumpkin
Hidden Pictures
Garfield Scavenger Hunt
Candy Cards Game
Matching - Pumpkin Patch
Build a Scarecrow
Monster Maker
Variety of Games

<a href="http://www.flickr.com/photos/jawboneradio/214731497/"><img src="http://static.flickr.com/65/214731497_7aa686412f_t.jpg" /></a><a href="http://www.flickr.com/photos/jawboneradio/214746470/"><img src="http://static.flickr.com/63/214746470_119212be40_t.jpg" /></a><a href="http://www.flickr.com/photos/jawboneradio/214725914/"><img src="http://static.flickr.com/35/214725914_00d9c1e078_t.jpg" /></a><a href="http://www.flickr.com/photos/jawboneradio/214730268/"><img src="http://static.flickr.com/70/214730268_caa0ebfc8e_t.jpg" /></a><br />Zombie Letters from <a href="http://e-zombie.com/">e-zombie.com</a>

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

Senders Address and Date (Return Address)
Letter Address (Inside Address)
Salutation (Dear Mr. Burton:)
Paragraphs/Body
Closing (Sincerely yours,)
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