Professional Learning Podcast Treasury Lesson Plans Personal Workspace Site Search ALEXville Learning Assets Home Courses of Study
Home  |    Add Bookmark   |   Print Friendly   |   Rate This Lesson Plan   |   Suggest a Variation

You may save this lesson plan to your hard drive as an html file by selecting "File", then "Save As" from your browser's pull down menu. The file name extension must be .html.

This lesson provided by:
Author: Laura Roberts
System:Shelby County
School:Calera Middle
Lesson Plan ID: 4253
Title:

Introduction to Spreadsheets

Overview/Annotation:

Students will utilize Excel or other spreadsheet software to create both text and numerical valued columns to produce a Christmas or birthday wish list.

Content Standard(s):
TC2(6-8) 5. Use basic features of word processing, spreadsheets, databases, and presentation software.
TC2(6-8) 6. Select specific digital tools for completing curriculum-related tasks.
TC2(6-8) 11. Use digital tools and strategies to locate, collect, organize, evaluate, and synthesize information.
MA2013(5) 12. Solve word problems involving addition and subtraction of fractions referring to the same whole, including cases of unlike denominators, e.g., by using visual fraction models or equations to represent the problem. Use benchmark fractions and number sense of fractions to estimate mentally, and assess the reasonableness of answers. [5-NF2]
MA2013(5) 16. Solve real-world problems involving multiplication of fractions and mixed numbers, e.g., by using visual fraction models or equations to represent the problem. [5-NF6]
MA2013(5) 17. Apply and extend previous understandings of division to divide unit fractions by whole numbers and whole numbers by unit fractions. (Students able to multiply fractions in general can develop strategies to divide fractions in general by reasoning about the relationship between multiplication and division. However, division of a fraction by a fraction is not a requirement at this grade.) [5-NF7]
Local/National Standards:

[Local Standards]6th Grade Business Explorations - Produce a spreadsheet utilizing cell characteristics, row height and column width, borders and shading and page layout; 7th Grade Business Explorations - #10 - Produce a spreadsheet utilizing cell characteristics, row height and column width, borders and shading, page layout, and addition.

Primary Learning Objective(s):

Students will understand a simple spreadsheet and its use. Students will be able to create a simple spreadsheet using Autosum for addition.

Additional Learning Objective(s):

Students will learn the difference between text and numerical values for column use.

Approximate Duration of the Lesson: 31 to 60 Minutes
Materials and Equipment:

Catalogues or newpaper advertisements with prices of various items

Technology Resources Needed:

Computer, Excel or other spreadsheet software, printer, paper, overhead projector. Laser printer desirable, but not required.

Background/Preparation:

Teacher (presenter) should go through the activity before teaching to review the basics of Excel. Make sure students are able to relate various uses for spreadsheets, such as accounting and cost tracking.

Procedures/Activities:
1.)Discuss the use of spreadsheets in programs such as Excel.

2.)Open Excel and discuss the cell characteristics and form of information entry.

3.)Merge the first row of 7 cells across for a title bar explaining the differences between rows and columns. (Highlight the cells, then choose "Cells" from the Format menu and click on the "Alignmemt" tab to place a check in the "Merge Cells" box.)

4.)Students then name the list using their own names and "Wish List." Explain how to select font style and how to bold and center the title.

5.)In the second row of the spreadsheet enter the sub-title headings such as Item, Estimated Cost, Actual Cost, Rating (Priority), Most Important. (Explain how to widen columns, if needed.)

6.)Below the sub-heading highlight the next 8 cells in Column 1 and format the cells for text. ("Number" tab on the Format/Cells menu.) This will allow students to list the items they have selected.

7.)Have students enter items they would like to include on their "wish" lists. Students only need 1 or 2 items to begin. Suggest new shoes or clothing items to stimulate thought. Unfamiliar items can be used to teach vocabulary words. For example, picture mats were an item unfamiliar to my students.

8.)Highlight the same number of cells in Column 2 and format the cells as numerical/currency.

9.)Enter estimated cost of selected items. This will also produce discussion possibilities.

10.)Format Column 3 for currency and use the catalogues or advertisements for actual prices. This column can be provided for student use as a follow-up activity to save time in completing the spreadsheet.

11.)In Column 4 the student will rate the items on a scale of 1-8 with #1 representing the most important item. This may also be the most expensive item.

12.)Column 5 is used to mark the item that the student wants the most in the event that another item is too expensive. Asterisks may be used to note the one "most wanted" item.

13.)Column 6 and 7 can be used later. Students may be shown how to insert rows and columns at any time during the activity.

14.)Use Autosum to get a total for Columns 2 (estimated cost) and 3 (actual cost).(Click in Cell B15, then click the Autosum symbol in the tool bar. Do the same in Cell C15.)

15.)Demonstrate how to set the print area. (Highlight the area to print and from the file menu select "print area," then "set print area.") Students may go to "page setup" and choose "landscape" then adjust the margins to center the spreadsheet on the paper.

16.)Have the student save his file as Christmas or Birthday Wish List for later use.

17.)Show the students how to print the spreadsheets to share with their parents.

Attachments:**Some files will display in a new window. Others will prompt you to download. Excel activity.xls
Assessment Strategies:

Completion of the chart without "actual prices" is full credit. Following the process from beginning to printing is the desired product at this stage.

Extension:

Students may add actual prices for items, clip art, borders, or shading.

Remediation:

Teacher may partner a stronger student with a student who may need extra assistance or seat the student nearer the teacher or with a direct view of the area where the overhead will be displayed.

Each area below is a direct link to general teaching strategies/classroom accommodations for students with identified learning and/or behavior problems such as: reading or math performance below grade level; test or classroom assignments/quizzes at a failing level; failure to complete assignments independently; difficulty with short-term memory, abstract concepts, staying on task, or following directions; poor peer interaction or temper tantrums, and other learning or behavior problems.

Presentation of Material Environment
Time Demands Materials
Attention Using Groups and Peers
Assisting the Reluctant Starter Dealing with Inappropriate Behavior

Be sure to check the student's IEP for specific accommodations.
Variations Submitted by ALEX Users:
Alabama Virtual Library
Alabama Virtual Library

Hosted by Alabama Supercomputer Authority
The University of Alabama at Birmingham
The University of Alabama at Birmingham
The Malone Family Foundation
The Malone Family Foundation
Thinkfinity
Thinkfinity
Best of the Web

Web Design by: Digital Mason LLC