CSC 109 - Experience Information Technology

1. Create an example web page
   1. Define the client server structure of web applications
   2. Examine HTML and its role in web applications
   3. Define CSS and its role in web applications
   4. Examine Javascript and its role in web applications
   5. Use a code editor to build a web page
   6. Apply HTML elements to define and structure a web page
   7. Apply CSS rules to define the presentation of a web page
   8. Implement an image on a web page
   9. Implement a Javascript slide show on a web page
   10. Demonstrate the web page using one or more web browsers
2. Evaluate features of a basic IP based communication system
   1. Use and connect basic copper and fiber optic lines needed for a communications system
   2. Compare and contrast fiber optic, copper and wireless communication systems for business and residential users
   3. Experiment and use various communications software for both wired and wireless technology
   4. Describe the basics of voice and data communication systems
3. Assess the fundamentals of computer programming
   1. Compare current programming languages
   2. Discuss the primary structures used in a software program
   3. Explain variables and data types
   4. Understand the software development cycle
   5. Install an Integrated Development Environment (IDE)
   6. Design a software program in a designated programming language
   7. Compile a software program using the appropriate IDE
   8. Develop and execute a test plan
   9. Explore object oriented programming
4. Design relational databases
   1. Develop a logical data model
   2. Develop a conceptual schema
   3. Define the data dictionary
   4. Model and Entity-Relationship Diagram
   5. Discuss normalization techniques
   6. Determine the difference in logical and physical database design
5. Generate a relational database using a popular PC RDBMS
   1. Select the database software
   2. Create a new, empty database
   3. Create a table
   4. Change the design of a table
   5. Enter and edit data in a table
   6. Describe relationships between tables in the database
   7. Enforce relationships between tables in the database
6. Create a simple mobile application
   1. Install the Android Software Development Kit
   2. Configure application settings including the application name, package name, target SDK and theme
   3. Create a simple user interface using various views (buttons, text boxes, check boxes) and layouts
   4. Modify resource files to add strings, drawables, and colors
   5. Describe the relationship between activities, services, content providers and intents
   6. Utilize buttons to initiate activities
   7. Create and configure an emulator using the Android Virtual Device Manager
   8. Implement API demos to an application
   9. Deploy applications to an emulator
   10. Describe the process of publishing an app to an app store
7. Demonstrate the features and use of hardware basics
   1. Understand the concept of geometry
   2. Identify the various types of hard drives
   3. Perform a hard drive swap
   4. Discuss partitioning and formatting
   5. Perform a memory upgrade
8. Evaluate the concept of networking
   1. Identify the components of a local area network
   2. Describe the advantages of networking
   3. Analyze a peer-to-peer and server-based network
9. Examine career paths within business and industry
   1. Interact with guest lecturers in the classroom
   2. Explore Iowa Technology-TAI Tour(s)
   3. Attend at least one Technology Fair
   4. Define the roles and careers available in IT
   5. Interview one manager and one entry level employee in an IT field of choice