7th TA Notes, CALS 85, Fall 2011, October 13
For labs October 17-21, Second Excel Lab 6,
BEFORE LAB:
•
Log in to Blackboard and check & reply to discussion postings. Let Dr. L know of good ones
•
Meet with your lab partner to go over the lab
•
Record grades and bring to lab graded homework assignments to
hand back
•
Notify Dr. L of any students performing at a C or lower
grade, for mid-term warnings
THE LAB:
1.
Take Attendance. Explain it is too late now to hand
in lab 2 (print out of folders & Notepad).
2.
Hand back graded Resumes.
3.
Make sure students get out paper and pen and take notes.
4.
LAB:
Things to
cover in Excel:
X-Y
Scatter Plot data:
Relationship between Area and Population of Selected
Countries, 2010
Data Source: Population Reference Bureau (2011)
Country
Area, Sq.
Km. 2010 Pop in Millions
USA
9,372,000
310
China
9,596,000
1,338
India
3,287,000
1,189
Australia
7,686,000
22
Japan
378,000
127
Indonesia
1,919,000
236
(Click on:
RelationshipCountryAreaPopulation2011.xls)
Have
everyone do a bar chart (column chart) of
Area. Then have them do sorting (highlight everything, RANGE,
SORT)
<remember to uncheck the box for "My data has Headers> to
arrange the data in
descending order.
See
if students can figure the formula for density—people/sq km.
Make a
fourth column of population/area using a multiplying and dividing
formula:
=C4/B4*1000000
Then
have everyone make an X-Y scatterplot comparing population to the area
and look for a line of best fit. Explain strong, weak, positive, negative
and no
relationship. Go to Chart Tools, Layout Tab, Trendline, chose Linear to draw
line of
best fit in graph.
Label and
dress up both the spreadsheet and the graph (Titles, Data Source, Axis Labels, Units Clear).
Copy
the spreadsheet into Word by highlighting and pasting into Word. (to
align table, go to Table, Cell Height and Width, Center alignment)
Copy the
graph (highlight the graph, copy to the windows clipboard).
Show where
the link to do the Population Pyramid spreadsheet is.
MS
POWERPOINT
Show menu
driven PowerPoint program to create a title page in PORTRAIT
ORIENTATION (Design Tab, Slide Orientation).
Read
assignment for next week. PowerPoint Cover Page (in
portrait). Copy
spreadsheets and graphs from Excel to Word. Hand in new
spreadsheet
(from real data), appropriate graph, two paragraph discussion,
population spreadsheet, population pyramid graph and two paragraph
discussion, include copy of original data source.
6.
Show link to facsimile of lab 6 as example.
7.
Encourage students to construct the China 2000 population
pyramid first before they try their own country choice.
Notice the instructions for BOTH Excel 2003, 2007, and 2010! In
http://www.uvm.edu/~agri99/spring2004/Population_Pyramids_in_Excel.html. If time walk through this in lab.
8.
Read assignment out loud to the students.
9.
Ask students “How many understand the assignment?
Any Questions?”
10.
Make sure students know they may contact you and meet with
you outside of lab if necessary to get extra help with the lab.
11.
Collect Name Tents at end of lab (if still using).
AFTER THE
LAB:
•
Record absences and comments on spreadsheet template
•
Meet with your TA partner and record grades in spreadsheet.
•
Both TAs should save the spreadsheet in three places: on your
PC, data stick, and upload to your zoo accounts.
•
Contact Dr. L if students are missing or having trouble
with Blackboard (in wrong lab, can’t log in, etc.)
Contact Dr. L if students lab grades are C or lower!
LAST
Thing: Returning TAs in Spring 2012:
CALS 002 Labs (Dr. L)
CALS 183 Labs (Dr. Patterson)
CALS 85 Labs (Dr. L