K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators iPad Classroom Tech Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple Mac Keynote Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Tech Coordinator Tutorials Video Reversal Video Tutorials Coding For Kids Resources

Third Grade Technology Lessons - Qtr. 1

Touch Typing, Expense Spreadsheets with Charts

Third Grade Technology Lessons focus on typing skills development and expense spreadsheets with charts (Qtr.1), coding and logic games, (Qtr.2), research (Qtr.3) , and presentations (Qtr.4).

 

In the 1st Qtr, 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, or other similar programs.

 

 

Recommendations:

 

Typing Lessons: Focus on typing accuracy and correct finger placement, not speed. Speed will be acquired naturally over time in the future months and years of typing lessons.

 

File Distribution: Share assignment files using Dropbox, Google Drive, Box.com, Microsoft OneDrive or a shared network drive on your school network server.

 

 

 

Enrichment: Use the enrichment activities to support regular classroom curricula. Good for early finishers, late arrivals, supplementation, differentiation.

 

Time Management: These weekly lessons are programmed for 2 weekly sessions of 45 minutes each. Adust the activity selections according to your own needs.

 

Internet Search: Make sure your students' computer browsers are set to safe search. If your school is using content filtering on the network, (and they should be!) then safe search may be taken care of automatically. In any case, the academic topics we are researching are unlikely to produce inappropriate results. Provide appropriate supervision.

 

Third Grade Technology Lesson Schedule:


 

First Quarter - August ~ October

Third Grade Lesson Plans Qtr. 1

QTR. 1 Main Topics Covered:

Typing, Spreadsheets, Word Processing

 

9 Sessions = Typing Practice
(review homerow keys plus G H -E I- R U)

 

7 Sessions = Spreadsheets with charts

 

2 Sessions = Word Processing

 

Prerequisites: Internet access, Spreadsheet program. Microsoft Word or compatible word processor.

 


 

Qtr. 1 - Week 1:

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 in Pictures

 

Review of Typing Stage 1: Demonstrate how to use Dance Mat Typing stage one, level one ( ASDF,JKL; and G, H ). Review the homerow and proper finger technique.

 

Assign Typing Practice Stage 1 - 3 :

Assign 25-30 minutes or until done.

 

Typing Level One Typing Level Two Typing Level Three

 

 

1) Assign 3 Minutes of: Typing Rocket Jr. Type with both hands, try to get a final score of 60 points or more.

2) Assign: Keyboard Climber 2. Type with both hands. Finish level two.

 

Typing Rocket Keyboard Climber

 

More Typing Practice Here:

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 1:

Session 2:

Word Processing - "My Vacation" | Enrichment

 

 

My Vacation : Make the "My Vacation" (Windows PC) templates available to the students. Demonstrate how to write in the editable text box.

 

Assign: "My Vacation" writing. Students will save / print their finished work.

 

Instructions:

Describe in 100 words or more what you did this summer.

Tell an interesting story with a beginning, middle, and end.

Add at least one small image related to your story.

Ideas:

1.What you did,

2.What happened to you,

3.Places you went,

4.What was so boring and what you wished you had done instead.

5.Who you met,

6.Who you played with,

7.Movies you saw, books you read,

8.What Else?


My Vacation by Sabine

 

Alternative Activities:

 

iPad - Butterfly Lifecycle iPad - All About Me

 

1) iPad - All About Me Acrostic

2) iPad - All About me Balloon Stickies

3) iPad - All About Me Pic Collage

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 2:

Session 1:

Typing | Enrichment

Review of Typing Stage 1: Demonstrate how to use Dance Mat Typing stage one, level one ( ASDF,JKL; and G, H ). Review the homerow and proper finger technique.

 

Assign Typing Practice Stage 1 - 3 :

Assign 25-30 minutes or until done. Type with both hands on the homerow keys.

 

Typing Level One Typing Level Two Typing Level Three

 

 

1) Assign 3 Minutes of: Typing Rocket Jr. Type with both hands, try to get a final score of 60 points or more.

2) Assign: Keyboard Climber 2. Type with both hands. Finish level two.

 

Typing Rocket Keyboard Climber

 

More Typing Practice Here:

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 2:

Session 2:

Spreadsheet with Chart | Enrichment

Demo: Favorite Ice Cream Flavor

1) Demonstrate how to enter text and numbers into the spreadsheet.

2) Demo how to create a chart with the data entered.

