tcip groups for lesson group 1 business group 2 literacy group 3 math/science karaamandabarb...
TRANSCRIPT
TCIP Groups for LessonGroup 1Business
Group 2Literacy
Group 3Math/Science
Kara Amanda Barb
Mike Brittni Diane
Tim Frank Jan
Kelli Justine
Kristin
Lizzie
Background of our Lesson• 9-12 Computer Applications course• Semester elective course• Class Environment• Computer Lab, 1 workstation per student• Mixed-Ability Classroom
• Students are learning Microsoft Excel 2010• Students are working on the T-Shirt Fundraiser Project for their
school. Their responsibilities are:• T-shirt ordering• Collect money for T-shirts • Delivery of T-shirts
COMPUTER APPLICATIONSJuly 31, 2012Mrs. LaPlaunt and Mrs. Stewart
Computer Applications Agenda - Tuesday, July 31, 2012
1. Login to Computer2. Open MS Excel3. Download ‘Excel 2010 Examples’ from Wiki, save to your
folder4. Homework Review5. MS Excel - Sort, Filter, Formulas6. Group Project7. Homework
• Recheck group’s calculations• Share group findings• Finalize T-Shirt orders
Microsoft Excel 2010Term Definition
Ascending Sort Order where lowest values are on top
Cell Place on the spreadsheet, which can hold text, numbers or formulas
Custom List Dialog appears to select a list to sort the selected column by
Data Collection of unprocessed items, which can include text, numbers, images, audio, and video
Descending Sort Order where highest values are on top
Dialog Box A box on a computer screen that asks for user input or displays information
Drop Down List Valid entries to make data entry easier in Excel
Microsoft Excel 2010Term Definition
Filter Data Display only the rows that meet criteria
Group A mode in Excel that allows you to edit several worksheets at once
Insert Point A blinking vertical line that indicates where next character typed will display
Sort To arrange or to separate
Spreadsheet Refers to an Excel worksheet
Tab Includes commands that allow you to insert various objects
Worksheet Enter, calculate, manipulate, analyze, and store related data
Group TasksGroup 1 Group 2 Group 3
Determine which homeroom sold the most T-Shirts
Determine by color and size how many T-shirts to order.
Determine profit from T-shirt sales
• Sort spreadsheet first by homeroom
• First sort by color • Calculate sales tax and total cost of T-shirts
• Add the total T-shirts for each homeroom
• Then sort by size • Calculate difference between sales price and cost
• Use filters for color and size to see the difference
• Determine profit
• Total the number of T-shirts for each color and size