Due Dates and Final Exam

All Assignments must be turned in by Friday, December 7th


There will be no Final Exam for this class.

Access Assignments and Quiz

Unit A - Getting Started with Access 

• Read and complete all the activities on pages Access 2-17.
• Complete Independent Challenge 2 on page Access 22.  Email 'Recycle-A.accdb' to me when complete.

Unit B - Building and Using Queries 

• Read and complete all the activities on pages Access 26-41.
• Complete Skills Review on pages Access 43-44.  Email 'Recycle-B.accdb' to me when complete.

Access Quiz 

• There is no Access Quiz.  Your grade will be based on the above files you were instructed to turn in.

PowerPoint Assignments and Quiz

Unit A - Creating a Presentation 

• Read and complete all the activities on pages PowerPoint 2-17.
• Complete Independent Challenge 1 on page PowerPoint 21.  Email to me when complete.

Unit B - Modifying a Presentation 

• Read and complete all the activities on pages PowerPoint 26-39.
• Complete Independent Challenge 1 and the Advanced Challenge Exercise on pages PowerPoint 45-46.  Email to me when complete.

Unit C - Inserting Objects into a Presentation 

• Read and complete all the activities on pages PowerPoint 50-65.
• Complete Independent Challenge 2 on page PowerPoint 70.  Email to me when complete.

PowerPoint Quiz 

• Email me when you are ready for the quiz

Excel - Unit D

Working with Charts

• Read and complete all the activities on pages Excel 79 - 95.

• Complete Independent Challenge 1 on page Excel 100.  Email to me when complete.

• Complete Independent Challenge 2 on page Excel 101.  Email to me when complete.

Excel - Unit C

Formatting a Worksheet

• Read and complete all the activities on pages Excel 51 - 69.

• Complete Independent Challenge 1 on pages Excel 73-74.  Email to me when complete.

• Complete Independent Challenge 2 on pages Excel 74-75.  Email to me when complete.

Excel - Unit B

Working With Formulas

• Read and complete all the activities on pages Excel 25 through 41.

• Complete Independent Challenge 1 on page Excel 45.  Email to me when complete.

• Complete Independent Challenge 2 on page Excel 6.  Email to me when complete.

Excel - Unit A

Getting Started with Excel 2010

• Read and complete all the activities on pages Excel 1 through 17.

• Complete Independent Challenge 1 on pages Excel 20 - 21.  Email to me when complete.

• Complete Independent Challenge 2 on pages Excel 21 - 22.  Email to me when complete.

Word Quiz

Once you are finished with Unit D assignments, you are ready for the Word quiz.  It is hands-on, just like the end-of-the chapter assignments you have done.

You can use your book on the quiz.

When you are ready for the quiz, please email me.  Put 'Ready for Word Quiz' in the subject line of the email.

It will be ready to take by Friday, 9-21.

Unit D - Formatting Documents

• Complete the activities on pages Word 78 - 95.
• Complete the Skills Review on pages Word 97 - 99.  (email this document to me when complete)
• Complete Independent Challenge #3 on pages Word 102 - 103.  (email this document to me when complete)

Unit C - Formatting Text and Paragraphs

• Complete the activities on pages Word 50 - 67.
• Complete the Skills Review on pages Word 69 - 71.  (email this document to me when complete)
• Complete Independent Challenge #2 on page Word 73, including the Advanced portion.  (email this document to me when complete)

Unit B - Editing Documents

Once you have complete the assignments for Unit A, you are ready to move on to Unit B:

• Complete the chapter, pages Word 26 - 41.
• Complete Independent Challenge 1, pg. Word 45.  Don't do the Advanced Challenge portion.  (email to me when finished)
• Complete Independent Challenge 2, pg. Word 46.  (email to me when finished)

Word - Unit A

• Read and Complete all the activities on pages Word 1 - 17.

• Complete the Skills Review on pages Word 19 - 20.  Using your campus email, send this document to me at mindy.holder@sccc.edu.  Put 'Word Unit A' in the Subject line of the email. 

