CISS 1280 - Microsoft Excel Advanced

Academic Division: Business, Industry and Technology
Academic Discipline: Computer Information Systems

Assistant Dean: Dr. Vincent Palombo

2 Credit(s)
This second level course covers expert Excel features, including formatting with advanced techniques, working with templates and workbooks, working with lists, using analysis tools, managing and auditing worksheets, collaborating with workgroups, and using advanced format functions. UG

2 Lab Hour(s)

1 Lecture Hour(s);

Required Prerequisite Course(s): Take CISS 1220

College Wide Outcomes

College-Wide Learning Outcomes	Assessments - - How it is met & When it is met
Communication – Written
Communication – Speech
Intercultural Knowledge and Competence
Critical Thinking
Information Literacy
Quantitative Literacy

Student Learning Outcomes for Course

Outcomes	Assessments – How it is met & When it is met
1. Analyze large amounts of data using filters, PivotTables, PivotCharts, and Excel’s Business Analysis Tools: Data Model, PowerPivot and PowerView.	Skill exam – hands-on practice to master skills Problem-based project – appropriate application of skills to solve a problem Weeks 1-4
2. Evaluate business solutions using Moving Average, Break-Even Point, Solver, Scenarios, and Complex formulas.	Skill exam – hands-on practice to master skills Problem-based project – appropriate application of skills to solve a problem Weeks 4-6
3. Automate complex and repetitive tasks using Macros.	Skill exam – hands-on practice to master skills Problem-based project – appropriate application of skills to solve a problem Weeks 6-8
4. Manage external data using import, queries and database functions.	Skill exam – hands-on practice to master skills Problem-based project – appropriate application of skills to solve a problem Weeks 9-11
5. Collaborate with Others using Shared Workbooks and Cloud Storage.	Skill exam – hands-on practice to master skills Problem-based project – appropriate application of skills to solve a problem Weeks 12-15

Standard Grading Scale
93-100 A

90 - 92 A-

87- 89 B+

83 - 86 B

80 -82 B-

77- 79 C+

73 - 76 C

70 -72 C-

67- 69 D+

63 - 66 D

60 -62 D-

00- 59 F

Statement on Diversity
North Central State College believes that every student is a valued and equal member of the community.* Every student brings different experiences to the College, and all are important in enriching academic life and developing greater understanding and appreciation of one another. Therefore, NC State College creates an inclusive culture in which students feel comfortable sharing their experiences. Discrimination and prejudice have no place on the campus, and the College takes any complaint in this regard seriously. Students encountering aspects of the instruction that result in barriers to their sense of being included and respected should contact the instructor, assistant dean, or dean without fear of reprisal.

*Inclusive of race, color, religion, gender, gender identity or expression, national origin (ancestry), military status (past, present or future), disability, age (40 years or older), status as a parent during pregnancy and immediately after the birth of a child, status as a parent of a young child, status as a foster parent, genetic information, or sexual orientation,

Standard NCSC Course Policies
Important information regarding College Procedures and Policies can be found on the syllabus supplement located at this link