Introduction

Digital Literacy Class: We are going to learn about so many incredible ways to be creative, collaborative, and to communicate. We will focus on computer skills and applications. Some topics you already know about, and you will know better, and other topics and applications will be new to you! Either way, we will work together to find the ones you are able to use best. This class consists of Project-Based-Learning. You will be given plenty of time to learn the skills and applications that you will use for a lifetime. I hope you enjoy the material we will cover. - Mr. S

Thursday, May 29, 2014

Weekly Menu & Grocery Shopping 2014

Hello Everyone,



Objective:  To plan a weekly meal menu and shop for items on the list.  To identify prices and differences in 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.



Steps:

1.  Complete Weekly Menu Form - Get it Approved.

2.  Complete Grocery List Based on Menu Choices - Get it Approved.

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 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 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 home. 
Detergent, soap, etc.  You may also include any items you might
actually use regularly to your shopping list.  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, pharmacy's 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/








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.




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 AREA
FOR YOUR GROCERY SHOPPING FROM THE SHOPPING LIST YOU COMPLETED FOR YOUR
MOVING DAY!




SEE EXAMPLE BELOW:



If you need copies of the forms in MS Excel or Printable, click the form below and download or print a copy:





Weekly Menu PDF (Printable):

https://docs.google.com/file/d/0BzY9jTFcLEUWdW9scGRJQTBYRWs/edit?usp=sharing



Weekly Menu MS Excel:

https://docs.google.com/file/d/0BzY9jTFcLEUWWTRGSkNyR2U1UlU/edit?usp=sharing



Grocery List PDF (Printable):

https://docs.google.com/file/d/0BzY9jTFcLEUWNHpwazhVaV9DSDg/edit?usp=sharing





Grocery List MS Excel:



https://docs.google.com/file/d/0BzY9jTFcLEUWaVlFZ2xGc296MnM/edit?usp=sharing



Good Luck,

Mr. S

Tuesday, May 27, 2014

Personal Budget Moving Day Activities 2014

Today you will work out your Moving Plan and fill out your Checkbook.

Here is a copy of my BUDGET SPREADSHEET as and Example:  https://docs.google.com/spreadsheet/ccc?key=0AjY9jTFcLEUWdFFBcjAzRUZscm1CV0dhTzVjSlFQRlE&usp=sharing



You must use a COPY of the following document https://docs.google.com/document/d/1A-Tdt6ZC6PaCwx3YhqH-T5vZp6s7Jzry8i8LFhAVzL4/edit?usp=sharing and share it with me for credit.



YOU WILL USE THE PURCHASE SHEET TO SHOW ALL OF YOUR ITEMS BOUGHT.  Include all
items purchased, where you bought them, and how much they were.  This
includes travel expenses, airfare, insurance, household goods,
furniture, and anything else you need to buy.



Your opening balance in your checkbook should be $134.50.  Your Parents,
Uncle, Grandma, etc. is giving you a one-time grant for $2500 to help
you get started.  It is your graduation present.  You need to complete
the budget sheet (handout in class) and let me know all the things you
are buying to get yourself started.  Follow these directions:


  1.  First, you need to list where you went to college.

  2.  Second, you need to list the address and city you are moving too.

  3.  Explain how you are getting to your new city and what you are taking with you



  •  You must find a flight, train, bus, etc. (Travelocity.com, Greyhound.com, etc.)  copy and paste your itinerary.

  • What are you taking with you?  List any items you are taking with
    you.  EVERYTHING.  And have a plan to move it.  You are only allowed to
    have so much on a plane or bus.

  • If you buy a car you need a quote for insurance (Geico.com) and budget for gas and maintenance.


You must now furnish your new apartment.  Find local stores (Wall-Mart,
Ikea, Craigslist.org) to find the following items and budget for them:


  1. Transportation:  Bike, Car(Insurance, Gas, Maintenance Apply), Transpass (Local Bus/Train)

  2. Furniture:  Bed, Couch, Table & Chairs, Lamps, Desk, TV, Stereo, Computer, etc.

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


You will fill out the worksheet completely and use it to fill out the
Checkbook on your BUDGET Sheet.  When you have filled out the budget, make sure you have SHARED it with me for credit.



I hope you are having fun with this assignment and learning how to keep a
budget while you are discovering how much things really cost.



Keep up the good work!!



- Mr. S

Friday, May 23, 2014

Memorial Day 2014 Rememberance

All:



Next Tuesday we will continue work on our Personal Monthly Budget Project.  Today please follow the directions below.  After our viewing of the video in class, you will write in your journals.



Watch the following Memorial Day Tribute Video:

https://www.youtube.com/watch?v=UmCbiibZvX0



Please read the following post and write a short reflection (2-3 Paragraphs) in your Weebly.com journal.








"3rd Herd" Prior To MFO Deployment (Ft. Lewis, WA)

As you know, I am a Veteran of the US Army.  This weekend is for you to
relax and enjoy a well-deserved rest.  While we celebrate our Veteran's
on another day, please bear in mind the following excerpt from
About.com:



