Category Archives: computer applications

Financial Literacy: Budgeting

πŸ“–Standards
NBEA.PF.3
Β Β Β Develop and evaluate a spending/savings plan.

⏰Time
90 minutes

πŸ“²Technology Required
Teachers will need a computer connected to a projector or smart board to show the presentation or video. Students will need access to Excel, Sheets or other spreadsheet software.

πŸ“ƒSummary
Students will participate in a class discussion on the importance of budgeting and be presented an example of a personal budget. Students complete a personal budget using estimated or actual expenses and income. The lesson concludes with students watching videos that guide them through deciding on a long-term purchase using a spreadsheet.

LESSON

Introduction to budgeting discussion

Use this presentation to lead a class discussion on what budgeting is and why it is important.

During or after the presentation, ask these questions

  1. Why is a budget important?
  2. Name a short-goal.
  3. Name a long-term goal.
  4. What are 3 things on which you need to spend money?
  5. Name 3 things on which you want to spend money.

Project: Complete a personal budget

Introduce the personal budget project using this slides presentation that explains the purpose of the project and gives an example of a completed budget.

Assign the budget worksheet to students. This sheet can be opened and completed in Google Docs or downloaded and completed as a Word file. If students prefer, they can create a table in Sheets or Excel.

Project: How Good is Your Budget?

NOTE: This activity is part of the Applied Digital Skills curriculum through Google for Education. You do NOT need to create a classroom in the Applied Digital Skills program to complete this lesson. The only activity that requires sign-in is submitting a quiz at the end, which is really just an evaluation of how well the student liked the lesson.

In the previous activity, students completed a budget. In this activity, students complete the research a long-term purchase using a spreadsheet. Although the videos are done by Google and use Google sheets, the steps in creating and duplicating a formula work identically in Microsoft Excel. The video examples use selecting a cell phone and phone plan but students can use any other expense that interests them, including renting an apartment or buying a car. Teachers can copy and paste the instructions below into their Google classroom.

Instructions to Students

  1. Watch the Google for Education videos that you will find here on researching a long-term purchase.

https://applieddigitalskills.withgoogle.com/c/middle-and-high-school/en/plan-and-budget/develop-a-budget/develop-a-budget.html

2. Create a spreadsheet following the instructions in the videos. You can follow the video example of selecting a cell phone or use another long-term purchase, such as a car.

3. Submit your spreadsheet.

4. Submit a document in Word or Google doc explaining which option you picked and why.

ASSESSMENT: 

Students will participate in a class discussion and complete the two budget worksheets for teacher review.

Differentiation:

You may wish for students to play the Crossroads: New Decisions game budgeting module.

The game can be downloaded here. 

IMPORTANT NOTE TO TEACHERS: As this game was developed for youth in high-risk situations it includes game levels on making a safety plan, the Adverse Childhood Events Scale and other topics not normally covered in the classroom. It would be most appropriate for students in a therapeutic setting or in a life skills class where topics such as abuse are discussed. If you are not familiar with the ACES, please check the questions here

ND STATE STANDARDS: 

ND 5.12.1.0   Develop and evaluate a spending/savings plan..

Teaching frequency tables with Indigenous communities’ data

STANDARD

CCSS.MATH.CONTENT.6.SP.B.4 Display numerical data in plots on a number line, including dot plots, histograms, and box plots.

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

Technology Required

Students will need either a computer or tablet to play the game. Teachers will need a computer connected to a projector or smart board to show the presentation or video.

Time

60-75 minutes including, presentation, analysis and game

Summary

With a Google slides presentation, students are introduced to the concept of answering a question with data. A video is also provided for review. Using a data set of all tribal leaders in 2019, they are walked though an example of using Google Sheets to create frequency table and plots of data. Students then use the data set to create their own tables and plots. Students finish the lesson by playing a game where they learn about computing distributions in Mayan history.

Lesson

1. Presentation on primary sources and frequency distributions with Google sheets.

Give students a slide presentation that asks the question “How wired are tribes?” . This also gives the definitions of data, primary sources, secondary sources and frequency table. Students will learn how to create a frequency table with Google sheets.

Differentiated Instruction: If needed, students can review the information by watching this video on their own.

You can also assign students who were absent to watch the video on their own.

2. Assign Students to Create Their Own Frequency Distribution

A Google doc with the assignment and link to video.