Getting Started

Student Data Files -

Get student data files from the email that I sent you and copy them to your 'Q' network drive.

Orientation

Mindy Holder – NEED TO KNOW

Fall 2012

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.

Student Handbook -http://issuu.com/craig.dusek/docs/studenthandbook11_12?viewMode=magazine&mode=embed

Attendance –

      Attendance will be recorded via use of sign in sheets.  However, it will not be used for a grade.

      If you know you will be gone, please email me at mindy.holder@sccc.edu so that I have record of it.

Cell Phones – 

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

MATERIALS NEEDED

      Microsoft Office 2010 , First Course, Introductory, Illustrated Series.  ISBN 978-0-538-74715-8.

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 posted to the online grading program, Engrade.  www.engrade.com/students.

CONTACT INFORMATION

Mindy Holder

620-417-1356 (office)

620-629-0610 (cell)

mindy.holder@sccc.edu

Office – Business Division, AA125

Grades

Regarding Grades:

We will not utilize Engrade for this course.  I will simply email you your grades as you complete the assignments.

Word - Units A, B, C, and D

Unit A – Creating Documents with Word 2010

• Read and complete all the activities on pages Word 1 through 17. 
•  Complete Skills Review on pages Word 19 – 20.  When complete, please email your work to me as an attachment.  (If you have questions about sending an attachment with an email, please let me know ASAP).  Put ‘Word Ch 1, SR’ in the subject of the email.

 Unit B - Editing Documents

• Read and complete all the activities on pages Word 25 through 41. 
•  Complete Independent Challenges 1-2,  pages Word 45– 46.  When complete, please email your work to me as an attachment. 

Unit C - Formatting Text and Paragraphs

• Read and complete all the activities on pages Word 49 through 67.
• Complete Independent Challenges 1-3, pages Word 72 - 74.  When complete, please email your work to me as an attachment.

Unit D - Formatting Documents

• Read and complete all the activities on pages 77 - 95.
• Complete Indepdendent Challenges 1-2 on pages Word 100 to 101.  When complete, please email your work to me as an attachment.  

When completed with Unit D, please email me requesting the Word quiz.  Before going on to Excel.

Downloading Data Files

You will need to download the data files for this textbook to your computer.

1.   

•  Start your internet browser (Google Chrome, Internet Explorer, or FireFox) and type www.cengage.com/ct/studentdownload in the address bar.
• You should now get a page you can print on how to complete the download process.  

 
 
 
 

•  You are now going to click on the link in the #1 on the web page above.  This will take you to the following screen:

 
 
 
 
 
 
 
 

• Now you need to type the text book ISBN # in the Search for Books of Materials box as shown above – type 978-0-538-74715-8 and click on Find.
• This will bring you to the following screen.  Below the picture of the textbook, you will see the section entitled ‘Related Products & Free Material’ and there is an ‘Access’ button to the right.  Click on this button.

 

• Now you should be at this screen (see below).  On the left hand side, you will see ‘Book Resources’.  Click on the ‘Data Files’ link under that.

 
 
 
 
 
 
 
 

• This brings you to the screen below.  See where is says Download Now:  0538747153_241411.exe, you will want to click on the 05xxxx .exe link.  This will start the download process for you.  Save/DoubleClick on the downloaded file/Run/Unzip are the next selections you will make.   Your data files should be in a folder called Course Technology on the C: drive.

 

Getting Started with the Office Suites Course

All of your assignments will be on this blog. We do not use eCollege for this course.

You will utilize your school email account to send questions and assignments to me at mindy.holder@sccc.edu.

We will utilize Engrade for our gradebook program.  (Log in instructions will be posted at a later date.)

It is EXTREMELY important to put the appropriate text in the subject portion of your email.  For example, if you are submitting an assignment, please post in the Subject area:  Assignment for Word Chapter 1.  If you have a question, please post in the Subject area:  Question on Ch 1 Word MSS class.  This just helps me to answer your questions right away.

