COURSE SYLLABUS

Info. Systems	CSA 135		Excel
Department	Course No.		Course Title
3 hrs	1.5		1.5
Credit Hrs.	# lecture hrs./week		# lab hrs./week
Prepared by	Jean Insinga			January 15, 2009
	Faculty Member			Date
Course prerequisites:		None unless placement tests indicate otherwise.
Course Location (building/room number):			Online
Meeting time (days/hours):		Online

Course Description:

Microsoft Excel for Windows will be utilized to design, organize, and manipulate business applications. Students will use introductory through advanced features working with worksheets, databases and charts.  

Scope of Course:

Microsoft Excel offers a comprehensive study of spreadsheet concepts and skills. This course begins with the basics of Microsoft Excel creating a basic worksheet using formulas and formatting techniques.  The students will expand their skill set using worksheet functions, charts and graphics, Excel lists, multiple worksheets and workbooks, editing and web tools, data tables and scenario management and solver.

The course provides the students with hands-on tutorials and application cases for each topic.  The final project integrates all Excel functions and tools.

Program/Discipline Learning Outcomes Contained in Course:

The goal of the Business Division is to incorporate the following learning outcomes into each course:

§ Written and oral communication skills

§ Critical thinking, problem solving, and analytical skills

§ Interpersonal skills and awareness

§ Teamwork, team-building, and project focus

§ Knowledge of ethical and legal business behavior

§ Awareness and respect for other perspectives

§ Global awareness and diversity

§ Flexibility and adaptive to change

§ Personal productivity and organizational skills

§ Ability to understand your customer

§ Understand process management

Importance of Course in Program/Discipline:

CSA 135 – Microsoft Excel is a very important component of the Business Division. In today’s highly competitive and technologically advanced society, good spreadsheet computer skills are an imperative. Students in CSA 135 are able to acquire and/or refine their worksheet skills. The ability to plan, design and create worksheets using functions and tools allows the student to analyze and synthesize business information.  The reports and data worksheets will enhance productivity in a company and will serve the students in both academic and professional careers. Knowledge of the Microsoft Excel is highly desirable in today’s workplace. The course gives a very practical technical foundation and allows the student to learn and apply the advanced features to business data.

Learning Outcomes:

The goal of CSA 135 is to provide each student with a comprehensive course in Microsoft Excel. The following list describes the learning outcomes that support this overall goal:

§ Understand the basics of an Excel worksheet.

§ Understand and apply formulas and functions.

§ Develop professional –looking worksheets using formatting tools.

§ Chart and graph worksheet data.

§ Work with Excel Lists.

§ Work with multiple worksheets and workbooks.

§ Apply Excel’s editing and web tools.

§ Create data tables and Scenario Management.

§ Understand and use Solver for complex problems.

§ Integrate all skills in completing a comprehensive case study.

Textbooks and other required readings/computer software/materials/library reserve room:

Microsoft Excel 2007 Comprehensive

June Jamrich Parsons, Dan Oja, Roy Ageloff, and Patrick Carey

Course Technology – Thomson Learning

Office Location (building/room number):	Wheaton Hall Room 313	Office Hours:	24/7 Monday –Thursday ONLINE M 9:00AM – 11:30AM (On Campus)
Office Telephone:		Office e-mail:
	860-343-5763		jean.insinga@snet.net

Attendance Policy:

Students are Expected to participate in an online course through assignments, projects, Exams and chat sessions.  An online course allows the student to establish a flexible schedule to do work; however, chat sessions will be scheduled times.  Discussion Postings will be 5% of your final grade.  Open chats are strongly recommended to interact with other students and clarify any questions or problems that are causing difficulty in your understanding of the course assignments.

Evaluation (Exams, term papers, projects, etc., and percentages towards final grades):

The final grade will be determined by two Exams and hands-on computer applications projects, and will be affected by course participation, conduct, and attendance.

Midterm Exam                                                           20%

Software Projects                                                       40%

Practice Test                                                               10%

Chat Sessions / Discussions                                        5%

Final Exam Project                                                    25%

