|
Graduate Boot Camp Course Syllabus |
|
Evening MBA, IMBA, MIB, Jamaica, Bolivia, ADBA |
|
If you would like to contact me - Gerard Klonarides gk@fiu. edu |
|
And my website is at http://w3.fiu.edu/gk |
|
|
Thursday August 11, 2005 11:19:36 AM -0400
Good Morning IMBA, Good Evening MBA class,
This is what you have to do:
Complete EXCEL exercises 1-20 (Link will be restored during first day of class)
Save your work as you go along on your laptop or on your PC
If you save on the C drive of the computer in the lab - it will only remain there for this day - it is deleted nightly
If you wish to save for longer - either email it to yourself or save it on your laptop or the CBA U, W or V drive - ask me about it.
Email the exercises as you go along to (one by one , or 5 at a time) gk@fiu.edu
If you finish all 20 today - you are dismissed for the rest of the classes
If you have questions or are finding difficulty - we will resume tomorrow and go through each question one by one
For the eve MBA - Tuesday is beginner's level, Wednesday is intermediate level, and Thursday is advanced.
For the IMBA - beginner's, intermediate and advanced will be concentrated into the two days (11th and 12th Aug) we have together.
Good luck
Prof
Excel IV - Final Touches
PowerPoint – Fundamentals
PowerPoint – Intermediate
PowerPoint – Advanced
1. Open new worksheet
2. Enter data and calculate Totals by using formula manually, the fx function
3. Calculate average, min, max, and count manually
4. Calculate sum using sigma function
5. Copy and paste formulas to a second worksheet
6. Use $ in calculations
7. Save worksheet
8. Open new sheets
9. Rename sheets
10. Insert a worksheet
11. Change place of a worksheet
12. Delete row, and column
13. Insert row and column
14. Select all, copy, create new sheet.
15. Column widths, row heights
16. Borders, patterns, centering, adjust left and right
17. Color fonts, high lights, change font size
18. Format rows and columns for currency, for text and for decimal places
19. Increase and decrease decimal places
20. Select adjacent columns.
21. Exercise 01
22. Printing - preview
23. Print setup, landscape or portrait, gridlines,
24. Custom header and footer,
25. Inserting time and date, Insert name
Laptop Maintenance and security Level I
1. System tools
2. Scandisk
3. Disk cleanup
4. Disk defragmenter
5. Maintenance wizard
6. Control panel - mouse
7. Time and date change
8. What happens to email if date and time is wrong
1. Review
2. Insert a hyperlink and test hyperlink; www and email
3. Undo button
4. Exercise 02 Calculate car loan using PMT manually and function box
5. Insert comment command,
6. Print the cell formulas
7. Calculate % margin, markup, functions - including totals, mins, max, count, averages
8. Freeze panes, format columns,
9. Sort
10. Go to top, go to bottom, select all,
11. Increase and decrease decimal places,
12. Sort, sorting from bottom right to top left
13. Use of auto filter, one column, multiple columns,
14. Printing; print preview, insert page number, page of page numbers, insert name of file, insert sheet number, margins
15. Insert comment , permanent or hide
16. Show all comments
17. Review sum, count, average, min, max and PMT
18. New; Log and log10
19. Power of x
20. Square root
21. Sum of squares
22. Sum of products
1. Open new Power Point presentation
2. Select auto layout Title slide
3. Change size of fonts
4. Save presentation
5. Open same presentation
6. Change background color and preview
7. Insert new slide in same presentation
8. Save again
9. Change text box color
10. Change font color
11. Apply color scheme
12. Spell check
13. Save and Print
Laptop Maintenance and security Level II
1. Security - Anti-virus Norton - McAfee - AVG ( www.grisoft.com ) and TrendMicro ( http://www.trendmicro.com) and firewalls (ZoneAlarm www.zonealarm.com )
2. Encryption, ( www.pgp.com ) digital ids, digital signatures, ( www.Thawte.com ) and digital certificates (www.verisign.com )
1. Review
2. Variance
3. Matrix command
4. Standard deviation
5. Sum row and column
1. Review
2. Apply design template
3. Normal view outline view, slide view, slide show view
4. Choose any of 24 layouts
5. Add clip art
6. Add photos
7. Add sound
8. Add movie
9. Choose slide color scheme
10. Choose from 22 presentation designs
11. Introduce and choose from 18 entry animations
12. Introduce sound and choose from 16 sounds
13. Change order and timing
14. Introduce text, all at once, letter by letter and word by word
15. Preview
16. Rehearse timing
17. Slide show
18. Import file
19. Import word document
20. Import spreadsheet
21. Import database
22. Use of ruler
23. Use of guides
24. Save and print
1. Graphs
2. Charts
3. Histogram
4. Series 1 and series 2 in same graph
5. Pivoting
6. Cross tabulate
7. 3 dimensional workbook
1. Questions
2. Produce small 30 second slide show
1. GANTT charts for Project Management
2. PERT/CPM charts for Operations Management/Systems Analysis and Design