MS Excel Personal Timesheet Project (200 pts)

ALL:

JOURNAL ENTRY:  After viewing the following articles and charts, what does the term POVERTY mean?  Find your block on the first link and find out about how many families in your area are living below the Federal Poverty level listed in the second chart listed.  Write 4-5 sentences reflecting on your thoughts about this reality!
Please review this article for your Journal Entry:  Philadelphia Poverty Figures (Click Link)
Federal Averages For Annual Income (Poverty Level) (Click Here For Article)


PAYROLL TIMESHEET LINK:

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

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

Today you will be working on Microsoft Excel and creating a time-card for yourself.  Please read the corresponding story to the number you are given in class to fill out your time-card for the week ending on April 14th, 2014.  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 at 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.

Here are your scenarios:


Anyone with a last name that starts with A - H will be Employee #1, I - P will be Employee #2, and 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 rate 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 (hscribnercaa@gmail.com).  You must also go to the back of the room and PRINT A COPY of your Timecard, Sign it and Date it, and turn it in for credit.

Good Luck!!

- Mr. S

Excel Practice Day

Practice Creating the following tables in MS Excel today:

The first is a grade log.  Make sure you use the AVERAGE function to show the average scores for your grades at the bottom of the spreadsheet.  You must also type the instructions in the cells below as pictured:

The next table you will create is the Exercise table.  Please fill in all the data exactly as it is pictured:

Format the table just like the picture to the right:

Finally, you must create the table for the products listed here:

Good Luck!

Mr. S

Seminar Projects - 4th MP

Today you will start your Computer Science Seminar.  You may work on any projects you like that have technology components.  Make an IMOVIE, Create a Song in GARAGEBAND, work on Code.Org, or work on any of the Extra Credit Mini Projects listed on the class website (LINK).

You can also work on Gamestar Mechanic (Create Video Games) or CODEHS.com, or Udacity or Kahn Academy to work on additional classwork. 

BY THE END OF SEMINAR TODAY YOU MUST SEND ME AN EMAIL WITH THE PROJECT YOU ARE WORKING ON FOR SEMINAR AND WHO YOU ARE WORKING WITH (NO MORE THAN 3 STUDENTS ON A TEAM PLEASE).

YOU MAY NOT JUST WATCH YOUTUBE or LISTEN TO MUSIC.  YOU MAY WORK ON OTHER HOMEWORK IF YOU LIKE.  Whatever you decide to do, you must use some kind of technology as part of it.

Good Luck and I will see you in Seminar Tomorrow!

Mr. S

MS Excel Basic (Google Spreadsheets) Training Days

This is your Introduction to MS Excel.  Please pay close attention during the class presentation (Click Here to Download Presentation at Home).  You will be creating a number of spreadsheets over the next few days.  It is important that you learn to navigate around the spreadsheet as easily as you do in MS Word.  You will find that most of the RIBBON items are similar and that you can find out how to do things without my help by using the HELP Button.

We will be using MS Excel (Google Spreadsheets) to create Employee Timecards, Payroll Worksheets, a Family Monthly Budget, and much more!

Use this link for more information and helpful practice templates:  MS EXCEL PAGE

Finally,  you will be using templates that are built-in to the MS Excel program.  I will add different requirements as we progress.  Good Luck!!

- Mr. S

Yearbook MacWorks Pages Project (300 points)

Today you will be creating your own 1/3 page for the Crossroads Yearbook.  Your page section will be copied and listed alphabetically in our yearbook.  The yearbooks will be printed in black & white to save money, but an electronic color copy will be emailed to everyone and linked to my website for download.  You can then print and bind your own color copy if you like.

Here is a video tutorial I recorded to help you: (Click Link and Watch It)
https://docs.google.com/file/d/0BzY9jTFcLEUWMmQzWkV3VHV3V2s/edit?usp=sharing

Here are some tutorials for you to learn how to use MacWorks Pages:

http://www.apple.com/iwork/pages/

http://manuals.info.apple.com/en_US/Pages09_UserGuide.pdf

http://www.lynda.com/iWork-tutorials/pages-09-essential-training/47996-2.html