There are no make-up Exams given unless arrangements have been made prior to the Exam. 

Unit Outlines/Unit Objectives/Expected Outcomes/Assessment Measures:

Each unit will cover specific topics from the textbook as well as a software product. Each student is Expected to read the assigned chapters, do all homework assignments, and complete all hands-on lab assignments. The labs, homework assignments, and test scores will be used to calculate the student’s overall grade.  An assignment sheet lists projects, quizzes and Exams.  All will be posted on the Calendar as well.

Class	Reading Assignments from Text Book	Assignment
1	Managing Your Files Pages FM1-FM24 (For Review) Using Common Features of Microsoft Office 2007 Pages OFF  2- OFF 32 (for Reference)	Course Survey
2	Tutorial 1-Getting Started with Excel Session 1.1Introducing Excel Pages EX 2 –EX 21	Quick Check Session 1.1 Page EX 21
3	Session 1.2 Working with Cells and Ranges.. Pages EX 22 – EX 46	Quick Check Session 1.2 Page EX 46 Review Assignments 1-22  Page EX 48 –EX 49
4		Case Problem 1 Altac Bicycles Page EX 49
5	Tutorial 2-Formatting a Workbook Session 2.1 Formatting Workbooks Pages EX 58 –EX 80	Quick Check Session 2.1 Page EX 80
6	Session 2.2 Formatting the Monthly Sales Worksheet Pages EX 80 – EX 100	Review Assignments 1-20 Page EX 102 - EX 104 Case Problem 3 FrostiWear Page EX 104- EX 106
7	Tutorial 3-Working with Formulas and Functions Session 3.1 Understanding Cell References When Copying Formulas Pages EX 114 – EX 130	Project #1 Assigned Quick Check Session 3.1 Page EX 130
8	Session 3.2 Working with AutoFill Pages EX 131 – EX 150	Quick Check 3.2 Page EX 151 Review Assignments 1-15 Page EX 152 – EX 153 Case Problem 1 Chemistry 303  Page EX 153 – EX 154
9	Tutorial 4 Working with Charts and Graphics Session 4.1 Creating Charts Pages EX 162  - EX 186	Quick Check 4.1 Page EX 187
10	Session 4.2 Creating a Line Chart Pages EX 187 – EX 205	Quick Check 4.2 Page EX 205 Review Assignments 1-18 Pages EX 207 – EX 208 Case Problem 2 Midwest Tornado Institute Page EX 209 - EX 211 Project #1 Due Project #2 Assigned
11	Tutorial 5 Working with Excel Tables, PivotTables, and PivotCharts Session 5.1 Planning a Structured Range of Data Pages EX 218 – EX 232	Quick Check 5.1 Page EX 232 – EX 233
12	Session 5.2 Filtering Data Pages EX 233 – EX 246	Quick Check 5.2 Page EX 246 Review Assignments 1-16 Page EX 272
13	Session 5.3 Analyzing Data with PivotTables Pages EX 246 – EX 270	Quick Check 5.3 Page EX 270 Case  Problem 1 Hewart Zoo Page EX 273- EX 274 Project #3 Assigned
14	Tutorial 6 Managing Multiple Worksheets and Workbooks Session 6.1 Using Multiple Worksheets Pages EX 282 – EX 295	Quick Check 6.1 EX 295 Project #2 Due
15	MIDTERM EXAM
16	Session 6.2 Linking Workbooks Pages EX 295 –EX 310	Quick Check 6.2 page EX 310 Review Assignment 1-15 Page EX 326 – EX 327
17	Session 6.3 Creating a Hyperlink Pages EX 310 – EX 324	Quick Check 6.3 Page EX 325 Case Problem 2 Ute Auto Sales & Service  Page EX 328 – EX 329 Project #4 Assigned
18	Tutorial 7 Using Advanced Functions, Conditional Formatting, and Filtering Session 7.1 Working with Logical Functions Pages EX 338 – EX 352	Quick Check 7.1 Page EX 353
19	Session 7.2 Using Lookup Tables and Functions Pages EX 353 –EX 372	Quick Check 7.2 Page EX 372 – EX 373 Review Assignment 1-13 Page EX 384 Project #3 Due
20	Session 7.3 Using Advanced Filtering Pages EX 373 – EX 382	Quick Check 7.3 Page EX 382 – EX 383 Case Problem 2 Town of Baltic Administrative Office Page EX 386 –EX 387
21	Tutorial 8 Developing an Excel Application Session 8.1 Planning an Excel Application Pages EX 394 – EX 407	Quick Check 8.1 Page EX 407
22	Session 8.2 Validating Data Entry Pages EX 407 –EX 420	Quick Check 8.2 page EX 420
23	Session 8.3 Working With Macros Pages EX 420 – EX 442	Quick Check 8.3 Page EX 442 Review Assignment 1-16 Page EX 443 – EX 444 Case Problem 1 Seattle Popcorn Page EX 446 – EX 447 Project #4 Due Project 5 Assigned
24	Tutorial 9 Developing a Financial Analysis Session 9.1 Evaluating Investment Options Pages EX 458 – EX 475	Quick Check 9.1 Page EX 475 – EX 476
25	Session 9.2 Projecting Future Income and Expenses Pages EX 476 – EX 489	Quick Check 9.2 Page EX 489 Review Assignment 1-11 Page EX 508 – EX 509
26	Session 9.3 Working with the Payback Period Pages EX 489 – EX 506	Quick Check 9.3 Page EX 507 Case Problem 3 Eason Financial Services Page EX 512 – EX 513
27	Tutorial 10 Performing What-If Analyses Session 10.1 Understanding Cost-Volume-Profit Relationships Pages EX 518 – EX 537	Quick Check 10.1 Page EX 537 Project #5 Due
28	Session 10.2 Using Scenario Manager Page EX 538 – EX 549 Session 10.3 Understanding Price Elasticity of Demand Page EX 549 –EX 564	Quick Check 10.2 Page EX 549 Quick Check 10.3 Page EX 565 Review Assignment 1-16 Page EX 566 – EX 567 Case Problem 3 Fairway Convention Center  Page EX 570 - EX 577 Final Exam Project Assigned
29	Tutorial 11 Connecting to External Data Session 11.1 Examining Data Sources Pages EX 576 – EX 591	Quick Check 11.1 Page EX 591 – EX 592
30	Session 11.2 Introducing Databases and Queries Page EX 592 – EX 611	Quick Check 11.2 Page EX 611 Review Assignment 1-21 Page EX 630– EX 631
31	Session 11. 3 Creating a Web Query Page EX 612 – EX 628	Quick Check 11.3 Page EX 629 Case Problem 2 Kate’s Confections  Page EX 632 - EX 634
32	FINAL EXAM PROJECT

