Search
IUPUI School of Engineering and Technology

IUPUI School of Engineering and Technology

Computer Technology Applications Capstone

CIT 30600 / 3 Cr.

This course will study how organizations incorporate and automate computer applications, web applications and web services. Students will create a capstone project and a training module for an organization focusing on the use of current emerging computer and web application technologies as well as support and communication tools.

Software
  • Microsoft Word
  • Microsoft Excel
  • Microsoft PowerPoint
  • Microsoft Access
  • Microsoft Publisher
Outcomes

Course Outcomes (What are these?)

  • Apply knowledge gained using computer and web applications to produce a capstone project for the virtual workplace (CIT c)
  • Research, present findings, and predict the future in order to learn new skills and transfer knowledge to new tools (CIT f, h)
  • Successfully train others to be productive computer users (CIT g)
  • Use collaborative tools to build virtual workplace solutions (CIT i)
  • Create more sophisticated procedures to automate application software (CIT i)
  • Recognize the role of speech and handwriting recognition software (CIT j)
  • Integrate applications to build virtual workplace solutions (CIT l)
  • Use application software to publish to the web as part of the virtual workplace (CIT i)
  • Recognize and incorporate rules regarding the difference between designing documents for paper and designing for the web (CIT m)
  • Use application software document design techniques (CIT j)
  • Make use of blogs, RSS feeds, Software on Demand (CIT j)
  • Apply other emerging technologies (CIT i)
  • Identify and explain the role of web services in the virtual workplace (CIT m)

CIT Student Outcomes (What are these?)

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

(f)  An ability to communicate effectively with a range of audiences 

(h) Recognition of the need for and an ability to engage in continuing professional development 

(i) An ability to use current techniques, skills, and tools necessary for computing practice.

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

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

(m) An understanding of best practices and standards and their application.

Topics
  • Advanced topics in Word
  • Advanced topics in Excel
  • Advanced topics in Access
  • Advanced topics in Powerpoint
  • Using Adobe Suite
  • Other Productivity Tools
Principles of Undergraduate Learning (PULs)

1a.  Communicate effectively in a variety of formats, particularly written, oral, and visual formats

3. Integration and Application of Knowledge

4. Intellectual Depth, Breadth, and Adaptiveness

What You Will Learn

Advanced Topics in Word

  • Working with Document Sharing Tools, a Master Document, a Table of Contents, and an Index
  • Creating an Online Form
  • Enhancing an Online Form and Working with Macros, Document Security, and XML
  • Blogging Feature: Creating a Blog Post

Advanced Topics in Excel

  • Using Macros and Visual Basic for Applications (VBA) with Excel
  • Formula Auditing, Data Validation, and Complex Problem Solving
  • Importing Date, Working with PivotCharts, PivotTables, and Trendlines
  • Collaboration Feature: Using SharePoint and Excel Services

Advanced Topics in Access

  • Advanced Report Techniques
  • Advanced Form Techniques
  • Administering a Database System
  • Web Feature: Sharing Access Data

Advanced Topics in PowerPoint

  • Reusing a Presentation with Multimedia
  • Creating a Self-Running Presentation Containing Animated Shapes
  • Online Feature: Importing Files from the Microsoft Office Online Web Site
Using Adobe Suite
  • Set magazine sizes 
  • Using backgrounds or gradients
  • Importing pictures
  • Inserting text

Other Productivity Tools

  • Publisher
    • Use Publisher Templates to create a data driven catalog
  • Prezi
    • Use templates and themes
    • Include pictures, web links, diagrams and video
  • OneNote
    • Insert notes, tables, lists, folders, Web pages, and audio into OneNote
    • Use to pen tool to annotate a note
    • Use the Windows snippet tool to insert a picture or paste from a Web page
  • Google Docs
    • create an interactive store locator map 
  • Research and compare features of various sky drives and cloud storage