Michael Belanger                                                                                                        SHCPS

Impact of Technology in Education                                                                           2008-2009

Microsoft Excel

Overview:

This project was created to teach students about the possibilities Microsoft Excel offers and get them proficient at making spreadsheets, making graphs, and performing functions within a spreadsheet, and basic functionality.

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).Learn how to insert information into a spreadsheet.

 -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.

-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.

Length:

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

Materials:

• Teacher laptop with projector/ or Interactive Whiteboard
• Packets (study guides) for students
• Laptops with Microsoft Office installed for students

Teacher Background/Resources:

The teacher will need to know how to operate an Interactive Whiteboard or PowerPoint and have basic knowledge of the use of Microsoft Word in order to be of assistance to the students.

Required Student Knowledge:

Basic typing skills and be comfortable using the laptop computers Basic Operations Standard 1.

Product and Performances:

Interactive Whiteboard/or PowerPoint use with built-in activities to reinforce student knowledge.

Assessment:

Students will be assessed with a Qwizdom test at the end of four classes.

Technology skills required/developed:

• Proficiency with Microsoft Excel basics
• An understanding of the uses of spreadsheets
• Use and importance of  “Save As” feature.