Apemag

  • About
    • Open Source
    • Examples of Student Work
    • Mr. V
      • Contact
    • Grading
      • Participation
      • Participation: How To
    • Scope
    • Bells
    • Hand Outs
  • Photo
    • Photo I
    • Photo II
    • Genre
    • Expression
    • Research
    • Concepts
    • MVP
    • PVA
  • See
    • How To
    • PS CC
    • Rolland Cut Studio
    • PS CS4
    • Adobe Capture
    • Process
  • AI
    • Screen Printing
    • AI Toolbox
  • PS
    • PS Lessons 1-4
      • Photoshop Paint Bucket Lessons
      • Photoshop Basic Tools Lessons
      • Photoshop Paint Brush Lessons
      • Photoshop Layers Lessons
    • PS Lessons 5-10
      • Photoshop Free Transform Lessons
      • Photoshop Clone Stamp Lessons
      • Photoshop Healing Brush Lessons
      • Photoshop Selection Tools Lessons
      • Photoshop Light Adjustment Lessons
      • Photoshop Hue Saturation Lessons
    • PS Lessons 11-14
      • Photoshop Text Lessons
      • Photoshop Blur Effect Lessons
      • Photoshop Green Screen Lessons
      • Photoshop Water Mark Lessons
    • PS Lessons 15-18
      • Photoshop Filters Lessons
      • Photoshop Line Drawing Lessons
      • Photoshop Opacity Lessons
      • Photoshop Advertisement Lessons
  • Tools
    • Photo Collections
    • Photoshop CC Tutorials
    • Photoshop Toolbox
    • Photoshop CS4 Tutorials
    • Photoshop Assessments
    • Photoshop Advanced Lessons
    • Templates
  • GA
    • Vinyl
    • Screen Printing
    • Logo
    • Animation (PSCC)
    • Animation (PS4)
    • Advanced Graphic Arts
    • Visual Media (Photoshop)
    • Graphic Arts Concepts
    • Photoshop Advanced Lessons
    • Visual Media (Microsoft Word)
    • Wood Concepts
  • ENG
    • English 10
      • English 10 Vocab
      • Domains of Writing
      • Mood Tone and Theme
      • Essays
      • English 10 Files
      • English Tools
      • AudioBooks
      • More Eng Vids
      • Figurative Language
      • Propaganda
      • English 10: Persuasive Essay and Research
      • E10 Mid Term
        • Mid Term Study Guide
        • Mid Term Study Guide Answers
    • English 11
      • Career Research
      • English 11 Vocab
      • English 11 Files
      • English 11 Audiobooks
      • English 11 Ideas
      • English 11 Videos
    • Essays
      • Fear Essay
      • Mobile Device Essay
      • Overload Essay
    • MLA
    • Independent Reading
      • IR Visual Guidelines
      • IR Essay Guidelines
  • Biz
    • Personal Finance
      • Simulation Tutorials
    • Computer Applications
    • Excel
  • Draft
    • Drafting Tutorials
    • Drafting (All)
    • Moyer’s Google Page

Excel: Bank Record & College Fund

1. Open a new excel file and save it as yourlastnamebankrecord.xls.

2. In Sheet 1, Create a spreadsheet that tracks lottery winning payments of $10,000 for 12 months.
3. Your spreadsheet should show 10 purchases per month.
4. Use the appropriate formula to calculate the balance each month.
5. There should be at least $500 remaining each month, and this leftover amount should be labeled “To College Fund”.

6. Complete the assignment for 12 months of deposits March 1, 2012 – February 1, 2012.

7. You may include up to 4 reoccurring payments each month. Ex. Rent, Cell Phone payment, Car payment, Car Insurance. This will make it easier as you will only need to come up with 6 new purchases each month.

8. In Sheet 2, Create a Spreadsheet called College Fund that adds the amount not spent each month.

9.  The formula to be placed in Cell E4 to find the balance is: =E3-D4 (then hit enter)

An example of the spreadsheet is below.
Use approximate widths for cells.

 

 

 

video platformvideo managementvideo solutionsvideo player

College Fund
video platform video management video solutions video player

 

Feb 12, 2012admin
Theater Job TemplatePowerPoint Basic Tutorial
Home Computer Applications Excel: Bank Record & College Fund
  You Might Also Like  
How To, News

Logan Mat Cutter: How to Use

How To Cut Left Handed on a Logan Mat Cutter Nov 5, 2018admin

