Brown_B315
Ms. Brown: Instructional Technology
  • Welcome & Contact Info
    • Half Days & Delays
    • BHS Calendars &I Info 1819
  • SubPlans
  • Parent Connection
  • Guidance Newsletter
  • Contact Info & Syllabi
  • Grading & Rubrics
    • Checking Grades for Comp Apps
  • Lab Expectations
    • Make Up Work
    • Buy Back & Attendance Policy
    • Help Cards
    • Passes/Sign Out
    • Headset Protocol
    • Exit Procedures
  • AUP Contract
  • Typing.com
  • Student Portal Infinite Campus
  • Student Email
  • Bookmarks & Favorites
  • Guiding Question
  • Email: Themes & Signature
  • File Mgmt & Class Folders
  • Drag & Drop
  • Manage Files on OneDrive
  • Create Folder on One Drive
  • Download & Saving a File
  • Class 28
  • Class 29
  • Class 30
  • Class 31
  • Class 32
  • Class 33
  • Fire Drill & School Safety Protocol
  • School Safety Quick Guide
  • Computer Apps Projects
    • MS Word Projects 18-19 >
      • 1 Basics of Word Processing
      • 1 Intro to Word
      • 2 Tools of Word
      • 3 Highlight Tool Activity
      • 4 Synonym & Antonym Finder
      • 5 Synonym Finder Tool & Find Function
      • 6 Font Effect of MS Word
      • 7 Alignment & Formatting Tools
      • 8 Class Pres Poster
      • 9 Spell Checker / What Font?
      • 10 Bicycle Paragraph Formatting Font
      • 11 Intermediate Word Processing
      • 12 Letter Writing
      • 13 Create A Basic Table
      • 14 Business Memo
      • 15 MLA Style Report
      • 16 List of Menu Items
    • MS Excel Projects 18-19 >
      • E-1 Intro to Excel (Videos)
      • E-1b Undergrad Enrollment
      • E-2 Market Analysis
      • E-3 Employee Roster
      • E-4 Top Selling Products
      • E-5 Employee Prod Rpt
      • E-6 Sales Forecast
      • E7 Basic Graphing in Excel
      • E7 WPM Graph Survey
      • MS Excel Frameworks
    • Power Point Projects
    • Desktop Publishing
    • Office 365
    • ComApps Assessment Tool
    • RUBRIC Comp Apps
    • Access Projects
    • Getting to Know MS Word 2013
    • BlockStyle Letter MS Word Assessment
  • Keyboarding Fun & Info
    • Keyboarding Data Assessment
    • Ergonomics: Computers
    • Keyboarding Stretches
    • Keyboarding Rubric
    • Goals & Objectives of Keyboarding
    • Keyboarding Practice Sites
  • Best Practices of IT
  • Handbook, Cyberbullying, & Digital Literacy
  • About Computer Applications
    • Office Specialist Text
  • Professionalism for High School
  • Thank You Letter Project
  • Tech Literacy Frameworks
  • Technology Literacy: BPS
  • MSWord 2010
    • Microsoft Word Shortcut Tools/Tips
    • Microsoft Word Shortcut Keys & Commands
  • MSPublisher 2010
  • MSPowerPoint 2010
  • Graphs: Creating & Web-Based Generators
  • 7 Research & Reference
  • Learning Styles: How Am I Smart?
  • Approved Websites for School Use
  • PSAs to View
  • Career & College
  • Brain Teasers
  • Career Exploration
  • Getting a Job: Resume
  • Quotes & Memes
  • Cursive Learning
  • School Hacks & Resources
  • Educational Downtime Page
  • Clubs & Activities (BHS)
  • Personal Finance P3
  • Adding a Printer

Introduction to MS Excel
Using Ms Excel for Business


Unit Essential Question:

​How will understanding the fundamentals (basic skills) of MS Excel help me improve as a student?
​

Objective for Lessons Using MS Excel:

Students will become familiar with the fundamentals of MS Excel, its tools functions and how it can be used for classroom projects and in business.​

​Lesson: E-1 Undergrad Admissions

A Pre-Assessment Exercise


Objective for Undergraduate Enrollment Lesson:
Students will become familiar with the fundamentals of MS Excel, its tools functions and how it can be used for classroom projects and in business.​

Job Description:
​By editing this spreadsheet you are preparing a database of demographic data for the simulated business named College Concierge.  This information will appear on the company website.

This will assist prospective students in making their decision to attend the University of Learning.

Skills Covered in E-1b Undergraduate Enrollment
- Saving a Spreadsheet
- Entering Data in a spreadsheet
- Identifying Cell Addresses ( A1, B3, C7, H11)
- Formatting Cells

​Instructions:

1. Download the E-1b Undergraduate file below and save it to your Excel Folder (found in the Comp Apps Folder). 
​
2. Lesson directions appear on the Spreadsheet Document, there is no paper copy.

NOTE:  Directions are shaded in blue.
Picture
e1b_undergraduate_enrollment_v3.xlsx
File Size: 12 kb
File Type: xlsx
Download File

Done with the... 
E-1b  Undergraduate Enrollment Lesson ?

Make sure you completed the 
Take Away Sheet from last class.

Powered by Create your own unique website with customizable templates.