D. Nixon: CS 12 > Week 6

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

Computer Science 12


Week 6




Tuesday, October 10, 2011



Assignment 6 (due next week)

  1. Excel assignment:

    1. Continuing the invoice example from last week, with taxable and non-taxable items. Do the same example again, this time using SUMIF. The use of SUMIF will allow you to simplify your spreadsheet, perhaps eliminating a column.

      2. As before, the invoice should have a filename with the following format:

      • last-first-invoice.xlsx

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

      Your invoice must be unique, containing a store name, product names, and prices different from those in files submitted by other students in Computer Science 12.

    2. Table of sales people (continued from two weeks ago):

      3. Continuing the "sales force" exercise from two weeks ago: A little further down on the worksheet, create a separate table containing results computed from the other table. There should be rows for each rank of employee and columns for (1) the total number of employees with a given rank, (2) the total amount of sales by all employees of a given rank, and (4) the average sales by employees of a given rank.

      This spreadsheet should have a filename with the following format:

      • last-first-salesforce.xlsx

    Submit both of the above files in the appropriate area on Blackboard, and have access to the files in lab next week. (The two files should be sumitted separately in the same area on BlackBoard, not in a ZIP file.) We will use them again in future exercises both in lab and in homework.

    where "last" and "first" should be replaced by your own last name and first name, respectively. Also, please have access to this file in lab next week, because we will continue work on your HTML files in future lab sessions and homework assignments.

  2. Paper, draft 3

    3. Write the third draft of your paper. The third draft should be between four and seven pages long, double spaced, with a font size anywhere between 12 and 15. The third draft must have citations, a bibliography, a table of contents at the beginning, and properly formatted footnotes (which will place themselves automatically at the bottom of the relavant page), and at least three sections (in addition to the biblography) than the bibliography) whose headings will appear in a table of contents at the beginning. The bibliography, citations, table of contents, and footnote placement must be automatically generated, and must be re-generatble in Microsoft Word 2010 in the version you submit. (This means you must submit it from a machine which uses Microsoft Word 2010 -- otherwise, there will likely be incompatibilities.) The paper itself must be an original paper, not plagiarized. (Warning: BlackBoard includes the ability to search automatically for possible plagiarism.)

    The paper must be in a file with the following filename:

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


Both the Excel assignment and the draft of your paper must be submitted, via BlackBoard, by no later than the due date, at the beginning of our class session. If you have any trouble submitting them, come early to lab and ask me to help you. (Have access to your files in lab, of course.)


To all information for Week 6  |  To all homework assignments



Excel tutorials

On COUNTIF, SUMIF, AVERAGEIF:

It is recommended that you also use Excel's Help feature to get more information on all of the above.


To all information for Week 6  |  To all LINK_TO_CATEGORY_TUTORIALS_Excel



Tutorials on Microsoft Word

Citations (needed for bibliography, and should be used after all quotes):

Bibliography:

Footnotes (to be used NOT for citations but for small digressions):

Numbered headings (optional):

General tutorials and FAQs on matters relevant to writing an academic paper:


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



Study guide for next week's quiz

On Friday, October 14, we will have our usual brief (10 to 20 minute) quiz at the beginning of class. (Please arrive on time or early.) The October 14 quiz will be an on-paper quiz having two parts:

  1. Excel: mostly about Excel formulas involving the functions that have been covered in lab and/or in tutorial material. These include SUM, COUNT, AVERAGE, MIN, MAX, IF, AND, OR, COUNTIF, SUMIF, and AVERAGEIF, and also the basic arithmetic operations (addition, subtraction, multiplication, and division), plus the date functions. Given an on-paper picture of an Excel spreadsheet, you will be expected to be able to write appropriate formulas for specified cells.

    2. There will also be some multiple-choice and fill-in-the-blanks questions. Likely topics covered include the Excel date functions and the difference between absolute and relative cell references.

    To prepare for the quiz, the main thing you will need is practice using all the above-named Excel functions. To that end, it is recommended that you not only do the homework but also play with examples in the tutorials. Make sure, especially, that you are comfortable with COUNTIF, SUMIF, and AVERAGEIF, and also with nested IF functions and logical expressions involving AND and OR.

  2. Microsoft Word: A few brief fill-in-the-blanks or multiple-choice questions on the use of Microsoft Word's automatic generation of bibliographies, citations, and footnotes.


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

D. Nixon: CS 12 > Week 6