Michael Belanger                                                                                                        SHCPS

Impact of Technology in Education                                                                              2008

If I had a Million Dollars 

Overview:

This project was created to integrate spreadsheet skills, data entry skills, and technology standards.  Students will create a budget worksheet.

Grade 6-8

Standards Covered:

1.1       1.4       1.12     1.13     1.14     1.15     1.16     1.17     1.25     2.5       2.6       2.7

Student Learning Outcomes:

Students will

·         Use features of a computer operating system (e.g., determine available space on local storage devices and remote storage resources, access the size and format of files, identify the version of an application).

·         Identify and use a variety of storage media (i.e., CDs, DVDs, flash drives, school servers, and online storage spaces), and provide a rationale for using a certain medium for a specific purpose. Create an original spreadsheet, entering simple formulas.

·         Describe the use of spreadsheets to calculate, graph, organize, and present data in a variety of real-world settings..

·         Create an original spreadsheet, using formulas.

·         Use various number formats (e.g., scientific notation, percentages, exponents) as appropriate.

·         Produce simple charts and graphs from a spreadsheet.

·         Distinguish among different types of charts and graphs, and choose the most appropriate type to represent given data.

·         Apply advanced formatting features to customize tables, charts, and graphs.

·         Use a variety of technology tools (e.g., dictionary, thesaurus, grammar-checker, calculator) to maximize the accuracy of work.

·         Identify and discuss the technology proficiencies needed in the workplace, as well as ways to prepare to meet these demands.

·         Identify and describe the effect technological changes have had on society.

·         Explain how technology can support communication and collaboration, personal and professional productivity, and lifelong learning.

This project will take approximately 4 classes from start to finish.

Materials:

• Laptops
• Network access
• Printer access

Teacher Background/Resources:

The teacher will need to know how to use Excel. The teacher will also need to know how to save student’s work into the server. Also, have the capability to print.

Required Student Knowledge

Students will have prior experience using Excel, but it will only be used in a simple way. Knowledge is not required, but helpful. Students will need to understand the benefits of Excel spreadsheets.

Product and Performances:

You have just won the lottery and are giving each one of the students ONE Million dollars to spends how ever they want. Have them create a spreadsheet reflecting how they will spend the money. They must choose at least five different ideas on where to spend it, and show a chart on where the money will go using subsections, a table, chart, pictures, and formulas.

Assessment:

Students will be assessed according to their final document on how accurate the spreadsheet is, and how much the spreadsheet shows.

Technology skills required/developed:

• Understand the functions of Excel
• Learn how to save documents into the server