"Many people confuse Memorial Day and Veterans Day.
Memorial Day is a day for remembering and honoring military personnel
who died in the service of their country, particularly those who died in
battle or as a result of wounds sustained in battle. While those who
died are also remembered on Veterans Day, Veterans Day is the day set
aside to thank and honor ALL those who served honorably in the military -
in wartime or peacetime."



Use the following links to find out more about this special weekend and
why you should be thankful for the sacrifices made on your behalf.  We
are not a perfect nation, but the blood of a few has been given so we
can enjoy the freedoms we have.  Always Remember!

http://usmilitary.about.com/od/theorderlyroom/a/memorialday.htm

http://www.usmemorialday.org/backgrnd.html



MEDAL OF HONOR PROJECT:

Please go to the following link (http://www.history.army.mil/moh/).  You will be able to choose the period in history you would like to know more about.  I would like you to pick one Medal of Honor winner from history.  Look through them carefully.  Once you have identified one Medal of Honor citation to work with, you will be required to post it to our Google Document that is Shared ( https://docs.google.com/presentation/d/1lzv6J9whcPRm-g_A-Jp1uOtw_GlVObaFBJl9w3cULAM/edit?usp=sharing )



I would like you to add a slide to this presentation.  Make sure you find a picture of the person you found, a link to that person's citation page, and a thoughtful reason why you picked them.  I will publish this document for everyone to see so make sure your name and class period is on it as well. 



Make sure you spend some time over the weekend remembering those who gave all for you to live in a country that is free and has opportunity that is found no where else!



Thanks for your time and effort with this project!



- Mr. S

Thursday, May 22, 2014

Personal Monthly Budget - Project Startup Day 2014

Personal Monthly Budget Startup Day!



Here is the Google Spreadsheet we will use for this project.  Make sure you open the document, MAKE A COPY, and NAME it (Your Last Name) CS Period (?) Budget 2014

https://docs.google.com/spreadsheet/ccc?key=0AjY9jTFcLEUWdGJ1U1FKSXZBNzI2d2JoNnlMOVBsdGc&usp=sharing



On the first page you will notice it is a template for a family
budget.  Today you will be entering your basic start-up information. 
You
have a job somewhere other than the Philadelphia Area based on your
research on Career Day (Click Here).  You must enter your personal
information, Job Title and list the address you work at. 
Your next task is to fill in your address (apartment).  Over the
next few days you will find out about utilities, services, groceries,
and other costs to get changes to your plan and you will have to adjust
your
budget to reflect the changes.  Final budgets will be gradable. PLEASE
SHARE your BUDGET with me so we can keep working on
them each day.  Eventually you will be graded on the following basis:



Grading is as follows:     (1500 points Total)

     Personal Finance Worksheet Completion (100 points)

     Career Day Google Doc Complete (100 points)

     Google MAP Day Completion (200 points)

     Initial Budget Setup Day (100 points)

          Initialize and Accurately Place All Initial Information and Data Sheet

          Costs associated with the move to new location

               (Furniture, Travel, Housewares, Electronics, etc)

     Moving Day (StartUp) Worksheet (100 points)

     Stock Market Game Day Activities (100 points)

          Setting up and Starting To Invest

     Services & Utilites Day (Google Map) (100 points)

          Create a Google Map with Work & Home Address

          Add Points on the Map for Local Points of Interest

               Doctors, Grocery, Mall/Shopping, Entertainment, Restaurant

               Garage (Auto), Public Transportation, Route to Work (Method)

     Insurance & Investment Day Changes  -  (100 points)

          Renter's Insurance, Auto Insurance, Life Insurance, Health Insurance

          Stock Market Game Withdrawals

     Meal Plan & Grocery Shopping  -  (100 points)

          Weekly Meal Plan to include 2 "Date" nights and Sunday Family Dinner

          Cleaning Supplies, Housewares, Expendables, Etc.

          Online Grocery Order Submission.

     Final Changes & Submission of Budget (Email)  -  (300 points)

          Random Final Changes and Email to Instructor for Credit.

     Final Presentation (200 points Total)

          Powerpoint  - 100 points

          Presentation  - 100 points



Final Presentations of your completed BUDGET will need to include explanations to the class of
where you live, what you spent money on, and how you saved and can tell
the difference between expenses and discretionary income.





Keep up the good work!!



- Mr. S




Good Luck!!



MR. S 



Tuesday, May 20, 2014

Personal Monthly Budget - Google Map Day

Here is a link to your responses for the CAREER DAY Search Sheet:



https://docs.google.com/spreadsheet/ccc?key=0AjY9jTFcLEUWdFlEMDVCUGhnQTc5RjU0QWIxWmo1ZUE&usp=sharing



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
at the following link:



http://goo.gl/maps/aCRTS



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



Work, Home, Directions (Route) from Home to Work



You must also include the following:



GROCERY

POLICE STATION

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 me (hscribnercaa@gmail.com) as a COLLABORATOR and email me
the link to your map.  In the Email with the link, you need to identify
the following items by listing the Company and Customer Service Phone
Number for each service in your new city:



PHONE COMPANY

CABLE COMPANY

NATURAL GAS COMPANY

ELECTRIC COMPANY

TRASH PICKUP COMPANY

WATER SERVICE

SEWER SERVICE

POLICE DEPARTMENT

FIRE DEPARTMENT

AMBULANCE COMPANY





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.  Good Luck!!





- Mr. S

Friday, May 16, 2014

AfterCollege.com (FMB) Start Day

FAMILY MONTHLY BUDGET STARTING POINT:

Today you will build on the research you completed Monday.  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 "Get Started Today".  Select a College you are interested
attending (SCHOOL).  Enter a (MAJOR) you are likely to study.  Set the
(GRADUATION DATE) for MAY of 2013 and click EXPLORE NOW.





If you chose professional training that did not
require college, you must use Monster.com, Careerbuilder, Craigslist, 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.



Everyone in class will start with $36,000/year in base pay.  This will
be your NET pay after 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 Crossroads have chosen the same
place to work in (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.  Depending on where
you live, you will have to decide how much to spend on transportation
for work.  You may use Craigslist or other Real Estate and Apartment
Finder websites to find places to live.



Once you have found all the information above and written it down on
paper or a Word/Google Doc to save, 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):



https://docs.google.com/forms/d/1p7xEGjupnxhzFprOUWFTwsKDHD43kPXer55wIKe9-0A/viewform



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 as
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.  You
will present to the class your final budgets, so be careful and
accurate.



Good Luck!



- Mr. S

Wednesday, May 14, 2014

Personal Finance and MONEYSKILL Program (300 points)

Here is the link to the presentation Personal Finance 101 from class:

https://drive.google.com/file/d/0BzY9jTFcLEUWV0N4NlltejB5Tkk/edit?usp=sharing

Use this link to help you complete your class handout.  If you need another copy of the worksheet, you can click the following link and print it in the back of class, on your own time:

https://drive.google.com/file/d/0BzY9jTFcLEUWRGh1TVI4djA4YlE/edit?usp=sharing



MONEYSKILL.ORG

Please click the link below and log into the MoneySkill.org website:

MONEYSKILL.ORG (CLICK HERE)





Your Username the first letter of your first name and your last name. (Example: hscribner)

Your Password is your Student Number.



You have until June 6th to complete all 12 units online.  There will be a certificate of completion for this and it is a graded event!  You must complete this starting today in class, and use your time at home, or free time in school to work on it.  It is considered a HOMEWORK Assignment.  Every student must complete the program for credit.  Good Luck!



- Mr. S

Monday, May 12, 2014

Personal Monthly Budget 2014 College & Major Day

Today you will create a Journal Entry (Weebly Journal) after reading the following article:



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!



After your Journal Entry is complete, 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.



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: 



https://docs.google.com/forms/d/1a1yKllyW3DBgE_-H6U3P2dLHR_n-PKDvP6ZDcKNFviM/viewform?usp=send_form





Tomorrow we will discuss Financial Literacy and Financial Planning.  Later this week 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.



When you have completed the Journal Entry and the College & Major
Survey above, you are free to finish your Yearbook Pages that are due by
the end of today!



Good Luck!



Mr. S

Thursday, May 8, 2014

Sesame Street Payroll Project (400 pts)



Today we will walk through creating a TIMECARD and 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 over the
next two days and show Mr. S in class. When
complete, you should know how to enter data on a form, manipulate the
form to complete basic functions and how to automate the form by copying
functions and formulas to additional cells.



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



Payroll Project WORD Worksheet:

https://drive.google.com/file/d/0BzY9jTFcLEUWUkhYSk5TT0NjMFk/edit?usp=sharing



Second, choose one character from Sesame Street to create a TIMECARD
for.  Make sure that you evenly space out the character's hours evenly
over the work week as if they had worked for a real company you
operate.  Use the following link to download a blank form and adjust the
figures to be accurate for your character:


GOOGLE SPREADSHEET BLANK TIMESHEET LINK:

(Do Not Forget To "Make A Copy" To Add To Your Google Drive BEFORE CHANGING!)

https://docs.google.com/spreadsheet/ccc?key=0AjY9jTFcLEUWdDUyajRIY1gxLXpwSE5ZeXRLMEdmTUE&usp=sharing



MS EXCEL PAYROLL TIMESHEET LINK:

https://docs.google.com/file/d/0BzY9jTFcLEUWYVMxdnZpLVQtbmc/edit?usp=sharing



Finally,  Use the form below (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.





Payroll Project Google Spreadsheet (Blank):

(Do Not Forget To "Make A Copy" To Add To Your Google Drive BEFORE CHANGING!)

https://docs.google.com/spreadsheet/ccc?key=0AjY9jTFcLEUWdEVWLTlSTFR3bVp1RmV2d0h1YWtXZVE&usp=sharing



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.  Good Luck.



- Mr. S











Dragons Breathe Fire

Dragons Breathe Fire