| CIS 101 Tasks as of Monday, July 26, 11:04 PM | ||||
| Task | Due | Name | Description | URLs |
| G | #N/A | Grade Info | Please note that October 6th is the last day to drop a class without a passing/failing notation being placed in your transcript. Mid term low grades are due on October 15th. October 21 is the last day to drop without special permission from the Dean. Your class and grade information is always available at http://www.uvi.edu/cerit/cis.htm | |
| 1 | Tue, 22-Jun | Goals | Write a short essay (a page is fine) stating your goals for this course. Complete the statements "At the end of the semester, in CIS 146 I want to have learned…" and "I expect to earn an grade of X by doing the following..." Your essay should be word processed or Emailed and include appropriate personal information. If you are going to send this assignment via email, you must place the message in the body of the Email. Do not send it as a file attachment. | |
| 2 | Wed, 23-Jun | Send an Email message to me stating that you understand how to use Email. Also note if you find your secret code acceptable. You may request another code. Your Email must be from your Email account and have a subject heading. | ||
| 3 | Thu, 24-Jun | Letter | Write a letter to some public person about any topic that you care to write. The person need not be living and your letter does not have to be serious. You do not have to sign or send the letter. Be sure to include all appropriate task information. Use a letter head, proper grammar and spelling. Save the letter in the directory A:/letter | |
| 4 | Tue, 29-Jun | SS Times | Create a Spreadsheet that shows a times table. Your sheet should look like the one to the linked at the right. You must include colors. Don't forget to include the taskheaders. Print the sheet twice, once with the formulas showing and once with the values. To show and hide formulas, selection Options from the Tools menu and then click on the formuals check under the view tab. | |
| 5 | Wed, 30-Jun | Present | Create an electronic presentation promoting STT as a tourist destination. Use appropriate graphics. You will show your presentation in class. | |
| 6 | Mon, 5-Jul | Personal HP | Use Micosoft word (or the HTML editor of your choice) to create a HTML home page for yourself. Your home page must include at least one picture and a link to another page. Once your page is complete, you need to use WSFTP (or other FTP pragram) to post the file to the /student directory of the testbed.uvi.edu server. Use the Account cis101 with the password cis101 to log in to testbed.uvi.edu. Add a directory using the format FLLLLLL where F is the first letter of your first name and LLLLLL is the first six letters of your last name. Email me with the appropriate URL when you have sent your page. I will bring my Digital camera to class if you want to include your picture on your page. | |
| 7 | Tue, 6-Jul | Translation | You will translate from English to another language then back to English to see how well translation software works. In any word processor, write a few paragraphs introducing yourself to a resort manager in a foreign country. 1) Briefly introduce yourself and whomever you plan to travel with by name and relationship to you 2) Briefly describe where you work, study and live. 3) Briefly describe some activities you wish to participate in while visiting. Say that you are looking forward to having fun on your visit. Now select and copy your paragraphs then go to the web site http://babelfish.altavista.digital.com/cgi-bin/translate and paste. Select English to French and press the Translate button. Copy and paste the translation into your document then go back to the original translate page and paste the French translation into the box. Select French to English then press the Translate button again. Paste this translation i | |
| 8 | Thu, 8-Jul | SS Loan | Follow the example of the example loan sheet link to the right. Print the sheet twice once with "View Formulas" selected and once with the values. Be sure to use named ranges for cells. | |
| 9 | Mon, 12-Jul | First Draft | Write the first draft of your term paper using your first assigned topic and the paper specification in the calendar area of the CIS page. This counts as a task. Inform me via Email if you wish to switch topics. | |
| 10 | Tue, 13-Jul | Find Prices | Using magazines from the library and/or the Internet: Find the "best" prices on the following Windows software: Microsoft Office Professional, Quicken Deluxe, WinFax Pro, and Microsoft Publisher. Hardware: Price and describe the configuration of a minimal computer to run all of the above software. Include a list of the references that you used. | |
| 11 | Thu, 15-Jul | Quicken | Visit the web site at the right and review the two files in the format code_bankstatements.html and code_personalrecords.html where the code is your grade code. Enter the first half of your personal records into quicken then reconcile using your first bank statement. Repeat with the second set of records. After your second reconcilliation, print a cash flow report. Customize your reports to include your name in the title. | |
| 12 | Mon, 19-Jul | Find Text | Combine the four files described below to complete a quote. Email the completed quote back to me. The files can be found at | |
| 13 | Tue, 20-Jul | Scheduling | Use Excel to create two schedules in good form with. 1) with days at the top names on side; 2) days at the side and names on the top. Your schedule should show the number of hours worked for each person. There are five persons (Ann, Tim, Sue, Jim, and Ben). You need to cover seven days with persons working from ten AM to Nine PM. There are two shifts to work with (Ten to Five) and (Four to Nine). Ann won't work on Saturday. Tim and Ben won't work Sundays. Tim and Jim want two days off in a row. They don't care which days. Saturday and Wendsday require two persons on the job from ten to five. On Saturday and Wendsday one of the persons working during the day must be Ann, Tim, or Ben at all times. Jim Prefers to work evenings. All persons should work about 20 hours a week and no more than eight hours in a day. All persons should work about the same hours. | |
| 14 | Wed, 21-Jul | Library | This class meets in the library. In this session, you will learn the use of the library, electronic references and the CD-ROM Lab. Your assignment is to hand in a typed paper that answers the questions in the library handout. Your answers are due on Wed, 8 July 98. | |
| 15 | Thu, 22-Jul | Mail Merge | Word: Use the files "mailmergeletter.doc" and "mailmergedata.doc" to create five letters. To create the letters: | |
| 16 | Thu, 22-Jul | Address Label | Use the uviinfo.mdb file to create an internal Mailing label sheet for all persons in the Business Division. Include the Name, Title, Department and Island fields. Sort by Island then Name. Print the data as if it were going on Avery 5260 mailing labels(left/right border .25", top/bottom .5", 3 columns, .25" label gap, 3 columns). You may print on regular paper. Put your name and task information in a fake address at the top. | |
| P1 | Wed, 7-Jul | Paper 1 | Be sure to follow the specification noted to the right. Inform me via Email if you wish to switch topics. | |
| T1 | Thu, 15-Jul | Test 1 | Use the example at faculty.uvi.edu/cis/homework/code_retirement where code is your grade code to create the page described. Be sure to use color and to format your numbers. Note that everyone has different data. Print the sheet twice: once with "View Formulas"selected (found in the tools, options, View) and once with the calculated values showing. | |
| FP | Mon, 26-Jul | Final Project | Write a fact sheet on your assigned company. Use the format and company described to the right. Remember to work smart. Much of the required information can be found in the libary's business reference section. At anytime before the project is due, you may hand in your work for review and corrections. You do not need to normalize the data as stated in the instructions. I give bonus points for new references of general use in this assignments. | |
This table was created by a free Excel macro written by Charles Balch.
Here's the code. It is care ware - it's yours for free if do something nice for anyone (anyone includes you).