NURS011IR, CSCI019m: Electronic Spreadsheet

Updated 2014.04.04

Syllabus       EMail Guidelines       Spreadsheet Design Guidelines       Excel Home Page (MS)       Excel Resources

Day #10. Friday, 4/04/2014: VLOOKUP, another way to make decisions

·        Excel Resources

Homework due 4/11

·        VLOOKUP: Auto Insurance. Deposit a digital copy in the drop box.

Spring 2012: 13 lectures + final spread over 2 days;   Fall 2013: 12 lectures, 1 review day;   Spring 2014: 14 lectures plus final

NOTE: Did all assignments except for Patient data and Macros before spring semester 2014 started.

 

Earlier classes are below…

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Day #9. Friday, 3/28/2014: Who wants to be a millionaire? Financial functions

·        Compound Interest

·        Excel Resources

·        Spreadsheet template

·        Spreadsheet examples

Homework due 4/04

·        Financial functions. Deposit a digital copy in the drop box.

Day #8. Friday, 3/21/2014: 3D Workbooks

·        Microsoft's vision of the future

·        Excel Resources

Homework due 3/28

·        3D Workbooks: Jewelry Sales. Deposit a digital copy in the drop box.

Day #7. Friday, 3/07/2014: Pivot Tables and Pivot Charts

·        Excel Resources

Homework due 3/21/2014

·        Patient Data. Deposit a digital copy in the drop box.

Day #6. Friday, 2/28/2014: Logical functions, making decisions

·        Excel Resources

Homework due 3/07/2014

·        Logical functions: Gradebook. Deposit a digital copy in the drop box.

Day #5. Friday, 2/21/2014. Charts

·        Excel Resources

Homework due 2/28/2014

·        Charts. Deposit a digital copy in the drop box.

Day #4. Friday, 2/14/2014. Databases: Sorting and Filtering©

·        Excel Resources

Homework due 2/21

·        Iowa Football. Deposit a digital copy in the drop box.

Day #3. Friday, 2/07/2014. Absolute and Mixed Cell References

·        Sample file. Budget, addition, compound interest.

·        Excel Resources

Homework due 2/14

·        Absolute/Mixed cell references: Real Estate. Deposit a digital copy in the drop box.

Day #2. Friday, 1/31/2014. AutoFill, Functions, and Simple Formulas

·        Sample file.

·        Excel Resources

Homework due 2/07

·        Formulas: WKRP. Deposit a digital copy in the drop box.

Day #1. Friday, 1/24/2014. Formatting

·        Learning Outcomes: Common skills, Spreadsheet skills, Database skills

·        Excel basics. Excel Resources.

·        Sample file

·        The value of spreadsheets: retirement

·        Culture: Visicalc, the world's first electronic spreadsheet

Homework due 1/31

·        Formatting: GPA. Deposit a digital copy in the drop box.

·        Read, sign, and turn in: Assignment, Test, and Homework policies.

Day #11. Friday, 4/11/2014: Advanced Filters and Database Functions

·Excel Resources

Homework 4/25

Day #12. Friday, 4/25/2014: Date & Time Functions

·Excel Resources

Homework due 5/02

Day #13. Friday, 5/02/2014: Macros

·Excel Resources

Homework due 5/09

Day #13. Friday, 5/09/2014: Review

·Excel Resources

Final Test. Thursday, 5/15/2014

Day Other