Using Microsoft Excel in the Classroom, DelNegro-Jozefiak, Fall 2019

Course Number:	EDU 5515 C37
Instructor:	Nicole (Nicky) DelNegro-Jozefiak
Location:	Blended format course. The course will meet once in-person the week of October 6^th (TBD). The remainder of the course will be held in an online/independent format with possible Zoom video meetings.
Dates and Times:	October 6-November 24, 2019.
Credits:	3 graduate credits (45 hours)
Tuition:	$975

Note: Course payment or purchase order of $975, payable to Castleton University, is due at the time of registration. A purchase order number can be entered into the online registration form and the purchase order can be uploaded to the registration form. If paying by check, please mail the check to: Financial & Registration Services, Castleton University, 62 Alumni Drive, Castleton, VT 05753. To help us ensure that your payment is applied to the correct course, PLEASE WRITE “CFS” IN THE CHECK MEMO LINE. Thank you.

Course Description

Microsoft Excel 2013: Comprehensive covers key introductory, intermediate, and advanced Microsoft Excel skills. Topics covered include entering and editing entries, selecting cells and ranges, creating and modifying basic formulas, formatting worksheets, working with multiple-sheet workbooks, charting, collaboration, integrating with other Office programs, and more.

Course Goals/Objectives

By the end of this course, you will be able to:

Navigate the Excel window and issue commands
Select, move, and copy cells and ranges
Insert, delete, move, copy, and rename worksheets
Create formulas to calculate values
Format worksheets using a variety of methods
Create different types of charts
Work with dynamic and static date functions
Copy worksheets and their formats
Build formulas with criteria IF functions and logical functions
Create and format tables from worksheet data
Draw, modify, and add text to shapes
Set macro security to protect workbook data
Group worksheets for efficient data entry
Protect workbooks and worksheet contents
Import web data into a worksheet
Share Excel data with Word, PowerPoint, and Access

Course Expectations

Your performance in this course is evaluated on your performance in exercises with the following skills:

Introductory skills (Lessons 1-6): 33%
Intermediate skills (Lessons 6-12): 33%
Advanced skills ( Final Project): 33%

Required Texts

Required texts are not included in the course tuition.

Title: Microsoft Excel 2013: Comprehensive
Authors: Eric S. Weinstein
Publisher: Labyrinth Learning
ISBN: 13:978-1-59136-483-2

For additional course information

Nicole (Nicky) DelNegro-Jozefiak

For additional registration information

Bethany Sprague
(802) 468-1325