Excel Spread Sheet Lesson
Bell Ringer: Look at the picture above. Why might using a computer be faster and easier than using the old method of paper and pencil to compute math problems.
(Every student has done math with a paper and pencil (prior knowledge) and most dont generally like doing it this way, so the use of a computer might interest them.)
Purpose/Objective: SWBAT use Microsoft excel and most of its components. Define the purpose of Microsoft Excel and explain why it is useful, effective and saves time.
Lecture/Discussion:
-- What is Microsoft Excel?
-- How might excel be useful to me?
--What kind of things can excel do?
--What are some of excel's limitations?
-- Why might excel be useful to me in the future?
A spreadsheet is the computer equivalent of a paper ledger sheet. It consists of a grid made from columns and rows. It is an environment that can make number manipulation easy and somewhat painless. (Below is a paper ledger and the "spreadsheet" or computer ledger.)
(They are shown the similarities between the past method (ie; paper ledger) and the spreadsheet shown below)
Columns vs. Rows
Have you ever been to a staduim to see a sports event of concert? Do you remember what the ticket stub said? In order to help you find your seat it probably split the seating up into columns and rows. Say you were column "B" row "6". Can you find that on the spreadsheet below?
**(Almost every student has been to some sort of baseball game, concert or sporting event held in a staduim-type building or atleast knows what one is. This also gives them a chance to try and find column B row 6.)**
The seat you would be in is highlighted in blue above. The columns are the letters on top of the box and the rows are the numbers at the left of the box. The intersection of a column and a row is called a "cell". Highlighted above is cell "B6".
**(The student should be able to find B6 based on what I have told them about columns and rows)**
Some things Excel will compute are: sums, averages, maximums, minimums, sin/cos/tan, etc.
(Student Response: "What are those?" This questions is better answered in the tutorial)
Closure: Browse the tutorial to find out more specifics of Microsoft Excel. When you feel confident, launch Microsoft Excel from MSOFFICE2001 and play around a bit, try some things and see what you can find out.
iMovie Lesson
Bell Ringer: Have you ever used a camcorder like the one in the top picture? How might the use of iMovie save a lot of time for the guy in the second picture?
**(Most students have experience with cameras and know what projectors do and may have even worked one in school (prior knowledge). This allows them to compare what they already know to what they will learn later and mold it into something useful for the future.)**
Purpose/Objective: SWBAT see the purpose and use of iMovie, how it saves time, learn the basics and be able to use iMovie, and see the importance of video on the internet.
Lecture/Discussion:
-- What is iMovie?
-- How can Iuse it?
-- What can iMovie do?
"If a picutre is worth a thousand words, a movie must be worth a million."
The large box above is called the shelf. In it are 4 different "clips" of video. These clips are all 5 minutes in length (seen at the top left of each clip).
What does the picture above remind you of? Do you have a cd player at home? This is whre you play, pause, stop, rewind and fast forward the video clips. Each button is labeled accordingly.
**(Most students have used a cd player or discman (prior knowledge) so they will know, basically, how this will work.)**
The picture above shows the scrubber bar. This is where you will put video clips in to be played consecutively. Where the red arrow labeled "playhead" is pointing is where one video clip ends and another begins.
**(The students can see the cut off point, where one video ends and another begins.)**
You can choose how you would like each clip to begin and end using the box below.
This allows you to manipulate how the clips are played consecutively.
**(The icons are self explanitory, most students know what overlap, fade in/out, push etc. means. If not this is best answered in the tutorial provided.)**
You can also add some of your own sound effects to your movie by using the box below.
You get to choose when you want these sounds made.
**(The sounds are self explanitory.)**
Closure: Complete the tutorial in the link above and when you feel confident enough, go to iMovie and play around with some video clips. (there are some default video clips already there that you can use.)