1st Quarter

Touch Typing & Expense Spreadsheets with Charts

Third Grade Technology Lessons focus on typing skills development and expense spreadsheets with charts (Q1), coding and logic games (Q2), research (Q3), and presentations (Q4).

In Q1, students continue to develop two hand homerow typing proficiency. Students also create expense spreadsheets 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 and other similar programs.

Session 1: Introductions, Lab Rules, Typing and Enrichment

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:

Review of Typing Stage 1:

• Demonstrate how to use Dance Mat Typing Stage 1, Level 1 (ASDF, JKL, and G, H).
• Review the home row and proper finger technique.
• Download proper keyboard finger placement poster.

Typing Practice Stage 1-3:

• Practice for 25-30 minutes or until done.

Additional Typing Practice:

• 3 minutes of Typing Rocket JR.
  • Type with both hands, try to get a final score of 60 points or more.
• Finish level 2 of Keyboard Climber 2. Type with both hands.

Enrichment:

• Students work on enrichment activities after typing.

Session 2: Word Processing, "My Vacation" and Enrichment

My Vacation:

• Make the "My Vacation" templates available to the students.
  • Demonstrate how to write in the editable text boxes.
• Students use a graphic organizer to write about their vacation.
  • Write 100+ words about your vacation. Save / print their finished work.

Alternate Activities:

• iPad - All About Me Acrostic
• iPad - All About Me Balloon Stickies
• iPad - All About Me Pic Collage

Enrichment:

• Students work on enrichment activities when finished.

Session 1: Typing and Enrichment

Review:

• Demonstrate how to use Dance May Typing Stage 1, Level 1 (ASDF, JKL, and G, H).
• Review home row position and proper finger technique.

Typing Practice Stage 1-3:

• Practice 25-30 minutes or until done.

Additional Typing Practice:

• 3 minutes of Typing Rocket JR.
  • Type with both hands, try to get a final score of 60 points or more.
• Finish level 2 of Keyboard Climber 2. Type with both hands.

Enrichment:

• Students work on enrichment activities after typing.

Session 2: Spreadsheet with Chart and Enrichment

Favorite Ice Cream Flavor:

• Create a spreadsheet and chart about your classmates' favorite ice cream flavor.
  • Demonstrate how to enter the title, text, and numbers into the spreadsheet.
  • Demonstrate how to create a chart with the data entered.
  • Watch the 25 Second First Chart video tutorial.
• Students use the tally sheet to survey the class on their favorite ice cream flavors.
  • Use the data collected to create your own spreadsheet and chart.

Enrichment:

• Students work on enrichment activities when finished.

Session 1: Typing and Enrichment

Review:

• Demonstrate how to use Dance May Typing Stage 1, Level 1 (ASDF, JKL, and G, H).
• Review home row position and proper finger technique.

Typing Practice Stage 1-3:

• Practice 25-30 minutes or until done.

Additional Typing Practice:

• 3 minutes of Typing Rocket JR.
  • Type with both hands, try to get a final score of 60 points or more.
• Finish level 2 of Keyboard Climber 2. Type with both hands.

Enrichment:

• Students work on enrichment activities after typing.

Session 2: Spreadsheet with Chart and Enrichment

What Is Your Favorite Subject?:

• Create a spreadsheet and chart about your classmates' favorite subject.
  • Demonstrate how to enter the title, text, and numbers into the spreadsheet.
  • Demonstrate how to create a chart with the data entered.
  • Demonstrate how to add images or clipart.
  • Watch the 25 Second First Chart video tutorial.
• Students use the tally sheet to survey the class on their favorite subjects.
  • Use the data collected to create your own spreadsheet and chart.

Enrichment:

• Students work on enrichment activities when finished.

Session 1: Typing and Enrichment

Review:

• Demonstrate how to use Dance May Typing Stage 1, Level 1 (ASDF, JKL, and G, H).
• Review home row position and proper finger technique.

Typing Practice Stage 1-3:

• Practice 25-30 minutes or until done.

Additional Typing Practice:

• 3 minutes of Typing Rocket JR.
  • Type with both hands, try to get a final score of 60 points or more.
• Finish level 2 of Keyboard Climber 2. Type with both hands.

Enrichment:

• Students work on enrichment activities after typing.

Session 2: Spreadsheet with Chart and Enrichment

Zoo Animals Chart:

• Create a spreadsheet and chart with zoo animals.
  • Demonstrate how to enter the title, text, and numbers into the spreadsheet.
  • Demonstrate how to create a chart with the data entered.
  • Demonstrate how to add images or clipart.
  • Watch the 25 Second First Chart video tutorial.
• Students imagine you have a mini-zoo with several types of animals.
  • Use the Zoo Animals Handout to count how many mammals, birds, fish, reptiles, or amphibians you have.
  • Use the data collected to create your own spreadsheet and pie chart illustrating the number of each type of animal in your zoo.

Enrichment:

• Students work on enrichment activities when finished.

Session 1: Typing and Enrichment

Review:

• Demonstrate how to use Dance May Typing Stage 1, Level 1 (ASDF, JKL, and G, H).
• Review home row position and proper finger technique.

Typing Practice Stage 1-4:

• Practice 25-30 minutes or until done.

Additional Typing Practice:

• 3 minutes of Typing Rocket JR.
  • Type with both hands, try to get a final score of 60 points or more.
• Finish level 2 of Keyboard Climber 2. Type with both hands.

Enrichment:

• Students work on enrichment activities after typing.

Session 2: Spreadsheet with Chart and Enrichment

Fruit Stand with Chart:

• Create a spreadsheet and chart with fruits for a fruit stand.
  • Demonstrate how to enter the title, text, and numbers into the spreadsheet.
  • Demonstrate how to create a chart with the data entered.
  • Demonstrate how to add images or clipart.
  • Watch the 25 Second First Chart video tutorial.
• Students imagine you're raising funds to help needy children pay for school supplies by making & selling fresh fruit juice and smoothies.
  • Choose at least 8 items from the Fruit Stand Shopping List.
  • Create your own spreadsheet and chart illustrating items you need for your fruit stand.

Enrichment:

• Students work on enrichment activities when finished.

Session 1: Typing and Enrichment

Review:

• Demonstrate how to use Dance May Typing Stage 1, Level 1 (ASDF, JKL, and G, H).
• Review home row position and proper finger technique.

Typing Practice Stage 1-4:

• Practice 25-30 minutes or until done.

Additional Typing Practice:

• 3 minutes of Typing Rocket JR.
  • Type with both hands, try to get a final score of 60 points or more.
• Finish level 2 of Keyboard Climber 2. Type with both hands.

Enrichment:

• Students work on enrichment activities after typing.

Session 2: Spreadsheet with Chart and Enrichment

Bake Sale Spreadsheet:

• Create a spreadsheet and chart with bake sale goods.
  • Demonstrate how to enter the title, text, and numbers into the spreadsheet.
  • Demonstrate how to create a chart with the data entered.
  • Demonstrate how to add images or clipart.
  • Watch the 25 Second First Chart video tutorial.
• Students imagine you are holding bake sales to raise money to purchase school supplies for needy children in the community.
  • Choose at least 8 items from the Bake Sale Goods List to sell at your bake sale.
  • Create your own spreadsheet and chart illustrating the goods you will have at your bake sale.

Enrichment:

• Students work on enrichment activities when finished.

Session 1: Typing and Enrichment

Review:

• Demonstrate how to use Dance May Typing Stage 1, Level 1 (ASDF, JKL, and G, H).
• Review home row position and proper finger technique.

Typing Practice Stage 1-4:

• Practice 25-30 minutes or until done.

Additional Typing Practice:

• 3 minutes of Typing Rocket JR.
  • Type with both hands, try to get a final score of 60 points or more.
• Finish level 2 of Keyboard Climber 2. Type with both hands.

Enrichment:

• Students work on enrichment activities after typing.

Session 2: Spreadsheet with Chart and Enrichment

Bake Sale Spreadsheet:

• Create a spreadsheet and chart with party supplies.
  • Demonstrate how to enter the title, text, and numbers into the spreadsheet.
  • Demonstrate how to create a chart with the data entered.
  • Demonstrate how to add images or clipart.
  • Watch the 25 Second First Chart video tutorial.
• Students imagine you are having a party and have invited several classmates, family members, and friends.
  • Choose at least 8 different foods, drinks, and party gifts that you think your friends will enjoy.
  • Create your own spreadsheet and chart illustrating all of the fun party supplies you need for the party.

Enrichment:

• Students work on enrichment activities when finished.

Session 1: Typing and Enrichment

Review:

• Demonstrate how to use Dance May Typing Stage 1, Level 1 (ASDF, JKL, and G, H).
• Review home row position and proper finger technique.

Typing Practice Stage 1-4:

• Practice 25-30 minutes or until done.

Additional Typing Practice:

• 3 minutes of Typing Rocket JR.
  • Type with both hands, try to get a final score of 60 points or more.
• Finish level 2 of Keyboard Climber 2. Type with both hands.

Enrichment:

• Students work on enrichment activities after typing.

Session 2: Spreadsheet with Chart and Enrichment

Costume Donations Spreadsheet:

• Create a spreadsheet and chart with costume donations.
  • Demonstrate how to enter the title, text, and numbers into the spreadsheet.
  • Demonstrate how to create a chart with the data entered.
  • Demonstrate how to add images or clipart.
  • Watch the 25 Second First Chart video tutorial.
• Students imagine a major Halloween costume company is donating costumes to your school for needy children.
  • Choose 8 or more types of costumes from the Halloween Costume List to donate to the children.
  • Create your own spreadsheet and chart illustrating the costumes and quantities.

Enrichment:

• Students work on enrichment activities when finished.

Session 1: Typing and Enrichment

Review:

• Demonstrate how to use Dance May Typing Stage 1, Level 1 (ASDF, JKL, and G, H).
• Review home row position and proper finger technique.

Typing Practice Stage 1-4:

• Practice 25-30 minutes or until done.

Additional Typing Practice:

• 3 minutes of Typing Rocket JR.
  • Type with both hands, try to get a final score of 60 points or more.
• Finish level 2 of Keyboard Climber 2. Type with both hands.

Enrichment:

• Students work on enrichment activities after typing.

Session 2: Word Processing and Enrichment

Halloween Pumpkin Poem Generator:

• Create a poem using the Halloween Pumpkin Poem Generator.
  • Demonstrate how to enter text into the poem generator.
  • Demonstrate how to generator the poem.
  • Demonstrate how to copy and paste the generated poem into a word processor.
• Students write your poem, then copy & paste the generated poem into a word processor.
  • Format the font size and style, add a border and clipart, add your name and print the poem.

Enrichment:

• Students work on enrichment activities when finished.