3) See a 25 second First Chart video tutorial here.

 

Excel Ice Cream Chart

 

 

Assign: Favorite Ice Cream Flavor

Use the tally sheet to survey the class on their favorite ice cream flavors. Students use the data collected to create their charts.

Ice Cream Flavor Tally Sheet

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 3:

Session 1:

Typing | Enrichment

Review of Typing Stage 1: Demonstrate how to use Dance Mat Typing stage one, level one ( ASDF,JKL; and G, H ). Review the homerow and proper finger technique.

 

Assign Typing Practice Stage 1 - 3 :

Assign 25-30 minutes or until done. Type with both hands on the homerow keys.

 

Typing Level One Typing Level Two Typing Level Three

 

 

1) Assign 3 Minutes of: Typing Rocket Jr. Type with both hands, try to get a final score of 60 points or more.

2) Assign: Keyboard Climber 2. Type with both hands. Finish level two.

 

Typing Rocket Keyboard Climber

 

More Typing Practice Here:

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 3:

Session 2:

Spreadsheet with Chart | Enrichment

Demo: What is Your Favorite Subject?

1) Demonstrate how to enter text and numbers into the spreadsheet.

2) Demo how to create a chart with the data entered.

3) Demo how to add images or clipart.

4) See a 25 second First Chart video tutorial here.

 

Favorite Subject Chart

 

 

Assign: What is Your Favorite Subject?

Use the tally sheet to survey the class on their favorite subject. Students use the data collected to create their charts.

What is Your Favorite Subject Tally Sheet

 

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 4:

Session 1:

Typing | Enrichment

Review of Typing Stage 1: Demonstrate how to use Dance Mat Typing stage one, level one ( ASDF,JKL; and G, H ). Review the homerow and proper finger technique.

 

Assign Typing Practice Stage 1 - 3 :

Assign 25-30 minutes or until done. Type with both hands on the homerow keys.

 

Typing Level One Typing Level Two Typing Level Three

 

 

1) Assign 3 Minutes of: Typing Rocket Jr. Type with both hands, try to get a final score of 60 points or more.

2) Assign: Keyboard Climber 2. Type with both hands. Finish level two.

 

Typing Rocket Keyboard Climber

 

More Typing Practice Here:

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 4:

Session 2:

Spreadsheet with Chart | Enrichment

Demo - Zoo Animals Chart

1) Demonstrate how to enter text and numbers into the spreadsheet.

2) Demo how to create a chart with the data entered.

3) Demo how to add clipart or images if possible.

4) See a 25 second First Chart video tutorial here.

 

Zoo Animals Spreadsheet

 

 

Assign: Zoo Animals Chart

Instructions: Students imagine they have a mini-zoo with several types of animals. Students use their worksheet to count how many mammals, birds, fish, reptiles, or amphibians they have. Students use their data to create a spreadsheet and pie chart illustrating the number of each type of animals in their zoo.

Zoo Animals Handout

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 5:

Session 1:

Typing | Enrichment

Review of Typing Stage 1: Demonstrate how to use Dance Mat Typing stage one, level one ( ASDF,JKL; and G, H ). Review the homerow and proper finger technique.

 

Assign Typing Practice Stage 1 - 3 :

Assign 25-30 minutes or until done. Type with both hands on the homerow keys.

 

Typing Level One Typing Level Two Typing Level Three Typing Stage 4

 

 

1) Assign 3 Minutes of: Typing Rocket Jr. Type with both hands, try to get a final score of 60 points or more.

2) Assign: Keyboard Climber 2. Type with both hands. Finish level two.

 

Typing Rocket Keyboard Climber

 

More Typing Practice Here:

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 5:

Session 2:

Spreadsheet with Chart | Enrichment

Demo - Fruit Stand with Chart

1) Demonstrate how to enter text and numbers into the spreadsheet.

2) Demo how to create a chart with the data entered.

3) Demo how to add clipart or images if possible.

4) See a 25 second First Chart video tutorial here.

 

Fruit Stand Spreadsheet

 

 

Assign: Fruit Stand Spreadsheet with Chart

Instructions: Students have decided to raise funds to help needy children pay for school supplies. They will make and sell fresh fruit juices and smoothies at the next important school event. Students choose at least 8 items from the Fruit Stand Shopping List for their fruit juice and smoothie creations.

Fruit Stand Shopping List

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 6:

Session 1:

Typing | Enrichment

