Charts & Fractions
i n t e g r a t i n g . e x c e l . i n t o . t h e . c u r r i c u l u m
w e b s i t e c r e a t e d b y : E u g e n i e K i m
G r a d e : 5
S u b j e c t : M a t h
M a t e r i a l s : B o o k s   a n d / o r   I n t e r n e t ,   M i c r o s o f t   E x c e l
T E K S [ O b j e c t i v e s ] :: F o c u s :: A c t i v i t y :: R e s o u r c e s :: E D C I 4 2 0 3

 

T E K S  1 1 1 . 1 7 [ a ][ 1 ][ 2 ][ b ][ 2 ][ A ][ 5 ][ B ]
m a t h e m a t i c s		 [up]

Number, operation, and quantitative reasoning. The student uses fractions in problem-solving situations. The student is expected to:

+ generate equivalent fractions

Patterns, relationships, and algebraic thinking. The student makes generalizations based on observed patterns and relationships. The student is expected to:

+ use lists, tables, charts, and diagrams to find patterns and make generalizations such as a procedure for determining equivalent fractions

f o c u s [up]

+ Explain the concept of fractions and how to obtain equivalent fractions.

+ Use a visual such as a pie. This pie visual can also lead into the idea of pie charts. Explain the significance of pie charts

a c t i v i t y [up]

. Activity 1 .

Students will make flash cards, which will help them study and learn equivalent fractions. On one side of the flash card should be a reduced fraction, and on the other side should be an equivalent fraction. Practice with the non-reduced fraction to see if the student can think of the equivalent fraction.

. Activity 2 .

Complete the Pie Charts and Fractions worksheet using Microsoft Excel.

. Activity 3 .

Students will collect data from friends, family, or classmates, of their favorites. Favorite can include types of music, types of food, types of animals, etc. Then, using the Chart Wizard in Microsoft Excel, students will create a data table which clearly shows how many people preferred each item, and will then graph the data.

** Students will either email their activities to their teachers or print out and turn them in. **
r e s o u r c e s [up]

** Remember to cite your sources. Plagiarism is not only wrong, it is illegal **

* Fractions -- From MathWorld

* Equivalent Fractions

* Microsoft Excel Chart or Graph Help

n o t e : [up]
This website is copyrighted, but is openly available for public and private educational use. The lesson and site itself were created by Eugenie Kim in hopes of enriching students' minds in math, through integration of Microsoft Excel.

 

 

 

 

 

 

 

Hosted by www.Geocities.ws

1