Standard

CIS 128 - Spreadsheet and Database Techniques

Course Description

Provides a study of spreadsheets and databases. Topics include: spreadsheet fundamentals, advanced spreadsheet concepts, development of macros, database management fundamentals, and advanced database management concepts.

Competency Areas		Hours
Spreadsheet Fundamentals		Class	4
Advanced Spreadsheet Concepts		D. Lab	6
Development of Macros		P. Lab/O.B.I.	0
Database Management Fundamentals		Credit	7
Advanced Database Management Concepts
Prerequisite:	SCT 100
Corequisite:

Course Guide

Competency	After completing this section, the student will:	Hours
		Class	D.Lab	P.Lab/ O.B.I.
SPREADSHEET FUNDAMENTALS		8	12	0
Spreadsheet concepts	Explain the purpose of a spreadsheet.
	Identify “What if” analyses.
	Define cell, format, range, label, retrieve, absolute, command, replicate, formulas, text, and values.
Cursor movement	Move the cursor under the control of a spreadsheet program using several different methods.
	Construct labels, values, and formulas.
	Name ranges.
	Access disk files by listing, saving, retrieving, and erasing.
Modification	Explain the purpose of insert, delete, move, and erase. Rearrange data by moving and copying.
Formats	Identify the different formats available on the spreadsheet program used in class.
Printing	Identify the steps for printing spreadsheets.
	Explain method for changing spreadsheet print size, margins, and borders.
	Print all or a portion of a spreadsheet.
	Modify the spreadsheets by changing the print size, margins, and borders.
ADVANCED SPREADSHEET CONCEPTS		8	12	0
Functions	Define a function.
	Identify the main functions used with the spreadsheet program.
	Create spreadsheets using various functions.
Graphs	Identify line, bar, stacked-bar, and pie graphs.
	Create line bar.
	Format graphs.
DEVELOPMENT OF MACROS		4	6	0
Spreadsheet macros	Define macros. Identify the main commands used in macros.
	List the correct sequence of steps to build a macro.
	Using a spreadsheet program on the microcomputer, build and execute macros that will make data entry and heading entry easier, and automatically format print outs.
Database creation and maintenance	Sort all or a portion of the spreadsheet. Search and extract data from the spreadsheet.
DATABASE MANAGEMENT FUNDAMENTALS		4	6	0
Concepts	Explain the purpose of and need for a database. Define file, record, and fields.
Creation	Identify steps necessary to set up a database (e.g., defining field names, field type, width, decimal positions).
	Create the structure of a database.
	Add records to a database.
Maintenance	Modify records contained in a database.
	Delete records contained in a database.
	Save, retrieve, and copy a database file.
Viewing	Identify the steps to display a database Sort/index a database file.
Printing databases	Identify the different options available to print a database.
	Print a report with subtotals.
	Identify ways to modify the printing of the report.
ADVANCED DATABASE MANAGEMENT CONCEPTS		16	24	0
Command file programming	Identify common file programming commands. Create command file programs on the microcomputer.
Queries	Define query. Identify the steps necessary to create a query.
Combing	Join databases created in the same application.
	Identify the steps necessary to import data from a different application.
Forms	Explain the purpose of a form. Create and use a database form.

Suggested Resources

Books

Ageloff/Parsons/Oja/Carey.(1998)New Perspectives on Microsoft Excel 97 Comprehensive.

Adamski/Hommel/Finnegan.(1998)New Perspectives on Microsoft Access 97 Comprehensive-Enhanced. Course Technology

Shelly/Cashman/Pratt. Microsoft Access 2000 Comprehensive Concepts and Techniques. Course Technology 2000

Adamski/Hommel/Finnegan. New Perspectives on Microsoft Access 2000 Comprehensive. Course Technology 2000

Shelly/Cashman/Quasney. Microsoft Excel 2000 Comprehensive Concepts and Techniques. Course Technology 2000

Ageloff/Parsons/Oja/Carey. New Perspectives on Microsoft Excel 2000. Comprehensive 2000