Midterm Assigmnent

Today in class we performed a mid term assignment showing how to use excell spreadsheets.  We used formulas and/or functions to perform this task. This was the assignment:

In Excel, use formulas and/or functions to answer the following questions:

How many 1) males, 2) females, 3) traditional 4) non-traditional undergraduates, 5) graduates 6) in-service graduate student that are currently teaching, and 7) total respondents.
What was the average score for each category above 3-6 (trad, non-trad, grad, inservice grad)?
Create a column chart of the averages by group classification (1-4) and move it to its own worksheet. Rename the work-sheet Averages by Group.  Make sure your chart has added data labels to show the values and a heading.
Do a ttest between the highest and lowest average and determine if it is statistically significant.  When conducting the ttest use a 1, 2 for the tails (1) and type (2) fields of the ttest function as we did in class.
Upload, share your doc with me ricpierce@gmail.com, and publish your spreadsheet in Google Docs.
Create a blog post that summarizes the learning and link to your published spreadsheet document. 

ISTE NETS T

1. Facilitate and Inspire Student Learning and Creativity

Teachers use their knowledge of subject matter, teaching and learning, and technology to facilitate experiences that advance student learning, creativity, and innovation in both face-to-face and virtual environments. Teachers:

a.	promote, support, and model creative and innovative thinking and inventiveness.
b.	engage students in exploring real-world issues and solving authentic problems using digital tools and resources.
c.	promote student reflection using collaborative tools to reveal and clarify students' conceptual understanding and thinking, planning, and creative processes.