Course Review & Final Project

Edit 39 15 …

Overview

This page will cover information on the final project and review tutorials.

Course Review

For information on key skills and knowledge see the tutorials below.

Tutorial Guidelines

Your tutorials need to have the following parts
  • 5-10 key skills that everyone must be able to do
  • 3-5 slide presentation for the class
  • Brief 'how to' on the skills
  • In class exercise for folks to practice the 2-3 most important skills

Final Project

This section describes the final project.

The Task Part 1

Calculate the exact number of M&M's in the glass jar.

Your calculation must involve:
  • A clear process which you can describe
  • Tools that you use to take measurements, or gather data
  • Calculations performed on Microsoft Excel
  • A result that is a specific number

The Task Part 2

Convince us that your calculation is the most accurate.

To convince us you will create ONE of the following:
  • PowerPoint
  • PodCast
  • Movie

Your presentation (whatever the format) must include:
  • Your name
  • Your final calculation
  • The process you used
  • Why your method is more accurate than others
  • Works cited
  • Good design (transitions, layouts, music, word art, avoid excessive text, bullets etc)

Things you may do

  • Share ideas
  • Share resources
  • Share data
  • Open the jar
  • Use ALL resources available to you
  • Access the jar outside of class (just let Mr. Mundahl know)

Things you may not do

  • Submit a group project
  • Submit a project identical to another student
  • Remove any M&M's fromt he jar
  • The jar may not leave the classroom, Mr. Mundahl's office, or Mr. Mundahl's home

Assessment

50% - Calculation
50% - Presentation

Bonus: if the class as a whole produces a more accurate result than last semester's group then each student will get a +5%. This will be determined in the following way:
  • Single best calculation is closer than last semester (129 off) = +2.5%
  • Average class calculation is closer than last semester (486 off) = +2.5%

Download this file to determine who has the most accurate result: Final ILTECH MnMs.xlsx

Final Exam

This is the review guide for the final exam (for the folks who are taking it).

Review session 5/20 8:30pm Small House.

The exam will cover the following topics:
  • Wikis (making a new page, adding links, headings, videos, toc, bullets)
  • Password management (the 'formula method' of creating a password)
  • Excel (formulas like *,-,+,/)s
  • REAL method
  • Vocabulary