Excel Units D-F

Unit D:

• Read and complete all the exercises on pages EXCEL 79-95.
• Complete the Independent Challenge 1 on pg Excel 100.   When finished email the final file to me as an attachment at mindy.holder@sccc.edu.
• Complete the Independent Challenge 2 on pg Excel 101.  When finished email the finished file to me as an attachment at mindy.holder@sccc.edu.

Unit E:

• Read and complete all the exercises on pages EXCEL 105-121.
• Complete the Independent Challenge 1 on pg Excel 125.   When finished email the final file to me as an attachment at mindy.holder@sccc.edu.
• Complete the Independent Challenge 2 on pgs Excel 125-126.  When finished email the finished file to me as an attachment at mindy.holder@sccc.edu.

Unit F:

• Read and complete all the exercises on pages EXCEL 129-145.
• Complete the Independent Challenge 1 on pg Excel 149.   When finished email the final file to me as an attachment at mindy.holder@sccc.edu.
• Complete the Independent Challenge 2 on pgs Excel 149-150.  When finished email the finished file to me as an attachment at mindy.holder@sccc.edu.

Excel Units B and C

Excel Unit B

• Read and complete pages Excel 26 through 41
• Complete Independent Challenge 1, pg. Excel 45.  Please email this file to me at mindy.holder@sccc.edu when completed.  
• The file should be an attachment
• The subject line should say 'Excel Unit A, IC2'
• Complete Independent Challenge 2, pg. Excel 46.  Please email this file to me at mindy.holder@sccc.edu when completed as directed above.

Excel Unit C

• Read and complete pages Excel 52 through 69
• Complete Independent Challenge 1, pg. Excel 74.  Please email this file to me at mindy.holder@sccc.edu when completed.  
• Complete Independent Challenge 2, pg. Excel 74-75.  Please email this file to me at mindy.holder@sccc.edu when completed.

Friday, January 16th

Getting Started with Excel

Excel Unit A

• Read and complete pages Excel 1 through 17
• Complete Independent Challenge 2, pg. Excel 21-22.  Please email this file to me at mindy.holder@sccc.edu when completed.  
• The file should be an attachment
• The subject line should say 'Excel Unit A, IC2'

Wednesday, January 14th

• Textbooks
• Download Student Data Files

Orientation - Monday, January 12th

Computer Based Spreadsheets - Excel 2013

Spring 2015

POLICIES/PROCEDURES

Student Conduct -

·         Respect – Treat other students and myself with respect as I will do the same for you.

·          Language – Keep your language clean and respectable.  Watch what you are discussing in class as you might say something that would offend others who can hear you.

·         Honesty – Represent yourself and your work in an honest manner.

·         Property – Respect College Property.

·         Tobacco – Do not use tobacco products in the classroom.

·         Food – Do not bring food into the classroom for any reason.

·         Drinks – Drinks are allowed in classroom as long as the cup has a lid and you take the cup with you when you leave.

Attendance –

·         Attendance will be recorded via use of sign in sheets.  DO NOT SIGN IN FOR OTHER STUDENTS.
·         You are expected to attend class as scheduled.  Don't be late.

·         If you know you will be gone, please email me at mindy.holder@sccc.edu so that I have record of it.
·         If you are sick, please stay home.
·         Cancellation of classes due to weather will be made via RAVE alerts.  If you live out of town and roads are hazardous, please stay home.  Your safety is important.

Cell Phones – 

·          Keep on silent mode.  If you need to take a call, then quietly step outside to do so.

Campus Security - (620)482-3756 

Student Handbook

Academic Calendar

Course Syllabus

MATERIALS NEEDED

Textbook –

·         Microsoft Excel 2013, Illustrated Complete Series.  ISBN 9781285093192.   IT IS MANDATORY THAT YOU HAVE THIS TEXT BOOK FOR CLASS.

COURSE MANAGEMENT

·         Everything you need to know about the class, assignments, holidays, tests, etc. can be found on my teaching blog:  http://mindyholder.blogspot.com.

·         Grades will be emailed to your school email.

CONTACT INFORMATION

Mindy Holder

620-417-1356 (office)
mindy.holder@sccc.edu

Office – Business Division, AA125

Last Assignments - Due May 9th

These are the last units for the semester.  Please take your time and go through this material carefully.  It's definitely more advanced but this is what will put you ahead of everyone else who 'thinks' they know Excel.

Unit G:

• Read and complete all the exercises on pages EXCEL 153-169.  
• Complete the Independent Challenge 1 on pgs Excel 173.   When finished email the finished assignment to me as an attachment at mindy.holder@sccc.edu.

Unit H:

• Read and complete all the exercises on pages EXCEL 177-193.  
• Complete the Skills Review on pgs Excel 195-196.   When finished email the finished assignment to me as an attachment at mindy.holder@sccc.edu.
• Complete the Independent Challenge 1 on pgs Excel 196-197.   When finished email the finished assignment to me as an attachment at mindy.holder@sccc.edu.

