CURRENTLY: Accepting Final Exam Submissions Until 11.59pm Wed 17 Dec 2014

Week 14:

Wed 10 Dec 2014: Hands-On Review of FINAL EXAM (TO TURN IN ELECTRONICALLY) POSTED ON PEARSON as FINAL-EXAM // DUE 15 December 2014 (only two days grace period)
Mon 08 Dec 2014: STUDY-ASSIGNMENT: Watch MS Videos Webpage Production in MS-Office 2013
Mon 08 Dec 2014: Lecture #28 -- (1) Web Publishing in MS-Word, (2) Using different approaches to graphics and equations in web publishing


Week 13:

Fri 05 Dec 2014: Hands-On Review of FINAL EXAM (TO TURN IN ELECTRONICALLY) POSTED ON PEARSON as FINAL-EXAM // DUE 15 December 2014 (only two days grace period)
Wed 03 Dec 2014: Lecture #27 -- (1) Dynamic Documents in MS-Word, (2) Using different Text Box inserts in MS-Word documents
Wed 03 Dec 2014: READING ASSIGNMENT: Pearson Word 2013, Chapters 7 and 8 (Vol. 2)
Mon 01 Dec 2014: STUDY-ASSIGNMENT: Watch MS Videos Document and Web Integration in MS-Office 2013
Mon 01 Dec 2014: Lecture #26 -- Integrated Dynamic Documents in Microsoft Office 2013


Week 12:

Fri 21 Nov 2014: HOMEWORK #8 (TO TURN IN ELECTRONICALLY) POSTED ON PEARSON as Assignment-8 // DUE 10 December 2014
Wed 19 Nov 2014: Lecture #25 -- Advanced Features in MS-Word
Mon 17 Nov 2014: STUDY-ASSIGNMENT: Watch MS Videos Advanced Word 2013: Style sheets, MailMerge, GraphicsDesign...
Mon 17 Nov 2014: READING ASSIGNMENT: Pearson Word Chapters 7-8 (Vol. 2)
Mon 17 Nov 2014: Lecture #24 -- Advanced features in Word: MailMerge, Graphic Design...


Week 11:

Fri 14 Nov 2014: HOMEWORK #7 (TO TURN IN ELECTRONICALLY) POSTED ON PEARSON as Assignment-7 // DUE 05 Dec 2014
Wed 12 Nov 2014: Lecture #23 -- Intermediate Features in MS-Word: Completing the Business Report
Mon 10 Nov 2014: STUDY-ASSIGNMENT: Watch MS Videos Intermediate Word 2013: Style sheets, References, Captions, ...
Mon 10 Nov 2014: READING ASSIGNMENT: Pearson Word Chapters 5-6 (Vol. 2)
Mon 10 Nov 2014: Lecture #22 -- Intermediate features in Word: Business report building, TOC, References, tags, graphics, and more...


Week 10:

Fri 07 Nov 2014: HOMEWORK #6 (TO TURN IN ELECTRONICALLY) POSTED ON PEARSON as Assignment-6 // DUE 21 Nov 2014
Wed 05 Nov 2014: Lecture #21 -- Intermediate Features in MS-Word: Completing the Report
Mon 03 Nov 2014: STUDY-ASSIGNMENT: Watch MS Videos Intermediate Word 2013: Style sheets, References, Captions, ...
Mon 03 Nov 2014: READING ASSIGNMENT: Pearson Word Chapters 3-4
Mon 03 Nov 2014: Lecture #20 -- Intermediate features in Word: Report building, TOC, References, tags, graphics, and more...


Week 9:

Fri 31 Oct 2014: EXAM #2 (TO TURN IN ELECTRONICALLY) POSTED ON PEARSON as Exam-2 // DUE 14 Nov 2014
Wed 29 Oct 2014: Lecture #19 -- Beginning Features in MS-Word - Making a Letter and Memo
Mon 27 Oct 2014: STUDY-ASSIGNMENT: Watch MS Videos Beginning Word 2013: Create document, Custom margins, Table of Contents, Track changes, Word count
Mon 27 Oct 2014: READING ASSIGNMENT: Pearson Word Chapters 1-2
Mon 27 Oct 2014: Lecture #18 -- Beginning features in Word: Creating and customizing a document


