Archives

Google Slides Basic Skills

⏰ Lesson Time

15-20 minutes EACH for two lessons

📲 Technology Required

Device with web-browser – Chromebook, laptop or desktop computer, iPhone or iPad

📃 Summary

There are 6 short videos on Google Slides topics like adding images and choosing a theme. We recommend breaking the first four videos into two separate lessons that students complete during class.

📚 Lesson

These lessons from Google for Education provide a good overview to Google Slides. These are part of the Applied Digital Skills program for which you can register your class and/or yourself or you can just select individual lessons. In our experience, students do better when the lessons are split over 3 or more days.

Day 1: Watch videos 1, 2 and 3

Learn Google Slides while creating a presentation about you. This lesson can be used as is or modified for other topics. The default assignment is for students to create an “All About Me” presentation. The first three videos explain creating a presentation, choosing a theme, inserting a title, adding text and images. You can copy the link and paste it into your Google classroom or other site used for assignments or have students watch these together as a group in class.

For younger students, these three videos may be adequate for your class requirements.

Day 2: Create a Presentation (Bells and Whistles optional)

Watch this five-minute video on Animation and Transition in Google Slides.

Create Your Own Presentation

After watching this 5-minute video, students are ready to create their own presentation. Students can create an “About Me” presentation as suggested in the Google slides or teachers can assign their own preferred topic.

Assessment

Rubric for assessment includes:

  • Student created Google slides presentation
  • Presentation includes the following elements: headers, text and images
  • Presentation uses at least one animation and one slide transition

For younger students, you may wish to eliminate the last requirement.

Related lesson:

Google Apps Basics for Hamsters — As the name implies, a super-basic introduction to Google Drive and Google Docs.

Google Apps Basics for Hamsters

While I have heard many teachers say,

“My students know technology better than I do.”

– Teacher who is often incorrect.

I have often found this not to be the case when it comes to Google apps. I’ve often found that students sometimes don’t want to admit that they don’t know Google apps, assuming that everyone else does.

No hamsters were available so I used my guinea pig

This is the first in a series of lessons for either teachers or students who may not be extremely familiar with Google apps.

For many years, I taught statistics in graduate programs in education, psychology, business and engineering. On a conference planning committee, we had a request that read,

“I would like a session on statistics, but not statistics for dummies. I want a session so easy that a hamster could understand it.”

So, that was the origin of my session, “Statistics for Hamsters.”

Now, maybe you are a Google apps guru and you don’t need any of this. Yay for you. Seriously, yay! Let’s hang out. Still, you may find these resources helpful to share with your students. Just copy the link into your Google classroom, which, of course, you know how to do.

If that is not you, keep reading, and we can still hang out. Especially if you bring coffee.

⏰ Lesson Time

25 minutes

📲 Technology Required

Device with web-browser – Chromebook, laptop or desktop computer, iPhone or iPad

📚 Lessons

Google Drive and Google Doc: Super-Basics

All the Google apps lessons follow a similar format of a series of 15-30 second videos on simple tasks like opening the app, creating a new file and sharing. The lessons are 6-7 minutes but by the time your students get their computers open, log on and start the lesson we estimate around ten minutes of class time.

We have had more success with having students do these activities in class prior to an assignment that will use the app.

This is our favorite basic–basic lesson on Google Drive. From Google for Education, takes six minutes and ends with a quiz where you can test your knowledge.

Introduction to Google docs – The total lesson should take about 7 minutes.

Use what you learned

Follow up this lesson with a simple assignment in Google docs. This provides three prompts students can choose from to answer a question. They will practice creating a doc, copying and pasting from a doc (or, alternatively, saving to their drive), editing a doc and sharing it.

Note to the teacher: You should save the assignment in your Google classroom or other system and be sure to edit it to include your email before assigning to students.

Primary and Secondary Sources with Buffalo Hunting

📖Standards

CCSS.ELA-Literacy.RH.6-8.1
Cite specific textual evidence to support analysis of primary and secondary sources.

⏰ Lesson Time

40-60 minutes

📲Technology

If you would like to incorporate the game, students will need access to computers with Spirit Lake installed on them.

In class: If you are teaching in person, you will need a laptop and projector for your slideshow presentation. If you want to include Spirit Lake gameplay, your students will need access to Mac or Windows computers that have Spirit Lake installed, along with their assigned usernames and passwords. Alternatively, Making Camp Dakota can be played on any device.