Due Dates for assignments will be posted along with the assignment.  Late work will not receive credit.  Extensions on assignments will be dealt with on an individual basis.

Please do your own work.  This should not be a stressful course.  It is set up for you to learn Word, Excel, PowerPoint, and Access 2010 applications.   It is a course you chose to do.  

Always read the assignment instructions carefully. There will not always be a a new posting on this blog everyday, however, you need to check just in case.

You will need the following for this course:

• Computer - (Windows based)
• Software - Microsoft Office 2010
• Other hardware - Printer attached to your computer
• Textbook - Microsoft Office 2010, First Course, Introductory, Illustrated Series from Course Technology.  ISBN #978-0-538-74715-8

If you have questions, please email me as indicated above.  I will always try to respond in a timely manner.

ASSIGNMENT:    Please send me an email (mindy.holder@sccc.edu) stating that you have read through this introduction and are ready to start Chapter 1 Word.  Please put in the subject line 'Introduction to Software Suites'.

Spring 2012 Semester

This is the end of the Spring 2012 semester

Access Assignments

Chapter 1-

• Read through pages AC-3 to 13
• Complete Skills Review 1.1, pages AC14-16
• Complete Skills Review 1.2, pages AC16-18
• Complete the Challenge Yourself 1, page AC18 - 19

Chapter 2-

• Read through pages AC-22 to 43
• Complete Skills Review 2.1, pages AC44-46
• Complete Skills Review 2.2, pages AC46-48
• Complete the Challenge Yourself 1, page AC48-49

 
Chapter 3-

• Read through pages AC-53-77
• Complete Skills Review 3.1, pages AC78-80
• Complete Skills Review 3.2, pages AC81-84
• Complete the Challenge Yourself 1, page AC84-85

Access Quiz - Email me when you are ready for this.

There will be no final exam.

All Assignments are due Monday, May 7, 2012.

PowerPoint Assignments

Chapter 1-

• Read through pages PP-3 to 15
• Complete Skills Review 1.1, pages PP16-18
• Complete Skills Review 1.2, pages PP18- 20
• Complete the Fix-It , page PP23 

Chapter 2-

• Read through pages PP-25 to 42
• Complete Skills Review 2.1, pages PP43-46
• Complete Skills Review 1.2, pages PP46-50
• Complete the Challenge Yourself 1, page PP50-52

Chapter 3-

• Read through pages PP-57 to 74
• Complete Skills Review 3.1, pages PP75-77
• Complete Skills Review 3.2, pages PP77- 79
• Complete the On Your Own, page PP82 - 83

Chapter 4-

• Read through pages PP-85 to 100
• Complete Skills Review 4.1, pages PP101-103
• Complete Skills Review 4.2, pages PP103- 105

 PowerPoint Quiz - Email me when you are ready for this

Excel Quiz

After Chapter 4 in Excel, you will be ready to take the exam.

I will be gone Monday, April 2 and hopefully back on Wednesday, April 4.

There are no classes Friday, April 6 and Monday, April 9 for Easter Break.

The exam will be ready after the Easter break.  Email me if you are ready for it.

Excel 2010

If you don't have the files for Excel, grab on of the cd's by the printer and copy the Excel data files to your Q drive (or wherever you are saving your files).  Just be sure to put it back on the spindle when you are done copying the files.

Excel Chapter 1

View more presentations from mindysholder

Assignment - Chapter 1 Excel

• Complete pgs. EX-2 through EX - 25.  Go SLOWLY through this chapter.
• Complete Skills Review 1.1 and 1.2  on pages EX-26 through 33.
• Complete the Challenge Yourself 2 on pages EX-35 through36.  EMAIL this file to me when completed.

Excel Chapter 2

View more presentations from mindysholder

Assignment - Chapter 2 Excel

• Complete pgs. EX 41 through EX 63.   Again, go SLOWLY through this chapter.
• Complete the Skills Review 2.1 and 2.2 on pages EX-64 through EX-69.  EMAIL these completed projects to me when completed

