×
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

Fifth Grade Technology Lessons - Qtr. 1

Touch Typing, Spreadsheet Budgets with Charts

Fifth 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 proficiency. 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 placement, 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 Fifth Graders aim for typing about 25 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. Adjust the activity selections according to your own needs.

Week 1 - Qtr. 1 - Fifth 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 - Fifth 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 - Fifth 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 - Fifth Grade


Session 2:

Budget Spreadsheet with Chart | Enrichment

Students create a budget spreadsheet and chart with school supplies.

  1. Assign: School Supplies Budget Spreadsheet

    Instructions: Students have $65.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 create a budget using a spreadsheet to show how much they have to spend (allowance), and how much each item costs (expenses). Students use a simple formula (sum) to calculate the total expenses. Students create a simple formula to subtract total expenses from the $65.00 allowance to show how much money is left over (allowance - total expenses = money left over). Students create a chart showing their expenses.

    Back to School School Supplies Budget

  2. School Supplies Spreadsheet Budget Example School Supplies Price List Rubric for Spreadsheet with Chart
  3. Watch Short Video Spreadsheet Tutorials Here
  4. Demonstrate how to enter text and numbers into the spreadsheet.
  5. Demonstrate how to use the SUM formula to calculate the total expenses.
  6. Demonstrate Demonstrate how to use a formula to calculate Money Left Over (allowance - expenses).
  7. Demonstrate how to format the prices with dollar $ signs.
  8. Demonstrate how to create a chart with the data to illustrate the expenses.
  9. Demonstrate how to add clipart or images if possible.
  10. Demonstrate how to Save / Print as necessary.
  11. Assign Enrichment - Students work on these enrichment activities when finished.

Week 3 - Qtr. 1: Fifth 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: Fifth Grade


Session 2:

Budget Spreadsheet with Chart | Enrichment

Students create a Budget Spreadsheet and chart with clothing items.

  1. Assign: Clothes Shopping Budget Spreadsheet

    Instructions: Students have $150.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 a budget using a spreadsheet to show how much they have to spend (allowance), and how much each item costs (expenses). Students use a simple formula (sum) to calculate the total expenses. Students create a simple formula to subtract total expenses from the $150.00 allowance to show how much money is left over (allowance - total expenses = money left over). Students create a chart showing their expenses.

    Clothes Shopping Budget

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

Week 4 - Qtr. 1: Fifth 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: Fifth Grade


Session 2:

Budget Spreadsheet with Chart | Enrichment

Students create a party food budget spreadsheet and chart.

  1. Assign: Party for Five Food Budget Spreadsheet and Chart

    Instructions: Students have a budget of $25.00 to feed a total of 5 people (including themselves) for a party. Students must try to buy as much as they can without going over the budget. Students create a budget using a spreadsheet to show how much they have to spend (allowance), and how much each item costs (expenses). Students use a simple formula (sum) to calculate the total expenses. Students create a simple formula to subtract total expenses from their allowance to show how much money is left over (allowance - total expenses = money left over). Students create a chart showing their expenses.

    Party for Five Food Budget

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

Week 5 - Qtr. 1: Fifth 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: Fifth Grade


Session 2:

Budget Spreadsheet with Chart | Enrichment

Students create a pet adoption budget and chart.

  1. Assign: Puppy Pet Adoption Budget Spreadsheet

    Instructions: Students have a budget of $200.00 to adopt a new puppy and a variety of related items for the puppy. Students choose all the items they think they need to get started taking care of the new puppy, but they must keep costs under $200.00. Students create a budget using a spreadsheet to show how much they have to spend (allowance), and how much each item costs (expenses). Students use a simple formula (sum) to calculate the total expenses. Students create a simple formula to subtract total expenses from their allowance to show how much money is left over (allowance - total expenses = money left over). Students create a chart showing their expenses.

    Pet Adoption Budget

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

Week 6 - Qtr. 1: Fifth 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: Fifth Grade


Session 2:

Budget Spreadsheet with Chart | Enrichment

