Issue 14, Volume 5

November 18, 2004

 

 

Thought for the Week
"You don't understand anything until you learn it more than one way." -- Marvin Minsky

 

CPSB Receives Technology Award
The Calcasieu Parish School Board was awarded third place in Top 10 Tech-Savvy School Board Study. The award was presented during the recent National School Board Association’s Technology and Learning Conference in Denver. The nation's top 10, digitally-advanced school boards were announced by the Center for Digital Education (CDE) and National School Boards Association (NSBA). The selection was based on the Center and NSBA’s first annual Digital School Boards Study. The study examined how school boards and their districts are applying information technology (IT) to better engage their local communities and constituents, and improve the delivery of services and quality of education to public schools.

More than 2,500 school districts were invited to participate in the study, which grouped school boards into three categories based on student population. Survey questions and criteria focused on school boards' online presence, technology applications that allow the public to interact with school board members, access to information such as school board calendars, policies and agendas, and technology advancements in the school board chambers and the school district’s overall use of technology.

Excel Tip
One of the first functions beginning Excel users learn is the IF function, which takes the form =IF(condition,true_result,false_result). When you use this function, you typically test only one condition at a time. For example, in the formula =IF(A1>10,"Great","Average"), the only condition evaluated is whether the value in cell A1 is greater than 10. However, there may be times you want to display a result depending on whether any one of multiple conditions is true. Suppose you need a formula that says: If A1 contains 10, or if A15 is greater than 20, or if A25 is less than 100, display "Great." But if none of these conditions is true, display "Average." You can create such a formula by combining the IF and the OR functions. The OR function takes the form OR(condition1, condition2, condition3) and evaluates to a logical true value if any of the conditions is true. If all of the conditions are false, the OR function evaluates to a logical false. In our example, the formula would take the following form:

=IF(OR(A1=10,A15>20,A25<100),"Great","Average")

If any of the three conditions is true, the OR function evaluates to true, and the formula returns "Great." If all three conditions evaluated by the OR function are false, the OR function returns a value of false, and the IF test returns "Average."

Looking for a Way to Say “Thanks” to Our Troops?
Operation Dear Abby is one of the places where you can send an email to cheer up our troops this Thanksgiving and holiday season. Use the 2nd URL to send an uplifting message through Defend America. Finally, your class may wish to consider collecting donations to contribute calling cards to the troops for a much-appreciated holiday gift.
WRITE TO THE TROOPS:
http://anyservicemember.navy.mil
http://www.defendamerica.mil/nmam.html
http://www.operationuplink.org

Locating Your Last Edits in Microsoft Word
When working with a long document in Microsoft Word there are times when you need to quickly find where you made your last edit. Word can automatically take you to the last three locations in your document where you typed or edited text.  Inside of your document press SHIFT + F5 together. The cursor will appear at the point you made your last change. To see the previous change press SHIFT + F5 together again.

Looking for a Thanksgiving Lesson Plan?
At this website students will learn about the history of Thanksgiving celebrations and feasts in America, how different presidents chose to celebrate it (or not), and how it was tied to a  successful harvest. http://www.riverdeep.net/current/2001/11/111901_thanksgiving.jhtml

Sending Email to Tech Help
When sending an email to tech.help@cpsb.org don't forget to include a "Subject". When you do not put a subject in the subject line it makes it difficult to determine if this email is a valid email or "spam" email. If you put a subject like (register, virus, printer, etc… this helps us get these emails categorized and answered in a prompt and more effective time frame.

Windows Movie Maker 2 Tutorial
This site has a free tutorial for Windows Movie Maker 2. It lets you create, edit, and share your movies right on your PC. It's easy to use, yet it provides powerful capabilities that rival those of expensive computer editing packages. You can download the software FREE from Microsoft. It works with both Windows XP Home Edition and Windows XP Professional Edition. http://www.atomiclearning.com/moviemaker2_sample

