K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
Spreadsheets
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 Coding For Kids Resources

Second Grade Technology Lessons - Qtr. 2

Touch Typing, Spreadsheets, and Coding

Second Grade Technology Lessons focus on typing skills development and word processing (Qtr.1), spreadsheets and coding (Qtr.2), research (Qtr.3) , and presentations (Qtr.4).

 

In the 2nd Qtr, students continue to develop typing profiency. Students also create spreadsheets with charts. Students will learn spreadsheet vocabulary such as rows,columns, cells, data, and values. Students will be introduced to coding and beginning programming concepts.

 

 

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.

 

Second Grade Technology Lesson Schedule:


 

Second Quarter - October ~ December

Second Grade Computer Lessons - 2nd Qtr

QTR. 2 Main Topics Covered:

Typing, Spreadsheets, Coding

 

9 Sessions = Typing Practice
(review previous keys plus T Y, W O, Q P)

 

5 Sessions = Spreadsheets with charts

 

4 Sessions = Coding

 

Prerequisites: Internet access, Spreadsheet program, Signup at code.org (free)

 

 

 

Qtr. 2 - Week 1:

Session 1:

Typing | Enrichment

 

Review Typing - Stage 4:

Demonstrate how to use Dance Mat Typing. Review proper finger technique.

 

Assign Typing Practice:

Assign 25-30 minutes or until done with Dance Mat Typing.

 

Typing Stage 4 Typing Stage 5 Typing Stage 6 Typing Stage 7

 

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.

 

Typing Rocket Keyboard Climber

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2:

Spreadsheet with Chart | Enrichment

Demo: Favorite Pet Spreadsheet

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.

 

What is Your Favorite Pet Spreadsheet

 

 

Assign: Favorite Pet Spreadsheet

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

What is Your Favorite Pet Chart

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Qtr. 2 - Week 2:

Session 1:

Typing | Enrichment

 

Review Typing - Stage 4:

Demonstrate how to use Dance Mat Typing. Review proper finger technique.

 

Assign Typing Practice:

Assign 25-30 minutes or until done with Dance Mat Typing.

 

Typing Stage 4 Typing Stage 5 Typing Stage 6 Typing Stage 7

 

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.

 

Typing Rocket Keyboard Climber

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


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) See a 25 second First Chart video tutorial here.

 

Assign Spreadsheet with Chart (Party Supplies):

Students create the party supplies spreadsheet with chart.
Students enter text data in column A, number values in column B. Students create chart using their text and numbers. Students save and / or print.

Party Supplies Spreadsheet

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Qtr. 2 - Week 3:

Session 1:

Typing | Enrichment

 

Review Typing - Stage 4:

Demonstrate how to use Dance Mat Typing. Review proper finger technique.

 

Assign Typing Practice:

Assign 25-30 minutes or until done with Dance Mat Typing.

 

Typing Stage 4 Typing Stage 5 Typing Stage 6 Typing Stage 7

 

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.

 

Typing Rocket Keyboard Climber

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2:

Spreadsheet with Chart | Enrichment

Demo: How You Get to School 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) See a 25 second First Chart video tutorial here.

 

How do Your Usually Get to School Spreadsheet

 

 

Assign: How do You Get to School Spreadsheet with Chart

Use the tally sheet to survey the class. Students use the data collected to create their spreadsheet and charts.

Tally Sheet

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Qtr. 2 - Week 4:

Session 1:

Typing | Enrichment

 

Review Typing - Stage 4:

Demonstrate how to use Dance Mat Typing. Review proper finger technique.

 

Assign Typing Practice:

Assign 25-30 minutes or until done with Dance Mat Typing.

 

Typing Stage 4 Typing Stage 5 Typing Stage 6 Typing Stage 7

 

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.

 

Typing Rocket Keyboard Climber

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2:

Spreadsheet with Chart | Enrichment

Demo: What is Your Favorite Subject 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) See a 25 second First Chart video tutorial here.

 

What is Your Favorite Subject Spreadsheet

 

 

Assign: What is Your Favorite Subject Spreadsheet with Chart

Use the tally sheet to survey the class. Students use the data collected to create their spreadsheet and charts.

Favorite Subject Tally Sheet

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Qtr. 2 - Week 5:

Session 1:

Typing | Enrichment

 

Review Typing - Stage 4:

Demonstrate how to use Dance Mat Typing. Review proper finger technique.

 

Assign Typing Practice:

Assign 25-30 minutes or until done with Dance Mat Typing.

 

Typing Stage 4 Typing Stage 5 Typing Stage 6 Typing Stage 7

 

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.

 

Typing Rocket Keyboard Climber

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2:

Spreadsheet with Chart | Enrichment

Demo: What is Your 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.

 

 

 

Assign: What is Your Favorite Ice Cream Flavor?

Use the tally sheet to survey the class. Students use the data collected to create their spreadsheet and charts.

Favorite Ice Cream Flavor Tally Sheet

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Qtr. 2 - Week 6:

Session 1:

Typing | Enrichment

 

Review Typing - Stage 4:

Demonstrate how to use Dance Mat Typing. Review proper finger technique.

 

Assign Typing Practice:

Assign 25-30 minutes or until done with Dance Mat Typing.

 

Typing Stage 4 Typing Stage 5 Typing Stage 6 Typing Stage 7

 

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.

 

Typing Rocket Keyboard Climber

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2:

Coding for Kids | Enrichment

In Advance: Sign Up to Code.org (Free)

In Advance: Create a 2nd Grade Section in Course 1 (beginner coding activities) and add your students names.

In Advance: Generate your students' usernames and passwords list.

 

Demo how to solve a few of the coding puzzles.

Code.org

 

Assign Coding: Have students go to https://code.org/ and login with the credentials from the usernames and passwords list you generated earlier. Students work at their own pace on the challenges in Course 1.

 

 


Qtr. 2 - Week 7:

Session 1:

Typing | Enrichment

 

Review Typing - Stage 4:

Demonstrate how to use Dance Mat Typing. Review proper finger technique.

 

Assign Typing Practice:

Assign 25-30 minutes or until done with Dance Mat Typing.

 

Typing Stage 4 Typing Stage 5 Typing Stage 6 Typing Stage 7

 

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.

 

Typing Rocket Keyboard Climber

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2:

Coding for Kids | Enrichment

In Advance: Sign Up to Code.org (Free)

In Advance: Create a 2nd Grade Section in Course 1 (beginner coding activities) and add your students names.

In Advance: Generate your students' usernames and passwords list.

 

Demo how to solve a few of the coding puzzles.

Code.org

 

Assign Coding: Have students go to https://code.org/ and login with the credentials from the usernames and passwords list you generated earlier. Students work at their own pace on the challenges in Course 1.

 

 

Qtr. 2 - Week 8:

Session 1:

Typing | Enrichment

 

Review Typing - Stage 4:

Demonstrate how to use Dance Mat Typing. Review proper finger technique.

 

Assign Typing Practice:

Assign 25-30 minutes or until done with Dance Mat Typing.

 

Typing Stage 4 Typing Stage 5 Typing Stage 6 Typing Stage 7

 

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.

 

Typing Rocket Keyboard Climber

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2:

Coding for Kids | Enrichment

In Advance: Sign Up to Code.org (Free)

In Advance: Create a 2nd Grade Section in Course 1 (beginner coding activities) and add your students names.

In Advance: Generate your students' usernames and passwords list.

 

Demo how to solve a few of the coding puzzles.

Code.org

 

Assign Coding: Have students go to https://code.org/ and login with the credentials from the usernames and passwords list you generated earlier. Students work at their own pace on the challenges in Course 1.

 

Qtr. 2 - Week 9:

Session 1:

Typing | Enrichment

 

Review Typing - Stage 4:

Demonstrate how to use Dance Mat Typing. Review proper finger technique.

 

Assign Typing Practice:

Assign 25-30 minutes or until done with Dance Mat Typing.

 

Typing Stage 4 Typing Stage 5 Typing Stage 6 Typing Stage 7

 

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.

 

Typing Rocket Keyboard Climber

 

Assign Enrichment: Students work on enrichment activities after typing.

 

 


Session 2:

Coding for Kids | Enrichment

In Advance: Sign Up to Code.org (Free)

In Advance: Create a 2nd Grade Section in Course 1 (beginner coding activities) and add your students names.

In Advance: Generate your students' usernames and passwords list.

 

Demo how to solve a few of the coding puzzles.

Code.org

 

Assign Coding: Have students go to https://code.org/ and login with the credentials from the usernames and passwords list you generated earlier. Students work at their own pace on the challenges in Course 1.

 

 


 

 

Additional Second Grade Activities:

Engage and challenge your students with these supplemental 2nd grade 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

 

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.

 


Comic Life Digital Comics - Kindness

computer lab activities using comic life Comic Life - Students create a comic strip illustrating 5 acts of kindness.


Session 1 - Discuss kindess. Demo and practice how to use comic life. Explore and learn.

Session 2 - Fill out worksheet - Take pictures of students acting out kindness.

Session 3 - Continue with kindess pictures - take headshots - Begin building comic.

Session 4 - Build comics and print / save as pictures. Good for open house displays.

 

 

Research - Insects / Animals

Ant ResearchCommon Core Insect Research Graphic Organizer

Common Core Animal Research Graphic Organizer

Ants | Honey Bees | Spiders | Great White Sharks | Tigers | Dolphins | Student's Choice

Red Fire Ant | Water Strider | Lady Bug | Monarch Butterfly | Horse Fly | Luna Moth | Walking Stick

 

 

Fossils Webquest

Kindergarten computer activities using the internetThis is a webquest for finding information on the internet about fossils.

 

 

 

Butterfly Lifecycle PowerPoint

Butterfly LifecycleButterfly Lifecycle PowerPoint - 1 Slide

Butterfly Lifecycle Pictures | Butterfly Info and Pics | More Butterfly Info and Pics | More

 

iPad - Butterfly Lifecycle iPad Version - Butterfly Lifecycle Mini Poster

 

 

Frog Lifecycle PowerPoint

Frog LifecycleFrog Lifecycle PowerPoint - 1 Slide

Frog Lifecycle Pictures | Frog Lifecycle Info | Harcourt Frog Lifecycle Video

 

iPad Frog LifecycleiPad Version Frog Lifecycle Mini Poster

 

 

Microsoft PowerPoint - All About Dinosaurs (4 sessions)

PowerPoint lessons for first gradersStudents create a 4 slide PowerPoint about dinosaurs.


Session 1 - Lead the children as a group to build a basic 4 slide Power Point framework with titles on each slide and save.

Session 2 - Students research dinosaur facts using handouts with some assistance. Students save completed handouts with teacher / student names on them.

Session 3 - Students add the research info from the student handouts to their slides. Students collect and add images. Students and teacher review slide info for accuracy and spelling. Students save their work.

Session 4 - Students revise and edit as necessary and finish presentations.

 

Comic Life - Dinosaur Comic Presentation

Comic life computer lab lesson 2nd gradeStudents create a dinosaur facts comic strip using a comic strip creator program. This can be an alternative to the PowerPoint assignment.

 

 

Dinosaur Research

Kindergarten computer activities using the internet Students research facts about dinosaurs. This alternate lesson can supplement or substitute for the presentations.

 

 


 

PowerPoint

Learn PowerPoint in One Minute (Video)

Animal Camouflage -PowerPoint

Community Heroes - PowerPoint

All About Dinosaurs - PowerPoint

Fossils PowerPoint

How do People use Land?

Hurricanes and Tornadoes

Kindness PowerPoint

Then and Now

What Plant Parts Do (Mac iWork Keynote)

 

Excel

Excel First Chart

Excel Bar Chart

Excel M & M Chart

 

Word

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 Lady Bug Math

Copy and Paste Nemo

Cut and Paste Squidward

Copy and Paste Time - Hours

Copy and Paste Time - Half Hours

Copy and Paste Time - Quarter Hours

Cut and Paste Numbers

Cut and Paste - Positional Words

Cut and Paste Weather Words

Living and Non Living Things - Copy and Paste Practice

Forces - Pushing and Pulling - Copy and Paste Practice

 

Writing and Clipart

Common Core Opinion Writing Graphic Organizer

Ant Diagram

Clouds and Rain

Fall Acrostic Poem

Friendship Poster

Head, Shoulders, Knees and Toes

Halloween Pumpkin Personification Poem Generator

Happy Holidays

Happy Valentine's Day

Happy Mothers / Fathers Day

Happy Spring Break

Happy Thanksgiving Letter

I Have a Dream

Let's Create - Write an Ad - Famous Astronaut

Let's Create - Write an Ad - Famous Actor

Let's Create - Write an Ad - Dance Troupe

Let's Create - Write an Ad - Art Gallery

Let's Create - Write an Ad - Famous Author

Let's Create - Write an Ad - Famous Inventor

Let's Create - Write an Ad - Famous Singer

Let's Create - Write an Ad - Gymnastics Champion

Let's Create - Write an Ad - Famous Paleontologist

Making Bulleted and Numbered Lists

My Life - Time Line Template

Respiratory System Labeling in MS Word

Seasons of the Year

Skeleton Bones

Story About a Pumpkin

 

Graphics

Skeleton Labeling

Kindness Comic Strip

Butterfly Life Cycle Pictures for Projects

Frog Life Cycle Pictures for Projects

Anatomy - Labeling the Skeletal System ( Mac Version )

Dinosaurs Comic Life

Continents and Oceans Labeling

Water Cycle Illustration

 

 

More Ideas
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
    Excel Chart
  • Excel Pie Chart
  • Newspaper
    Template
  • Newspaper Template