Complete problems in the Excel Homework Spreadsheet, as assigned in class. The problems in the spreadsheet build on predecessor problems. WHERE A NUMBER IN A CELL IS BASED ON A PREVIOUS CALCULATION (OR IS GIVEN), LINK ANY CELL USING THAT NUMBER TO THE CELL WHERE IT INITIALLY APPEARS, so that any changes in predecessor problems are automatically incorporated into successor problems. At the end of the semester, you will plug new data into your spreadsheet and see if it provides a proper solution. Links to pdfs of the SOLUTIONS are give at the bottom of this page. Your grade will be based on how well your spreadsheet works at the end of the semester. However, don't wait until the end to work on it. First, it's too much work to delay starting it. Second, completing this will help you prepare for exams.

You will write a Solid Waste engineering report describing the existing solid waste management system and two alternative management systems you design for a hypothetical town. You will find needed data and make necessary calculations as part of HW 2.

• As you complete individual assignments for HW2 (as they are assigned in class), you will also turn in appropriate sections of the Engineering Report. These should be submitted as short memos, with tables, figures, and sample calculations given in an appendix (which can be HW 2 assignments).
• On the day of the FINAL, you'll turn in a single report based on your previous work, adding executive summary, introduction, and conclusion sections. Tables and figures should be incorporated into the body of the report. Sample calculations should be included in an appendix. Of course, you will have improved your sections (based on my comments) before turning in the final version.

Your report will be judged on content (do you describe the solid waste management system and its alternatives), analysis (do you evaluate the alternatives), coherence (does the report hold together), clarity (is the language clear), and grammar (is the language correct).

Read the articles "The State of Garbage in America" and "The State of Garbage in America_Data and Methodology Assessment". In particular, carefully inspect each table and figure. Be prepared to discuss the articles in class.

Read 4 articles in Biocycle magazine (on different topics) and write a paragraph review (~300 words) of each article. Head each review with the article citation (not included in the 300 word count). See the Student Resources page for help in referencing. Turn in two copies of each review, each attached to a copy of the original article. Be prepared to discuss in class by Feb 9. Your review will be judged on content (do you summarize the important parts of the article), coherence (does the review hold together), clarity (is the language clear), and grammar (is the language correct).

Find articles by going to the Campbell Library search page (www.rowan.edu/open/library/, then select the "Library Resources" link). Enter "Biocycle" in the "Find this:" box. Hit the search button and you'll see the search results. Select the "Full text available from ABI/INFORM Global: 01/01/1992 to present" link to go to the ProQuest website where you can view many issues of Biocycle. Stick with issues from the past year or two, find interesting articles, and print them out. Pick articles on four different topics!

The graduate student(s) will  prepare and deliver a 75-minute powerpoint-based lecture/discussion session on Legislation and Regulations pertaining to Solid Waste. Start on this immediately by reading the chapter in the text and searching the Internet (e.g., NJDEP and USEPA). I will give you additional readings that will help. Your primary focus is on the Resource Conservation and Recovery Act. But, you should also cover the Pollution Prevention Act, environmental law fundamentals, enforcement, and New Jersey solid waste law.