Course: CIS215 ONLN. Decision Making Using Spreadsheets                                    MCCC        Credits: 3

This course provides additional experience using spreadsheet software as a productive decision-making tool. Topics covered will include macro programming, advanced printing features, database management, internal functions, and graphing.

 

Prerequisites: CIS110 or CIS101 or CIS155 or equivalent experience.

Professor: Dr. Moulton                                                    Semester: Fall, 2009

Class Hours:  

T & R 

9:05 AM - 11:00 AM 

CIS215 IC. Decision Making Using Spreadsheets

  (9:05 - 10:00 AM Lecture in ATC224, 10:05 - 11:00 AM Lab in ATC224)

T & R 

11:15 AM - 1:10 PM 

CIS111 JC. Comp Science I: Programming/Concepts

  (11:15 - 12:10 PM Lecture in ATC212, 12:15 - 1:10 PM Lab in ATC212)

online

 anytime

CIS111B ONLN. Comp Science II: Object-Oriented Programming 

online

 anytime

 CIS215 ONLN. Decision Making Using Spreadsheets

 

Office Hours and Information Sources:  

M 

 by appointment

T

 8:30 - 9:00 AM  

W  2:30 - 4:30 PM

R

 8:30 - 9:00 AM   

F  by appointment

 

Textbooks (sold as a single package with 4 components at the Central Campus MCCC bookstore for a reduced price--the CIS215 bundled ISBN  is 0538769254): 

Note: Be sure to purchase the textbook package including the Excel 2007 Casebook with AutoGrader (containing keycode needed for assignments).  There is a considerable cost reduction on the package versus buying the components separately.    You should be able to order the bundle at the MCCC Central Campus Bookstore or online at http://www.mc3central.bkstore.com/ 

 

 

Grading:
 

50%

Weekly Assignments including Case Problems, Tutorials, Projects, and Discussion Group

20%

Mid-Term Exam

30%

Final Exam 

 

Note: MCCC is now on a plus/minus grading system.  Your final grade will be reported as follows:

Grade Percentage Quality Points
 A  93 - 100  4.00
 A-  90 - 92  3.67
 B+  87 - 89  3.33
 B  84 - 86  3.00
 B-  80 - 83  2.67
 C+  77 -79  2.33
 C  70 - 76  2.00
 D  60 - 69  1.00
 F  < 60  0.00

 

Class Format:
This is an asynchronous class which will allow you flexibility within the weekly framework to study at times convenient for you.  Weekly lectures and assignments will be posted on the Course Documents board each Tuesday evening by midnight.  Weekly assignments will be due the following Tuesday evening by 11:59 PM in order to receive full credit.  The discussion group will be available to you 24/7 for the purpose of interacting with the class (posting questions, answers, helpful hints, etc.).  Private communication will be available through e-mail, phone, and/or office visits.  The only on-campus requirements will be the mid-term and final exams which can be scheduled at your convenience in the testing center on the Central Campus or the West Campus.

College Policies:


Student Academic Code of Ethics: In the pursuit of knowledge and scholarship, all members of the academic community at MCCC must maintain a constant commitment to academic integrity.  The College provides an environment that fosters critical thinking and judgment, and in order to safeguard the integrity of the institution, students are expected to follow the policies of the College and the faculty. To fulfill their part of that commitment, students must adhere to an academic code of ethics by refraining from participation in acts of academic dishonesty. By attending MCCC, students accept this Student Academic Code of Ethics and agree to the following:           

         Students must do all of their own work.

         Students must not cheat.

         Students must not help others to cheat.

Students who are unclear about the validity of an academic procedure they are about to undertake should ask their instructor for guidance beforehand. Violations of this code of ethics will result in sanctions, including possible dismissal from the College.  (See complete Code of Ethics in catalog, Student handbook or online at http://www.mc3.edu/policy/aa/ethics.htm)

Students with Disabilities Policy: Students with disabilities may be eligible for accommodations in this course.  Contact the Director of Services for Students with Disabilities in College Hall, at (215) 641-6575/6577 for more information.  At West Campus, contact the Director of Student Affairs, (610) 718-1839.

Veterans:  Student veterans may be eligible for benefits and services related to military service.  At Central Campus, contact the Military and Veterans Affairs Advisor in College Hall 122 or at 215-641-6581 to learn about education benefits and healthcare entitlements.  At the West Campus, contact Michael Ondo in South Hall 151 or at 610-718-1857 for the veterans resources.    http://www.mc3.edu/sa/vet/vet.htm

Student Code of Conduct/Civility: Montgomery County Community College is committed to providing a campus environment in which all students have an equal opportunity to learn, study, and grow as scholars and as citizens of the larger community. Students are expected to treat all members of the college community with dignity, respect, fairness, and civility and to behave in a responsible manner at all times both in and outside of the classroom.  (See complete Code of Conduct in Student Handbook or online at http://www.mc3.edu/policy/sa/conduct.htm)

Class cancellation policy (inclement weather--320: day/ 2320: evening)

 

Learning Goals: 

 

1.       Demonstrate the use of spreadsheets to increase business decision making ability. Spreadsheets will be developed to analyze investment decisions, project cash flows, prepare financial statements, and calculate loan costs. Additional projects will be individually assigned based on the interest of the student.

2.       Produce spreadsheet reports by utilizing the advanced printing features of the software.

3.       Apply advanced finance, math, date, string, logic, and statistic functions in a spreadsheet.

4.       Design and print graphs based on spreadsheet information.

5.       Program macro procedures which save time in developing a spreadsheet.

6.       Create customized menus.

7.       Apply techniques for creating and updating spreadsheets efficiently.

8.       Create a data base, query information, and print reports using database features within spreadsheets.

 

 

Course Outline (subject to modification):

Week (Dates) Topic
1 (9/2 - 9/8)

 Overview of Course & Environment

 

 Managing Your Files; Getting Started with Microsoft Office 2007

 T1. Getting Started with Excel

2 (9/9 - 9/15)  T2. Formatting a Workbook

 T3. Working with Formulas and Functions

3 (9/16 - 9/22)  T4. Working with Charts and Graphics
4 (9/23 - 9/29)  T5. Working with Excel Tables, PivotTables, and PivotCharts
5 (9/30 - 10/6)  T6. Managing Multiple Worksheets and Workbooks
6 (10/7 - 10/13)  T7. Using Advanced Functions, Conditional Formatting, and Filtering
7 (10/14 - 10/20)  T8. Developing an Excel Application
8 (10/21 - 10/27)  Review & Mid-Term Exam (by appointment : testing@mc3.edu or westtesting@mc3.edu)
9 (10/28 - 11/3)  T9. Developing a Financial Analysis
10 (11/4 - 11/10)  T10. Performing What-If Analyses
11 (11/11 - 11/17)  T11. Importing Data into Excel
12 (11/18 - 11/24)  T12. Expanding Excel with Visual Basic for Applications
13 (11/30 - 12/8)

 Work on Projects

 

 Selected Advanced Topics--

   A: Working with Text Functions and Creating Custom Formats

   B: Integrating Excel with Word

   C: Sharing Workbooks in a Group

   D: Customizing Excel

14 (12/9 - 12/14)  Review & Evaluation

 Finish Projects 

15 (12/12 - 12/19)  Final Exam (by appointment : testing@mc3.edu or westtesting@mc3.edu)


Back to Moulton Homepage