Information Technology 282

ITEC 282
Spreadsheet Practicum

1. Catalog Entry

ITEC 282
Spreadsheet Practicum

Credit hours (1)

This course is a one hour class focused on reinforcing the skills learned in ITEC 281.  The course consists strictly of problem solving and will aid in the building of competence in using spreadsheets for the purpose of future classes, industry and for preparing for spreadsheet certification exams.  This course is only taught pass/fail.

2. Detailed Description of Course

The course will have students do projects using the following spreadsheet skills:

    1) Create and manage worksheets and workbooks
        a. Create worksheets and workbooks
        b. Navigate through worksheets and workbooks
        c. Format worksheets and workbooks
        d. Customize options and views for worksheets and workbooks
        e. Configure worksheets and workbooks to print or save
    2) Create cells and ranges
        a. Insert data in cells and ranges
        b. Format cells and ranges
        c. Order and group cells and ranges
    3) Create tables
        a. Create a table
        b. Modify a table
        c. Filter and sort a table
    4) Apply formulas and functions
        a. Utilize cell ranges and references in formulas and functions
        b. Summarize data with functions
        c. Utilize conditional logic in functions
        d. Format and modify text with functions
    5) Create charts and objects
        a. Create a chart
        b. Format a chart
        c. Insert and format an object
    6) Manage and share workbooks
        a. Track changes, manage comments, identify errors, troubleshoot with tracing, display all changes, retain all changes
    7) Apply custom formats and layouts
        a. Apply advanced conditional formatting and filtering
        b. Prepare a workbook for internationalization and accessibility
    8) Create advanced formulas
        a. Look up data with functions
        b. Apply advanced date and time functions
    9) Create advanced charts and tables
        a. Create advanced chart elements
        b. Create and manage PivotTables

3. Detailed Description of Conduct of Course

As a practicum the course will be entirely based on projects covering the topics listed in section 2.  The content may be delivered in either a traditional lecture class or in an online format.

The course grade will be on a pass/fail basis and will be determined entirely on the quality of the workbooks submitted for the projects assigned.  

4. Goals and Objectives of the Course

This course is a practicum.  Upon the completion of the course students shall have demonstrated competence in doing the following with spreadsheets:

    1) Create and manage worksheets and workbooks
    2) Create cells and ranges
    3) Create tables
    4) Apply formulas and functions
    5) Create charts and objects
    6) Manage and share workbooks
    7) Apply custom formats and layouts
    8) Create advanced formulas
    9) Create advanced charts and tables
    10)Create output appropriate for the
    11)Select the appropriate functions to analyze data sets
    12)Develop custom formulas based on output needs

5. Assessment Measures

Students will be assessed on the spreadsheets they submit for the projects assigned.  The course will be graded pass/fail.

6. Other Course Information

None

Review and Approval

June 20, 2015