Fun Excel Spreadsheets #1

Click on these links and download the documents:

We will review them to see different ways Excel can be used.

The following templates are from one of my favorite sites:  Vertex42

Gantt Chart

Soccer Templates

Calendar

Simple Budget.

Assignment:  follow along and manipulate the spreadsheets the way I did on the projected screen.
(no written homework)

REFLECTION:  This activity went well.  The conditional formatting had the biggest Wow factor.   My objective was to show students that Excel can be used for more than graphs. I believe it succeeded.  Year 5 went a little better because I had the links for Vertex all ready to go.

Sept 20, 2013 Year 5 Assignment

Year 5 students, 

I will out today at a STEM conference on Environmental Education.  Mr. Copley will be your teacher today.  If you only have part of the period to work, then just do the first part.  Otherwise do both parts.

PART I
First,  look at Human Right's Watch Child Soldier's Worldwide list of countries where children are used as soldiers.

(Print a map from yoel.info.com and shade or color all the countries with child soldiers.)

PART II
Secondly, go to some sites and learn about Ishmael Beah and his home country:  Sierra Leone.  Then I want you to write a reflection on the question: 

 What do child soldiers experience that is similar to your childhood, and different from your childhood? 

Links to online resources:

Ishmael Beah's official Website featuing his book:   A Long Way Gone: Memoirs of a Boy Soldier

A link to an excerpt of A Long Way Gone that includes chapter 1.

Radio Interview with Ismael Beah on NPR's Fresh Air

Allow yourself time to write a good paragraph or two about what you learned from these links. 

Turn in your map and reflection into the red tub. 

See you next week.  Enjoy your long weekend!

Mr. Johnson

How-To Screenshot Project

Good afternoon 10 graders,

I am assigning a new project. I will hand out copies of the How-To Project Instructions in class today.

You may look at one of Mr. Johnson's How to find Computer Sign-up Sheet (one I did for CIS teachers), and look at Prezi example as well:  How to Use Formulas in Excel.

These examples give you a general idea of how to do the project.  They do not show all the components requrired for your assignemnt.

Enjoy!

Mr. Johnson