PMB STEP 6: Grocery Day

OVERVIEW
Students should learn the basics about finding their first job based on the college or training they chose. Make sure that they understand that their first job may be in the field they chose, but not necessarily the position they see themselves in to start off with. That will lead to them choosing a place to live and then understanding the community they are a part of. Students will continue to work on their Personal Monthly Budget Project by creating a map of their new neighborhood and locating businesses, organizations, and stores with basic needs and other necessities that will make their new home more comfortable.  Today students will create a basic food menu for the week and use time in class to shop online for the items they chose.

OBJECTIVE(S) / (SWBAT)
Participate in-class discussions about different places that might be needed in your new neighborhood.

Complete ALL Documents, Spreadsheets, and Google Forms associated with the PMB Project.

Open, Copy, Share, and Start the PMB Google Spreadsheet for PMB Project

Complete the Personal Monthly Budget Worksheet Section for STEP 6: Gorcery Day

LINKS & DOCUMENTS (Open Documents, Click FILE and MAKE A COPY)
Primary Document for Personal Monthly Budget Project (500pts)
PMB GOOGLE DOCUMENT DIGITAL WORKSHEET PACKET

Primary Spreadsheet for Personal Monthly Budget Project
PMB GOOGLE SHEET TEMPLATE (Click Here)

Simple Survey to list choices from Steps 3 and 4 yesterday:
PMB START-UP SHEET TFDL2022 SURVEY

PROJECT

To plan a weekly meal menu and shop for items on the list. To identify prices and differences in the quality of different items. To be able to accurately create a personal menu, shopping list, and translate your purchases into an online budget form for evaluation.

STEP BY STEP
1. Complete Weekly Menu Form - Get it Approved Prior to Creating Grocery List
2. Complete Grocery List Based on Menu Choices - Get it Approved Prior to Shopping
3. Shop online for items on Grocery List and compare quality and prices.
4. Total your Grocery Spending and Enter All Items on Shopping List in Budget Online (PMB)
5. Share your menu and list with the class during final presentations.

Please use the handout to plan your menu for a week. I would like you to plan at least 2 dinners for 2 people and a family dinner (6 people or more) for the weekend sometime. It can be breakfast, lunch, or dinner, but include anything you would normally serve. Once your menu is complete, make a grocery list. In addition to groceries, there is a list of other items (BELOW) that you will need to keep at your new apartment. Detergent, soap, etc. You may also include any items you might actually use regularly on your shopping list.

Additional Items to Buy: Laundry Detergent, Soap, Shampoo, Deodorant, a Mop, a Broom, All-Purpose Cleaner, Light Bulbs, Dish Soap, 3 2-Liter Bottles of Soda (ie. Coca Cola, Pepsi, etc.), Band-Aids, Cold Medicine, and a Bucket, Tylenol or Advil, Batteries and a Flashlight, a Basic Tool Set, a Wiffle Ball Bat Set, and M&M's.

Finally, go to the website below and price everything you will need. You may need to make substitutions, but you will get a good general idea of prices for your weekly shopping trip. You will enter these figures on your monthly budget (remember that this sheet and shopping list is only for one week) when you are finished as actual costs.

Here are a couple of places to shop. You may also look for other online grocery stores, pharmacies or other providers. They must list individual item pricing and you need to figure out delivery if you do not have one of the stores local to your new apartment. (Example: You can price things at Target.com, but you must figure out shipping costs if you do not have a Target store locally. You must also figure out how to get your purchases home if you do not have a car.)

https://www.freshdirect.com/index.jsp

http://www.amazon.com/

https://www.lifewire.com/groceries-online-3482646

YOU MUST ADD EVERY ITEM ON YOUR SHOPPING LIST TO THE PERSONAL SHOPPING LIST PAGE OF YOUR DATA SHEET ON THE FAMILY MONTHLY BUDGET. MAKE SURE YOU CREATE AN AREA FOR YOUR GROCERY SHOPPING FROM THE SHOPPING LIST YOU COMPLETED FOR YOUR MOVING DAY!

ESSENTIAL QUESTION(S)
What will my weekly/monthly food bill look like?  How do I fit it into my budget?

What services or stores are most important, and which ones would be considered luxuries?

What items do I need to buy to survive, and what is not necessary. Based on the selection of my apartment, where can I go to buy these items, and how much will they cost.

ACADEMIC STANDARD(S) (PA)
PA Career Education & Work Standard 13.3.11.D

Analyze Budgets and Pay Statements to include paychecks, bank statements, bills, and other documents that would be required to keep a Personal Monthly Budget

Jump$tart Standards: Financial Responsibility Standards 1, 2 and 4

National Standards for Economics:
Standard 2: Decision Making

PA Social Studies:6.2.12.D: Evaluate changes in economic institutions over time (e.g., stock markets, non-government organizations)

PMB STEP 5b: Map Project (Your New Neighborhood)

OVERVIEW
Students should learn the basics about finding their first job based on the college or training they chose. Make sure that they understand that their first job may be in the field they chose, but not necessarily the position they see themselves in to start off with. That will lead to them choosing a place to live and then understanding the community they are a part of. Students will continue to work on their Personal Monthly Budget Project by creating a map of their new neighborhood and locating businesses, organizations, and stores with basic needs and other necessities that will make their new home more comfortable.

OBJECTIVE(S) / (SWBAT)
Participate in-class discussions about different places that might be needed in your new neighborhood.

Complete ALL Documents, Spreadsheets, and Google Forms associated with the PMB Project.

Open, Copy, Share, and Start the PMB Google Spreadsheet for PMB Project

Complete the Personal Monthly Budget Worksheet Section for STEP 5a: MOVING DAY

LINKS & DOCUMENTS (Open Documents, Click FILE and MAKE A COPY)
Primary Document for Personal Monthly Budget Project (500pts)
PMB GOOGLE DOCUMENT DIGITAL WORKSHEET PACKET