You’ll need the 2019 Tribal Leaders Data Set to complete this assignment. Copy the link into Google classroom for students to access.

Here is the answer key for the teacher

If your students completed the assignment correctly, it will match the answer key here.

Differentiated Instruction: For more advanced students

You may wish to have them compute an additional frequency distribution to show the frequency distribution of tribal entities by BIA region. That answer is also provided in the file above.

3. Play a game that teaches distributions

When students have completed their assignments that can play AzTech: Meet the Maya, a game which teaches statistics, including frequency distributions.

Assessment

Two types of assessment are available, their answers to the assignment with Google sheets, and their responses to the in-app math challenges in AzTech: Meet the Maya, which are graded automatically with data available from the. teacher reports.

Making a Calendar with Google Slides

πŸ“– Standard

CCSS.ELA-LITERACY.WHST.6-8.6 Use technology, including the Internet, to produce and publish writing and present the relationships between information and ideas clearly and efficiently.

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

⏰ Time

200 minutes (approximately 5 class periods)

πŸ“² Technology Required

Students will use the Internet to find a minimum of 12 appropriate images to represent their topic. Students will need access to a device with Google Slides to create calendar.

πŸ“ƒ Summary

This lesson plan allows students to explore a topic of interest to create an informational calendar. Students are to pick a topic, include an image for each month, brief explanation and source for that image. At the end of the project, students perform a self-assessment.

πŸ“š Lesson

Introduce Assignment to Students

Calendar Assignment

In this assignment, you will be creating a personalized calendar using Google slides. Your calendar must consist of a minimum of 13 pages an include the following:

  1. A title slide with introduction of the topic.
  2. A page for each month with:
    1. An image related to your topic
    2. Text explaining the image and its relationship to the topic.
    3. A link to a source for the image and information on the page.

Presentation to Explain Modifying Template

Use this brief presentation to explain how to change the background on a slide and how to add images. It uses the 2022 calendar template as an example.

There are many, many Google Slides calendar templates you can find on the web. Many of these are great, some cost money, some are for 2021 and some have broken links. So, we added an example here that you, on the topic, “Indigenous”, that you can copy into your Google classroom and modify, just to make sure you would have a free template that is available and up to date. It uses a variety of methods of citing sources, from a simple web link in January to APA style in May.

The sample calendar as a PDF is found here.

Make a personalized gift

Janna Jensen, IT specialist from North Dakota, laminates each page in the calendar and binds the pages for a personalized gift from students to parents or other special people in their lives. If you have limited funds, you can just laminate the first and last page for durability, or skip lamination altogether if you don’t have a laminator.

If, like me, you don’t have a binding machine, you can just use a 3-hole punch and twist ties from cables or bags of bread. Ask the lunchroom staff to save some for you.

My first time ever using a laminator.

Make this assignment your own!

I highly recommend encouraging your students to improvise with this assignment. They can find another template on line, insert pages in between months so that each month has a large scale image at top – the possibilities are endless.

Assessment 

Students perform a self-assessment shown below. 

Related Lesson

You may wish to use this lesson to introduce students to the concepts of primary and secondary sources.

Differentiated Instruction

Advanced students may wish to complete these six online lessons to become more proficient with Google slides.

State Standards: North Dakota

K-5.IAI.9 Organize information using technology and other tools.


TE.K-5.MTL.11 Use technology to gather and share information with a variety of audiences in ways that others can view, use, and assess.

Calendar example with grazing lands

Making a Calendar with PowerPoint

by Janna Jensen

πŸ“– Standard

CCSS.ELA-LITERACY.WHST.6-8.6
Use technology, including the Internet, to produce and publish writing and present the relationships between information and ideas clearly and efficiently.

⏰ Time

200 minutes (approximately 5 class periods)

πŸ“² Technology Required

Students will use the Internet to find appropriate images to reflect tasks typically accomplished during a specific month. Students will need access to a device with PowerPoint to create calendar.

πŸ“ƒ Summary

This lesson plan allows students to explore agricultural subjects of interest to create an informational calendar. Students are to pick a field in agricultural and create a calendar outlining the big tasks performed each month. At the end of the project, students perform a self-assessment.

NOTE: While this assignment focuses on agriculture, it could be modified for any subject – science, social studies, literature, and, certainly, art.

Don’t have PowerPoint but you use Google Slides? Check out this lesson.

