OAT 130 Sections 100 & 101 Syllabus
| ELGIN COMMUNITY COLLEGE |
OAT 130
SOFTWARE APPS FOR THE OFFICE
|
|
| SPRING 2016 |
ROGER
M. RAMEY, ASSOCIATE PROFESSOR
|
|
| TT 1:15 - 12:30; M113 |
OFFICE:
M105.03; 847.214.7905
|
|
Date |
Class Activity |
Assignment |
| Jan 19 | Intro to Course |
|
| Jan 21 | Getting Started with Windows 8 - 1A - Getting to know Windows 8 | |
| Jan 26 | Getting Started with Windows 8 - 1B - Managing Files and Folders | |
| Jan 28 | Creating Documents with Microsoft Word 2013-1A-Flyer | Skills Review 1C & Mastering Word 1E |
| Feb 2 | Creating Documents with Microsoft Word 2013-1B-Information Handout | Skills Review 1D & Mastering Word 1F |
| Feb 4 | Using Tables and Templates to Create Resumes and Cover Letters-2A-Resume | Skills Review 2C & Mastering Word 2E |
| Feb 9 | Using Tables and Templates to Create Resumes and Cover Letters-2B-Cover Letter, Reference List, and Envelope | Skills Review 2D & Mastering Word 2F |
| Feb 11 | Creating Research Papers, Newsletters, and Merged Mailing Labels-3A-Research Paper | Skills Review 3C & Mastering Word 3E |
| Feb 16 | Creating Research Papers, Newsletters, and Merged Mailing Labels-3B-Newsletter with Mailing Labels | Skills Review 3D & Mastering Word 3F |
| Feb 18 | Catch-up Day | |
| Feb 23 | Creating a Worksheet and Charting Data-1A-Sales Report with Embedded Column Chart and Sparklines | Skills Review 1C & Mastering Excel 1E |
| Feb 25 | Creating a Worksheet and Charting Data-1B-Inventory Valuation | Skills Review 1D & Mastering Excel 1F |
| Mar 1 | Using Functions, Creating Tables, and Managing Large Workbooks-2A-Inventory Status Report | Skills Review 2C & Mastering Excel 2E |
| Mar 3 | Using Functions, Creating Tables, and Managing Large Workbooks-2B-Weekly Sales Summary | Skills Review 2D & Mastering Excel 2F |
| Mar 8 | Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools-3A-Enterprise Fund Pie Chart | Skills Review 3C & Mastering Excel 3E |
| Mar 10 | Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools-3B-Tourism Spending Projection with Line Chart | Skills Review 3D & Mastering Excel 3F |
| Mar 15 | Catch-up Day | |
| Mar 17 | Getting Started with Microsoft Office PowerPoint-1A-Company Overview | Skills Review 1C & Mastering PowerPoint 1E |
| Mar 29 | Getting Started with Microsoft Office PowerPoint-1B-Itinerary Presentation | Skills Review 1D & Mastering PowerPoint 1F |
| Mar 31 | Formatting PowerPoint Presentations-2A-Employee Training Presentation | Skills Review 2C & Mastering PowerPoint 2E |
| Apr 5 | Formatting PowerPoint Presentations-2B-Event Announcement | Skills Review 2D & Mastering PowerPoint 2F |
| Apr 7 | Enhancing a Presentation with Animation, Video, Tables, and Charts-3A-Informational Presentation | Skills Review 3C & Mastering PowerPoint 3E |
| Apr 12 | Enhancing a Presentation with Animation, Video, Tables, and Charts-3B-Summary and Analysis Presentation | Skills Review 3D & Mastering PowerPoint 3F |
| Apr 14 | Catch-up Day | |
| Apr 19 | Getting Started with Microsoft Access-1A-Student Advising Database with Two Tables | Skills Review 1C & Mastering Access 1E |
| Apr 21 | Getting Started with Microsoft Access-1B-Student Workshop Database | Skills Review 1D & Mastering Access 1F |
| Apr 26 | Sort and Query a Database-2A-Instructors and Courses Database | Skills Review 2C & Mastering Access 2E |
| Apr 28 | Sort and Query a Database-2B-Athletic Scholarship Database | Skills Review 2D & Mastering Access 2F |
| May 3 | Forms, Filters, and Reports-3A-Studenta and Majors Database | Skills Review 3C & Mastering Access 3E |
| May 5 | Forms, Filters, and Reports-3B-Job Openings Database | Skills Review 3D & Mastering Access 3F |
| May 10 | Catch-up Day | |
| May 12 | Review for Final and Begin Final Integration Project | |
| May 17 | Final Integration Project | |
|
Note:
All
work must be turned in no later than May 17th, unless prior arrangements
are made. |
||
Back to ECC Faculty Page