Excel Chapter 3

View more presentations from mindysholder

Assignment - Chapter 3 Excel

• Complete pages EX 77 through EX-101.
• Complete Skills Review 3.1 on pgs. EX 102 - 105.
• Complete the Challenge Yourself 1 on pages EX-109 through 110.  EMAIL me this project when completed.
• Complete the Challenge Yourself 2 on pages EX-110 through 111.  EMAIL me this project when completed.

Assignment - Chapter 4 Excel

• Complete pages EX-115 through EX - 140.
• Complete Skills Review 4.1 and 4.2 on pages EX-141 through 149.
• Complete the Challenge Yourself 1 on pgs EX - 149 to 150.   Email me this file when completed.
• Complete the Challenge Yourself 2 on pgs. EX-151.  Email me this file when completed.

Word 2010 Quiz

Please email when you are ready for this quiz.


In the subject line of the email put "Suites Class - Word Quiz"

Word - Chapter 5

Word Chapter 5

• Complete all the activities in Chapter 5, pgs. WD-112 through 123.
• Complete the Skills Review 5.1 on pgs. WD-124 to 127.  Email final document to me when finished.
• Complete the Skills Review 5.2 on pgs. WD-127 to 129.  Email final document to me when finished.

Assessment over Word Chapters 1-5 will be next.  See further instructions posted this week.

Word - Chapter 4

• Complete the activities in Chapter 4, pgs. WD-82 through 100.
• Complete the Skills Review 4.1 on pgs. WD-101 through WD104.   Email final document to me when finished.
• Complete the Skills Review 4.2 on pgs. WD104 through 106.  Email final document to me when finished.

Word - Chapter 3

Word Chapter 3

Word Chapter 3 - Formatting Documents

1. Complete the activities in Chapter 3, pgs. WD-52 through 68.
2. Complete the Skills Review 3.1 on pgs. WD-69-73.  Email final document to mindy.holder@sccc.edu.
3. Complete the Skills Review 3.2 on pgs. WD-73-76.  Email final document to mindy.holder@sccc.edu.

Word - Chapter 2

Word Chapter 2

Word Chapter 2  - Formatting Text and Paragraphs

1. Complete Skills Review 2.1 on pages WD-42-44.  Email the final document to mindy.holder@sccc.edu. 
2. Complete Skills Review 2.2 on pages WD 44-47.  Email the final document to mindy.holder@sccc.edu.

Word - Chapter 1

To get started with Chapter 1, go through the following PowerPoint slides first.  This will give you a good visual overview of the chapter.

Office 2010 Word Chapter 1

Textbook Assignment:

• Word Chapter 1 - read through pages WD-3 through WD-12
• Complete the Skills Review 1.1 on pgs. WD-13 to15.
• Complete the Skills Review 1.2 on pgs. WD-15 to 17.
• Email these two Skills Reviews to mindy.holder@sccc.edu

Getting Started

GETTING STARTED

First of all, if you don't have access to Microsoft Office 2010, please me at mindy.holder@sccc.edu ASAP.  Most of the computer labs on campus have this software and you are free to work in AA109 or AA113 at anytime.
The text we are using for this course is:  Microsoft Office 2010, A Skills Approach, by Manning and Swinson. McGraw Hill Publishing. ISBN:  978 0 07 351647 9


This blog is where you will find all your assignments for the course.  Please check back every Monday for new assignments and revisions to previous posts.

If you have questions regarding any assignment, please email me at mindy.holder@sccc.edu or stop by my office in the business division.

To get started, you need to download the student data files (unless your text has a CD in the back of the book).  OR you can come by and borrow a CD with the file on it from me.


These files can be downloaded by:

• Going to the following web site and clicking on links to download data files to your computer...  http://highered.mcgraw-hill.com/sites/0073516473/student_view0/student_data_files.html

Let me know if you have problems obtaining your data files.