Hot Excel Projects for Elementary Classroom

1
Hot Excel Projects for Elementary Classroom
2
This session explained and demonstrated how to
infuse Bloom's Taxonomy with MS Excel. The
presenters distributed a higher-order thinking
skills (HOTS) tool which they suggested keeping
posted on or near the teacher's workstation so as
to have easy access to HOTS type questions during
the lesson. We were shown several examples of
the data collection projects they created
strictly for the purpose of using MS
Excel--favorite weather conditions, weather
comparisons, favorite french fry producer,
holidays). Their ideas were easy to use and
implement without needing a lot of preparation
work. To ease the burden on teachers, templates
could be created so teachers can have access to a
variety of project ideas. The samples they
demonstrated were for the elementary grade
levels. After collecting the data in the form of
student votes, the teacher shows the graphic
representation from the data. Then, they
explained how any data collection lesson can
easily involve asking HOTS questions to our
students (i.e., How would our graph change if we
added _____? What if we lived in ______, would
our graph look the same? etc.) For the lower
grade levels, you could use pictures to represent
the graph charts for better understanding.
3
(No Transcript)
4
Create Favorite ______ Spreadsheet To Create
Spreadsheet Open Excel Click WORD Art icon. Type
the name of the question. What is your Favorite
___________? Click OK Click and drag the title
to the top of the page Type the name of one of
the favorite objects in cell A5 Type the name of
the next item in cell A6. Continue to include the
number needed To make the columns auto fit,
move the cursor to the gray bar with the column
letters. Double click the line between A and
B. Gather the data Click in the cell next to
the item to type each data amount Press TAB to
move to the next column Press Enter to move to
the next row
5
To Create Graph Highlight columns A and B with
the information (Note the first cell will not
be shaded) Click the Graph (chart)
Wizard Follow the wizard- Click
Finish To size the graph, click on the black
handles and drag.
6
(No Transcript)
7
(No Transcript)
8
(No Transcript)
9
(No Transcript)
10
(No Transcript)