Course Code:
WFTR 570
Calendar Description:
Microsoft® Office Excel – Level 3 teaches students how to use advanced features to work with different types of reports. Students will look at productivity tools to increase data entry, features to enable collaboration with others, and use various commands to analyze large numerical reports.
Date First Offered:
2009-07-01
Hours:
Total Hours: 18
Seminars and Tutorials: 18
Total Weeks:
3
This course is offered online:
No
Pre-Requisites:
WFTR 550 MicroSoft Excel Level 2 or permission of CE/WFTR Coordinator
Non-Course Pre-Requisites:
NONE
Co-Requisites:
NONE
Rearticulation Submission:
No
Course Content:
Unit 1: Using Data Tools
- Using AutoFill
- Finding and Replacing Data
- Using Paste Special
- Consolidating Data
- Setting Up Automatic Subtotals
- Grouping and Ungrouping Data
- Converting Text to Columns
Unit 2: Preparing Online Documents
- Validating Data
- Using Pick Lists
- Removing Duplicate Rows
- Circling Invalid Data
- Working with Templates
- Using Hyperlinks
- Saving Worksheets as HTML
Unit 3: Collaborating with Others
- Using Comments
- Looking at Workgroup Functions
- Protecting Your Workbook
- Preparing for Distribution
Unit 4: Using Analysis Tools
- What-If Analysis
- Using the Goal Seeking Tool
- Using the Solver
- Using a Data Table
- Using PivotTables
Learning Outcomes:
Upon successful completion of this course, the student will be able to:
- Use AutoFill to copy or fill data
- Find and replace specific types of data
- Consolidate or summarize data
- Group or outline data
- Convert text to columns
- Use AutoFill to set up a series of data
- Find and replace data in a worksheet
- Use Paste Special to create different types of data
- Create groups and subtotals from the data in the worksheet
- Convert text to columnar formats
- Validate data and remove duplicate rows of data
- Use pick lists
- Work with existing templates, or create your own template
- Create, modify or remove a hyperlink
- Save a worksheet or a range of cells in a HTML format
- Publish a worksheet to the Internet
- Work with shared workbooks including adding protection or tracking changes
- Changing workbook properties and using the Document Inspector appropriately
- Set up a what-if scenario with a worksheet
- Use the Goal Seeking and Solver tool
- Work with a single or two variable data table
- Create and modify PivotTables or PivotCharts
Grading System:
Percentage
Passing Grade:
70%
Grading Weight:
Quizzes and Tests: 50 %
Assignments: 30 %
Lab Work: 15 %
Participation: 5 %
Number of Assignments:
4
Nature of Participation:
Attendance
Percentage of Individual Work:
100
Course Offered in Other Programs:
No
Additional Comments:
Completion of this course partially prepares students to write the Microsoft Certified Application Specialist exam. By completing the other levels available for this application students will have reviewed all of the exam objectives.
Text Books:
Required - Microsoft, 2008, Microsoft Office Excel 2007 Level 3 - Advanced Skills (CCI Learning Solutions Inc.). Chapters Covered: All