| |
|
 |
School of
Agriculture and Natural Resources
|
Course Outline for AGSC 137
Analysis
and Interpretation of Agricultural Data
Spring 2008
WebCT
Access of Course Material On-line (for students enrolled in the course)
INSTRUCTOR:
| Dr.
Walid H. Shayya |
Instructor
Contact Information
|
GENERAL
COURSE DESCRIPTION:
AGSC
137 involves the application of procedures and techniques for collecting,
analyzing, and interpreting agricultural
data. The course encompasses an introduction to statistical methods using examples and applications to which
students can easily
relate. The course also focuses on teaching students basic
statistical analysis using the MS Excel spreadsheet program and
other pertinent computer tools. Students enrolled in AGSC 137,
which is part of the laptop curriculum, will be introduced to these
important concepts through lectures and exercises that they may
complete on their laptops. Emphasis will be placed on
providing the student with problem-solving skills and the ability to
interpret the results of basic agricultural statistical analysis.
Following
a brief introduction to statistics and statistical inference,
students enrolled in AGSC 137 are introduced to common measures of
central tendency and dispersion used in summarizing agricultural
data followed by an introduction to the main concepts of probability
and probability distributions and their potential applications in
agricultural sciences. Additional topics to be covered include
correlation analysis as well as simple and multiple linear regression.
EXPECTED
COURSE
OUTCOMES:
At the
successful completion of AGSC 137, the student is expected to have:
-
Developed a basic understanding of statistical
methods, probability, correlation analysis, and linear regression
as related to agricultural science.
-
Developed an appreciation of the types of problems
in agriculture that can be analyzed statistically.
-
Been acquainted with the use of computer technology in
interpreting research data.
-
Developed the basic skills
for using the laptop in his/her
courses.
OFFICE
HOURS:
The instructor
has the following designated office hours per week:
-
Mondays:
1:00 to 1:50 p.m.
-
Tuesdays:
9:00 to 9:50 a.m.
-
Wednesdays:
10:00 to 10:50 a.m.
-
Thursdays:
10:00 a.m. to 11:50 a.m.
If necessary, students are also encouraged to make appointments to see
the instructor at other times. Students with disabilities who
require accommodations to fully-participate in the course activities
are requested to contact the instructor within the first two weeks
of the semester.
CONTACT
HOURS AND CLASS SCHEDULE:
AGSC 137 is a
two-credit hour course. It includes two contact hours per week for 15
weeks. Only one section of the course is being offered during the 2008
Spring semester. The schedule of the offered section is as follows:
- AGSC 137
- Section 2: Meets on Mondays (8:00 to 9:50 p.m.) in Room 102, Marshall
Hall.
TEXTBOOK(S):
Davis,
B. 2000. Introduction to Agricultural Statistics. Delmar,
Albany, New York.
Shayya, W.H. 2008.
Using MS Excel 2007 to Analyze Data: An Introductory
Tutorial (on-line tutorial).
Shayya, W.H. 2003.
Using MS Excel 2003 to Analyze Data: An Introductory
Tutorial (on-line tutorial).
CLASS
POLICIES:
-
Attendance:
First and foremost, students must always plan to be in class on time. Given the nature of the course, students are
also required to attend
all classes. Attendance will be taken during each class session
and appropriate action will be taken when any given students has more than
3 unexcused absences during the semester. Very few or no
absences will be considered during the grading process when the
student is close to receiving the next higher letter grade. No
make-up examination will be given without a written medical
excuse, family emergency, or prior permission from the instructor.
Students are responsible for all materials covered in the class
whether assigned or presented orally during the lectures.
-
Student Behavior:
As students in a technical program are preparing for a professional career, all students are expected to conduct themselves as professionals (in both manner and dress).Good
behavior in the classroom is expected from all students. Students who
engage in unacceptable or disruptive behavior will be asked to leave the
class.
-
Eating, drinking, or the consumption of any tobacco products is prohibited in the classroom situation (lecture hall, classroom, laboratory, or field). Doing so may result in the student's dismissal from that class period and will count as an unexcused absence.
-
Cell phones and pagers must be turned off during instruction time. Use of or disruption of class by these devices will result in the student's dismissal from that class period and will count as an unexcused absence.
Laptop computers may not be used during the lecture.
-
Assignments:
This course will include at least eight homework assignments of equal
weights. At the end of the semester, the assignment with the lowest grade for
each student will be dropped. Class assignments will account for 20% of the
final grade. Therefore, it is important that students complete those
assignments accurately, neatly, and on time. Assignments received past the due
date will be devalued 5% for each day that the item is late. No class
assignment of any student will be graded (for credit) once the same assignment
is corrected and returned to the class. A student missing an assignment will
receive a grade of zero on that assignment.
-
Examinations:
There will be two class examinations and a comprehensive final in
AGSC 137. Class examinations will cover class material,
homework assignments, and assigned readings.
-
Honesty Policy and Discipline (Due Process):
Honesty and integrity are major elements in professional behavior and are expected of each student. Any assignment (including those in electronic media) submitted by a student must be of the student's original authorship. Representation of another's work as the student’s own shall constitute plagiarism. Cheating, in any form, is an unacceptable behavior within all College courses. Students having academic problems should consult with their academic advisor or a college counselor. Instances of cheating will be dealt with in accordance to College policy. Standards of academic honesty and due process procedures for Morrisville State College are located in the Rules, Regulations, and Expectations section of the Student Handbook.
-
Safety Guidelines:
Certain class assignments may require the student to be absent from the professor's immediate supervision. Whether the student is under immediate supervision or not, safe conduct and safe use of equipment shall be the ultimate rule. Failure to comply with prudent safety practice and/or willful disregard for class participants and/or equipment may be cause for immediate dismissal from that particular class session by the professor(s). Subsequent similar activity may be cause for dismissal from the course by the Dean.
-
Things
to remember: The material covered in AGSC 137 will require a consistent
effort from each student (understanding earlier lectures will be crucial to
grasping concepts presented in subsequent lectures). Each student should plan to spend at least two
hours per week for every lecture convened in class. Students are also urged to spend the time in
solving problems and completing the required homework assignments
on time (and independently). Solving additional problems
from the text and revisiting the problems solved in the class will
be very helpful. Completing assignments well before the due
date will give the student a chance to ask questions should he/she
encounter problems. Students also should remember to ask
questions of the instructor when they face difficulties, whether
inside or outside the classroom. The instructor has an
open-door policy and welcomes the opportunity to visit with
students whenever needed.
GRADING/EVALUATION
OF STUDENT:
Evaluation is a shared responsibility between the teacher and the student. The purpose of the evaluation is to demonstrate how well the professor has taught and the student has learned specific course materials, the principles, concepts and terms relevant to the covered topics, and to determine the students' ability to apply that knowledge to specific situations.
The breakdown of grading
in this course will be as follows:
-
Class
Participation, Attendance, Work Ethic ==> 5% of final grade
-
Homework
Assignments ==> 20% of final grade
-
First
Examination (during the second lecture of the 5th week) ==> 20% of final grade
-
Second
Examination (during the two lectures of the 11th week) ==> 20% of final grade
-
Final
Examination (comprehensive) ==> 35% of final grade
The
distribution of grades in this course will be based on the A-F
College grading scheme. The letter grades correspond to the
following percentage scale: A (90-100%), A- (87-89.9%), B+
(83-86.9%), B (80-82.9%), B- (77-79.9%), C+ (73-76.9%), C
(70-72.9%), C- (67-69.9%), D+ (63-66.9%), D (60-62.9%), and F
(<60%).
OUTLINE
OF TOPICS:
|
Lecture
(Week)
|
Date
|
Lecture
Topic*
|
Textbook/On-line
Resources |
Homework
Assignment |
|
1 (1) |
Jan. 21 |
- MLK Holiday (no
classes) |
|
|
|
2 (1) |
Jan. 21 |
- MLK Holiday (no
classes) |
|
|
|
3 (2) |
Jan. 28 |
- Introduction to AGSC137 |
|
|
|
4 (2) |
Jan. 28 |
- Introduction to agricultural statistics
- Variables and
summation |
Chapter 1 (pages 1-7) |
#1, Problems 1, 2, and 3 on page 8 |
|
5 (3) |
Feb.
4 |
- Different forms of presenting data |
Chapter 2 (pages 9-12) |
|
|
6 (3) |
Feb.
4 |
- Different forms of presenting data (continued) |
Chapter 2 (pages 12-18) |
|
|
7 (4) |
Feb. 11 |
- Measuring central tendency of ungrouped data |
Chapter 2 (pages 18-24) |
|
|
8 (4) |
Feb. 11 |
- Measures of dispersion of ungrouped data
- Data properties of importance
- First exam study guide |
Chapter 2 (pages 24-30)
Handouts |
#2, Problems 1a,b,c,d,e and 4a,b,c on page 31 |
|
9 (5) |
Feb. 18 |
- Introduction to MS Excel |
Excel
On-line Introductory Tutorial |
|
|
10 (5) |
Feb. 18 |
Progress
Examination I |
| 11
(6) |
Feb. 25 |
- Exam review
-
Introduction to summarizing data using MS Excel |
On-Line
Handout on Common Excel Functions |
|
| 12
(6) |
Feb. 25 |
-
Hands-on exercise 1 on summarizing ungrouped data |
Handouts |
|
| 13
(7) |
Mar. 3 |
-
Hands-on exercise 2 on summarizing ungrouped data |
Handouts |
|
| 14
(7) |
Mar.
3 |
-
Hands-on exercise 2 on summarizing ungrouped data |
Handouts |
#3,
Problem set on summarizing data using MS Excel |
| 15
(8) |
Mar. 10 |
-
Measuring central tendency of grouped data |
Chapter
2 (pages 20, 22-23) |
|
| 16
(8) |
Mar. 10 |
- Measures of dispersion of grouped data |
Chapter 2 (pages 25-28) |
|
| Week
9 - Spring Break - No classes |
| 17
(10) |
Mar. 24 |
-
Analysis of grouped data using MS Excel |
On-Line
Handout on Common Excel Functions |
|
| 18
(10) |
Mar. 24 |
- Hands-on exercise on summarizing grouped
data
- Second exam review |
Handouts |
#4,
Problem 5 on page 32 |
|
19 (11) |
Mar. 31 |
Progress
Examination II |
|
20
(11) |
Mar. 31 |
| 21
(12) |
Apr.
7 |
- Exam review
- Data
sets
- Set
operations |
Chapter 3 (pages 39-42) |
|
| 22
(12) |
Apr.
7 |
-
Probability
-
Rules of probability |
Chapter 3 (pages 36-45) |
#5,
Problems 1, 2, and 4 on page 46 |
| 23
(13) |
Apr. 14 |
-
Normal probability distribution |
Chapter
4 (pages 53-59) |
|
| 24
(13) |
Apr. 14 |
-
Probability distribution functions in MS Excel |
Handouts |
#6, Problems 8 and 11 on page 61 |
| 25
(14) |
Apr. 21 |
-
Correlation analysis
-
Simple linear regression |
Chapter
11 (pages 157-164) |
|
| 26
(14) |
Apr. 21 |
-
Using MS Excel to solve correlation and linear regression problems |
On-line
Handout on Correlation and Regression
Analysis Using Excel |
|
| 27
(15) |
Apr.
28 |
- Multiple linear regression |
Handouts |
|
| 28
(15) |
Apr.
28 |
-
Using MS Excel to solve multiple linear regression problems |
Handouts |
#7,
Problem set on correlation analysis & linear regression |
| 29
(16) |
May
5 |
-
Setting-up and using the data analysis tool in MS Excel |
|
|
| 30
(16) |
May
5 |
- Wrap-up lecture
-
Final exam study guide |
Handouts |
|
|
Final
Examination
(comprehensive) |
*The
topics listed in the table above are tentative and may be subject to
change during the semester. |