








|
STEM Information Assurance, Information Security and Digital Forensics (IT)
2008 Howard County
Programming in Excel and PowerPoint |
 |
Challenges [Word ... PDF]
Prepare both a PowerPoint and an Excel project around the theme Cybersecurity. Both must be “interactive” and require user participation; they must both expect input (i.e., data entry, or a “click”) and return feedback to the user (such as a pop up that says great job).
PowerPoint
- At minimum 10 interlinked slides.
- Use animation of slide components
|
 |
 |
 |
 |
 |
|
|
|
|
Excel project
- Utilize 3-4 methods learned today
- Conditional formatting
- Data validation
- Logicals (IF, OR, AND, NOT)
- Formatting contents (numeric, string, date, significant digits)
- Formatting cells (color, size, borders)
- Hiding and locking cells
- etc.
|
 |
 |
|
|
|
|
|
|
|
|