Spreadsheet Magic

June 28, 2010

see http://mathcats.com/spreadsheets/

spreadsheets to download, use spreadsheets for more than math.

and http://center.uoregon.edu/ISTE/2010/program/search_results_details.php?sessionid=50096017&selection_id=59375465&rownumber=21&max=30&gopage=15

see http://center.uoregon.edu/conferences/ISTE/2010/handout_uploads/KEY_48684102/Talley_ISTE2010.pdf and http://center.uoregon.edu/ISTE/2010/program/search_results_details.php?sessionid=48684102&selection_id=59375465&rownumber=2&max=2&gopage=

start voicethread as powerpoint, upload, then kids go on and comment.

record teacher voice and or video giving directions of prompts for students and what they should do per slide, how and what to comment on…  also put up pictures or docs and tell kids to post up their questions.

put up ‘passage’ and have kids post reading strategy type comment on that text.

kids make voicethread on content

using trakstar to do treasure hunt research, package as voicethread.

This common craft video explains RSS and how to use RSS to bring the web to you.

Work SMART not HARD!

In this step you tell Movie Maker the location of the video clips that you will use to make the movie.

  1. Open Windows Movie Maker (start, programs, windows movie maker)
  2. Click “Import Video” under movie tasks to left
  3. Use the drop down menu to browse to location of video clips (this will often be the Y: drive, look for “jontemplates on ‘acsfs2’ (Y:)”
  4. Uncheck the box that says “create clips for video files”
  5. Select clips (you can select several at the same time)
  6. Click import
  7. Wait, then move on to Sequence

In this step you get your video clips in the right order.

  1. Identify location of clips. Change Collections in the toolbar to see all your video clips
  2. Preview clips in play back window to right
  3. Drag and drop clips to storyboard; move to correct order
  4. Save frequently
  5. Preview storyboard in playback window
  6. Once you get all your clips in order move on to effects, transitions and titles

Once your movie is ready you have one more step, Finish the Movie. This is kind of like the publishing step in the writing process; you make a final nice copy to share with other people. In this step Windows Movie Maker is going to collected all your pieces of video and any effects or titles and combine it all into one nice tidy file.

  1. Make sure you have save the project before going on, this step crashes the computer sometimes
  2. Click “Save to my computer” under Finish Movie to left
  3. Type a name for the finished movie file (it does not have to be the complete title, it can be short)
  4. Click browse
  5. Navigate to “My Documents” and put the movie somewhere inside
  6. Click OK
  7. Click next
  8. WAIT, this one may take a while
  9. Done!

Start by planning. What sound effects will you need? It may help to list search terms you will use to find sound effects:

These directions will only work when you do NOT have the USB headset plugged in.

1. open audacity, minimize

2. go to the “free sound project” website http://www.freesound.org/index.php

3. search for a sound (use the search box, listen so results with triangle)

4. once you locate a sound you want to record, bring audacity back up

5. mute all tracks

6. change recording source from “microphone” to “wave out” or “wave out mix” (this is in the toolbar, just below and to right of the play, record, etc)

7. press record

8. bring up the freesound page, press play

9. let audacity record the sound, you may want to record it several times to make sure you get a good copy

10. use copy and paste to move the sound to the correct part of the recording

Creative Podcasting for the Elementary Set by Kathy Shields This was a very useful, nuts and bolts session that was the best thing I did today. Thank you Kathy and everybody that participated. Kathy described her use of podcasting in elementary classes. Then she opened things up and had several audience members discuss their experiences with podcasting. Very informative… Her are a few things she or audience recommends: Let students listen to a few preselected podcasts and develop a list of traits of good podcast. Someone in audience suggested playing movie without video and looking at (listen at?) how the video carries so much message and how you have to speak in a special way to communicate, active acting voice. Build teams with roles; sound engineer, artist, senior writer (although all write some) >sound engineer can download background music, artist can make 200 x 200 pix ‘cover’, senior writer can write description for episode. First time (when student learning all nuts and bolts) keep the cognitive load light, let them pick the topic within the givens. Also don’t put too much emphasis on the research yet, do some research, but the first time through it is not about the research, add that later. Write a script, take it through the writing process. Bring groups up in front of class to practice, then debrief and give positive feedback and suggestions. Record with audacity – students often like to share the microphone in the middle as opposed to taking turns with headset, especially if they are practiced. Export as MP3, post to podOmatic. Make sure to name site and podcast the same thing, makes finding easier. Use “Episode 1: [title]” to name podcasts. Get groups to comment on one another’s podcasts. Encourage parents to comment. Train parents. Get principal, community to comment. Kathy has a great site with info re podcasting: ripplingpond

info at http://groups.google.com/group/wpves-tiger-tidbits

things to think about

svideo converter
good lighting – studio lighting
headphone splitter
wideangle lens

computer and monitor for script

play video or something at end – reward

use as positive behavior support