CIT 20600
Advanced Computer Applications
Advanced Computer Applications
Description
This course will cover the advanced topics of office applications in Word, Excel, PowerPoint, and Access, as well as establishing desktop publishing skills using Microsoft Publisher. There will be a strong emphasis on Web-driven applications. Topics include Web forms, data-driven documents, financial functions, worksheet queries, Web spreadsheets, Web databases, interactive OLE, macros, graphics, VBA, brochures, newsletters, business forms, and relational databases.
Textbook
Shaffer, Ageloff, Oja, New Perspectives on Microsoft Office 2007; Second Course, 2nd Ed, Course Technology, 2008, ISBN 9780324598414
Course Outcomes
- Develop instructional strategies and approaches (CIT 1, 6, 10)
- Integrate computer skills, instructional design, and disciplinary content effectively to accomplish professional objectives (CIT 1, 6, 10)
- Apply advanced production skills to generate Web publications (CIT 1, 6, 10)
CIT Program Outcomes (What are these?)
1.
6.
10.
Principles of Undergraduate Learning (What are Principles of Undergraduate Learning?)
1a.
1b.
1c.
4.
Topics
- Advanced topics in Word
- Tables, Graphics, OLE, VBA
- Charts and Analysis
- Advanced Topics in Excel
- Advanced Topics in PowerPoint
- Advanced Topics in Access
Assessment
- Assignments (17-20)
- Tests (2)
- Projects (4)