General Assignment Information
You will be responsible for all material in the textbook,
Microsoft Office2007 Advanced Concepts and Techniques, unless otherwise instructed (additional
cases may be done for Extra Credit). You should try to complete the exercises in every
chapter, even though not all material that you create will be submitted for a grade.
Chapters and assigned case problems (Cases and Places #2) will be submitted in blocks, by application, during the term (refer to the individual assignment
sheets for more detailed information). Case problems will be unique
and every student's should be different. I will be
looking to see if you have used the concepts taught, as
well as your own creativity to create and develop each case
problem.
Each packet is worth 30 - 45 points and must
be submitted with a completed and self-graded Cover Sheet
(assignment sheet). Additional cases you do from the chapters
may be turned in for extra credit (instructor discretion)
at the same time. In this course,
I may use the words Assignment Packet and Notebook interchangeably. A
notebook just indicates that you should place your assignments
in a folder or put them together with a clip (or submit
completed files zipped via the Angel assignment drop box for
online classes).
You must enter your name on each printout/file (some students like to
also put the chapter or the
case problem number on each printout/file for their own
purpose).
This should
be typed and not written by hand. Include this
information in the footer of your assignments (see
Instructions for
Compiling/Submitting Assignments below).
It's also a good idea to label your filenames with your
chapter, case # and initials so you don't get chapters and cases
confused. If the filename is "Enrollment", you could name it
"Enrollment-C4C2-SEK". This indicates the filename,
Chapter 4, Case 2, and my initials SEK (your initials would go here).
Kind of lengthy, I know, but it's worked for many of my students. Don't
use fancy characters or punctuation in your filenames since MSOffice and
ANGEL may not accept them.
It is your responsibility to work through the entire textbook while sitting at your computer. Practice tests can be taken
in the Skills Assessment Manager (SAM), as needed. The Apply Your Knowledge and In The Lab assignments help reinforce what you have learned in the
chapter. The case problems are basically done from scratch. You are taught the necessary material to complete the case problems by working through the chapter. Cases should be completed using features discussed in each
chapter and should look equally as good when finished.
Student Data Files can be
copied from SCC's network G:\Datalib\CGS2108\...(then pick the
appropriate application folder/file)
or downloaded from http://www.scsite.com
(see inside back cover of your
textbook).
A
link to student downloads can also be found in Angel.
Each assignment
packet including the files
from the assigned case problems should be submitted to the instructor by the due
date listed on the calendar. You must complete a Cover Sheet to submit
with each packet. The assignment packet must
delivered in hardcopy (on-campus students) or be zipped up
(on-line students) with all applicable files and the cover sheet and sent
to the instructor via the
ANGEL
assignment drop box by
the due date.
Textbook Modules
Word
Work through all three chapters and the Integration/Web Feature of Microsoft
Word from beginning to end. Complete all assigned Chapter pages/cases (see assignment links for more detailed info) and any extra credit work from this module.
If you are missing a graphic or template which you need to complete any case problem, just choose another one and make a note to me in your
assignment sheet about it. This holds true for any of the software, not just Word.
Online students will send files to me upon completion of the assignments, not
printouts.
Excel
Work through all three chapters and the Integration/Web Feature of Microsoft Excel from beginning to end. Complete all assigned
Chapter pages/cases (see assignment links for more detailed info) and any extra credit work from this module.
Access
Work through all three chapters and the Integration/Web Feature of Microsoft Access from beginning to end. Complete all assigned
Chapter pages/cases (see assignment links for more detailed info) and any extra credit work from this module.
Power Point
Work through the two chapters and the Integration/Web Feature of Microsoft Power Point from beginning to end. Complete all assigned
Chapter pages/cases (see assignment links for more detailed info) and any extra credit work from this module.
Outlook
Because this does not work
properly in the classroom environment at SCC, we do not cover it
in the course. If you have Outlook, you might want to work
through this for your own benefit. You are not tested on this
module.
Office Integration Case Studies
Microsoft Office allows you to interact in each application in a seamless fashion. This module sums up the text. You may work through the Integration Case Studies on your own for extra credit, if not assigned by the instructor. You will not be tested on material from this
chapter. As you were working through the chapters, you should have also worked through the Integration/Web Feature at the end of each module for a better understanding of how the programs interact with one another.
Internet--E-mail--Ethics
You will be introduced to and expected to have an understanding of how to "surf the net" and use e-mail during the course, especially if enrolled in an on-line course.
Appendix A -
Project Planning Guidelines
The
process of communicating specific information to others is a learned,
rational skill. Computers and software, especially Microsoft
Office 2007, can help you develop ideas and present detailed information
to a particular audience.
Appendix B -
Introduction to Microsoft Office 2007
Microsoft Office 2007 is a collection of the more popular
Microsoft application software. It is available in Basic, Home and
Student, Standard, Small Business, Professional, Ultimate, Professional
Plus and Enterprise editions. Each edition consists of a group of
programs, collectively called a suite. This appendix lists and
describes the various suites and their components.
Appendix C -
Microsoft Office 2007 Help
This appendix shows how to use Microsoft Office Help.
Appendix D -
Publishing Office 2007 Web Pages to a Web Server
With Office 2007 programs, you use the
Save As command on the Office button menu to save a Web page to a Web
Server using one of two techniques: Web folders or File Transfer
Protocol (FTP).
Appendix E -
Customizing Microsoft Office 2007
This appendix explains how to change the screen resolution in
Windows Vista to the resolution used in this book. It also describes ho
to customize the Word window by changing the Ribbon, Quick Access
Toolbar, and the color scheme.
Appendix F - Steps
for the Windows XP User
For most tasks, no differences exist between using Office 2007
under the Windows Vista operating system and using an Office 2007
program under the Windows XP operating system. With some tasks, however,
you will see some differences, or need to complete the tasks using
different steps.
Appendix G -
Microsoft Business Certification Program
This Program enables candidates to show
that they have something exceptional to offer - proved expertise in
Microsoft Office 2007 programs. The Microsoft Certified Application
Specialist Program is explained in detail in this Appendix. This
certification provides a valuable industry credential or proof that you have the Office
application skills required by employers. Our textbook is a Microsoft-approved
textbook that covers the required objectives for the various exams. The Web page
http://www.scsite.com/off2007/cert
includes links to general information on certification, choosing an
application for certification, preparing for, taking and passing the certification exam.
Back to Top
