CSCI1021 — Spreadsheet & Database Software
CSCI 1021 - Spreadsheet & Database Software CSCI 1021 - Spreadsheet & Database Software Hours/Week: Lecture 3 Lab 0 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 Major Content Database Software Concepts And Principles Using A Programming Language In A Database Environment: Events, Procedures, Modules 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 Mac
Prerequisites: CSCI1020, CAPL1010