Tech Lesson 10a: Setting Math
Story Problems to a Spreadsheet
Demonstrates understanding of basic technology and telecommunication
Operates Basic technology tools and applications
CSTA Level I Standard 4: (3rd to 5th) Use general purpose productivity
tools and peripherals to support personal productivity, remediate skill
deficits, and facilitate learning throughout the curriculum.
CSTA Level I Standard 5: (3rd to 5th) Use technology tools for
individual and collaborative writing, communication, and publishing
activities to create presentations, and publishing activities to create
presentations for audiences inside and outside the classroom.
M5P4 Students will make connections among mathematical ideas and to
M4P5: Students will represent mathematics in multiple ways.
M5A1: Students will represent and interpret the relationships between
Student Instructions: (Example Worksheet)
1. Read the Story Problem and circle the characters or objects in the
2. Underline the the numbers in the story and draw arrows to point to
the characters or objects they refer to.
3. Draw a box around the essential question of the Story Problem.
4. Decide what math function will be needed to solve the problem.
-> Combination or multi-step
5. Start Open Office. Click File->New->Spreadsheet
6. Put the characters or objects in cells B2 and B3. (Use more
cells in Column B if needed)
7. Put the number values in Column C next to the characters or objects.
10. Type "Answer" in Cell B3 (Or at end of character Column)
11. Underneath the "Answer" Cell - type the formula needed to solve the
Multiplication =C2*C3 (Notice that * means "multiply" in most
Division =C2/C3 (Notice that / means "divide" in most computer
12. Your Spreadsheet should look like this:
12. Save your work as "Lastname Problem Practice" in your file
Check your answer by hand.