Fall 2008 CIS 120 Class Tasks
Task #AssignmentApplicationDescription
0Introduction Document & 1) Google DocsMicrosoft WordCreate 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.
2Topic SelectionMicrosoft WordSelect 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.
3WebpagePublisherUse 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.
4PaymentsExcelUse 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?
5Video EditingMovie MakerCreate 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:

  • A title at the beginning
  • Transitions with an effect
  • At least one video effect on at least one segment.
Do not worry about sound. Once you have completed your clip, show it to me in the lab or post it online on a service like uTube and send me the link.
6LetterMicrosoft WordWrite 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.
7Web tasksWebYou 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."
8AddressesAccessYour 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.
  1. Save a copy of the AWC phone database to a known location such as "user files" on campus or "my documents" at home then open it in Access. Note: If you just open this link the database will be read-only and unusable. You must save.
  2. If the ribbon is minimized, right click the ribbon bar and uncheck the minimize option.
  3. You want to create a query that looks like this. Select the "Create" ribbon and press the "Query design" button.
    1. Add TableAWC then close the "Show Table" option
    2. Add the "Department," "Name," "Title," "Phone," and "Email" fields to the query in that order (it's easiest to do this by double clicking on them in the Table AWC list)
    3. Select Ascending by pressing the triangle that appears when you click below the field name on the sort line for Department and Name. This will sort first the department then the name.
    4. Filter the names by adding "*prof*" to the Title Criteria line. Note: the wildcard * matches any text before or after prof.
    5. If your Query looks like the example, use the save option. Save the query with the name Query Profs. .
  4. Select the "Create" ribbon and press the "Report Wizard" button.
    1. Insure that Queryprofs is showing in the "Tables/Queries" drop down selection area of the first report wizard screen and select all the fields in order (it's easiest to press the ">>" button. Click Next to get grouping
    2. Select "Department' and press the > key. Group by Department only and press next.
    3. Use the pull down selection area to sort by Name
    4. Use the "Stepped layout" and the "Landscape" orientation (use landscape to insure that each record fits on a line). Note: If you do not see the "Stepped Layout" option you made an error on an earlier step. Leave the adjust field width option checked and press Next.
    5. Accept the default "Office" style or choose one you like more and press Next.
    6. Title your report "AWC Faculty List by Department" and press Finish.
    7. Note that the department names and some other fields are truncated (cut-off). Press the "Close Print Preview" button to enter the report design view so you can fix the truncated fields
    8. In the Department Header area, click "Department" and make the text box wider by hovering over the right line of the box until you get the two way arrow the click and drag the box bigger.
    9. Add a label by clicking on the "Aa" button in the "Design Ribbon" and draw a label box in the "Report Header" area. Type your name, class section, and "task number 8: Addresses" in the address bar.
    10. From the Office Button list, select print preview and check that your report is acceptable.
  5. If acceptable, print just the first page of your report or send the file if you are taking this class online.
9Google DocsGoogle DocsOur 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.
  1. Follow this link to sign up for a Gmail account.
    1. Optionally you might want to have email to this account forwarded to another account. If you want to forward your email, enter your Gmail account home page, visit settings, then forward to the email account you typically use. Save your changes.
  2. Enable your account for Google Docs by going to Google Docs and signing in.
  3. d me an Email at Charles.Balch@azwestern.edu with your Google Docs activated account.
  4. I will then send you a message that invites you to collaborate on a document.
  5. The information you will add is created when you complete the learning tests at Kolb Learning Style and Jung Typology Test. Take the tests and review your results. Be sure to explore the various analysis options so you can discuss your results.
  6. When you are ready to share and discuss your scores, logon to Google docs and share your results with the class. Note: If you can't edit the document, you have not logged on with your "new" Google account.
10TranslateWebTranslate 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.
11RetirementExcelCreate 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
12Google DocsGoogle DocsIf 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.
13Mail MergeAccess and Microsoft WordCreate 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.
14Stock TrackingExcelUse 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.
15Linear EquationsExcelWe 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.
16Photo EditingGimpGive 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.
  1. Get a copy of GIMP or GIMP Portable. If you are in the lab, you can get a copy portable GIMP from our lab->Balch->Portable Apps->GIMP area. On campus, put your copy of GIMP someplace you have control of like a flash drive.
  2. Right click and save as to a known location the following pictures Alex in Agde and Tropical Beach.
  3. Launch GIMP and from the Tool Palette use the File Menu option "Open" to load the Tropical Beach and then from the picture
  4. Use the File menu option "Open as Layer" to open Alex in Agde pictures (FYI Alex is my wife).
  5. From the Picture Window use the File menu select "Save As" and save the file with the GIMP XCF file type selected.
  6. Select the lasso from the Tool palate and loosely select Alex, then invert your selection, and remove everything but Alex and the background close to her with Edit -> cut.
  7. Change your image zoom level and eraser size to carefully remove all of the original background from Alex and let the beach image show
  8. Use the four way arrow tool to move Alex to the bottom left of the beach (but not exactly like I did below)
  9. Use the Dodge Tool to brighten up Alex's face
  10. Use the image file menu to "Save a copy" and select the file type extension JPEG. You will be warned that this will flatten the image but that's what you want so press the Export button.
  11. In class, print a copy. Online, send me the picture as an attachment.
Notes: There are many good GIMP tutorials on the web.
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!
17PresentationsPowerPointCreate 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.
CPClass PresentationPowerPointYou will make a class presentation of your earlier PowerPoint presentation.
F01FinalFinal 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 1LibraryComplete 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 2TBATBA
LDLabor DayHoliday
M1Midterm 1Midterm is in lab. After the midterm, you can work on your missing and partial credit lab assignments.
M2Midterm 2Midterm is in lab. After the midterm, you can work on your missing and partial credit lab assignments.
MRMidterm ReviewMidterm review. Discussion of what will be on the midterm and study session.
OSOpen SessionOpen Session - Catch up on your work.
FPFinal Paper DueYour 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.

FPRPaper ResourcesYour 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

CCCampus Closed
Campus was closed as a result of electrical problems.

This table was created using a free Excel macro written by Charles Balch.