Review of Typing Stage 1: Demonstrate how to use Dance Mat Typing stage one, level one ( ASDF,JKL; and G, H ). Review the homerow and proper finger technique.

 

Assign Typing Practice: Students Choose ANY THREE

Assign 25-30 minutes or until done. Type with both hands on the homerow keys.

 

Typing Level One Typing Level Two Typing Level Three Typing Stage 4

 

 

1) Assign 3 Minutes of: Typing Rocket Jr. Type with both hands, try to get a final score of 60 points or more.

2) Assign: Keyboard Climber 2. Type with both hands. Finish level two.

 

Typing Rocket Keyboard Climber

 

More Typing Practice Here:

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 6:

Session 2:

Spreadsheet with Chart | Enrichment

Demo - Bake Sale Spreadsheet

1) Demonstrate how to enter text and numbers into the spreadsheet.

2) Demo how to create a chart with the data entered.

3) Demo how to add clipart or images if possible.

4) See a 25 second First Chart video tutorial here.

 

Bake Sale Spreadsheet

 

 

Assign: Bake Sale Spreadsheet with Chart

Instructions: Students are holding bake sales to raise money to purchase school supplies for needy children in their community. Students choose at least 8 different items from the "Baked Sale Goods" list to sell at their bake sale. Students enter their choices into a spreadsheet and create a chart with the data.

 

Bake Sale Goods List

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 7:

Session 1:

Typing | Enrichment

Review of Typing Stage 1: Demonstrate how to use Dance Mat Typing stage one, level one ( ASDF,JKL; and G, H ). Review the homerow and proper finger technique.

 

Assign Typing Practice: Students Choose ANY THREE

Assign 25-30 minutes or until done. Type with both hands on the homerow keys.

 

Typing Level One Typing Level Two Typing Level Three Typing Stage 4

 

 

1) Assign 3 Minutes of: Typing Rocket Jr. Type with both hands, try to get a final score of 60 points or more.

2) Assign: Keyboard Climber 2. Type with both hands. Finish level two.

 

Typing Rocket Keyboard Climber

 

More Typing Practice Here:

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 7:

Session 2:

Spreadsheet with Chart | Enrichment

Demo: Party Supplies Spreadsheet with Chart

1) Demonstrate how to enter text and numbers into the spreadsheet.

2) Demo how to create a chart with the data entered.

3) Demo how to add clipart or images if possible.

4) See a 25 second First Chart video tutorial here.

 

iPad Numbers Spreadsheet example here:

 

Party Supplies Chart

 

 

Assign:Party Supplies Spreadsheet with Chart

Students: You are having a party and have invited several classmates, family members and friends. You need to make a spreadsheet of all the fun party supplies you need for the party.

Choose at least 8 different foods, drinks, and party gifts that you think your friends will enjoy.

 

Download: party-supplies-list.pdf

 

Party Supplies List

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 8:

Session 1:

Typing | Enrichment

Review of Typing Stage 1: Demonstrate how to use Dance Mat Typing stage one, level one ( ASDF,JKL; and G, H ). Review the homerow and proper finger technique.

 

Assign Typing Practice: Students Choose ANY THREE

Assign 25-30 minutes or until done. Type with both hands on the homerow keys.

 

Typing Level One Typing Level Two Typing Level Three Typing Stage 4

 

 

1) Assign 3 Minutes of: Typing Rocket Jr. Type with both hands, try to get a final score of 60 points or more.

2) Assign: Keyboard Climber 2. Type with both hands. Finish level two.

 

Typing Rocket Keyboard Climber

 

More Typing Practice Here:

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 8:

Session 2:

Spreadsheet with Chart | Enrichment

Demo - Costume Donations Spreadsheet

1) Demonstrate how to enter text and numbers into the spreadsheet.

2) Demo how to create a chart with the data entered.

3) Demo how to add clipart or images if possible.

4) See a 25 second First Chart video tutorial here.

 

Costume Chart

 

Assign: Costume Donations Spreadsheet

Instructions: Students at your school have convinced a major Halloween costume company.to donate a variety of costumes for needy children in their community. Choose 8 or more types of costumes from the Halloween Costume List to donate to the children. Add your costume choices and the quantities into a spreadsheet.Use your information to create a bar or column chart.

Costume List

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 9:

Session 1:

Typing | Enrichment

