Master Syllabus CS2303, Computer Based Spreadsheets

Credits 3 Lab Hours 0 Lecture Hours 3 Clinical Hours 0
Course Description

A course designed to acquaint the student with computer-based spreadsheets as used with microcomputers. This program is structured to be used as a tool for solving everyday financial or business problems for all types of businesses. For each unit of credit, a minimum of three hours per week with one of the hours for class and two hours for studying/preparation outside of class is expected.

For each unit of credit, a minimum of three hours per week with one of the hours for class and two hours for studying/preparation outside of class is expected.

Program and/or Department Mission Statement

The CIS Program will provide superior learning opportunities in the area of information technology utilizing current technology to enable all students to archive their career and/or educational goals.

SCCC Outcomes

Outcome #1: Read with comprehension, be critical of what they read, and apply knowledge gained from their reading to broader issues of the day.

Outcome #5: Demonstrate the ability to think critically by gathering facts, generating insights, analyzing data, and evaluating information.

Outcome #6: Exhibit skills in information and technological literacy.

Outcome #9: Exhibit workplace skills to include respect for others, teamwork competence, attendance/punctuality, decision making, conflict resolution, truthfulness/honest, positive attitude, judgment, responsibility.

Course Outcomes

Upon completion of the Computer Based Spreadsheets course with 80% or higher mastery of course competencies, the student should be able to:

  1. Perform basic spreadsheet activities using spreadsheet software
  2. Utilize advanced functions of spreadsheet software to create charts, and reports, analyze data, and perform what-if data scenarios
Course Outline
  1. Getting Started with Excel
  2. Building and Editing Worksheets
  3. Formatting a Worksheets
  4. Working with Charts
  5. Working with Formulas and Functions
  6. Managing Workbooks and Preparing Them for the Web
  7. Automating Worksheet Tasks
  8. Using Lists
  9. Analyzing List Data
  10. Enhancing Charts and Worksheets
  11. Using What-if Analysis
  12. Analyzing Data with Pivot Tables
  13. Exchanging Data with Other Programs
  14. Sharing Excel Files and Incorporating Web Information
  15. Customizing Excel and Advanced Worksheet Management
  16. Programming with Excel
Instructional Methods
  1. Classroom lecture/discussion
  2. Handouts, videos, on-screen presentations
  3. Demonstrations using projector
  4. Hands-on computer lab projects both in teams and individually
  5. Instructors will enforce the Academic Honor Code & Cheating Policy as outlined in the SCCC College Catalog. Students who fail to adhere to this policy will receive an F for the course's final grade unless otherwise stated in the instructor's course policies.
Instructional Resources and Materials
  1. Assorted periodical and newsletter articles as they apply to the course
  2. Miscellaneous personal computer hardware/software
  3. Miscellaneous server hardware/software
Methods of Assessment

Assessment will consist of the development of both oral and written reports and computerized presentations on topics in information technology and will assess student ability to gather and evaluate current information in their respective disciplines.

  1. Outcome #1 will be assessed and measured by the comprehension of reading assignments and in-class discussions.
  2. Outcome #5 will be assessed through tests, quizzes, and the presentation of a final portfolio. Hands-on lab assignments and examinations in spreadsheet applications will assess student's basic knowledge of this software.
  3. Outcome #6 will be assessed through the completion of projects. Research assignments/projects completed via the Internet will develop the necessary skills for students to search and evaluate information effectively.
  4. Outcome #9 will be assessed through the completion of group projects.

Delivery of assignments from the instructor AND the student via e-mail will further enhance knowledge and use of this technology.

Note: The above-mentioned course assessment tools will assess student knowledge of technology in a variety of disciplines addressing both the SCCC Outcomes and General Course Outcomes/Competencies identified above.

Americans with Disabilities Act (ADA) Statement

Under the Americans with Disabilities Act, Seward County Community College will make reasonable accommodations for students with documented disabilities. If you need support or assistance because of a disability, you may be eligible for academic accommodations. Students should identify themselves to the Mental Health Counselor at 620-417-1106 or go to the Student Success Center in the Hobble Academic building, room A149.

Reviewed Date