Archive for May, 2007

You are currently browsing the On the Trails weblog archives for May, 2007.

A Gift of Words for Bryce and Brooke

The Manifesto for Children by E. Paul Torrance
Don’t be afraid to fall in love with something and pursue it with intensity.
Know, understand, take pride in, practice, develop, exploit and enjoy your greatest strengths.
Learn to free yourself from the expectations of others and to walk away from the games they impose on you.
Free yourself to play [...]

Advanced Spreadsheet Skills – Scope and Sequence

Intermediate Skills
Using Templates

Create templates
Edit templates
Create new workbooks based on
User-defined templates
Modify Workbook properties
Change Default Templates & modify template settings

Working with Ranges

Create Named Ranges
Use named ranges in Formulas
Use Lookup Functions
Create & Modify List Ranges

Formatting Cells

Create & Apply Custom Number Formats
Apply conditional formatting
Add data validation criteria to cells

Importing & Exporting Data

Import Data from Text Files
Export Data to Other [...]

Intermediate Spreadsheet Skills – Scope and Sequence

Beginning Skills | Advanced Skills

Customizing Workbooks

Rename Worksheets
Change worksheet tab colors
Select and move sets of Worksheet
Copy worksheets
Insert & Delete Worksheets
Hide & Unhide Worksheets
Use Save As
Renaming Folders while Saving

Using Lists

Learn about database features
Find & Replace Cell Contents
Freeze & Unfreeze Rows
Freeze & Unfreeze Columns
Hide & Unhide Rows & Columns
Sort lists in Descending Order
Sort lists in Ascending Order
Understand [...]

Beginning Spreadsheet Skills – Scope and Sequence

Intermediate Skills

Getting started with excel

The excel window
Viewing worksheets
Go to specific cells
Save workbooks in new folders
Close workbooks

Working with Cells, Rows, and Columns

Use the Task Pane to create Workbooks
Enter cell content
Edit cell content
Check spelling
Insert & Delete cells
Merge & split cells
Insert & delete columns & rows (columns are inserted to the left, rows above selection)
Modify column width & [...]

Google Calendar in Firefox Sidebar – a modest hack – really modest

A few years ago, there was a Firefox add-on that one could use that would display a small calendar in the sidebar of Firefox. I went searching this morning and could not find it.
All I wanted was a calendar that would show the month in the Firefox sidebar (and the ability to navigate to other [...]

Spreadsheets – not just for making graphs….

A typical lesson involving spreadsheets is one that focuses upon creating graphs.  That is a good skill to learn, but spreadsheets can be used in so many different ways. Here is one way.
How about creating a Know – Wonder – Learn Chart in your favorite spreadsheet software application?
Spreadsheets are great for organizing data – no [...]

Modeling Writing with a Message Board and Audio File

I was working with a fifth grade teacher today who wanted his kids to write reflections of their recent trip to Washington D.C. His students had typed a draft in Word already (yeehaw – someone gets it). As he conferenced with his kids, he did not feel that the kids were “getting it.” [...]

Mowing and the “Flat World”

I just spent the last two hours cutting my lawn and listening to Thomas Friedman’s The World is Flat on my iPod.
You never know when and how people will be WANT to learn. So maybe we should make the explanation of the Pythagorean theorem in podcast form.

Next time I might listen to David McCullough’s 1776.
Technorati [...]

Teaching with iTunes

On Sunday morning my son Bryce and I were watching Major League Baseball.  It was 9:00 in the morning and he wanted to watch the Toronto Blue Jays vs. the Philadelphia Phillies and I wanted to watch the Pittsburgh Pirates play the Arizona Diamondbacks.  Now, before MLB.TV, this would have been impossible. I watched my [...]

eWorksheets & Copyright

What if we made eWorksheets – electronic worksheets that already contained the proper citation format?
Technorati Tags: onthetrail, thoughts, copyright
Powered by ScribeFire.

addthis_url = ‘http%3A%2F%2Fbtcactus.edublogs.org%2F2007%2F05%2F18%2Feworksheets-copyright%2F’;
addthis_title = ‘eWorksheets+%26amp%3B+Copyright’;
addthis_pub = ”;

Fractional Flags

Have you ever looked at the flags of the world and thought about a fraction lesson. Well, a fourth grade teacher that I work with had. She was looking for a way for the kids to demonstrate their knowledge of fractions. So we came up with the following lesson.
Resources:

wireless computer lab (OLPC)
Windows Movie Maker [...]

Distinguishing or just Fluff?

Teach people HOW to learn and not WHAT to learn; this is the cornerstone of my educational philosophy. In the world of today it is apparent that HOW we educate children is more important than what we do to educate them.
How should we be teaching children how to learn? My approach to this question is [...]

Terry’s Red Clam Sauce

Red Clam Sauce

addthis_url = ‘http%3A%2F%2Fbtcactus.edublogs.org%2F2007%2F05%2F13%2Fterrys-red-clam-sauce%2F’;
addthis_title = ‘Terry%26%238217%3Bs+Red+Clam+Sauce’;
addthis_pub = ”;

Ch-ch-ch-changes – and why they are good!

“Technology changes defeat our presumptions. To serve as IT professionals,
we need to keep ourselves free of preconceptions. The knowledge we work the
hardest to gain is the knowledge that new technology will inevitably
supplant—because replacing that knowledge is what makes the technology
easier to use. We can’t leverage that arcane knowledge as our competitive
edge forever. The real edge [...]