Home
Email From Home
Final Tips
Excel Countdown
Email Tips
Time Liner Tip
Virus Quiz
Canning Spam
04-04-03
03-10-03
02-25-03
02-11-03
02-04-03
1/28/03
1/21/03
01/07/03
1/14/03
12-17-02
12-09-02
12-02-02 -Ele.
11-18-02
11-11-02
11-26-02
11-06-02-Secondary
10-15-02 -Ele.
08-28-02
Home
Up

Excel Countdown

Did you know that Excel can count the seconds until a deadline?

Every time we turn around lately, someone mentions something like, "Thirteen schooldays left." or "Just two more Thursdays to go."  While clock watching and second-counting is a supreme waste of time, it's good to know that Excel can at least add a measure of precision undreamt of by us weary, spring-fever victims.

Below is an example of how Excel can count down the days, hours, minutes, and seconds until a certain day and time. Here are a few tips:

bullet You can Refresh this page to update the countdown. The shortcut is F5 in Internet Explorer. 
bulletCopy and paste these cells into Excel to study the formulas and modify it for your own purpose. Or, click here to download an Excel example file. Be sure to "Save As..." the file into your own home directory. One nice thing about the Excel file is that the cells are annotated using the "comment" feature.
bullet You can also click in the spreadsheet and recalculate. The Excel shortcut for recalculate is F9. Hold F9 down for a running countdown! 

Note that the date and time indicated in cell C2 is noon on June 13th, an arbitrary, random moment selected as an example. In Excel, edit this value to your own target date and time and you can experience the joy of watching the seconds tick down to your own personal goal.

More ideas like this:

bulletUsing similar techniques, you could have a spreadsheet count the seconds you've been alive or the duration of a science experiment. 
bulletEdit the target date in C2 to create a countdown to birthdays, holidays, anniversaries, or any special days.
bulletCount the seconds until you meet your loved one again. Or rather, let Excel count the seconds while you watch television or something.
bulletLook up your life expectancy, then set up a spreadsheet to count the days, minutes, and seconds you have left. Then make good use of them!
bulletSend me your idea!

 

Instructional Technology Classes

There are lots of great Instructional Technology classes offered by the Macomb ISD this summer. Go to http://www.misd.net/il/ and click on Course Offerings and Registration to find out more.

B U Z Z W O R D  O F  T H E  D A Y

HORKED: Broken, confused or trashed. Generally describes software or hardware that no longer works. "The router is horked!"
Nominated by Mike Fratini

Reprinted with permission:
To see the full Buzzword Compliant Dictionary, just click here.
http://www.buzzwhack.com

Technology Tips Online!

See http://www.cvs.k12.mi.us/tips for the complete collection.

Look for more tips for teachers.
Please contact Craig, Jerry, Rita, Lisa, or Angela for any questions or support.


Chippewa Valley Schools

Instructional Technology Department
Chippewa Valley Schools

586-723-2030

Craig McBain
, Instructional Technology Coordinator

Jerry Allen
Rita Hughes
Lisa Kimmel
Angela Miller
Instructional Technology Consultants
 

Tips for Teachers is part of TIZ: Technology Information Zone! 
Please contact the help desk  for any additional questions or support.


Chippewa Valley Schools

Craig McBain
Instructional Technology Coordinator
586-723-2031