TE063.2
From Brush Schools Wiki
Go back to 6th Grade Technology Standards Page
Contents |
Technology Standard 3.2 - Level 6
Use a variety of technology tools for data collection and analysis
Standard in Kid Friendly Language
Use a spreadsheet program (6th grade uses Microsoft Excel) to collect information and analyze it
Standard Unwrapped
KNOW
- Spreadsheet vocabulary
- column
- row
- cell
- cell address
- sheet
- Resize columns and rows
- Collect classroom data
- Enter information
- Navigate (tab, return, arrows, mouse click)
ABLE TO DO
- Create a basic spreadsheet
- Collect and organize data
- Create a basic graph
- Format and edit a spreadsheet and graph in Microsoft Excel
Instructional Strategies
Note: Excel is covered heavily in 7th and 8th grade, so this is a basic introduction
- Class will review the basics of Microsoft Excel together
- Set up the workspace (standard & formatting toolbar, formula bar, formatting palette, view)
- Practice navigating
- Begin the spreadsheet by explaining (what do they do, are they important) and creating column headings:
- Student Name
- Age
- Gender
- Game system
- Favorite game
- Collect data
- Talk about the importance of getting names, spelling, info. exactly right
- Each individual will enter in their own information
- Everyone will go everyone else's computer and enter their personal information
- Clean up the data so it all matches and is correct
- Format the spreadsheet
- Adjust columns for information
- Change font
- Change color scheme
- Add borders
- Rename sheet
- Sort the data
- alphabetize
- use the sort feature to do (one sort, double sort)
- Sort by game system
- Create a chart using the chart wizard
- Compile the system data into a smaller table at the bottom of the other chart
- Select the appropriate data
- Choose a chart that will fit the data being represented
- Run through all of the options
- Create chart as a new sheet
- Format the chart
- Change the y-axis scale
- Change the colors
- Add pictures of each game system
Assessment Strategies
- Teacher will grade the assignment as each student gets finished
- Since it was a class activity, grading will be based on whether or not a student has all of the required elements and the appearance is appealing and readable.
Resources
An example of a finished Game Survey
