CSCI019m/NURS011IS: Electronic Spreadsheet

Updated 2018-12-11

Syllabus       Excel Resources      Academic Calendar     Finals Schedule      Final

The final test is Tuesday, December 11, 2018 from 2:30 to 4:20 in HH112. (Reserved room on 1/02/2018)

Test

·         Excel file

Review for Final Test

·         Final test is Tuesday at 2:30 unless you have made arrangements to take it Monday at 8:00 (Ann, Caleb, Emily, Hannah, Valeria). The test will be in HH-112 (computer lab).

·         Skills you should know for the Excel test

·         Practice test: part 1, part 1 solution. Video 1, Video 2.

·         Practice test: part 2, part 2 solution. Video 1, Video 2.

 

Earlier classes are below…

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Day #13. Friday, 11/30/2018: Macros!

·         Interesting tech: Augmented reality in medicine.

·         Excel Resources

Homework due next Friday at 7:30 a.m.

·         Movie Macros. Instructions are in the workbook.

Day #12. Friday, 11/16/2018: Who wants to be a millionaire? Financial functions

·         Augmented Reality (Pepsi)

·         Compound Interest

·         Excel Resources

·         Financial functions template

·         A very interesting spreadsheet

Homework due 11/30/2018:

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

Day #11. Friday, 11/09/2018: Date & Time Functions

·         Interesting tech: Biometrics

·         Excel Resources 

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

Homework due next Friday at 7:30 a.m.

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

Day #10. Friday, 11/02/2018: Advanced Filters and Database ("D") Functions

·         Interesting tech: Amazon Go

·         Excel Resources

Homework due next Friday at 7:30 a.m.

·         Advanced Filters, "D" functions: Iowa Football. Deposit a digital copy in the drop box.

Day #9. Friday, 10/26/2018: VLOOKUP, another way to make decisions

·         Interesting tech: Microsoft's Seeing AI

·         Excel Resources

Homework due next Friday at 7:30 a.m.

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

Day #8. Friday, 10/19/2018: 3D Workbooks

·         Interesting technology: Bigger cell phone screens.

·         Excel Resources

Homework due next Friday at 7:30 a.m.

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

 

Day #7. Friday, 10/05/2018: Pivot Tables and Pivot Charts

·         Microsoft's vision of the future

·         Excel Resources

Homework due in two weeks (next week is fall break) at 7:30 a.m.

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

Day #6. Friday, 9/28/2018: Logical functions, making decisions

·         Excel Resources

·         Sample file

Homework due next Friday at 7:30 a.m.

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

Day #5. Friday, 9/21/2018. Visualizing data: Excel charts

·         Interesting tech: 200 countries, 200 years

·         Excel Resources

Homework due next Friday (9/28) at 7:30 a.m.

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

Day #4. Friday, 9/14/2018. Databases: Sorting and Filtering

·         Excel Resources

·         Sample file

Homework due next Friday at 7:30 a.m.

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

Day #3. Friday, 9/07/2018. 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 at 7:30 a.m.

·         WKRP payroll: Instructions. File. Deposit the file in the drop box.

Day #2. Friday, 8/31/2018. AutoFill, Functions, and Simple Formulas

·         The value of spreadsheets: retirement

·         Sample file.

·         Excel Resources

Homework due next Friday 9/07/2018 at 7:30 a.m.

·         Formulas: Football. 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 Other

Day #1. Friday, 8/24/2018. Formatting

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

·         Excel Resources

·         Sample file

Homework due next Friday at 7:30 a.m.

·         Formatting a sales 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 #14. Friday, 5/04/2018

Final Test. Tuesday, 5/08/2018, at 2:30 p.m.

·         File.