Your Final Exam

Final Exam – Fall 2013

Advanced Computers, Database Management, Software Suites

One of the changes I have to deal with starting next year is paying a monthly subscription rate for software like Microsoft Office and my Adobe products like Photoshop,etc.  We usually purchase the software at one set price per computer until I decide it’s time to upgrade the software.  There is no monthly subscription.  Changing to a monthly subscription could become too costly in school settings.  The following articles explain this and give you the pros and cons of this change.  You will also read about alternatives to Microsoft Office and Adobe.

Read the following articles.  Discuss with classmates if you wish, and then write me one or two paragraphs (at the most) telling me what you think I should do next year and why.  Read carefully and then justify your opinion to me. 

I want to know what you think.  I am not going to worry about grammar/sentence structure. 

Then email me your 1-2 paragraphs by Wednesday at 4:00 p.m.

http://www.cbsnews.com/news/is-office-2013-proof-that-its-time-to-switch/

http://mac.appstorm.net/general/opinion/what-office-365-creative-cloud-and-other-software-subscriptions-mean-for-you/

http://www.businessweek.com/articles/2013-11-14/2014-outlook-software-makers-subscription-drive

Access Assignments

Chapter 4 - Enhancing Tables

• Read and complete all the activities on pages 413- 461. (DON'T DO Activity 4.02)  Please let me know if you don't understand any of the functions discussed.  I will email more info to you that should help.
• Complete Skills Review Project 4C - on pgs 464-466.  Submit this complete assignment to me at mindy.holder@sccc.edu

Chapter 5 - Enhancing Queries

• Read and complete all the activities on pages 483- 525.  Please let me know if you don't understand any of the functions discussed.  I will email more info to you that should help.
• Complete Skills Review Project 5C Payroll on pgs 528-531.  Submit this complete assignment to me at mindy.holder@sccc.edu

Chapter 6 - Customizing Forms and Reports

• Read and complete all the activities on pages 549- 595.  Please let me know if you don't understand any of the functions discussed.  I will email more info to you that should help.
• Complete Skills Review Project 6C Party Orders on pgs 598-601.  Submit this complete assignment to me at mindy.holder@sccc.edu

No assessment is required for this unit.

Excel Deadline

Goal - Have all the Excel assignments and the assessment completed and turned in by October 21.

Excel 2010 Assignments and Assessment

Chapter 4 - Use Financial and Lookup Functions, Define Names, and Validate Data

• Read and complete all the activities on pages 225 - 260.  Please let me know if you don't understand any of the functions discussed.  I will email more info to you that should help.
• Test yourself by reviewing the terms on page 261-262
• Complete Project 4F - Quarterly Cost Report and Lookup Form on pgs. 272-272.  Submit this complete assignment to me at mindy.holder@sccc.edu

Chapter 5 - Managing Large Workbooks and Using Advanced Sorting and Filtering

• Read and complete all the activities on pages 283 - 327.  
• Complete Project 5F - Vocational Programs on pgs. 340-341.  Submit this complete assignment to me at mindy.holder@sccc.edu

Chapter 6 - Creating Charts, Diagrams, and Templates

• Read and complete all the activities on pages 351- 385.  
• Complete Project 6E - Hires on pgs. 395-396.  Submit this complete assignment to me at mindy.holder@sccc.edu

Excel Assessment 

• Read and complete all the activities on pages 409 - 411 for the Business Running Case. 
• Submit this completed assessment to me at mindy.holder@sccc.edu

Word Deadline

Goal - Please try to get your Word assignments and the assessment completed by September 16th.

Word Chapters 4-6 and Assessment

Word - Chapter 4

• Read and complete all the activities on pages 49 - 81.  You will need to utilize your student data files for this assignment.
• Complete Mastering Word, Project 4G, Expense Reduction on pages 94-95.
• Email this project file to me as an attachment using your school email account.  The subject line should say 'Word 4G'.  My email address is mindy.holder@yahoo.com.

Word Chapter 5

• Complete pgs. 105-141.
• Complete Mastering Word Project 5E Phone Accessories on pgs. 150-151.   Email the document to me when finished.

Word Chapter 6

• Complete pgs. 163-199.
• Complete Mastering Word Project 6E Seminar Agenda on pgs. 208-209.  Email the document to me when finished.
• Complete Mastering Word Project 6F Library Classes on pgs. 210-211.  Email the document to me when finished.

Assessment

• Complete the Business Running Case on pgs. 221-223.  Email this assessment to me when finished.

Fall 2013 - Getting Started

Things you will need for this class:

• Textbook - Go! Office 2010, Volume 2.  Pearson.  ISBN 978-0-13-509090-9.
• Student data files CD...should be included with textbook.  If not, come see me and I will make you a copy. 
• Access to this blog - mindyholder.blogspot.com.  Look on right column under 'Mindy's Classes' and select 'Advanced Computer Class'.  This is where you will find all your assignments.
• Access to a computer with Office 2010.
• My contact info:  620-417-1356, mindy.holder@sccc.edu.