When you think you have mastered the software a bit, please click the link below to download the template.  You will be using any one of the three outlined spaces to create your page.  Do not resize the background blocks, but you can change the background color and edge trim.  Ultimately, the yearbook staff will be editing, proofreading, and pasting your section into the final draft of the yearbook.

YEARBOOK PAGES TEMPLATE: (CLICK LINK BELOW AND DOWNLOAD)
https://docs.google.com/file/d/0BzY9jTFcLEUWbUZjUTlJd2tvVHc/edit?usp=sharing

Anyone who does not submit this project will have the picture from their SCHOOL DISTRICT ID used in the yearbook.  Enjoy creating this last project of the year.  Do not forget that any time not spent on this project can be spent finishing your Family Monthly Budget, working on your 8th Grade Project, or working on Extra Credit items to improve your grades.

Good Luck,

- Mr. S 

Please see the example below for what the yearbook pages will look like:

Business Proposal TACKK.COM Webpage! (200 pts.)

Happy Friday!  Make sure to show this post to your Substitute Teacher Today!

If you are able to enter the room and quietly and quickly get to work, you may use headphones to listen to music while you work on the assignment today.  The ultimate decision of whether or not you can is up to the Substitute and I expect you to follow any and all directions that person gives to you!  You are all aware of how to behave in school and especially in my class.  Make sure to get to work on today's assignment as soon as you can to give yourself the most time to complete it!

YOU ALL DID A GREAT JOB SHARING YOUR BUSINESS PROPOSALS YESTERDAY!  I AM VERY PROUD OF THE WORK YOU COMPLETED SO FAR ON THIS PROJECT!

You will now create (BIG SURPRISE) a Tackk.com Webpage for your Business Proposal!

Please Sign In to your Tackk.com Account and CREATE a new Tackk.

You will need to DOWNLOAD the slides from your Google Presentation as JPEG images.  You could also DOWNLOAD the Entire Presentation into MS Powerpoint on your class computer and then SAVE the file as IMAGES.  This would place a folder on the desktop with a picture of each slide in one, single command.

Follow these steps to create images from your presentations:

Open Google Drive Presentation
Click FILE and look for DOWNLOAD
DOWNLOAD Image for each slide as a JPEG file.  You will have to select each slide individually and complete this sequence.

If you want a faster way, DOWNLOAD the entire presentation and open in MS Powerpoint (ppt)  Then Choose SAVE in MS Powerpoint and SAVE AS IMAGES. This will put a folder on the desktop or in your computer's download file (under the STUDENT files).  You may then use the upload the images together to create a slideshow on your Tackk Web Page.

Once you have the images ready to upload to Tackk.com, you can look at my example Tackk to add additional items.  Here is the link:  https://tackk.com/v9fbpb

Make sure to write 1-2 paragraphs (2-3 Sentences Each) about why you chose this type of company to start, and why someone would choose you over your competitors.  Focus on what is unique or different about the products and services you sell.  Your Tackk.com Web Page must include all the slides of your presentation, a map of your business location in Philadelphia, PA, a link to your Weebly Webpage (either a button or text), and a response form for feedback.  Once you have completed this, please leave a response on my Tackk.com (Super Falafel) webpage with a link to your Tackk.  I will make sure you have all the items required and you will receive your points for this project.  You may also email me the link to your Tackk Web Page for credit.

MAKE SURE YOU USE THE FOLLOWING KEYWORDS AT THE BOTTOM OF THE TACKK SO WE CAN SEARCH FOR YOUR PAGE:  #caatech  and  #xroadsmlabp

Once completed, you may quietly work on anything else you owe for class.  Remember, Grades Close On April 18th at 4pm for my class.  With PSSA's and Holidays, we only really have 7 more class days until grades are due!

Enjoy the day!

Mr. S

Business Proposal Presentations (100 points each)

Today you will be presenting your Business Proposal Presentations to each other.  We will be pairing off.  You will sit with a random partner and "present" your business idea (Google Presentation) to each other.  While you are watching the presentation, you will have the following link open:

Business Proposal Presentation Response Form 2014 (CLICK HERE FOR FORM)

You will present your idea, your partner will fill out the form, then you will reverse rolls.  You will each have 3 minutes to complete the tasks.  At the end of both presentations you will be assigned another partner and repeat the process.  You MUST have at least 3 presentations to receive your points for this exercise!

Good Luck!

- Mr. S