CISS 1220 - Microsoft Excel Academic Division: Business, Industry and Technology Academic Discipline: Computer Information Systems Assistant Dean: Dr. Vincent Palombo 2 Credit(s) This course is an introductory course in spreadsheets using Microsoft Excel for Windows. Through a series of hands-on exercises, the student will create, edit, format, and print worksheets. Topics include: creating, saving, retrieving, formatting, editing, printing, creating formulas, using functions, naming cells and ranges, creating tables, creating charts, defining range names, validating data, sorting and filtering data, maintaining file organization, and using templates. UG 2 Lab Hour(s) 1 Lecture Hour(s); 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. Create Excel Worksheets and Charts. |
Skill exam – hands-on practice to master skills Problem-based project – appropriate application of skills to solve a problem.
Weeks 1-4
|
2. Summarize Data using Functions, Filters, Tables and Summary Sheets.
|
Skill exam – hands-on practice to master skills Problem-based project – appropriate application of skills to solve a problem.
Weeks 4-6
|
3. Analyze Data with Pie Charts, Line Charts, and What-If Analysis Tools.
|
Skill exam – hands-on practice to master skills Problem-based project – appropriate application of skills to solve a problem.
Weeks 7-9
|
4. Validate Data and Audit Worksheets. |
Skill exam – hands-on practice to master skills Problem-based project – appropriate application of skills to solve a problem.
Weeks 10-11
|
5. Manage Large Workbooks Using Advanced Sorting and Filtering.
|
Skill exam – hands-on practice to master skills Problem-based project – appropriate application of skills to solve a problem.
Weeks 12-13
|
6. Create and Format Charts, Diagrams, and Templates.
|
Skill exam – hands-on practice to master skills Problem-based project – appropriate application of skills to solve a problem.
Weeks 14-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
Add to Portfolio (opens a new window)
|