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
Steve Lee Ignacio

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 profiency. 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, Expense Spreadsheets

 

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

 

9 Sessions = Spreadsheets with charts

 

 

Prerequisites: Internet access, Spreadsheet program.

 

 

 

 

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

 

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

 

Assign Typing Practice Stage 1:

Assign 25-30 minutes or until done with Dance Mat Typing stage one, level one ( ASDF,JKL; and G, H ). Typing Practice Here:

Typing Practice

 

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

 

Assign: Keyboard Climber 2. Students type with both hands. Finish level two.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Word Processing - "My Vacation" | Enrichment

 

My Vacation : Make the "My Vacation" (Windows) template available to the students. Demo how to write in the editable text box.

 

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

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?

 

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 when finished.

 

 

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 proper finger technique.

 

Assign Typing Practice Stage 1:

Assign 25-30 minutes or until done with Dance Mat Typing stage one, level one ( ASDF,JKL; and G, H ). Typing Practice Here:

Typing Practice

 

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

 

Assign: Keyboard Climber 2. Students type with both hands. Finish level two.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Spreadsheet with Chart | Enrichment

Demo: Favorite Ice Cream Flavor

Demonstrate how to enter text and numbers into the spreadsheet.

Demo how to create a chart with the data entered.

Spreadsheets

 

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.

 

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 proper finger technique.

 

Assign Typing Practice Stage 1:

Assign 25-30 minutes or until done with Dance Mat Typing stage one, level one ( ASDF,JKL; and G, H ). Typing Practice Here:

Typing Practice

 

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

 

Assign: Keyboard Climber 2. Students type with both hands. Finish level two.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Expense Spreadsheet with Chart | Enrichment

Demo: Back to School Supplies Expenses

Demonstrate how to enter text and numbers into the spreadsheet. Demo how to format the number values with dollar signs. Discuss and demo how to create a total using the sum formula. Demo how to create a chart with the data entered.

Spreadsheets

 

Assign: Back to School Supplies Expenses

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 

Qtr. 1 - Week 4:

Session 1: Typing | Enrichment

 

Review of Typing Stage 2:

Demonstrate how to use Dance Mat Typing stage two ( ASDF,JKL; and E, I ). Review proper finger technique.

 

Assign Typing Practice Stage 2: Assign 25-30 minutes or until done with Dance Mat Typing stage two ( ASDF,JKL; and E, I ). Typing Practice Here:

Typing Stage Two

 

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

 

Assign: Keyboard Climber 2. Students type with both hands. Finish level two.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Expense Spreadsheet with Chart | Enrichment

Demo: Clothes Shopping Expenses with Chart

Demonstrate how to enter text and numbers into the spreadsheet. Demo how to format the number values with dollar signs. Discuss and demo how to create a total using the sum formula. Demo how to create a chart with the data entered.

Spreadsheets

 

Assign:Clothes Shopping Expenses with Chart

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 

Qtr. 1 - Week 5:

Session 1: Typing | Enrichment

 

Review of Typing Stage 2:

Demonstrate how to use Dance Mat Typing stage two ( ASDF,JKL; and E, I ). Review proper finger technique.

 

Assign Typing Practice Stage 2: Assign 25-30 minutes or until done with Dance Mat Typing stage two ( ASDF,JKL; and E, I ). Typing Practice Here:

Typing Stage Two

 

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

 

Assign: Keyboard Climber 2. Students type with both hands. Finish level two.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Expense Spreadsheet with Chart | Enrichment

Demo - Lunch Expenses for Two

Demonstrate how to enter text and numbers into the spreadsheet. Demo how to format the number values with dollar signs. Discuss and demo how to create a total using the sum formula. Demo how to create a chart with the data entered.

Spreadsheets

 

Assign: Lunch Expenses for Two

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 

Qtr. 1 - Week 6:

Session 1: Typing | Enrichment

 

Review of Typing Stage 2:

Demonstrate how to use Dance Mat Typing stage two ( ASDF,JKL; and E, I ). Review proper finger technique.

 

Assign Typing Practice Stage 2: Assign 25-30 minutes or until done with Dance Mat Typing stage two ( ASDF,JKL; and E, I ). Typing Practice Here:

Typing Stage Two

 

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

 

Assign: Keyboard Climber 2. Students type with both hands. Finish level two.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Expense Spreadsheet with Chart | Enrichment

Demo - Movie Expenses for Two

Demonstrate how to enter text and numbers into the spreadsheet. Demo how to format the number values with dollar signs. Discuss and demo how to create a total using the sum formula. Demo how to create a chart with the data entered.

Spreadsheets

 

Assign: Movie Expenses for Two

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 

Qtr. 1 - Week 7:

Session 1: Typing | Enrichment

 

Review of Typing Stage 3:

Demonstrate how to use Dance Mat Typing Stage Three ( ASDF,JKL; and R, U ). Review proper finger technique.

 

Assign Typing Practice Stage 3: Assign 25-30 minutes or until done with Dance Mat Typing two ( ASDF,JKL; and R, U ). Typing Practice Here:

Typing Stage Three

 

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

 

Assign: Keyboard Climber 2. Students type with both hands. Finish level two.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Expense Spreadsheet with Chart | Enrichment

Demo - Sports Equipment Expenses

Demonstrate how to enter text and numbers into the spreadsheet. Demo how to format the number values with dollar signs. Discuss and demo how to create a total using the sum formula. Demo how to create a chart with the data entered.

Spreadsheets

 

Assign: Sports Equipment Expenses

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 

Qtr. 1 - Week 8:

Session 1: Typing | Enrichment

 

Review of Typing Stage 3:

Demonstrate how to use Dance Mat Typing Stage Three ( ASDF,JKL; and R, U ). Review proper finger technique.

 

Assign Typing Practice Stage 3: Assign 25-30 minutes or until done with Dance Mat Typing two ( ASDF,JKL; and R, U ). Typing Practice Here:

Typing Stage Three

 

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

 

Assign: Keyboard Climber 2. Students type with both hands. Finish level two.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Expense Spreadsheet with Chart | Enrichment

Demo - Camping Trip Expenses

Demonstrate how to enter text and numbers into the spreadsheet. Demo how to format the number values with dollar signs. Discuss and demo how to create a total using the sum formula. Demo how to create a chart with the data entered.

Spreadsheets

 

Assign: Camping Trip Expenses

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 

Qtr. 1 - Week 9:

Session 1: Typing | Enrichment

 

Review of Typing Stage 3:

Demonstrate how to use Dance Mat Typing Stage Three ( ASDF,JKL; and R, U ). Review proper finger technique.

 

Assign Typing Practice Stage 3: Assign 25-30 minutes or until done with Dance Mat Typing two ( ASDF,JKL; and R, U ). Typing Practice Here:

Typing Stage Three

 

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

 

Assign: Keyboard Climber 2. Students type with both hands. Finish level two.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Expense Spreadsheet with Chart | Enrichment

Demo - Lemonade Stand Expenses

Demonstrate how to enter text and numbers into the spreadsheet. Demo how to format the number values with dollar signs. Discuss and demo how to create a total using the sum formula. Demo how to create a chart with the data entered.

Spreadsheets

 

Assign: Lemonade Stand Expenses

 

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