Primary Spreadsheet for Personal Monthly Budget Project
PMB GOOGLE SHEET TEMPLATE (Click Here)

Simple Survey to list choices from Steps 3 and 4 yesterday:
PMB START-UP SHEET TFDL2022 SURVEY

Digital MAP Project

NOTE: Until Tech Freire allows students to use Google Maps (My Maps) Application, please just create a list of the locations below on your PMB Google Document Worksheet for Step 5!  You may also create an account on Microsoft and use BING MAPS to create a map.

Today you will be creating a GOOGLE MAP of your new home and work area. Please sign in to GMAIL and then follow Google site to Google Maps. Below is a link to a sample map that I created for myself. It assumes that my first job out of college was teaching here. I located our school, a local apartment, and I saved the route I take to work (use Get Directions and save the result to your map). I also included most of the information that you will have to find for yourself. 

See my example BING MAP at the following link:  https://www.bing.com/maps?&cp=39.978385~-75.161032&lvl=15&osid=e9c799c2-052e-4b92-9a3e-73ccae890b94&v=2&sV=2&form=S00027

Once you have looked at my map, your assignment today is to CREATE your own Digital  Map that includes the following items:

WORK LOCATION

HOME (APARTMENT) LOCATION

ROUTE YOU TAKE TO WORK

You must also include the following:
GROCERY
SHOPPING MALL/CENTER
LAUNDRY/DRY CLEANER
COFFEE SHOP
PUBLIC TRANSPORTATION (Closest Bus or Train)
CLOSEST MAJOR AIRPORT (In case you need to fly home to Philly)
HOSPITAL
DOCTOR'S OFFICE
DENTIST'S OFFICE
CHURCH/PLACE OF WORSHIP (Optional)
THREE (3) DIFFERENT RESTAURANTS
TWO (2) FUN THINGS TO DO

Please add these items to your PMB 

This exercise will give you an idea of what types of things you need to look for if you move to another city someday to take a job or start college. Even if you share an apartment/house with others, you should know this information.

ESSENTIAL QUESTION(S)
What are some of the places in my new neighborhood that I will go to often?

What services or stores are most important, and which ones would be considered luxeries?

What items do I need to buy to survive, and what is not necessary. Based on the selection of my apartment, where can I go to buy these items, and how much will they cost.

ACADEMIC STANDARD(S) (PA)
PA Career Education & Work Standard 13.3.11.D

Analyze Budgets and Pay Statements to include paychecks, bank statements, bills, and other documents that would be required to keep a Personal Monthly Budget

Jump$tart Standards: Financial Responsibility Standards 1, 2 and 4

National Standards for Economics:
Standard 2: Decision Making

PA Social Studies:6.2.12.D: Evaluate changes in economic institutions over time (e.g., stock markets, non-government organizations)

PMB STEP 5a: MOVING DAY

OVERVIEW
Students should learn the basics about finding their first job based on the college or training they chose. Make sure that they understand that their first job may be in the field they chose, but not necessarily the position they see themselves in to start off with. That will lead to them choosing a place to live and then understanding the community they are a part of. Students will complete a Worksheet, a Google Form Reflection, and sign up for our class Virtual Stock Market Game TFDL2021.

OBJECTIVE(S) / (SWBAT)
Participate in-class discussions about job choices based on career decisions.

