In the 1st Qtr, students continue to develop two hand homerow typing proficiency. 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.

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.

Fifth Grade Technology Lesson Schedule:

First Quarter - August ~ October

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.

Qtr. 1 - Week 2:

Session 2:

Budget Spreadsheet with Chart | Enrichment

Students create a budget spreadsheet and chart with school supplies.

Assign:Back to School - School Supplies Budget Spreadsheet

Instructions: Students have $65.00 to spend on school supplies. Students use the School Supplies Price List to purchase as many items as they can without going over budget. Students create a budget using a spreadsheet to show how much they have to spend (allowance) , and how much each item costs (expenses). Students use a simple formula (sum) to calculate the total expenses. Students create a simple formula to subtract total expenses from the $65.00 allowance to show how much money is left over (allowance - expenses = money left over). Students create a chart showing their expenses.

Qtr. 1 - Week 3:

Session 2:

Budget Spreadsheet with Chart | Enrichment

Students create a Budget Spreadsheet and chart with clothing items.

Assign:Clothes Shopping Budget Spreadsheet

Instructions: Students have $150.00 to spend on school clothes. Students use the Clothes Shopping Price List to purchase as many items as they can without going over budget. Students create their spreadsheet using the list of clothes and their prices. Students use a formula (SUM) to calculate their total clothing expenses. Students create a chart illustrating their clothing expenses.

Qtr. 1 - Week 4:

Session 2:

Budget Spreadsheet with Chart | Enrichment

Students create a party food budget spreadsheet and chart.

Assign:Party for Five Food Budget Spreadsheet and Chart

Instructions: Students have a budget of $25.00 to feed a total of 5 people (including themselves) for a party. Students must try to buy as much as they can without going over the budget. Students create a budget using a spreadsheet to show how much they have to spend (allowance) , and how much each item costs (expenses). Students use autosum to calculate the total costs. Students create a simple formula to subract total food expenses from the $25.00 allowance to show how much money is left over (money left over).

Qtr. 1 - Week 5:

Session 2:

Budget Spreadsheet with Chart | Enrichment

Students create a pet adoption budget and chart.

Assign:Puppy Pet Adoption Budget Spreadsheet

Instructions: Students have a budget of $200.00 to adopt a new puppy and a variety of related items for the puppy. Students choose all the items they think they need to get started taking care of the new puppy, but they must keep costs under $200.00. Students create a budget using a spreadsheet showing how much they have to spend (allowance), and how much each item costs (expenses). Students use the autosum formula to calculate the total costs. Students use a simple formula to subtract total adoption expenses from the $200.00 allowance to show how much money is left over (money left over).

Qtr. 1 - Week 6:

Session 2:

Budget Spreadsheet with Chart | Enrichment

Students plan a party and stick to the budget.

Assign:Birthday Party Budget Spreadsheet

Instructions: Students have a budget of $100.00 to feed a total of 15 people (including themselves) for a birthday party. Students create a birthday party budget spreadsheet to show how much they have to spend ( $100.00), the total costs of the items they buy, and how much they are over or under the budget amount. Students research online stores (Amazon, Walmart, other) to find their party items and prices. Students may use the "Quick Start Template" to save time.

Qtr. 1 - Week 7:

Session 2:

Budget Spreadsheet with Chart | Enrichment

Students chart fast food nutrition and calorie information.

Assign:Fast Food Calorie Chart

Instructions: Students search for fast food nutrition and calorie information on the internet. Students plan a meal with a burger, sandwich or salad, along with a side order of french fries or other item. Students also add a drink and a dessert to their meal. Students enter the calories and the fat calories for each item into their spreadsheet. Students choose any restaurant they would like to eat at for their planned meal (McDonalds, Burger King, Jack in the Box, Wendy's, Subway, Taco Bell, Carl's Jr. etc).

Qtr. 1 - Week 8:

Session 2:

Budget Spreadsheet with Chart | Enrichment

Students create a profit or loss spreadsheet and chart for a lemonade stand.

Assign:Profit or Loss Spreadsheet for Lemonade Stand

Instructions: Students create a spreadsheet and chart comparing Thanksgiving dinner prices for two stores. Students choose the same 6 or 7 items from each store to compare. Students create their spreadsheet using prices from the Thanksgiving price list. Students format the numbers with dollar signs. Students use a formula (SUM) to calculate the total costs. Students create a chart illustrating their expenses. Students may add clipart or related images.

Additional Fifth Grade Activities:

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.