| CIS 310 Spring 2001 Tasks as of Tuesday, May 15, 4:07 PM | ||||
| Task | Due | Name | Description | URLs |
| G | 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 | CIS Class Information | |
| 1 | Wed, 24-Jan | 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 310 I want to have learned…" and "I expect to earn an grade of X by doing the following..." You should Email your response to me. | |
| 2 | Mon, 29-Jan | Colors | Create a spreadsheet with three columns. In the first column write color names. Format the other 2 column cells in sequential colors (use 10-16 colors). Write the words "sample text" in all cells of the last 2 columns. Format the text as black in one column and as white in the other column. Keep text size normal (around 10 point Times). Print your page and post it on the testbed.uvi.edu site in your selected directory with the name colorsample.html | |
| 3 | Wed, 31-Jan | Simple Loan | Use the example to the right to create a loan comparison spreadsheet. Be sure to get the formatting (including colors) correct. Print the sheet out twice. Once with the formulas showing. Also create a HTML version of the file and post it in the same area. | |
| 4 | Mon, 5-Feb | Stock | Create a summary table for the last two months of the data on your stock data page (links is to the right). The file you are looking for will be in the format gradecode_stock where grade code is your four letter grade code. Your summary table data should be in proper format with columns sorted by stock name. The summary table should show price minimum, maximum, average and range. Create a graph of the average price for all stocks. Transfer the summary table and bar chart to a word processor document. Include a short discussion of the table and chart. Be sure to include which company you would invest in and why in your discussion. All information must fit on one page. Do not include raw data. | |
| 5 | Wed, 7-Feb | Jone's Loan | Mr. Jones wrote a letter stating his understanding of the current balance of his loan. Your boss has asked you to review his record of payments (look for the gradecode_pmts files in the usual places) and write Mr. Jones a letter informing him of what the status of his loan is. Your boss noted that Mr. Jones seemed confused as to what he should be paying and asked that you include the actual payment value he should have been making and amount owed on the loan as of Jan 25, 1997. Also attach a table showing Mr. Jones monthly payments, amount to interest and amount to principal. Make sure that your letter and table look professional. | |
| 6 | Mon, 12-Feb | Sales | Use the sales data found in the file gradecode_saleshwk.html to calculate the ideal re-order level and purchase quantity amount by try systematically changing the reorder and purchase points to find the maximum net profit. Use the purchase quantity as your initial stock amount. Discuss what other variables might be manipulated to improve profit. Include a copy of your sheet showing formulas. The data in blue is sent only so that you may check your formulas. You must use formulas to calculate the blue data. See the notes at the bottom the sheet to create your formulas. You will need to use the IF function. | |
| 7 | Wed, 28-Feb | Solver | These are some solver resources. I meant for this to be an assignment but messed up so everyone gets full points as a bonus. | |
| 8 | Mon, 5-Mar | Histograms | Examine the example histogram display to the right and visit the homework data area to get your own data set. Hand in a sheet that is similar to the example using your data set which is the form code_histogram.html. | |
| T1 | Wed, 7-Mar | Test 1 | Follow the instructions of the test sheet "fish" | |
| 9 | Mon, 19-Mar | Address Label | Use the uviinfo.mdb file to create an internal Mailing label sheet with all persons in the Business Division. Include the Name, Title, Division 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. Make your name appear by putting yourself in the Business Division and by saying your on an island named "A." | |
| 10 | Mon, 26-Mar | Class Reports | Using the data from the website to the right, create reports that summarize Classes showing, average GPA, cumulative units, and student counts. Be sure to put your reports in good form. | |
| 11 | Wed, 28-Mar | Class Standing | Create a report in good form that shows student GPA and age sorted by division and then descending class standing. Redo the report showing the same information sorted by ascending age. Include a summary line for each division. Use the new version of the student file to the right. To calculate the age create a query that creates a field that looks something like: Age: Year(Now())-Year([DOB]). | |
| 12 | Mon, 2-Apr | Car Report | Using the usedcar data base create a report showing vehicle ID, cost, location, transmission description, selling price, count of vehicles, sum of cost, average of cost, sum of selling price and average selling price. You will need to create a linking query. Sort the vehicle's by location with subtotals for each location and the cars overall. | |
| 13 | Mon, 16-Apr | Forms 1 | Create a database that has a table that with fields to recorda a name and address. Next create a form that allows the entry of names and addresses. Print out a copy of your form. | |
| 14 | Wed, 18-Apr | Forms 2 | Use the table at the right to create a form that allows a user to enter in containers and their contents. You will need to create a master and "child" form. The child form will be inserted in the master form document. Note that both tables have a field named container ID. | |
| A | Access Refs | Here are some online resources that may help you learn to use Access. | ||
| T2D | Wed, 2-May | Test 2 | In task 11 you created a report that showed average student GPA and Age sorted by Division. Your test is to create a summary report showing average student GPA, average Age, and cumulative units (sum of units) sorted by instructor. Do not show individual student data. | |
| F | Wed, 9-May | Final | In task 11 you created a report that showed average student GPA and Age sorted by Division. Your test is to create a summary report showing average student GPA, average Age, and cumulative units (sum of units) sorted by class. Do not show individual student data. | |
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).
