About the final exam

The final exam is easy, but you need to complete it in one hour. We will start around 10.15 and we will finish at 11.15. After the exam is over, we will use that time to fix any problems we may have with grades for the homeworks or any other confusion. I sent the grades by email earlier, check to see if they are correct and let me know tomorrow after the exam if you have any problems.

Thanks!

Final Exam: Excel part

For the Excel part:

Use this file to start your exercise.

And make your result look like this.

Topics for the final exam

The final exam will cover the following topics: Words, Excel and Powerpoint.

Here are the detailed list of items:

Word

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.


Excel

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.

Powerpoint

1. Opening, creating and saving a presentation. Pack and go (how does it work?)
2. Slide layout, slide design, slide backgrounds.
3. Slide masters, how they are used, adding logos, etcetera.
4. Inserting objects. Clip art. Audio, video, pictures, from files and from the clip art. Importing to the clip art. Inserting charts and tables. Organizational charts.
5. Transitions, different types, how to set up an automatic and manual transition.
6. Animation, different types. Custom animations. Animating different parts of the slide.

Study hard!

Access homework, due December 9th at 23:59

You need to design a database to manage a travel agency.

1. Create the following tables:

TourGuides:

Last name, First name, Birthdate

Travelers:

Last name, First name, Address, ... other personal information

ToursOffered:

DepartureLocation, ArrivalLocation, Duration, Description

Locations:

Name, Description, Weather

Vans:

Model, Color, Capacity

TripsScheduled:

A trip scheduled is a TourOffered scheduled for a specific time and assigned to a TourGuide and a van and offered at a specific price. So the fields should include:

TourOffered, TourGuide, Van, Price, TimeDeparture.

TravelersInTrips:

This table relates travelers and scheduled trips. It should also include how much the user has paid already, and in what format (credit card, cash, debit card, etc).

- Please remember that all tables should include primary keys (IDs), when it makes sense, you can use IDs that appear in the real world (license plates for the van). The rest of the time, let Access generate one for you.

2. Create the following relationships:

- ToursOffered with Location (twice, for Departure and Arrival).
- TripsScheduled with ToursOffered, Vans and TourGuide.
- TravelersInTrips with Travelers, TripsScheduled.

3. Create nice looking forms to enter data for each of the following:

- Tour guide.
- Travelers.
- Tour offered (sub form: departure and arrival location).
- Trips scheduled (sub forms: van, maybe: ToursOffered and TourGuide).
- Travelers in Trips (sub forms: travelers, maybe: trips scheduled)

(more to be posted on the weekend)

Just for fun

A masterpiece of playback

How to find video files with google

Check this

Homework #4: Powerpoint (due November 23)

Please a create a Powerpoint presentation with at least 10 slides (no more than 20, please).

You are free to choose the layout and design of your slides, but you should include, at least:

1. 1 picture from a file.
2. 2 clipart objects.
3. 1 organization chart (with at least 3 levels and 7 people).
4. 1 table.
5. a sound clip (it should play when I click on it).
6. a movie clip.

Also:

Your presentation should play with 10 seconds per slide and show at least:

A. 3 types of animation schemes (one of them modified to make it a "custom" animation)
B. 3 types of transitions.

Also:

I. Your presentation should include a logo in each page and your name in the footer (you should modify the master for this).
II. Your presentation should include notes.

Finally:

I will reserve 10 points of the grade to the CONTENT of your presentation. Make it interesting, make it fun, make it coherent. I know that some of my requirements will make your presentation weird, but try as hard as you can, and you will get those 10 points.

Homework #3: weblogs (due November 10th at 23.59)

1. Create a weblog in blogger.
2. The weblog should include at least 5 posts. The posts should at least show:

a. different type of fonts (show me you know how to use html without making the weblog too ugly).
b. a blockquote.
c. links (to other blogs).
d. at least 2 pictures (use flickr.com or picasa / hello to post pictures in blogger).

The weblog should also include:

a. comments implemented by a commenting system (haloscan).
b. at least 5 links to your favorite blogs.
c. a visit counter (www.miarroba.com)

3. Make your blog as "cute" as you can. You will get extra points if it looks fun and interesting. Think of this weblog not as homework but as the beginning of your blogging life.

Excel Exam

Here is an Excel spreadsheet that you can use as a starting point for your exam, so you don't have to type all those numbers. Check the Sheet 1 and 2.

Exercise 1:

Please create the spreadsheet as given here.

a- Product, value and quantity should be the values given in the tables.
b- Purchase = value * quantity
c- With discount 1 is applying a discount of 11% to the Purchase value.
d- With discount 2 is applying a discount of 33% to the Purchase value.
e- Note that both discount values (11 and 33) should be taken FROM THE spreadsheet, so that if when I grade I change those values manually, they should immediately reflect a change in the corresponding columns.
f- After you created the table and formatted it as shown, please create a pie chart that replicates the one I gave you.

Exercise 2:

Please create the spreadsheet as given here.

a- The values for rice, flour, sugar and milk for the months from January to June should be entered by you directly.
b- The total, average, median, min and max should be created by using FORMULAS.
c- Generate the bar chart showing the evolution of the four products through the months, in the format given.
d- Then generate a line chart that ONLY SHOWS two of the series (flour and rice) and format it as given.

Excel

As for practice for the exam: you should take the Excel homework as a sample of what the exam will be (this does NOT mean it will be the same). And check the list of topics. Then go to www.google.com and do a search on "Excel exercises", or "Excel practice" or "Excel exams" or "Excel tutorial" and use what you find that resembles what we saw in class. Examples of links I found:

http://web.utk.edu/~dhouston/excel/exercise.html: this one is really good.

http://math.about.com/od/excel/: these are great tutorials.

http://labs.pharmacology.ucla.edu/user_ed/excel/excel_exercises/: this is more formula heavy... but still useful.

Etcetera. Play with google, and if you find interesting exercise websites, mail them to me and Ill post them here for everyone to use.

Grades for Test #1

You should now have the grade for your test in your email inbox (make sure you check the account from which you SENT the test exam). A comment about this test:

Most people did well in the exam (the average was 80 out of 100). Actually, 75% of the class got a grade > 74. If you are in the low 25% you need to work REALLY hard. You still have 3 tests ahead of you, homework, etcetera, so you still can better your grade. But I can't promise the exams will be easier. Tests are my ONLY way to know you are doing your own work, so they can't be completely replaced by work you do at home, nor they should be. You are supposed to perform well in tests, since that is the way you will be evaluated in job interviews, SATs, etcetera.