A useful link

With some basic explanation about some advanced features in Excel.

http://oit.montclair.edu/documentationpdf/excel_advanced.pdf

Excel topics (tentative)

1. Creating, opening and saving a spreadsheet. Page setup, printing.
2. Find and replace (including all wildcards).
3. Grouping and ungrouping worksheets. Copying a worksheet, inserting a blank worksheet.
4. Absolute, relative and mixed cell references. What they are, how to use them.
5. Editing a worksheet: inserting, moving, deleting cells, rows and columns. Formatting (colors, borders, orientation, row height, column width, etc).
6. Formatting text, numbers, etc. Custom formats. Conditional formatting.
7. Summations, formulas. Naming columns and rows and using those names in formulas. Autofill.
8. Charts. Creating, formatting a chart, adding new data, removing data. Editing a chart.
9. Autofilters. Custom filters.
10. Macros.
11. Sorting. Subtotals. Pivot tables.

Topics for the Word Exam (October 7th - NOTICE the change in date!)

The exam will have two parts:

a. you will be asked to use the programs to generate a document (please make sure you have a web based email program that you can use to submit your results at the end of the exam, like you did for the homework). This is the “practical” part.
b. you will also have to respond questions on paper about word. This is the conceptual part.

You are allowed to use your notes or the programs to answer your questions (and create the document, of course). Still, you should NOT rely on having this help available. The exam will have a very strict time policy. If you do not study in advance you will spend all your time going through your notes and using Words help or trying things with the documents.

What I am basically saying is: I will test how much you know about Word by setting a time constraint. We can all find out how to do something in Word if we can spend half an hour going through the help and the menus.

Here is the list of topics:

1. Create a new file, open, save. Page setup. Printing.
2. Basic edition: cut, copy, paste, paste special (unformatted text).
3. Find (including advanced find: match case, etc). Wildcards (only * and ?). Replace.
4. Layouts: normal, web, view, outline. Toolbars (showing and hiding them, how to add buttons to a toolbar).
5. Header and footer. Inserting page number, page count, today date, etc.
6. Breaks: page breaks, section breaks, column breaks.
7. Autotext. What it is, how to use it.
8. Drawing arrows, squares, lines.
9. Formatting text: fonts, paragraph formatting.
10. Bullets, numbering. Different levels of bullets.
11. Columns, tabs (different types of tabs, how they are used). Indentation.
12. Spellchecking, tracking changes.
13. Mail merge: creating a data source, inserting fields from the data source, creating letters and envelopes.
14. Macros: how to record and run a macro.
15. Tables: creating a table, formatting tables, splitting cells, text orientation in cells, borders, colors.
16. Microsoft equation editor. Creating and editting an equation.

Project #1: due 10/5

The project consists of 3 parts:

1. CV: create a curriculum based on this model.

You have two options:

a. use the model to generate YOUR own curriculum vitae.
b. you can generate a fictitious curriculum vitae for a fictitious person.

In both cases remember that:

I. you cannot use the data given in the model.
II. the document should have the same organization than the one given. That means it should have the same parts (Objective, Education, Employment, etc). It should also be organized in terms of columns, indentation, etcetera, as the one given. You do not need to come up with exactly the same font, but use them consistently as they appear in the model (for example, use the same font for all the titles of the sections: OBJECTIVE, EDUCATION, etc). You have two weeks to work in this assignment, so if you have doubts, dont hesitate to ask me.

2. Equation: generate the following equation with Microsoft word.



3. Table: generate the following table with Microsoft word.



NOTES:

Please send three separate documents to christianatlincoln@gmail.com. Please keep electronic copies of the documents, in came something bad happen (like me not getting your email). You should receive a confirmation "soon" (within a day), that I have your documents and that I can view them. If not, please send email. Assignment is due October 5th, 23:59. If I receive your email after that time you will loose 20% of your grade for each day you are late. I will not accept excuses for assignments being late. You have PLENTY of time to complete the assignment, so do not wait until the last minute tu submit it.

Thanks! Have fun!

Syllabus, update

Please download here.

Class #3

Class 3