Excel – INFT 103

CG • Section 8WK • 11/08/2019 to 04/16/2020 • Modified 07/28/2020

Course Description

An introduction to the basics of Microsoft® Excel which includes creating and analyzing data through the use of performing calculations and various formulas. Topics include entering data in a cell, constructing formulas, formatting worksheets, using the SUM function and creating charts based on data from the spreadsheet.

Prerequisites

None

Rationale

This course is designed to offer the student a hands-on introduction to Excel concepts and applications. The course will assist in fulfilling institutional aims through integrating university-level computer competencies.

Measurable Learning Outcomes

Upon successful completion of this course, the student will be able to:

  1. Create and edit a spreadsheet in Microsoft Excel.
  2. Manipulate basic formulas in Microsoft Excel.
  3. Organize data within a spreadsheet.
  4. Create a graphical representation of data.
  5. Use the Goal Seek tool in Excel to predict results.

Course Assignment

Textbook readings and lecture presentations

Course Requirements Checklist

After reading the Course Syllabus and Student Expectations, the student will complete the related checklist found in Module/Week 1.

Class Introduction

This assignment serves as a short introduction for the instructor and also clarifies several policies for INFT 103. Answer the following questions. The answers do not need to be in sentence form.

Training Assignments (4)

The student will complete the Training Assignments in SAM. The Training Assignments are online simulations that allow the student to learn skills in Excel. Features in the training include learning aids that explain how to perform the skill. The student will complete the questions in the assignments by showing the skill in SAM. The student will have unlimited attempts when completing the Training Assignments.

Textbook Projects (3)

The student will complete assignments by downloading the assignments from within SAM. The student must download and use the starter files provided in SAM to complete the Textbook Assignments. The student will submit a spreadsheet for each completed Textbook Assignment to SAM.

SAM Projects (7)

The student will download a starter file from SAM for each SAM Project Assignment. Once the student has completed the assignment on his/her computer, he/she will upload the file back into SAM. The assignment will be automatically graded upon submission to SAM. The student will be allowed 3 attempts to upload the assignment to improve his/her score.

Case Study

The student will complete a fuel cost analysis using spreadsheets via Blackboard. Once the spreadsheets are complete, the student will also write a 250-word rationale for decisions regarding the chart type used in the spreadsheet and reasoning behind why the vehicles were chosen for the assignment. The student must include a reference page that cites all sources in the format used by his/her degree program.

Quizzes (2)

Each quiz will be open-book/open-notes and have a 1-hour time limit. The student will be allowed 3 attempts per question and 1 attempt per quiz. Each quiz will be completed via SAM.

Final Exam

The exam will be open-book/open-notes, and have a 1-hour time limit. The student will be allowed 3 attempts per question and 1 attempt for the exam. The Final Exam will be completed via SAM.