11-6-09
1. Do a pretest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
2. Do three lessons on http://typing-lessons.org/
3. Do a posttest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
4. Using Excel to make averages and sums
Sometimes you need to add up lots of numbers or make averages of lots of numbers.
You don't want to do this by hand with a calculator, because you may need to change the numbers later.
If you use a spreadsheet with functions, you can have the software do the math for you, which will make your life easier.
Using functions allows you to have the results of the information dynamically update whenever the information itself changes.
Get some data:
Use this link to get at least a week of data for weather in Duxbury:
http://www.wunderground.com/weatherstation/WXDailyHistory.asp?ID=KMADUXBU4&day=6&year=2009&month=11&graphspan=day
Make columns for: temperature, high, low and average
make a row for each date, at least 7
Use the AVERAGE() function to average your columns and rows
Make a chart that helps demonstrate the information in your dataset.
Do the same process with another set of numbers, real or imaginary.
11-5-09
1. Do a pretest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
2. Do three lessons on http://typing-lessons.org/
3. Do a posttest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
4. Set up a spreadsheet in Excel with data like this:
| |
Robots |
mp3 players |
video games |
| Marc |
7 |
2 |
34 |
| Amon |
3 |
3 |
20 |
| Gareth |
25 |
1 |
5 |
| Kip |
15 |
7 |
15 |
| Becky |
8 |
5 |
20 |
We will be using the Chart Wizard to generate charts and graphs of data
This page has more information about the process:
http://peltiertech.com/Excel/ChartsHowTo/ChartIntro.html
11-2-09
1. Do a pretest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
2. Do three lessons on http://typing-lessons.org/
3. Do a posttest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
4. Candy Spreadsheet with totals and averages
This formula will give a total of the cells named inside the parenthes marks: =SUM()
This forumula will give an average of the cells named inside the parenthes marks: AVERAGE()
Set up your first column so that it has the types of candy.
Your other columns should show how many, what kind and several attributes of the candies
The bottom rows should show averages and totals (A separate row for each)
If you do not have data from your halloween take, you can use this picture to get the contents of a sample Halloween treat bag.
10-30-09
1. Do a pretest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
2. Do three lessons on http://typing-lessons.org/
3. Do a posttest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
4. Check the Term One List and finish up any work
10-29-09
1. Do a pretest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
2. Do three lessons on http://typing-lessons.org/
3. Do a posttest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
4. Type a writing assignment from another class.
Using a writing assignment that you have done for another class, you will type up your handwritten version.
If you began but did not finish one of these yesterday, finish it.
If you did not begin one last class, choose two to work on this class.
10-27-09
Lunch
Discussion:
- What changes have you seen in your computer abilities since the term started?
- How are you using these skills in your other classes?
- How can you use these skills on assignments in other classes?
1. Do a pretest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
2. Do three lessons on http://typing-lessons.org/
3. Do a posttest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
4. Using an assignment from another class where you have had to write something, type up the assignment and put it on a page with a heading.
Hand this in before the end of the period
10-26-09
1. Do a pretest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
2. Do three lessons on http://typing-lessons.org/
3. Do a posttest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
4. Catch up - work on your
Centered tabs from 10-22
Spending Spree with Decimal tabs from 10-21
5. Assignments that you could use your new typing skills for:
In school, you have a number of classes that you could use your typing and computer skills for. At this point, it is important for you to identify these assignments so that you can improve your work on them. Getting your work between the school and home could involve a couple of techniques: Using a usb flash drive, or sending an email with an attachment of the file you are working on.
Make a list of each of the courses you have that have upcoming assignments that could involve typing.
List the teacher's name, assignment, and due date(s)
Put this on a page with a heading
Use tabs to align the assignment and due dates
For next class, bring in an assignment that you hand wrote. We will be using that in class.
10-22-09
1. Do a pretest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
2. Do three lessons on http://typing-lessons.org/
3. Do a posttest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
4. Finish and print your shopping spree document with currency tabs
5. Centered tabs
- Make three lists that will sit next to each other on the page
- Use tabs to make them align on the center of the words.
- The lists should be: animals, colors, countries
- There should be at least five items in each list.
- Bold the category title
- Each list should be set up on a centered tab
- You will need to put a tab BEFORE the first item on the line to get it to the tab.
Make another set of lists of the categories of your choice.
- At least seven items on each list
- Use centered tabs
- Bold the category title
10-21-09
1. Do a pretest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
2. Do three lessons on http://typing-lessons.org/
3. Do a posttest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
4. Print your table with embedded pictures if you have not done so already.
5. Work on your list with currency tabs.
Currency tabs checklist:
- A menu for a restaurant
- Ten items at least on the list
- prices for each of the items
- Item prices are all aligned with a currency tab, around 5 inches
- The name of the restaurant should be centered on the line above the list
6. Make a second currency tabbed list detailing how you would spend $5,000
- At least six items
- Prices should be from online sources.
- Underneath each item, list where you got the price.
- Use a right aligned tab for the vendor of the product
- Before each item, list the product or stock number from the vendor.
Here is an example of about how it should look:
Shopping spree:
Quantity Product number Description Price
1 CUPCAKE MakerBot CNC Basic Kit $750.00
http://store.makerbot.com/cupcake-cnc/cupcake-cnc-basic.html
The next item would align on the same tabs.
10-20-09
1. Do a pretest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
2. Do three lessons on http://typing-lessons.org/
3. Do a posttest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
4. Print your table from last class
5. Tab placement and Leaders
When you use tabs properly, you can do some interesting and creative things with them.
The most common tabs you will encounter are currency, aligned on the decimal, right aligned, left aligned and center aligned.
Make a one column Menu for a restaurant that has:
tab for currency with a leader- All the prices should be lined up on the decimal
You should use a leader for the tab so that some character prints before the price.
10-16-09
1. Do a pretest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
2. Do three lessons on http://typing-lessons.org/
3. Do a posttest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
4. Tables - Inserting images into the cells.
Put an assignment header on the top of your page.
Table One:
- Make a table to organize the foods that your friends like
- On the top row, list the names of four or five friends
- In the left column, list a bunch of foods that they may or may not like.
- Find small pictures of each of the foods online.
- Save the images to your folder
- Put the cursor in the cell for that food
- Choose insert, picture, from file
- Resize the picture by dragging the corner handles while holding the shift key
- Make all of your pictures so that they are about the same size, and not huge.
- In the column under each person's name, indicate whether they like or don't like that food
- Add a column to the right of the last person's name and title it TOTAL
- Add up the 'likes' for each food and put the amount in the total column.
Table Two:
Make a second table using these techniques to organize the information of your choice.
10-15-09
1. Do a pretest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
2. Do three lessons on http://typing-lessons.org/
3. Do a posttest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
4. Artists and songs - Tables
Your page should have an assignment heading on the top.
Make a table that lists your favorite musical artists and the songs you like by them.
Set the first column to be artist names, one per row
list at least three songs by the artist , one per column
Adjust the border of the column to:
Change the color/style of the columns
Add a heading over the table
Adjust the colors of the table
Make another table similar to this organizing the information of your choice.
Use the autoformat features to change the appearance of the second table.
10-13-09
1. Do a pretest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
2. Do three lessons on http://typing-lessons.org/
3. Do a posttest on http://typingtest.com/ , record your speed, accuracy and net speed in your agenda
4. Your schedule - Tables
In Word, you will at times need to organize information in a table.
Schedule table
Use an assignment header for this.
Make a table with 3 columns and 8 rows
The top row will be for labels, Period in the left cell, Semester 1 in the center cell and Semester 2 in the right cell.
In the left column, put the period names
In the center column, put your first semester classes
In the right column, put your second semester classes.
Table of your choice
On this page, make another table to organize some information.
The table should be at least 3 rows tall and 4 columns wide.
For example:
Players on a Team
| # |
Position |
First Name |
Last name |
| 23 |
Center |
Gareth |
Branwyn |
| 42 |
Forward |
Phillip |
Torrone |
| 61 |
Guard |
Becky |
Stern |
| 10 |
Forward |
Kip |
Kay |
| 3 |
Guard |
Collin |
Cunningham |
10-9-09
1. Do a pretest, record your speed, accuracy and net speed in your agenda
2. Do three lessons on http://typing-lessons.org/
3. Do a posttest, record your speed, accuracy and net speed in your agenda
4. Computer Club information:
Mrs. Allen will talk about what will be happening in the Computer Club this year.
10-8-09
1. Do a pretest, record your speed, accuracy and net speed in your agenda
2. Do three lessons on http://typing-lessons.org/
3. Do a posttest, record your speed, accuracy and net speed in your agenda
Hand in your progress report!
4. You're going on a trip!
Write a paragraph about a trip that you would like to take to a place of your choosing.
Explain what you will do on the trip, and who you will be travelling with.
Make a list of all the things that you will need to go on the trip.
Put your assignment header on the top of the page.
Divide the whole list into three sections, each with its own headline:
- All the things you will need to pack
- All the things you will need to buy
- All the things you will need to get on arrival
Use the Bulletted lists feature in Word to add the dots.
You can change the dots to other shapes.
5. Got it done?
If you complete your work on this and other class assignments, you can work on keyboard based assignments for other classes (papers, homework written assignments, etc).
You can also work on improving your typing skills with type based games.
10-7-09
Do a pretest, record your speed, accuracy and net speed in your agenda
Do three lessons on http://typing-lessons.org/
Do a posttest, record your speed, accuracy and net speed in your agenda
If the printer in the room does not work, you should be able to print to the library.
After you print, go out, get your print and come back
Make sure all of your work is up to date.
Take this brief survey; http://bit.ly/2sDt61
Print a fresh copy of youir speed test spreadsheet to bring home.
How-To
You will be using the list function in the word processor to make a numbered list.
- Make a list of ALL the steps to do something you know well.
- There should be at least 10 steps in your process.
- Use the numbering feature in Word to add numbers to the items.
- Put a heading on the document
- Check your instructional list with two classmates before printing it.
- Have them look for spelling errors, capitalization problems and missed steps.
- Print it and hand it in.
10-5-09
Do a pretest, record your speed, accuracy and net speed in your agenda
Do three lessons on http://typing-lessons.org/
Do a posttest, record your speed, accuracy and net speed in your agenda
Your print options should be better as of this period.
If the printer in the room does not work, you should be able to print to the library.
After you print, go out, get your print and come back
Make sure all of your work is up to date.
Did you get everything printed last period?
Here is the list:
- Folder Card
- Assignment Header
- Touch Typing paragraphs - 9-29-09
- Speed Test data spreadsheet
- Community issues 10-1-09
Make sure all of them are in your folder!
Headlines and styles
It is often useful to make use of headlines and styles in your written work.
Put an assignment heading at the top of your page.
Write two paragraphs about about Fall
In the first paragraph, tell about what you like or dislike about the weather. Write at least 5 sentences, not including repeating the question.
In the second paragraph, tell about what kinds of activities you like to do during the fall. Write at least 5 sentences, not including repeating the question.
Write a descriptive headline for each of the paragraphs.
Use the headline feature in your word processor to modify the headline.
Use Bold, underline and italic to modify and add emphasis to certain words in your text.
10-1-09
Do a pretest, record your speed, accuracy and net speed in your agenda
Do three lessons on http://typing-lessons.org/
Do a posttest, record your speed, accuracy and net speed in your agenda
Your print options should be better as of this period.
If the printer in the room does not work, you should be able to print to the library.
After you print, go out, get your print and come back
Make sure all of your work is up to date.
Here is the list:
- Folder Card
- Assignment Header
- Touch Typing paragraphs - 9-29-09
- Speed Test data spreadsheet
Make sure all of them are handed in!
Community Issues
Write two paragraphs about an issue you feel strongly about in the community.
In the first paragraph:
Explain what the issue is and why it is important to you.
In the second paragraph:
Tell what you think could be done about it.
Paragraphs should be at least 5 sentences long. You should use correct spelling, punctuation and grammar. If you restate the question in your response or summary sentences, don't count those toward the five sentence minimum.
Use an assignment header for the document.
Hand it in before the end of the period.
9-30-09
Do a pretest, record your speed, accuracy and net speed in your agenda
Do three lessons on http://typing-lessons.org/
Do a posttest, record your speed, accuracy and net speed in your agenda
Spreadsheet demonstration
Speed Test Data
Checklist for what you have completed and printed:
Folder Card
Assignment Header
Touch Typing paragraphs - 9-29-09
Speed Test data spreadsheet
9-29-09
Touch Typing Quiz
Touch Typing demo
Written assignment:
What is it like touch typing?
How can you use this skill in the future?
Write this in sentence and paragraph form.
Write at least two paragraphs.
Put an assignment header on your document.
Use proper spelling, punctuation and capitalization.
Make sure your prints of your other assigments are in your folder:
Make an Assignment Heading
Folder Card
Do a speed test - typingtest.com
Write your results in your agenda
Typing lessons on typingtest.com at least three
Do a post test on typingtest.com
9-25-09
1. You should know the keyboard by today.
Work on any lessons that you need to get you familar with touch typing the keyboard.
Do a speed test and keep track of the scores in your agenda.
2. Your folder card should be complete and printed by this period.
Your card should be attached to your folder.
3. Document heading:
Demo for alignment and tabs
Use the document heading to make a page that shows just the heading you would use on a
project assignment.
Print the heading.
9-24-09
1 Know the keyboard by Friday
Use the first 18 lessons on http://www.freetypinggame.net/free-typing-test.asp
Your hands should be covered
Your fingers should be on the home row.
2 Do a typing test
Do at least 3-4 lessons on http://www.freetypinggame.net/free-typing-test.asp
Print or save the certificate for each lesson you do.
Staple the prints together and get them checked off.
Do a speed test to follow up.
3 Print out your Folder Card and certificates from last period
4 Word processer
Tabs and headings
Make an Assigment Heading
9-22-09
1 Know the keyboard by Friday
Use the first 18 lessons on http://www.freetypinggame.net/free-typing-test.asp
Your hands should be covered
Your fingers should be on the home row.
2 Do a typing test
Do at least 3-4 lessons on http://www.freetypinggame.net/free-typing-test.asp
Print or save the certificate for each lesson you do.
Staple the prints together and get them checked off.
Do a speed test to follow up.
3 Demo - Anatomy of the Web Browser
4 Complete your Folder Card
9-21-09
1 Know the keyboard by Friday
After that, we can set personal goals for speed and accuracy
Do the first 18 lessons on http://www.freetypinggame.net/free-typing-test.asp
2 Do a typing test,
3 or more lessons (more will get you familiar with the keyboard quicker)
Print the certificates for each of the lessons you do,
Staple today's together, put them in your folder
Do a post test to follow up
Track your results in your agenda
4 Demonstration - Knowing your way around the web browser
3 Complete your Folder Card
9-18-09
1 Goals for knowing the whole keyboard
Know the whole keyboard by the end of next week
first 18 lessons on freetypinggame.net
2 Use the typing test on http://www.freetypinggame.net/free-typing-test.asp
Set the test to the homerow for a test that matches what you know.
Track your results in your agenda
3. Lessons: Use this page: http://www.freetypinggame.net/free-typing-lesson.asp
Set a speed goal of 10-15 words per minute
Save the lesson completion certificate for each lesson you do.
Do at least three or more lessons.
5. Folder Card
Design your card, add your photo, rotate your photo
Print a copy for your folder and one to take home before the end of the period.
9-16-09
1 Stretches you can do while typing
http://www.ualr.edu/star/healthy_keyboarding/techniques.htm
2 Use the typing test on http://www.freetypinggame.net/free-typing-test.asp
Set the test to the homerow for a test that matches what you know.
Track your results in your agenda
3. Lessons: Use this page: http://www.freetypinggame.net/free-typing-lesson.asp
Set a speed goal of 10-15 words per minute
Save the lesson completion certificate for each lesson you do.
Do at least three or more lessons.
4 http://Typingtest.com/
5. Folder Card
9-15-09
Proper hand and body position: http://www.freetypinggame.net/proper-hand-placement.asp
1. Take a typing Pre Test http://www.typingtest.com/
Touch Typing
2. Lessons: Use this page: http://www.freetypinggame.net/free-typing-lesson.asp
Set a speed goal of 10-15 words per minute
Do at least three lessons.
If you go all the way through the lesson and meet your goal, you will get a printable certificate.
You can either save this certificate to print later or print it if the printer is working.
3. Take a typing Post Test http://www.typingtest.com/
4. Typing Test Spreadsheet
9-11-09
How do I learn to touch type the home row of the keyboard?
Process:
- Use your keyboard cover for your test, lessons and post test.
- Take a Pretest on http://www.typingtest.com/
- Record the speed accuracy and net speed in your agenda.
- Use the online resources listed below for learning the home row without looking
- Take a Post test on http://www.typingtest.com/
- Record the speed accuracy and net speed in your agenda.
Resources:
Use your keyboard cover
Covered hands speed test on http://www.typingtest.com/
Use online lessons to learn the home row:
Sense - Lang - http://www.sense-lang.org/typing/tutor/index.php?lang=EN
Typing lessons on http://typing-lessons.org/
Free Typing Game - http://www.freetypinggame.net/free-typing-lesson.asp
Type Online - http://www.typeonline.co.uk/lesson1.html
Power typing - http://www.powertyping.com/qwerty/lessonsq.html
Typing Web - http://www.typingweb.com/tutor/courses/
9-10-09
What are some productive ways to work with Word?
Where can I save and find my work?
How fast can I type without looking?
How can I save the information from my speed tests?
Activities:
Covered hands speed test on http://www.typingtest.com/
Typing lessons on http://typing-lessons.org/
Do another typing test after the typing lesson
Save the information from your test in a spreadsheet
Headings: date | speed before | accuracy before | net speed before | lessons done | speed after | accuracy after | net speed after
9-9-09
Where should I store my work?
How can I lay out a page with a photo, text and other graphics
Activities:
Folder Card
KeyboardCover - Make a keyboard cover with two 11x17 sheets of paper.
Typing test Cover your keyboard and take a 1 minute typing test- http://www.typingtest.com/
Typing lesson Keep your keyboard covered, and work on the home row - http://www.typing-lessons.org/
9-2-09
Welcome back!
What can I expect, and what will be expected of me in class this semester?
Handouts:
Class Guidelines and Grading policy
Content overview of semester
Activity:
community building
Accessing computer accounts
Comments (0)
You don't have permission to comment on this page.