Unit I:

• Read and complete all the exercises on pages EXCEL 201-215.  
• Complete the Skills Review on pgs Excel 219-220.   When finished email the finished assignment to me as an attachment at mindy.holder@sccc.edu.

Unit J:

• Read and complete all the exercises on pages EXCEL 225-241.  
• Complete the Skills Review on pgs Excel 243-245.   When finished email the finished assignment to me as an attachment at mindy.holder@sccc.edu.

Unit K:

• Read and complete all the exercises on pages EXCEL 249-265.  
• Complete the Skills Review on pgs Excel 267-269.   When finished email the finished assignment to me as an attachment at mindy.holder@sccc.edu.

Unit L:

• Read and complete all the exercises on pages EXCEL 273-289.  
• Complete the Skills Review on pgs Excel 291-292.   When finished email the finished assignment to me as an attachment at mindy.holder@sccc.edu.

Computer Based Spreadsheets - Getting Started, Units A - F (January 13th - March 14th)

Getting Started with Microsoft Excel:

• Textbook - Microsoft Excel 2010, Illustrated Series, Complete. Reding and Wermers. Cengage Learning.  ISBN:  978-0-538-74713-4.
• Students Data Files -  Click on the following link to download these data files to your computer.  If you have trouble downloading and extracting these data files, please let me know so we can set up a time to go through this.
• https://www.dropbox.com/sh/7f769gjxhsm8pfq/2EDI0xBDBO
• Grades will be posted to Engrade.com.  I will be sending you your login for this in a separate email.
• You are expected to use your school gmail account.  
• You are expected to check this blog for any changes or updates to the assignments or due dates.  These will be made in red.
• My grading is pretty simple.  If you completed the assignment correctly, then you receive 50 pts per assignment/unit.  If you did not complete it correctly, I will return it to you to redo.  If your redo is correct, you will receive the full 50 pts.
• Note - An assignment is considered a Unit.  You will notice each unit will have 2-3 things that you email to me.  Completion of all the unit correctly will give you the 50 pts.
• When submitting an assignment, please put 'Excel Class - Unit A, Concepts Review' (for example) in the subject line.  
• There are no quizzes in this course.
• Any other questions, please let me know.
• Below you will find the assignments for the first half of the semester
• All the assignments below are due by Friday, March 14th

Unit A:

• Read and complete all the exercises on pages EXCEL 1-17.  (Note these are the GREEN tabbed pages)
• Complete the Concepts Review.  Put your answers in an email to me at mindy.holder@sccc.edu.
• Complete the Skills Review on pgs Excel 19 and 20.   Skip question #1.  When finished email the file EX A-Weather Statistics to me as an attachment at mindy.holder@sccc.edu.

Unit B:

• Read and complete all the exercises on pages EXCEL 25-41.  
• Complete the Concepts Review on pgs Excel 42-43.  Put your answers in an email to me at mindy.holder@sccc.edu.
• Complete the Skills Review on pgs Excel 43and 44.   When finished email the file EX B-Baking Supply Company Inventory to me as an attachment at mindy.holder@sccc.edu.
• Complete the Independent Challenge 1 on pg Excel 45.   When finished email the final file to me as an attachment at mindy.holder@sccc.edu.
• Complete the Independent Challenge 2 on pg Excel 46.  When finished email the finished file to me as an attachment at mindy.holder@sccc.edu.

Unit C:

• Read and complete all the exercises on pages EXCEL 51-69.  
• Complete the Independent Challenge 1 on pgs Excel 73-74.   When finished email the final file to me as an attachment at mindy.holder@sccc.edu.
• Complete the Independent Challenge 2 on pgs Excel 74-75.  When finished email the finished file to me as an attachment at mindy.holder@sccc.edu.

Unit D:

• Read and complete all the exercises on pages EXCEL 79-95.
• Complete the Independent Challenge 1 on pg Excel 100.   When finished email the final file to me as an attachment at mindy.holder@sccc.edu.
• Complete the Independent Challenge 2 on pg Excel 101.  When finished email the finished file to me as an attachment at mindy.holder@sccc.edu.

Unit E:

• Read and complete all the exercises on pages EXCEL 105-121.
• Complete the Independent Challenge 1 on pg Excel 125.   When finished email the final file to me as an attachment at mindy.holder@sccc.edu.
• Complete the Independent Challenge 2 on pgs Excel 125-126.  When finished email the finished file to me as an attachment at mindy.holder@sccc.edu.

Unit F:

• Read and complete all the exercises on pages EXCEL 129-145.
• Complete the Independent Challenge 1 on pg Excel 149.   When finished email the final file to me as an attachment at mindy.holder@sccc.edu.
• Complete the Independent Challenge 2 on pgs Excel 149-150.  When finished email the finished file to me as an attachment at mindy.holder@sccc.edu.