CIT-11 Home http://www.c-jump.com/CIT11/CIT11syllabus.htm
Take a look at additional web tutorials on Excel:
Research this week:
A session on office security - please listen:
Password setting and Macro Security Levels:
- this is an Office 2007 link, however, the first part of the link provides good information regarding spyware, viruses and general steps you should take to protect your computer. It's the same link as provided below (the last one under PowerPoint 2007 Links)
(Extra credit if you find security information on the newest version of office and listen/read and send back the address and a comment.
Self-study this week (not to be turned in):
Here is your second Excel Spreadsheet Assignment.
Students who are NOT in health care should do this problem:
Computer Problem: I want you to compare the prices for 4 different computers (different vendors) you might buy. For each computer you will have a base price, 4 different additional items, warranty extension for 1 year, shipping and handling.
Make the title a different font, size and make it bold and italics as well. The title should be centered in a merged cell and it should have a colored background.
Make the column headers two words and have them wrap in the cell
All dollar amounts should be formatted for currency
Calculate the total and highlight the least expensive in one color and the second least expensive in another color.
If you buy over 50 systems you get a discount different vendors offer different discounts two give a percent off and 2 give a specific amount off each machine. Calculate the per machine price if you get a discount. Calculate the total due on 50 systems if you get the discount.
Students who are in health care should do this problem:
Doctor Appointments: I want you to set up an appointment spreadsheet for a small doctors practice. There are 4 doctors that schedule 20 minute visits.
Make the title a different font, size and make it bold and italics as well. The title should be centered in a merged cell and it should have a colored background.
The columns should be for the 4 doctors and they should have the first name above the last line so they wrap in a cell.
Down the side should be the available times for appointments.
Enter the patients name and contact information in the cell.
Count the number of patients that each doctor saw and highlight the doctor who saw the most patients with one color and the doctor that saw the least number of patients in another color.
Calculate if the doctor saw this number of patients every day for a week how many patients would they see per week. If the cost of a visit is $100, how much will each doctor bring in over the week. Making the same assumption, how much would they bring in during a 50 week year. These numbers should be formatted in currency.
Answer the following questions:
Name and explain each of the password options available within a Microsoft Office file.
Where is the password option set? Provide a print-screen of the dialogue box on which you configure this setting.
What is a macro? Why is macro security necessary?
If youve used Office 2003, name and explain the differences between each of the four macro security levels available in an Office file. If youve used Office 2007, explain how macro security is configured.
Which of the following passwords is considered the strongest? Explain why you chose what you chose.
A. andy1234
B. 678AsDf!
C. STRONG
D. 9T$m2G7
You want to password protect a document so that anyone can read it but only people who know the password can modify the document. What settings should you use on the Security tab in the Options dialog box?
Youve forgotten the password to open a password-protected file. What can you do?
Based on your research about current version of the Microsoft office, as well as from Microsoft team, write a set of guidelines for your office staff.
To submit the assignment, email me a copy of your document with all the answers.