Remote: Students need internet connections to see your presentation, watch the videos, and view and enter answers on their worksheets.

📃 Summary

Discover why primary sources are important with a story about Dakota buffalo hunting. Have your students watch the following two videos back to back within the downloadable slideshow. These two videos together are great resources for a lesson on the value of primary sources. Included are questions for discussion and critical thinking. Students can do a primary sources scavenger hunt at the Library of Congress (LOC) website. Included in the slides are two curated museum videos about American bison.

Example usable to teach with primary sources: Black and white video of galloping buffalo

📚 Lesson

Present the lesson Buffalo Hunting – Primary and Secondary Sources. The slideshow comes with several examples of primary and secondary sources from the Library of Congress, the Smithsonian museum, and YouTube.

Videos with Primary and Secondary Sources

Two videos about the Dakota buffalo hunters are presented within the presentation for your students to compare and contrast. The first video contains primary sources, and the second is an interpretation of the narration using animation as a secondary source.

If you want to go directly to the two videos included in the Google slides presentation, these are linked below.

Video with Primary Sources
Video with Secondary Sources

Questions included within the Google Slides presentation

These can be discussed together in class or assigned to students to answer individually.

  1. Reflect: Which video did you like better? What did you like about it?
  2. Compare and Contrast: Was there any information you could get from the first video that you did not see in the second?
  3. Explain: Do you think both videos are equally accurate?
  4. Analyze: The first video used photos and paintings. The second video used animation to help tell the story. Both were made about the buffalo hunt. Which source did you think was more trustworthy? Why?
  5. Synthesize: Imagine if you could add some more facts to the video using primary and secondary sources. List one primary source you would add. List one secondary source.

Differentiated Instruction

Note: For differentiated instruction, you can have students select one or two of the questions to answer. In more advanced classes, you may wish to discuss how the oil painters could be biased in their representation of their subjects, and how even photos could be biased in the subjects photographers chose to capture.

Virtual Scavenger Hunt

  1. Review the copy and paste functions with your students as learning a key introductory component of online research using the LOC. Enclosed are instructions for students to help walk your students through.
  2. Have students research primary sources at the LOC website. Click the following link for downloadable graphic organizers to distribute to your class. One answer model has been filled out. Students will copy and paste URLs for six primary sources from the LOC site and label three of them.

Game

Spirit Lake is an adventure game with multiplication, division, and geometry practice that plays on Mac or Windows computers. This is tied in with Dakota culture and history. You can have your students play for 20-30 minutes, hunt rabid wolves, and hunt buffalo. Look out for primary and secondary sources!

Don’t have a Mac or Windows computer? Making Camp Dakota can be played on the web and also includes content with buffalo hunting, as well as examples of primary and secondary sources.

Assessment

To check their data, you need your Spirit Lake teacher data reports username and password and your students’ usernames and passwords roster added to your account for Spirit Lake.

Related Lesson

Primary and secondary sources

Primary and Secondary Sources

📖Standards

CCSS.ELA-Literacy.RH.6-8.1
Cite specific textual evidence to support analysis of primary and secondary sources.

⏰ Time Required

40 minutes

📲Technology Required

Students must have access to laptops, desktop computers, or tablets with an internet connection. Students also need a camera for taking pictures of their primary and secondary sources to email to the teachers.

📃 Summary

This history lesson for Grades 5-6 introduces primary and secondary sources as it relates to history.

This 40-minute lesson begins with a 7-10 minute presentation on sources with some formative assessment using manipulatives. Students can learn about secondary sources through the telephone game presentation. Students then delve into two different types of sources: primary and secondary sources. Students can do a KidCitizen online module about Primary Sources. The lesson provides a summative assessment activity where students generate two primary sources and one secondary source about an event in their lives.

📚 Lesson

Introduce the Lesson
The lesson slideshow, Primary and Secondary Sources, begins with the telephone game. Students will gain more understanding of why sources are important to keep track of.

Critical Thinking

Students think, “Why are sources important for studying history?” Question words are included in the slides: “Who, What, When, Where, Why, and How?”

KidCitizen Module

The link for the Primary Sources interactive module is included in the slideshow. Students undergo a self-paced but short online module to understand primary sources. Also, you can click here to explore the module and copy the URL.

Assessment

This activity, which does incorporate writing, is included in the slideshow, but is also written below. Just copy and paste the text into your Google classroom or other LMS.

