Aug 15, 2022  
2022-2023 College Catalog and Student Handbook 
    
2022-2023 College Catalog and Student Handbook

CISS1280

Add to Portfolio (opens a new window)

CISS 1280 - Microsoft Excel Advanced


Academic Division:

Business, Industry and Technology


Academic Discipline:

Computer Information Systems


Assistant Dean: Vincent Palombo PhD
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. Semesters available: Day - Sp Evening - Sp 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

 

 


TEXTBOOK INFORMATION
Textbook: 



Add to Portfolio (opens a new window)