NCCE - Tech Tools for Administrators 2/28/13

Handout - http://tammyw.macmate.me/TWHandouts/TW_Handouts/Entries/2013/2/6_Technology_Tools_for_Administrators.html
tammyworcester.com
Tools Covered
       Blogger
       Google Spreadsheets/Forms
       Evernote

Blogger
       Good way to easily make a web presence
               Would be good for staff who aren't on the web yet
       Important to have a web presence - employers check!
       Things you can do with your blog
               Can add to posts
                       Text
                       Video
                       Images
                       links
                       Audio (using vocaroo.com)
                               Can embed from vocaroo
       Should probably turn on comment moderation in settings
       Use pages for more static content
               Can have up to 20 pages
       Can create a template for others but they can't just choose it from a
       gallery, would have to copy and paste the HTML
       Can embed regular/custom google maps using the embed code
       Can embed calendar

Google Spreadsheets/Forms
       Use Spreadsheets/forms to gather info (see pervious class)
       Use batchgeo.com to quickly create a google map with data gathered from your google form (AWESOME!!!)
       Uses
               Tech support requests
               Parent surveys
               Teacher Evaluations
               IEP Meeting/staffing
               New student registration

Evernote
       Note taking syncing application
       Syncs across any device (phone/iPad/computer)
       Offers easy encryption
       Has OS enhancements to capture and clip from your computer/web          browser
       Includes OCR from pictures
       Can share via email/facebook/twitter or by URL (evernote shows your
       notes as web pages

Tech eNews 2-28-2013

Tech eNews for 2-28-2013

1. Missing toolbar items in Excel 2011
2.  Wireless expansion project underway
3.  eVAL Signup for Certificated Staff
4.  Need help, please ask!
5.  Updating your e-mail to log into School Dude
6. Take home rights to software


1. Missing Toolbar items in Excel 2011
If you're used to the tool bars in Office 2008 for Mac, you're used to having a specific set of buttons on each row of your tool bars, with certain items like "format borders" always being visible.

In the newer versions of Excel and Word 2011 for Mac, the applications will start hiding items from your "ribbon" if the Excel/Word window is not full screen.  For instance, when you shrink an Excel Spreadsheet, you'll end up with a sub-set of the tools available, and there's not a way to get them back without making the window larger (or digging in the menu to find them).  Click the link below for a Tech Blog article about how to customize the buttons and get your most-needed buttons back!

http://wsdtechblog.blogspot.com/2012/06/toolbar-items-missing-in-excel-2011.html

2.  Wireless expansion project underway
WSD Tech Staff Sean Elkinton, Linda Henderson, and Kenneth Mai are busy installing wireless access points to expand the WSD network into all areas of each building.  The new wireless is a more robust system that should provide much faster throughput, better coverage, and a more stable connection to the network.  It also features a “guest” network which is OK to allow students to access from their personal devices.   The Tech person in your building can help you set up district owned devices to connect to WSD.  For personal devices, you can connect to guest using the password you can get from your building support person.  The guest wireless password will be changing quarterly, so make sure you check the Tech eNews next month for the new password.


3.  eVAL Signup for Certificated Staff
Certificated staff should sign up for eVAL trainings to support their collection of evidence for TPEP.  The deadline for WAE members to sign up is March 5, 2013.  Here is the sign up link:
https://docs.google.com/a/washougalsd.org/spreadsheet/viewform?formkey=dGhaSFJ4SjBFeWFBSDBNQkRLYXM5dHc6MQ

4. No Problem Too Small – Please ask if you need help!
Sean, Linda and Kenneth are here to support district staff in your work educating children. If you run into a technology problem, please don’t hesitate to ask us for help. We’re only able to help if you let us know you’re having a problem!

5.  Updating your e-mail to log into School Dude
Some staff have asked about School Dudes still using the "old" Washougal.k12.wa.us e-mail addresses.  There isn't a way for us to mass-change all of the addresses, but if you want, you can update it for your account.

Log into school dudes using the normal link, on the WSD "For District Employees" page, using your and click the "settings tab" at the top (in the blue bar).

Click on either Maintenance or IT (it will update both)

Enter your new e-mail address in the box where it says E-mail address, then put in the submittal password and click submit.

You can contact Sean, Linda or Kenneth if you need help or don't know the School Dude password.

6. Take home rights to Microsoft Software
Yes, there are "take home rights" to some of the software that you use in your classroom, which includes Microsoft Office 2010/2011, Sophos Antivirus, Inspirations, and if you are at WHS, Adobe Creative Suite 4.

There's a form, created using a template from Microsoft, that outlines the "rules" around this use. It's located on the WSD Technology page, under the Business/Operations menu on the WSD Website, also linked here:
http://www.washougal.k12.wa.us/business_operations/technology.htm

It's called the "Take Home Rights Agreement" and in a nutshell, it says you'll use the MS software for work related purposes, and that you'll uninstall it if you ever leave your job at WHS. Note that for both the Microsoft software, and the Adobe software for WHS, your at home use is restricted to work related purposes, which would cover things like lesson planning, working on school projects, grading student work, etc.

You're entitled to the same version of MS Office as you have at work on your teaching computer.

If you are interested in this, please download the form, sign it and initial in the row of lines, and send the form along with a blank DVD to Les Brown. He will copy the installation media onto the DVD, and send it back to you.

Infographics as Assessments

NCCE - Infographics as Assessments 2-28-2013
Holy cow! The presenter goes way fast on this one so while I have notes they are really scattered and incomplete.  However she has an amazing website with everything on it.
http://www.schrockguide.net/infographics-as-an-assessment.html

Website - kathyschrock.net
                       linkyy.com/infographic
Infographic - A graphical representation of information, data, or knowledge

Linkyy.com - URL shortener that allows you to make a custom link

Flowtown - infographic website?

Infographics Types
       Data
               Graphs
               Bar Chart
               Pie Chart
       Process
               How to make a PBJ sandwich
               Workflow
Infographics and the Common Core
       There are a number of common core standards that are addressed with             the use of infographics
               Graph data
               Represent a mathematical situation with symbols
               Use objects drawings and diagrams to support
Tools (Layer based )
       Inkscape
       Pixler
       Pictochart - online infographic site
       Easel.ly - online infographic site
       Info.gram - online infographic site
       Visualize - iPad app (99 cents)
       Creatagraph - online tool for creating graphs
Steps to creating an infographic
       Periodic table of visualization methods - interactive tool to help choose               type
       Chart Chooser - online tool to help make charts/graphs
       Many eyes - online tool to create visualization

Research
       Create essential question
       List info sources
       Start research
       Re-work questions?
       Evaluate info - credible?
       Gather assets
       Cite sources
       List keywords

Layout
       beginning, middle, end
       Inverted pyramid style
               Main point at top supporting ideas below
       LATCH Model - Way to arrange info
               Location
               Alphabet
               Time
               Category
               Hierarchy

Visulize.me - Auto generates infographic from your Facebook

Book Trailers with Students - how to get non-Readers engaged in the Library

Book Trailer – path to success

Images trump words – pictures that capture the story help convey far more information than just words on a screen

Short video Ads – not retelling the book

Trying to “Advertise” the book so someone else would want to check it out.  Teaser information – selling the book to other students.

Purpose is to connect the book to other kids

John Schu – Watch, Connect, Read in Illinois

Book Trailers for Readers website – by Harclerode

The One and Only Ivan by Katherine Applegate trailer on YouTube

Take notes on key/pivotal scenes as you’re reading.

Trying to tease, but not give away major surprises/the ending

Engage students at Higher order thinking skills

Picking out key ideas

Collaborate – working in groups, find pictures, agree on scenes, find music, dividing work

Meaningful keyword searches – how to find the pictures/scenes/music that relates to what you want

Authentic audience – how to target a message to a group of peers – what will resonate with the group we’re targeting

Way to engage non-readers into the library environment, get students interested in both reading and synthesizing information

How do you do this:

Watch samples online

http://www.Booktrailersforreaders.com/

http://www.book-trailers.net

http://booktrailersforall.com

What works, what didn’t in the samples you saw

Music, image choice, what makes the video engaging

Key passages, what to include

15-20 images, 3-5 seconds per image, plus some text, to make a 90 second trailer

Keyword searches – Create Commons – Searching using Advanced tab – to makesure you can re-publish the books

Pictures need to be large – 640x480 – large enough to fill screen

Lots of photo sites –

3dtoad.com

behold.com

Flickr.com

Freefoto.com

Findicons.com

Freephotobank.com

Goolge images

Humanline.com

Ookaboo.com

Openclipart.com

Pics4learning

Picsearch

Schoolclipart

Sprixi

Veezzle

Visual Dictionary

Flickr might be blocked by Interne filter

MS Office Online has hundreds of images that are Create Common licensed for re-use

In Google – use Advanced search sprocket to search for Usage Rights = free to use and share

Storyboarding first, doesn’t let them just start the story – need to plan what they’re going to do

Uses storyboard to capture the link/source for the images rights

Save information into a folder (pictures, sources, videos etc. so that it is all together when you get to start the video part)

Photostory or Windows Movie Maker (or iMovie for Mac) as video site.

Photostory does a wizard driven movie making

Animoto (paid app) works well

Royalty Free music

Songsmith

Garage Band

Fine tuning – text that links the images,

Narration that tells a story

Sounds that sents the tone for the movie

Book cover sandwich – cover at both front and end

Leave the person with a definite impression

Credits at the end – who did it, music credit, photo credits

Essential learning:

How to be successful, how to persevere, how to carry something through to completion and draft/edit/publish

QR Codes on outside of books – so people can snap a shot of it and see the video. 

Gave kids copy of the QR codes so they can put it on the refrigerator to share with parents (put up on refrigerator)

Fun idea – have kids take pictures with the number of views, track where people are watching the videos from

Bulletin board with QR codes, images of the books that have trailers produced for them

YouTube

Facebook

SchoolTube

TeacherTube

Pinterest

Twitter

BookTrailersforall.com

Didn’t get parent permission because she’s not using picture of student in the work

Session materials here: http://2013.ncceconnect.org/T208

NCCE 2013 - 25 websites in 50 Minutes

http://www.discoveryeducation.com
25 websites in 50 minutes 2-28-2013 8:30 AM
Matt Monjan from Discovery Education
These are the free resources, streaming product is expensive - $3,000 per school building

WebMath.com linked from DiscoveryEducation site, free how-to tools for math (interactive widgets to help sovle problems)  from arithmetic to calculus

DiscoveryEducation.com/webinar archived broadcasts, webinars, presentations from “live” activities like the fieldtrips

Most of these don’t require a login - nice for students to sit down in a “kiosk” mode to interact with items

Kathy Shrock’s Guide to Everything (organized list of web tools for education)
http://www.schrockguide.net

Young Scientist Challenge - cool hands on activities for students to explore and do (project based learning activities)

Science of Every day Life - time travel, virtual labs, innovation etc.

Live Blogging from NCCE 2013 in Portland - Jay Bennett

NCCE - Google Forms 2-27-2013

Use a URL shortener (goo.gl) to share links to docs
There's a chrome plugin

Admin needs to set up "rapid release" for google apps

Can collaborate on google forms now like you can on presentations and documents

Forms no longer automatically create a spreadsheet, you can choose..
       No spreadsheet
       New spreadsheet
       A tab in an existing spreadsheet

Create spreadsheet first
       put questions in the top row, one per column
       Go to tools menu and create form
               form is created with questions input already
       If you start with the spreadsheet it is automatically associated with that      spreadsheet

Custom form response
       Can create custom "thank you" message at end of form
       Could include a link to a website or results of form

Logic Branching
       The response leads to different questions
       Use "Add Item" --> "Page Break"
       Each "page" is a different branch
       At bottom of each page you need to set "after page"

CountIf formula
       Use "count-if" function to translate text data to numbers so you can            create a chart/graph
       typing "=countif" will give you a list of functions and function format         information
       With numerical data you can "insert"-->"chart"
       "file"-->"publish" to publish chart/spreadsheet
       Clicking on the chart and "publish chart" to get embed code

Array formula
       Function pulls data from one sheet to another

Transpose formula
       Function swaps columns and rows
       Can make it much easier to view data
       In example it placed names across the top and answers down the columns

Filter formula
       Function allows you to enter a search term and will pull data associated                with that term
       Can make your search field a autofilled pulldown list
               Choose cell and go to "Data"--->"Validation"
       Use additional functions to make a custom search page

Use Google Form/Spreadsheet as assignment dropbox
       Create form with name, url, notes fields
       Students can submit URL

Image function
       =image will take a url as an input and will pull the image from that url into           the spreadsheet
       Can use this function to pull in a QR code (see class presentation)

Concatenate using the CHAR function
       char(10) puts in a line break

Website tammyworcester.com
tip of the week  tip81 self checking quizzes
Also can use the Flubaroo script
       tools-->script gallery

NCCE - Bare is Beautiful 2-27-2013

Cloud Computing
               Data storage
               Apps
               Content creation
               Browser extensions
       All online running through your web browser
       Allows collaboration
Browser Extensions
       Extensions allow features and functions not generally available in the          standard web browser
Extensions to consider
       Evernote
       YoLink
       Zotero (FF only)
       Diigo
       Google Toolbar
       Fireshot
       Cooliris
       Pixler Grabber
       DownloadHelper (FF only)

Online Software Replacement
       Music Making
               Soundation
               Jamstudio
       Adobe Pro
               Fillanypdf
               PDFonline
       Documents
               Google Docs
               Office Live
               Dinky's Page

Many more at resources.edtech2020.org/bare-is-beautiful

Freemake Video Converter (GET IT)!!!!!

www.smore.com online flyer/poster making site (Very cool!!)

Install iPad apps using Apple Configurator

Open iTunes

Login with teachers login for App Store

Download apps – Time consuming

Find the apps under the Apps tab in left sidebar of iTunes

Right click on downloaded app and select “show in finder”

Select all the new apps you downloaded  “.ipa” files

Quit itunes, leaving finder window open

Open Configurator app

Double click name of the profile to edit (name.ipad.pilot)

Click Configuration/Restriction then functionality tab

Check Allow installing apps

Go to Applications Tab

Click Allow use of iTunes store

Save

Plug in USB cable from the cart

Click on name of iPad group in left hand side bar

Click on apps tab

Click group in sidebar (if for some reason it’s not already selected)

Select all iPads

Click apps tab

Drag .ipa files into the apps tab inside of configurator

Wait for import then check new app boxes

Click apply – Time consuming

Double click name of the profile to edit

Click Configuration/Restriction then functionality tab

Uncheck Allow installing apps

Go to Applications Tab

Unclick Allow use of iTunes store

Save and apply