You are living history! Tell the class about an event that happened in your life using primary and secondary sources. You may change the number of sources they submit to you.

  1. THINK: What resources do you need?
  2. SELECT two primary sources in your home about yourself and one secondary source. Label your sources as Primary Source and Secondary Source. 
  3. Take a picture of your two primary sources and of your secondary source. Email it to your teacher. 
  4. Write a paragraph about your historical life event in your own words using your sources as proof of what happened.

Understanding averages using skunks

📖STANDARDS  

CCSS.MATH.CONTENT.6.SP.B.5 Summarize numerical data sets in relation to their context, such as by:

  • CCSS.MATH.CONTENT.6.SP.B.5.A Reporting the number of observations.
  • CCSS.MATH.CONTENT.6.SP.B.5.B Describing the nature of the attribute under investigation, including how it was measured and its units of measurement.

CCSS.MATH.CONTENT.6.SP.B.5.C Giving quantitative measures of center (median and/or mean) and variability (interquartile range and/or mean absolute deviation), as well as describing any overall pattern and any striking deviations from the overall pattern with reference to the context in which the data were gathered.

CCSS.ELA-LITERACY.RH.6-8.7 Integrate visual information (e.g., in charts, graphs, photographs, videos, or maps) with other information in print and digital texts.

LESSON TIME

30 minutes 

📃SUMMARY

In this lesson plan, students will learn how to find the mean and calculate the average and practice finding the average in a game environment. They will learn about skunks and skunk farming through primary source material. Then analyzing historical data, students will calculate the average.

📲TECHNOLOGY REQUIRED

Device with web-browser (Chromebook, laptop or desktop computer)

📚LESSON

Introduce the Assignment

Students can read the assignment, Going on a Skunk Hunt , on their own or teachers can read it to the class and ask any questions (5 minutes)

Through the next three activities – video, reading and assessment –  students will gather clues to unlock the “secret password” for the Skunk Hunt and get to play a short online game. Individual links to the video, reading and assessment components are included below for your reference, but are all included in the Skunk Hunt activity as well for ease of student access. 

The answer to the Skunk Hunt/secret password is: 3harvestnewyork1911

VIDEO

Watch this animated video explaining how to find the average. The video includes an example problem walking through the process, introduces the formula to find the average and also includes vocabulary to explain that mean and average the same thing. (2:00)

READING

Read this short post, Skunks for Fur and Farming , about the intersection of skunks and agriculture, incorporating information from primary sources and historical data. (5-10 minutes)

ASSESSMENT

In this assessment activity, Playing the Skunk Market ,students will use a table with historical data to solve two to four problems asking students to find the average. Two problems require solving for the average and two problems require solving for the average or estimating the average. (10-15 minutes)

ANSWER KEY AVAILABLE HERE. 

RELATED: This lesson plan corresponds with the math standards covered in and refers to content included in Forgotten Trail. Forgotten Trail is recommended as a supplemental resource for this activity. The image at the top of this post is from that game. You can view your students’ progress on mastering these standards by viewing your teacher reports. You can access the Forgotten Trail reports here.

Reading & comparing bar graphs

📖Standards

CCSS.MATH.CONTENT.6.SP.B.5 Statistics & Probability: Summarize numerical data sets in relation to their context.

CCSS.MATH.CONTENT.7.RP.A.2.B Ratios & Proportional Relationships: Identify the constant of proportionality (unit rate) in  tables, graphs, equations, diagrams, and verbal descriptions of proportional relationships.

⏰Lesson Time

40- 50 minutes

📲Technology Required

Device with web-browser – Chromebook, laptop or desktop computer, iPhone or iPad

📃Summary

This lesson introduces students to reading and comparing bar graphs with proportional relationships. Students receive a slide or handout with four bar graphs and complete a set of cards with questions or complete the activity in Google slides . The lesson ends with an adventure game that includes discussion of interpreting bar graphs.

📚Lesson Plan

Related lesson plan

If you have not watched the videos on Mayan Trading and Distributions, you may want to check out this lesson plan first.

Preparing for the lesson – Options

Print out the cards if students do not have home Internet access or if you want to use the cards to do the activity in class. (Note: Business card stock may not be the best $10 I have spent as a teacher, but it’s high on the list. I  don’t know what it is about cards that makes something seem like a game but I have had the greatest success with activities like this one.). Here is a PDF for the cards. If you would like to download the cards to edit and add your own questions, here is a Microsoft Word doc.

