General Assignment Information

     You will be responsible for all material in the textbook, Microsoft Office2007 Introductory 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 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 Chapter may be turned in for extra credit (instructor discretion) at the same time.  In this course, I 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-C1C2-SEK".  This indicates the filename, Chapter 1, 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\CGS2100\...(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.

Introduction to Computers
Read through the COM pages. This section gives a general overview of computer concepts.  Many of you may already be familiar with the material in this module.  If you are new to computers, the material in this section will be new to you.  You will be responsible for knowing the material in this section.

Microsoft Windows /Microsoft Office
Read/work through this  section of the book.  It is very important that you have a good understanding of Windows, especially concerning file management.  If you do not, you will have problems throughout the remainder of the course.  This short module also introduces you to how the office programs work together. 

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 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 (Web Features)
Microsoft Office allows you to interact in each application with the Internet in a seamless fashion. This module sums up the text. You may work through Integration 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

Back to Top

Back to Top

To create a footer in Word, Excel and Power Point (Access is different)* complete the following steps:

1. From the Ribbon, select Insert, Footer (or Header/Footer) option
2. Select the appropriate footer position/style and type your name or initials (PPT gives option for Slide or Handouts).
3. If you want to include more information, press the tab key or continue typing at this point (across, not down).
4. Ex: Sandy Keeter - Word Chapter 1 - Case 2 - "Current Date"
5. Click on "Close Header & Footer" button when done (or change back to Normal View in Excel..:)

When you have completed the above steps, you can use Print Preview to verify you have a footer at the bottom of the page.

*In Access, the Header will change according to the name you assign to the objects (ie: tables, queries, forms, reports). Therefore, all objects will be saved with your initials and the object name.

Back to Top

How to compress files and folders using Windows XP or Windows Vista
 native compressing capabilities
(Click here for more detailed WinXP or alternate WinZip Instructions)

1. Windows XP and Windows Vista have the ability to zip up files and folders without the need to install WinZip separately. To Zip files that reside in a folder:

     a. Open the folder that contains the files to be zipped (or simply select the folder without opening it if you want all files within zipped up - see other instructions below).

     b.  Click Edit and then Select All and Windows will select all files in the folder for you or Ctrl click individual files to be zipped.

     c. Click File, or right click the file(s) and then select Compress to ZIP + options or Send To, Compressed (zipped) Folder and verify the location where you want it saved or sent.

Windows will then compress the files and place them all in a new file with an icon that resembles a folder with a zipper along the left side of the folder. If file extensions are displayed you will see the new compressed file has an extension of .zip. This new .zip file can then be attached in an e-mail to send multiple files at once in a compressed format. The zip file will take on the name of the first or last file you zipped, which is most likely not an appropriate name. You may want to change the name to an appropriate name prior to sending via email by right clicking on the zip file (be careful not to remove the zip extension).

2. Windows XP and Windows Vista can also compress entire folders so that you don't have to select a bunch of files.

     a. Select the folder to be compressed.

     b. Click File, or right click the folder and then select Compress to ZIP + options or Send To, Compressed (zipped) Folder and verify the location where you want it saved or sent.

Windows will then compress the folder with all of its files and place them in a new file with an icon that resembles a folder with a zipper along the left side of the folder. Again, if your computer is configured to display file extensions you will see the new compressed file has an extension of .zip. This new .zip file can be attached in an e-mail to send multiple files at once in a compressed format. The zip file will take on the name of the folder you zipped, which is most likely appropriate but it may be renamed by right clicking on the zip file (be careful not to remove the zip extension). Don't use fancy characters or punctuation in your zip filename since ANGEL may not accept them when you try to submit via the dropbox.

Back to Top