Getting Started with Excel
An introduction
What?
The Office for Technology and Information Services maintains licensing for the Microsoft Office suite of applications, including Microsoft Word, PowerPoint, Skype for Business, and others. Our focus this month is Microsoft Excel. It is a spreadsheet program, which allows for a variety of calculations and visualizations to be applied to data. It also allows for sorting, grouping, and summarizing of various types of information.
Why?
Using basic data analysis is key to keeping up with student progress. By utilizing student performance data from both standardized and formative assessments, progress can be tracked and charted. Microsoft Excel provides the ability to calculate averages for grades that students earn on class assignments, calculate averages across all your classes, easily create lists and charts, or sort and re-sort lists in a variety of ways. This SMORE will provide you with:
- Information on the parts of a spreadsheet
- A basic overview of how to get data out of myStudent and into Excel
- How to perform some basic calculations on that data.
Below are some examples of data in spreadsheets. Click to enlarge.
Parts of a spreadsheet
A student report card example
A spreadsheet with a chart
How?
You can export data from myStudent and manipulate it to create lists and collect aggregate data using Microsoft Excel. Here's how...
For basic information on working in a spreadsheet, watch the short video below.
https://youtu.be/6mSKsaquTAM