G9 Tech Class #29

Following our G9 Due dates webpage, today is Presentation Day!!! Be prepared to show and explain your final Stock Shares Tracker in 5 minutes:

• built, 
• operational,
• what did you do to track your shares?
• what spreadsheet features did you use to track your shares?
• how much did you invest in each one? Why?
• did you make a "profit"?
• talk about the process of creation
• issues you had to overcome
• timeline and your time management
• group work
• strengths / weaknesses / areas of improvement
• Q&A mini session

-----------------------------------------------------------------------------

April 1st: Watch the following new uploaded Google videos

G9 Tech Class #28

Today we will finish working on making the last touch ups to your Shares Tracker Product including:
It has to evidence the following specifications:

• use header rows
• sequence numbering
• sorting ascending and descending
• insert columns and rows
• column and row merge
• format title (font, color, size, shading, etc)
• at least three different formulas
• one fixed cell reference
• copy/cut and paste information
• insert a graph (pie, bar, etc)
• format the graph: change the Title: font & color, the colors of the bars/pie pieces, etc)

Record all your progress in your Process Journal before you turn in Create stage today (if you haven't turned it in last class).

Please make sure you are including the Assignment Standards and turn in your work by following the steps to submit and assignments.

G9 Tech Class #26

Today we will continue working on Create stage.

Please visit G9 Tech Class #25 for reviewing 

the expectations for Create stage.

Following the Due Dates for Project 2 Create stage is 
due today.

Please make sure you are including the 
Assignment Standards.

Before you submit Create stage today, don't forget to make your

 journal entry of the day and include in it the sketches of your designs

as visual evidence!

G9 Tech Class #19

Today we will continue working on spreadsheets.

Last class we worked on Activity 1 (Part 1&2) as well as on Activity 8 posted in our last class' blog post: Tech Class #18.

To continue making progress with Project 2, let's cover some Spreadsheets basics as the vocabulary:

• sheet
• cells
• columns
• rows
• row heading
• cell reference
• name box
• formula bar

We can watch this short video to get started:

Microsoft Excel Spreadsheet Basics -- powered by ehow

Getting acquainted tasks:


1. The Basics: make a list of your class in a spreadsheet including the following information: your classmates' names, last name and age. Each piece of information should be  in different columns labeled Name, Last Name and Age. Add a column to number each row/student. Header row should be purple and the numbers column should be light yellow. Name the Sheet 'Students List'.


2. Calculating: Add a new Sheet to your spreadsheet where we will make a balance spreadsheet. Name it 'Balance'. Include columns for date, item description, debit, credit, and balance. Format the cells to show $ for the content when applicable. Title row should be boldfaced and green. Apply calculations to the balance column so that any debits and credits are applied to the balance automatically. Pick one website--iTunes' Top 100 songs, for example-- and you have a $25 budget, and you need to use the balance sheet to figure out what combination of purchases would best maximize your budget. Add the debit and credit columns (at the bottom).

G9 Tech Class # 18

Today we will continue working on our Project 2:


1. Finish Activity 1 (Parts 1& 2). (Look for details posted in last class' blog entry)

2. Start thinking about your guiding questions (what will you like to learn) about the Stock Market and tracking shares and write them down in you new G-Shared Doc, that later be included in your Investigation stage.

3. Explore Using formulas in a spreadsheet to generate number patterns. Let's try this:

• If we would to generate a simple pattern of numbers which is contained in a single column, looks like this: 1,1,0,2,2,0,3,3,0,4,4,0,...
• How do you think we can generate the same pattern using a formula instead of typing all the numbers in a column?
• There are several different ways you can use to achieve the desired pattern. How many ways can you find of doing it?

4. Try other number patterns that you would lie to generate. Eg: Fibonacci Numbers

5. Work on Activity 8: from The NYSE Up Close and Personal Activity Booklet.

Can we be internationally minded here? Is NYSE the only stock exchange in the world? Do you know any other Stock Markets?

- Your task is to invest  the money in shares (justify your choice of shares: min 3 companies, max 5 companies, with at least one international company)

- You must also design a spreadsheet that keeps track of the value of the shares on a daily basis in a way that is easy to understand (she is not an excel specialist but she likes everything to be explained to her).

- She wants to know how much the value has changed from the initial investment and from day to day.

- Let's look into these:

• How many companies can I invest in?
• How much does it cost to make a trade?
• How long will the investment be?
• Where and how will you follow the prices?
• How will you test the product?
• How sophisticated will your spreadsheet/formulas need to be? Will you need multiple pages? How do you make cell references between different pages?

6. Start your Process Journal for Project 2 today! Make your daily record of what you  learnt/progressed today.

G9 Tech Class #17

Today I would like you to use the first part of the class to check on the comments on your assignments and resubmit updates if needed. Also please follow up on missing assignments to avoid "0s" or "Ms" in your grades. Please visit the G9 Tech Class Blog for details and expectations for each stage.

Therefore If you need some time to finish the last details of your products from Project 1 to turn them in today, please work on the first thing today (20 min aprox).


- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
Today we will also begin with Project 2: Shares Tracking using Spreadsheets

The Project is going to be about keeping track of our investments using spreadsheets.

We will be investigating how shares in companies work and we will be improving our spreadsheet skills.

The dynamic of  Project 2 would be the following:

• Regroup for this project with someone who you haven't work with in Project 1.
• get starte with Part 1 and Part 2 of Activity 1 on the NYSE (listed below)
• make notes and complete the activity on a new shared document with your new group.
• Please name this assignment: Project 2- Activity 1

1. Let's get started with "The Stock Market and you"

Please complete Part 1 and Part 2 of Activity1 from The NYSE Up Close and Personal ACtivity Booklet.

2. In your new group's shared doc, write down your answers and ideas to complete ACtivity 1 (parts 1 &2).

3. If you have time, please add some guiding questions about the Stock Market and tracking shares that can be included in your Investigation stage.

4. Work on Activity 8: 

Can we be internationally minded here? Is NYSE the only stock exchange in the world? Do you know any other Stock Markets?

Please finish Activity 1 (parts 1 and 2) and Activity 8.