Data Evaluation Project (Due by November 18, 2020)

profilefinewinesneed
Exceltips.pdf

You will need to

analyze the data from

the ML2 spreadsheet

based on your

evaluation questions.

Start with a simple

table in Excel. Here

we are looking at

participants’ reading

and math scores pre

and post program.

Once you have your

simple table in Excel,

you can select the

table, then click on

“Insert”, “Charts”

and select the kind of

chart or graph you

want to use. If you

keep your mouse on

the specific chart

type, it will give you a

brief description of

the chart and

purpose/use.

Once you have

created the chart,

you can right click on

the data inside the

chart to add labels

and other specifics

inside the chart.

Here is an example of the data label

menu options…

You can add more than one chart, and more than one type of chart on your spreadsheet; you can also copy and paste individual charts from

here to a Word document.