Victoria Rasmussen

Messages

UEN Class Materials

Handouts used in class and reference documents to support instruction for classes are on the left.
Links to web sites used in class and for reference on class topics are on the right.

My Documents

Electronic Portfolios for Students
- Agenda (PDF)
- KWL form (PDF)
- KWL Form (Word 07)
- Overview PowerPoint from Class (PDF)
- How To Create a Portfolio (PDF)
  
  Step-by-step guide and storyboards for PowerPoint and Google Sites
Excel 2007 for Teachers
- Course Agenda and Assignment Information
- Excel Class Reference Guide
  
  Concept descriptions and instructions for doing some operations in Excel.
- Problem Solving Process - Draft Worksheet
- Small Group Story Problems for Practice
- Excel Example: Battleship
  
  Instruction sheet. Uses formatting and multiple sheets.
- Battleship Game
  
  Example Worksheet.
- Excel Example: Compare Groups
  
  Instruction sheet. Uses charts.
- Excel Example: C to F Conversion
  
  Instruction sheet. Uses conversion formula in a table format.
- Excel Example: Lonely Bingo
  
  Instruction sheet. Uses comments and conditional formatting.
- Lonely Bingo
  
  Example Worksheet.
- Excel Example: MasterMind
  
  Instruction sheet. Uses IF function and sheet protection.
- Excel Examples: Miscellaneous
  
  Instruction sheet. How to calculate with dates, mazes, visual literacy, following instructions...
- Excel Example: Recipe Conversion
  
  Instruction sheet. Uses text boxes, simple formulas to adjust amounts of ingredients for different numbers of servings.
- Recipe Conversion
  
  Example Worksheet.
- Excel Example: Self-test or Interactive Worksheet
  
  Instruction sheet. Uses IF function.
- Self-test or Interactive Worksheet
  
  Example Worksheet. Use Home Tab, Format button, Unprotect sheet item to remove sheet protection and view functions.
- Excel Example: Show Change Over Time
  
  Instruction sheet. Uses charts.
- Excel Example: What if?
  
  Instruction sheet. Uses simple formulas to calculate how long it will take to save a given amount of money.
- Movie List for Filtering Practice (XLS)
- Excel Skill Review Worksheet
  
  Thanks to David Thacker who submitted this fun review quiz as his Excel class assignment.
- Excel Review Quiz
- Wingdings Font Key (XLS)
  
  Reference sheet showing which letter on the keyboard makes which symbol when the Wingdings font is applied. Useful to select a symbol for correct or incorrect answers in the self-test activity.
- PDF Versions
  All the Word 2007 documents are available as PDFs for download from this folder.
  - Excel Agenda, Assignment
  - Excel Guide
  - Excel Group Work Problems
  - Example: Battleship
  - Example: Compare Groups
  - Example: Conversions
  - Example: Lonely Bingo
  - Example: Mastermind
  - Examples: Miscellaneous
  - Example: Recipe Conversion
  - Example: Self-test
  - Example: Show Change
  - Example: What If?
  - Excel Review Quiz
Web Publishing for Everyone
MS Office Week
- Welome Information
- Instructional Plan Assignment
  
  See link to rubric in bookmarks folder.
- Day 1 Overview
- Word Concept Guide
- Day 2 Overview
- Excel Concept Guide
- Excel Examples
- Day 3 Overview
- 7 Deadly Multimedia Sins - Sample PowerPoint
  
  This is a .PPTX document.
- PowerPoint Peer Review Form
- Storyboard Form
- Day 4 Overview
- Review Quiz

My Bookmarks

Electronic Portfolios for Students
- Helen Barrett: Electronic Portfolios
  
  This site is the ultimate, definitive site for research, examples, information and direction.
- Project-based Learning Checklist Tool
  
  This PBL site has several great tools, but this one allows you to create checklists using items others have already filled in.
- UEN Online Rubric Tool
  
  Go here to use use pre-created rubrics or customize one. If you want to save your rubric, go through your my.uen page instead.
