Excel is great tool for
solving math problems related to inventory tracking. Sixth grader should be taught to use Excel to
help them understand and solve inventory
problems. First demonstrate how to manually
track and maintain Classroom furniture and art supply inventory. Next, manually determines the total cost to
restock items that are below required
inventory limit.
Next, use a laptop computer, Microsoft Excel, and the Smart
Board to demonstrate how the same problems are solved using Excel spread sheet.
Advantage of using Microsoft Excel:
Using Spread sheet to track inventory, what items and how
many to order, and calculate total cost
of the purchase order. Once the formulas
and charts are set up properly in the spread sheet, any changes to the
furniture, art supplies, and item unit prices, all the dependent data such as
the quantity to order, the total purchase costs, and all the bar charts and pie charts are
automatically updated to reflect the change.
Spread sheet user don't have to belabor themselves with the calculations
or updates to the pie charts and bars charts.
The most costly items can be readily identified visually by
examining pie chart and percentages which are automatically calculate when pie
chart is added for select group of data cells.
|
TechPACK components
|
What is known
|
What must be learned
|
|
Technology
|
Laptop personal
computer basic, spread sheet basics, Microsoft Word basics.
|
Spread sheet, insert
math function, insert bar graphs, pie charts.
Research online for Excel tutorial software.
|
|
Pedagogy
|
Model how to solve a
small inventory tracking and reorder problem by applying addition,
subtraction and multiplication of decimal numbers and whole numbers.
|
Model a small
inventory tracking and reorder problem using Excel spread sheet
|
|
Content
|
Decimal Number
Addition, Percentage. Solve word
problem in everyday situation by applying whole number and decimal addition /
subtraction.
|
Using Microsoft
spread sheet to solve the inventory problem
|
No comments:
Post a Comment