Review of Typing Stage 1: Demonstrate how to use Dance Mat Typing stage one, level one ( ASDF,JKL; and G, H ). Review the homerow and proper finger technique.

 

Assign Typing Practice: Students Choose ANY THREE

Assign 25-30 minutes or until done. Type with both hands on the homerow keys.

 

Typing Level One Typing Level Two Typing Level Three Typing Stage 4

 

 

1) Assign 3 Minutes of: Typing Rocket Jr. Type with both hands, try to get a final score of 60 points or more.

2) Assign: Keyboard Climber 2. Type with both hands. Finish level two.

 

Typing Rocket Keyboard Climber

 

More Typing Practice Here:

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

Qtr. 1 - Week 9:

Session 2:

Word Processing | Enrichment

Demo - Halloween Pumpkin Poem Generator

1) Demonstrate how to enter text into the poem generator

2) Demo how to generate the poem.

3) Demo how to copy and paste the generated poem into a word processor.

 

Halloween Poem Generator

 

 

Assign: Halloween Pumpkin Poem Generator

Students: Write your poem then copy and 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.

Pumpkin Poem Generator

 

Assign Enrichment: Students work on enrichment activities after typing.

 


 

 

Additional Third Grade Activities:

Engage and challenge your students with these supplemental 2nd grade activities.

 

Would You Rather Questions with QR Codes for Kids32 Would Your Rather... Questions with QR Codes and Task Cards

A great back to school getting to know you activity. The questions are fun, silly, serious, and thought provoking. Students choose a task card and scan the code with QR code reader using an iPad or other device.

 

Kindergarten Tech LessonsMy Summer Vacation Narrative - Cell Phone Graphic Organizer

 

 

 

Halloween

Halloween Poem Generator

Halloween Pumpkin Personification Poem Generator

 

Alternate Activity: Halloween Acrostic

 

 

Thanksgiving

Kindergarten Tech LessonsHappy Thanksgiving and Happy Holidays letters to family.

 

 

Holiday Poem Generator Holiday Poem Generator

 

 

Thanksgiving Poem GeneratorThanksgiving Turkey Personification Poem Generator

 

 

 

Martin Luther King Jr. Activities

MLK Poem GeneratorI have a Dream Poem Generator

Choose from a Collection of MLK Activities

 

 

Valentine's Day

Kindergarten Tech LessonsHappy Valentine's Day Letters

Students create a Valentines' day letter to their loved ones using fancy fonts. clipart and borders.

Poem GeneratorHoliday Poem Generator

 

 

Happy Spring Break

Kindergarten Tech Lessons Type Happy Spring Break letters or create an acrostic. Utilize font sizes, styles, clipart, borders, printing. Should fill a single page, use good grammar and have correct spelling.

 


 

Slide Presentations

 

Tri-Fold BrochurePowerPoint
News Paper Template
One Minute
PowerPoint Lesson
Miwok Indians
PowerPoint
Tri Fold Brochure PowerPoint PowerPoint News Paper Template One Minute PowerPoint Lesson California Miwok Indians PowerPoint
Oahu PowerPoint
Then & Now
PowerPoint
Amazing Animals
PowerPoint
Kwakiutl Indians
PowerPoint
Oahu PowerPoint Then and Now PowerPoint Amazing Animals PowerPoint Kwakiutl Indians PowerPoint

 

Earth Science

Hurricanes and Tornadoes - PowerPoint / Keynote ( Earth Science )

Solar System Inner and Outer Planets - PowerPoint / Keynote ( Earth Science )

Tornadoes - PowerPoint / Keynote ( Earth Science )

 

History Social Science

California Chumash Indians ( History - Social Science )

California Hupa Indians ( History - Social Science )

California Miwok Indians PowerPoint ( History - Social Science )

Native Americans - Cheyenne ( History - Social Science )

Native Americans - Kwakiutl ( History - Social Science )

Native Americans - Navajo ( History - Social Science )

Needs and Wants - PowerPoint ( History - Social Science )

iPad - Martin Luther King Words of Freedom Collage

 

Life Science

Amphibians, Fish and Reptiles - Keynote / PowerPoint ( Life Science )

Animal Adaptations - PowerPoint / Keynote ( Life Science )

Animal Adaptations - Armadillo - PowerPoint / Keynote ( Life Science )

Animal Adaptations - Coyote - PowerPoint / Keynote ( Life Science )

Animal Adaptations - Porcupine - PowerPoint / Keynote ( Life Science )

