BTECA 124 Microsoft Excel: Manage Tables and Import Data (1 credit)
Course Description
Students learn advanced-features of Excel to align with the Microsoft Office Specialist (MOS) objectives. This is the fourth class in a series to prepare students for the MOS exam.
Course Content
A. MS Excel Advanced Features
B. Data Importation and Validation
C. Workbook and Worksheet Inspection
D. Data Manipulation within a Worksheet
Student Outcomes
1. Apply advanced MS Excel features in order to increase clarity and navigation within academic and workplace worksheets.
2. Demonstrate the ability to manipulate data within a worksheet.
3. Demonstrate the ability to import data and text files from other programs.
Degree Outcomes
Program Outcome: Apply technical skills to meet industry standards in the office. Manage time and multiple tasks appropriate to the office. Employ software and/or technology to manage information. Information Competency: Graduates will be able to seek, find, evaluate and use information and employ information technology to engage in lifelong learning.
Lecture Contact Hours 2
Lab Contact Hours 16
Total Contact Hours 18
Potential Methods
A. Discussion, in class or online
B. Instructor assessment
C. Objective test
D. Peer assessment
E. Production test
F. Computerized test
G. Self-assessment
H. Individual project
I. Completed documents
Add to Portfolio (opens a new window)
|
