Using Microsoft Excel in the Classroom, DelNegro-Jozefiak, Spring 2020

Course Number:	EDU 5515 C32
Instructor:	Nicole (Nicky) DelNegro-Jozefiak
Location:	Blended format course. The course will meet once in-person the week of January 26, 2020. The remainder of the course will be held in an online/independent format with possible Zoom video meetings.
Dates and Times:	January 26 – March 22, 2020
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

Educators and Administrators will learn to use Microsoft Excel 2013 to manipulate student data to propel their next steps for instruction and to enhance student learning in their classroom. EXCEL is also useful for teachers in MTSS and EST in creating spreadsheets to input data for data collection. Integrating technology in the classroom is becoming more and more important along with being able to assist your students to use Excel to progress in your classroom. This will allow you to teach students how to apply technology to improve and enhance their education by introducing Excel into your classroom.

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
Much, much more!

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