Witty.ca - Mr. Rich's Professional Archives

  • Home
    • Lunch
    • Support
    • Intro
    • Cyber
  • Courses
    • Course Listing & Updates
    • DMS 2022-2023 >
      • Tech and Design Grade 6
      • Tech and Design Grade 7
      • Tech and Design Grade 8
    • -----------------------
    • DMS Archive 2021-2022 >
      • Tech and Design Grade 6 2021-22
      • Tech and Design Grade 7 2021-22
      • Tech and Design Grade 8 2021-22
    • HCS Archive 2015-2016 >
      • HCS'15 Media Studies 120
      • HCS'15 Nutrition for Healthy Living 120
      • HCS'15 Visual Art 9
      • HCS'16 Intro to Electronics 110 >
        • Purchasing a Computer in 2016 >
          • HCS'15 Visual Art 110/120
      • HCS'16 Housing & Design 120
      • HCS'16 Visual Arts 10
      • HCS Winter Decoration Ideas
    • HCS Archive 2014-2015 >
      • HCS'15 - Digital Production 12
      • HCS'15 - Graphic Art & Design 11
      • HCS'15 - Media Studies 12
      • HCS'15 - Visual Art 10
      • HCS'14 - BBT 10
      • HCS'14 - Info Tech 11/12
      • HCS'14 - Visual Art 9
      • HCS'14 - Visual Art 11/12
      • HCS Art Club
      • HCS Announcement Text
    • HCS Archive 2013-2014 >
      • HCS'14 - English 12
      • HCS'14 - Graphic Design 11
      • HCS'14 - Individual & Family Dynamics 12
      • HCS'14 - Info Tech 12
      • HCS'14 - Social Studies 8
    • Student Introduction Form
  • Tech Units
    • Safety & Citizenship >
      • Work Place Safety
      • Digital Safety & Citizenship
      • Digital Communication
      • Digital Rights & Responsibilities
      • Digital Etiquette
      • Digital Wellness
      • Digital Business
      • Digital Access
      • Digital Literacy
      • Digital Law
    • Scratch Coding >
      • Scratch Explained
      • Scratch 3 - Crossy Road 1
      • Scratch 3 - Crossy Road 2
      • Scratch 3 - Teacher Notes
      • OLD - Scratch 2 (Coding) >
        • Scratch 2 - Introduction to Coding
        • Scratch 2 - How to
        • Scratch 2 - Introduction
        • Scratch 2 - Frogger (p1)
        • Scratch 2 - Frogger (p2)
        • Scratch 2 - Frogger (p3)
        • Scratch 2 - Frogger (p4)
        • Scratch 2 - Frogger (p5)
        • Scratch 2 (Coding) >
          • Scratch 2 - A 2nd Project
          • Scratch 2 - Teacher Notes
          • Scratch 2 - Choosing another language
      • OLD - Scratch 1 (Coding) >
        • Scratch 1 (Coding)
        • Scratch (Scripts 1 & 2)
        • Scratch (Script 3)
        • Scratch (Frogger)
        • Scratch (Frogger 2)
        • Scratch (Frogger 3)
        • Scratch (Frogger 4)
        • Scratch Mini-Challenge 1
        • Scratch Final Project
        • Notes for Teachers >
          • Teaching Scratch
    • Graphic Design with Inkscape >
      • Graphic Design Overview
      • Inkscape Act.1
      • Inkscape Act.2
      • Inkscape Act.3
      • Inkscape Act.4
      • Inkscape Act.5
      • Inkscape Act.6
      • Inkscape Bonus Challenge
    • Photoshop with The GIMP >
      • GIMP Overview
      • GIMP Install & Setup
      • GIMP Activity 0
      • GIMP Activity 1
      • GIMP Activity 3
      • GIMP Activity 4a
      • GIMP Activity 4b
      • GIMP Activity 6b
      • GIMP Activity 6e/f
      • GIMP Final Project - Cereal-Box
      • GIMP Final Project - Magazine Cover >
        • HCS'16 Graphic Art & Design 110
      • GIMP Bonus Assignment
      • GIMP Marking Breakdown
      • Raster Graphics Explained
      • Old GIMP Activities >
        • GIMP Activity 2
        • GIMP Activity 6a
        • GIMP Activity 6c
        • GIMP Activity 6d
    • Excel
    • Audio / Video >
      • Sound (Audacity)
      • Video (One Minute PSA)
      • Make a Movie Trailer
      • Blender Video Editor - Test
    • Automotive >
      • Auto - Careers
      • Auto - Engines
      • Auto - 4-Stroke vs 2-Stroke
    • Coding - Teacher Start
    • Python (Coding) >
      • Python - CS 110 PD - July 2016
      • Python - CS 110 PD Part 2 (Projects)
      • Python - CS 110 PD Part 3 (GUI)
      • Install Python 3.5 + PyGame
    • Design (AutoCAD) >
      • Design Act. 1
      • Design Act. 2
      • Design Act. 3
      • Design Act. 4
      • Design Act. 5
      • Design Act. 5b and 5c
      • Design Act. 6
      • Design Act. 7
      • Design Act. 8
      • Design Act. 9
      • Design Act. 10
      • Design Act. 11
      • Design Act. 12
    • Design (Sketchup) >
      • Sketchup House Setup
    • Portable Apps >
      • Cam Studio
      • Virtual Dub
      • Scratch (and Zip File for Students)
      • TuxPaint (and Zip File for Students)
      • TuxTyping (and Zip File for Students)
      • Google Chrome
    • Project Management >
      • Intro to Project Mgmt.
      • Assignment for Project Management
    • Database >
      • Tasks Database
    • Final Projects and Exam Review >
      • Final Project - BBT 10 - 2015
      • Final Project - Digital Production 2015
      • Final Project - Media Studies 2015
      • Exam Review 2013
    • Cybersecurity
  • Art Units
    • Elements and Principles >
      • Elements of Art
      • Principles of Design
    • Photographic Composition
    • Visual Art 9
    • Graphic Art & Design 110 >
      • Colour Theory
      • Layout
      • Fonts and Type
    • Visual Art 110
    • Previous Box Projects - Visual Art 10
  • Other Units
    • Housing >
      • How to Design a House
    • Media Studies >
      • Media Studies Handouts
      • What is media? Why study media?
      • Film, Television and Video
      • Advertising, Marketing and You
      • Media and the Internet
      • Self-Study Project
    • Nutrition >
      • Recipes >
        • Black Bean Cake and Cupcake
  • Sports
    • Volleyball >
      • NMS Volleyball 2019
      • Volleyball Contact
      • (Old) Volleyball 2017
      • (Old) Volleyball Spring 2016
      • (Old) 2016 Tournament - MS Boys Volleyball
      • (Old) Volleyball Spring 2015
      • (Old) 2015 Tournament - MS Boys Volleyball
    • Soccer >
      • (Old) Soccer Fall 2015
    • Basketball
  • Blogs
    • Computer Science Blog
    • Personal Blog
  • Contact
  • About
    • About Mr. Rich
    • About Technology and Computer Science
  • Archives
    • Teaching Software >
      • Purchasing a Computer (notes) >
        • Purchasing a Computer
        • Computer Scenarios
        • Computer Presentation
        • PAC Test Instructions
        • PAC Peer Review
        • How to Submit Computer Comparisons
        • How to Submit Computer for Helen
      • Scratch 2 (Coding)
      • Scratch 1.4 (Programming)
      • ARCHIVED - GIMP (Raster Graphics)
      • ARCHIVED - Inkscape (Vector Graphics)
      • AutoCAD (2D Design)
      • Sketchup (3D Design) >
        • Google Sketchup (2011)
        • Google Sketchup (2012)
      • Excel vs Calc (Spreadsheet)
      • Cam Studio (Screen Capture Videos)
      • TuxPaint (for young kids)
      • TuxTyping (Typing Tutor)
    • Links >
      • Career Links in Fredericton
      • Job Hunting Tips
    • Presentations >
      • Scratch Workshop Oct 11, 2013
      • Scratch Workshop Sept 18, 2013
      • Math for French Immersion
    • Software That Is No More >
      • Setup (for an older version of Weebly) >
        • Setup - Day 1
        • How To Setup Your Weebly Pages
        • Marks (link to Canvas)
        • Web Portfolio
    • Previous Teaching >
      • Old Teacher's Logs >
        • Teacher's Log 2015-2016
        • Teacher's Log 2014-2015
        • Teaching Notes - Hartland 2014
        • BBT9 Teacher's Log (Apr-June2013)
        • BBT9 Teacher's Log (Jan - Apr 2013)
        • BBT9 2012
      • Sept2010-Jan2012 >
        • Old Home
        • Middle School >
          • Literacy
          • Social Studies 6
          • Social Studies 7 >
            • Online Test - Canada at Confederation
      • Jan2012-Nov2012 >
        • Book Blog >
          • Blog to Book
        • About Mr Rich
    • PD Sessions >
      • BBT9-10 Oct6 2016
      • BBT Teachers PD (Jan 2013)
      • Cyber-bullying (May 2013)
