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

Register online now!