NGPF Spreadsheet Activities, Projects, & Case Studies
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ACDEFGHIJLMNOPQRSTUVWXYZ
1
TitleTypeUnitSkill 1Skill 2Skill 3Skill 4Skill 5Skill 6
2
Automate Your Checking RegisterProject01. CheckingEntering & editing dataFormatting numbersFormatting columns & rowsFormatting text within a cellEquations with relative cell referencesFormatting your entire spreadsheet
3
Save Me!Case Study02. SavingEntering & editing data
4
EXCEL: Savings Brainteaser Part IIActivity02. SavingAll skills -- linked to complete Spreadsheets playlist
5
EXCEL: Saving on an NBA SalaryActivity02. SavingAll skills -- linked to complete Spreadsheets playlist
6
Car, Home, Retirement: What's My Plan?Case Study02. Saving, 07. InvestingEntering & editing data
7
EXCEL: Build a Credit Card CalculatorActivity03. Types of CreditAll skills -- linked to complete Spreadsheets playlist
8
COMPARE: Select the Right Auto FinancingActivity03. Types of CreditEntering & editing data
9
A Tale of 2 Credit ScoresCase Study04. Managing CreditEntering & editing data
10
EXCEL: 3 Students Budget for the Semester & Unanticipated ChangesActivity05. Paying for CollegeEntering & editing data
11
Customize Your College BudgetProject05. Paying for CollegeEntering & editing data
12
Plan a Spring Break TripProject05. Paying for CollegeEntering & editing dataEquations with relative cell referencesUsing the SUM function
13
CREATE: Monthly College BudgetActivity05. Paying for CollegeEntering & editing data
14
INTERACTIVE: How Much Will Your College Actually Cost?Activity05. Paying for CollegeEntering & editing data
15
ANALYZE: Which Colleges Help Low Income Students the Most?05. Paying for CollegeEntering & editing data
16
CREATE: A Salary-Based BudgetActivity06. BudgetingEntering & editing data
17
Plan a Friendsgiving DinnerProject06. BudgetingEntering & editing dataEquations with relative cell references
18
Budget Your Event MenuProject06. BudgetingEntering & editing dataEquations with relative cell references
19
Budgeting with RoommatesProject06. BudgetingEntering & editing data
20
Moving Off Campus Project06. BudgetingEntering & editing dataEquations with relative cell referencesUsing the SUM functionCreate a complex graph or chart
21
Rein In Your WantsProject06. BudgetingEntering & editing dataFormatting columns & rows
22
Travel Costs for VacationProject06. BudgetingEntering & editing dataFormatting numbersEquations with absolute cell references
23
Calculate Your Medical ExpensesProject
06. Budgeting, 11. Insurance
Entering & editing data
24
EXCEL: Dollar Cost Averaging in ActionActivity07. InvestingEntering & editing dataEquations with relative cell references
25
EXCEL: Asset AllocationActivity07. InvestingEntering & editing dataEquations with relative cell references
26
5 Stocks on Your BirthdayProject07. InvestingEntering & editing dataCreating a multi line graph
27
Envision Your RetirementProject07. InvestingEntering & editing data
28
ANALYZE: Think You Can Beat the Stock Market? Activity07. InvestingEntering & editing data
29
Payday Loan, Bankruptcy... What Should I Do? Case Study08. Financial PitfallsEntering & editing dataEquations with relative cell referencesUsing the SUM function
30
ROLEPLAY: What If You Played the Lottery?Activity08. Financial PitfallsEntering & editing data
31
What's the Catch? Be a Savvy Consumer!Case Study08. Financial PitfallsEntering & editing data
32
EXCEL: Sum Your ExpensesActivity12. BonusEntering & editing dataFormatting text within a cellUsing the SUM function
33
Build a Basic Budget SpreadsheetProject12. BonusEntering & editing dataFormatting numbersFormatting columns & rowsFormatting text within a cellEquations with relative cell referencesFormatting your entire spreadsheet
34
Lesson Guide - Intro to SpreadsheetsLesson Guide12. Bonus
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...