Apr 19, 2024  
2019-2020 Course Catalog 
    
Catalog Navigation
  Catalog Home
  Introduction to Century College
  Mission, Vision, Values

  College Calendar

  Course Descriptions and Outlines
  Programs (Century Academic Pathway)
  Programs (Department)
  Programs (A-Z)

  Academic Policies and Program Requirements
  Admissions and Registration
  Application for Admission
  Student Services and Resources
  Student Handbook
  Transfer

  Continuing Education and Customized Training
  College Administration and Faculty
  Maps and Directions
  Archived Catalogs
  My Portfolio
HELP
2019-2020 Course Catalog [ARCHIVED CATALOG]

Facebook this Page (opens a new window)
Tweet this Page (opens a new window)
Add to Portfolio (opens a new window)

CSCI 1021 - Spreadsheet & Database Software

Credits: 3
Hours/Week: Lecture None Lab None
Course Description: This course teaches the theory and application of spreadsheet and database management software. The current software technologies will be used to demonstrate these concepts and principles. Students will study and apply spreadsheet concepts such as data lists, pivot tables, one-variable and two-variable input tables, importing data, and the creation of spreadsheet applications using a programming language. Students will study and apply database concepts such as table relationships, queries, forms and reports, macros, and the creation of database applications using a programming language. The intent of this course is to prepare students to be able to customize spreadsheet and database software applications.
MnTC Goals
None

Prerequisite(s): CSCI 1020  and CAPL 1010  or instructor consent.
Corequisite(s): None
Recommendation: Basic knowledge of Microsoft Windows, introductory knowledge of spreadsheets and databases.

Major Content
  1. Database Software Concepts And Principles Using A Programming Language In A Database Environment: Events, Procedures, Modules
  2. Database Software Concepts And Principles Principles Of Database Design: Relationships, E-R Diagrams, Integrity, Anomalies, Normalization The Use Of Queries To Extract Organization Information: Crosstab Queries And Others The Use Of Forms To Find And Maintain Table Data Customizing Reports And Integrating Database Software With Other Programs Other Customization Features Structured Programming Techniques World Wide Web Concepts And The Maintenance Of Database Tables Via HTML Documents Macros And Other Automating Features
  3. Integration Transfer Of Spreadsheet Data To A Database Transfer Of Database Data To A Spreadsheet Object Linking And Embedding (OLE)
  4. Spreadsheet Software Concepts And Principles Use Of Charts To Display Organization Data Tools For Extracting Management Data: Lists, Filters, Pivot Tables Integrating Spreadsheet Software With Other Programs And The World Wide Web The Use Of Multiple Worksheets And Look-Up Tables To Extract Organization Data How Data Tables, Solver, And Scenario Management Can Be Used In Cost-Volume-Profit Analysis Automating Tasks Using Macros And Other Automating Features Structured Programming Techniques Using A Programming Language In A Spreadsheet Environment: Objects, Prop

Learning Outcomes
At the end of this course students will be able to:

  1. To teach the concepts and techniques of database management software.
  2. To teach the customizing and automating features of spreadsheet software.
  3. To teach the customizing and automating features of database management software.
  4. To teach the concepts and techniques of spreadsheet software.

Competency 1 (1-6)
None
Competency 2 (7-10)
None


Courses and Registration


Facebook this Page (opens a new window)
Tweet this Page (opens a new window)
Add to Portfolio (opens a new window)