- Example: Richer Picture
  
  See several examples of online portfolios from many grade levels and subject areas.
- Example: Arron's Bike Portfolio
  
  Click Arron's Portfolio link mid-way down the page. This is an example of a word processor document saved as a PDF file.
- Example: Jared's IDET Portfolio
  
  UEN's own Jared Covili completed an electronic portfolio for his IDET graduate program.
- Article: Creating a Culture of Student Reflection
  
  Teacher reflects on his experiences implementing electronic portfolios in his classroom.
- Article: Assessment Research
  
  This article summarizes the effectiveness of portfolios as an alternative form of assessment.
- Google Sites Sample Portfolio
  
  This is a bare-bones example of how you could structure a class portfolio web site.
Excel 2007 for Teachers
- Bloom's Taxonomy Review
- Multiple Intelligences Review
- Printable Quick Reference Guide
- Microsoft Lesson Plan Home Page
  
  Locate lesson plans with tutorials that use Excel in a variety of subject areas.
- Design a Crossword Puzzle in Excel
  
  Tutorial from Microsoft
- Bingo Boards for Printing
  
  This web site has instruction sheets and bingo boards of different sizes. Created by Dr. Jeff Ertzberger.
- Bingo Boards for Printing
  
  This link downloads an Excel file to make Bingo boards that use 30 vocabulary words of your choice. Created by Robert Griffith.
- Interactive Excel
  
  This site includes many downloadable files that are already programmed so students can practice and study with simulations. They are primarily for science subjects.
- Spreadsheet Safari
  
  Lesson plan and activity ideas in different subject areas. Includes downloadable files. Generally appropriate for elementary.
- Article - Excelets: Excel's Excellent Adventure
  
  Math oriented - instructions and resources for using Excel in the classroom. From TechLearning eZine.
- Video Tutorial: Excel Projects and Conditional Formatting
  
  See how to make a "Lonely Bingo" game using the comments tools and conditional formatting in this 30 minute video tutorial.
- Video Tutorial: Excel: Creating Interactive Worksheets
  
  Directions to use the IF function for an interactive worksheet. 30 minute video tutorial.
- Video Tutorial: Excel: Create a Planning Book and Self Test
  
  The first 20 minutes is devoted to the planning book, the "self test" using the IF function gets a quick how-to in the last 10 minutes of this 30 minute video tutorial.
Web Publishing for Everyone
- my.uen Help Center
- Shellie Butler my.uen page
  
  Example
- Jared Covili my.uen page
  
  Example and resource links
- Larkin Weyand my.uen page
  
  Example
- my.uen Blog example
  
  Halloween stories from 4th graders (current on 11/4/09)
- Weebly Tutorial: Basic Overview
- Weebly Tutorial: Page Set Up
MS Office Week
- Instructional Plan Assignment Rubric
- UEN K-12 Educator Site
- UEN Copyright Resources Web Page
- UEN Multimedia Resources for Educators Web Page
- my.uen Help Center
- Microsoft Education Web Site
- Microsoft - Search for Interactive Command Reference Guide
  
  This free "plug-in" helps you identify how to do things with version 2007 that you used to do with 2003. Different downloadable guide for each of the MS Office products.
- Office Quick Reference Guides
  
  Printable 2-page guides with step-by-step instructions. Available for 2003 and 2007 for all Office products.
- UEN Faculty Lounge Webcast (tutorials)
  
  Participate live on Thursdays at 3:30 during the school year, or view archived sessions any time.
- UEN Professional Development YouTube Channel (tutorials)
  
  for PowerPoint
- internet4classrooms (tutorials)
- Atomic Learning (tutorials)
  
  Some available at no cost.
- actden (tutorials)
  
  PowerPoint 2007 only, but fun
- About.com
- How Stuff Works
- Helen Barrett on ePortfolios
- Graves District PowerPoints (for Peer Review Activity)
- Desktop Publishing: 7 Tips Article