D. Nixon: CS 12 > Week 11

Home (CS 12) | Assignments | Tutorials | Examples | Quizzes & Exam | Other Info | Chat

Computer Science 12


Week 11




Sunday, April 26, 2020



Assignment 11 (due next week, unless otherwise specified)

  1. Excel practice
  2. Word: Adding table of contents, bibliography, and (inline) citations to your paper (due next week, May 3)
  3. PowerPoint presentation, draft 2 (due next week, May 3)
  4. Website tutorial
  5. Reminder: Extra-credit project proposals

  1. Excel practice:
  2. Experiment with the PMT, PV, and FV functions, applying them both to loans and to savings accounts with interest. Also, try varying the period of the payments (weekly, monthly, quarterly, annual).

    You are not expected to submit any of this as homework, via email, but you are expected to become fluent enough with the PMT, PV, and FV functions that you can use them on a quiz.

  3. Word: Adding table of contents, bibliography, and (inline) citations to your paper (due next week):
  4. IMPORTANT NOTE: This assignment MUST be done using the downloadable software version of Microsoft Word, e.g. the free Microsoft Word software download that you can do from your official QC email account. Do NOT use the online version of Microsoft Word (Office 365).

    After you submit your paper on problem-solving (see the instructions for Paper on problem-solving, part 3) and receive feedback on it, submit it again, this time adding automatically generated table of contents, bibliography, and inline citations.

    The "Draft 3" version of your paper was required to have a total of four or five main sections: (1) a section on the problem you chose at the beginning of the semester; (2) a section on the week 5 invoice problem, with the discount; (3) a section on the week 5 sales force problem, with employee ranking; and (4) an introduction and/or conclusion containing a general discussion of problem-solving techniques, of which your approaches to the three Excel problems are examples. Each of these four or five main sections should have a heading. At least one of these four or five main sections must also have at least two sub-sections, with sub-headings. Your paper must also contain at least one quote from an online problem-solving tutorial, with appropriate citation.

    If any of the above was not yet done in your "Draft 3" version of the paper, add it now.

    You will now be asked to create an automatically-generated table of contents that will automatically list both the four (or five) main headings and the sub-headings. Before you can create such a table of contents, you must first use appropriate heading styles, as instructed in this week's tutorials. Use the "Heading 1" style for each of the four (or five) main headings, and use the "Heading 2" style for each of the sub-headings.

    You will now be asked to learn how to create an auto-generated bibliography and anto-generated inline citations, which will take a lot of the drudgery out of any future research papers you may write. As instructed in this week's tutorials, use Word's "Manage Sources" feature to enter data for both your bibliography and citations.

    The paper must be a Microsoft Word document with a filename with the following format:

    where "last" and "first" should be replaced by your own last and first name. Also, together with the paper, re-submit the spreadsheet (or a corrected version thereof) that was the focus of Part 1 of your paper. Give the spreadsheet a filename like the following:

    again replacing "last" and "first" with your own actual last and first names. Submit both files attached to a single email message with a subject line like the following:

    HW 11 Paper Draft 4, LastName FirstName

    where "LastName" and "FirstName" should be replaced by your own last name and and first name, respectively.

    For full credit, your paper must show evidence of having used the automatic features mentioned above. To that end, once you add those features, DO NOT edit your paper using any word processing software other than Word 2010 or later, and DO NOT edit your paper using the online version of Microsoft Word (Office 365). If you edit the paper using an incompatible version of Microsoft Wrod, the table of contents, citations, and bibliography will remain, but the evidence of automatic generation will disappear -- it will look like you did them the painstaking old-fashioned way.

  5. PowerPoint presentation, draft 2 (due next week):
  6. See the description of the new section of the PowerPoint presentation you were told to add in the Week 8 assignment.

    Your PowerPoint slideshow, with the new section added, must have a filename with the following format:

    where "last" and "first" should be replaced by your own last and first name.

    Submit the file attached to an email message with a subject line like the following:

    PPT slideshow Part 2, LastName FirstName

    where "LastName" and "FirstName" should be replaced by your own last name and and first name, respectively.

  7. Website tutorial:

    Study the Tutorial on the components of most websites and be prepared to answer questions about it on the upcoming quiz.

  8. Reminder: Extra-credit project proposals:

    See instructions here.


To all information for Week 11  |  To all homework assignments



Example files for this week

Some example files will be uploaded here.

More may appear here before and during our online class session today (April 12).


To all information for Week 11  |  To all example files



Tutorials on Excel topics covered this week

On the PMT (payment), PV (present value), and FV (future value) functions:

It is recommended that you also use Excel's Help feature to get more information on Excel's financial functions.


To all information for Week 11  |  To all tutorials about Excel



Tutorials on Microsoft Word

The following Microsoft Word features are required on the final version of the problem-solving paper, and on any extra-credit papers you write for this class.

  1. Heading styles (needed for table of contents):
  2. Note that the "Heading 1" style should be used for headings of main sections and "Heading 2" style is used for headings of subsections. Your papers will probably be too short to need more than one level of headings. Use only "Heading 1" for your section headings.

    Do NOT use a heading style for the title of your entire paper itself. Heading styles are for section headings. Use the "Title" style for the title of your paper.

  3. Table of contents:
  4. Bibliography and (Inline) Citations:

Important: To ensure that your paper contains evidence that you used these automated features, be sure to edit your document ONLY in Microsoft Word 2010 or later.


To all information for Week 11  |  To all tutorials about Word



Tutorial on the structure of most modern websites

Structure of a typical modern website:


To all information for Week 11  |  To all tutorials about the World Wide Web



Study guide for next week's quiz

The May 3 quiz will be an online quiz including the following:

  1. There will be some Excel problems, which may involve any of the topics covered so far. Be especially prepared for problems involving the financial functions PMT, PV, and FV, and problems involving the logical functions (IF, AND, OR) including nested or otherwise multiple IF, and functions using criteria (CountIF, SumIF, and AverageIF). Also be prepared for problems involving VLookup, the LARGE and SMALL functions, the date-related functions ((DATE, TODAY, DAYS360, YEARFRAC, and the use of simple subtraction to get a time interval in actual days). The questions will include at least one problem in which you are asked to write an appropriate formula to accomplish some particular calculation. The questions may also include fill-in-the-blanks and/or multiple choice questions.

    There may also be some short-answer essay questions (no more than a sentence or two) and/or fill-in-the-blanks or multiple-choice questions about the financial functions, including the time unit conversions that are often needed.

  2. There will probably be a few fill-in-the-blanks and/or multiple choice questions about the Microsoft Word features covered in this week's tutorials: automatically generated table of contents, citations, and bibliography.

  3. There will also be some questions about the following tutorial:   The components of most websites. These questions might include some short-answer essay questions (no more than a sentence or two) as well as fill-in-the-blanks and/or multiple choice questions.


To all information for Week 11  |  To all quiz and exam study guides

D. Nixon: CS 12 > Week 11