G9 Tech Class #22

Today we will continue working with Spreadsheets:

Continuing last class' exercise 3. Sorting/Graphing/Percentages/Average: 

Part II:
Make your Percentage formula with a cell reference to the Max Grade cell using fixed cell reference (absolute range). Eg: 100


- Change the Max Grade in cell F2 to 200 and then change it again to 130 and see what happens to the results.
- Insert 2 columns between the columns named Grade and Percentage.
- Label those columns as Assignment/Test 2 and Grade 2.
- Complete these columns with assignments/test and grades information.

- Insert 1 column between the columns named Percentage and Max Grade.

- Label it: Average
- Under the Average column enter the formula to calculate the average between Grade and Grade 2.

- Insert three rows at the top
- Merge the rows and columns into one and add the title: "Students Grades for Spreadsheets class".

Part III:
- Select columns: Assignment/Test and Grade (including the header row)
- Insert a Bar Chart (What is this?)
- Place the graph/chart right under these columns Assignment/Test and Grade 
- Analyze the information graphed


- Repeat the same process using columns Assignment/Test 2 and Grade 2 (including the header row)
- select columns, insert bar chart, place graph under those columns, analyze the information graphed)




4. Mix and Match:
- Add a new Sheet and label it: 'My Challenge' 
- Create a challenge spreadsheet exercise including instructions, examples, etc for another group/student to solve. 
- It has to include the following design specifications:

1. use header rows
2. sequence numbering
3. sorting ascending and descending
4. insert columns and rows
5. column and row merge
6. format title (font, color, size, shading, etc)
7. three different formulas
8. one fixed cell reference
9. copy/cut and paste information
10. insert a graph (pie, bar, etc)
11. format the graph: change the Title: font & color, the colors of the bars/pie pieces, etc)

Type all the instructions and information on your "My Challenge" sheet. You can merge 5 columns by 5 rows for it.

G9 Tech Class #20

Today we will continue working on developing our spreadsheet skills solving other Spreadsheet chalenges :-)

Open the workbook spreadsheet that we were working on last class. It should have your previous challenges on Pages 'Students' List' and 'Balance'.


1. Sorting: Add a new Sheet to your spreadsheet. Name it 'Sorting'. We will sort columns and rows. - Create a table listing ten of favorite bands or musicians, the artist's latest album, and the number of copies sold. You can copy and paste information from your 'Balance' sheet based on your purchases if you want to.
- Select the whole list and copy & paste it twice leaving 2 blank rows between the sets of data.

For the first set the title row should be Orange. For the second set the title row should be Red and for the third set the title row should be light grey.

For the first set: Sort the list alphabetically by artist (descending)
For the second set: Sort the list by album (descending) , and 
For the third set: Sort it in numerical order by sales (descending)


- Copy every set again to the right of the set of data and sort the 3 lists in an ascending order.  
Leave a blank column in between. In all: you need to have 6 sets of data sorted in different ways.


- Add a Row above each set of Data (Careful: this will leave 3 rows between each set of data!)
Select the three consecutive cells and merge them into one big cell.
Add a Title above each set of data explaining what they are about and how they were sorted.
Eg: List sorted alphabetically (ascending) by Artist

Please format all the titles with different fonts, colors and shading.