Note: On all emails for this course, start the subject line out with IST2300, followed by whatever else is appropriate. Emails without this subject line formatting may not be accepted! HW1: Word Project 4. Filename(s): "Charity Auction Proposal.docx" and "Charity Auction Title Page.docx" Due: Tues, 1/19 --------------------------------------------- HW2: Word Project 4, In The Lab 1. Filename(s): "Lab 4-1 Clean Fleet Auto Proposal.doc" Due: Wed, 1/20 --------------------------------------------- HW3: Excel Project 4 Due: Tues, 1/26 --------------------------------------------- HW4: Excel Project 4, In the Lab 2 Filename(s): "Lab 4-2 The Bean Bag Game Company Quarterly Income.xlsx" (See link 6 above for a hint on the Data Table!) Due: Tues, 2/9 --------------------------------------------- HW5: Excel Project 4, In the Lab 4 (In class lab) Filename(s): "amortization-table.xlsx" Due: Mon, 2/8 --------------------------------------------- HW6: Access Project 4 Filename(s): "JSP Recruiters-Chapter4-Start.accdb" Note: Be sure to copy the startup file from the S: drive to your R: drive and work on it. Do NOT just click on the file on the S: drive - you won't be able to save your work! Due Wed, 2/17 --------------------------------------------- HW7: Access Project 4, In the Lab 2 Filename(s): "JMS TechWizards-Chapter4-Start.accdb" Note: Be sure to copy the startup file from the S: drive to your R: drive and work on it. Do NOT just click on the file on the S: drive - you won't be able to save your work! Due Fri, 2/19 --------------------------------------------- HW8: Word Project 5 Filename(s): "Health Club Form Letter.docx", "Health Club Members.mdb", "Health Club Mailing Labels.docx", "Health Club Envelopes.docx", "Health Club Member Directory.docx" Due: Monday, 3/1 Notes - This is a challenging project! It has several different documents, all of which must be created correctly and saved correctly (filenames AND folders!). Be sure to follow the text directions on page 321 carefully. You want to save all your files in the "Total Fitness" folder on your R: drive. --------------------------------------------- HW9: Word Project 5, In The Lab2 Filename(s): "Lab 5-2 Booster Club Form Letter.docx", "Lab 5-2 Booster Club Envelopes.docx", "Lab 5-2 Booster Club Labels.docx", "Lab 5-2 Booster Club Directory.docx", "Lab 5-2 Booster Club Members.mdb" Due: Tuesday, 3/2 Even if you finish this assignment early, be sure to come to class Monday! We are going to start on In the Lab4 for Word Chapter 5 and you need to be here! --------------------------------------------- HW10: Word Project 5, In The Lab4 Copy the folder "In-the-Lab4-mail-merge" from the S: drive to your R: drive. Do all the instructions found in the itl4.doc file. Use itl4_formletter.docx as your main document. Use playerlist.mdb as your data source. Due: Wednesday, 3/3 --------------------------------------------- HW11: Excel Chapter 5 Filename(s): "Silver Photography Accessories Sales Rep Table.xlsx", "Silver Photography Accessories Sales Rep Table CSV.csv" Notes: Follow the instructions in the text VERY carefully! Be especially careful when naming cells or regions of cells. Follow capitalization and watch carefully for any extra spaces anywhere in a name. Also be very careful to highlight exactly what the book tells you to! Some regions are treated differently than others. Be careful not to skip any steps. Due: Tuesday, 3/9 --------------------------------------------- Wednesday, 3/10 - We will take Test 2 over Word Chapter 5. Bring your textbook if you will need it for reminders of how to do anything. The test will cover creating filters from an already existing datasource and main document. You will also need to create several merge-documents (like we did in ITL4) and an envelope or mailing labels document like we did in Word Chapter 5. --------------------------------------------- HW12: Excel Chapter 5, In the Lab 2 Filename(s): "Lab 5-2 Consultant Specialist Table.xlsx", "Lab 5-2 Consultant Specialist Table Final.xlsx", Notes: Follow the instructions in the text VERY carefully! Be especially careful when naming cells or regions of cells. Follow capitalization and watch carefully for any extra spaces anywhere in a name. Also be very careful to highlight exactly what the book tells you to! Some regions are treated differently than others. Be careful not to skip any steps. Due: Friday, 3/26 (After Spring Break!) --------------------------------------------- HW13: Access Chapter 5 Filename(s): "JSP Recruiters-Chap5Start.accdb" Note: Be sure to copy the startup file from the S: drive to your R: drive and work on it. Do NOT just click on the file on the S: drive - you won't be able to save your work! Due Mon, 3/29 --------------------------------------------- HW14: Access Chapter 5, ITL3 Filename(s): "ADA Beauty Supply-Chap5Start.accdb" Note: Be sure to copy the startup file from the S: drive to your R: drive and work on it. Do NOT just click on the file on the S: drive - you won't be able to save your work! Due Wed, 3/31 --------------------------------------------- HW15: Word Project 6 Filename(s): "Health Bits Newsletter.docx", "Hand and Eye Chart Modified.docx", Due: Tuesday, 4/6 Notes: This is a fun project! We create a newsletter. In this project you will use some graphics and files from the data disk (on your S: drive). As usual, follow the instructions CAREFULLY, don't miss any steps and everything should work ok. There should be two files saved in this project. --------------------------------------------- HW16: Word Project 6, In the Lab 3 Filename(s): "Lab 6-3 Eleventh Frame Newsletter.docx", Due: Wednesday, 4/7 Notes: This is a fun project! We create a newsletter. In this project you will use some graphics and files from the data disk (on your S: drive). As usual, follow the instructions CAREFULLY, don't miss any steps and everything should work ok. --------------------------------------------- Friday, 4/9 - We will take Test 3 over Word Chapter 6. Bring your textbook if you will need it for reminders of how to do anything. The test will cover creating a newsletter using the techniques learned in Chapter 6 and In the Lab 3. A good way to study would be to see if you can do one of the other In The Labs (1 or 2 or both) in about 40 minutes time. If you can, you should be ready to take the test and do well on it. --------------------------------------------- HW17: Excel Project 6 Filename(s): "NextDVR Profit Potential Template.xltx", "NextDVR Profit Potential.xlsx", "NextDVR Workspace.xlsw", Due: Monday, 4/19/2010 You need to copy four files from the S:\ drive or from the website. Copy them to your R:\ drive to use for this project. They are NDVR Kansas City Profit Potential.xlsx, NDVR Louisville Profit Potential.xlsx, NDVR Portland Profit Potential.xlsx, and NDVR Company Profit Potential.xlsx. Use these four files to create and save the workspace file on pages EX485-491. No matter what the book says about finding the files and using them, copy them from the S:\ drive to your R:\ drive and use the files in your R:\ drive for this part of the chapter. --------------------------------------------- HW18: Excel Project 6, In the Lab 1, Parts 1 and 2. Filename(s): "Lab 6-1 Part 1 Rings and Things Annual Sales Analysis.xlsx", and "Lab 6-1 Part 2 Rings and Things Annual Sales Analysis.xlsx", Due: Monday, 4/19/2010 Be sure to save all your files on your R:\ drive! This is a detailed and somewhat complicated project, so it will require careful attention and some trial and error. Be sure to save your work often. If you aren't sure you are understanding what the text is asking you to do, I suggest the following steps: 1) Re-read the part you aren't understanding. 2) Look back at your Excel Project 6 workbook and see how you did it there. 3) Go back and re-read the text where it showed how to do it in chapter 6. 4) Your best buddy is page EX491! --------------------------------------------- HW19: Access Project 6 Filename(s): "JSP Recruiters-Chap6Start.accdb" Due: Thurssday, 4/22/2010 Notes: Read these notes before starting the project! I have put a startup file to use for this chapter. It is on the S:\ drive and is named "JSP Recruiters - Chap6Start.accdb". Copy this file to your R:\ drive and this file for all your chapter 6 work. Follow the text carefully and you should not have any problems. If something doesn't seem to work out correctly, delete it and try again! Be sure not to leave out ANY steps ANYwhere! You may have to get through with the project before it really starts to make sense to you. By the time you finish this project and the next In the Lab assignment, you should have a good idea of what it takes to create a menu in Access and what role the macros serve in that process. --------------------------------------------- HW20: Access Project 6, In the Lab 1 Filename(s): "JMS TechWizards-Chap6Start.accdb" Due: Tuesday, 4/27/2010 Notes: Read these notes before starting the project! I have put a startup file to use for this chapter. It is on the S:\ drive and is named "JMS TechWizards-Chap6Start.accdb". Copy this file to your R:\ drive and this file for all your chapter 6 work. Follow the text carefully and you should not have any problems. If something doesn't seem to work out correctly, delete it and try again! Be sure not to leave out ANY steps ANYwhere! You may have to get through with the project before it really starts to make sense to you. ---------------------------------------------
Created on ... Jan 15, 2010
Last updated on ... Apr 22, 2010