ADA Accommodations Statement

Students with physical or learning disabilities who may require accommodations are encouraged to contact the Counseling Office.  After disclosing the nature of the disability, students are urged to discuss their needs with individual instructors.  This should be done at the beginning of each semester.  Instructors, in conjunction with appropriate college officials, will provide assistance and/or accommodations only to those students who have completed this process.

Academic Ethics and Classroom Behavior

At Middlesex Community College we expect the highest standards of academic honesty.  Academic dishonesty is prohibited in accordance with the Board of Trustees’ Proscribed Conduct Policy in Section 5.2.1 of the Board of Trustees’ Policy Manual.  This policy prohibits cheating on examinations, unauthorized collaboration on assignments, unauthorized access to examinations or course materials, plagiarism, and other proscribed activities.  Plagiarism is defined as the use of another’s idea(s) or phrase(s) and representing that/those idea(s) as your own, either intentionally or unintentionally.

Use of Computing Resources

All resources and facilities of the Data Processing Labs, including the computer classroom sites, are to be used solely for the legitimate and authorized academic and administrative purposes. Any unauthorized or illegitimate use of the computer systems, resources, and/or facilities will be subject to appropriate disciplinary action, including but not subject to criminal prosecution in accordance with Section 53a-250, et seq., of the General Statutes.