ÍÃ×ÓÏÈÉú

Catalog description:

An introduction to business-oriented computer skills. Extensive hands-on use of electronic spreadsheets and database software. Examples and exercises will stress problem-solving in a business context. Credit not awarded for both CSE 148 and CSE 243.

Prerequisite:

None

Course Objectives:

• To provide students with the foundations necessary to use personal productivity software.
• To provide students with the skills needed to effectively use spreadsheet software.
• To provide students with the skills needed to effectively use database software.
• To provide students with the skills needed to effectively use Excel and Access in future business courses.

Learning Outcomes:

• Objective 1: To provide students with the foundations necessary to use personal productivity software.
  • The student can navigate, copy, and move files on the local and network file system.
  • The student can use appropriate software resources to connect to ÍÃ×ÓÏÈÉú's network and servers.
  • The student can create, edit, format, and print word processing documents including lists, tables, footnotes, multi-column pages, and graphic images.
  • The student can explain the difference among pasting, embedding, and linking content between Office tools. The student can effectively use all three methods to integrate information between Office tools.
• Objective 2: To provide students with the skills needed to effectively use spreadsheet software.
  • The student can create, edit, format, and print spreadsheet documents including formulas relating cells in the spreadsheet.
  • The student can effectively use relative and absolute addressing to efficiently copy formulas in a spreadsheet.
  • The student can create, edit, format, and print graphs and charts to represent the data in a spreadsheet.
  • The student can use basic spreadsheet functions (e.g. SUM, AVERAGE, etc.), financial functions (e.g. PMT), lookup functions (e.g. VLOOKUP, HLOOKUP, etc.) and logical functions (e.g. IF, OR, AND, COUNTIF, etc.) in spreadsheet formulas.
  • The student can import external data, either from Access or other sources, into a spreadsheet and place it in a form leading to effective analysis.
  • The student can create and use pivot tables and pivot charts to organize data into a meaningful summary.
• Objective 3: To provide students with the skills needed to effectively use database software.
  • The student can explain the relational database concepts field, table, common field, primary key, foreign key, and query.
  • The student can define fields, enter or import data, and edit the structure and content of a relational database.
  • The student can create input forms and reports for a relational database.
  • The student can use simple criteria and combinations of criteria to select, sort, and summarize data from a relational database.
  • The student can explain the structured query language (SQL) that is generated when creating queries through point and click methods.
  • Students can create one and two table SQL queries using SELECT, FROM, JOIN, WHERE, ORDER BY, GROUP BY, and HAVING.
  • The student can import external data from Excel into a table and export Access data into Excel
• Objective 4: To provide students with the skills needed to effectively use Excel and Access in future business courses.
  • The student can use the capabilities of Excel to analyze and summarize information to solve a specified business problem.
  • The student can use the capabilities of Access to extract the information necessary to analyze and solve a specified business problem.
  • The student can integrate and combine results from various tools into a single report.
  • The student can learn to use additional features, not specifically covered in class, of each software product studied.
  • The student can determine and articulate when it is appropriate to use particular features of each software product in solving business problems.

Required topics (approximate weeks allocated):

• Introduction to using computers at ÍÃ×ÓÏÈÉú (1)
• Spreadsheets [EXCEL] (7)
  • fundamental Excel skills
  • creating and using charts and graphs
  • designing and using spreadsheets to solve problems
  • retrieving and analyzing external data
  • using logical functions and advanced analysis tools to make decisions
• Databases [Access ](6)
  • creating and manipulating tables
  • creating forms and reports
  • designing tables and building a database
  • using queries to select data for decision making
  • importing and exporting data for storage and analysis
• Exams/Review (1)