| Fall 2008 CIS 120 Class Tasks | |||
| Task # | Assignment | Application | Description |
| 0 | Introduction Document & 1) Google Docs | Microsoft Word | Create a document and place your name in large type at the top of the page. Complete the following sentence "By the end of the semester I intend to get a grade of ______ by doing the following:
You might get ideas of what you will do to earn your grade from reading the supplement to the syllabus. Write a paragraph or two about yourself. Let me know where you grew up, why you are attending AWC, any family issues that might influence your work in class, if you have a job outside of class, and your experience with computers. Include a section describing the extent of your computer experience and what you would like to be sure to learn in this introduction to computer class. What are your hobbies and or interests? Check your document for grammar and spelling errors. If you have a public online presence such as through Facebook or a blog, please provide me with the address. |
| 2 | Topic Selection | Microsoft Word | Select a computer related topic then write a few paragraphs about why you selected the topic.
Do some initial research on the topic then write a few paragraphs about the topic as you now understand it. Be sure to include a definition, why the topic is important, and where you did your research. All writing should be in your own words. Your paper should be in good format. You can use one of the topics provided at topic list or choose a different computer related topic. You will be using this topic for a class presentation and for your final paper. All topics must have my approval. |
| 3 | Webpage | Publisher | Use Microsoft Producer to create a website in your AWC web page area or create a page using a free service such as YouTube or Google Sites. Note that, while your AWC web area is accessible to the world, nobody will see your web page unless you let them know to follow the link. You may also remove your web page after you have received full points for this assignment.
Your site should have at least one graphic, no spelling errors, and at least two links to places that you think are interesting. Describe your links. You might consider using some of the material you created it task one for the content of your web page. In class print out your page from the website or online Email me a working link to your website. |
| 4 | Payments | Excel | Use Microsoft Excel to create a Spreadsheet that calculates the loan payments and total payments for the life of a loan. Use a principal of $200,000 and all the conventional mortgage rates you can find from BankRate.com. Calculate for 15, 20, 25, and 30 years. If handing in hard copy, print the spreadsheet twice. Once with the formulas showing and once with the values showing. The printout with the numbers must be one page. The printout showing the formulas can be more than one page. Here's how the value version should look Payment Example. Your numbers should vary as you will be using the latest rates from BankRate.com. Use the PMT function to calculate the payment.
Create a discussion area on your SS to discuss what you found out about the total amount paid versus the size of monthly payments. Try changing the interest rate by a point. How much does that change the amounts? What would your considerations be if you were taking out a loan? What term would you choose if you were getting a loan? |
| 5 | Video Editing | Movie Maker | Create a movie about a minute in length using the raw video provided in class. Your finished movie should have a number of effects, starting/ending titles, text titles, video transitions between segments and at least one special effect. We will use Windows Movie Maker to make the movie. Movie Maker is found on your computer using Windows Explorer (Windows Key - E) and looking in the "C:\program files\Movie Maker" directory. Just double click on Movie Maker to start it. If you want to use Movie Maker often, drag the icon into your start button then into all programs. There is a 50 Meg (very large) movie that you can edit at Ben.wmv or you can use a video clip of your choice but your starting clip must be a clip that you can use legally. I.E. Don't use a downloaded clip unless it is public domain. After you have your selected clip, edit it down to one minute. Your completed movie should include:
|
| 6 | Letter | Microsoft Word | Write a letter to a public official addressing an issue of concern to you or to the manager of a store where you recently had good service. You must include the correct sending address but you can have a "fake" return address. The letter should include a graphic and have your return address in the top right. There should be no grammatical or spelling errors. See an example. |
| 7 | Web tasks | Web | You will be posting at least four messages. Two postings will be topics started by you in the Blackboard "Bulletin Board" area.
Message 1: Go to the Blackboard website and put a message in the message area discussing your topic and why it is important. This is the topic that you selected in task 2 and that you will write your paper on. Message 2: Put a question or observation about chapter six (The Internet) in the Blackboard discussion area. Messages 3 & 4: Question or comment on two fellow students' messages in message areas 1 & 2. Visit again a couple days later and respond to any students' questions. Your message should be more substantial than just saying something like an "interesting topic," "Good Post," or "I agree." |
| 8 | Addresses | Access | Your goal is to manipulate a database to create a report that shows faculty members sorted by name and grouped by department. Databases use tables to store information, queries to organize the information, and reports to show the information. For this exercise, the table has been created for you.
|
| 9 | Google Docs | Google Docs | Our objective is to enter some test data into a shared document. To use a shared document you will need to create a Google account, enable that account for Google Docs, then send me the account information. Once I have your account information, I'll share the document with you. Here are the steps.
|
| 10 | Translate | Web | Translate a short letter from English to another language then "round trip" back to English.
Using French and Spanish as examples (you may use any language), create a document with the following headers: English English to French English to French to English Discussion of French Round Trip English to Spanish English to Spanish to English Discussion of Spanish Round Trip General Discussion of Computer Language Translation In the English section write a few paragraphs introducing yourself to a resort manager in a foreign country. 1) 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. 4) Say that you are looking forward to having fun on your visit. 5) Paste your in at http://translate.google.com translate to another language (such as French). 6) Paste the translation into your document in the appropriate area then go back to the original translate your content back to English and place it into your document under the appropriate heading. 7) Discuss the final result. Is it humorous? Accurate? Would you understand it if you read it? --- Repeat the above procedure using a different language (such as Spanish). Finally, discuss the general value of language translation software. Do you think it is good enough for business use? How about personal use? Would you trust it for description of medical problems? Did the translations give you some idea of the usual problems that people learning English encounter? If you are fluent in either language you selected, discuss the quality of the first generation translations. |
| 11 | Retirement | Excel | Create a spreadsheet that helps to calculate how much money you will save with various retirement plans as shown in the Retirement Assignment example.
Find a monthly retirement savings amount that you think you can be happy with both now and when you retirement. Include a discussion about the amount of money that you will save each month towards your retirement and the amount of money you will have to spend after retirement. You can get an idea of some realistic interest rates at |
| 12 | Google Docs | Google Docs | If you do not have a Gmail account, please create an account the go to Google docs then send your address and class info (be sure to include the section) to me at charles.balch@azwestern.edu. I will then send you additional instructions.
Note: Some of you managed to complete this exercise when we tried it earlier this semester. You will receive full credit for the exercise in both areas if you complete this exercise now or have already completed the exercise. |
| 13 | Mail Merge | Access and Microsoft Word | Create a query in the NWind.mdb database that discovers all USA customers who purchased Tofu, then create a mail merge letter in Microsoft Word than sends an announcement that NWind will now be selling reduced fat and reduced taste Tofu in addition to the traditional line to those customers. In addition to the address and salutation, the body of your letter should also include a merge field.
Only print and hand in the first two letters. Also print a copy showing your merge fields. |
| 14 | Stock Tracking | Excel | Use the historical weekly stock prices from January 2000 to the present for two technology sector company stocks symbols to create a summary table showing your two stocks and the DJI Max, Min, range, Mean, and Standard deviation. Also create graphs for each of the stocks performance. Place these tables and graphs into a MS Word document and discuss your findings. Be sure to discuss any significant trends or dips in the stock values. Reference these significant events by date. How much profit would you have made if you could have invested a thousand dollars at the lowest stock price and sold at the highest. Would you suggest buying this stock now? Why or why not?
You can get stock information at Yahoo Finance. |
| 15 | Linear Equations | Excel | We will be looking at the optimal mix of production of a company that has three departments and creates three products. Each department has a limited number of resources available and each product takes a different amount of hours from each department to make and has a different profit. You want to discover the profit in a variety of scenarios including the best or optimal profit. We will first run through this program with some test production numbers then a different set of numbers will be given in class.
Solver is an Excel addin that uses linear programming to discover the optimal mix of different variables. To add solver, press the office button, then Excel options at the bottom of the pop-up window, select add-ins, press the manage add-ins button, and check the solver checkbox. Solver is no available to you in the "data" ribbon. You will use solver as one method to find the seven product mixes described in the solver spreadsheet. The solver SS can be found at solver.xls. You can create Solver scenarios by selecting "Solver" from the "Data" ribbon. There are also two macros associated with this spreadsheet. You can review the macros by going to the "Developer" ribbon and selecting view code. (Make the developer ribbon available by pressing the office button, selecting Excel options, and then check the "Show Developer Tab in the Ribbon" option. Run the macros by pressing the associated buttons next to their scenarios in the SS. |
| 16 | Photo Editing | Gimp | Give someone a virtual vacation! Adapt a pictures of your own or use the pictures supplied below to create a new picture. If you use the ones below, substitute the tropical background for the canal background. Feel free to creatively add some additional items. Please no inappropriate content.
Instructions: We will be using the Freeware program GIMP to do our editing.
Your picture should look something like this but put Alex a little more to the right so I know you didn't send me a copy! ![]() |
| 17 | Presentations | PowerPoint | Create a PowerPoint presentation on the topic that you chose earlier. Your presentation should have at least five slides with at least three points on each slide.
Your presentation should be in good form and include slide transitions. Good form means that you have only five to seven words for each point you want to make. Do not put the entire text of what you intend to say on the slides. Here is a good PowerPoint review that supplements your text. You will make your presentation in class. |
| CP | Class Presentation | PowerPoint | You will make a class presentation of your earlier PowerPoint presentation. |
| F01 | Final | Final Exam Dates. The final is in the lab and will follow the format of the midterms. Wed. Dec. 10 8:30-10:30 AM |
|
| F03 | Final Exam Dates. The final is in the lab and will follow the format of the midterms. Mon. Dec. 8 1:40-3:40 PM |
||
| F04 | Final Exam Dates. The final is in the lab and will follow the format of the midterms. Thr. Dec. 11 8:30-10:30 AM |
||
| F07 | Final Exam Dates. The final is in the lab and will follow the format of the midterms. Tue. Dec. 9 1:40-3:40 PM |
||
| Guest Lab 1 | Library | Complete the work assigned in class. Be sure to complete both sides of the paper and to select a reference related to your topic. | |
| Guest Lab 2 | TBA | TBA | |
| LD | Labor Day | Holiday | |
| M1 | Midterm 1 | Midterm is in lab. After the midterm, you can work on your missing and partial credit lab assignments. | |
| M2 | Midterm 2 | Midterm is in lab. After the midterm, you can work on your missing and partial credit lab assignments. | |
| MR | Midterm Review | Midterm review. Discussion of what will be on the midterm and study session. | |
| OS | Open Session | Open Session - Catch up on your work. | |
| FP | Final Paper Due | Your goal is a short, scholarly and informative fact sheet on the topic you have selected and I have approved. Your term paper should be concise, complete, and focused on your topic. In particular, for many topics, it is very easy to find specific product information from companies that advertise on the Internet or in trade magazines. Parroting such literature is not appropriate to your paper. Keep the mention of specific companies and products minimal and justified.
Your paper should be mostly in your own words. All words that are not your own must be within quote marks with an attributed source. According to the AWC Code of Conduct plagiarism is "passing off the ideas or work of another as one's own without crediting the source." Further, as stated in the catalog, plagiarism is academic dishonesty and grounds for an automatic "F" on your paper. | |
| FPR | Paper Resources | Your paper should be in the APA format with both inline references and a reference page. All papers are submitted both through Blackboard and as hard copy. Your hard copy must be accompanied by a pink slip from the AWC Writing Lab showing they have reviewed your paper. Useful links
| |
| CC | Campus Closed | Campus was closed as a result of electrical problems. | |
This table was created using a free Excel macro written by Charles Balch.