CSCI019m/NURS011IS: Electronic Spreadsheet

Updated 2019-05-11

Syllabus       Excel Resources      Academic Calendar     Finals Schedule      Final

The final test is Thursday, May 9, 2019 from 2:30 to 4:20 in HH112.

 (Reserved room on 1/02/2018)

Day #14. Friday, 5/03/2019

·         Practice test: Part 1. Part 2.

·         Solution: Part 1. Part 2.

·         Sheet 1 instructions for printing. Video solutions: Part 1, video 1. Part 1, video2. Part 2, video 1. Part 2, video 2.

Thursday, 5/09/2019. Final test

·         Final

 

 

 

 

 

 

 

 

Day Other

Day #12. Friday, 4/26/2019: Who wants to be a millionaire? Financial functions

·         Compound Interest

·         Ben Franklin

·         Compound Interest8th wonder of the world

·         Average annual stock market return

·         Financial functions template

·         Excel Resources

·         A very interesting spreadsheet

Homework due next Friday:

·         Financial Functions homework. Deposit a digital copy in the drop box.

Day #11. Friday, 4/12/2019: Date & Time Functions

·         Interesting tech: Biometrics

·         Excel Resources 

·         Cool applications of Excel's date functions: Holidays, Birthday, Calendar

Homework due in 2 weeks (next Friday is Good Friday):

·         Instructions. Workbook. Deposit a digital copy in the drop box.

Day #10. Friday, 3/29/2019: Advanced Filters and Database ("D") Functions

·         Interesting tech: Amazon Go

·         Excel Resources

Homework due Friday, April 12:

·         Advanced Filters, "D" functions: Sioux City Weather.

Friday, 4/05/2019: No class. Tom is out of town

Day #9. Friday, 3/22/2019: VLOOKUP, another way to make decisions

·         Excel Resources

Homework due next Friday

·         VLOOKUP: Gradebook. Instructions. Data file. Deposit a digital copy in the drop box.

Day #8. Friday, 3/15/2019: 3D Workbooks

·         Interesting technology: Bigger cell phone screens.

·         Excel Resources

Homework due next Friday

·         3D Workbooks: Instructions. Data file. Deposit a digital copy in the drop box.

Friday, 3/8/2019: Spring break

Day #7. Friday, 3/01/2019: Pivot Tables and Pivot Charts

·         Microsoft's vision of the future

·         Excel Resources

Homework due in two weeks (next week is spring break)

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

Day #6. Friday, 2/22/2019: Logical functions, making decisions

·         Excel Resources

·         Sample file

Homework due next Friday

·         Logical functions: Instructions. Data file. Deposit a digital copy in the drop box.

Day #5. Friday, 2/15/2019. Visualizing data: Excel charts

·         Interesting tech: 200 countries, 200 years

·         Excel Resources

Homework due next Friday

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

Day #4. Friday, 2/08/2019. Databases: Sorting and Filtering

·         Interesting tech: Microsoft's Seeing AI

·         Excel Resources

·         Sample file

Homework due next Friday

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

Day #3. Friday, 2/01/2019. Absolute and Mixed Cell References

·         Interesting tech: the future of football?

·         Sample file. Budget, addition, compound interest, loan payments.

·         Excel Resources

Homework due next Friday

·         Real Estate: Instructions. Starting file. Deposit the file in the drop box.

Day #2. Friday, 1/25/2019. AutoFill, Functions, and Simple Formulas

·         Interesting TV tech from CES: LG Rollable TVLG waterfallSamsung 219" TV

·         The value of spreadsheets: retirement

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

·         Sample file.

·         Excel Resources

Homework due next Friday

·         Formulas: NFL Passers. Instructions. Data file. Deposit the file in the drop box.

·         If you haven't already done so: Read, sign, and turn in: Assignment, Test, and Homework policies.

Day #1. Friday, 1/18/2019. Formatting

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

·         Excel Resources

·         Sample file

Homework due next Friday

·         Formatting a spreadsheet: Instructions. Start with this file. Your result should look like this. Put your finished worksheet in the drop box.

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

 

Day #13. Friday, 4/26/2019: Macros!

·         Excel Resources

Homework due next Friday

Test 

Final Test. Tuesday, 5/07/2019, at 2:30 p.m.

·         File.

 

Earlier classes are below…