Learning objectives

By the end of these lessons, students will be able to:

  • Utilize a database, such as a spreadsheet, to collect, organize, graph, and analyze data to facilitate problem-solving and decision-making

  • Curate information from digital sources using a variety of tools and methods to create collections of artifacts that demonstrate meaningful connections or conclusions

  • Apply basic formulas (add, subtract) and advanced formulas (example: using =SUMIF to calculate costs)

  • Differentiate between formulas with absolute and relative cell references

Course outcomes

This course will teach you to draft something similar to these example student outcomes. 

Course curriculum

These lessons are included in your course:

    1. Budget to Make Good Financial Decisions

    2. Long-Term Spending Decisions

    3. Review Spreadsheet Terms

    4. Research and Collect Data

    5. Research Costs

    6. Add Rows and Duplicate Formulas

    7. Use Data to Inform a Decision

    8. Using Formulas to Inform Decisions

    1. Use Code for Decision Making

    2. Set Up Your Housing Spreadsheet

    3. Research and Record Rental Options

    4. Create Variables to Hold Two Locations

    5. Communicate with the API

    6. Find the Distance Between Two Points

    7. Get Locations from Spreadsheet

    8. Use Coding to Help Solve Problems

    1. Develop a Budget

    2. Copy Data and Create a Summary Table

    3. Calculate Total Expenditures

    4. Categorize Expenditures

    5. Label and Calculate Category Totals

    6. Use Data Validation to Make Your Spreadsheet More Reliable

    7. Visualize the Data and Make Decisions

    8. Develop a Budget Wrap Up

    1. Introduction to Car Loans

    2. Loan Terms and APR

    3. Create a Loan Amounts Table

    4. Absolute Values and Currency Formatting

    5. Calculate Totals for Interest and Amount Paid

    6. Research Cars in Your Price Range

    7. Car Loans Wrap Up

    1. Plan a Vacation

    2. Set Up Your Spreadsheet and Start Your Research

    3. Transportation

    4. Lodging/Accommodations

    5. Food

    6. Attractions and Souvenirs

    7. Review of Formulas and Visuals

    8. Vacation Wrap Up

    1. Budgets

    2. Assessment

    3. Reflection

About this course

  • $49.99
  • 42 lessons
  • 2 hours of video content

You may also like

Browse other courses in our catalogue that may be of interest: