|
3/16 Project (Due before class on 3/30)
Using this file (download here), complete the following and email to Mr. Marvin when complete.
- Save file as FIRSTNAME_census.xls
- On a separate tab called "Calculations"
- Calculate the total number of people with income.
- Using MAX, determine how many people are in the income level that has the most people in it in the "over 75" group.
- Create a row showing how many people would be in each income level in the Western Region if the US was 1.5 times as large.
Create line graph that compares the total number of people in each category vs the total number of people in each category that live in the Northeast.
- This graph will have two lines on it.
- The X axis should be labeled with the income levels.
- The Y axis should be the number of people (in thousands).
- Do not include the $100,000+ category in your graph.
Email the completed project called FIRSTNAME_census.xls to Mr. Marvin before 3/30. The subject of the email should be "XLS Project" (you'll lose points if it's not!).This project is worth a test grade.
3/9 Class work
Complete exercises on pages 311-326.
The files that you need can be downloaded here.
If you miss class, you will need to make up this work on your own time.
3/2 Class work
Complete exercises on pages 282-297.
The files that you need can be downloaded here.
2/23 Class work
Complete exercises on pages 228 - 240 and 272 - 276.
The files that you need can be downloaded here.
Download the files that you need and move them to the desktop.
2/9 Class work
Download .zip file from here and move the file to your desktop. It is called PPT_Lesson02.zip.
Once the file is on your Desktop, right click on the file and select "Extract" and extract the files to your desktop.
Use these files to complete the Exercises in your textbook from page 548 - 571. Switch with your partner each time you turn the page.
When instructed to print, print presentation with 6 slides per page.
|
Academics 