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)