Fourth Grade Technology Lessons - Qtr. 1

Touch Typing, Spreadsheet Budgets with Charts

Fourth Grade Technology Lessons focus on (Qtr.1) - typing skills development and spreadsheet budgets with charts, (Qtr.2) coding and logic games, (Qtr.3) graphics / photo editing , and (Qtr.4) presentations.

In the 1st Qtr, students continue to develop two hand homerow typing profiency. Students also create a variety of spreadsheet budgets with charts.

Students will learn spreadsheet vocabulary such as rows,columns, cells, data, values, and formulas. Spreadsheets may be created using a variety of spreadsheet applications from Microsoft, Google, Apple, or other similar programs.

Recommendations:

1. Typing Lessons: Focus on typing accuracy, proper finger placment, not speed. Speed will be acquired naturally over time in the future months and years of typing lessons. However, if you need a benchmark of Words Per Minute typed, then I use about 5 words per minute per grade level. That means Fourth graders aim for typing about 20 words per minute on average.
2. File Distribution: Share assignment files using a cloud storage service, your school's learning management system, or a shared network drive on your school's internal network.
3. Enrichment: Use the enrichment activities to support regular classroom curricula. Good for early finishers, late arrivals, supplementation, differentiation.
4. Time Management: These weekly lessons are programmed for 2 weekly sessions of 45 minutes each. Adust the activity selections according to your own needs.

Fourth Grade Technology Lesson Schedule:

First Quarter - Aug ~ Oct

Main Topics Covered: Typing, Spreadsheet Budgets

9 Sessions = Typing with fingers on home row - no pecky typing

1 Session = Word Processing (My Vacation)

7 Sessions = Spreadsheet Budgets with charts

1 Session = Spreadsheet Formulas

Prerequisites: Internet access, Spreadsheet program.

Week 1 - Qtr. 1 - Fourth Grade

Session 1:

Introductions | Lab Rules | Typing | Enrichment

Do Introductions: Introduction to the computer lab teacher, discuss what we will do in the lab. Spend time getting to know the students.

Review Computer Lab Rules: Discuss the rules of the computer lab

Review of Typing Stage 1: Demonstrate how to use Dance Mat Typing stage one, level one or your school's preferred typing program. Review the homerow and proper finger technique.

Download: proper-keyboard-finger-placement-on-the-keyboard.pdf

1. Assign Typing Practice Stages 1-3

Assign 25-30 minutes or until done.

2. Assign 3 Minutes of: Typing Rocket Jr. Try to get a final score of 60 points or more.
3. Assign: Keyboard Climber. Type with both hands. FINISH level two.
4. Assign Enrichment - Students work on these enrichment activities after typing.

Week 1 - Qtr. 1 - Fourth Grade

Session 2:

Word Processing - "My Vacation" | Enrichment

Students use a fun graphic organizer to write about their vacation

My Vacation: Make the "My Vacation" templates available to the students. Demonstrate how to write in the editable text box. Download the "My Vacation Instructions."

1. Assign: "My Vacation" writing. Students write 120+ words about their vacation. Students will save / print their finished work.

Download: My Vacation - Instructions

2. Alternative Activities:
3. Assign Enrichment - Students work on these enrichment activities when finished.

Week 2 - Qtr. 1 - Fourth Grade

Session 1:

Typing | Enrichment

Review Typing: Demonstrate how to use Dance Mat Typing or your school's preferred typing program. Review the homerow and proper finger technique.

1. Assign Typing Practice. Students Choose any THREE

   Assign 25-30 minutes or until done.

2. Assign 3 Minutes of: Typing Rocket Jr. Try to get a final score of 60 points or more.

   Assign: Keyboard Climber . Type with both hands. FINISH level two.

3. Assign Enrichment - Students work on these enrichment activities after typing.

Week 2 - Qtr. 1 - Fourth Grade

Session 2:

Expense Spreadsheet with Chart | Enrichment

Students create an expense spreadsheet and chart for school supplies.