If students are learning from home, you can copy the Google slides presentation to your Google classroom and assign to students.

1. Individual Activity

Use this Google slides presentation to introduce and explain the assignment.

Print out the “Graphs” page or display it using a Smartboard, projector or in your Google classroom. Each student / group is required to complete the cards using the graphs provided.

Example of card with graph question
One of a pair of cards comparing graphs

2. Class Activity

After the students have completed the assignment, which should take around 10-15 minutes, have students share their findings to these questions with the class. Discuss and review the different questions and answers that can come from the same set of data.

3. Play Games!

Students can play the AzTech: The Story Begins to practice statistics in a history adventure game. Link available from the games page, select the device on which you want students to play. Available free for Chromebook, Android or iOS.

AzTech: The story Begins
Play AzTech: The story begin

Assessment

AzTech Games Teacher Reports – Teachers can access standards-aligned student reports including answers to problems, number of correct answers, quiz results and pre-test/post-test results.

Students’ responses in the activities above, both individually and as a group, provide formative assessment of their ability at interpreting and extrapolating from graphical data.

State Standards

Minnesota Math Standard 7.2.2.1 – Represent proportional relationships with tables, verbal descriptions, symbols, equations and graphs; translate from one representation to another. Determine the unit rate (constant of proportionality or slope) given any of these representations.

Distributions and Mayan Trading

📖Standard

7.SP.A.1 Understand that statistics can be used to gain information about a population by examining a sample of the population; generalizations about a population from a sample are valid only if the sample is representative of that population. Understand that random sampling tends to produce representative samples and support valid inferences.

Minnesota State Standard – History Sub-strand 4, Standard 15 “North America was populated by indigenous nations that had developed a wide range of social structures, political systems, and economic activities, and whose expansive trade networks extended across the continent.”

Time

20- 30 Minutes 

📲Technology Required

Device with web-browser – Chromebook, laptop or desktop computer, phone or tablet

📃Summary

The two videos here combine math and social studies, because, clearly, the Maya understood math. The concept of distributions is introduced in the context of trading, explaining why some objects are more valuable. Students play AzTech: Meet the Maya, which teaches measures of central tendency. The lesson concludes with a question and another video on distributions.

📚Lesson Plan

1. Watch video – Mayan Trading (1:57)

The Mayan trading video is based on an idea from one of my favorite history teachers, who says that history is more than just names and dates but also how people lived, what they used, what they did. It also has a bar chart of the relative value of objects. It explains that the Maya traded less common items for more common ones and that items that were more difficult to obtain were more valuable.

2. Play AzTech: Meet the Maya

Next, have students start the AzTech games series. They can play AzTech: Meet the Maya online or using an iPad. We recommend downloading the game onto your iPhone or iPad for better performance.

3. Question to test understanding

José tried to trade a banana for a quetzal feather and a villager threw a spear at him. Why would the villager do that? Explain using math. Extra points if you can discuss distributions in your explanation.

4. Video giving the answer to the word problem on distributions (5:15)

This five-minute video introduces distributions and variability and gives an example of computing a weighted mean from a frequency distribution.

OPTIONAL You can also copy this Google slides presentation to your own classroom if you’d rather modify the explanation for your own lecture. The slides can also be printed out and sent home with students who do not have Internet access.

ASSESSMENT

You can view your students’ progress on mastering these standards by viewing your teacher reports. The link to the teacher dashboard for AzTech: Meet the Maya student reports can be found on this page. You should have received a password during the Growing Math training.

State Standards

Minnesota State Standard 6.4.1.1 – Determine the sample space (set of possible outcomes) for a given experiment and determine which members of the sample space are related to certain events. Sample space may be determined by the use of tree diagrams, tables or pictorial representations.

Related Lesson

Distributions and Mayan Trading (Bilingual English & Spanish) – This lesson is a bilingual version of the lesson above and features resources in English and Spanish.

Science, language arts and math with wildflowers

📖 STANDARDS

English/ Language Arts

CCSS.ELA-LITERACY.RI.6.7 Integrate information presented in different media or formats (e.g., visually, quantitatively) as well as in words to develop a coherent understanding of a topic or issue.

CCSS.ELA-LITERACY.RI.6.4 Determine the meaning of words and phrases as they are used in a text, including figurative, connotative, and technical meanings.

Next Generation Science Standard

