7th+College+Costs

College Cost url}?f=print|print this page

PA Standards Objectives - Evidence of best practice – students will be able to refer to the video and helpful tips on my wiki at anytime they get stuck and Model lesson before students are allowed to complete task.
 * NETS.1.6-8: Students demonstrate creative thinking, construct knowledge, and develop innovative products and processes using technology.
 * NETS.2.6-8: Students use digital media and environments to communicate and work collaboratively, including at a distance, to support individual learning and contribute to the learning of others.
 * NETS.3.6-8: Students apply digital tools to gather, evaluate, and use information.
 * NETS.6.6-8: Students demonstrate a sound understanding of technology concepts, systems and operations.
 * Workbook Skills
 * Working with toolbars
 * Working with the menus
 * Keyboard moves
 * Entering info in a spreadsheet
 * Using a template
 * Renaming an existing workbook || Borders and Styles
 * Using the borders button
 * Using the fill color button
 * Creating a style by example || Page Setup
 * Print preview and page set up
 * Creating headers and footers
 * Repeating row and column labels
 * Using page break preview ||
 * Objects, Pictures, and Diagrams
 * Inserting a draw object into a worksheet
 * Drawing a line or arrow in a worksheet
 * Formatting a drawing object
 * Resizing a drawing object
 * Adding text to a drawing object
 * Drawing a text box
 * Inserting a picture
 * Formatting a picture or a graphic || Formulas & Functions
 * Entering formulas
 * AutoSum and AutoSum list
 * Basic functions
 * Inserting functions in formulas
 * Editing functions
 * Drag down fill || Formatting Skills
 * Number formatting
 * Formatting using the toolbar
 * Formatting using the formatting palette
 * Cell alignment and spacing
 * Shrinking or wrapping text in a cell
 * Selecting columns and rows
 * Changing column width and row height
 * Inserting or deleting a column or row
 * Inserting or deleting selected cells
 * Using the merge and center button ||

Activity - Students will...

Click on this link to find your 6 colleges and the cost of the college (unless it is in PA you are an "out of state student"). Here is a link to help you choose a college if you are unsure.
 *  FINDING YOUR COLLEGES: **

 Find 6 colleges and their cost for "Tuition and fees " (in or out of state) and the cost for "room and board " (you have to click on Cost & Financial Aid see photo below). If there is no cost for room and board that means you can't live on the college campus. You would have to live in an apartment - you put "0" in the space, although, really it would be a high cost for an apartment and food shopping.



**CREATING YOUR CHART:** 1. In your Excel WORKBOOK Include in 1A College, in 1B cost of Tuition, in 1C Room and Board and in 1D Total 2.  //drag this too your desktop to see it larger.//

 3. Research your data and put it in the chart as above shows

4. Make sure in the final column you use the SUM tool to calculate the total (the Blue column). HOW TO DO IT - Highlight 2b,2c,2d choose the SUM tool. (backwards E from tool bar - called AutoSum). See the video, for a visual. Do this for each college.

 5. Making the <span style="color: #008000; font-family: 'Comic Sans MS',cursive; font-size: 120%;">dollar signs in the columns. -
 * <span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">choose columns B C D (all the columns about money)
 * <span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">go to menu item FORMAT... Go down to Cells...
 * <span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">In the box that opens choose "currency" on the left, then choose "United States (that will give you your dollar sign). For this assignment your don't need coins so you can change the "2 decimal points" to 0.
 * <span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">Click Okay.

<span style="color: #0000ff; font-family: 'Comic Sans MS',cursive; font-size: 120%;"> **CREATING YOUR GRAPH:** <span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">6. Create a graph below the chart (as in the sample) - how to create the graph - 4th videos down
 * <span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;"> Highlight the chart you just made.
 * <span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">Choose CHART in the menu and pick the graph you want.
 * <span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">You can move the blue or green square to decide what part of the chart you want to show in the graph
 * <span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">In the formatting palette go under chart labels and input a title, a label for x and y axis.

<span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">Make sure your graph includes: a title, labels on X & Y axis. Make sure the bars are readable as well as the the money a,mounts and the college names.

<span style="color: #0000ff; font-family: 'Comic Sans MS',cursive; font-size: 120%;"> **INCLUDE PICTURE:** <span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">Include a picture of your top choice college and write which college it is.

<span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">7. The picture you choose should go to your desktop, then to your workbook.

<span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">6 colleges with tuition, room & board (reasonable numbers) <span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">total using sum tool <span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">graph including data <span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">title on graph <span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">lable on x & y axis <span style="font-family: 'Comic Sans MS',cursive; font-size: 120%;">picture of college
 * <span style="color: #0000ff; font-family: 'Comic Sans MS',cursive; font-size: 120%;">GRADE - WHAT I AM LOOKING FOR/WHAT YOU NEED TO SHOW YOU CAN DO **