Week 8:

Fri 24 Oct 2014: HOMEWORK #5 (TO TURN IN ELECTRONICALLY) POSTED ON PEARSON as Assignment-5 // DUE 07 Nov 2014
Wed 22 Oct 2014: Lecture #17 -- (1) Advanced Features in PowerPoint, (2) Overview of Homework #5
Mon 20 Oct 2014 2014: STUDY-ASSIGNMENT: Watch MS Videos Advanced PowerPoint 2013: Sound, Bullets, Headers/Footers, Animation, Flowchart, Orgchart, Templates, Insert charts, Slide Masters
Mon 20 Oct 2014: READING ASSIGNMENT: Pearson PowerPoint Chapter 7
Mon 20 Oct 2014: Lecture #16 -- Advanced features in PowerPoint: Customizing and animating a presentation


Week 7:

Wed 15 Oct 2014: Hands-on Lecture #15 -- Intermediate Features in PowerPoint
Mon 13 Oct 2014: STUDY-ASSIGNMENT: Watch MS Videos Intermediate and Advanced PowerPoint 2013: Backgrounds, Cropping, Watermarks, Inserting audio and videos, Creating masters, and Handout masters
Mon 13 Oct 2014: READING ASSIGNMENT: Pearson PowerPoint Chapters 5,6
Mon 13 Oct 2014: Lecture #14 -- Intermediate features in PowerPoint: Formatting and enhancing your presentation


Week 6:

Fri 10 Oct 2014: HOMEWORK #4 (TO TURN IN ELECTRONICALLY) POSTED ON PEARSON as Assignment-4 // DUE 24 Oct 2014
Wed 08 Oct 2014: Hands-on Lecture #13 -- Intermediate Features in PowerPoint
Mon 06 Oct 2014: STUDY-ASSIGNMENT: Watch MS Videos Intermediate PowerPoint 2013: Backgrounds, Cropping, Watermarks, Handout masters
Mon 06 Oct 2014: READING ASSIGNMENT: Pearson PowerPoint Chapters 3,4
Mon 06 Oct 2014: Lecture #12 -- Intermediate features in PowerPoint: Formatting and enhancing your presentation


Week 5:

Fri 03 Oct 2014: Help session for MIDTERM EXAM-1 (TO TURN IN ELECTRONICALLY) POSTED ON PEARSON as MIDTERM EXAM 1 // DUE 17 Oct 2014
Wed 01 Oct 2014: Lecture #11 -- Interactive exploration of beginning features in PowerPoint
Wed 01 Oct 2014: EXAM-1 (TAKE-HOME ASSIGNMENT, TURN IN ELECTRONICALLY) posted on Pearson as MIDTERM EXAM 1.
Wed 01 Oct 2014: STUDY-ASSIGNMENT: Watch MS Videos Beginning PowerPoint 2013: Apply theme, Apply transitions, Create presentation, Highlight text & change fonts, Print slides/notes/handouts, Use Presenter view
Mon 29 Sep 2014: READING ASSIGNMENT: Pearson PowerPoint Chapters 1-2
Mon 29 Sep 2014: Lecture #10 -- Beginning features in PowerPoint: Creating a presentation


Week 4:

Fri 26 Sept 2014: HOMEWORK #3 HELP SESSION -- HW #3 IS POSTED ON PEARSON as Assignment-3 // DUE 10 October 2014: 11.59pm
Wed 24 Sept 2014: STUDY-ASSIGNMENT: Watch MS Videos Advanced Excel 2013: Advanced If, Array formulas, Pivot Table, Password protection, Work with macros
Wed 24 Sept 2014: Lecture #9 -- (1) Advanced features in Excel: Macros and addressing modes
Mon 22 Sept 2014: READING ASSIGNMENT: Pearson Excel Chapters (Vol. 2) 6-8
Mon 22 Sept 2014: Lecture #8 -- Advanced features in Excel: Pivot Tables/Charts


