Excel Assignment Schedule

IS 340

Spring 2017

All bulleted assignments listed below are required and must be submitted as designated by your instructor.

Problem Set 1 – Chapter 1

Section 1: Meeting Date: January 24, 2017; Due date: February 7, 2017

Sections 2 & 3: Meeting Date: January 25, 2017; Due date: February 8, 2017

Complete all reading and work on pp. 68-138

• Guest House Rental Rates, p. 145; show the questions & your answers in your hardcopy.
• Real Estate Sales Report, p. 146

Extra Credit – 20 points – Net Proceeds from House Sale, p. 148; show the Comments in your hardcopy.

Problem Set 2 – Chapter 2

Section 1: Meeting Date: February 7, 2017; Due date: February 21, 2017

Sections 2 & 3: Meeting Date: February 8, 2017; Due date: February 22, 2017

Complete all reading and work on pp. 152-189

• Metropolitan Zoo Gift Shop Weekly Payroll, p. 193; show the Comments/Recommendations in the hardcopy.

• Auto Loan Calculator, p. 194 – NOTE: the title of this problem (Mortgage Calculator) in the text is incorrect; it should be Auto Loan Calculator. The problem is a “From Scratch” problem requiring you to create the file from the directions, not a file download. However, I have placed a starting file for this problem on the course Excel Homework Files webpage – using this file makes the problem much easier.

Extra Credit – 20 points – Park City Condo Rental, p. 196

Problem Set 3 – Chapter 3

Section 1: Meeting Date: February 21, 2017; Due date: March 7, 2017

Sections 2 & 3: Meeting Date: February 22, 2017; Due date: March 8, 2017

Complete all reading and work on pp. 198-252

• Airport Passenger Counts, p. 257
• Grade Analysis, p. 258

Extra Credit – 20 points – Harper County Houses Sold, p. 260

Problem Set 4 – Chapter 4

Section 1: Meeting Date: (none); Due date: March 28, 2017

Sections 2 & 3: Meeting Date: (none); Due date: March 29, 2017

Complete all reading and work on pp. 262-319

• Crafton’s Pet Supplies, p. 324
• Artwork, p. 324-325; be sure to print Q&A from item “h” with the rest of the assignment.

Extra Credit – 20 points – Dairy Farm, p. 326

Problem Set 5 – Chapter 5

Section 1: Meeting Date: (none); Due date: April 11, 2017

Sections 2 & 3: Meeting Date: (none); Due date: April 12, 2017

Complete all reading and work on pp. 328-383

• Mountain View Realty, p. 389-390; be sure to print Q&A from item “f” with the rest of the assignment
• Fiesta Collection, p. 390-391

Extra Credit – 20 points – Innovative Game Studio, p. 392

Problem Set 6 – Chapter 7

Section 1: Meeting Date: (none); Due date: April 25, 2017

Sections 2 & 3: Meeting Date: (none); Due date: April 26, 2017

Complete all reading and work on pp. 454-495

• West Coast University Admissions Office, p. 502-503
• Artwork Database, p. 503

Extra Credit – 100 points – Capstone Exercise, p. 393-394 (in Chapter 5) – NOTE: Only Students who have completed all previous extra credit assignments (Problem Sets 1-6) are eligible to complete this extra-credit. Previous extra-credit assignments need not be perfect, but they must have been attempted and submitted with a Reasonable Expectation of Success (see Syllabus, minimum requirements).