Add Comments to a Slide as a Collaborator Within PowerPoint
Adding notes to a slide show that's being passed around by a team of collaborators is easy. Simply choose Insert | Comment, type the message you want to share, and then click outside the automatically created comment box. Repeat this process to add as many comments on as many slides as you want. You can also easily hide the comments if a slide gets filled up with everyone's comments and is no longer easy to see (although this isn't as much of a problem in PowerPoint 2002/2003 since comments are collapsible in these versions). To do so, simply choose View |Markup (View | Comments in PowerPoint 97/2000/v.X) to remove the check mark from this option in the menu. Since this menu item works as a toggle switch, select Comments a second time in the View menu to reveal the comments once again.

Postcards from Buster
Ever wish you could take a class trip around the Unites States to experience the diverse cultures that make our country a true melting pot? Most of us do not have that option, but this site could be the next best thing. Travel with Buster Bunny as he explores the United States and shares his experiences through video clips, songs, games, and recipes. http://pbskids.org/buster

Changing the Layout of a Slide in PowerPoint
You can change the layout of an existing slide by selecting the slide and clicking a different layout thumbnail in the Slide Layout task pane. If you make changes to the layout of a slide -- such as sizing or moving a placeholder -- but then decide you would rather use the original layout, you can reapply the layout without losing text you have already entered, by clicking a command on the layout thumbnail's drop-down list.  When you manually alter the layout or the types of items on a slide, PowerPoint uses an automatic layout behavior to apply a slide layout that matches your changes.  Select the slide for which you want to change your slide layout.
Point to the text object's frame (but not to a handle). Then drag the object to the bottom of the slide. On the Format menu, click Slide Layout. The Slide Layout task pane opens with the current slide layout thumbnail selected. Point to the current thumbnail, and click the down arrow that appears to its right. On the menu click Reapply Layout. PowerPoint moves the object back to its original position on the slide. In the Slide Layout task pane, scroll down until you reach the Text and Content Layouts area. In the Text and Content Layouts area, click the desired layout change. The layout changes and carries the text over to the new layout. You can now insert a table, new text, diagram or organization chart, clip art or picture, or media clip as the selected content object.

Top Ten Viruses Found on CPSB Computers
Here are the top ten viruses found on CPSB computers in the past 7 days. The stats are based on 738 infected computers out of a total of 9424 OfficeScan clients.

The latest OfficeScan pattern as of 11-17-2004 is pattern 2.249.00. Please check your pattern by placing your cursor over the OfficeScan icon and viewing the pop-up window that appears. If your pattern is significantly different than this (A HIGHER PATTERN NUMBER IS OK), please email tech.help@cpsb.org regarding this or any other question you have regarding OfficeScan.

The information shows the name of the virus, the number of infected files found, and the percentage of the virus from the total.  ALL school board employees need to ensure that their Dell, Compaq, HP, IBM or other PC classroom computers stay virus free. Go to the following link to download the district copy of OfficeScan: http://teacherlink.cpsb.org/officescan and your computer will automatically be updated daily to scan for the latest viruses. You must install the software using Internet Explorer 4.0 or later (Netscape will not work!!!!!) Please answer "Yes" to all prompts as the software installs. If you have any questions, please contact the CPSB Help Desk at tech.help@cpsb.org.

Best on the Net!! -- Visit this site for hundreds of websites for teachers! We would love to hear from you about the best educational sites you have found on the web. Please submit, via email, the sites you feel merit inclusion. Send to tech.connect@cpsb.org. Please include the URL and a short sentence about the site. 

Featured Sites: (These sites were submitted by teachers in Calcasieu Parish)

Thanksgiving Videos:
With Thanksgiving quickly approaching, here are a few great Unitedstreaming videos for you and your students to enjoy:

Holiday Facts and Fun: Thanksgiving (Grades K-4)
Giving Thanks (Grades K-4) 
Who's That Stepping on Plymouth Rock? (Grades 1-6)
The Pilgrims Come to America (Grades 2-5)
The Plymouth Colony  (Grades 2-5)
Turkey Girl (Pueblo) (Grades 4-8)
Puritans and Separatists (Pilgrims): The Establishment of Plymouth Colony (Grades 4-8)
Living History: Living at the Plymouth Colony (Grades 4-8)
New England Colonists, The: The Pilgrims and Puritans (Grades 5-7)
Pilgrims and Puritans: The Struggle for Religious Freedom in England (1517-1692) (Grades 7-12)

Unitedstreaming's website is http://www.unitedstreaming.com.  If you are a classroom teacher and do not have a Unitedstreaming account, you can contact Diane Mason at diane.mason@cpsb.org to obtain your school code.

Cybersleuth Kids:
http://cybersleuth-kids.com
An Internet search guide for students K-12 which features Science, Math, Geography, and History
 


An official publication of the CPSB Technology Department
If you have any questions or comments please e-mail the Webmaster.
For Technical Support:  tech.help@cpsb.org

Calcasieu Parish Homepage  Technology Department  Teacher Link  Best on the Net
Tech Guides  Computer Purchasing Information  Tech Connect Archive
 

This site was last modified on Friday, August 19, 2005