Home | Fall 2008 Schedule | Saving in Word | Assignments | Syllabus | Lab Help | Student Sites | Fall 2008 Student Links | Copyright and Fair Use Laws | Fast Track/MAT Calendar

Spreadsheet Assignment

Examples | Tutorials | Assignment | Upload | Scoring Rubric

Perform a Google search for "spreadsheet lessons" or look over the spread sheet examples.

Good Lesson Example on the Web

Resources for Science Learning
Third grade students discuss and choose a suitable subject in conducting a poll of their classmates; their choice is "Favorite Sports." http://www.fi.edu/qa98/me5/me5.html

Using Spreadsheets in Thinking Science Lesson
As an example of the use of spreadsheets the following makes use of Excel to analyze the data obtained by groups of pupils performing Activity 13 'Spinning Coins. 'http://www.edu.dudley.gov.uk/science/case4.html

Use Spreadsheets to Teach Mathematics and Meet Standards
Spreadsheet assignments offer concrete ways to explore abstract concepts in mathematics and other subjects. Mathematical ideas are conveyed in several different ways--using pictures, colored squares, and number lines. Counting on a number line or a number chart, or using pictures to count in a pictograph helps make the process of counting with numbers more meaningful. Samples of some completed assignments are included. http://www.angelfire.com/wi2/spreadsheet/necc.html#List

Math Forum People Learning Math Together
Examples

• Arithmetic and Geometric Series

• What's My Rule? (the function)
• Judy's Allowance
• Pay Plans
• How Much Would I Weigh on Mars?
• Scale Solar System Model
• The Biggest Box

http://mathforum.org/sum95/math_and/spreadsheets/examples.html

CSM Student Examples:

Student Problem 1  - total was included in graph

Student Problem 2- has no calculation

Tutorials on How to Use Excel

Ways to Upload your Spreadsheet

 There are different ways that you can upload your Spreadsheet.

Example 1: Save as Web Page - This is how it looks - The advantage of this is anyone can open it.

1. Open Excel - Choose the Save As option - in the Save as Type text box choose as a web page. Excel creates two items in this process a web page and a folder with the same name. You will need both of these to make the web page work.
2. Open Expression - From the File Menu choose Import then File
3. You will need to add both the HTM File and the Folder that has the same name as the HTM file
4. Then on your web page create a link to the HTM file.
 

Example 2: Save as PDF  - This is how it looks - The advantage of this is anyone can open it.

Same process as above, only in Step one you save as a PDF file instead of a web page and this process will only create one file. You will import just the file in the same way in Expressions and then link to it.

Example 3: Upload the Excel file - This is how it looks - This opens in Excel. If the person who is viewing your website does not have Excel they cannot open your file. However, you can also access the file and update it.

1. Open Expression - From the File Menu choose Import then File
2. You will need to add just the Excel File
3. Then on your web page create a linked to the Excel file.

Example 4: Copy and Paste - This is how it looks - Advantage of this is it is easy, but the disadvantage is the formatting doesn't come in as well.

You will have to select the elements separately. For example: first open excel and select the table information then copy it. Now open your web page in Expression and paste the table. Then do the same with the graph.

Scoring Rubric