| CIS 310 Spring Y2K Tasks as of Wednesday, January 17, 9:09 AM | ||||
| 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, 19-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, 31-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 | Mon, 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. | |
| 4 | Wed, 2-Feb | Excel HTML | Convert the file you created in the "Simple Loan" task into an HTML file then use FTP to create a directory with your name under the CIS310 directory on testbed.uvi.edu (user ID: cis310/password: cis310). Put the file in your directory with the name "simpleloan.html." Email me at CIS310@balch.org with the URL when you have the file uploaded. Be sure to include the http:// protocol header as part of the URL. | |
| 5 | Mon, 7-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. | |
| 6 | Save | Copy and paste the savings template and data posted on the web with the name "classcode_savings.html" where the classcode is the four letter code assigned to you. Replace the format samples with appropriate formulas, then format the numbers as shown. Note that everyone has different data. Print the sheet twice: once with "View Formulas" and once with the calculated values showing. | ||
| T1 | Test 1 | Follow the instructions of the test sheet "fish" | ||
| 7 | 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. | ||
| 8 | Sales | Use the sales data found in the file gradecode_saleshmw.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. | ||
| 9 | Excel HTML 2 | Convert the file you created in the sales task into an HTML file then post the file to the CIS357 directory on testbed.uvi.edu (user ID: cis357/password: cis357) with the name "salesgradecode.html" where gradecode is your four letter grade code. Email me at CIS310@balch.org when you have completed your work. | ||
| 10 | Macro | Write a macro that finds the best values for task 8 automatically. | ||
| 11 | 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. | ||
| 12 | Access HTML | Convert the file you created in the "Class Reports" task to HTML and post it with the name ClassReportsGradeCode on the testbed.uvi.edu server. | ||
| 13 | 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]). | ||
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).