This issue sponsored by:
| SchoolCounselor.com eNewsletter #101 |
January 18, 2009
Welcome to SchoolCounselor.com, an electronic newsletter designed to advance counselors' level of technological literacy, application, and integration. You will find practical solutions and answers to technology related problems, especially as they apply to your job as counselor. If you would like to share a tip or trick, or if you would like to ask a question, e-mail Russ Sabella at email@example.com.
Highlights from SchoolCounselor.com
Top 5 Training Topics for School Counselors
Must See Videos
New videos added since the last issue.
TIPS AND TRICKS
QUESTION: School Counselor Nancy J. writes, “I need to know how to combine 2 or more (usually more) Excel databases. our scheduling program will not let me download all information needed in one file. I spend hours on this. Is Access the best way? Do you have hints for Access?”
ANSWER: Since you are already using Microsoft Excel, let’s stick with that instead of migrating over to Access (also because, honestly, Access, in my opinion, is much less user friendly than Excel, which is not that user friendly to begin with). The trick to getting everything into one sheet is that the data fields, in this case columns, match exactly. For instance, the first column may include student ID, second column include number of absences, and so on. If this is the case, than you can just copy and paste one sheet or even multiple sheets into one master data file.
I’m guessing, however, that you are probably wondering how to “match up” data for students from one data set to another. Most commonly, counselors may want to match up each student’s post scores with their pre-scores on any given performance indicator. For example, let’s say you have the number of absences for a group of students with whom you are working. After a few weeks of intervention, you download the same group’s number of absences and then want to put them side by side in two columns, of course making certain that the post-absences match the pre-absences for each student. (Note too, that in this example, one should look at absences for equivalent periods in order to best make comparisons such as Quarter 1 versus Quarter 2).
This can be accomplished several ways including a combination of manually inserted formulas or using Microsoft Excel Pivot Tables. The easiest way that I know how to do this is to use Dr. Tim Poynton’s EZANALYZE Amalgamate feature. According to Dr. Poynton’s website (http://www.ezanalyze.com/help/amalgamate.htm), “The Amalgamate Data function in EZAnalyze allows you to combine two worksheets in the same Excel file into one, based on a 'Unique Identifier' that exists in both sheets. For example, if you want to merge data that exist in two different databases (such as NCES and your state Department of Education), you can merge them together easily using this function. This function adds new variables (columns) to your sheet for all cases (rows) that have the same Unique Identifier. You can choose whether or not you want to keep rows of data that do not match.”
Go to the website to learn the steps in doing this and to download the Excel addin (click on Download on the left side). One tip to know is that this feature only works for combining multiple sheets that exist in the same file, not different files. So if you do have more than one excel file, you’ll have to first copy and past the data you want to combine in different sheets using one file.~~~~~~~~~~~~~~~~~~~~~~~~~~~
No Shoes? No Problem for this College Interview
By BARBARA RODRIGUEZ
RALEIGH, N.C. (AP) — For her college interview, Avery Cullinan put on her best outfit but didn't bother with shoes. She sat in her living room, smiled into her computer's webcam and told an admissions officer more than 800 miles away that Wake Forest University was right for her.
Read More here.
Microsoft Outlook 2007: Flag E-Mail as a Task
Flagging mail messages as tasks automatically adds them to your To-Do Bar so that you can easily track and complete them.
1. Right-click the flag icon next to an e-mail message.
2. Designate a date by which you want to follow up on this message.
3. View the message on your To-Do Bar.
~~~~~~~~~~~~~~~~~~~~~~~~~~~Tech-Parenting from our POV
by Anne Collier
"Is it smart or sneaky for parents to have accounts on Facebook or MySpace to monitor their children's behavior?" "I won't let my teenager on Facebook or MySpace. Is that a mistake? Should I?" "Of the social networks, which do you consider to be the most safe, and which do you consider to be least safe?" Those are just a few of dozens of questions from parents around the US my ConnectSafely.org co-director Larry Magid and I (Anne Collier) enjoyed answering in a one-hour, live online discussion at the Washington Post last week. It's now archived at the Post's Web site
Cyberbullying Package (free)
CyberSmart! is extraordinarily pleased to announce the release of our CyberSmart! Cyberbullying Package, a positive and empowering suite of K-12 lessons. The lessons adopt an integrated approach, based on current research findings and best practices from the fields of cyber security, school violence prevention, and character education to impact behavioral change. The resulting package of materials focus on developing critical thinking and decision-making skills, guiding students to define the problems and issues themselves and "own" them. "CyberSmart!'s free cyberbullying lessons allow face-to-face character education to be extended into cyberspace. These lessons are a great resource to continually remind the school community about safe, ethical online use within the context of living a life of character," said Merle J. Schwartz, Ed.D., Director of Education and Research, The Character Education Partnership.
Internet Safety Technical Task Force Releases Final Report on Enhancing Child Safety and Online TechnologiesThe Berkman Center for Internet & Society at Harvard University today released the final report of the Internet Safety Technical Task Force, a group of 29 leading Internet businesses, non-profit organizations, academics, and technology companies that joined together for a year-long investigation of tools and technologies to create a safer environment on the Internet for youth. The Task Force was created in February 2008 in accordance with the Joint Statement on Key Principles of Social Networking Safety announced in January 2008 by the Attorneys General Multi-State Working Group on Social Networking and MySpace. The report was delivered to the 52 Attorneys General in December, 2008.
To read the final report, including the executive summary, as well as reaction statements from members of the Task Force, visit: http://cyber.law.harvard.edu/pubrelease/isttf
Internet Evolution: Future of the Internet III Press release for a December 2008 "survey of experts by the Pew Internet & American Life Project that asked respondents to assess predictions about technology and its roles in the year 2020." Includes summary and full text of the report, which found that experts predict the "mobile device will be the primary connection tool to the internet ... in 2020." Also includes links to previous "Future of the Internet" and other related reports.
WORTHY WEBSITES AND SOFTWARE
Video Sharing Websites:
1. YouTube (owned by Google, Inc.) allows people to easily upload and share video clips on www.YouTube.com and across the Internet through web sites, mobile devices, blogs, and e-mail. http://www.youtube.com/ Youtube is now integrated with Google Video (http://video.google.com/).
2. TeacherTube is a video sharing website that is very similar to YouTube in layout and function, with one crucial difference: it's entirely devoted to educational videos. The site monitors inappropriate materials, so it's safe to use in the classroom.
3. WonderHowTo hand-selects and curates the best instructional videos from over 1,700 web sites. Explore the largest collection of free how-to videos anywhere. http://www.wonderhowto.com/
4. 5min is a place to find short video solutions for practical questions and a place for people to share their knowledge. http://www.5min.com/
Podcast Directories and Search Engines:
1. The Apple podcast directory searchable through iTunes software (http://www.apple.com/itunes/podcasts/)
2. Podcast Pickle (http://www.podcastpickle.com/)
3. Podcast Directory (http://www.podcastdirectory.com/)
4. digitalpodcast. (http://www.digitalpodcast.com/)
5. The Education Podcast Network (http://epnweb.org/).
Online Meetings and Collaboration:
1. Skype is free software that allows one to video/audio conference with others and includes instant messaging and file transfer. http://www.skype.com
2. ooVoo. Similar to Skype, ooVoo allows for video/audio conferencing, file transfer, and instant messaging. http://www.oovoo.com/
3. With Vyew you can give a presentation to a hundred people online or post a document you've been working on for review by your colleagues at their convenience. Vyew is extremely flexible allowing you to bring online collaboration and conferencing into your workflow on your terms. http://vyew.com/
4. Windows Meeting Space enables face-to-face collaboration among small groups of Windows Vista users—virtually anytime, anywhere. Useful for both business and personal purposes, this tool enables you to share work on computer-based projects with other people more easily and comfortably. Windows Meeting Space uses peer-to-peer technology and automatically sets up an ad hoc network if it can't find an existing network. So you can use it in a conference room, a favorite hotspot, or a place where no network exists. You can join a meeting that someone else sets up, or you can start a new meeting and invite other people to join it. Windows Meeting Space is on the Start menu, under All Programs. http://tinyurl.com/66rrsw
5. DimDim. Unlike other web conference products, Dimdim does not require users to install software on their computers to attend web meetings. Users can start or join meetings with just a few clicks. Dimdim is available for free so everyone - not just big companies with big budgets - can use it. http://www.dimdim.com/
6. GoToMeeting is an online meeting service that enables individuals and organizations to easily, securely and cost-effectively collaborate, present information and demonstrate products online. http://www.gotomeeting.com
7. Webex. WebEx delivers a robust suite of on-demand collaborative applications. http://www.webex.com/
8. Yugma. Yugma is an easy-to-use web conferencing service that allows users to host or attend online meetings on Windows, Mac or Linux computers. http://www.yugma.com/
The Future of Reputation
Daniel Solove, an authority on information privacy law, offers a fascinating account of how the Internet is transforming gossip, the way we shame others, and our ability to protect our own reputations. Focusing on blogs, Internet communities, cyber mobs, and other current trends, he shows that, ironically, the unconstrained flow of information on the Internet may impede opportunities for self-development and freedom. Longstanding notions of privacy need review, the author contends: unless we establish a balance among privacy, free speech, and anonymity, we may discover that the freedom of the Internet makes us less free.
Although you can purchase this book in paperback, the full text of The Future of Reputation is now available online for free. The front matter to the book is at the beginning of each chapter. If you're using this book for a book discussion group or for an academic class, you can also access discussion questions here.
Dropbox is the easiest way to share and store your files online. No complicated interfaces to learn. Dropbox runs in the background on your desktop. Watch this screencast for how this free service works here.
Big Huge Labs
Helping you do cool stuff with your digital photos since 2005. :-)
Also check out http://www.dumpr.net/
File Dropper’s simple, elegant, and the biggest of the bunch. 5GB! Uploading a file is as easy as browsing for your file, and clicking “Upload.” Every file gets a permanent link that you’re free to share with your friends. There are no frills, no awesome features to speak of, but it’s dead simple, practically limitless in size, and probably the one I use most.
CustomGuide.com has a Ton of Free "Cheat Sheets"
These "cheat sheets" are PDF files designed to fit on the front and back of one page. They're eye-catchingly designed to cover all the basic functions of a software application. Applications covered? Generally speaking, programs from Microsoft, Mac, and Adobe (the guides cover several different release versions, especially for Microsoft Office programs). There are also cheat sheets for Firefox and QuickBooks.
JUST FOR FUN
Uncle Jay Explains: Year-End News Review!
Why Don't We Do It in Our Sleeves?
This humorous five-minute video encourages people to cough and sneeze according to infection control guidelines. Watch and find out why it is best to cough into your sleeve. Also includes a link to "Soap in the City," a short, funny video that uses the story of Typhoid Mary to explain the importance of hand washing to prevent the spread of disease. It also demonstrates the correct technique for washing hands. From three doctors.
TeachersFirst 100th Day Activities: 50+ Ideas for the 100th Day of School
There are lots of ways to note the 100th day of school. Here are fifty of our favorites. Many of these activities will challenge both lower and upper elementary students as they build better number sense for "100." Enjoy!
Also check out http://www.teachersfirst.com/holiday/
SchoolCounselor.com does not knowingly send unsolicited e-mail. This Newsletter is for subscribers only. If you received it and did not subscribe, please let us know using the link on our home page. We will remove your name immediately.
TO SUBSCRIBE to this newsletter, simply go to the signup page at www.SchoolCounselor.com/newsletter and enter your e-mail address. You will receive an e-mail asking you to confirm your subscription. We will add your e-mail address to the list when you reply to the confirmation e-mail.
TO UNSUBSCRIBE from this newsletter, simply visit go to the signup page at http://www.schoolcounselor.com/unsub.htm and click the unsubscribe button after entering your e-mail address. Important: You will then be asked to click on a link called “click here” to complete the process.
TO CHANGE YOUR E-MAIL ADDRESS: If your old address will become inactive, PLEASE
UNSUBSCRIBE with your old address and SUBSCRIBE with your new one.
IF ALL ELSE FAILS send a note. Please allow a week or two for changes to take effect.
Want to advertise in this newsletter? Visit http://www.schoolcounselor.com/advertising.htm
The SchoolCounselor.com newsletter may contain links to sites on the Internet owned and operated by third parties. SchoolCounselor.com is not responsible for the availability of, or the content located on or through, any such third-party site. Information in this document is provided "as is," without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability, fitness for a particular purpose and freedom from infringement. The user assumes the entire risk as to the accuracy and the use of this document. SchoolCounselor.com will not be liable for any damages of any kind arising from the use of this information, including, but not limited to direct, indirect, incidental, punitive, and consequential damages.
Sunday, January 18, 2009
Posted by RS at 12:27 PM
- ► 2015 (12)
- ► 2014 (24)
- ► 2013 (27)
- ► 2012 (39)
- ► 2011 (75)
- ► 2010 (98)
- ▼ 2009 (55)
Produced by Sabella & Associates, LLC
Copyright, 2009. All Rights Reserved. Contact Dr. Russell Sabella at firstname.lastname@example.org.