Description
This lesson introduces students to how data is stored and organized in Microsoft Excel. Students explore cells, tabs, graphs and tables through an interactive Excel workbook.
Materials
Interactive Excel Workbook
(recommend downloading)
Slides
SC Digital Literacy Standards
Data and Analysis
3.DA.2.1 Discuss appropriate tools for collecting data.
3.DA.2.2 Represent data with bar graphs
3.DA.3.1 Interpret and analyze given data (i.e., tables).
Computing Systems
4.CS.2.2 Explore application software (e.g., word processor, spreadsheet, presentation software, web browser).
SC Math Standards
Data, Probability, and Statistical Reasoning
3.DPSR.1.1 Collect and organize categorical and numerical data based on observations, surveys, experiments, and investigations with whole number values using tables, scaled picture graphs, scaled bar graphs, or dot plots. Use titles and labels. Limit scales to multiples of 1, 2, 5, and 10.
3.DPSR.1.2 Solve one-step, real-world situations using whole number data represented in tables, scaled picture graphs, scaled bar graphs, or dot plots. Limit scales to multiples of 1, 2, 5, and 10.
4.DPSR.1.1 Collect and organize numerical and categorical data based on observations, investigations, surveys, and experiments using tables, scaled bar graphs, or dot plots. Use titles and labels. Scales to include whole numbers, halves, and fourths.