Computer Applications Week 11

1
Computer Applications Week 11

• Excel, Word, Email and Internet Research

2
Assignment List

• Excel Formatting- Making a Presentation
• Student Survey Questions
• Making your own survey
• Creating A Calendar
• (Unit Project) Student Survey Spreadsheet
• Student Survey Presentation

3
More Excel Formatting

• Today you will make a presentation that
  summarizes the ways of formatting cells in Excel
• Template for presentation is on desktop
• Quick Demonstration of Excel

4
Excel Formatting Cells Quiz
5
More Excel Formatting pt.2
6
Sorting Tool

• You know that Excel can store more information
  than a human.
• Did you know that it can sort through that
  information quickly and accurately?

7
Sorting Tool

• Select cells to sort first
• DATAgtSORT
• Dialog choose which column to sort by
• Ascending vs. Descending

8
Sorting Practice

• Open the file CA Excel Sorting Practice
• Use the sort tools to answer the questions

9
Day 2

• What is Excel really good at?
• Storing Lots of Data
• Making Beautiful (and Meaningful) Charts
• Making Calculations
• Sorting Lots of Data
• Making it all look so good!

10
What are people really good at?

• Learning
• Thinking
• Investigating
• Interpreting
• Collecting

11
Student Survey

• You will be conducting a survey of the students
  in this class.
• Work in groups of 3
• Excel Specialist
• Powerpoint Specialist
• Word Specialist

12
Survey- What is your goal?

• Your group should agree about what the goal of
  your survey should be
• To help market a product?
• To advise parents about the inner workings of
  teenagers?
• To advise the school about the opinions of the
  student body?
• What do you want to accomplish with the survey?
• Avoid overly personal topics.

13
What will the survey look like?

• Typed in Word- Formatted to Look Good
• 10 Multiple Choice Questions
• 5 Choices for each question
• Each Question should have only one answer for
  each person
• Deep or Important Questions preferable
• NO what is your favorite color?

14
Sample Question

• How much time do you spend on homework each
  night?
• 0 minutes
• 30 minutes or less
• Between 30 minutes and 1 hour
• Between 1 hour and 2 hours
• More than 2 hours

15
Agenda

• Get into groups- remember the 3 jobs
• Turn in paper with names, jobs and the purpose of
  your survey (15-20 minutes)
• Type your Questions in Word
• Make the 10 questions
• Rough Draft- Do not worry about color, etc.
• Put names and jobs of your group members
• Print Questions by the end of the period today!

16
Day 3
17
Creating A Calendar
18
Student Survey Spreadsheet
19
Student Survey Presentation