Course Description: This is a basic course in the use of Microsoft Excel for data management and analysis that has beenrequested by our students. Assuming little prior knowledge of Excel, the course objective is to teachstudents a beginner's level of competency to:- import data into Excel, fill in rows and columns- check for errors- use simple formulae to examine and summarize data, or calculate new fields- do simple database tasks with tables, filters, and sorting- create 'cross tabs' with pivot tables for summarizing and analyzing data- draw, format, and present scientific graphs from Excel data- do simple statistical analyses -histograms, regressions (trend line), t-tests, ANOVAsThe course will focus on analyses typically performed by environmental scientists and biologists.Lectures, exercises, and all graded materials will focus on using Excel on laptops.
Place in the curriculum: We hope that most students will take the course early in their undergraduate careers. The idea is toprovide computational skills that students say they need both in courses and on co-op.
Specific course objectives: When you are finished with the course, I hope that you will be able to perform the tasks listed above.
Place in the curriculum: We hope that most students will take the course early in their undergraduate careers. The idea is toprovide computational skills that students say they need both in courses and on co-op.
Specific course objectives: When you are finished with the course, I hope that you will be able to perform the tasks listed above.