Adobe Illustrator, Advanced Graphic Arts, News, Photoshop Advanced Lessons, Visual Media

Advanced Graphic Arts Projects

  Advanced Graphic Arts Projects All projects must incorporates evidence of multi-stage planning that includes sketching, drawing, finalization of and implementation of the plan. Original Logo Process SCREEN PRINTING –Halftones and Photographs [50 POINTS] –Multi-Diemntsional [200 POINTS] -Single Color Burlap/Canvas [50 POINTS] -Two Color T-Shirt (Registration) [200 POINTS] VINYL -Digital Vinyl [50 POINTS] -Two Color […]

News, Photo Collections, Photoshop Filters Lessons

Photographs for Color Division

These images to be used for Photoshop practice exercises only. Right click to copy this image to your clipboard. Next, open a new Photoshop canvas and leave the dimensions that Photoshop recommends, as Photoshop is aware of the size of the object on your clipboard. Paste the image into the new canvas. Mar 27, 2017admin

Advanced Graphic Arts, Photoshop Advanced Lessons

Foldable Package Design

Design a foldable package for a new product. On paper sketch the package details. Have the sketches approved before digital design begins. CLICK HERE TO DOWLOAD THE FOLDABLE PAGE FRONT CLICK HERE TO DOWLOAD THE FOLDABLE PAGE BACK Feb 5, 2018admin

Photoshop CS4 Tutorials

Photoshop Tutorial 2B: Drawing A Triangle

This video explains how to use the shift key to draw perfectly straight lines, with focus on drawing a triangle. YouTube Sep 15, 2012admin

Adobe Capture, Advanced Graphic Arts, News, Photoshop Advanced Lessons

Adobe Capture: Digitizing Artwork

Digitizing original logo artwork with Adobe Capture and Adobe Illustrator Nov 4, 2018admin

Advanced Graphic Arts

Your Product: Advanced Advertisement

Using the GA Template create a food advertisement modeled after the one below. You advertisement should include the labeled design elements and the following additional elements: -An image of your product -A Close up of your product -A Gradient -At least 1 solid color strip -An item description -A tagline -A Logo -Contact information -Logo […]

Keyboarding, PowerPoint

Power Point: Sharpen A Pencil

Create a 4 slide Power Point presentation that would explain how to sharpen a pencil. The Slideshow should have: A design (not white) A title slide with your name 3 “How to” slides 1 clipart 1 shape Save the presentation as “Pencil.ppt”. Mar 7, 2014admin

Photography
  • 31 Days to a Better Photo
  • Kyle Dempsey (Instagram)
  • SmugMug Films
  • Trout and Coffee (YouTube)
Photoshop Links
  • 1001 Fonts
  • Anderson Frye
  • Cathy Pierson Basics
  • distans exercises
  • Ms. Loke
  • Simple Photoshop Tools
  • TinaAvalon
Visual Media
  • Jerry Travis
  • Tonya Skinner
English Tubes
  • Alexander Clarkson
  • Bob Ahlersmeyer
  • Eric Odegaard
  • Tim Mcgee
Photoshop Tubes
  • Blue Lightning TV
  • Wes Robinson (DTown)
Technology Education Links
  • Technology Student (WATT)
  • Twin Valley Technology Education
Teacher Links
  • DRC
  • M-Socrative
  • Poll Everywhere
  • Take The Poll
More Teacher Links
  • E Reading Worksheets
  • English For Everyone
  • News ELA
  • Read Write Think
  • SAS
  • Teaches Pay Teachers
  • Thomas Jefferson Quotes
  • Web English Teacher
Design
  • Illustration Friday
  • Jim Howard CYHS
  • Jim Howard on Sk8Crit
  • Mr. Eagen
  • Mr. Ratkevich
  • Preston High
  • ReWired
  • Strathhaven
English Goods
  • 100 Persuasive Essay Topics
  • 101 Persuasive Essay Topics
  • 10th Grade Lesson PLans
  • BNW (Mrs. Berry's)
  • Brave New World (Spark Notes)
  • Brave New World Study Guide 1
  • English for Everyone
  • Jefferson English Links
  • Plot
  • SAT Vocabulary Lists
  • The Pearl PDF
  • The Race to Save Apollo 13
  • TWC Soft Rainns (.ppt)
  • TWC Soft Rains (pics)
  • Words of Sympathy
2018 © Education Monkey