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

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:

 

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.

 

Fourth Grade Technology Lesson Schedule:


 

First Quarter - August ~ October

Fourth Grade Computer Lesson Plans Qtr. 1

QTR. 1 Main Topics Covered:

Typing, Spreadsheet Budgets

 

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

 

1 Session = Word Processing (My Vacation)

7 Sessions = Spreadsheet Budgets with charts

1 Session = Spreadsheet Formulas

 

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 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 three.

 

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?

 

Additional 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 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 three.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Budget Spreadsheet with Chart | Enrichment

Demo: Clothes Shopping Budget Spreadsheet

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 calculate "Money Left Over" using a simple formula to subtract "Total Expenses" from "Allowance". Demo how to create a chart with the expense data entered.

Spreadsheets

 

Assign: Clothes Shopping Budget Spreadsheet

 

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 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 three.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Budget Spreadsheet with Chart | Enrichment

Demo: Party for Five Food Budget

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: Party for Five Food Budget

 

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 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 three.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Budget Spreadsheet with Chart | Enrichment

Demo: Pet Adoption Budget

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: Pet Adoption Budget

 

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 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 three.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Budget Spreadsheet with Chart | Enrichment

Demo - School Supplies Budget

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: School Supplies Budget

 

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 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 three.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Budget Spreadsheet with Chart | Enrichment

Demo - Birthday Party Budget

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: Birthday Party Budget

 

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 three.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Nutrition Facts Spreadsheet with Chart | Enrichment

Demo - Fast Food Nutrition Facts (Session 1 of 2)

This assignment involves online research and spreadsheet creation. Students may require

2 or more class sessions to complete this assignment.

Demonstrate how to enter text and numbers into the spreadsheet. Demo how to create the calorie charts with the data entered.

Spreadsheets

 

Assign: Fast Food Nutrition Facts

 

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 three.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Nutrition Facts Spreadsheet with Chart | Enrichment

Demo - Fast Food Nutrition Facts (Session 2 of 2)

This assignment involves online research and spreadsheet creation. Students may require

2 or more class sessions to complete this assignment.

Demonstrate how to enter text and numbers into the spreadsheet. Demo how to create the calorie charts with the data entered.

Spreadsheets

 

Assign: Fast Food Nutrition Facts

 

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 three.

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2: Spreadsheets with Formulas | Enrichment

Simon's Spreadsheet Formulas (add and subtract), (multiply and divide),

(multiple operations). Students practice using formulas in a spreadsheet.

 

Spreadsheets

 

Assign:Simon's Spreadsheet Formulas

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


 

 

Additional Fourth 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.

 


 

Working With Image Software

 

Most of these lessons can be done in (1-2) 45 minute sessions.

Basic Photo Editing

 

Lesson One: Basic Photo Editing

Students will use an image editor to crop, lighten, darken, sharpen, resize and remove red eye from several photos.

 

 

 

 

Labeling Images

 

Lesson Two: Labeling Images

Students annotate an image, labeling the various bones of the skeletal system.

 

 

 

 

Speech Bubbles

 

Lesson Three: Speech Bubbles

Students learn to add speech bubbles to images by creating their own knock knock joke comic.

 

 

 

 

Green Screen

 

Lesson Four: Green Screen

Use the green screen / chroma key technique to put yourself in a completely different picture.

 

 

 

 

Magic Wand Photo Editing

 

Lesson Five: Magic Wand

Use the magic wand to remove backgrounds without a green screen.

 

 

 

 

Head Switch

 

Lesson Six: Switch Heads

Switch your head onto another body.

 

 

 

 


 

 

Excel M&M ChartExcel How We Get
to School Chart
Favorite Pet
Excel Chart
Clothes Shopping
Budget
Excel M&M Chart Excel How We Get to School Clothes Shopping Budget
Clothes Shopping
Expenses
Your Favorite
Subject Chart
Zoo Animals
Chart
Party Foods
Excel Chart
Clothes Shopping Expenses Your Favorite Subject Chart Excel Zoo Animals Chart Party Foods Excel Chart
Halloween Costume
Donations Chart
Lemonade Stand
Expenses Chart

Lunch Expenses
Expenses Chart

Thanksgiving
Shopping Expenses
Halloween Costume Donations Chart Lemonade Stand Expenses Chart Lunch Expenses Chart Thanksgiving Shopping Expense

 

PowerPoint

Astronomy - Planet Research

Research and present information about a planet.

Animal Adaptations - PowerPoint / Keynote ( Life Science )

Research and present information about an animal's adaptations.

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

