×
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
Spreadsheets
iPad Classroom Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple / Mac Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Coding For Kids Resources

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

Fourth Grade Computer Lessons Qtr. 1

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

Computer Lab Rules

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

Proper finger placement on the keyboard
  1. Assign Typing Practice Stages 1-3
  2. Assign 25-30 minutes or until done.

    Typing Stage 1 Typing Stage 2 Typing Stage 3
  3. Assign 3 Minutes of: Typing Rocket Jr. Try to get a final score of 60 points or more.
  4. Assign: Keyboard Climber. Type with both hands. FINISH level two.
  5. Type Rocket Jr. Typing Stage 3
  6. 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 Graphic Organizer - Black My Vacation Graphic Organizer - Pink My Vacation Graphic Organizer - Purple My Vacation Graphic Organizer - Blue My Vacation Graphic Organizer - Black

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.
  2. Download: My Vacation - Instructions

    My Vacation - Instructions My Vacation - Example
  3. Alternative Activities:
  4. All About Me Acrostic All About Me Acrostic All About Me Pic Collage
  5. 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. Typing Stage 1 Typing Stage 2 Typing Stage 3 Typing Stage 4
  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. Type Rocket Jr. Typing Practice
  5. 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. School Supplies Spreadsheet Example School Supplies Price List
  3. Demonstrate how to enter text and numbers into the spreadsheet.
  4. Demonstrate how to use the SUM formula to calculate the total expenses.
  5. Demonstrate how to format the prices with dollar $ signs.
  6. Demonstrate how to create a chart with the data to illustrate the expenses.
  7. Demonstrate how to add clipart or images if possible.
  8. Demonstrate how to Save / Print as necessary.
  9. Watch Short Video Spreadsheet Tutorials Here
  10. 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. Typing Stage 1 Typing Stage 2 Typing Stage 3 Typing Stage 4
  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. Type Rocket Jr. Typing Practice
  5. 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. Clothes Shopping Spreadsheet Example Clothes Shopping Price List
  3. Demonstrate how to enter text and numbers into the spreadsheet.
  4. Demonstrate how to use the SUM formula to calculate the total expenses.
  5. Demonstrate how to format the prices with dollar $ signs.
  6. Demonstrate how to create a chart with the data to illustrate the expenses.
  7. Demonstrate how to add clipart or images if possible.
  8. Demonstrate how to Save / Print as necessary.
  9. Watch Short Video Spreadsheet Tutorials Here
  10. 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. Typing Stage 1 Typing Stage 2 Typing Stage 3 Typing Stage 4
  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. Type Rocket Jr. Typing Practice
  5. 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. Munch Box Lunch Expenses Spreadsheet Munch Box Lunch Menu
  3. Demonstrate how to enter text and numbers into the spreadsheet.
  4. Demonstrate how to use the SUM formula to calculate the total expenses.
  5. Demonstrate how to format the prices with dollar $ signs.
  6. Demonstrate how to create a chart with the data to illustrate the expenses.
  7. Demonstrate how to add clipart or images if possible.
  8. Demonstrate how to Save / Print as necessary.
  9. Watch Short Video Spreadsheet Tutorials Here
  10. 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. Typing Stage 1 Typing Stage 2 Typing Stage 3 Typing Stage 4
  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. Type Rocket Jr. Typing Practice
  5. 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. Sports Equipment Expenses Spreadsheet Sports Equipment Price List
  3. Demonstrate how to enter text and numbers into the spreadsheet.
  4. Demonstrate how to use the SUM formula to calculate the total expenses.
  5. Demonstrate how to format the prices with dollar $ signs.
  6. Demonstrate how to create a chart with the data to illustrate the expenses.
  7. Demonstrate how to add clipart or images if possible.
  8. Demonstrate how to Save / Print as necessary.
  9. Watch Short Video Spreadsheet Tutorials Here
  10. 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. Typing Stage 1 Typing Stage 2 Typing Stage 3 Typing Stage 4
  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. Type Rocket Jr. Typing Practice
  5. 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. Camping Trip Expenses Spreadsheet Camping Trip Price List
  3. Demonstrate how to enter text and numbers into the spreadsheet.
  4. Demonstrate how to use the SUM formula to calculate the total expenses.
  5. Demonstrate how to format the prices with dollar $ signs.
  6. Demonstrate how to create a chart with the data to illustrate the expenses.
  7. Demonstrate how to add clipart or images if possible.
  8. Demonstrate how to Save / Print as necessary.
  9. Watch Short Video Spreadsheet Tutorials Here
  10. 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. Typing Stage 1 Typing Stage 2 Typing Stage 3 Typing Stage 4
  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. Type Rocket Jr. Typing Practice
  5. 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. Night at the Movies Expense Spreadsheet Mega Movies Price List
  3. Demonstrate how to enter text and numbers into the spreadsheet.
  4. Demonstrate how to use the SUM formula to calculate the total expenses.
  5. Demonstrate how to format the prices with dollar $ signs.
  6. Demonstrate how to create a chart with the data to illustrate the expenses.
  7. Demonstrate how to add clipart or images if possible.
  8. Demonstrate how to Save / Print as necessary.
  9. Watch Short Video Spreadsheet Tutorials Here
  10. 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. Typing Stage 1 Typing Stage 2 Typing Stage 3 Typing Stage 4
  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. Type Rocket Jr. Typing Practice
  5. 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. Thanksgiving Dinner Spreadsheet Thanksgiving Food Price List
  3. Demonstrate how to enter text and numbers into the spreadsheet.
  4. Demonstrate how to use the SUM formula to calculate the total expenses.
  5. Demonstrate how to format the prices with dollar $ signs.
  6. Demonstrate how to create a chart with the data to illustrate the expenses.
  7. Demonstrate how to add clipart or images if possible.
  8. Demonstrate how to Save / Print as necessary.
  9. Watch Short Video Spreadsheet Tutorials Here
  10. 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. Typing Stage 1 Typing Stage 2 Typing Stage 3 Typing Stage 4
  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. Type Rocket Jr. Typing Practice
  5. 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. Typing Stage 1 Typing Stage 2 Typing Stage 3 Typing Stage 4
  4. 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.

  5. Type Rocket Jr. Typing Practice
  6. Assign Enrichment - Students work on these enrichment activities after typing.