In today’s world, students must prepare themselves for a wide range of college and work opportunities. All students want to lead a happy life and enjoy the good things the world has to offer. Our students will certainly be provided a quality education. This year I am working with our junior high students as they learn and master a wide range of 21st Century Skills.

In this year’s “Technology Applications” class, students will learn and master various topics associated with computers and technology.

Sunday, April 26, 2015

Week 31 (April 20, 2015)

With STARR testing this week, work on our second Excel Spreadsheet was a little sporadic.   When all the dust settled, the spreadsheet came out great. Students did a fantastic job of paying attention to all the details.

This real life project had students creating an Excel spreadsheet for a small business of their creation. Students had to list a number of items they plan to sell in their store and determine a "Cost" for each item.  Using the Internet, students researched typical "Markup" percentages and used an Excel Formula to calculate a "Selling Price".

Here are some samples.

Saturday, April 18, 2015

Week 30

6th Graders "knock it out of the park" on their second MS-Excel spreadsheet.  This spreadsheet had them creating a spreadsheet for a business venture of their choosing.  This week, students learned how products end up in our stores. From manufacturer to distributor, wholesaler to retail store, students learned the basics of how profits are made through markups of various percentages.

Here are some samples of the spreadsheets they created.  The quality of these products are an indication of the student's understanding of what is expected in a business related spreadsheet.

Saturday, April 11, 2015

Week 29

Students completed their very first spreadsheet this week.  We didn't start with a small and simple spreadsheet, but one which was large and complex.  I threw them into the water and all the students proved to be champion swimmers.

Each student started with a list of household items they believed to be essential to setting up their first apartment or dorm room.  As students gathered information from various store websites, they learned about manufacturers and descriptions.  In the process, many students learned and commented on the cost of essential household items.  Many had no idea things could cost so much.

Here is a small sampling of the great spreadsheets created by all 6th Graders.

Sunday, April 5, 2015

Week 28

6th Graders are on their way to completing their first Microsoft Excel spreadsheet.  They have filled in the data from their "First Apartment" research and are ready to wrap up their spreadsheet by learning to add Functions, Currency Formatting, Borders and a little color.  As soon as they are done, they will be reviewing and getting ready for their first Excel test on Tuesday or Wednesday.

The students next spreadsheet will have them owning their own store.  In their next spreadsheet, students will learn to work with "Cost, Markup and Selling Price" for each item they sell.

As students complete their spreadsheets, samples will be made available for viewing.  Stay tuned.

If all goes well, we may do another Proofreading and Typing Lesson on Thursday and Friday.