1. Assign: School Supplies Expense Spreadsheet

   Instructions: Students have $60.00 to spend on school supplies. Students use the School Supplies Price List to purchase as many items as they can without going over budget. Students use a simple formula (SUM) to calculate their total expenses. Students enter their choices into a spreadsheet and create a chart with the data.

   Back to School School Supplies Expenses

2. Demonstrate how to enter text and numbers into the spreadsheet.
3. Demonstrate how to use the SUM formula to calculate the total expenses.
4. Demonstrate how to format the prices with dollar $ signs.
5. Demonstrate how to create a chart with the data to illustrate the expenses.
6. Demonstrate how to add clipart or images if possible.
7. Demonstrate how to Save / Print as necessary.
8. Watch Short Video Spreadsheet Tutorials Here
9. Assign Enrichment - Students work on these enrichment activities when finished.

Week 3 - Qtr. 1: Fourth Grade

Session 1:

Typing | Enrichment

Review Typing: Demonstrate how to use Dance Mat Typing or your school's preferred typing program. Review the homerow and proper finger technique.

1. Assign Typing Practice. Assign 25-30 minutes or until done.
2. Assign 3 Minutes of: Typing Rocket Jr. Try to get a final score of 60 points or more.

   Assign: Keyboard Climber . Type with both hands. FINISH level two.

3. Assign Enrichment - Students work on these enrichment activities after typing.

Week 3 - Qtr. 1: Fourth Grade

Session 2:

Expense Spreadsheet with Chart | Enrichment

Students create an expense spreadsheet and chart with clothing items.

1. Assign: Clothes Shopping Expenses Spreadsheet

   Instructions: Students have $125.00 to spend on school clothes. Students use the Clothes Shopping Price List to purchase as many items as they can without going over budget. Students create their spreadsheet using the list of clothes and their prices. Students use a formula (SUM) to calculate their total clothing expenses. Students create a chart illustrating their clothing expenses.

   Clothes Shopping Expenses

2. Demonstrate how to enter text and numbers into the spreadsheet.
3. Demonstrate how to use the SUM formula to calculate the total expenses.
4. Demonstrate how to format the prices with dollar $ signs.
5. Demonstrate how to create a chart with the data to illustrate the expenses.
6. Demonstrate how to add clipart or images if possible.
7. Demonstrate how to Save / Print as necessary.
8. Watch Short Video Spreadsheet Tutorials Here
9. Assign Enrichment - Students work on these enrichment activities when finished.

Week 4 - Qtr. 1: Fourth Grade

Session 1:

Typing | Enrichment

Review Typing: Demonstrate how to use Dance Mat Typing or your school's preferred typing program. Review the homerow and proper finger technique.

1. Assign Typing Practice. Assign 25-30 minutes or until done.
2. Assign 3 Minutes of: Typing Rocket Jr. Try to get a final score of 60 points or more.

   Assign: Keyboard Climber . Type with both hands. FINISH level two.

3. Assign Enrichment - Students work on these enrichment activities after typing.

Week 4 - Qtr. 1: Fourth Grade

Session 2:

Expense Spreadsheet with Chart | Enrichment

Students create a lunch expenses spreadsheet and chart.

1. Assign: Munch Box Spreadsheet and Chart

   Instructions: Students have one gift card for $15.00 for the school cafeteria called the "Munch Box". Students choose lunch items from the Munch Box Menu provided. Students select enough items to get food and drinks for themselves and one very hungry and thirsty friend for lunch. Students purchase as many items as they can without going over budget. Students create an expense chart showing the costs of their purchases.

   Lunch Expenses for Two

2. Demonstrate how to enter text and numbers into the spreadsheet.
3. Demonstrate how to use the SUM formula to calculate the total expenses.
4. Demonstrate how to format the prices with dollar $ signs.
5. Demonstrate how to create a chart with the data to illustrate the expenses.
6. Demonstrate how to add clipart or images if possible.
7. Demonstrate how to Save / Print as necessary.
8. Watch Short Video Spreadsheet Tutorials Here
9. Assign Enrichment - Students work on these enrichment activities when finished.