Students plan a party and stick to the budget.

  1. Assign: Birthday Party Budget Spreadsheet

    Instructions: Students have a budget of $100.00 to feed a total of 15 people (including themselves) for a birthday party. Students create a birthday party budget spreadsheet to show how much they have to spend ( $100.00), the total costs of the items they buy, and how much they are over or under the budget amount. Students research online stores (Amazon, Walmart, other) to find their party items and prices. Students may use the "Quick Start Template" to save time.

    Birthday Party Budget

  2. Birthday Party Budget Party Budget Quick Start Template Rubric for Spreadsheet with Chart
  3. Watch Short Video Spreadsheet Tutorials Here
  4. Demonstrate how to enter text and numbers into the spreadsheet.
  5. Demonstrate how to use the SUM formula to calculate the total expenses.
  6. Demonstrate Demonstrate how to use a formula to calculate Money Left Over (allowance - expenses).
  7. Demonstrate how to format the prices with dollar $ signs.
  8. Demonstrate how to create a chart with the data to illustrate the expenses.
  9. Demonstrate how to add clipart or images if possible.
  10. Demonstrate how to Save / Print as necessary.
  11. Assign Enrichment - Students work on these enrichment activities when finished.

Week 7 - Qtr. 1: Fifth 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: Fifth Grade


Session 2:

Spreadsheet with Chart | Enrichment

Students chart fast food nutrition and calorie information.

  1. Assign: Fast Food Calorie Chart

    Instructions: Students search for fast food nutrition and calorie information on the internet. Students plan a meal with a burger, sandwich or salad, along with a side order of french fries or other item. Students also add a drink and a dessert to their meal. Students enter the calories and the fat calories for each item into their spreadsheet. Students choose any restaurant they would like to eat at for their planned meal (McDonalds, Burger King, Jack in the Box, Wendy's, Subway, Taco Bell, Carl's Jr. etc).

    Fast Food Nutrition Facts

  2. Fast Food Nutrition Facts Spreadsheet Instructions Fast Food Nutrition Facts Spreadsheet Rubric for Spreadsheet with Chart
  3. Demonstrate how to enter text and numbers into the spreadsheet.
  4. Demonstrate how to use the SUM formula to calculate totals.
  5. Demonstrate how to create a chart with the data.
  6. Demonstrate how to add clipart or images if possible.
  7. Demonstrate how to Save / Print as necessary.
  8. Assign Enrichment - Students work on these enrichment activities when finished.

Week 8 - Qtr. 1: Fifth 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: Fifth Grade


Session 2:

Profit / Loss Spreadsheet with Chart | Enrichment

Students create a profit or loss spreadsheet and chart for a lemonade stand.

  1. Assign: Profit or Loss Spreadsheet for Lemonade Stand

    Instructions: Students create a profit or loss spreadsheet and chart for a lemonade stand with 6 days of sales and expenses. Students use the random number generator to get their sales and expenses numbers for each day. Students enter their data in the spreadsheet for each day. Students use a formula (sum) to calculate expenses. Students use a simple formula to calculate profits or losses (sales - total expenses = profit).

    Lemonade Stand Profit or Loss Spreadsheet

  2. Lemonade Stand Profit or Loss Spreadsheet Lemonade Stand Profit or Loss Instructions
  3. Watch Short Video Spreadsheet Tutorials Here
  4. Demonstrate how to enter text and numbers into the spreadsheet.
  5. Demonstrate how to use the SUM formula to calculate the total expenses.
  6. Demonstrate Demonstrate how to use a formula to calculate Profit or Loss (Sales - Total Expenses).
  7. Demonstrate how to format the values with dollar $ signs.
  8. Demonstrate how to create a chart with the data to illustrate the profits or losses.
  9. Demonstrate how to add clipart or images if possible.
  10. Demonstrate how to Save / Print as necessary.
  11. Assign Enrichment - Students work on these enrichment activities when finished.

Week 9 - Qtr. 1: Fifth 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: Fifth 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.