CMST 100G at the University of Maryland Global Campus teaches you to analyze numbers with spreadsheets and present them professionally.
UMGC describes it as an introduction to the use of electronic spreadsheets to analyze numerical data, including basic terminology, formats and other applications. The goal is to produce professional spreadsheets effectively for business and personal use, with hands-on practice in industry-standard software. It is worth 1 credit.
It is not open to students who have completed CMST 303, and you can receive credit for only one of CAPP 100G, CAPP 103, CMST 100G or CMST 103. The concept that trips most students up is cell referencing, which decides whether a copied formula still works.
Course at a Glance
| Item | Details |
|---|---|
| University | University of Maryland Global Campus (UMGC) |
| Course code | CMST 100G |
| Credits | 1 |
| Restrictions | Not open to students who have completed CMST 303 |
| Credit overlap | Only one of CAPP 100G, CAPP 103, CMST 100G or CMST 103 |
| Typical work | Hands-on workbook projects: budgets, analyses and charts |
What CMST 100G Covers
| Topic | What it means in practice |
|---|---|
| Terminology and formats | Cells, ranges, worksheets, number and date formats |
| Analyzing numerical data | Formulas, functions, sorting and filtering |
| Presenting results | Charts, conditional formatting and print layout |
| Business and personal applications | Budgets, invoices, grade books, sales summaries |
Key Concepts Explained
Relative and Absolute References
A relative reference such as B2 shifts when a formula is copied. An absolute reference such as $B$2 stays fixed. Mixing them correctly is the core spreadsheet skill.
Example: Sales are in B2:B10 and a tax rate is in E1. In C2, =B2*$E$1 copied down to C10 gives tax for every row. Written as =B2*E1, the copies point to E2, E3 and so on, which are empty, so the results are 0.
Functions
Functions such as SUM, AVERAGE, MIN, MAX, COUNT and IF do common tasks reliably. IF tests a condition and returns one value if true and another if false.
Example: =IF(B2>=1000,"Bonus","No bonus") labels each salesperson. =SUM(B2:B10) totals sales; =AVERAGE(B2:B10) gives the mean.
Choosing the Right Chart
Column or bar charts compare categories, line charts show change over time and pie charts show parts of a whole when there are only a few parts.
Building a Professional Workbook
Assignments often grade the workbook's structure as well as its answers. Good practice includes:
- Inputs (such as rates or assumptions) in clearly labeled cells, referenced by formulas.
- No typed results where a formula should be.
- Consistent number formats: currency, percentages, decimal places.
- Descriptive sheet names and a title on each sheet.
- Charts with titles, axis labels and legends where needed.
- Print settings checked: orientation, fit to page, headers.
Typical Assignments and How to Approach Them
| Assignment type | What it tests | How to approach it |
|---|---|---|
| Budget worksheet | Formulas and references | Keep assumptions in separate cells |
| Data summary | Functions, sorting, filtering | Check totals by a second method |
| Chart task | Visual presentation | Pick the chart type for the message |
| Formatted report | Professional output | Preview printing before submitting |
Sorting, Filtering and Conditional Formatting
Analyzing numerical data is the heart of CMST 100G, and three tools do much of the work. Sorting puts records in order; filtering hides records that do not meet criteria; conditional formatting highlights values that matter.
Example: In a monthly expense sheet, sort by amount to see the largest costs, filter to show only the "Travel" category, and apply a rule that colors any value over budget red. A reader spots problems in seconds.
Converting a range into a formatted table adds filter buttons, banded rows and formulas that extend automatically when you add data, which keeps larger workbooks tidy.
Where Students Get Stuck
- Error values. #DIV/0! means division by an empty or zero cell; #REF! means a referenced cell was deleted; #NAME? usually means a typo in a function name.
- Numbers stored as text. They will not sum; convert them.
- Copied formulas pointing to the wrong cells. Check absolute references.
- Misleading charts. Check axis scales and labels.
Study Tips for CMST 100G
- Press F2 on a cell to see which cells its formula uses.
- Use Show Formulas view to check a whole sheet quickly.
- Learn the F4 shortcut to toggle absolute references.
- Keep a small practice workbook of every function you learn.
How We Help with CMST 100G
Send the instructions, data, your workbook and any feedback. A tutor can explain formulas and references, trace an error with you, or prepare a model workbook for a comparable task. For heavier number work in later courses, see our statistics assignment help guide.
GradeEssays is independent of the University of Maryland Global Campus. Our help is for learning; the work you submit must be your own under UMGC's academic integrity policy.
Get Your CMST 100G Workbook Right
Share the instructions and your file. We explain formulas and charts with a clean model workbook.
Start My Spreadsheet HelpFree revisions · Full refund if late · Written from scratch for your order
Frequently Asked Questions
It is a 1-credit course.
No. UMGC states it is not open to students who have completed CMST 303.
You can receive credit for only one of CAPP 100G, CAPP 103, CMST 100G or CMST 103.
UMGC describes industry-standard spreadsheet software. Your section specifies the program.
It makes the row, column or both fixed, so the reference does not change when the formula is copied.
Yes. We trace the error and explain the correct formula.