Animal Adaptations - Raccoons - PowerPoint / Keynote ( Life Science )

Animal Adaptations - Roadrunner - PowerPoint / Keynote ( Life Science )

Animal Adaptations - Skunk - PowerPoint / Keynote ( Life Science )

Animal Homes - PowerPoint / Keynote ( Life Science )

Animal Homes - African Termites PowerPoint / Keynote ( Life Science )

Animal Homes - Beavers PowerPoint / Keynote ( Life Science )

Animal Homes - Birds PowerPoint / Keynote ( Life Science )

Animal Homes - Honeybees - PowerPoint / Keynote ( Life Science )

Animal Homes - Prairie Dogs - PowerPoint / Keynote ( Life Science )

Animal Homes - Spiders - PowerPoint / Keynote ( Life Science )

City Wildlife - PowerPoint ( Life Science )

Ecosystems - PowerPoint / Keynote ( Life Science )

Extinct, Endangered, Threatened - PowerPoint / Keynote ( Life Science )

Facts about Seeds - Keynote / PowerPoint ( Life Science )

Food Pyramid - Fruits ( Life Science )

Food Pyramid - Grains ( Life Science )

Food Pyramid - Vegetables ( Life Science )

Life Cycle of a Frog - PowerPoint / Keynote ( Life Science )

Mammals and Birds - Keynote / PowerPoint ( Life Science )

Mammals - Herbivores, Carnivores, Omnivores ( Life Science )

Photosynthesis - Keynote / PowerPoint ( Life Science )

Those Amazing Animals - PowerPoint ( Life Science )

Whales - PowerPoint / Keynote ( Life Science )

What Plant Parts Do - Keynote / PowerPoint ( Life Science )

 

 

Physical Science

Energy - PowerPoint / Keynote ( Physical Science )

Inventors - PowerPoint (Physical Science)

Solids, Liquids, Gases - PowerPoint / Keynote ( Physical Science )

 

Spreadsheets

Excel First Chart

Excel Bar Chart

M & M Chart

Excel Expense Budget

Excel Shopping Budget

Excel Lemonade Stand

Valentine's Day Excel Chart

Ordering Planetary Data - Excel ( Earth Science )

 

Word Processing

Cut and Paste, Copy and Paste

Animal Classification Copy and Paste

Animal Vocabulary Cut and Paste

Cut and Paste Computer Parts

Copy and Paste - Fractions

Copy and Paste Nemo

Copy and Paste Time - Hours

Copy and Paste Time - Half Hours

Copy and Paste Time - Quarter Hours

Cut and Paste Squidward

Cut and Paste Numbers

Cut and Paste Weather Words

Living and Non Living Things - Copy and Paste Practice

Forces - Pushing and Pulling - Copy and Paste Practice

My Life - Time Line Template 10 Years

 

Writing, Clipart and Images

Facts about Money

Fall Acrostic Poem

Friendship Poster

Halloween Pumpkin Personification Poem Generator

Happy Holidays

Happy Valentine's Day

Happy Spring Break Letter

Happy Spring Break Acrostic

Happy Thanksgiving Letter

Happy Mother's Day Letter

Happy Mother's Day Acrostic

Money - Using the Calculator

 

Graphics

Put Your Head on Another Body

Put Your Face on Money

Create a Wanted Poster

Labeling the Parts of a Plant ( Life Science )

Lunar Eclipse illustration ( Earth Science )

 

Research

Facts about Money

Weather Inventions and Forecast

 

Popular for iPads - iWork

For PC's and Microsoft Office

  • Excel Bar Chart

  • Excel Bar Chart
  • Thanksgiving
    Copy and Paste
  • Thanksgiving Copy and Paste
  • Green Screen
    Photo Editing
  • Green Screen Photo Editing
  • Computer Lab
    Rules
  • Computer Lab Rules Essentials
  • California Regions
    Brochure
  • California Regions Brochure
  • Amazing Animals
    PowerPoint
  • Amazing Animals
  • I Am
    Poem Generator
  • I Am Poem Generator
  • "Floater"
    Animation
  • I Can Float Animation
  • Learn PowerPoint
    in One Minute
  • Learn PowerPoint in One Minute
  • Copy and Paste
    Practice
  • Copy and Paste Practice
  • M&M
    Chart
  • Excel Pie Chart
  • NewsPaper
    Template
  • Newspaper Template