Week 5 - Qtr. 1: Fourth Grade

Session 1:

Typing | Enrichment

Review Typing: Demonstrate how to use Dance Mat Typing or your school's preferred typing program. Review the homerow and proper finger technique.

1. Assign Typing Practice. Assign 25-30 minutes or until done.
2. Assign 3 Minutes of: Typing Rocket Jr. Try to get a final score of 60 points or more.

   Assign: Keyboard Climber . Type with both hands. FINISH level two.

3. Assign Enrichment - Students work on these enrichment activities after typing.

Week 5 - Qtr. 1: Fourth Grade

Session 2:

Expense Spreadsheet with Chart | Enrichment

Students create an expense spreadsheet and chart with sports equipment.

1. Assign: Sports Equipment Expenses Spreadsheet

   Instructions: Students shop for sports equipment for their school. Students should spend as much as they can without going over $200.00. Students create their spreadsheet using the list of sports equipment and their prices. Students format the numbers with dollar signs. Students use a formula (SUM) to calculate the total cost. Students create a chart illustrating their expenses. Students may add clipart or related images.

   Sports Equipment Expenses

2. Demonstrate how to enter text and numbers into the spreadsheet.
3. Demonstrate how to use the SUM formula to calculate the total expenses.
4. Demonstrate how to format the prices with dollar $ signs.
5. Demonstrate how to create a chart with the data to illustrate the expenses.
6. Demonstrate how to add clipart or images if possible.
7. Demonstrate how to Save / Print as necessary.
8. Watch Short Video Spreadsheet Tutorials Here
9. Assign Enrichment - Students work on these enrichment activities when finished.

Week 6 - Qtr. 1: Fourth Grade

Session 1:

Typing | Enrichment

Review Typing: Demonstrate how to use Dance Mat Typing or your school's preferred typing program. Review the homerow and proper finger technique.

1. Assign Typing Practice. Assign 25-30 minutes or until done.
2. Assign 3 Minutes of: Typing Rocket Jr. Try to get a final score of 60 points or more.

   Assign: Keyboard Climber . Type with both hands. FINISH level two.

3. Assign Enrichment - Students work on these enrichment activities after typing.

Week 6 - Qtr. 1: Fourth Grade

Session 2:

Expense Spreadsheet with Chart | Enrichment

Students create an expense spreadsheet and chart with camping supplies.

1. Assign: Camping Trip Supplies Expenses Spreadsheet

   Instructions: Students shop for camping trip supplies. Students should spend as much as they can without going over $300.00. Students need to purchase a variety of supplies to make their outdoor experience as safe, comfortable, and fun as possible.Students create their spreadsheet using the list of camping equipment and their prices. Students format the numbers with dollar signs. Students use a formula (SUM) to calculate the total cost. Students create a chart illustrating their camping supplies expenses. Students may add clipart or related images.

   Camping Trip Supplies Expenses

2. Demonstrate how to enter text and numbers into the spreadsheet.
3. Demonstrate how to use the SUM formula to calculate the total expenses.
4. Demonstrate how to format the prices with dollar $ signs.
5. Demonstrate how to create a chart with the data to illustrate the expenses.
6. Demonstrate how to add clipart or images if possible.
7. Demonstrate how to Save / Print as necessary.
8. Watch Short Video Spreadsheet Tutorials Here
9. Assign Enrichment - Students work on these enrichment activities when finished.

Week 7 - Qtr. 1: Fourth Grade

Session 1:

Typing | Enrichment

Review Typing: Demonstrate how to use Dance Mat Typing or your school's preferred typing program. Review the homerow and proper finger technique.

1. Assign Typing Practice. Assign 25-30 minutes or until done.
2. Assign 3 Minutes of: Typing Rocket Jr. Try to get a final score of 60 points or more.

   Assign: Keyboard Climber . Type with both hands. FINISH level two.

3. Assign Enrichment - Students work on these enrichment activities after typing.

