Learning Target: I can create aworksheet and an embedded chart in MS Excel.

Class Announcements:

  • If Eagle Tech Leaders sent their winter virtual project to me, I did get those submitted.
  • Eagle Tech Leaders should continue working on the Spring projects for state STLP.
  • All students (Computer Apps and STLP) should be thinking about their technology STEM fair projects. Most already know what they are doing but a few may need to come up with some ideas. Mr. Smith will give us a date for this event.

MONDAY 1/14/2013

Bellringer for digital journal (Create Bellwork12 Section in One Note Journal) Q: What is the first step in creating an effective worksheet? A: To make sure you understand what is required.

STUDENTS WILL READ IN DIGITAL TEXT AND COMPLETE PROJECT FOR:

  • Chapter Introduction
  • 1-1 Project - Worksheet with an Embedded Chart
  • 1-1a Overview
  • To Do To Start Excel
  • 1-2 Selecting a Cell
  • 1-3 Entering Text
  • To Do To Enter the Worksheet Titles
  • 1-3c AutoCorrect
  • To Do To Enter Column Titles
  • To Do To Enter Row Titles
  • 1-4 Entering Numbers
  • To Do To Enter Numbers
  • 1-5 Calculating a Sum
  • To Do To Sum a Column of Numbers
  • 1-6 Using the Fill Handle to Copy a Cell to Adjacent Cells
  • To Do To Copy a Cell to Adjacent Cells in a Row
  • To Do To Determine Multiple Totals at the Same Time
  • To Do To Save a Workbook

Also complete training in SAM: “MS Excel Training Textbook - Creating Worksheet and Embedded Chart (Numbers 1-10)”

TUESDAY 1/15/2013

Bellringer (Bellwork 12): The person requesting the worksheet should supply their requirements in a requirements document. What are the components of this document? (A requirements document includes a needs statement, a source of data, a summary of calculations, and any other special requirements for the worksheet, such as charting and Web support)

STUDENTS WILL READ AND COMPLETE FOLLOWING

  • 1-7 Formatting the Worksheet
  • 1-7a Font, Style, Size, and Color
  • To Do To Change a Cell Style
  • To Do To Change the Font
  • To Do To Bold a Cell
  • To Do To Increase the Font Size of a Cell Entry
  • To Do To Change the Font Color of a Cell Entry
  • To Do To Center Cell Entries Across Columns by Merging Cells
  • To Do To Format Column Titles and the Total Row
  • To Do To Format Numbers in the Worksheet
  • To Do To Adjust the Column Width
  • 1-8 Using the Name Box to Select a Cell
  • To Do To Use the Name Box to Select a Cell
  • 1-8c Other Ways to Select Cells
  • Also complete training in SAM: “MS Excel Training Textbook - Creating Worksheet and Embedded Chart (Numbers 11-20)”

WEDNESDAY 1/16/2013

Bellringer(Bellwork 12): Q: What is the function in Excel that adds all of the numbers in a range of cells?

A: SUM

  • STUDENTS WILL READ AND COMPLETE FOLLOWING
  • 1-9 Adding a Clustered Cylinder Chart to the Worksheet
  • To Do To Add a Clustered Cylinder Chart to the Worksheet
  • 1-10 Changing the Worksheet Names
  • To Do To Change the Worksheet Names
  • 1-11 Changing Document Properties
  • To Do To Change Document Properties
  • To Do To Save an Existing Workbook with the Same File Name
  • 1-12 Previewing and Printing a Worksheet
  • To Do To Preview and Print a Worksheet in Landscape Orientation
  • To Do To Quit Excel
  • 1-13 Starting Excel and Opening a Workbook
  • To Do To Start Excel
  • To Do To Open a Workbook from Excel
  • 1-14 AutoCalculate
  • To Do To Use the AutoCalculate Area to Determine a Maximum
  • 1-15 Correcting Errors
  • 1-15a Correcting Errors While You Are Typing Data into a Cell
  • 1-15b Correcting Errors After Entering Data into a Cell
  • 1-15c Undoing the Last Cell Entry
  • 1-15d Clearing a Cell or Range of Cells
  • 1-15e Clearing the Entire Worksheet
  • To Do To Quit Excel
  • Also complete training in SAM: “MS Excel Training Textbook - Creating Worksheet and Embedded Chart (Numbers 21-29)”

THURSDAY 1/17/2013

Bellringer (Bellwork 12): Paste a print screen in your journal that shows how you can use the name box in Excel to select a cell. (Should look

something like below).

  • Complete at least two practice tests at the end of the chapter in SAM to prepare for first quiz

FRIDAY 1/18/2013 – no bellwork today

Finish any uncomplete work this week and work on early finish activities

Finished worksheet will be for a grade.

Complete digital driver’s license

Figure 1–1 Finished Spreadsheet should look like the one below. This will be for a project grade.

APPROVED EARLY FINISH ACTIVITIES

(1) ACT Question of the Day

(2) Khan Academy or Study Island

(3) Math XL or Quizlet

(4) Wikipedia

(5) ACT Practice Test

(6) School Tube

(7) Typing practice: