Purdue School of Engineering and Technology

Purdue School of Engineering and Technology

Advanced Computer Applications

CIT 20600 / 3 Cr.

The course will cover advanced office application topics. There will be a strong emphasis on web-driven applications. Focus will include web publishing and forms, data-driven documents, web spreadsheets, web databases, interactive OLE, macros, VSA, and collaborative and/or interactive software application and productivity tools. Hands-on exercises, web research, solo and group projects, and presentations will be used to master course topics.

  • Microsoft Word
  • Microsoft Excel
  • Microsoft Powerpoint
  • Microsoft Access
  • Microsoft Publisher

Course Outcomes (What are these?)

  • Students will use critical thinking skills to locate, extract and organize information to generate interactive business solutions (CIT b)
  • Students will employ problem-solving techniques in designing data-driven products (CIT b)
  • Students will apply their technology skills to specific applications within their field and to the development of instructional strategies and approaches (CIT k)
  • Students will successfully create macros using the Visual Basic development environment (CIT l)
  • Students will integrate computer skills, instructional design, and disciplinary content effectively to accomplish professional objectives (CIT c)
  • Students will apply advanced production skills to generate Web publications (CIT j)

CIT Student Outcomes (What are these?)

(b) An ability to analyze a problem, and identify and define the computing requirements appropriate to its solution.

(c) An ability to design, implement, and evaluate a computer-based system, process, component, or program to meet desired needs.

(j) An ability to use and apply current technical concepts and practices in the core information technologies.

(k) An ability to identify and analyze user needs and take them into account in the selection, creation, evaluation and administration of computer-based systems.

(l) An ability to effectively integrate IT-based solutions into the user environment.

  • Advanced topics in Word
  • Tables, Graphics, OLE, VBA
  • Charts and Analysis
  • Advanced Topics in Excel
  • Advanced Topics in Powerpoint
  • Advanced Topics in Access
Principles of Undergraduate Learning (PULs)

2.  Critical Thinking

3.  Integration and Application of Knowledge

4.  Intellectual Depth, Breadth, and Adaptiveness

What You Will Learn

Operating System (Windows and File Management)

  • Advanced file management techniques in Windows 8

Word Processing

  • Creating a Document with a Title Page, Table, and Watermark
  • Using a Template to Create a Resume and Sharing the Finished Document
  • Generating Form Letters, Mailing Labels, and a Directory for a Cover Letter
  • Creating a Newsletter with a Pull-Quote and Graphics


  • More Charting, Web Apps, Excel Web Pages, Web Queries, and Collaboration (working title)
  • Financial Functions, Data Tables, and Amortization Schedules
  • Creating, Sorting, and Querying a Table
  • Working with Multiple Worksheets and Workbooks

Presentation Graphics

  • Working with Information Graphics
  • Delivering and Collaborating on Presentations
  • Adding Emphasis with Text Boxes
  • Creating a Self-Running Presentation Containing Animation


  • Creating Reports and Forms
  • Multi-Table Forms
  • Macros, Switchboards, PivotTables, and PivotCharts
  • Creating Reports and Forms Using Design View

Integrating Applications

  • Managing Contacts and Personal Information
  • Using desktop publishing techniques and software to integrate data