πŸ“š Lesson

Introduce Assignment to Students

Calendar Assignment

In this assignment, you will be creating a personalized calendar using PowerPoint. Your calendar must consist of a minimum of 13 pages an include the following:

  1. A title slide with introduction of the topic.
  2. A page for each month with:
    1. An image related to your topic
    2. Text explaining the image and its relationship to the topic.

See the Agriculture Calendar for an example.

Video or Presentation on Creating Calendar with PowerPoint

Classroom Presentation

Use this PowerPoint of Instructions on how to create a calendar with PowerPoint. It is a brief 3-5 minute explanation. Instructions are also available in Google Slides format.

Video

This video is only 1:33 and shows using PowerPoint to create a calendar

Students can watch the video above, which has only music, no voice over, so it will be usable even if your students don’t have headphones or your computers don’t have speakers. It is also a good review if students are learning at home or need an extra reminder.

Make a personalized gift

I laminate each page in the calendar and bind the pages for a personalized gift from students to parents or other special people in their lives. If you have limited funds, you can just laminate the first and last page for durability, or skip lamination altogether if you don’t have a laminator.

If you don’t have a binding machine, you can just use a 3-hole punch and twist ties from cables or bags of bread. Ask the lunchroom staff to save some for you.

Assessment

Students perform a self-assessment shown below.

State Standards: North Dakota

K-5.IAI.9 Organize information using technology and other tools.


TE.K-5.MTL.11 Use technology to gather and share information with a variety of audiences in ways that others can view, use, and assess.

Google Slides and Math

πŸ“–Standards

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.

⏰ Time

120 – 180 minutes (You may wish to use 2-3 class periods)

πŸ“² Technology Required

The games used here require a Chromebook, Windows or Mac computers or iPads.

πŸ“ƒ Summary

Students play three games that teach fractions and statistics. Students learn enhanced features of Google slides. They then create a Google slides presentation stating which is their favorite game and why.

πŸ“š Lesson

0. Optional: Google Slides Basics

If students are not familiar with Google Slides, begin with the Google Slides Basics lessons. If students know how to create slides document, select a theme, add text, images, transitions and animations, you can skip this step.

1. Introduce the assignment

Explain to students that they will be playing three different educational games and making a recommendation for future classes. If there is only time to play one of these games, which should the teacher choose. A copy of the assignment is here with both Chromebook and iPad games included. Save to your Google classroom or other system and delete whichever device is not available to your students. If your students have access to both devices, no editing is required. Since their presentation will be made with Google Slides and they want it to be as convincing as possible, they should include images and video to support their points.

2. Play AzTech: The Story Begins

This game teaches fractions and basic statistics, integrated with social studies terms and Latin American history.

Allow students 10 -15 minutes to play the game.

3. Learn about Google Slides Advanced Features

This presentation has links to six videos beyond Google slides basics.

Click on the links on the left side of the screen to learn about:

  • Modifying the theme
  • Inserting video
  • Adding effects to text and images

Allow 10-15 minutes to watch videos and start on their presentations.

4. Play Forgotten Trail or Fish Lake Adventure

Students play Fish Lake Adventure (iPad) a game that teaches fractions or Forgotten Trail (Chromebook), a game that teaches fractions and statistics.

Allow 10-15 minutes to watch videos and continue their presentations.

5. More Google Slides Advanced Features

Continue with more Google slides basics. Watch three videos on the right side of the screen on :

  • Customizing with Word Art
  • Publishing to the web
  • Presentation notes

Allow 10-15 minutes to watch videos and continue their presentations.

6. Play AzTech: Meet the Maya

Allow students the option of playing AzTech: Meet the Maya or continuing one of the two previous games. Meet the Maya continues the game series that teaches fractions and basic statistics, integrated with social studies terms and Latin American history.

Allow 10-15 minutes to play and continue their presentations.

7. Finish !

It’s decision time. Students will select one game to finish for their presentation. Students who finish ahead of the class may play the other games.

Allow 30 minutes to finish the game they have chosen and continue their presentations.

8. Optional (extra credit) Present or publish

Depending on your class and your own objectives, you may want to end this lesson with students either publishing their presentations to the web or presenting in class and trying to convince their classmates that the game they have chosen is the one students should be using to learn next year.

Allow 30 minutes to finish the game they have chosen and continue their presentations.

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.