Week 7 - Qtr. 1: Fourth Grade

Session 2:

Expense Spreadsheet with Chart | Enrichment

Students create an expense spreadsheet and chart for a night at the movies.

1. Assign: Movie Night Expenses Spreadsheet

   Instructions: A student and a friend or family member go to the movies and buy movie tickets along with some food and drinks. Students should spend as much as they can without going over $60.00. Students create their spreadsheet using prices from the Mega Movies price list. Students format the numbers with dollar signs. Students use a formula (SUM) to calculate the total cost. Students create a chart illustrating their expenses. Students may add clipart or related images.

   Movie Night Expenses

2. Demonstrate how to enter text and numbers into the spreadsheet.
3. Demonstrate how to use the SUM formula to calculate the total expenses.
4. Demonstrate how to format the prices with dollar $ signs.
5. Demonstrate how to create a chart with the data to illustrate the expenses.
6. Demonstrate how to add clipart or images if possible.
7. Demonstrate how to Save / Print as necessary.
8. Watch Short Video Spreadsheet Tutorials Here
9. Assign Enrichment - Students work on these enrichment activities when finished.

Week 8 - Qtr. 1: Fourth Grade

Session 1:

Typing | Enrichment

Review Typing: Demonstrate how to use Dance Mat Typing or your school's preferred typing program. Review the homerow and proper finger technique.

1. Assign Typing Practice. Assign 25-30 minutes or until done.
2. Assign 3 Minutes of: Typing Rocket Jr. Try to get a final score of 60 points or more.

   Assign: Keyboard Climber . Type with both hands. FINISH level two.

3. Assign Enrichment - Students work on these enrichment activities after typing.

Week 8 - Qtr. 1: Fourth Grade

Session 2:

Expense Spreadsheet with Chart | Enrichment

Students create an expense spreadsheet and chart for a Thanksgiving dinner.

1. Assign: Thanksgiving Dinner Expenses Comparison Spreadsheet

   Instructions: Students create a spreadsheet and chart comparing Thanksgiving dinner prices for two stores. Students choose the same 6 or 7 items from each store to compare. Students create their spreadsheet using prices from the Thanksgiving price list. Students format the numbers with dollar signs. Students use a formula (SUM) to calculate the total costs. Students create a chart illustrating their expenses. Students may add clipart or related images.

   Thanksgiving Dinner Expenses

2. Demonstrate how to enter text and numbers into the spreadsheet.
3. Demonstrate how to use the SUM formula to calculate the total expenses.
4. Demonstrate how to format the prices with dollar $ signs.
5. Demonstrate how to create a chart with the data to illustrate the expenses.
6. Demonstrate how to add clipart or images if possible.
7. Demonstrate how to Save / Print as necessary.
8. Watch Short Video Spreadsheet Tutorials Here
9. Assign Enrichment - Students work on these enrichment activities when finished.

Week 9 - Qtr. 1: Fourth Grade

Session 1:

Typing | Enrichment

Review Typing: Demonstrate how to use Dance Mat Typing or your school's preferred typing program. Review the homerow and proper finger technique.

1. Assign Typing Practice. Assign 25-30 minutes or until done.
2. Assign 3 Minutes of: Typing Rocket Jr. Try to get a final score of 60 points or more.

   Assign: Keyboard Climber . Type with both hands. FINISH level two.

3. Assign Enrichment - Students work on these enrichment activities after typing.

Week 9 - Qtr. 1: Fourth Grade

Session 2:

Spreadsheet Formulas | Enrichment

1. Assign: Simon's Spreadsheet Formulas (add and subtract), (multiply and divide), (multiple operations). Students practice using formulas in a spreadsheet.
2. Assign Typing Practice. Assign 25-30 minutes or until done.
3. Assign 3 Minutes of: Typing Rocket Jr. Try to get a final score of 60 points or more.

   Assign: Keyboard Climber . Type with both hands. FINISH level two.

4. Assign Enrichment - Students work on these enrichment activities after typing.