Saturday, January 18, 2014

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.
  • 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.