OADM242 Excel Level II (Experimental)
Department of Science, Technology, Engineering & Mathematics: STEM Department Archive
- I. Course Number and Title
- OADM242 Excel Level II (Experimental) Course No Longer Offered
- II. Number of Credits
- 1 credit
- III. Number of Instructional Minutes
- 1000
- IV. Prerequisites
- OADM142
- Corequisites
- None
- V. Other Pertinent Information
- VI. Catalog Course Description
- Additional Excel spreadsheet techniques and application, including macro programming, database searching, extraction, and linking to obtain prescribed reports and graphs.
- VII. Required Course Content and Direction
-
-
Course Learning Goals
Students will be able to:
- organize a problem for solution with spreadsheet template;
- apply the principles of effective worksheet and database layout in building a spreadsheet template;
- create and use simple spreadsheet macros;
- use the spreadsheet's database techniques to locate, link, extract, and combine data from multiple spreadsheets;
- use spreadsheet functions to prepare and printing graphs; and
- use spreadsheet print capabilities to enhance printed output.
-
Planned Sequence of Topics and/or Learning Activities
- Spreadsheet Template Definition and Design
- Defining and organizing the problem
- Designing a template to solve the problem
- Spreadsheet Macros
- Creation
- Use
- Spreadsheet Database Techniques
- Searching
- Linking
- Extracting
- Combining
- Graphing and Printing
- Creating graphs
- Printing graphs
- Enhancing reports
-
Assessment Methods for Course Learning Goals
-
Reference, Resource, or Learning Materials to be used by Student:
See course syllabus for required textbooks.
-
Review/Approval Date - Unavailable; New Core 8/2015