Complete Google Form Survey (Yesterday's Choices)

Open, Copy, Share, and Start the PMB Google Spreadsheet for PMB Project

Complete the Personal Monthly Budget Worksheet Section for STEP 5a: MOVING DAY

LINKS & DOCUMENTS (Open Documents, Click FILE and MAKE A COPY)

Primary Document for Personal Monthly Budget Project (500pts)

PMB GOOGLE DOCUMENT DIGITAL WORKSHEET PACKET

Primary Spreadsheet for Personal Monthly Budget Project

PMB GOOGLE SHEET TEMPLATE (Click Here)

Simple Survey to list choices from Steps 3 and 4 yesterday:
PMB START-UP SHEET TFDL2022 SURVEY

MOVING TO YOUR NEW CITY

At your graduation party, your friends and family got together and gave you $2000 in cash as a gift to get you started.  Add these funds to your Personal Monthly Budget, and use it to go shopping for some basic items you will need to survive.  You must have a plan to move to your new city, and once there, figure out how you will get to work, get around town, and do your shopping.  Tomorrow we will be creating maps of the area using digital tools, today you need to focus on shopping for the basic items you will need to start your life in this new area.

Now you need to furnish your apartment to live in. Find a list of the following sources, and add it to your shopping list page.

1. Transportation around town: (Bike, Car, Public Transportation, Walk, etc.)

2. Basic Furniture: Bed, Couch, Table & Chairs, Lamps, Desk, Lights, TV, Stereo, Dresser, Computer, and other major items:

3. Household Goods: Dishes, Pots&Pans, Glassware, Silverware, Towels, Sheets, Blankets, Pillows, Plants, etc.:

List each item on the shopping list sheet of your SPREADSHEET. You must keep track of everywhere online you shop and enter your spending in your checkbook ledger.  Add links to each product you plan to buy, total the cost of your purchases and add it to your overall budget. All of your spending will be tracked on this ledger for the month. Credits are deposits and Debits are spending/checks etc.


ESSENTIAL QUESTION(S)
What are some of the decisions I will make to have basic financial stability?

What items do I need to buy to survive, and what is not necessary.  Based on the selection of my apartment, where can I go to buy these items, and how much will they cost.

ACADEMIC STANDARD(S) (PA)
PA Career Education & Work Standard 13.3.11.D

Analyze Budgets and Pay Statements to include paychecks, bank statements, bills, and other documents that would be required to keep a Personal Monthly Budget

Jump$tart Standards: Financial Responsibility Standards 1, 2 and 4

National Standards for Economics:
Standard 2: Decision Making

PA Social Studies:6.2.12.D: Evaluate changes in economic institutions over time (e.g., stock markets, non-government organizations)

PMB STEP 3 & 4: First Job & Apartment

OVERVIEW
Students should learn the basics about finding their first job based on the college or training they chose.  Make sure that they understand that their first job may be in the field they chose, but not necessarily the position they see themselves in to start off with.  That will lead to them choosing a place to live and then understanding the community they are a part of. Students will complete a Worksheet, a Google Form Reflection, and sign up for our class Virtual Stock Market Game TFDL2021.

OBJECTIVE(S) / (SWBAT)
Participate in class discussion about job choices based on training decisions.

Complete Google Form Survey

Complete the Personal Monthly Budget Worksheet Section for STEP 3.

PERSONAL MONTHLY BUDGET STARTING POINT

Today you will build on the research you completed earlier this week. You are responsible for not only finding a college and major you are interested in but finding your first job after college.

YOU MAY NOT FIND A JOB IN PHILADELPHIA OR THE REGIONAL AREA.

You must find an "ENTRY-LEVEL" job outside the Philadelphia Area (Philadelphia, Montgomery, Bucks, Delaware, and Chester, Camden, Burlington, and Gloucester Counties are off-limits).

Use the College and Major you chose on Monday and go to the following website https://www.aftercollege.com/. Look on the right side of the opening page and you will see a box that says "Explore Curated Jobs". Select a College you are interested in attending (SCHOOL). Enter a (MAJOR) you are likely to study. Set the (GRADUATION DATE) for MAY of 2021 and click SHOW ME THE JOBS.

If you chose professional training that did not require college, you must use Indeed.com, Monster.com, Careerbuilder, or other employment search sites to find your first job away from the Philadelphia area. You will have to search in a part of the country that interests you, and you still need to identify how you were trained to work in your chosen field. Ask me if you have any questions about this.

If you joined the Military, ask me to help you identify a base to live near so you can complete the budget that way.

You may have to SIGN IN (Create A Free Account). Use your class GMAIL to sign up, and select a password you can remember.

Now you must choose a job that you are interested in. Once you find the job you must research where you will be working. Look up the company that is hiring for that position and where the office is. You will need to find an actual, accurate address to use. You must also copy the Job Title and Job Description for use later.

Next time we are in class you will find out what your salary is based on your job location and title. This will be your Gross Pay before taxes and deductions, so you can spend that money on living expenses and anything else you need to buy to survive. We will discuss your purchases in more depth next week. For now, once you know what you are doing for a living and where you are working, you are now ready to find an apartment. You need to find a place to live near where you work, or someplace that will not cost a fortune to commute from. Everyone must live outside the Philadelphia Area.

YOU MAY NOT LIVE WITH FAMILY, but if you and someone from class have chosen the same place to work (same City or Area), you may share an apartment or living arrangement. This will help your overall budget. You must still keep separate budgets, but you can share the costs. YOU MUST HAVE YOUR OWN BEDROOM FOR PRIVACY. Depending on where you live, you will have to decide how much to spend on transportation for work. You may use any Real Estate or Apartment Finder website to find places to live.

Once you have found all the information above and written it down on paper, please fill out and submit the following form completely (The more accurate and complete your answers are, the easier it will be to do additional tasks for your budget):

PMB START-UP SHEET TFDL2022 SURVEY

I was going to assign cities for you to find jobs in, but this is more realistic. If you take this project seriously, you will be surprised at what you will learn about how much things cost and how keeping an accurate budget will save you money, time, and aggravation. Previous students who complete this project correctly have enjoyed it and learned a lot about their future. I hope you have fun working on it too.

ESSENTIAL QUESTION(S)
What are some of the decisions I will make to have basic financial stability?

How can I invest in stocks and funds?

ACADEMIC STANDARD(S) (PA)
PA Career Education & Work Standard 13.3.11.D

Analyze budgets and pay statements, such as but not limited to Charitable contributions Expenses Gross pay Net pay Other income Savings Taxes

Jump$tart Standards: Financial Responsibility Standards 1, 2 and 4

National Standards for Economics:
Standard 2: Decision Making

PA Social Studies:6.2.12.D: Evaluate changes in economic institutions over time (e.g., stock markets, non-government organizations)

PMB Step 2: Budgeting & Investing

OBJECTIVE
Students should learn the basics about savings accounts and investing in the Stock Market. Students will use independent learning time to navigate through a series of videos to help them better understand basic Personal Budgets, Saving Money, Credit Card Tips, and how to Invest in Company Stocks.

STOCK MARKET BASICS PRESENTATION (CLICK HERE)

STEP BY STEP
1. Open the STOCK MARKET BASICS PRESENTATION (See Link Above) and Review the Slides.
2. Watch the Videos Below and Complete the Class Worksheet & Vocabulary List (on the form listed above.)
3. Open your MarketWatch.com Account and spend the rest of class buying or selling stocks.

ENRICHMENT LINK
If you would like to learn more about investing, please review the following article: 

Investing VS Gambling Article (Click Here).

Second, watch each video link below on your own. After each video, answer the questions on the worksheet for today. When you have completed the worksheet questions, please research and fill in the Vocabulary Section on the back of the sheet. Turn in the sheet for credit!

1. Personal Budget Tips:
https://www.youtube.com/watch?v=0_GZOr4l7P0

2. How To Save Money:
https://www.youtube.com/watch?v=UxC_KaCD8KQ

3. Savings Account Video:
https://www.youtube.com/watch?v=j0ttAaz32VU

4. Credit Card Tips:
https://www.youtube.com/watch?v=en6IfLFlrJM

5. Company Investing Tips
https://www.youtube.com/watch?v=6MPtq56CT1I

ESSENTIAL QUESTION(S)
What is a Budget? What Vocabulary Words are associated with this project? How do my financial choices affect my future ability to pay for college, a home, raise a family, or afford other items during my lifetime?

What steps can I take now to insure a strong financial future?

OBJECTIVE(S) (SWBAT)
Open, Make a Copy, and Share the Personal Monthly Budget Worksheet to start the project!

Personal Monthly Budget Worksheet Link (Click Here)

Work on PMB STEP 2: Budgeting & Investing

Participate in-class discussion about the Personal Monthly Budget Project.

ACADEMIC STANDARD(S)
Academic Standard (PA): PA Career Education & Work Standard 13.3.11.D

Analyze budgets and pay statements, such as but not limited to Charitable contributions Expenses Gross pay Net pay Other income Savings Taxes

Jump$tart Standards: Financial Responsibility: Standards 1, 2 and 4

National Standards for Economics
Standard 2: Decision Making

PA Social Studies:6.2.12.D: Evaluate changes in economic institutions over time (e.g., stock markets, non-government organizations)

Personal Monthly Budget (PMB) Introduction

OVERVIEW

High school students often tire of being asked, “What are your career plans?” Some students have no idea how to answer the question. Others may give a rote answer just to stop the questions. There are actually so many career choices available that high school students can pursue that they need direction in order to discover their own interests and skills. They may discover that opportunities are available they never even thought of before. Here are just a few suggestions that may help in career research for high school students.

BRAINSTORMING
This may seem like a simple suggestion, but it is a good first step. Students should make a list of things they like and do not like to do and classes they like and do not like. For example, do they like history class but hate math class or vice versa? Do they like to work in groups or do they prefer to work alone? Do they like to work indoors or outdoors?

Source: https://resilienteducator.com/classroom-resources/how-to-help-high-school-students-with-career-research/

OBJECTIVE

Students will use online research tools, conversation, and creativity to identify a prospective college or career path for themselves. Based on the selection of colleges they choose, they will identify a major course of study as well. Once identified, students will perform a number of tasks to record and explain their choices. Students will be asked to complete the following tasks as they reflect on their choices:

1. Project Worksheet (FILE / MAKE A COPY):

Personal Monthly Budget Worksheet (PMB)

2. Navigation and Completion of College/Major Choice Project
3. Completion of Online Form to record choices.
4. Completion of Google Document (SHARE) to outline information about their choice.

RESEARCH WEBSITES / ARTICLES

Best Jobs Without a College Degree (Article)

40 Jobs You Can Get Without A College Degree (Article)

Join the Military (Information Link)

EducationPlanner.org (Click Here)

INFORMATIONAL VIDEO(S)

https://bigfuture.collegeboard.org/explore-careers/college-majors/the-college-major-what-it-is-and-how-to-choose-one

Please describe what major you are interested in and why you chose it at this point in your life. I realize college is a few years away, and I am sure your interests might change between now and when you are going to go to school, but you will use the information you develop today to research future careers tomorrow. 

Eventually, you will be responsible for choosing a College, Career, and your first job after college to complete the PERSONAL MONTHLY BUDGET PROJECT (PMB) over the next few weeks!

Please go to CollegeBoard.Org and create an account. (CLICK HERE). You will use this site to research your College and Major and use the information tomorrow to decide what your first career might be. You must complete the COLLEGE SEARCH and MAJOR AND CAREER SEARCH sections of the CollegeBoard.Org website prior to completing the survey below.

IF YOU CAN NOT CREATE AN ACCOUNT ON COLLEGEBOARD, PLEASE GO TO THE FOLLOWING LINK:

https://bigfuture.collegeboard.org/college-search

If you choose not to pick a college and major, you must identify another path to a career. You will need to identify how you will receive training and complete all the steps below based on that training choice. I will explain what I mean in class.

When you have completed today's research, please add the name of your college and the major you have chosen to the Google Spreadsheet by answering the following questions on this link:

COLLEGE & MAJOR SURVEY (PMB PROJECT 2022)

Next, you must open add the following information to the PMB Google Document:

College Name
College Address
Major Area of Study you would be interested in.
Sport you are interested in participating in.
Extra-curricular activity you might be in.

You should find out all the information listed above about the college or career training program you are most interested in. You need to SHARE this document with me for credit. 

In the case of a career training program (ITT Tech, Electrical Union, etc.) you will need to fill in as much information as possible.

Tomorrow we will discuss Financial Literacy and Financial Planning, and you will see a list of entry-level positions that people could choose based on a variety of decisions. You will be entering your college and major and choosing a career with this site. Your choices will determine where you will live and what career you will start with. We will also be discussing financial planning and investing later this week.

ESSENTIAL QUESTION(S)

What careers am I interested in?  What training would be required to start in those careers?  How can I figure out what my interests, skills, and abilities are, and how will they help me identify career fields I might be interested in?

How do my career choices, and training or college choices affect my personal finances?

OBJECTIVE(S) (SWBAT)
Open, Make a Copy, and Share the Personal Monthly Budget Worksheet to start the project!

Participate in-class discussion about the Personal Monthly Budget Project.

Utilize the resources above to search for future careers.

ACADEMIC STANDARD(S)
Academic Standard (PA): PA Career Education & Work Standard 13.3.11.D

Analyze budgets and pay statements, such as but not limited to Charitable contributions Expenses Gross pay Net pay Other income Savings Taxes

Jump$tart Standards: Financial Responsibility: Standards 1, 2 and 4

National Standards for Economics
Standard 2: Decision Making

PA Social Studies:6.2.12.D: Evaluate changes in economic institutions over time (e.g., stock markets, non-government organizations)

MarketWatch.com Investment Game

GO TO THE BOTTOM OF THIS POST TO JOIN THE CLASS VIRTUAL STOCK MARKET GAME RIGHT NOW! There will be prizes for top earners in each class!

OVERVIEW

Students should learn the basics about savings accounts and investing in the Stock Market. Students will use independent learning time to navigate through a series of videos to help them better understand basic Personal Budgets, Saving Money, Credit Card Tips, and how to Invest in Company Stocks. Students will complete a Worksheet, a Google Form Reflection, and sign up for our class Virtual Stock Market Game TFDL2021. 

OBJECTIVE(S) / (SWBAT)
Participate in class discussion about investing

Complete Google Form Survey

Sign-Up and Play MarketWatch.com Contest with class

Start by watching the video below to learn about Basic Budgeting Tips:

NEXT.....Learn the Basics of the Stock Market with this video:

Investing Basics: Stocks

Make sure you spend some time reviewing the presentation from our class discussion at the link below:

BUDGETING & STOCK MARKET BASICS GSLIDES LINK

Step by Step Instructions:
1. Use the information below to join our TFDL2022 Virtual Stock Market Game and start trading stocks and funds with $10,000 in "virtual" funds. Prizes will be awarded in April!

MarketWatch Virtual Stock Market Game 2021

Join now, and see if you can win my 'TFDL21-22' competition. The more participants the higher the level of competition. Can you master the market?

Game created by: Harvey Scribner
Use the information and directions below to join the game.
Open this link and read the competition summary.

https://marketwatch.cmail19.com/t/n/j-l-e22959998dbe11eca1ac3790816ed46f-l-t-r-l/

Click the 'Join Now' button to get started. Password: TFDL922

YOUR USERNAME MUST BE YOUR FIRST-INITIAL-LAST-NAME-TFDLP# so I can identify you on the game ranking list for credit.

You should use your personal email address, not your school address, so you can recover the password if necessary.  Follow the instructions and start trading!  Thanks for Playing!

(❗️) STOCK MARKET GAME RULES & GRADING

1.  Students must create a username as listed above and create an account using their personal email address so they can recover the password if necessary.

2.  Students must make a minimum of ten (10) trades per week to qualify for the class contest.

3.  The Student in each class who makes the most PROFIT by MARCH 31st, 2022 will win the class prize.  The student with the most PROFIT by APRIL 30th, 2022 will be declared the overall winner.  Honorable Mentions will include those who do the most research, lead class discussions on why certain stocks should be bought, sold, or avoided and why, and other positive interactions or responses.

  Class Winner(s): $10 gift card of choice

  Overall Winner:  $25 gift card of choice

  Honorable Mention(s):  $5 gift card of choice

4.  Students will be given points for Creating an Account (20 pts. Effort), minimum trading per week (20 pts. Effort per Week), tracking stocks and completing research on possible investments (Extra-Credit as Completed), and completing a game-ending survey (100 pts. Mastery).  

ESSENTIAL QUESTION(S)
What are some of the decisions I will make to have basic financial stability?

How can I invest in stocks and funds?

ACADEMIC STANDARD(S) (PA)
PA Career Education & Work Standard 13.3.11.D

Analyze budgets and pay statements, such as but not limited to Charitable contributions Expenses Gross pay Net pay Other income Savings Taxes

Jump$tart Standards: Financial Responsibility  Standards 1, 2 and 4

National Standards for Economics:
Standard 2: Decision Making

PA Social Studies:6.2.12.D: Evaluate changes in economic institutions over time (e.g., stock markets, non-government organizations)

Basic Banking Simulations & CPS2022

CLASSROOM PERCEPTION SURVEY 2022

Please click the link below and complete the Classroom Perception Survey 2022.  This is a completely anonymous survey and will help your teachers adjust and modify our classrooms to be more "learning-friendly".  Thank you for your time and effort with this request.  No information will be tracked or recorded about your responses, so please be as honest as possible while not being hostile or offensive.  The more description you add, the easier it will be to make specific changes.  

Classroom Perception Survey 2022 Link (Click Here)

OVERVIEW

Bank Accounts – Teens should know how a bank account works and the fees associated; not only the account fees and how they incur (min balance amounts, activity fees, etc.) but also the ATM fees. Young people tend to like to do things online so they can search for a low-cost, basic online checking account. And while check writing may someday be obsolete, don’t forget to show them how to write a check and explain how it works. Also, review how debit cards work, how to safeguard all their information, and how too many swipes at the checkout counter can lead to costly and embarrassing overdraft charges.

Resource: https://www.forbes.com/sites/markavallone/2016/06/07/five-financial-concepts-your-teens-should-understand-before-high-school-graduation/#54a5b6fc4eab

WEBSITES & RESOURCES
http://www.themint.org/teens/writing-a-check.html

https://message.bankofamerica.com/onlinebanking_demo/OLB_Simulator/index.html#/accounts/overview

https://message.bankofamerica.com/onlinebanking_demo/mobileApp_Simulator/

https://www.motc.gov.qa/en/ditoolkit/migrant-workers/cash-machine-simulator-atm

(❗️)GMAIL ASSESSMENT ACTIVITY
Go to your GMAIL and click COMPOSE. Send an email to Mr. Scribner (harvey.scribner@techfriere.org) with the following information: 

TO:  harvey.scribner@techfreire.org

SUBJECT:  Basic Banking Simulations

Body of Message:  Please write a full paragraph to explain what you learned by completing the activities on the basic banking websites listed above.  Have you ever used credit/debit cards or had to actually complete banking tasks online?

R.A.C.E.S. Method R - Repeat the Question, A - Answer the Question, 

C - Cite Evidence, E - Examples / Explanation, S - Summarize your Thoughts

STEP BY STEP
Each student will click the links above and follow ALL DIRECTIONS! You will be learning, if you have never done it before, how to use an ATM, Write A Check, Deposit A Check, Make A Payment, and Pay Online Bills. Each activity has a link to a resource or simulation. You may complete these steps more than once to make sure you understand how to do these simple banking transactions.

Make sure you spend some time on each resource learning how to complete basic functions of banking and personal finance. When you are done, please send an email to Mr. S (harvey.scribner@techfriere.org) describing some of the tasks you were required to complete, and some of the things you learned by completing these requirements.

ESSENTIAL QUESTION(S)
How do I access my personal banking electronically?

How can I deposit money, withdraw money, pay bills, or complete other basic banking transactions online?

OBJECTIVE(S)  (SWBAT)
Complete Google Form Survey (Classroom Perception Survey 2022)

Participate in-class discussion about basic banking

Utilize the resources above to become familiar with online banking tasks.

ACADEMIC STANDARD(S)
Academic Standard (PA): PA Career Education & Work Standard 13.3.11.D

Analyze budgets and pay statements, such as but not limited to Charitable contributions Expenses Gross pay Net pay Other income Savings Taxes

Jump$tart Standards: Financial Responsibility: Standards 1, 2 and 4

National Standards for Economics
Standard 2: Decision Making

PA Social Studies:6.2.12.D: Evaluate changes in economic institutions over time (e.g., stock markets, non-government organizations)

Payroll Spreadsheet Project (Formulas & Reference Cells)

OVERVIEW

Last week you created TIMECARDS. Today you will we will walk through POSTING IT to PAYROLL SHEETS on GOOGLE DRIVE. You will be required to follow along in class. At the appropriate time, you will complete the work on your own. 

For credit you must SHARE your PAYROLL SHEET with Mr. S (harvey.scribner@techfreire.org). When complete, you should know how to enter data on a form, manipulate the form to complete basic functions. You will also know how to automate the form by copying functions and formulas to additional cells.

PROJECT DELIVERABLES

Start by reviewing the following sheet of instructions either online or use the copy at your desk:

Student Payroll Project Google Document Directions Worksheet (Click Here)

(❗️) Student Payroll Project Spreadsheet (Click Here)

Make a Copy to add it to your Google Drive to create a PAYROLL SHEET for the whole company of characters. We will work on this in class. Pay attention and follow along and you will be able to complete the work with little effort. When complete, simply share your work with Mr. S for comments/grading.

See examples of blank and finished payroll sheets below. Numbers in the active worksheet must be formulas, not just numbers entered alone. The worksheet must be "automated" for credit.

(❗️)GMAIL ASSESSMENT ACTIVITY
Go to your GMAIL and click COMPOSE. Send an email to Mr. Scribner (harvey.scribner@techfriere.org) with the following information: 

Answer the following questions in an email to Mr. S:

(harvey.scribner@techfreire.org) 
You may copy/paste the questions into the email.

1.  Who made the most overtime money?

2.  Who made the least amount of money?

3.  What was the total amount of FICA money paid for everyone?

4.  How does Sesame Street Inc. make money?  What do they sell?

TO:  harvey.scribner@techfreire.org

SUBJECT:  Payroll Spreadsheet Project

Body of Message:  Answer All Questions Listed Above (Copy/Paste Questions into Gmail)

R.A.C.E.S. Method R - Repeat the Question, A - Answer the Question, 

C - Cite Evidence, E - Examples / Explanation, S - Summarize your Thoughts

STEP BY STEP
1: Sign into your Tech Freire Google Account. Click the link above to OPEN the "Payroll Project Google Spreadsheet"(PPGS), click FILE and MAKE A COPY and Rename it "Sesame Street Payroll (Your Last Name) P(period you attend my class 1-7)

2. Using the information on the "Payroll Project Word Worksheet" - Enter the header information correctly on the PPGS. Make sure to enter the Company Name, Company Address, Phone / Fax, and Dates Covered.

3. Enter all of the individual information for each Employee. This includes entering the Employee Name, ID#, Hourly Rate, Hours Worked, and Overtime Hours.

4. Using the formulas located ON THE SPREADSHEET, create formulas in each box to calculate the GROSS PAY. Create formulas to calculate the amount of FICA, Fed. Tax, and State Tax. Finally, create a formula to calculate each employee's NET PAY.

Note: you must change the percentages to decimals and type them directly into each formula, or reference them in each formula. We have not discussed CONSTANT REFERENCES yet, so be careful the formulas do not change if you reference your cells incorrectly.

5. Repeat STEP 4 for each employee. Check your work against the examples below. Other than the DATES COVERED, the totals should be the same. 

WARNING: DO NOT JUST HAND TYPE THE FIGURES BELOW. YOU MUST USE FORMULAS IN EACH CELL TO ACHIEVE THE CORRECT FIGURES AND TOTALS.

When you have finished the worksheet should now be "automated", and you can SHARE it with me for credit at harvey.scribner@techfreire.org

Thank you for your perseverance and good attitudes!

- Mr. S

ACADEMIC/LEARNING OBJECTIVE
Students will learn to use electronic spreadsheets for basic calculations, data storage and evaluation, and other tasks. Students will complete basic spreadsheet tasks, simple functions, and basic formatting. Students will be able to create, work with, collaborate on and share spreadsheets for classwork and basic applications

STUDENTS MUST START BY READING ALL DIRECTIONS THOROUGHLY!

Students will view instructional videos in class, followed by practical lessons. Students will create, work with, store, and collaborate on basic spreadsheets using Google Sheets. Students will be introduced to basic math, functions, formatting and organizational features of the spreadsheets.

ACADEMIC STANDARDS

Common Core Math Students consider the available tools when solving mathematical problems and working with/understanding data sets.

PA SAS Digital Literacy Use Technology to enhance effective communication. Use technology to enter and manipulate data and text. Apply basic mathematical operations to solve problems.

CCSS.ELA-LITERACY.RST.6-8.2 Determine the central ideas or conclusions of a text; provide an accurate summary of the text distinct from prior knowledge or opinions.

CCSS.ELA-LITERACY.RST.6-8.3 Follow precisely a multistep procedure when carrying out experiments, taking measurements, or performing technical tasks.

CCSS.ELA-LITERACY.RST.6-8.4 Determine the meaning of symbols, key terms, and other domain-specific words and phrases as they are used in a specific scientific or technical context relevant to grades 6-8 texts and topics.

CCSS.ELA-LITERACY.RST.6-8.7 Integrate quantitative or technical information expressed in words in a text with a version of that information expressed visually (e.g., in a flowchart, diagram, model, graph, or table).

CCSS.ELA-LITERACY.RST.6-8.9 Compare and contrast the information gained from experiments, simulations, video, or multimedia sources with that gained from reading a text on the same topic.

Payroll Timecard Spreadsheet Project

OVERVIEW

Today you will be using Google Sheets to complete a basic timecard. Millions of people complete these weekly to report the time they spend at their jobs. Most of these timecards are used to calculate the paycheck that is sent to the home for the work they do. It is critical that you learn the basics of how this document works, and how to calculate basic taxes and deductions.

PAYROLL TIMESHEET LINK
Google Drive Spreadsheet (BLANK Template):
https://docs.google.com/spreadsheets/d/1vddJGc9dHx_0q1k2sAINW0n-FeHebM8JwimyuiGpePw/edit?usp=sharing

SCENARIO SETUP

Students will be using Google SHEETS to complete a time-card for a fictional job. Please read the corresponding story to the number you are given in class to fill out your time-card for the week ending on February 12th, 2022.  We will complete the Example together in class.

Example Employee: Rate per hour is $10.55. Monday was a vacation day for eight hours. On Tuesday you worked for eight regular hours and added two hours of overtime. On Wednesday and Thursday you worked eight hours, and Friday you worked for seven hours until you felt sick in your stomach. You logged an hour of sick time. You went in Saturday to make up for the time lost and added one hour of regular time and three hours of overtime.

Anyone whose last name starts with
  A - H will be Employee #1
  I - P will be Employee #2
  Q -Z will be Employee #3.

Please use the following scenarios to fill out your timecards.

Employee #1: You make $20.25 an hour. You felt sick on Monday and called out sick for eight hours. You were feeling so much better the next day that you worked eight hours and then an extra three hours overtime to make up for your absence. On Wednesday you could not be stopped again and put in an eight-hour day and one hour of overtime. Thursday you only were able to work seven hours, and Friday you worked eight hours and an extra hour of "flex" time at the normal rate to make up for Thursday.

Employee #2: You make $14.50 an hour. You arrived for work on Monday ready to go. You put in eight hours and two hours of overtime. On Tuesday you took a vacation day for eight hours of pay. Wednesday and Thursday were regular days of eight hours each, and Friday you arrived late after two hours of sick time. You finished the day strong and added six hours of regular time and an additional four hours of overtime. Saturday you added four more overtime hours as well.

Employee #3: You make $13.25 an hour. On Monday you worked eight regular hours and four hours of overtime. You took Tuesday as a personal day and clocked eight hours of vacation time. On Wednesday you worked eight hours of regular time and added an additional two hours of overtime. Thursday you were not feeling well and used eight hours of sick time. Friday and Saturday you worked full eight-hour days and logged an additional two hours of overtime.

Overtime for everyone is time and a half so multiply your hourly rate by 1.5 and you will have the overtime rate. Sick time and Vacation Time are the same rates as your regular rate.

Take a look at your TOTAL PAY in the bottom right-hand corner. In your email figure out what that number would be if you took out the following deductions:

Local Tax: 4.33%
State Tax: 3.07%
Federal Tax: 15%
Social Security: 6.5%
Medical Coverage: 1.4%
Retirement / 401K: 2%

Once you complete your time-card, SHARE it with me (harvey.scribner@techfreire.org).

STEP BY STEP INSTRUCTIONS
1. Open your EXAMPLE Timecard that we completed in class. Click FILE and MAKE A COPY, Change the Name, then click SHARE and add Mr. S Gmail address (harvey.scribner@techfreire.org) and click SEND to turn it in. Make sure you fill out the top of the form completely. In the real world, you would make sure your name, address, phone number, and other information are correct.

2. Change the WEEK ENDING date to Sunday at the end of this workweek. Make sure, at other employers, you are following the prescribed work week. (Does it start or stop on a specific day) Make sure you are reporting hours for the correct days and times. This is a Legal Document and must be correct prior to you signing it.

3. Use the specific example (based on the initial of your last name) and enter the RATE OF PAY in the correct box at the bottom of the sheet. Make sure to enter formulas to make the Overtime, Sick, and Vacation times work automatically.

4. Once your Rate Of Pay entries are correct, Enter the appropriate times for each day into the cells that correspond with when you worked Regular Hours, Overtime Hours, Sick Hours, or Vacation Hours according to your example.

5. Double Check your entries.

6. Enter each of the rates of tax accord ng to the example. You must change the percentage rates into decimal point values to use them in the equations. Make sure the entries are correct. Below the tax rates enter an equation that multiplies the total amount of pay by the tax rate (decimal) and you will get the amount of the specific deduction for each item. You will see that these totals are deducted from your total pay and the amount of your check for the week appears at the bottom.

7. When it is complete, make sure you have shared a copy with Mr. S using GMAIL for credit.

OBJECTIVE
Students will learn to use electronic spreadsheets for basic calculations, data storage and evaluation, and other tasks. Students will complete basic spreadsheet tasks, simple functions, and basic formatting. Students will be able to create, work with, collaborate on and share spreadsheets for classwork and basic applications

STUDENTS MUST START BY READING ALL DIRECTIONS ON THE CLASS WEBSITE!

Students will create, work with, store, and collaborate on basic spreadsheets using Google Sheets. Students will be introduced to basic math, functions, formatting, and organizational features of the spreadsheets. Students will prepare to complete a Spreadsheet Quiz at the end of the lesson next week!

READ ALL DIRECTIONS CAREFULLY!

THANK YOU FOR YOUR ATTENTION AND POSITIVE ATTITUDE TODAY!

ACADEMIC STANDARDS

Common Core Math Students consider the available tools when solving mathematical problems and working with/understanding data sets.

PA SAS Digital Literacy Use Technology to enhance effective communication. Use technology to enter and manipulate data and text. Apply basic mathematical operations to solve problems.

CCSS.ELA-LITERACY.RST.6-8.2 Determine the central ideas or conclusions of a text; provide an accurate summary of the text distinct from prior knowledge or opinions.

CCSS.ELA-LITERACY.RST.6-8.3 Follow precisely a multistep procedure when carrying out experiments, taking measurements, or performing technical tasks.

CCSS.ELA-LITERACY.RST.6-8.4 Determine the meaning of symbols, key terms, and other domain-specific words and phrases as they are used in a specific scientific or technical context relevant to grades 6-8 texts and topics.

CCSS.ELA-LITERACY.RST.6-8.7 Integrate quantitative or technical information expressed in words in a text with a version of that information expressed visually (e.g., in a flowchart, diagram, model, graph, or table).

CCSS.ELA-LITERACY.RST.6-8.9 Compare and contrast the information gained from experiments, simulations, video, or multimedia sources with that gained from reading a text on the same topic.

Formatting Spreadsheets

Overview

This activity introduces students to spreadsheets over the course of two or three lessons. The first lesson helps students learn the parts of a spreadsheet and how to read a spreadsheet table. The second lesson directs students to make changes to their spreadsheets. Through this activity, they will see one of the most powerful aspects of spreadsheets: the use of formulas. Purpose (SWBAT) Students will be able to create, format, and manipulate basic data in a Google Sheets spreadsheet. Students will also be able to change formatting, highlight, and create charts and graphs based on data provided or created. Objective(s) Recognize basic parts of a spreadsheet window Read a spreadsheet with data Make changes in a spreadsheet to data and formatting

Introduction Videos

Modifying Cells CHALLENGE File (Click Here)

Formatting Cells CHALLENGE File (Click Here)

Creating Simple Formulas CHALLENGE File (Click Here)

CLASSROOM PRESENTATION & ACTIVITIES (click link below)
https://docs.google.com/presentation/d/1Mk3P6hVQL6gmiAVBLiGv4tdg2TSYHvQ8ZAxgYIfmHKc/edit?usp=sharing

Introductory Practice Worksheet
Note: Click the link below to Open the Practice Worksheet, click File and Make a Copy, and then SHARE your copy of the Practice Worksheet with Mr. S (harvey.scribner@techfreire.org) for credit. Make sure to Change the Name of your Practice Worksheet by adding your Last Name and Class Period to the Title Block for easy reference.

https://docs.google.com/spreadsheets/d/1vGbsKzk7C4e9j0CQk5y_RXFCcV3dMRG7U0AQ5FXJzqg/edit?usp=sharing

(❗️) Assessment

Students will open their Google Drive and CREATE a new Google Sheet that includes all the data listed in the picture below.  Students will then format their worksheet to look EXACTLY like the image below (Colors may vary slightly).  Students should NAME their work "Google Sheets Assessment (Last Name) P (1-7)" and SHARE it with Mr. S (harvey.scribner@techfreire.org) for credit.  This assessment is due by Friday, February 11th, 2022 at 4pm.  You may utilize any of the references or sites listed here for help.  This is an individual assignment.

Vocabulary

Cell: A single data point or element in a spreadsheet.

Column: A vertical set of cells.

Row: A horizontal set of cells.

Range: A selection of cells extending across a row, column, or both.

Function: A built-in operation from the spreadsheet app, which can be used to calculate cell, row, column, or range values, manipulate data, and more.

Formula: The combination of functions, cells, rows, columns, and ranges used to obtain a specific result.

Worksheet (Sheet): The named sets of rows and columns making up your spreadsheet; one spreadsheet can have multiple sheets

Spreadsheet: The entire document containing your worksheets

Extension Activity

Google Sheets Cloud Skills Boost Course (Click Here)  In this course you will be introduced to Google Sheets - Google’s cloud-based spreadsheet software included with Google Workspace. With Google Sheets you can create and edit spreadsheets directly in your web browser—no special software is required.

Standards

Common Core Math Students consider the available tools when solving mathematical problems and working with/understanding data sets. 

PA SAS Digital Literacy Use Technology to enhance effective communication. Use technology to enter and manipulate data and text. Apply basic mathematical operations to solve problems. 

CCSS.ELA-LITERACY.RST.6-8.2 Determine the central ideas or conclusions of a text; provide an accurate summary of the text distinct from prior knowledge or opinions. 

CCSS.ELA-LITERACY.RST.6-8.3 Follow precisely a multistep procedure when carrying out experiments, taking measurements, or performing technical tasks. 

CCSS.ELA-LITERACY.RST.6-8.4 Determine the meaning of symbols, key terms, and other domain-specific words and phrases as they are used in a specific scientific or technical context relevant to grades 6-8 texts and topics. 

CCSS.ELA-LITERACY.RST.6-8.7 Integrate quantitative or technical information expressed in words in a text with a version of that information expressed visually (e.g., in a flowchart, diagram, model, graph, or table). 

CCSS.ELA-LITERACY.RST.6-8.9 Compare and contrast the information gained from experiments, simulations, video, or multimedia sources with that gained from reading a text on the same topic.

Alternate Resources (Training Sites for Google Sheets)

https://zapier.com/blog/google-sheets-tutorial/

https://www.w3schools.com/googlesheets/index.php

Reference Site Acknowledgement: https://edu.gcfglobal.org/en/
About GCF Global: "For almost 20 years, the GCFLearnFree.org program has helped millions around the world learn the essential skills they need to live and work in the 21st century. From Microsoft Office and email to reading, math, and more—GCFLearnFree.org offers more than 200 topics, including more than 2,000 lessons, more than 1,000 videos, and more than 50 interactives and games, completely free."