Mr. Rich's Excel Activities - Movie List Functions - 20,000 Trees Functions and Charts

EXCEL - Data, Functions and Charts

For this unit, students will use program called
Microsoft Excel

  • New Brunswick students can login to www.office.com and then download this software for free.
    ​(Windows, Mac and Android versions available)
  • To download for free, login with your student account (@nbss.nbed.nb.ca) and password. 
    - Then click on your initials (top right corner) and choose "View account"
    - Then click either "Office Apps" or "Manage Office Apps" or something similar.  Follow the instructions from there.

Spreadsheets and Data - Microsoft EXCEL

Picture
Spreadsheets are a simplified way to create, manage, sort and visualize data.

Microsoft Excel is the most common spreadsheet app used in business today.

Students will learn how to enter data about their favourite movies.  Students will use functions to determine averages, minimums, maximums and other similar calculations.

Students will also be given data, such as the 20,000 trees of our city.  Students will be asked to sort the data, determine the 10 most numerous trees, and use this data to make at least 3 different charts.

Microsoft Excel (microsoft.com)

Picture
Learn how to use Excel on the official Microsoft site. 

​There are lots of great videos on this site, but you probably want to have a purpose first and then go looking here for reference or to find solutions.


Similar Programs to Excel

While Microsoft Excel is the most used spreadsheet program in businesses world-wide, it is not the only one.

The first spreadsheet apps was VisiCalc for early Apple computers, followed quickly by Lotus 1-2-3 for other computers.

Many others copied this with Microsoft Excel being the first using a GUI (graphical user interface) and so quickly taking over the market.

CURRENT ALTERNATIVES for EXCEL
On Mac computers, Apple now has Numbers.
On Linux computers, Gnumeric is popular.
​A popular free program is LibreOffice and/or OpenOffice.org which also has Calc.
On the web, Google now has Sheets (although it doesn't do as much as the other programs).

For a large list of spreadsheet apps, check out this Wikipedia page.

Activities

Introduction (aka Hook)
 - Follow intro activity here (You can login as GUEST)

Activity #1 - Create a Movie List of 20 movies
 - Start with this blank template (Download now)
 - To see a sample movie list, click here.
 - Follow the instructions here (You can login as GUEST)

Activity #2 - Calculate, Sort and Chart the 20,000 Trees in Fredericton
 - Start with this data file
 - Follow the instructions here (You can login as GUEST)






Copyright © Graham Rich 2010-2023.   Site made using Weebly.com.