MS-LS2-1 Ecosystems: Interactions, Energy, and Dynamics: Analyze and interpret data to provide evidence for the effects of resource availability on organisms and populations of organisms in an ecosystem.

Mathematics Standard

CCSS.MATH.CONTENT.6.SP.A.3 Recognize that a measure of center for a numerical data set summarizes all of its values with a single number.

📲 Technology required

Optionally, the teacher will have access to a printer to print pages 2-3 of the book and selected pages to color. Since choke cherry and Simpson’s Ball Cactus are mentioned in the problems, it is recommended that, at a minimum, these pages should be printed. Alternatively, the link can be shared to students who are learning from home to read material on their computer.

📃 Summary

This is a true STREAM lesson. Combining science, reading, art and mathematics. Students read a description of the pine forest ecosystem and life zones. They define any new words in their personal dictionary. Students then use information on plant life to identify life zones and locate these zones in terms of altitude. Students who complete the activity before the allotted class time play a game that teaches fractions and basic statistics.

Time Required

50 minutes

📚 Lesson Plan

Read pages two and three of Wildflowers of Ponderosa Pine Forests Coloring Book – These pages explain the pine forest ecosystem, including an illustration of Life Zones.

Complete word journal

Some teachers call it a personal dictionary, to others it’s a word journal. Regardless, the goal is the same, for students to record new words, give a dictionary definition and “make the word their own”. This can be done by rewriting the definition in their own words, using the word in a sentence or including an illustration of the word.

Two dictionary sites to recommend for definitions are below. An added bonus to mention to students is that they can hear words pronounced.

Since students often ask for an example, here is an example you can link in your lesson.

The personal dictionary assignment, with all links, can be found here. Feel free to copy and paste into your Google classroom or other site, or print out for your class.

Use Life Zones to Solve Problems

Angie and Sam are on their way to Michigan but they have gotten so, so lost! They are somewhere in Colorado. Sam has sent Angie this text:

Hey, Angie! I can’t see you anywhere. All I can see are trees, a whole lot of trees, and if I look up the mountain, I see even more trees, closer together. I recognize this plant with red berries. Grandma called it choke cherry. Where are you? How can I meet you? Should I go up or down?

Angie texts him back,

There aren’t that many trees around me, but there are some of these round cactus plants. We are definitely not in Michigan!

Use the information on life zones to answer these questions. (Hint: You may have to look on the plant pages as well.)

  1. In which of the five life zones is Sam right now? How do you know?
  2. In which of the five life zones is Angie right now? How do you know?
  3. Should Sam go up the mountain or down the mountain to meet up with Angie? Why?

Click here for the life zone assignment as a Google doc.

BONUS 1: Game Play

You might recognize Sam and Angie from the game, Forgotten Trail, where they try to retrace their ancestors’ journey across the U.S. and Canada. If you finish this assignment and your personal dictionary before class time is over, play Forgotten Trail here.

BONUS 2: Art

As an alternate bonus activity, students may color the pictures in the book according to the legend included. This would require that the teacher print pages for students. Since choke cherry and Simpson’s Ball Cactus are mentioned in the problems, it is recommended that, at a minimum, these pages should be printed.

Assessment

Recommended rubric for the Personal Dictionary is as follows:

This assignment is worth 100 points. A minimum of ten words is required. You can include up to two extra  words for an additional 20 points.

Each word is worth 10 points.

  • Dictionary definition – 3 points
  • Definition in your own words – 5 points
  • Use in a sentence or draw a picture – 2 points

Recommended rubric for Life Zone Questions

Each question is worth 25 points.

Sam is in the Montane zone (5 points). We know this because he sees a lot of trees and the Montane zone is a forested area. He said that there are even more trees up ahead so we know he is not in the subalpine area because above that are no trees (10 points). He also saw choke cherry plants and these are at elevation from 7,000 – 9,000 feet. The Montane zone starts at 8,000 feet. (10 points)

Angie is in the Foothills (5 points). We know this because she says there are not many trees (10 points) and she sees the Simpson’s Ball Cactus which is common in the Foothills (10 points).

Sam should go down the mountain to meet Angie (5 points) because Sam is in the Montane zone, which is at 8,000 to 10,000 feet (10 points) and she is in the Foothills which is at (6,000 to 8,000 feet) so he needs to go down in altitude to meet her (10 points).

Assessment for Forgotten Trail math problems

Problems are scored automatically within the game. Teachers who are part of the Growing Math project or with 7 Generation Games site license can access student data from the Reports page.