Week 3:

Fri 19 Sept 2014: HELP SESSION FOR HOMEWORKS #1 and #2 POSTED ON PEARSON as Assignment-1 and Assignment-2
Wed 17 Sept 2014: STUDY-ASSIGNMENT: Watch remainder of MS Videos Intermediate Excel 2013 (ones that weren't assigned for Week 2)
Wed 17 Sept 2014: Lecture #6 -- Intermediate features in Excel
Mon 15 Sept 2014: READING ASSIGNMENT: Pearson Excel Chapters 3-5
Mon 15 Sept 2014: Lecture #5 -- Intermediate features in Excel


Week 2:

Fri 12 Sept 2014: HOMEWORK #2 (TO TURN IN ELECTRONICALLY) POSTED ON PEARSON as Assignment2 // DUE 26 Sept 2014
Wed 10 Sept 2014: STUDY-ASSIGNMENT: Watch MS Videos Intermediate Excel 2013: Insert headers/footers, Sort and filter data, Conditional Formatting, VLOOKUP
Wed 10 Sept 2014: Lecture #4 -- Intermediate features in Excel
Mon 08 Sept 2014: READING ASSIGNMENT: Pearson Excel Chapters 3-5
Mon 08 Sept 2014: Lecture #3 -- Intermediate features in Excel


Week 1:

Fri 05 Sep 2014: HOMEWORK #1 (TO TURN IN ELECTRONICALLY) POSTED ON PEARSON as Assignment1 // DUE 19 Sep 2014 at 11.59pm
Wed,Fri 03,05 Sep 2014: STUDY-ASSIGNMENT: Watch MS Videos Beginner Excel 2013: Create Chart, Top Tips, Understand/use Cell References, Add/subtract Time, Average Numbers
Wed 03 Sep 2014: READING ASSIGNMENT: Pearson Excel Chapters 1,2 (Vol. 1)
Wed 03 Sep 2014: Lecture #2 -- Tour of Excel for Beginners, Building a Budget in Excel -- Example Budget No. 1 and Example Budget No. 2
Mon 01 Sep 2014: NO CLASS - LABOR DAY


Week 0:
Fri 29 Aug 2014: STUDY-ASSIGNMENT:(not to turn in) Watch MS Videos Beginner Excel 2013: Add Numbers, Basic Math, Create Workbook, Freeze/Lock Panes
Fri 29 Aug 2014: Lecture #1 -- Basic Excel Concepts, with in-class Excel Exercises
Wed,Fri 27,29 Aug 2014: Signup for Piazza and PearsonWeb IN CLASS
Mon 25 Aug 2014: FIRST CLASS -- CSE/A101 -- 12.50pm - 1.40pm OR 1.55pm - 2.45pm


Course Material Overview


• Appendix A -- MS-Office 2013 Tutorial
1. Introduction to MS-Excel 2013
   1.1. Introduction and Overview
   1.2. Overview of Beginning Excel 2013
   1.3. Overview of Intermediate Excel 2013
   1.4. Overview of Advanced Excel 2013
   

2. Introduction to MS-PowerPoint 2013
   1.1. Introduction and Overview
   1.2. Overview of Beginning PowerPoint 2013
   1.3. Overview of Intermediate PowerPoint 2013
   1.4. Overview of Advanced PowerPoint 2013
   

3. Introduction to MS-Word 2013
   1.1. Introduction and Overview
   1.2. Overview of Beginning MS-Word 2013
   1.3. Overview of Intermediate MS-Word 2013
   1.4. Overview of Advanced MS-Word 2013
   

4. Introduction to Webpage Construction with MS-Office 2013
   1.1. Introduction and Overview
   1.2. Overview of Beginning Webpage Construction
   1.3. Overview of Intermediate Issues
   1.4. Overview of Advanced Issues and Supporting Software
   

Bibliography

• References Cited in Class

This Web page and all subordinate pages
Copyright © 2014 by Mark S. Schmalz
All rights reserved, except printing by UF/CISE faculty
or UF students officially registered for this class.