Research and present information about armadillo adaptations.

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

Research and present information about coyote adaptations.

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

Research and present information about porcupine adaptations.

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

Research and present information about raccoon adaptations.

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

Research and present information about roadrunner adaptations.

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

Research and present information about roadrunner adaptations.

California Chumash Indians

Research and present information about California Chumash Indians, their homes, food and clothing.

California Hupa Indians

Research and present information about California Hupa Indians, their homes, food and clothing.

California Miwok Indians PowerPoint

Research and present information about California Miwok Indians, their homes, food and clothing.

California Missions PowerPoint

Research and present past and current information about one of California' s Missions.

Ecosystems PowerPoint

Research and present information about the forest, desert and water ecosystems.

Foodchain PowerPoint

Research and present information about food chain producers, consumers, and decomposers.

Food Pyramid - Fruits

Research and present information about the food pyramid and fruits.

Food Pyramid - Grains

Research and present information about the food pyramid and grains.

Food Pyramid - Vegetables

Research and present information about the food pyramid and vegetables.

Food Web Energy Pyramid

Students create their own energy pyramid

Inventors - PowerPoint (Physical Science)

Research and present information about an inventor and their inventions.

Hawaii - The Orchid Isle

Research and present information about Hawaii's geography, history, and economy.

Maui - The Valley Isle

Research and present information about Maui's geography, history and economy.

Oahu

Research and present information about Oahu's geography, history and economy.

Hot and Dry Desert Ecosystem

Research and present information about the hot and dry desert ecosystem, plants and animals.

Desert Ecosystem PowerPoint

Research and present information about desert ecosystems, desert plants and desert animals.

Taiga Forest Ecosystem PowerPoint

Research and present information about Taiga forest ecosystems, plants and animals.

Temperate Forest Ecosystem PowerPoint

Research and present information about Temperate forest ecosystems, plants and animals.

Tropical Rainforest Ecosystem PowerPoint

Research and present information about the Tropical Rainforest ecosystem, plants and animals.

Rocks and Minerals PowerPoint

Research and present information about rocks and minerals.

Igneous Rocks PowerPoint

Research and present information about igneous rocks.

Minerals PowerPoint

Research and present information about minerals.

Metamorphic Rocks PowerPoint

Research and present information about metamorphic rocks.

Sedimentary Rocks PowerPoint

Research and present information about sedimentary rocks.

Mammals - Herbivores, Carnivores, Omnivores PowerPoint

Research and present information about the diet of each mammal type.

PowerPoint Parts of Plant

Research and present information about plant parts such as seeds, leaves, fruits, flowers, roots and stems.

Tri-Fold Brochure Template

Template for creating a tri-fold brochure

Technology Leader - Apple Keynote Presentation

Research and present information about a major technology leader

iPad - Martin Luther King Words of Freedom Collage

Create a collage about MKL on the iPad

 

Internet Research

Internet Mapquest Activity

Learn to use Mapquest to find directions and travel time between two points.

Internet Martin Luther King Jr. Research

Students research facts about Martin Luther King's Jr.' s life, legacy, death, most famous speech.

Internet President's Day Research

Research facts about George Washington and Abraham Lincoln.

Internet Weather Inventions Research

Research information about the anemometer, barometer, rain gauge, thermometer.

 

 

Word

Autobiographical Poem Generator

Students use the generator to create their own autobiographical poem.

I am Poem Generator

Students use the generator to create a personalized I am Poem.

Family Tree Template

Students create use the template to create a family tree.

Halloween Pumpkin Personification Poem Generator

Students use the generator to create a Halloween Poem

Time Line Template

General purpose time line template

Time Line - New World Exploration

Students use the time line template to outline the exploration of the Americas.

Time Line - New World Exploration - England

Students use the time line template to outline England's exploration and settlement of the Americas.

Time Line - New World Exploration - Spain

Students use the time line template to outline Spain's exploration of the Americas.

Time Line - New World Exploration - France

Students use the time line template to outline France's exploration of the Americas.

Time Line Cesar Chavez

Students use the time line template to outline major events in the life of Cesar Chavez.

My Life - Time Line Template 10 Years

Students use the time line template to arrange their important life events in chronological order.

California Regions Brochure

Create a brochure about one of the California Regions.

We the People - Illustrating the Preamble

Illustrate and interpret the phrases of the preamble

 

Resources

California Regions Resources

Regional Map and research information about California's four regions.

Google Earth California Missions

Record a virtual tour flyby presentation of 4 California Missions with Google Earth.

 

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